#Excel #StructuredReferences #ExcelFormulas

Structured References: Name-Based Formulas Instead of Cell Positions

Name: Structured References: Name-Based Formulas Instead of Cell Positions
Uploaded: 2026-10-20T22:08:20+00:00
Duration: 4 min 1 s
Description: Learn how structured references let you build formulas based on column names instead of positions. Stephen Yoss explains why this matters when working with large datasets—your formulas automatically update if data moves or changes, plus tables auto-calculate across entire columns. Watch to see how this saves time on formula maintenance.

4:01 · A clip from Excel Accounting Tools: Most Useful Formulas and Pivot Tables, taught by Stephen Yoss

Learn how structured references let you build formulas based on column names instead of positions. Stephen Yoss explains why this matters when working with large datasets—your formulas automatically update if data moves or changes, plus tables auto-calculate across entire columns. Watch to see how this saves time on formula maintenance. From the course “Excel Accounting Tools: Most Useful Formulas and Pivot Tables” (4 CPE credits, Specialized Knowledge, Basic): https://www.cpetoday.com/course/excel-accounting-tools-most-useful-formulas-and-pivot-tables-25c01231 Taught by Brian Tankersley — Speaker & Author, K2 Enterprises. More from Brian Tankersley: https://www.cpetoday.com/instructor/brian-tankersley CPE Today offers live webinars, Live Replays and self-study for CPAs and accounting professionals. NASBA-sponsored (ID 167619) and an IRS-approved CE provider. https://www.cpetoday.com/ #Excel #StructuredReferences #ExcelFormulas

More from this course

3:07 Create Custom Groups in Pivot Tables Without Original Data

1:20 Fuzzy Lookup Saved 20,000+ Records Without a Key

3:59 Why I Still Use OLD Excel Formulas (Not the Modern Ones)