2024 MSCPA Annual Convention: Details

Digging Deep with Excel Pivot Tables

← Return to The CPE Catalog
Thursday, August 29, 2024 @ 8:00am 9:00am
Add to Calendar

Description

This session focuses on the power of pivot tables within Microsoft Excel. We initially discuss the creation of pivot tables and various ways to summarize information. Then we explore ways to utilize summarized pivot table data. The course uses several practical examples that should inspire participants to find their own creative uses for pivot tables. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Prerequisites

Basic working knowledge of Microsoft Excel.

Highlights

The major topics covered in this course include:

  • Data preparation and cleansing
  • Pivot table creation
  • Pivot table customization
  • Navigating Excel’s PivotTable Analyze tab

Objectives

After attending this presentation, you will be able to...

  • Create a pivot table in Excel
  • Customize a pivot table
  • Utilize output from a pivot table

Preparation

None

Credits

Category Amount
General 1.00