Discover how pivot tables can make work tasks easier and how they can be useful in analyzing data. In this workshop, participants will learn how to create, format, and modify pivot tables, and perform various summary techniques when displaying data. This workshop will also explore more advanced techniques such as how to group items in pivot tables and how to create calculated fields. Pivot charts will also be covered.

(Description continued below)

Participants will:

• create, modify, and format pivot tables
• use summary functions
• create customized calculations
• group numbers and dates
• reorder labels and sort values
• link and update pivot tables
• create and modify pivot charts

The following workshops are suggested prerequisites to this workshop:

• Excel: Data Management

Participants should already be able to:

• navigate an Excel spreadsheet
• create basic formulas
• work with subtotals
• sort and filter data
• work with tables
• manage named ranges