Office 365 and Excel for Analysts

Excel

Video

Office 365 and Excel for Analysts

Speaker: Joseph McDaid, CA

  • Format

    Video

  • Level

    Intermediate

  • Duration

    50 min

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

Learning outcomes

  • Learn about Office 365, Office's subscription service
  • Learn about some new and existing analytics features provided by Microsoft Excel

£35.00 (CIMA members only)

£45.00

VAT calculated on checkout

Product information

Overview

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.

Who should take this course?

  • Controllers
  • CFOs
  • Finance Managers
  • Vice Presidents of Finance, Strategy, or FP&A
  • Others with responsibility for financial planning, Strategy and analysis for small, medium or large companies

Professional development

All learning resources available in the CGMA Store qualify for CPD for CIMA members.

Prerequisites:None
Programme level:Intermediate
Duration:50 min
Format:Video
Access:This is a digital product. You will have access to the content for a year after purchase date.

Return and refund policy

£35.00 (CIMA members only)

£45.00

VAT calculated on checkout

Speaker

  • Joseph McDaid, CA