Pivot Tables - Excel Magic


Visitors: 492

Pivot tables are magic. For those of us who know how to use pivot tables, we can’t imagine using Excel without them. If pivot tables and their potential are a mystery to you, this article will help.

First, explaining pivot tables without using pictures in this article is a bit like explaining the Internet to cowboys in the 1800’s. It’s hard. But I’ll give you two explanations that will help: one technical and one metaphor.

A technical explanation is that pivot tables sort and count. If you have 30 salespeople that work for your company throughout the country, you might want to sort all of your monthly sales by salesperson and then SUM all the sales for each salesperson. If you don’t know pivot table technique but you do know how to sort in Excel, the salesman summary problem is doable but tedious. You sort the salesman and their sales, and then you do some basic but repetitive formulas to sum sales for each salesperson. It is doable.

But then the sales manager hears of your good work and asks you to sum not only by salesperson but by sales region. Your sorting and summary techniques that worked for salespeople is very difficult to sort and sum by salesperson and region. You need to learn pivot tables.

But pivot tables are much more than a technical answer to a request from your sales manager. Pivot tables are a revealing tool of analysis for your business or organization. Here’s an information metaphor of why pivot tables are a great research tool for numbers and information.

In my backyard, there’s a big pine tree right adjacent to the deck. It’s autumn now as I sit by my tree. Visually, from the side, the tree is green, with no movement. But I hear many birds chattering in the tree as they settle in before sunset. If I walk underneath the tree slowly, I can see birds flying about within the tree branches. I’m sure my tree would look different from the top.

What’s my point?

If my pine tree were a spreadsheet, I could look at it from the top, bottom, side or even fold it inside out to examine it for data. And for birds.

Pivot tables are a bit of Excel magic. It all begins with a common looking spreadsheet with columns of data and hundreds or thousands of rows. It might be a sales spreadsheet or expenses spreadsheet.

The sooner you learn how to use pivot tables, the sooner you will reap the benefits of turning common business data into useful information. The pine tree in your backyard will never look the same to you again.

Visit Richard's website at http://TheWorldsShortestExcelBook.com to sign up for some free Excel training courses. Richard is an author of Excel e-books and training videos. If you need help with pivot tables today, go to http://www.techspectrum.com/twseb-pt.htm for assistance.

Finally, if you need on-site advanced Excel training for your company, please visit http://www.techspectrum.com/AET.html for further information. Thank you.


Article Source:

Rate this Article: 
Magic, Clown Magic, and Magic in Clowning - What's the Difference?
Rated 4 / 5
based on 5 votes

Related Articles:

Excel Quick and Easy Pivot Tables

by: Frances Christ (June 18, 2008) 
(Computers and Technology/Software)

Excel 2007 Training - Isn't About Time You Upgraded Your Excel Skills?

by: Jack G. Elliott (November 19, 2008) 
(Computers and Technology/Software)

Using Excel to Organize Your Browsing Discoveries (Create a Mini-Database Using .

by: John V. W. Howe (February 18, 2007) 
(Internet and Businesses Online)

Excel Programmer – Excel Automation for businesses

by: Steve Das (December 13, 2012) 
(Business/Small Business)

Excel: Five Issues to Consider When Developing an Excel Template

by: Chris Le Roy (December 31, 2006) 
(Computers and Technology)

Excel Tutorial - The Secret to Excel

by: Richard Kraneis (October 22, 2005) 
(Computers and Technology/Software)

Billards Tables and Pool Tables Primer

by: Anne Clarke (July 11, 2008) 
(Recreation and Sports/Billiards)

Pub Tables - Perfect Accent Tables

by: Jennifer Akre (August 01, 2006) 
(Home and Family/Interior Decorating)

Forex Pivot Points - What is the Forex Pivot Points?

by: Simon Aridej (February 03, 2008) 
(Finance/Currency Trading)

Magic, Clown Magic, and Magic in Clowning - What's the Difference?

by: Tom Raymond (June 30, 2005) 
(Arts and Entertainment)