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