Who should attend
This class is for users familiar with standard Excel features but who need more efficient and powerful ways of manipulating their data. Others may have inherited pivot tables, and want to understand and modify them.
Pivot tables are arguably Excel's most powerful feature, and most likely to impress your boss. At first glance, pivot tables seem quite mysterious: with a quick drag-and-drop, your data somehow reorganizes itself into interesting groupings and useful totals. There are more than a few organizations whose critical business decisions rely on carefully designed pivot tables. Unfortunately, because they accomplish so much behind the scenes" it's hard to figure out how pivot tables actually work — and scary to try to modify existing ones. That's where our trainers come in: they love nothing more than demystifying tricky features like pivot tables. After this class, you'll be the one creating pivot tables to capture insights about your company's data. Here's what you'll learn:
Module 1: Creating and Managing Pivot Tables
1. Organize and clean data in spreadsheets for pivot table analysis
2. Manage and update pivot table source data to display new values
3. Edit pivot table report formats and settings
Module 2: Advanced Pivot Table Strategies Custom Pivot Table Design
1. Use Power Pivot to connect data sources
2. Format default layouts for pivot table reports
3. Create a data model and pull data in from various tables for pivot table analysis
"It was very easy to follow along and I learned a few new tricks."
"Loved learning about creating tables, how to add data/see it update and using the duplicate finder tool. Our instructor did a great job, in my previous role I was an educator and taught tech, so I know good teaching and engagement, great work! A+"
"It was a great course and I really enjoyed Josh’s ability to be engaging and keep your attention. Overall, I rate Josh 10/10 and would recommend courses from him to colleagues, friends working in other companies and even to some fellow grad students!"
"Mo was amazing. Did not feel rushed. Very informative and interactive. I want him to teach all the classes offered through my organization."
"Josh was great. Very patient, great pace, and passionate about helping us learn."