This Microsoft Excel Advanced Course is for people who already manage data well with Excel. They use it regularly and require advanced features to automate tasks. It is designed for Excel 2013, 2016, 2019 & 365.
Our Microsoft Excel Advanced course is suitable for those with a good working knowledge of Excel who wish to progress to the more complicated functions and features.
A good working knowledge of Microsoft Excel, or our Excel Intermediate course.
Using logical functions
The IF function (recap)
Creating nested IF functions
The IFS function
AND and OR functions
Combining logical functions
Working with Lookups
The VLOOKUP function
The HLOOKUP function
The XLOOKUP function (365)
INDEX & MATCH
Data Validation
Using data validation
Setting criteria for entry of text, values and dates
Creating a dropdown list
PivotTables and PivotCharts
Creating and rearranging PivotTables
Using the PivotTable toolbar
Creating PivotCharts
Using Slicers to manipulate PivotTables
Using analytical options
Using Goal Seek
Creating, saving and viewing scenarios
Creating single input data tables
Creating double input data tables
Projecting with data tables
Macros
Creating macros
Using the macro recorder
Viewing and editing macro VBA code
Send us a message & we will respond shortly
Enter your name, like you want it to appear on your Certificate
