Pivot tables give you the power to digest and analyze large quantities of data, both to update 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;
How to build a Pivot Table from scratch;
Ways to view the same data from different perspectives by changing a PivotTable’s structure;
Pivot Table data filtering;
The kinds of calculations Pivot Tables can make;
“Drilling Down” to reveal the data underlying a calculation;
Creating a Pivot Chart
Refreshing Pivot Table data and changing the data source.
There will be plenty of time for questions, so come prepared.
Presenter:
Gerald A. Rosenthal, is the founder of ComputerImages, a Boston-based software training and consulting firm, and has been using Excel since the program debuted as Macintosh only software in 1985. ComputerImages offers computer classes and training.