Excel - Pivot Tables

Excel pivot tables are sometimes thought of as the “holy grail” of Excel—and with good reason. Using excel pivot tables, you can often quickly generate summary reports of your data. What might take you hours to summarize using formulas to find sums, averages, and totals, you can do in minutes with pivot tables. In this session, you'll practice creating pivot tables using a few different types of data. 

Course objectives:  

By the end of this course, participants will be able to:
•    Recognize Pivot Tables in Excel
•    Recognize when Pivot Tables can be used for data summarization and analysis
•    Successfully set up existing spreadsheets to create Pivot Tables
•    Create new Pivot Tables in Excel
•    Modify field selections and options, format data, manage relationships, use calculation fields, and group data in Pivot Tables to create data summaries
•    Insert slicers and timelines to quickly analyze Pivot Tables
•    Create Pivot Charts from Pivot Table summaries
•    Apply styles to Pivot Charts
 

 

Category(s): Office Productivity

---

Prerequisites

We highly recommend that you attend any prerequisite workshops listed below since familiarity with the skills and concepts taught in them is essential to benefit fully from subsequent workshops.

However, if you have independently learned the skills and concepts of the required workshop(s), your "equivalent skills" will be accepted as a substitute for attending the prerequisite workshop(s).

To help you determine your skill level, click workshop titles below (if any) for descriptions which outline the topics taught in each workshop and that are assumed in later sessions. You are expected to know the commands and concepts listed within the descriptions for the prerequisite workshop. In most cases, you can also refer to workshop handouts and other helpful materials from the workshop description page.

In addition to any specific prerequisites listed, you should have, as a minimum, basic computing skills.