Free ebook
Free ebook: Conditional Formatting Mastery
Everything you need to know about Excel's conditional formatting: highlight rules, top/bottom rules, data bars, color scales, icon sets, formula-based rules, managing and debugging rules, and real-world use cases. Hands-on examples throughout.
Get the ebookFree tools
Practice with free browser tools
Formula builder, formula explainer, CSV cleaner, and 7 more — no upload, no sign-up. Try what you learn in the lessons.
Browse free tools=COURSE.PATH
Excel Formulas & Functions
Course-style lessons for formulas, lookup functions, logical tests, text cleanup, dates, and dynamic arrays.
What this path is for
Use this page when you want a guided route through public Excel lessons without searching from scratch. Preview a tutor, open the full lesson on YouTube, and return here for the next option.
Learn
Read and write formulas with clean references and correct operators.
Learn
Use lookup, logical, text, date, and dynamic array functions.
Learn
Troubleshoot formula errors and choose the right function for the task.
Suggested course flow
- 01Excel Introduction - Learn Excel BasicsLeila Gharani - preview available
- 02Excel Formulas + FunctionsChandoo - preview available
- 03Learn ALL the useful Excel concepts in 40 mins - Tables, Formulas, Pivots & ChartsChandoo - preview available
- 04XLOOKUP + 10 TricksChandoo - preview available
- 05IF formula and 5 Advanced TipsChandoo - preview available
- 06Dynamic Array Formulas - MasterclassChandoo - preview available
Previewable lessons
Showing the first 36 of 213 curated public lessons for this path.
01
02
03
Learn ALL the useful Excel concepts in 40 mins - Tables, Formulas, Pivots & Charts
Chandoo
Open on YouTube (opens in a new tab)04
05
06
07
Excel VLOOKUP: Basics of VLOOKUP and HLOOKUP explained with examples
Leila Gharani
Open on YouTube (opens in a new tab)08
Basic Excel Formulas and Functions You NEED to KNOW!
Leila Gharani
Open on YouTube (opens in a new tab)09
10
11
Excel Formulas and Functions - Tutorial for Beginners
Kevin Stratvert
Open on YouTube (opens in a new tab)12
13
Excel IF Formula: Simple to Advanced (multiple criteria, nested IF, AND, OR functions)
Leila Gharani
Open on YouTube (opens in a new tab)14
15
16
17
18
19
20
Excel Formulas and Functions Tutorial - Full Course (2026)
Excel Champion
Open on YouTube (opens in a new tab)21
22
23
24
Advanced Excel Formulas (IF, IFS, INDEX, MATCH, SUMPRODUCT, XLOOKUP, OFFSET, CHOOSE)
Simon Sez IT
Open on YouTube (opens in a new tab)25
How to Lock Cells in Excel to Protect your Formulas & Only Allow Input where Needed
Leila Gharani
Open on YouTube (opens in a new tab)26
Using the Excel FILTER Function to Create Dynamic Filters
Technology for Teachers and Students
Open on YouTube (opens in a new tab)27
Excel 365 Basics IF Function & Logical Tests IFS, IFNA, OR, AND, NOT, ISNUMBER Functions More
excelisfun
Open on YouTube (opens in a new tab)28
29
30
How to use excel text functions proper() text() textjoin() mid() right() left() and many more
The Knowledge Junction
Open on YouTube (opens in a new tab)31
Top 10 Most Important Excel Formulas - Made Easy!
The Organic Chemistry Tutor
Open on YouTube (opens in a new tab)32
The Ultimate LOOKUP Guide (XLOOKUP, VLOOKUP, HLOOKUP and more)
Kenji Explains
Open on YouTube (opens in a new tab)33
How an Excel Pro Uses XLOOKUP (R.I.P. VLOOKUP & INDEX MATCH)
Leila Gharani
Open on YouTube (opens in a new tab)34
How To Use the new Excel TEXTBEFORE & TEXTAFTER Functions to Save Time on Your Next Project
Leila Gharani
Open on YouTube (opens in a new tab)35
Learn about the *NEW* Dynamic Array Functions in Excel (Filter, Sort, Unique etc.)
Chandoo
Open on YouTube (opens in a new tab)36
Excel IF function trick ( In 20 seconds)| Pass/Fail
TutorialsPoint
Open on YouTube (opens in a new tab)Sources we reference — not partners
26 places we cite for accuracy. We link to them; none has reviewed, endorsed, or collaborated on this site.
Official documentation
Educators and channels
- Chandoo (opens in a new tab)
ExcelJet (opens in a new tab)- MrExcel (opens in a new tab)
- Contextures (opens in a new tab)
MyOnlineTrainingHub (opens in a new tab)
XelPlus (opens in a new tab)
Excel Campus (opens in a new tab)
Wise Owl (opens in a new tab)- Simon Sez IT (opens in a new tab)
Teacher's Tech (opens in a new tab)
YouTube (opens in a new tab)- Edureka (opens in a new tab)
Course platforms
