Excel Pivot Tables - Dissecting and Analyzing Your Data

Event description

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 PivotTable’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: Jerry Rosenthal, ComputerImages.com