Excel Illuminated: PivotTables – Part 2

Course Information

(No Reviews Yet)

Title:	Excel Illuminated: PivotTables – Part 2
Category:	Computer Software
Field of Study:	Computer Software and Applications
Course Code:	S020-0702
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