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