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

Topics

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

Who should Attend

• CPAs
• Accountants
• Financial consultants
• CFOs
• Banking
• Controllers
• Insurance
• Finance
• Telecom
• Education
• Marketing
• I.T
• Investments
• Sales
• Medical Devices
• Pharmaceutical
• Aviation
• FDA
• Retail
• Energy
• Logistics & Supply Chain
• Human Resource
• Audit
• Accounts