Microsoft Excel Advanced
Microsoft Excel Advanced
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.
- 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
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
-
Protecting your data
-
Functions
-
Range names
-
Data Validation
-
Getting and transforming data
-
Tables
-
Workbook linking
-
Data consolidation
-
Exporting data
-
PivotTable reports
-
PivotCharts
-
Macros
-
Circular references