The Ode to the Pivot Table

When you want to drag and drop,

Subject a few arrays to a lookup,

Perform complex statistical analysis,

There’re more to life than this!

Refrain:

Your excel troubles will end,

Make the pivot table your friend,

Then use a standard reference,

Your numbers will always make sense.

Sort them numerically or by alphabet,

Group them into a different set,

Define formulae, ranges and space

Manual calculation will take you days!

Refrain:

Your excel troubles will end,

Make the pivot table your friend,

Then use a standard reference,

Your numbers will always make sense.

When the model undergoes a change,

Due to input or new formula range,

Just remember to press F9

And everything will be fine.

Refrain:

Your excel troubles will end,

Make the pivot table your friend,

Then use a standard reference,

Your numbers will always make sense.

Advertisements

5 thoughts on “The Ode to the Pivot Table

  1. Nice one 🙂 Pivot table is amazing..It has been my savior. Pivots and lookup is what I am doing for the last ten days now for my research…just hoping the numbers will make sense somehow 🙂

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s