Popular Selections:
academics tabathletics tabstudent life tabfeatured events tab
 

About This Event

Summary

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:             

•             Excel 2013: The Basics

Bookmark and Share

Event Schedule

There are no upcoming dates for this event.