Analyzing Data with Pivot Tables

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.


  • 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.

Meet Your Instructor

  • Nic Barnhart

    Cofounder & CPO, Pareto Labs
    Finance/Analytics, ZipRecruiter

    Nic 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.