emendatio

We all have to work with excel now and then, some of us more frequently than others. Sometimes the excel file you’ll have to work on is more than just your typical 3 rows 5 columns birthday list comparison… yes sometimes its a huge table with thousands of data entries. In these cases its a pain to get an overview or find a specific data entry, build graphs or just find relevant information. There is of course a way to set filters to hide irrelevant data but a more elegant way is to use Pivot Tables. The Productivity Portfolio blog just published a nice introduction into this topic and explains how to set up a Pivot Table without losing your nerves:

Pivot tables are an Excel feature that you should learn how to use. Instead of analyzing rows upon rows of records, a pivot table can aggregate your data and show a new perspective with few clicks. You can also move columns to rows or vice versa. The problem is people believe creating a pivot table is too difficult to learn. Grab a seat and we’ll walk you through a short tutorial using Excel 2007.

This entry was posted on Wednesday, February 20th, 2008 at 10:25 am and is filed under How-To and Productivity.