Office & Productivity
Classroom
Advanced Excel Course
Clean business data, automate repeatable analysis and create useful Excel dashboards.
AT A GLANCE
Course highlights
LevelIntermediate
Duration6 Weeks
Learning formatClassroom
THE OVERVIEW
About this course
Strengthen spreadsheet skills with lookup formulas, dynamic arrays, PivotTables and Power Query. Use practical reporting exercises to build refreshable dashboards and check formulas for accuracy.
BUILD YOUR SKILLS
What you will learn
- Combine lookup, logical and dynamic array formulas.
- Clean and reshape imported data with Power Query.
- Create refreshable PivotTable dashboards with consistent checks.
YOUR TOOLKIT
Tools & technologies
- Microsoft Excel
- Power Query
- PivotTables
BEFORE YOU BEGIN
Who should join?
Ability to enter data, format worksheets and write basic Excel formulas.
SKILLS YOU BUILD
What you will learn
- Combine lookup, logical and dynamic array formulas.
- Clean and reshape imported data with Power Query.
- Create refreshable PivotTable dashboards with consistent checks.
TAKE THE NEXT STEP
Ready to explore Advanced Excel Course?
Speak with our counsellors and find the right learning path for you.