Advanced Excel
Lookups, pivot tables, data cleaning and dashboards — the Excel skills that get people hired.
📖 Course Overview
This course covers the Excel skills that job descriptions actually name: VLOOKUP/XLOOKUP, pivot tables, conditional logic, data cleaning and dashboard building. Each lesson tackles realistic business data problems.
By the end you will manipulate thousand-row datasets with confidence and produce summary dashboards that answer management questions in seconds.
Continue Your Learning Path
Learning compounds when courses connect. After finishing this course, these are the strongest next steps on MCQNepal:
- Data Analysis Fundamentals — turn Excel skill into analytical judgement
- Excel Formulas Reference Card — keep every formula from this course at hand
- Top 10 Excel Skills article — see how these skills appear in job interviews
What you'll learn
- Master lookup functions: VLOOKUP, XLOOKUP, INDEX-MATCH
- Summarise large datasets instantly with pivot tables
- Clean messy data with text functions and remove-duplicates tools
- Apply conditional aggregation: SUMIFS, COUNTIFS, AVERAGEIFS
- Build a live dashboard with charts, slicers and conditional formatting
🗂 Lessons
Advanced Excel — Practice Quiz — check your understanding before the final exam.
Take Practice QuizPass with 60%+ to earn your certificate. Unlocks after all lessons are completed.
🔒 Enroll and complete all lessons to unlock the final exam.Complete all lessons and pass the final exam to receive a verified PDF certificate with QR verification.