Pivot Tables Make Everything Just Right

This is a video for a song I wrote about pivot tables. It was for a group project in one of my classes. I recorded it with the other members of the group.

(download for free here: http://www.mediafire.com/?cjaal397gm7xppw)

Lyrics:

Sittin' here I got so much data
Gonna take forever so I think I'll do it later
Calculatin' all these numbers by hand
Can take a whole afternoon and that sounds pretty bland
Until my friend tells me all about the pivot table
Too good to be true, sounds more like a fable
An easy way to organize this data with ease?
Sign me up, teach me how, cuz that's the bees knees

Pivot tables make everything just right
I can use them all hours till the daylight
In a hurry and you don't have forever?
Couple clicks and the numbers come together

A pivot table helps you to condense your information
Into a single table, which limits your frustration
It can sort, it can count, it can give total amounts
It can take a bunch of numbers and then spit an average out
It can make a million bits of information seem compressed
Number crunchers 'round the world know this table is the best
So when you're using Excel and you start to feel unstable
That's information overload, just use a pivot table

Pivot tables make everything just right
I can use them all hours till the daylight
In a hurry and you don't have forever?
Couple clicks and the numbers come together
And when the time comes that I'm finally done
I double check my averages and all of my sums
Cuz tomorrow I gotta use em some more
That's what a pivot table's good for

Category:

Entertainment

Tags:

• pivot
• table
• microsoft
• excel
• ball
• state
• university

[amymill1]

Love your video! We just posted it on the Microsoft Excel Blog!

[youarentbenjamin]

@amymill1 Thanks Amy! My parents have never been more proud.

[TheAnimationEmpire]

Pretty sure your views are mostly Microsoft folks, but I hope not when seeing that your #1 audience is 13-17 year old males. Do high school guys use PivotTables?

LOL at that ipod holder as a boombox. =^)

Great job!

[youarentbenjamin]

@TheAnimationEmpire I don't know where you went to high school. Where I went that's ALL we did.

[jhtrico1850]

pivot best

[wayneIntacart]

And being as Amy didn't put the link here it is blogs.office.com/b/microsoft-e­xcel/archive/2011/05/06/rockin­-out-with-pivottables.aspx

[MissLolien]

I live and breathe pivot tables and I totally love this video! Now when people at work ask me why I've suggested they use a pivot table, they are getting this link sent to them. Great job :)

[mbcowburn]

Simply fantastic - enjoyable entertaining educational!

[vikramyt]

Excellent video!!

[DudeTMMom]

This is EXCELLENT! I do hope you guys got an "A" on your project!

[ExcelIsFun]

So Awesome!!!! I keep wondering why I don't hear this on the radio and why I can't download it on iTunes!?!?!?

[TheAnimationEmpire]

@youarentbenjamin Musta been a different decade. "Computers" was a lax class where we played the snake game. =^)

[jamstawildman]

Gents,

This might just be the most entertained I've ever been when thinking about Excel! I hope MS are giving you a comission for spreading the good word. Can you do one about crosstab queries in Access?