Microsoft Excel 2016 Advanced
Course

Microsoft Excel 2016 Advanced

This course teaches you how to master the advanced functions of Excel 2016. You'll learn how to apply a range of Excel formulas and functions to advanced financial data to produce sophisticated financial analyses and visualisations. The course is designed for professionals in data science, finance, and accounting, who already have comprehensive Excel knowledge but are ready to take their skills to the next level.

Simon Sez IT
Updated May 15, 2019

Course Overview

Get beyond the basics and supercharge your Excel 2016 capabilities. With this 9-hour, expert-led video training course, you’ll gain an in-depth understanding of the most business useful advanced features of Microsoft Excel that delve into high-level consolidation, analysis and reporting of financial information.

Target Audience

Data Analysts, Data Scientists, Statisticians, people in Financial Services, Accountancy, Audit, Tax 

Learning Objectives

In this course you will learn:

  • How to create amazing looking charts and graphs
  • Complex Time and Date functions
  • VLOOKUP, HLOOKUP
  • Statistical functions
  • Using Excel for forecasting
  • Connecting to external databases including Access and live web sources
  • Advanced Tables, including Styles and References
  • Advanced PivotTable uses including using filters, slicers and Pivot Charts
  • Goal Seek, Scenario Manager and Solver
  • Advanced charts such as Stock charts, Bubble Charts, Radar Charts and Sparklines
  • Using the Excel web app