ComplianceOnline

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

Instructor: David H Ringstrom
Product ID: 704603
  • Duration: 60 Min

recorded version

$129.00
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

Training CD

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

Customer Care

Fax: +1-650-963-2556

Email: customercare@complianceonline.com

Read Frequently Asked Questions

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

David H Ringstrom
Owner, Accounting Advisors, Inc

David H. Ringstrom, CPA, is an author and nationally recognized instructor who inducts multiple webinars each year. His Excel courses are based on 25 years of consulting and teaching experience. Mr. Ringstrom’s 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 :
ComplianceOnline Banking Summit 2016 | Risk Management and Data Security - 80390SEM
ComplianceOnline Medical Device Summit 2017

Product Reviews

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

Best Sellers
You Recently Viewed
    Loading