Friday, May 16, 2008

PivotTables And Excel

Thanks to the kindly Man from Mars and some schoolin' he gave me a few months back, I was able to "brave" the frightening world of Excel PivotTables just far enough to solve a reporting challenge that Vicki had for work.

It was a fairly simple problem: sum up the contents of two columns, and total up the number of unique combinations between them. In fact, it's probably the most basic use you'd ever put a PivotTable to, and yet it still took us close to 15 minutes to figure out how to do it! In the end, though, we got exactly what Vicki needed, and that's all that matters!

Somedays I feel less useless than others...

2 comments:

Mike Marsman said...

woohoo! glad i'm useful for somethings... ;)

pivots are a great excel tool - and can be really powerful for interpreting a lot of data and manipulating views of it on the fly. i do find that, if i haven't used the function over the past few weeks, i always spend about 10mins asking myself "how does this work again"?

Anonymous said...

And the 15 minutes of puzzling over it was very much appreciated!