Excel 101: Pivot Tables

Authored by David Ringstrom
About this Course
Topics covered include: Compiling unwieldy data into the format required for pivot table analysis quickly and easily; Using Excel's PivotTable feature to quickly identify anomalies within QuickBooks data; Adding fields to pivot tables; Discovering how pivot tables differ from worksheet formulas and learning the importance of the Refresh command; Identifying the requirements of ideal data sets to be analyzed within your pivot tables; Avoiding frustration by understanding the nuances of pivot table formatting; Learning the nuances associated with subtotaling data within a pivot table; Adding fields to pivot tables; Discovering how pivot tables differ from worksheet formulas and learning the importance of the Refresh command; Identifying the requirements of ideal data sets to be analyzed within your pivot tables; Learning the nuances associated with subtotaling data within a pivot table; Creating a macro that will automatically remove the words "Sum Of" from your pivot table fields; Filtering pivot table data based on date ranges by way of the Timeline feature in Excel 2013 and later; Learning multiple ways to remove fields from a pivot table; Disabling the GETPIVOTDATA function if it's not needed for your analysis; Understanding why numeric data may appear in a pivot table more than once and how to correct the problem.
$ 30.00
Add To Cart
NASBA Field of Study
Computer Software & Applications
Level
Basic
CPE Credits
2.0
Prerequisites
Must be familiar with Excel
Last Updated
07/31/2018
14121