Treasurer Hunt Directions: “PivotTable”

An exercise to build skills and apply them in a real-life situation.

Create a PivotTable that can be used to analyze data.

 Go to

Search by Keywords:  pivot table
You’ll use info in this article for all steps below.

  1. Read this article to learn the new terminology you’ll need in Pivot Tables.

Watch Microsoft’s “First Time” tutorial.

  1. See how Microsoft explains the new concepts and how a pivot table is created. To find the tutorial, in Excel: go to File, New, “Make Your First Pivot Table”

Identify the spreadsheet you want to work with.

  1. Find where the data is you want to analyze.  Be sure you’ve read the Tech-Talk article on pivot tables for ideas.

Create a list of questions that you want to be answered about your data.

  1. Write down a list of possible questions and info to get started.

Open the spreadsheet with the data you want to analyze.

  1. Make sure each column has a header and that the data is clean and complete so that your analysis is accurate.

Create a pivot table

6. Within your open spreadsheet, choose Insert, Pivot Table or Recommended PivotTables.  You’ll find it in a separate worksheet with your workbook. (Watch Excel: Make Your First Pivot Table.)

Hey, do you want to see how much you learned?

  1. Take the TRIVIA CHALLENGE.  See how many questions you get. You’ll find the answers in the articles above.