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 www.Tech-Talk.com …
Search by Keywords: pivot table
NOTE: You’ll use info in this article for all steps below.
- Read this article to learn the new terminology you’ll need in Pivot Tables.
Watch Microsoft’s “First Time” tutorial.
- 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.
- 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.
- Write down a list of possible questions and info to get started.
Open the spreadsheet with the data you want to analyze.
- 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?
- Take the TRIVIA CHALLENGE. See how many questions you get. You’ll find the answers in the articles above.