Data·10h
Advanced Excel
The spreadsheet skills that separate analysts from users.
FormulasPivot TablesPower QueryDashboardsAutomation
First module free · Premium+ unlocks the rest
About this course
Excel is still every business's second operating system. Level up from basic formulas to pivot tables, Power Query, dynamic arrays, and Office Scripts — the skills that show up on any analyst job description.
What you'll learn
- Master lookup/reference functions (XLOOKUP, INDEX/MATCH) and dynamic arrays.
- Build multi-sheet models with robust data validation.
- Clean and shape data at scale with Power Query.
- Design pivot tables and dashboards that update automatically.
- Automate repetitive tasks with Office Scripts or VBA.
- Audit and debug complex spreadsheets safely.
Roles this course opens up
Typical job titles that ask for this skill.
Financial Analyst
Operations Analyst
Business Analyst
Management Consultant
Data Analyst
How access works
Start any course for free. Upgrade when you're ready to unlock the rest.
Free
First module free
Start learning immediately. No credit card required. Test the course before committing.
Start freePremium+
Full course + every Academy tool
All modules, certificate on completion, career coach, interview prep and unlimited course generation — across every course.
See Premium+ plans