Excel Power User Module 9: PivotTable Wrap-Up and Web Data (2 hours) – On-Demand Webcast

Overview

This session concludes the PivotTable discussion by examining various ways to present report values; discussing the subtly of properly sorting a recurring-use PivotTable; and covering numerous filtering options, including slicers. Next you’ll explore the look-up function designed specifically to retrieve values from PivotTables. The session concludes by transitioning to data acquisition techniques, and you’ll retrieve data from perhaps the largest external data source of all-the Internet. This is part 9 of a 10-part series Module 1: Fundamental Features Module 2: Fundamental Functions, Concepts, Techniques Module 3: Six Critical Excel Functions Module 4: Handling Errors and Comparing Lists Module 5: Date and Text Functions Module 6: Time-Saving Techniques Module 7: Introduction to PivotTables Module 8: PivotTable vs. Formula-Based Reports Module 9: PivotTable Wrap-Up and Web Data Module 10: Getting, Preparing and Summarizing Data

Highlights

• Show values as
• Sorting
• Filtering
• Hybrid reports with GETPIVOTDATA
• Web data

Prerequisites

Excel Power User Modules 8 or knowledge of the topics covered

Designed For

Accounting professionals who use Excel for Windows.

Objectives

• State the process for displaying PivotTable report values as a percentage of the report total.
• Identify the default sort order of a PivotTable.
• Recall three ways to filter a PivotTable report.

Notice

“Adding to Calendar” does not register you for this event. Please either register online by clicking “Add to Cart” or contacting OSCPA at 503-641-7200 / 800-255-1470, ext. 3. Thank you!