1200 – Dataplexa Excel Portal

Excel Course Index

2025 Edition

Complete 2025 Excel (Microsoft 365) syllabus — dynamic arrays, XLOOKUP, TEXTSPLIT, Power Query, Power Pivot, dashboards, automation, data cleaning, and full BI workflows.

Open Excel Course Back to Learning Hub

I. Excel Basics & Fundamentals

1. Introduction to Excel (2025) 2. Excel Interface 3. Ribbons & Tabs 4. Workbooks & Sheets 5. Cells & Ranges 6. Basic Formatting 7. Number Formatting 8. Sort & Filter 9. Find & Replace 10. Basic Formulas

II. Intermediate Excel (Formulas + Functions)

11. Text Functions 12. Date Functions 13. Logical Functions 14. Math Functions 15. Lookup Functions 16. XLOOKUP (New) 17. XMATCH 18. Dynamic Arrays 19. TEXTSPLIT 20. TEXTBEFORE / TEXTAFTER

III. Advanced Excel Functions (2025 Edition)

21. FILTER Function 22. SORT Function 23. UNIQUE Function 24. VSTACK 25. HSTACK

IV. Power Query (Modern Data Cleaning)

26. Power Query Introduction 27. Transforming Data 28. Data Cleaning 29. Merging Tables 30. Automation in Power Query

V. Power Pivot + DAX (BI Level)

31. Power Pivot Basics 32. Data Models 33. DAX Basics 34. DAX Advanced 35. Measures

VI. Excel Dashboards

36. Dashboard Basics 37. Charts 38. Slicers 39. PivotCharts 40. Full Dashboard Project

VII. Automation & Office Scripts (2025 Excel)

41. Office Scripts Intro 42. Recording Scripts 43. Editing Scripts 44. Automating Tasks 45. Advanced Scripting

VIII. Final Excel Projects

46. Data Cleaning Project 47. Sales Dashboard 48. HR Dashboard 49. Finance Dashboard 50. Excel Capstone Project