Microsoft Excel Advanced


Microsoft Excel Advanced

Course Description

This course exposes several advanced features of Excel for What-if analysis, database analysis and how to build calculations using advanced functions as well as how to automate processes.


Performance Based Objectives

  • Build complex calculations with advanced functions
  • Link, export and consolidate data
  • Limit data entry and build complex models with Lookup functions
  • Analyse data with simple Tables, PivotTables and PivotCharts.
  • Create and modify Macros


Course prerequisites

Participants will need to have attended or be familiar with all the topics covered in the Microsoft Excel Intermediate course.

Course Features

  • Students
  • Max Students10
  • Duration1 day
  • Skill leveladvanced
  • LanguageEnglish
  • Re-take courseN/A