From
$145 – $290
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
Topics:
Module 2: Advanced Pivot Table Strategies Custom Pivot Table Design
Topics:
"It was very easy to follow along and I learned a few new tricks."
"Josh was great. Very patient, great pace, and passionate about helping us learn."
"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."
"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+"