• Get Data›
• Microdata↓
  • DLI -- see Mediated Access
  • ICPSR Direct
  • Equinox
  • LANDRU
  • Roper Center
• Tabulations↓
  • Canada Food Stats
  • Canadian Business Patterns
  • Canadian Centre for Justice Statistics
  • Canadian Education Tables
  • Census 1996
  • Census 2001
  • Census 2006
  • DLI -- see Mediated Access
  • E-STAT
• Time Series↓
  • Canadian Business Patterns
  • CANSIM II
  • CRSP
  • DLI -- see Mediated Access
  • E-STAT
• Mediated Access↓
  • Metropolis
  • Research Data Centre
• Data Software↓
  • Beyond 20/20
  • Excel Pivot Tables
  • SAS
  • SPSS

Excel Pivot Tables

What are Excel Pivot Tables?

Pivot tables are interactive worksheet tables that make it possible for you to manipulate, summarize, and analyze data from existing Excel tables. A PivotTable report is a cross-tabulated Excel report that combines and compares large amounts of data. You can rotate its rows and columns to see different summaries of the source data, and you can display the details for areas of interest.

How to Use Excel Pivot Tables?

You must have Microsoft Excel installed on your computer in order to create a pivot table. For more information about pivot tables, see Microsoft Office Online Assistance. For step-by-step instructions, a PivotTable Wizard can be invoked within Excel.

Excel on Campus

Excel is found on all computers in all A.I.C.T computer labs.
For a list of labs on campus, download: AICT Labs Summary 2005.
For lab hours, please consult lab schedules.