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.

The Ode to the Pivot Table