A common use of Excel is managing large datasets, which are then filtered, used in pivot tables or referenced in formulas. There is a little-used, but incredibly useful feature in Excel called “Tables,” which makes the formatting, filtering and general use of these datasets much easier.
Learn how to use Tables for:
- Auto-filtering
- Freezing column headers for scrolling
- Natural language references in formulas
- Auto-filling formulas when new rows are added
- Resizing the data range for pivot tables
- Quick Formatting including alternate row shading
- And more…
This comment has been removed by a blog administrator.
ReplyDelete