Thursday, March 19, 2015

Excel Tips & Tricks: Pivot Tables

Pivot tables are one of Excel's most powerful features. They help extract meaningful intelligence from detailed data sets. They also provide quick summaries, and help ‘slice-and-dice’ or analyze large data sets.

Pivot tables have many unexpected uses as well—limited only by your imagination. For example, you can quickly extract a list of unique values from a table to easily compare to two sets of similar data. Or you can create a formatted summary report that is linked to a data set that is regularly updated with new data. If you work with detailed tables and data, don’t miss these examples of pivot tables.
Share:

No comments

Post a Comment

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