This webinar will help you master pivot tables in Excel 2007, 2010, 2013, and 2016. Learn tricks and traps of working with pivot tables to help ensure accuracy of reports and convert obsolete Excel spreadsheet files to modern workbook formats.
Why Should You Attend:
This webinar will help you learn how to create pivot tables in Excel 2007, 2010, 2013, and 2016. How to instantly create accurate reports from complex data with only a few mouse clicks and use Excel pivot tables to easily create reports? Discover which document format cripple key pivot table related features in Excel 2007 and later. Avoid the common trap that causes Excel to treat numbers as text within a pivot table and save time and avoid frustration by understanding the nuances of pivot table formatting. Quickly summarize data for analysis, but instantly dive into the details when warranted.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.
Who Will Benefit:
- Accountants
- CPAs
- CFOs
- Financial consultants
- Controllers
- Banking
- Finance
- Insurance
- Education
- Telecom
- I.T
- Marketing
- Sales
- Investments
- Pharmaceutical
- Medical Devices
- FDA
- Aviation
- Energy
- Retail
- Human Resource
- Logistics & Supply Chain
- Accounts
- Audit
Speaker
David H RingstromCourse Provider
David H Ringstrom,
