27 July 2013
Excel tables offer several advantages over data ranges. Here's a look at some of the handy things tables enable you to do:
- Easy sorting and filtering.
- Quick formatting.
- Effortless data entry.
- Automatic nomenclature.
- Quick totals.
- Always visible headers.
- Formula autofill.
- No copy necessary.
- Dynamic charts.
- One-click select.
Full article: 10 reasons to use Excel's table object