Lesson 3: Pivot Tables

January 27, 2022

Review:

  • Attendance
  • Data Analysis in Spreadsheets

Presentation:

Assignment:

  • Complete Chapter 1 of Pivot Tables in Spreadsheets
  • Complete assembly of the Colorado County data set with all 64 counties assigned to one of 14 economic regions
  • Create a Pivot table summarizing GDP and Population by economic region (your pivot table should have 14 rows)

Justin

Justin Holman is CEO of Aftermarket Analytics, where he leads efforts to develop cutting edge sales forecasting and inventory optimization technology for the Automotive Aftermarket. Prior to joining Aftermarket Analytics, Justin managed corporate consulting for the Strategy & Analytics division at MapInfo Corporation, leading major projects for retail clients including The Home Depot, Darden Restaurants, Bridgestone-Firestone, Sainsbury’s and New York & Company. Before that, Justin served as Vice President of Software Development at LogicTools, now part of IBM's supply chain application software group. Justin holds a B.A. from Claremont McKenna College, a Ph.D. from the University of Oregon and an Executive Management certificate from Northwestern University's Kellogg School of Management.

Leave a Reply