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

Instructor: David H Ringstrom
Product ID: 704603
Training Level: Basic
  • Duration: 90 Min
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.

recorded version

1x Person - Unlimited viewing for 6 Months
(For multiple locations contact Customer Care)
Recorded Link and Ref. material will be available in My CO Section
Last Recorded Date: Feb-2018

Training CD / USB Drive

One CD/USB is for usage in one location only.
(For multiple locations contact Customer Care)
CD/USB and Ref. material will be shipped within 15 business days

Customer Care

Fax: +1-650-362-2367

Email: [email protected]

Read Frequently Asked Questions

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
Instructor Profile:
David H Ringstrom

David H Ringstrom
Owner, Accounting Advisors, Inc

David H. Ringstrom, CPA, is an author and nationally recognized instructor who teaches scores of webinars each year. His Excel courses are based on over 25 years of consulting and teaching experience. His mantra is “Either you work Excel, or it works you,” so he focuses on what he sees users don’t, but should know about Microsoft Excel. His goal is to empower you to use Excel more effectively.

Follow us :
REACH and RoHS Compliance: Gain a Deeper Understanding
Reduce costs for compliance with data integrity: 21 CFR Part 11, SaaS/Cloud, EU GDPR

Refund Policy

Registrants may cancel up to two working days prior to the course start date and will receive a letter of credit to be used towards a future course up to one year from date of issuance. ComplianceOnline would process/provide refund if the Live Webinar has been cancelled. The attendee could choose between the recorded version of the webinar or refund for any cancelled webinar. Refunds will not be given to participants who do not show up for the webinar. On-Demand Recordings can be requested in exchange.

Webinar may be cancelled due to lack of enrolment or unavoidable factors. Registrants will be notified 24hours in advance if a cancellation occurs. Substitutions can happen any time.

If you have any concern about the content of the webinar and not satisfied please contact us at below email or by call mentioning your feedback for resolution of the matter.

We respect feedback/opinions of our customers which enables us to improve our products and services. To contact us please email [email protected] call +1-888-717-2436 (Toll Free).

Product Reviews

This product hasn't received any reviews yet. Be the first to review this product! Write review

Best Sellers
You Recently Viewed