Analyzing Data with Pivot Tables
Learn how to do simple data analysis by building pivot tables from scratch in Excel. Easily turn large data sets into charts and graphs to uncover insights.
Meet Your Instructor
-
Nic Barnhart
Cofounder & CPO, Pareto Labs
Finance/Analytics, ZipRecruiterNic Barnhart is a cofounder and Chief Product Officer at Pareto Labs. Prior to that he was in finance and analytics at ZipRecruiter and head of operations at a health tech startup acquired by Aetna. Earlier in his career, Nic started a business to teach kids basic finance concepts and founded a nonprofit organization to fund efforts to combat human trafficking. He earned a B.S. from the United States Air Force Academy and an MBA from The Wharton School at the University of Pennsylvania.
Curriculum
01 Introduction to Pivot Tables
Understand what pivot tables are and how they make data analysis so simple that anyone can do it!
02 Finding the Best Selling Products
Build a pivot table from scratch in Excel through a practical example.
03 Discovering Seasonal Impacts
Modify the pivot table to uncover additional insights through a second example.