GCFLearnFree.org

This site covers more than I ever dreamed.”

Online Learner

GCFGlobal.org
Creating Opportunities For A Better Life.®
  • All Topics
  • Excel 2007
  • Creating Pivot Tables

Excel 2007

Single page view print copy

Creating Pivot Tables

Challenge!

Use the Company Sales workbook to complete this challenge.

  • Create a PivotTable 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 these two regions?


previous next
previous 1 2 3 4 5 next
Terms Of Use

©1998-2014 Goodwill Community Foundation, Inc. All rights reserved.