Modeling with Pivot Tables in Excel – OCTOBER
October 23, 2020 @ 10:00 am - 12:00 pm| $199.00
Modeling with Pivot Tables in Excel
Location: Online Webinar (Zoom, WebEx, Google Meet, MS Teams)
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.
- Pivot Table Concepts
- Pivot Table Tab
- Pivot Table Options
- Pivot Charts and Tables
- Calculated Fields
- Dashboard Development