Table automation opportunities

Spreadsheets tend to involve lots of calculations, so first, we’ll see how Table improve and sometimes alter formula behavior. Formulas that reference Table, either by residing within a Table, or referring to a Table will automatically reference additional data that you add to a Table. This eliminates the need to monitor and rewrite formulas that refer to normal ranges of cells. Then, I’ll show you an easy technique for applying number formatting.

From there, I’ll discuss the concept of structured references for formulas. Then, I’ll look at filtering data within Table and automating certain filtering tasks with Slicers. We’ll then see how Table eliminate a common data integrity issue with PivotTables, followed by enabling self-expanding charts.

Let’s begin by seeing how to automate formula management within Table.

Calculated Columns

A Calculated Column within a Table consists entirely of formulas....