Insights Teach on CourseBond Log in Sign up

Microsoft Excel Training Tutorials for Beginners, Intermediate and Advanced Learners

Beginner ⏱ 171 hours 📚 224 lessons 🌐 en 🏆 Certificate 📅 Last updated May 2026

✅ Our Excel long tutorials have become some of the most popular content we've ever published on the YouTube channel. To make them easier to find, we've created this playlist with them all in.

All these courses are taken from the full Simon Sez IT Excel courses, available here ➡️ https://bit.ly/3nK49ZV

1 section • 224 lectures • 170.8h total length

  • Excel Tutorial Beginner to Advanced - 12-Hour Excel Course 716 min
  • Excel 2019 for Beginners 183 min
  • Microsoft Excel 365 Tutorial: 4-Hour Beginner Excel Training Course 262 min
  • How to Use Excel 2021/365 for Beginners 282 min
  • Excel 2021/365 Beginners & Intermediate Training: 10-Hour Excel Tutorial Class 592 min
  • Microsoft Excel Intermediate Training (2021/365): 5-Hour Excel Tutorial Class 310 min
  • Microsoft Excel 2021/365 Tutorial: 3.5+ Hours of Advanced Excel Training Course 224 min
  • 30 Essential Excel Tips and Tricks for 2026 - Excel Productivity Tutorial 127 min
  • Top Excel Formulas and Functions 151 min
  • 30 Awesome Excel Tips and Tricks for 2023 122 min
  • Advanced Excel Tutorial: Advanced Functions Course (VLOOKUP, IF, Forecasting, Statistical) 273 min
  • Advanced Pivot Tables Tutorial in Excel - 2.5 Hour Pivot Table Excel Course 164 min
  • Top Ten Excel Formulas and Functions - IF, VLOOKUP, PMT, INDEX MATCH - Excel Tutorial 52 min
  • Microsoft Excel Mac Tutorial: MS Excel Mac Training Course - 2+ Hours 131 min
  • The Ultimate MS Excel Crash Course: 6-Hour Microsoft Excel 2016 Tutorial for Beginners 362 min
  • Excel Power Query Course: Power Query Tutorial for Beginners 109 min
  • Data Cleaning in Excel - Text Functions and Power Query in Excel! 68 min
  • VBA Excel - Edit a Macro using VBA in Excel Tutorial 47 min
  • How to Create a Stunning Interactive Dashboard in Excel! Sales Excel Dashboard - Crash Course 114 min
  • Excel Formulas for Beginners - 1+ Hour Class! 68 min
  • The Ultimate Excel Tutorial - Beginner to Advanced - 5 Hours! 343 min
  • Dynamic Array Functions in Excel: XLOOKUP, FILTER, UNIQUE, XMATCH 53 min
  • Advanced Excel Formulas (IF, IFS, INDEX, MATCH, SUMPRODUCT, XLOOKUP, OFFSET, CHOOSE) 60 min
  • Ultimate PivotTables Tutorial in Excel 365 49 min
  • Logical Functions In Excel Tutorial (IF, IFS, AND, OR, COUNTIF, SUMIF): Excel Formulas and Functions 57 min
  • Basic Forecasting in Excel Tutorial (SLOPE, INTERCEPT, FORECAST.LINEAR, TREND, Forecast Sheets) 45 min
  • Excel Tips & Tricks: Designing Better Spreadsheets - 1-hour Excel Tutorial 65 min
  • Creating an Interactive Dashboard in Excel Using Pivot Tables, Pivot Charts and Slicers 61 min
  • What-If Analysis (Goal Seek, Scenario Manager, Data Tables) - 1-hour Excel Tutorial 55 min
  • Ten Excel Tips that are Easy to Learn - Part 2 ✅ 41 min
  • Ten Microsoft Excel Tips and Tricks to Learn - Part 3 38 min
  • Using the Data Model to Create Pivot Tables: 1-Hour Tutorial! 43 min
  • PivotTables for Excel: A Quick 1-Hour Crash Course! 54 min
  • Cleaning Data in Excel: Microsoft Excel Crash Course 61 min
  • Interactive Dashboards in Excel: Microsoft Excel Crash Course 67 min
  • 20 Excel Tips to Improve Your Productivity 60 min
  • How to Use the AVERAGE Function in Excel 5 min
  • Microsoft Excel Chart Formatting Tips and Tricks 62 min
  • Advanced Excel Tutorial: 3+ Hours of Tips and Tricks 202 min
  • Chat GPT Tutorial: How to use ChatGPT to Convert Excel into PDF 3 min
  • Chat GPT Tutorial: How to use ChatGPT to Create VBA Scripts 12 min
  • How to Create a Dropdown Menu in Microsoft Excel 5 min
  • Private video
  • Private video
  • How to Create a Number Series in Microsoft Excel 1 min
  • How to Add Emojis to Data in Excel 4 min
  • How to Convert Numbers into Percentages in Excel 3 min
  • How to Autofit Column Widths in Excel 1 min
  • How to Highlight Cells or Rows with a Checkbox in Excel 3 min
  • How to Transpose Rows into Columns in Excel 2 min
  • How to Keep the Formula in a Cell Unchanged Using Absolute Referencing in Excel 2 min
  • How to Combine Excel Cells Using the & Sign 2 min
  • The Top 19 Excel Hacks of 2023 Master Spreadsheets Like a Pro! 94 min
  • Kickstart with Microsoft Excel: 11 Functions to Supercharge Your Skills! 103 min
  • How to Change Letter Cases in Excel: Convert Text Tutorial 2 min
  • How to Insert a Search Bar in Excel: Add Search to Spreadsheet 8 min
  • How to Add Spin Buttons in Excel: Add buttons to a spreadsheet 3 min
  • Excel Time Saving Tips 10 min
  • Excel Mastery: Calculate Days Between Dates Easily! 2 min
  • How to Filter Data with Excel Slicers 5 min
  • Track Performance with Variance Charts in Excel : Monitor Progress and Compare 5 min
  • How to Fit Long Text into One Cell 2 min
  • How to Use Text to Columns in Excel 4 min
  • Top 5 Excel Shortcut Tricks for Beginners 7 min
  • 5 Top Excel Shortcut Tips for Beginners 9 min
  • Best and Easiest Ways to Delete Empty Rows in Excel 5 min
  • How to Use ChatGPT with Excel for Macros & Formulas! 7 min
  • How to Show a Message When a Cell is Clicked in Excel 3 min
  • How to Fix Formula Errors With IF ERROR Function 3 min
  • How to Print Column Headers on Every Page: Better Spreadsheet Printing and Sharing 3 min
  • How to Flash Fill in Microsoft Excel 2 min
  • How to Use Autosum in Excel to Quickly Sum Data 1 min
  • How to Insert Multiple Rows in Excel 1 min
  • How to Use Data Validation in Excel 365 7 min
  • How to Add Navigation to Spreadsheet in Excel 6 min
  • How to Add a Form to Excel 4 min
  • How to use AND OR formulas in Excel 7 min
  • How to Use SUMIFS and COUNTIFS in Excel 8 min
  • How to Use VLOOKUP in Excel 9 min
  • How to Use HLOOKUP in Excel 7 min
  • INDEX and MATCH: Better than VLOOKUP in Excel? 8 min
  • How to use XLOOKUP and XMATCH in Excel 365 8 min
  • How to Sort on Multiple Columns in Excel 6 min
  • How to use SORT and SORTBY Functions in Excel 8 min
  • How to Use the FILTER function in Excel 10 min
  • How to use MEAN, MEDIAN, and MODE averages in Excel 7 min
  • How to Use Custom Formatting in Excel 365 10 min
  • How to Calculate Dates with WORKDAY and NETWORKDAYS in Excel 8 min
  • How to Calculate Dates with EDATE and EOMONTH in Excel 7 min
  • How to Clean a Dataset in Excel 9 min
  • How to Clean a Dataset with Power Query in Excel 8 min
  • How to Split Data into Columns in Excel 7 min
  • How to Create a PivotTable in Excel 365 7 min
  • How to Create a Pivot Chart in Excel 365 8 min
  • How to Use Dynamic Dropdown Lists in Excel 6 min
  • How to Use the PMT Function to Calculate Repayments in Excel 10 min
  • How to Use Goal Seek in Excel 365 6 min
  • How to Use the Scenario Manager in Excel 365 7 min
  • Microsoft Excel 365 Intermediate Training: 4+ Hour Excel Tutorial Class 255 min
  • Excel Spreadsheet Design Tips and Tricks 41 min
  • How to Use IF, IFS, COUNTIFS, SUMIFS, IFERROR, and IFNA in Excel 21 min
  • Ultimate Guide to Lookup in Excel: VLOOKUP, XLOOKUP, and more 48 min
  • How to Find Duplicates in Excel 365 9 min
  • Ultimate Guide to Splitting Data in Excel 24 min
  • Ultimate PivotCharts Tutorial in Excel 365 35 min
  • How to Make PivotTables and PivotCharts Dashboards with Slicers in Excel 29 min
  • How to Import Data into Excel from a Text File 5 min
  • 13 Excel Top Tips and Tricks to Save You Time 53 min
  • Top 10 Excel Formulas for Beginners 92 min
  • Top Excel Formulas - Beginner to Advanced 143 min
  • Excel 365 for Beginners: Getting Started and Introduction (1 of 51) 4 min
  • Excel 365 for Beginners: Access and Navigate the Online Portal (2 of 51) 8 min
  • Excel 365 for Beginners: Exercise to Get Started (3 of 51) 2 min
  • Excel 365 for Beginners: Install and Launch Excel 365 on Windows 11 (4 of 51) 5 min
  • Excel 365 for Beginners: Navigating Workbooks and Ribbons (5 of 51) 11 min
  • Excel 365 for Beginners: How to Use Contextual Menus and Ribbons (6 of 51) 6 min
  • Excel 365 for Beginners: Customize the Quick Access Toolbar (7 of 51) 8 min
  • Excel 365 for Beginners: Boost Productivity with Essential Keyboard Shortcuts (8 of 51) 9 min
  • Excel 365 for Beginners: Exercise for Contextual Menus, Ribbons and Panes (9 of 51) 5 min
  • Excel 365 for Beginners: How to Use Templates to Save Time (10 of 51) 8 min
  • Excel 365 for Beginners: How to Organize, Color, and Copy Your Worksheets (11 of 51) 8 min
  • Excel 365 for Beginners: Saving and Accessing Workbooks in OneDrive (12 of 51) 6 min
  • Excel 365 for Beginners: Enter and Format Text, Numbers, and Dates (13 of 51) 8 min
  • Excel 365 for Beginners: Simplify Data Entry with Excel's Custom Lists (14 of 51) 7 min
  • Excel 365 for Beginners: Exercise for Templates, OneDrive, and Custom Lists (15 of 51) 5 min
  • Excel 365 for Beginners: Mastering BODMAS in Excel Calculations (16 of 51) 8 min
  • Excel 365 for Beginners: Learn to Quickly Sum Data (17 of 51) 8 min
  • Excel 365 for Beginners: Learn the Most Essential Formulas and Functions (18 of 51) 7 min
  • Excel 365 for Beginners: Absolute vs. Relative Cell Referencing (19 of 51) 8 min
  • Excel 365 for Beginners: Speed Up Calculations with AutoSum (20 of 51) 7 min
  • Excel 365 for Beginners: How to Use AutoFill and Flash Fill to Streamline Your Work (21 of 51) 12 min
  • Excel 365 for Beginners: Exercise for Formulas, Functions, Auto-Fill and Autosum (22 of 51) 6 min
  • Excel 365 for Beginners: How to Create and Use Named Ranges for Easier Calculations (23 of 51) 4 min
  • Excel 365 for Beginners: How to Create Named Ranges (24 of 51) 5 min
  • Excel 365 for Beginners: Enhancing Formulas with Named Ranges for Clarity and Efficiency (25 of 51) 4 min
  • Excel 365 for Beginners: Exercise for Named Ranges (26 of 51) 3 min
  • Excel 365 for Beginners: Streamline Your Data with Correct Number Format (27 of 51) 13 min
  • Excel 365 for Beginners: Formatting Cells, Rows, and Columns Manually (28 of 51) 14 min
  • Excel 365 for Beginners: Effortlessly Style Your Data with AutoFormat (29 of 51) 5 min
  • Excel 365 for Beginners: Streamline Your Spreadsheets with Find and Replace Formatting (30 of 51) 7 min
  • Excel 365 for Beginners: Quick Tips to Copy Formatting using Format Painter (31 of 51) 6 min
  • Excel 365 for Beginners: Clearing Excel Formats and Hyperlinks (32 of 51) 6 min
  • Excel 365 for Beginners: Exercise for Custom Formatting (33 of 51) 5 min
  • Excel 365 for Beginners: Quick Guide on Excel Tables (34 of 51) 9 min
  • Excel 365 for Beginners: Table Creation and Style Customization (35 of 51) 11 min
  • Excel 365 for Beginners: Harnessing Table References in Excel Formulas (36 of 51) 8 min
  • Excel 365 for Beginners: Exercise for Excel Tables and Average Calculations (37 of 51) 4 min
  • Excel 365 for Beginners: Manage Rows and Columns in Excel (38 of 51) 10 min
  • Excel 365 for Beginners: How to Perfectly Align Text and Numbers in Excel (39 of 51) 10 min
  • Excel 365 for Beginners: Merge Cells vs. Center Across Selection (40 of 51) 8 min
  • Excel 365 for Beginners: How to Customize and Apply Themes in Excel (41 of 51) 9 min
  • Excel 365 for Beginners: Exercise for Insert Rows and Apply Number Formats (42 of 51) 4 min
  • Excel 365 for Beginners: Optimizing Data with Excel Lists for Better Insights (43 of 51) 8 min
  • Excel 365 for Beginners: Single-Level Sort (44 of 51) 6 min
  • Excel 365 for Beginners: Multi-Level Sort (45 of 51) 7 min
  • Excel 365 for Beginners: Sort with Custom List (46 of 51) 5 min
  • Excel 365 for Beginners: How to Filter Your Excel Lists (47 of 51) 9 min
  • Excel 365 for Beginners: Filter and Sort by Color (48 of 51) 5 min
  • Excel 365 for Beginners: Apply Subtotals in Excel Lists (49 of 51) 7 min
  • Excel 365 for Beginners: Exercise for Data Sorting and Filtering (50 of 51) 4 min
  • Excel 365 for Beginners: Course Recap and Conclusion (51 of 51) 4 min
  • How to Build Interactive Spreadsheets in Excel 53 min
  • Microsoft Excel 365 Tutorial: 3+ Hours of Advanced Excel Training 188 min
  • Ultimate Guide to Macros and VBA in Excel 365 59 min
  • How to Use Calculated Fields and Items in PivotTables 9 min
  • How to Count Unique Entries in Excel 365 4 min
  • How to Use Spills and Arrays in Excel 365 6 min
  • Unique vs Distinct in Excel 365 5 min
  • How to Extract Multiple Unique Columns in Excel 365 3 min
  • How to Extract Unique Values by Column in Excel 365 4 min
  • How to Use the SEQUENCE Function in Excel 365 5 min
  • How to use RANDARRAY and RANDBETWEEN in Excel 365 10 min
  • How to use XLOOKUP for Complex Lookups in Excel 365 8 min
  • How to use XMATCH in Excel 365 5 min
  • How to do Lookups with Multiple Criteria in Excel 365 7 min
  • How to do Lookups with Duplicates in Excel 365 6 min
  • How to use the LET Function in Excel 365 10 min
  • How to Create Excel Functions with LAMBDA 12 min
  • How to Create a Data Model in Power Pivot 7 min
  • How to Create Relationships Between Tables in Excel 365 4 min
  • How to Add Calculated Columns in Excel 365 6 min
  • How to Build a PivotTable from Multiple Sources 4 min
  • How to Clean Data with Power Query in Excel 365 10 min
  • How to Combine Files from a Folder with Power Query in Excel 365 7 min
  • How to use LAMBDA: Create New Formulas in Excel 36 min
  • Top Excel Tips for Efficiency Everyone Should Know 41 min
  • Ultimate Guide to the FILTER Function in Excel 365 22 min
  • How to Use Calculated Fields and Items in PivotTables 9 min
  • How to Use the SORT Function in Excel 365 12 min
  • How to Use the SORTBY Function in Excel 365 9 min
  • Ultimate Guide to Create Your Own Functions in Excel 365 23 min
  • How Create Custom Pivot Table Styles 9 min
  • How to Apply Custom Number Formatting in Excel 365 PivotTables 7 min
  • How to Lock Workbooks but not Slicers in PivotTables: Filterable and Adjustable Locked Spreadsheets 4 min
  • How to Use Form Checkboxes in Excel 365 8 min
  • How to Use Macros for Automation in Excel 365 7 min
  • How to Record Macros with Relative References in Excel 365 7 min
  • How to Use the VBA Editor in Excel 365 8 min
  • How to use Copilot to Generate VBA Code 5 min
  • How to use AI to Generate Sample Datasets 6 min
  • How to Build and Design Charts and Dashboards in Excel 140 min
  • Quickstart Guide to Cleaning Data and Building Reporting Dashboards 152 min
  • How to Boost Efficiency in Microsoft Office: Top Tips and Expert Hacks 139 min
  • Data Models, PivotTables, and Power Query in Excel 48 min
  • Conditional Formatting in Excel 46 min
  • How to Create Professional Charts for Business in Excel 59 min
  • Interactive Excel Charts and Dashboards - Data Visualization Course 159 min
  • Top Excel Functions for Data Analysts 96 min
  • Create Formulas and Fix Common Errors in Excel 77 min
  • Excel 365 Beginner to Advanced - 12 Hours 703 min
  • Private video
  • Private video
  • Top 15 Excel Tips and Tricks to Save Time and Speed Up Your Work 79 min
  • Top 15 Excel Functions Everyone Needs to Know 64 min
  • Accountant Excel Toolkit: Trial Balance and General Ledger in Excel 57 min
  • Ultimate Guide to VLOOKUP, HLOOKUP and XLOOKUP: Excel Lookup Functions Course 49 min
  • Ultimate Guide to FILTER, SORT, and SORTBY Functions in Excel: Beginner Tutorial 44 min
  • Excel Forecasting Functions Every Analyst Needs to Know 47 min
  • Excel for Accountants Course | Balance Sheet, Income, Cashflow, Financial Statements and MORE 66 min
  • Master Data Cleaning Essentials with Power Query And Excel 86 min
  • Top Excel Essential Tips 64 min
  • Deleted video
  • Microsoft Excel 365 Essentials Training Course
  • How to Create Dashboards with Copilot in Excel 365 - Agent Mode in Excel Beginner Course 32 min