Excel Advanced – Tutor Led
2026-07-01 | Edinburgh, 4 Queen Street, Edinburgh, EH2 1JE, United Kingdom
Duration: 1 Day
We can deliver onsite at your workplace of via virtual classrooms if preferred.
For individuals who are already using Excel to an advanced level. This course will teach you how to use Excel to analyse, collaborate and validate. These tools are extremely useful for auditing and streamlining your workflow.

What you will learn:

Macros
Additional Items

Editing & Deleting Macros
IfAnd/ IfOr Formula

Recording Macros
IfNa Formula

Custom Ribbon
Convert to Table

Screenshots

Review Data
Removing Duplicates

Tracking Changes
Filter Timeline

Auditing Tools
IfError

Watch Window
HLookups

Restricting Data Area
Sparklines

Pivot Tables

Utilities
Flash Fill

Goal Seek

Data Consolidation

Power View Reports

Create Senarios

What – If Analysis

Drawing Diagrams

Recommended Pivot Tables

Duration: 1 Day
We can deliver onsite at your workplace of via virtual classrooms if preferred.
