PivotTables (Excel)

Contrary to popular opinion, PivotTables are not difficult to understand; they are a powerful tool that can be created and utilized simply and easily. In fact, the purpose of PivotTables is to simplify data analysis.

This course is perfect for those of all comfort levels. No previous experience is assumed or required.

Areas covered:

Introduction – Overview of Excel, Overview of Tables and Data

Building a Pivot Table– Basic Concepts, Preparing Data, Understanding Fields, Value Fields, Row Fields, Column Fields

Using a Pivot Table– Filters, Formatting, Pivoting, Slicers, Timelines, Updating & Refreshing PivotTables

Question & Answer