Tables & Structured References
1 tutorial written here on tables & structured references, plus 33 public tables & structured references videos from other channels, filed by level and subtopic.
All articlesOriginal tutorials
1Excel Table vs normal range
Know when to convert a range into an Excel Table and why tables make formulas, filters, pivots, and reports safer.
Video resources
Every tables & structured references video we have filed, published by other channels. All 33 are listed — nothing hidden behind a cap.
All About Excel Tables: Excel learning resourceOnly 1% of Excel Users Know Excel Tables! STAND OUT from the Crowd!: Excel learning resourceThe Mistake Almost EVERY Excel User Makes (Free File): Excel learning resourceIntroduction to structured references: Excel learning resourceHow to Use Excel Tables Structured References: Excel learning resourceFREE EXCEL COURSE Lesson 6 - Excel Tables Overview: Excel learning resourceI See Your Excel Tables... and I'm Concerned: Excel learning resourceLock Structured References in Excel Tables: Excel learning resourceTable Structured References Aren't Hard - You're Using Them Wrong: Excel learning resourceHow to Use Structured References in Excel: Table, Column, and Item Specifiers: Excel learning resourceStructured References Across Multiple Tables: Advanced Excel Formula Technique: Excel learning resourceRelative & Fixed Referencing using Structured References in Excel: Excel learning resourceExcel Table: Structured References: Excel learning resource9.Excel Tables: Excel learning resourceHow To Create An Excel Table: Excel learning resourceUse Structured References in Excel: Table, Column, and Item Specifiers: Excel learning resourceExcel structured references inside a table: Excel learning resourceThe Subtotal Function For Excel Tables Total Row: Excel learning resourceExcel Tables: How to Use Structured References with the SUMIF Formula in an Excel Dashboard: Excel learning resourceHow to copy and lock structured references in an Excel table: Excel learning resourceHighline Excel 2013 Class Video 08: Excel Table Formula Nomenclature / Structured References 22 Ex.: Excel learning resourceExcel Absolute Reference Add-in for Table Formulas (Structured References): Excel learning resourceHow to Use Excel Tables Structured References: Excel learning resourceExcel Tables: Excel learning resourceExcel Table Structured References Explained 2024: Excel learning resourceUsing Table Structured References in Excel functions: Excel learning resourceUse Excel Tables to EASILY Save Hours of Time: Excel learning resourceEasily Format and Filter data with Excel Tables and Slicers: Excel learning resourceMicrosoft Excel - Absolute Structured References: Excel learning resourceExcel Tips - Tables and Structured References: Excel learning resourceExcel Tables - Formulas, Basic to Advanced: Excel learning resource008-Formula Using Structured References: Excel learning resourceHow do I turn off structured references in Excel? - Excel Tips and Tricks: Excel learning resource
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
