Curriculum
- 8 Sections
- 78 Lessons
- 10 Weeks
Expand all sectionsCollapse all sections
- The Foundation – Navigation & Workspace Setup8
- 1.1How To Master Microsoft Excel and AI From Scratch3 Minutes
- 1.2Master The Excel Interface Before You Start8 Minutes
- 1.3Setup Your Excel Workspace For Speed9 Minutes
- 1.4Navigate Excel Worksheets Like A Pro8 Minutes
- 1.5Master Rows And Columns In Microsoft Excel11 Minutes
- 1.6How To Lock Rows And Columns In Excel (Freezing Panes)6 Minutes
- 1.7Cell Management on Microsoft Excel8 Minutes
- 1.8Edit Multiple Worksheets At The Same Time4 Minutes
- Data Entry Excellence & Automation9
- 2.1Mastering Data Entry And Formatting Essentials15 Minutes
- 2.2Master Date And Time Entry In Excel11 Minutes
- 2.3Stop Typing Lists Manually (AutoFill)6 Minutes
- 2.4Stop Typing Data Manually: Master Excel Flash Fill7 Minutes
- 2.5Stop Data Entry Errors With Dropdown Lists (Data Validation)7 Minutes
- 2.6Excel Copy And Paste Secrets5 Minutes
- 2.7The Secret to Clean Excel Data9 Minutes
- 2.8Stop Manually Retyping Data in Excel11 Minutes
- 2.9Edit Thousands Of Cells Instantly7 Minutes
- Design, Formatting & Professionalism7
- 3.1Make Excel Sheets Look Professional Instantly with Format Painter7 Minutes
- 3.2Instantly Spot Trends With Conditional Formatting10 Minutes
- 3.3Designing in Excel: Pictures, Shapes & Text Boxes14 Minutes
- 3.4Microsoft Excel: The Difference Between Notes and Comments9 Minutes
- 3.5Fix Messy Decimals Instantly on Excel7 Minutes
- 3.6Complete Excel Spreadsheet Workshop For Beginners6 Minutes
- 3.7Stop Manually Formatting Data: The Power of Excel Tables9 Minutes
- Formula Logic & Basic Calculations7
- 4.1Why Most Excel Formulas Fail18 Minutes
- 4.2Understanding The Logic of Excel Formulas16 Minutes
- 4.3Mastering Excel Formula Logic and Calculation Order
- 4.4Stop Memorizing Excel Formulas7 Minutes
- 4.5Fix Common Excel Formula Errors Instantly9 Minutes
- 4.6Why Your Excel Totals Are Wrong6 Minutes
- 4.7Real World Excel Practice For Absolute Beginners14 Minutes
- Intermediate Functions & Data Protection8
- 5.1Make Excel Do The Heavy Lifting13 Minutes
- 5.2Master Every Excel COUNT Function in One Video11 Minutes
- 5.3Never Struggle With Excel Dates Again15 Minutes
- 5.4Master Time And Date Formulas In Minutes9 Minutes
- 5.5The Secret To Locking Cells In Excel7 Minutes
- 5.6Stop People From Breaking Your Excel Formulas
- 5.7Connect Multiple Excel Sheets Instantly6 Minutes
- 5.8Real World Excel Formulas For Business14 Minutes
- Advanced Lookup & Modern Dynamic Arrays11
- 6.1VLOOKUP Explained: The Most Important Excel Formula9 Minutes
- 6.2Stop Using VLOOKUP: Master The INDEX MATCH Combo12 Minutes
- 6.3Forget VLOOKUP Use This Instead (XLOOKUP/Modern Alternatives)12 Minutes
- 6.4The Most Misunderstood Excel Function11 Minutes
- 6.5Stop Dragging Formulas Down (Dynamic Arrays)10 Minutes
- 6.6How To Remove Duplicates And Create Unique Lists on Excel6 Minutes
- 6.7Never Remove Duplicates Again on Excel (UNIQUE Function)6 Minutes
- 6.8Auto-Update Lists With SORT & SORTBY8 Minutes
- 6.9The Most Powerful Function In Modern Excel (FILTER/LAMBDA)12 Minutes
- 6.10The New Way To Split Text In Excel13 Minutes
- 6.11The New Way To Split Data In Excel13 Minutes
- The "AI" Intelligence & Logic Layer4
- Data Visualization, Pivot Tables & Final Testing24
- 8.1Pivot Tables Are Easier Than You Think15 Minutes
- 8.2Master Pivot Tables And Slicers In Minutes12 Minutes
- 8.3Master Pivot Table Sorting And Conditional Filtering13 Minutes
- 8.4Make Pivot Tables Look Professional14 Minutes
- 8.5Master Data Visualization With Pivot Charts7 Minutes
- 8.6Make Your Excel Dashboards Interactive6 Minutes
- 8.7Can You Solve This Real World Excel Challenge? (Part 1)6 Minutes
- 8.8Can You Solve This Real World Excel Challenge? (Part 2)6 Minutes
- 8.9Can You Complete This Excel Challenge? (Part 3)6 Minutes
- 8.10Can You Solve This Real World Excel Challenge? (Part 4)5 Minutes
- 8.11Can You Pass This Excel Challenge?5 Minutes
- 8.12Test Your Skills With This Excel Practice Test11 Minutes
- 8.13The Right Way To Filter In Excel10 Minutes
- 8.14Validate AI Insights With Excel Copilot9 Minutes
- 8.15Turn Raw Data Into Business Strategy8 Minutes
- 8.16How To Enable Microsoft Copilot In Excel8 Minutes
- 8.17Excel Copilot Best Practices And Core Principles7 Minutes
- 8.18Let Copilot Write Your Excel Formulas6 Minutes
- 8.19You Won’t Believe How Easy Copilot Makes Excel Formulas9 Minutes
- 8.20Fix Messy Text Data Instantly With Copilot10 Minutes
- 8.21Automate Project Schedules With Excel Copilot15 Minutes
- 8.22Highlight Complex Data Instantly With Copilot12 Minutes
- 8.23Create Pivot Charts Instantly With Copilot12 Minutes
- 8.24Unlock Business Insights With Excel Copilot10 Minutes
Master The Excel Interface Before You Start
Next