Modeling with Pivot Tables in Excel

Location: Online Webinar (Zoom, WebEx, Google Meet, MS Teams)

Objectives:

Pivot tables are a powerful summarizing tool in Microsoft Excel that can help the user quickly extract and view data from a large data list of information.  This seminar will help you develop analysis models and reports with your existing workbooks.

You will also learn how to produce eye- catching dashboard using a combination of pivot tables, pivot charts and Slicers.  You will also learn how to use tables in Excel to efficiently manage changes to pivot tables and their data sources.

Learning Objectives:

1. Pivot Table Concepts
2. Pivot Table Tab
3. Formatting
4. Pivot Table Options
5. Pivot Charts and Tables
6. Calculated Fields
7. Dashboard Development