Who should attend
This live online interactive Excel Pivot Tables course will take you from beginning to advanced data analysis techniques. Participants will learn how to properly organize data; analyze and summarize data quickly using data mining techniques, VLOOKUP and PivotTables; develop savvy visualizations with PivotCharts; and analyze data across multiple worksheets and data sets through PowerPivot and data modeling.
Module 1: Creating and Managing Pivot Tables Pivot Tables Basics
1. Organize and clean data in spreadsheets for pivotable analysis
2. Managing and updating pivotable source data to display new values.
3. Editing pivotable report formats and settings
Module 2: Advanced Pivot Table Strategies Custom Pivot Table Design
1. Use PowerPivot to connect data sources
2. Format default layout for pivotable reports
3. Create a data model and pull data in from various tables for pivotable analysis