What is a Table?
The Feature Comparison worksheet contrasts the Table, PivotTable, and Data Table features. Let’s compare each feature:
- Tables – Tables transform static cell ranges into self-expanding lists, as shown in Figure 7.2, which, as you’ll soon see, unlocks multiple layers of automation:
Figure 7.2 – Table
- PivotTables – PivotTables are a report-writing feature that summarizes lists of data inside cell ranges or Tables into concise formats, as shown in Figure 7.3:
Figure 7.3 – PivotTable
Tip
I briefly explore PivotTables in this chapter and Chapter 9, Excel Quirks and Nuances.
- Data Tables – Data Tables enable you to swap one or more sets of inputs through a single anchor formula to compare multiple scenarios, as shown in Figure 7.4:
Figure 7.4 – Data Table
Nuance
The TABLE worksheet function, as shown...
