Excel Advanced – Tutor Led
January 22, 2027
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.
