Designed for Excel 365, 2019, 2016, 2013, 2010
Our Microsoft Excel Advanced course is suitable for those with a sound working knowledge of Excel who wish to progress to the most complicated functions and features.
A working knowledge of Excel or our Excel Intermediate course.
At the end of this advanced Excel course you will have a complete understanding of the higher functions of Excel.
You will be able to perform the most advanced calculations and functions, manipulate data using pivot tables and ‘advanced’ analysis, record macros and integrate with other office applications.
– Creating named ranges
– Using named ranges in formulas
The IF function (recap)
Creating nested IF functions
AND and OR functions
Combining logical functions
The VLOOKUP function
The HLOOKUP function
Using data validation
– Setting criteria for entry of text, values and dates
– Creating a dropdown list
Using database functions
– Setting up criteria
Using the PivotTable Wizard
Using the PivotTable toolbar
Using Slicers to manipulate PivotTables
Using Goal Seek
Using the Solver add-in
Working with scenarios
– Creating and saving scenarios
– Viewing scenarios
Using the macro recorder
Viewing and editing macro VBA code