Thursday, December 18, 2014

Excel Tips & Tricks: Tables

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…
Share:

1 comment

  1. This comment has been removed by a blog administrator.

    ReplyDelete

© UVAFinance | All rights reserved.
Blog Layout Created by pipdig