Free ebook
Free ebook: Excel for Beginners
A complete starting point for Excel: the screen, entering and formatting data, how formulas work, the functions everyone should know, and a gentle introduction to charts and PivotTables.
Get the ebookCourse path
Turn Tables & Structured References into a course path
Excel Tables & Data Cleaning strings this into a structured, intermediate-friendly path with a full lesson list.
View course path4 subtopics in this path
Excel Tables, named columns, structured references, totals rows, table styles, and practical table design.
Each item pairs the learning structure with curated public YouTube resources where available, so learners can move from outline to video practice quickly.
Convert ranges into Tables, choose styles, filter columns, and keep headers clean.
MyOnlineTrainingHub
Open on YouTube (opens in a new tab)
MyOnlineTrainingHub
Open on YouTube (opens in a new tab)Write formulas using table and column names instead of fragile cell coordinates.
Excel Off The Grid
Open on YouTube (opens in a new tab)Use built-in totals, subtotals, and filtered calculations inside tables.
Prepare tables that refresh cleanly and connect well to pivots, charts, and Power Query.
Real Excel screenshots showing what this topic looks like in practice.
Technology for Teachers and Students
Focused Excel Tables lesson covering the core mechanics learners need before reporting.
Open on YouTube (opens in a new tab)MyOnlineTrainingHub
Strong practical treatment of why tables matter and how they improve formulas and reporting workflows.
Open on YouTube (opens in a new tab)MyOnlineTrainingHub
Useful for teaching clean data layout before building reliable tables, summaries, and reports.
Open on YouTube (opens in a new tab)
Exceljet
Concise introduction to structured references and why they make table formulas easier to read.
Open on YouTube (opens in a new tab)
Online Training for Everyone
Practical tutorial on using Excel tables and structured references in repeatable worksheet formulas.
Open on YouTube (opens in a new tab)
TrumpExcel
Beginner overview of converting ranges to Excel tables and using table features productively.
Open on YouTube (opens in a new tab)MyOnlineTrainingHub
Best-practices lesson on common Excel table mistakes and how to build cleaner, safer tables.
Open on YouTube (opens in a new tab)MyOnlineTrainingHub
Focused guide to controlling structured references so table formulas stay accurate when copied.
Open on YouTube (opens in a new tab)Excel Off The Grid
Deeper table-reference tutorial that clarifies how structured references behave in real worksheets.
Open on YouTube (opens in a new tab)
BrainBell
Extracted from saved YouTube search results - titled "How to Use Structured References in Table, Column, and Item Specifiers", filed under Tables Structured References for its structured references coverage.
Open on YouTube (opens in a new tab)
Annette Slager
Extracted from saved YouTube search results - titled "Structured References Across Multiple Tables Advanced Formula Techn...", filed under Tables Structured References for its structured references coverage.
Open on YouTube (opens in a new tab)
Analytics Success
Extracted from saved YouTube search results - titled "Relative & Fixed Referencing using Structured References in", filed under Tables Structured References for its structured references coverage.
Open on YouTube (opens in a new tab)26 places we cite for accuracy. We link to them; none has reviewed, endorsed, or collaborated on this site.
Official documentation
Educators and channels
ExcelJet (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)
Teacher's Tech (opens in a new tab)
YouTube (opens in a new tab)Course platforms
