Free Excel Course: Basic to Advanced (TrumpExcel)
By TrumpExcel
- Course audio
- Course audio: English
- Level
- Beginner
- Length
- 26 lessons · 12.6 hours
What you'll be able to do
- Enter, format and manage data with tables and flash fill
- Write logical, lookup, text and date formulas
- Build charts, dynamic charts and pivot tables with slicers
- Protect workbooks and record a first macro
About this course
Sumit Bansal's free Excel course from TrumpExcel: 26 long lessons, about 12.5 hours, in a proper order. It begins with getting started, data entry and editing, formatting, cells and ranges, worksheets, tables, auto-fill and flash fill, and number formatting. Then come formula basics and lessons on logical, math, lookup and reference, statistical, text and date and time formulas, plus ten advanced formula examples. The last third covers named ranges, data validation, sorting and filtering, conditional formatting, charts including advanced and dynamic charts, pivot tables with slicers, protecting workbooks and an introduction to macros. One of the most complete free Excel courses on YouTube.
Syllabus
26 lessons · 12:34:48 in total
- 1Getting Started with Excel | Excel For Beginners | FREE Excel Course22:17
- 2[FREE Excel Course] Lesson 2 - Data Entry, Editing, and Number Formatting21:03
- 3[FREE EXCEL COURSE] Lesson 3 - Data Formatting in Excel25:02
- 4[FREE EXCEL COURSE] Lesson 4 - Working with Cells and Ranges33:39
- 5[FREE EXCEL COURSE] Lesson 5 - Managing Worksheets in Excel16:45
- 6[FREE EXCEL COURSE] Lesson 6 - Excel Tables Overview21:17
- 7[FREE EXCEL COURSE] Lesson 7 - Auto-fill, Custom Lists, and Flash Fill13:53
- 8[FREE EXCEL COURSE] Lesson 8 - Number Formatting in Excel26:28
- 9[FREE Excel Course] Lesson 9 - Excel Formula Basics26:39
- 10[FREE Excel Course] Lesson 10 - Logical Formulas in Excel23:27
- 11[FREE Excel Course] Lesson 11 - Math Formulas in Excel33:36
- 12[FREE Excel Course] Lesson 12 - Lookup and Reference Formulas in Excel46:57
- 13Stats Formulas in Excel - Explained with Examples41:37
- 14[FREE Excel Course] Lesson 14 - Text Formulas in Excel32:14
- 15[FREE EXCEL COURSE] Lesson 15 - Date & Time Formulas in Excel40:53
- 1610 Advanced Excel Formula Examples | FREE Excel Course45:09
- 17Creating Named Ranges in Excel | Dynamic Named Range in Excel | FREE Excel Course22:43
- 18Data Validation in Excel | Drop-down lists | FREE Excel Course31:06
- 19Data Sorting & Filtering in Excel (Basic + Advanced) | FREE Excel Course16:37
- 20Excel Conditional Formatting (Overview + Advanced Examples)25:18
- 21Introduction to Excel Charting | Excel Charts for Beginners35:49
- 2210 Advanced Excel Charts and Graphs (Creating from Scratch) | FREE Excel Course51:07
- 23Creating Dynamic Charts in Excel (Using Drop-down List and Scroll Bar) | FREE Excel Course27:24
- 24Excel Pivot Table (Intro, Formatting, Grouping, Slicers, Calculated Fields) | FREE Excel Course47:37
- 25Protecting Worksheets / Workbooks in Excel | Lock Worksheets in Excel | FREE Excel Course9:17
- 26Introduction to Excel Macros (For Excel VBA Beginners) | FREE Excel Course16:54
What to take next
Videos by TrumpExcel, played from their official YouTube channel. Subscribe on YouTube
Official upload by the teacher or institution on their own channel, shown with YouTube's embedded player.
Lessons listed from the official YouTube playlist. Full playlist on YouTube
Lessons last checked Oct 2026. Course summary and lesson structure by Sabaq.
Report a problem or a rights request