Excel: Zero to Expert
A free 7-lesson course. Every lesson has a video walkthrough, the finished Excel workbook to download and a step-by-step written guide.
- Lessons7
- Videoabout 9 hours
- LevelBeginner
- PriceFree
About this course
Excel: Zero to Expert is a free beginner course with 7 video lessons (about 9 hours of video in total). It starts with “Learn Excel from Scratch: Full Beginner Course (Microsoft 365) | Excel 101” and finishes with “Excel Financial Functions Full Course: PMT, NPV, IRR & Loan Schedules | Excel 107”. Every lesson comes with the finished Excel workbook from the video, so you can run every step yourself.
It suits complete beginners: no prior coding is assumed, and each video explains every line.
Course outline
- Learn Excel from Scratch: Full Beginner Course (Microsoft 365) | Excel 101 – Sheet: Welcome Workbook: excelbasics.xlsx. Download it from this page to see the finished result, or start a new blank workbook and build…
- Excel Formulas & Functions Full Course: IF, SUMIFS, Text & Dates | Excel 102 – Sheet: Functions Workbook: formulasfunctions.xlsx. Download it from this page to see the finished result, or start a new blank workbook…
- Excel Tables, Data Cleaning, Sorting & Filtering (Full Course) | Excel 103 – Sheet: Good Data Workbook: tablescleaning.xlsx. Download it from this page to see the finished result, or start a new blank workbook and…
- Excel PivotTables, Charts & Dashboards: Full Course | Excel 104 – Sheet: Data Workbook: pivotsdashboards.xlsx. Download it from this page to see the finished result, or start a new blank workbook and…
- XLOOKUP, Dynamic Arrays & What-If Analysis in Excel (Full Course) | Excel 105 – Sheet: Lookups Workbook: lookupswhatif.xlsx. Download it from this page to see the finished result, or start a new blank workbook and…
- Advanced Excel: LET, LAMBDA & Modern Formulas (Full Course) | Excel 106 – Sheet: Intro Workbook: advancedexcel.xlsx. Download it from this page to see the finished result, or start a new blank workbook and build…
- Excel Financial Functions Full Course: PMT, NPV, IRR & Loan Schedules | Excel 107 – Sheet: TimeValue Workbook: excel107finance.xlsx. Download it from this page to see the finished result, or start a new blank workbook and…
All 7 lessons
1 h 19 minLearn Excel from Scratch: Full Beginner Course (Microsoft 365) | Excel 101
1 h 19 minExcel Formulas & Functions Full Course: IF, SUMIFS, Text & Dates | Excel 102
1 h 25 minExcel Tables, Data Cleaning, Sorting & Filtering (Full Course) | Excel 103
1 h 24 minExcel PivotTables, Charts & Dashboards: Full Course | Excel 104
1 h 29 minXLOOKUP, Dynamic Arrays & What-If Analysis in Excel (Full Course) | Excel 105
1 h 22 minAdvanced Excel: LET, LAMBDA & Modern Formulas (Full Course) | Excel 106
1 h 8 minExcel Financial Functions Full Course: PMT, NPV, IRR & Loan Schedules | Excel 107
Frequently asked questions
Is the Excel: Zero to Expert course free?
Yes. All 7 videos, notebooks are free, with no sign-up.
Do I need to install anything?
You need Microsoft Excel (Microsoft 365 or Excel 2021 for the newest functions). Excel for the web also works for most lessons.
How long does the Excel: Zero to Expert course take?
The videos add up to about 9 hours. Most learners take one to two lessons a day, so plan on 1 to 2 weeks if you code along.
What level is it?
Beginner. It suits complete beginners: no prior coding is assumed, and each video explains every line.