2018 - Excel Pivot Tables 101: 2007, 2010, 2013 and 2016

Areas Covered in the Webinar:
Identifying the requirements of ideal data sets to be analyzed with pivot tables.
Convert obsolete Excel spreadsheet files to modern workbook formats.
Discovering how pivot tables behave differently from worksheet formulas when you make changes to the underlying data.
Understand how to avoid the cryptic prompt that appears if you try to rename a pivot table field in the wrong fashion.
Drill down into the detail of your numbers with a double-click.
Learn how to use the Recommended PivotTables feature in Excel 2013 and later.
Identify how to expand and collapse groups of data within a pivot table.
Identify the best approach for formatting numbers with pivot tables.
Understand the hierarchy Excel users when adding fields to a pivot table.
Manage subtotals within your Excel pivot tables.
Avoid disabled pivot table features by using the appropriate workbook format.
Understand the significance of refreshing Excel pivot tables.