IUPUI

This workshop lasts 3 hours, and is part of the certificate series Excel 2010 Advanced End-User

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, perform various summary techniques when displaying data, and how to create pivot charts. This workshop will also explore more advanced techniques such as how to group items in pivot tables and how to create calculated fields. The slicer tool will also be introduced.

    What You'll learn Available Downloads

• create, modify, and format pivot tables

• use summary functions and customized calculations

• group numbers and dates

• create filters and slicers

• link and update pivot tables

• create pivot charts

• Workshop Materials (PDF)

• Exercise Files (Win) (ZIP)

What you need to know

• navigate an Excel spreadsheet

• create basic formulas

• work with subtotals

• sort and filter data

• work with tables

• manage named ranges

If you don't have those skills, consider first taking the workshop:

• Excel 2010: The Basics