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
• 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.