If Carlsberg did formulas

“Logic will get you from A to B. Imagination will take you everywhere.” ~ Albert Einstein

On a coach full of inebriated colleagues being dropped off after a Christmas party, I was once asked “What’s your favourite Excel function?” This led to an extended discussion about the merits of the various usual suspects and some more esoteric options, only stopped short by the arrival at my stop. This speaks loudly to the type of conversations I attract (and revel in). In today’s post I champion SUMPRODUCT and how it blossoms beyond its mathematical roots.

Continue reading

Plunging into Pivots

“I’m not confused. I’m just well mixed.” ~ Robert Frost

One of the most requested topics when I’ve run Excel upskilling sessions has to be Pivot tables. When asked what people want to do with them the typical reply is something like “I just don’t get them.” Do you find yourself saying or hearing this as well? Lets dive in and have a look at pivoting data.

Continue reading