In this video we look at an Excel feature that should be more popular. Unfortunately, the advanced nature and unusual behavior of structured references make Excel Tables difficult for many users.
I explain the reason that Table formulas can cause so much confusion and inconsistency with formulas. And I share best practices on when to use Tables versus when to avoid them. DOWNLOAD THE WORKBOOK ► https://www.excelcampus.com/tables/st...
LINKS
Get free weekly Excel tips: https://www.excelcampus.com/newsletter/
Free 60minute Excel training session: https://www.excelcampus.com/blueprint
Join Our Comprehensive Excel Training Program: https://www.excelcampus.com/elevate
00:00 Introduction
01:15 Structured Referencing
02:45 Corporate Budgeting Example
06:03 When to use Tables
06:47 Possible Solutions