Digital Office SkillsAdvancedOnline

Microsoft Excel Advanced

Automate and analyse with Power Query, dashboards and advanced Excel functions.

About this program

The advanced Excel course for analysts and managers. You clean and combine data with Power Query, build dynamic dashboards, apply advanced formulas and what-if analysis, and automate repetitive work with macros.

What you'll walk away with

  • Clean and combine data sources with Power Query
  • Build interactive dashboards with pivot tables and slicers
  • Apply advanced formulas, arrays and what-if analysis
  • Automate repetitive tasks with simple macros