Storing data in an ordinary range works fine, until it doesn’t. The moment we add a new row, our SUM formulas miss it, our PivotTables go stale, and we’re stuck manually adjusting ranges. Excel Tables, created with the simple shortcut Ctrl+T, solve all of that. In this tutorial, we walk through three exercises that show…
The post