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
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:
IT – Informatics & Communications Technology Complex (ICTC)
535 W. Michigan St.
Indianapolis, IN 46202
There are no upcoming dates for this event.