Office & Productivity
Classroom
Advanced Excel
Clean business data, automate repeatable analysis and create useful Excel dashboards.
Level
Intermediate
Duration
6 Weeks
Learning format
Classroom
ABOUT THE COURSE
About Advanced Excel
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.
UNDERSTAND THE FIELD
What is Advanced Excel?
TOOLS & TECHNOLOGIES
Tools you will work with
- Microsoft Excel
- Power Query
- PivotTables
WHAT YOU WILL LEARN
Learning outcomes
- Combine lookup, logical and dynamic array formulas.
- Clean and reshape imported data with Power Query.
- Create refreshable PivotTable dashboards with consistent checks.
WHO SHOULD JOIN
Is this course right for you?
Prerequisites / eligibility
Ability to enter data, format worksheets and write basic Excel formulas.
TAKE THE NEXT STEP
Ready to explore Advanced Excel?
Speak with our counsellors and find the right learning path for you.