GCFLearnFree.org
Goodwill Community Foundation International
Skip Navigation Links Home > All Topics >
Microsoft Office
 >
Office 2007
  • Use Information Correctly
  • SkyDrive and Office Web Apps
  • Google Drive and Docs
  • Office 2013 
  • Office 2010
  • Office 2003
  • Office XP
  • Office 2000
  • Career
  • Computers
 >
Excel 2007
  • Use Information Correctly
  • SkyDrive and Office Web Apps
  • Google Drive and Docs
  • Access 2007
  • PowerPoint 2007
  • Word 2007
 >
Lesson 18
  • Lesson 1: Setting Up Your Excel Environment
  • Lesson 2: Starting a Workbook
  • Lesson 3: Modifying Columns, Rows, & Cells
  • Lesson 4: Formatting Text
  • Lesson 5: Creating Simple Formulas
  • Lesson 6: Working with Cells
  • Lesson 7: Printing Workbooks
  • Lesson 8: Creating Complex Formulas
  • Lesson 9: Working with Basic Functions
  • Lesson 10: Sorting, Grouping, and Filtering Cells
  • Lesson 11: Formatting Tables
  • Lesson 12: Aligning Text
  • Lesson 13: Working with Worksheets
  • Lesson 14: Using Templates
  • Lesson 15: Using What‑If Analysis
  • Lesson 16: Working with Charts
  • Lesson 17: Using Conditional Formatting
 >
Page 5
  • Page 1
  • Page 2
  • Page 3
  • Page 4
Printable
Version

Excel 2007

Creating Pivot Tables

5 of 5
Tweet

Challenge!

Use the Company Sales workbook to complete this challenge.

  • Create a pivot table report that calculates the amount each salesperson sold.
  • Filter the report by region.
  • View the data for the salespeople in the North and West region.
  • Who sold the greatest dollar amount in those two regions?


Back 5 of 5 Next
 
About Us | Site Map | Terms of Use | Support | Educators | Spanish | Donate | Classes | My Account
©1998-2013 Goodwill Community Foundation, Inc. All rights reserved.