Spreadsheets

  1. Home
  2. Computing & Technology
  3. Spreadsheets
photo of Ted French

Ted's Spreadsheets Blog

By Ted French, About.com Guide to Spreadsheets

Create Excel Pivot Tables

Wednesday August 13, 2008
Excel Spreadsheet Pivot Tables
Excel Spreadsheet Pivot Tables
© Ted French
A pivot table is a great tool that for sorting and summarizing the data in a spreadsheet or database file.

It can automatically sort, count, and total spreadsheet data and then create a second table to display the summarized data.

Once you have finished looking at the summarized data, you can quickly re-sort your data and look at it from a totally different perspective, and all of this can be done without using functions or formulas.

Despite being so useful, many people shy away from using them, on the belief that they are hard to use. They aren’t really, and once you get the hang of them, you’ll use them at every opportunity.

To find out more about this handy tool, watch the video on how to Create Excel Pivot Tables.

Related Articles

Comments

No comments yet. Leave a Comment

Leave a Comment

Line and paragraph breaks are automatic. Some HTML allowed: <a href="" title="">, <b>, <i>, <strike>

Discuss

Community Forum

Explore Spreadsheets

About.com Special Features

Spreadsheets

  1. Home
  2. Computing & Technology
  3. Spreadsheets

©2009 About.com, a part of The New York Times Company.

All rights reserved.