This class teaches you to use Microsoft Excel Pivot Tables to easily find important information in big data sets. Pivot Tables let you compare data and get answers without needing to write new formulas, copy and paste, or reorganize columns or rows. You'll also learn how to make basic tables and charts from an Excel sheet.

Performance Objectives: Upon completion of this course, you should be able to:

• Create and customize Pivot Tables.
• Nest fields.
• Group data.
• Calculate and customize statistics.
• Filter data.
• Use slicers.
• Create and customize Pivot Charts.

Prerequisite: You need to have a good understanding of and experience with Excel tables, charts, and formulas prior to this class.

Intended Audience: All audiences.