Zero-to-Expert Tutorial

Excel and VBA Complete Learning Path

Microsoft Excel is a spreadsheet and analytical platform, while VBA extends it with programmable automation for repeatable business workflows.

  • Starts from zero
  • 84 lessons
  • 15 modules
  • 6 projects
Start Tutorial
Begin From ZeroNo prior subject knowledge is assumed.
Ordered ModulesFollow the curriculum in order without skipping prerequisites.
Complete ProjectsPlan, build, integrate, test, and refine real outcomes.
Direct Lesson AccessEvery curriculum item links directly to its lesson.
About this tutorial

Learn Excel and VBA from the beginning

Microsoft Excel is a spreadsheet and analytical platform, while VBA extends it with programmable automation for repeatable business workflows.

This continuous 84-lesson curriculum starts from zero, introduces every required tool and concept in order, and progresses through Excel Basics, Workflow, Excel Foundations, Formulas and Functions, Data Analysis and PivotTables, Power Query before capstone work.

Who this tutorial is for

Spreadsheet beginners, analysts, finance and operations users, and developers building models, dashboards, queries, and automated workbooks.

Prerequisites

No previous Excel and VBA experience is required. The opening curriculum begins with “What Excel VBA Power Query and Power Pivot Are” and introduces setup, accounts, software, terminology, and prerequisite checkpoints before advanced work.

Master curriculum

Complete Excel and VBA Tutorial

Follow all 84 lessons in exact curriculum order. Open any lesson directly from the curriculum below and follow the modules in order.

Module 1

Start Here

2 lessons · Start from Zero

Module 2

Setup

1 lessons · Start from Zero

Module 3

Excel Basics

5 lessons · Start from Zero

Module 4

VBA Setup

3 lessons · Start from Zero

ADVERTISEMENT
Module 5

Workflow

1 lessons · Beginner

Module 6

Excel Foundations

5 lessons · Beginner

Module 7

Formulas and Functions

6 lessons · Beginner

Module 8

Data Analysis and PivotTables

6 lessons · Intermediate

Module 9

Power Query

6 lessons · Intermediate

Module 10

Power Pivot and Data Model

6 lessons · Intermediate

ADVERTISEMENT
Module 11

VBA Foundations

6 lessons · Advanced

Module 12

Advanced VBA Automation

6 lessons · Advanced

Module 13

Professional Excel Automation

6 lessons · Professional

Module 14

Projects and Capstones

24 lessons · Capstone

Project 1 · plan

Project: Understand Requirements and Plan Financial model workbook

Capstone · Project Lesson

CapstoneLesson
Project 1 · build

Project: Build the Foundation of Financial model workbook

Capstone · Project Lesson

CapstoneLesson
Project 1 · integrate

Project: Complete and Integrate Financial model workbook

Capstone · Project Lesson

CapstoneLesson
Project 1 · test

Project: Test Debug Refine and Finish Financial model workbook

Capstone · Project Lesson

CapstoneLesson
Project 2 · plan

Project: Understand Requirements and Plan Interactive PivotTable dashboard

Capstone · Project Lesson

CapstoneLesson
Project 2 · build

Project: Build the Foundation of Interactive PivotTable dashboard

Capstone · Project Lesson

CapstoneLesson
Project 2 · integrate

Project: Complete and Integrate Interactive PivotTable dashboard

Capstone · Project Lesson

CapstoneLesson
Project 2 · test

Project: Test Debug Refine and Finish Interactive PivotTable dashboard

Capstone · Project Lesson

CapstoneLesson
Project 3 · plan

Project: Understand Requirements and Plan Power Query reporting pipeline

Capstone · Project Lesson

CapstoneLesson
Project 3 · build

Project: Build the Foundation of Power Query reporting pipeline

Capstone · Project Lesson

CapstoneLesson
Project 3 · integrate

Project: Complete and Integrate Power Query reporting pipeline

Capstone · Project Lesson

CapstoneLesson
Project 3 · test

Project: Test Debug Refine and Finish Power Query reporting pipeline

Capstone · Project Lesson

CapstoneLesson
Project 4 · plan

Project: Understand Requirements and Plan Power Pivot KPI model

Capstone · Project Lesson

CapstoneLesson
Project 4 · build

Project: Build the Foundation of Power Pivot KPI model

Capstone · Project Lesson

CapstoneLesson
Project 4 · integrate

Project: Complete and Integrate Power Pivot KPI model

Capstone · Project Lesson

CapstoneLesson
Project 4 · test

Project: Test Debug Refine and Finish Power Pivot KPI model

Capstone · Project Lesson

CapstoneLesson
Project 5 · plan

Project: Understand Requirements and Plan VBA data-entry automation

Capstone · Project Lesson

CapstoneLesson
Project 5 · build

Project: Build the Foundation of VBA data-entry automation

Capstone · Project Lesson

CapstoneLesson
Project 5 · integrate

Project: Complete and Integrate VBA data-entry automation

Capstone · Project Lesson

CapstoneLesson
Project 5 · test

Project: Test Debug Refine and Finish VBA data-entry automation

Capstone · Project Lesson

CapstoneLesson
Project 6 · plan

Project: Understand Requirements and Plan End-to-end automated management reporting workbook

Capstone · Project Lesson

CapstoneLesson
Project 6 · build

Project: Build the Foundation of End-to-end automated management reporting workbook

Capstone · Project Lesson

CapstoneLesson
Project 6 · integrate

Project: Complete and Integrate End-to-end automated management reporting workbook

Capstone · Project Lesson

CapstoneLesson
Project 6 · test

Project: Test Debug Refine and Finish End-to-end automated management reporting workbook

Capstone · Project Lesson

CapstoneLesson
Module 15

Finish and Continue

1 lessons · Completion

Ready to begin?

Start at lesson 1 and follow the curriculum in sequence.

Start Tutorial

Stay Updated

Get the latest tutorials, tips and resources delivered to your inbox.

ADVERTISEMENT