Advanced Excel Training

Who Is This Course For?

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.

Prerequisites

A working knowledge of Excel or our Excel Intermediate course.

Benefits

• 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.

Course Syllabus

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