Description
Advanced Excel is the difference between a spreadsheet that reports and one that answers questions. This course covers the advanced feature set of Excel 365 in short, focused lessons: complex formulas, advanced lookups, data consolidation and the tools that automate repetitive work.
What you will learn
- Advanced lookup functions and when each is appropriate
- Complex and nested formulas, and how to trace and audit them
- Consolidating and importing data from multiple sources
- PivotTables, charts and dynamic reporting
- Time-saving tools for repetitive analysis
Who it is for
Experienced Excel users ready to work at a genuinely advanced level.
What is included
- Approximately 8 hours of self-paced online learning
- 13 structured units across 50 focused lessons
- Practical exercises throughout
- Certificate of completion
- 4 months access from the date of purchase
Format: 100% online and self-paced. Start immediately after purchase and learn at your own pace, on any device.






















