Office 365 and Excel for Analysts

In this session, attendees will learn about some new and existing analytics features provided by Microsoft Excel.

Topics discussed:

• An overview of Office 365, Office’s subscription service that provides ongoing new value and high impact for your work and business

• Examples of new Office 365 capabilities released since the launch of Office 2016 across the Office apps

• Identifying the best Office plan options for your analytics needs at work and at home

• New advanced chart types to help visualise your data

• Data/Power Query – Importing and cleaning up large amounts of data into Excel from a wide variety of sources including SQL, CSV, Hadoop and others

• Forecasting – Using the one-click forecasting feature to make predictions on your data

• Machine learning plug-ins – Fostering sentiment analysis and other ML scenarios by seamlessly integrating with Azure ML Studio

  This is an online, video course; it is also available as part of the CGMA Essentials.