Excel Course Index — Dataplexa

Excel
Course Index

2025 Edition

50 Lessons · 8 Levels

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

Start Course → ← Back to Learning Hub

50Lessons

8Levels

4Projects

2025Edition

Level I Excel Basics & Fundamentals Lessons 1–10

Introduction to Excel (2025)

Excel Interface

Workbooks & Sheets

Basic Formatting

Number Formatting

Level II Intermediate Excel (Formulas + Functions) Lessons 11–20

Logical Functions

Lookup Functions

TEXTBEFORE / TEXTAFTER

Level III Advanced Excel Functions (2025 Edition) Lessons 21–25

FILTER Function

UNIQUE Function

Level IV Power Query (Modern Data Cleaning) Lessons 26–30

Power Query Introduction

Transforming Data

Automation in Power Query

Level V Power Pivot + DAX (BI Level) Lessons 31–35

Power Pivot Basics

Level VI Excel Dashboards Lessons 36–40

Dashboard Basics

Full Dashboard Project

Level VII Automation & Office Scripts (2025 Excel) Lessons 41–45

Office Scripts Intro

Recording Scripts

Editing Scripts

Automating Tasks

Advanced Scripting

Level VIII Final Excel Projects Lessons 46–50

Data Cleaning Project

Sales Dashboard

Finance Dashboard

Excel Capstone Project

▶ Ready to Start?

Excel Course Index — 2025 Edition

Start Course → ← Back to Learning Hub