1. Technology
You can opt-out at any time. Please refer to our privacy policy for contact information.
Ted French

Excel Pivot Table Tutorial

By June 1, 2012

Follow me on:

Excel Spreadsheet Pivot Tables
Excel Pivot Tables
© Ted French

A pivot table is a great tool for sorting and summarizing the data in a worksheet 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, read the Excel Pivot Table Tutorial.

Related Tutorial

April 9, 2012 at 10:43 pm
(1) Bukkake Tube says:

Great post. I was checking continuously this weblog and I’m impressed! Extremely helpful information specifically the remaining part :) I take care of such info much. I was looking for this particular info for a long time. Thank you and best of luck.

June 7, 2012 at 9:42 am
(2) K.T.JAGAN says:


The tutorials posted are extremely good and easy to learn. Thanks for all the efforts put in for the learning fraternity. Knowledge is super power and it is more powerful when shared. Keep providing such good work!!!

July 14, 2012 at 3:18 am
(3) Kris says:

It’s a nice tutorial and good explained. Are there also some tutorials on how to use pivot tables with two or more tables? That would be great!

September 11, 2012 at 9:42 am
(4) Larry says:

You know you’ve created a good tutorial when someone named Bukkake Tube leaves a comment saying so. xD

November 14, 2012 at 4:33 am
(5) Kshirod Nanda says:

Its good to learn and request you all to follow

December 6, 2012 at 3:42 pm
(6) Oli Clay says:

I think the people making the comments might want to also check out an English grammar tutorial.

January 9, 2013 at 11:51 am
(7) Kim says says:

You guys are funny! Ok, back to Pivot Tables…good tutorial; very helpful. Thanks!

February 6, 2013 at 9:05 am
(8) tsion says:

Pretty easy actually!! Well done and thanks for this great tutorial.

February 9, 2013 at 10:55 am
(9) Jude Fernando says:

Thanks to you i have grabbed many things from this site..

February 11, 2013 at 7:55 pm
(10) UNKNOWN says:

Nice tutorial. Do you have tutorial that shows Pivot table with two different workbooks? Love to see the power of excel.

February 17, 2013 at 5:27 am
(11) Nee says:

Thanks…Your tutorials are helpful

July 12, 2013 at 12:02 pm
(12) gloria says:

us there any way in Excel 2007 to perm change the pivot tabel style to classic view?

September 30, 2013 at 12:08 pm
(13) Israel says:

As everyone has previously stated: Thank you!

I appreciate you taking the time to offer such concise and easy to follow instructions.

October 3, 2013 at 7:38 am
(14) Pivot Table in Excel says:

Although this series is a little bit outdated, the basics for setting up your pivot table are still true. This has once (in Excel 2003 days) introduced me to the wonderful world of data analysis using pivot tables.

Additionally I must say, this is the one advanced tool every serious data analyst should master, even since it has become so much more powerful with Excel 2007 and then finally PowerPivot in Excel 2010.

October 7, 2013 at 6:02 am
(15) Joe Hayes says:

Bukkake Tube! Honestly? what a username!

May 16, 2014 at 3:22 am
(16) John says:

When I set up the pivot table as shown on pg 6 I get zeroes showing in my table. I am using Excel 2007. I assume there is some way to show the correct values. Can you tell me what I am doin wrong please?

Leave a Comment

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

©2014 About.com. All rights reserved.