Course Information
Excel Illuminated: PivotTables – Part 2
Course Information
| Title: | Excel Illuminated: PivotTables – Part 2 |
|---|---|
| Category: | Computer Software |
| Field of Study: | Computer Software and Applications |
| Course Code: | M052 |
| CPE Credits: | 2.0 |
| Price: | 19.95 |
Description
Description:
This presentation will empower you to take your pivot table knowledge to the next level. Excel expert David Ringstrom, CPA, takes you beyond the basics of pivot tables by demonstrating how pivot tables differ from worksheet formulas, the importance of the Refresh and Report Filter commands, how to disable the GETPIVOTDATA function, how to drill down into numbers with a simple double-click, and much more. You’ll also see how to quickly transform unwieldy reports into pivot table-ready lists. David demonstrates every technique at least twice: 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 video.
Delivery Method: Online Interactive Self Study
Level: Overview
Prerequisites: None
Advanced Preparation: None
Course Details
Category: Computer Software
Field of Study: Computer Software and Applications
Passing Score: 70%
Technical Details: CA, FL: Computer Software and Applications are technical subjects TX: Computer Software and Applications are non-technical subject for TX. NY: Advisory Services includes Computer Software and Application
For More Detail:
If you are unable to view PDF then right click the mouse and click save link as
Objectives
Objectives:
1. Recognize which menus appear and disappear as you click within or outside of a pivot table. 2. Identify the mouse action that enables you to reconstruct the underlying pivot table source data. 3. Recognize how to enable or disable the GETPIVOTTABLE feature in Microsoft Excel.
For More Objectives:
If you are unable to view PDF then right click the mouse and click save link as
Profession
NASBA: Yes
QAS: Yes
CPA: Suitable for all CPAs
IRS: No IRS credit for Enrolled Agents.
Profession Identifiers: CPA