Advanced MS Excel
Stop fighting spreadsheets
Free lesson
Preview this course
Watch an introductory lesson before you enroll. No account is required.
What you will be able to do
- Write lookup and dynamic array formulas with confidence
- Clean and reshape messy data with Power Query
- Build PivotTables and slicer-driven dashboards
- Automate repeat work with macros
- Model scenarios with What-If and Solver
About this course
Formulas, Power Query, PivotTables and dashboards. Turn the reports that take you three days into ones that take three minutes.
Curriculum
3 modules · 8 lessons · 14 hours · 1 free preview
Formula fluency 3 lessons
- References, ranges and names Watch preview 12:18
- XLOOKUP, INDEX/MATCH and friends 19:42
- Dynamic arrays 17:25
Data wrangling 2 lessons
- Power Query basics 21:56
- Merges, appends and unpivot 23:14
Analysis and reporting 3 lessons
- PivotTables that do not lie 20:37
- Charts and dashboards 24:09
- Macros and automation 18:51
Requirements
- Excel 2016 or later, or Microsoft 365.
Who this course is for
- Students preparing for data-heavy office roles
- Analysts who spend too long cleaning recurring reports
- Managers who need clear dashboards for better decisions
Projects you will build
Interactive KPI dashboard with PivotTables and slicers
Scenario model using What-If tools and Solver
Career paths this course supports
The course builds practical foundations for roles like these. Job outcomes still depend on your portfolio, practice and interview performance.
- MIS Executive
- Business Analyst
- Operations Analyst
Simple by design
How your learning journey works
Preview first, learn at your pace, and leave with work you can show.
Try the teaching style
Watch the free preview and scan every module before deciding.
Learn by building
Follow focused lessons, complete practical projects, and revisit any topic whenever needed.
Prove the skill
Finish the curriculum and claim a certificate with a publicly verifiable ID.
Learners also took
Beginner
Mastery in Digital Marketing
Build a practical digital marketing foundation across social strategy, audience targeting, SEO, Facebook Ads, promotio…
Lifetime
Beginner
Python 3 Bootcamp
A crisp, complete path through Python 3 — syntax, data structures, files, OOP, and the standard library — built around…
Lifetime
Beginner to Intermediate
Fullstack Web Development
Build and deploy a complete product: semantic HTML, modern CSS layout, JavaScript, a REST API, a database, auth, and a…
Lifetime