Excel Pivot Tables - Dissecting and Analyzing Your Data June 8, 2022, 10:00am EDT June 8, 2022, 11:00am EDT

Pivot tables give you the power to digest and analyze large quantities of
data, both to produce periodic reports and uncover secrets underlying your numbers.
This live, one-hour session will show you how to structure your data for analysis and
build Pivot Tables and Pivot Charts.
Demonstrations and explanation will cover:
 What Pivot Tables are and what they can do;
 How to organize data into fields and records for Pivot Table analysis;
 Building a Pivot Table from scratch;
 Ways to view the same data from different perspectives by changing a Pivot
Table’s structure;
 Filtering Pivot Table data;
 Pivot Table calculations;
 “Drilling Down” to reveal the data underlying a calculation;
 Creating Pivot Charts; and
 Refreshing Pivot Table data and changing the data source.
There will be plenty of time for questions, so come prepared.

Presenter: Gerald Rosenthal, ComputerImages.com

Excel Pivot Tables - Dissecting and Analyzing Your Data