Digging Deep with Excel Pivot Tables

Overview

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.

Highlights

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

Prerequisites

A basic understanding of Microsoft Excel

Designed For

Excel users at all levels who want to enhance efficiency when analyzing and reporting data

Objectives

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

Preparation

None

Notice

This course is provided by a third-party vendor. Please note that login instructions will not be available in the ‘My Upcoming CPE’ section of the NESCPA website. Instead, the login instructions will be sent directly to you via email by ACPEN. Upon completing the course, your hours will be recorded in the ‘My CPE Tracker’ section of the NESCPA website.