Limited Period Offer - Get Unlimited Access to 10k+ hours of content with myCPE Prime at $199Subscribe Now

Excel Accountant: Pivot Tables for Data Analysis

  • Accountant
  • CPA (CA)
  • CFE
  • CGFM
  • CPA/CITP
  • CIA
  • CMA
  • CPA (US)
  • CA - ICAEW
  • Maryland Tax Preparer
  • ACCA
  • FPAC
  • CA - Ireland
  • CA - Scotland
  • CPA - Ireland
  • Course Description
  • Course Qualification
  • Presenter
  • FAQ

Course Description

Course Description

In this CPE webinar Excel expert David  Ringstrom, CPA, helps you uncover the feature that Microsoft reports 80% of Excel users have yet to try. As you’ll see, pivot tables are an easy-to-use report-writing tool that instantly summarizes lists of data with just a few actions with your mouse. Of course, when it comes to Excel there can be nuances that complicate things, which David brings to your attention so that you can work effectively with pivot tables.

David demonstrates every technique at least twice in this Excel CPE webinar: first, on a PowerPoint slide with numbered steps, and second, in the subscription-based Office 365 version of Excel. David draws your attention to any differences in the older versions of Excel (2019, 2016, 2013, and earlier) during the presentation as well as in his detailed handouts. David also provides an Excel workbook that includes most of the examples he uses during the webcast.

Office 365 is a subscription-based product that provides new-feature updates as often as monthly. Conversely, the perpetual licensed versions of Excel have feature sets that don’t change. Perpetual licensed versions have year numbers, such as Excel 2019, Excel 2016, and so on.

Major topics covered in this course:

  • Ideal Data for Pivot Tables
  • Initiating a Pivot Table
  • Pivot Table Interfaces
  • Adding Fields to Pivot Tables
  • Adding Another Row of Field
  • Managing Subtotal Positions
  • Number Formatting
  • Renaming Fields
  • Pivot Table Subtotaling Quirks
  • 4 Ways to Remove Fields
  • Report Filter Feature
  • Generate Multiple Pivot Tables
  • Pivot Table Sorting Nuances
  • Convert Pivot Table to Values
  • Forcing Pivot Tables to Recalculate
  • Recommended Pivot Tables (Excel 2013+)

Learning Objectives

  • To identify the location of the pivot table-related Subtotals command within Excel's ribbon menu interface.
  • To describe the indicator that signifies whether the columns or rows of a pivot table have been filtered.
  • To identify the location of the Field List command within Excel's ribbon menu interface.

Recommended For

  • This Excel course is recommended for CPAs, CFEs, CIAs, CMAs, MRTP, FPACs, Accounting, and other financial professionals using excel for data analysis.

Who Should Attend?

  • Accountant
  • Accounting Firm
  • Accounting Managers
  • Accounting Practice Owners
  • Accounts Director
  • Bookkeepers & Accountants & Tax Preparers
  • Certified Fraud Examiner
  • Certified Management Accountant (CMA)
  • Certified Public Accountant (CPA)
  • Certified Valuation Analysts
  • Chartered Professional Accountant
  • Chief Accounting Officer
  • Cloud Accountants
  • CPA (Industry)
  • CPA - Mid Size Firm
  • CPA - Small Firm
  • CPA in Business
  • Entrepreneurial Accountant
  • Entrepreneurial CPA