|
Title: Pivot Tables Excel Magic Post by: Daniel Franklin on September 23, 2007, 12:12:37 PM 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. |