The Easy Data Analysis with Pivot Tables class is a hands-on workshop, scheduled to take half a day. Students are expected to be familiar with working with data in Excel, but not with pivot tables. The class is an introduction to the wonder of Pivot Tables.
- Data Sources
- Excel Data
- External Data
- Working with Pivot Tables
- Pivoting
- Grouping
- Helpful Tricks
- Charting Pivot Data
- Pivot Charts
- Regular Charts
All classes offered by Peltier Technical Services have been developed by Jon Peltier of Peltier Tech. They assume an intermediate level of competency in Excel, and build on this base to develop strong skills. Attendees work on practical examples using their own notebook computers. Class materials include presentations and workbooks, as well as a handful of helpful utilities.
