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.