Microsoft Excel Learning Roadmap with
Practice Projects
Structured Phases, Practice Projects, and Source Links
📘 Phase 1: Foundations (Weeks 1-2)
Focus: Master basics (SUM, AVERAGE, MIN, MAX, COUNT, IF, formatting, charts).
Resource: [Excel Practice Online](https://excel-practice-online.com/?
utm_source=chatgpt.com)
Additional: [One Roadmap](https://oneroadmap.io/roadmap/excel?
utm_source=chatgpt.com) | [Datacamp Blog](https://www.datacamp.com/blog/learn-
excel?utm_source=chatgpt.com)
📗 Phase 2: Intermediate Skills (Weeks 3-5)
Focus: Lookup functions (VLOOKUP, INDEX/MATCH, IFERROR), text manipulation,
PivotTables, conditional formatting.
Resource: [Analythical Guide](https://analythical.com/blog/excel-skills-by-level?
utm_source=chatgpt.com)
Practice: [Wise Owl Excel
Exercises](https://www.wiseowl.co.uk/excel/exercises/standard/?
utm_source=chatgpt.com)
📙 Phase 3: Project-Based Practice (Weeks 6-9)
Focus: Apply skills in real-world projects (finance tracker, schedules, inventory,
dashboards).
Practice Projects List: [Zero to Mastery - Excel
Projects](https://zerotomastery.io/blog/excel-practice-projects/?
utm_source=chatgpt.com)
📕 Phase 4: Advanced Mastery (Weeks 10-12)
Focus: Power Query, Power Pivot (DAX), Macros/VBA, dashboards.
Resources:
[Excel Practice Online](https://excel-practice-online.com/?utm_source=chatgpt.com)
[Wise Owl Excel Exercises](https://www.wiseowl.co.uk/excel/exercises/standard/?
utm_source=chatgpt.com)
⭐ Guided Learning Resources
Coursera Guided Projects: [Excel Guided Projects](https://www.coursera.org/courses?
productTypeDescription=Guided+Projects&query=microsoft+excel&utm_source=chatg
pt.com)
W3Schools Practice: [Excel
Exercises](https://www.w3schools.com/excel/excel_exercises.php?
utm_source=chatgpt.com)