Overview

The Microsoft Advanced Excel Program is designed to prepare participants to become power users of Excel and being able to carry out more customised data processing and presentation. The areas covered will challenge participants to learn how to use advanced formula techniques and sophisticated lookups.

They will also learn to clean and prepare data for analysis and learn how to work with dates and financial functions. An in-depth look at spreadsheet design and documentation will prepare them for our big finale, where they will learn how to build professional dashboards in Excel.

Areas Covered

• Advanced Formulas and text manipulation
• Data, Power Query, Tables and Formatting
• Advanced Charting
• Data Analysis & Manipulation using PivotTables & Pivot Charts
• VBA & Macros
• Data Tables, Simulations & Solver
• Excel integration and Optimization