Stringfest Analytics

(Before you read this, if you want to try these out in Excel for yourself, download the exercise file below. It includes the sample data and the Python snippets from this post, so you can actually run the examples instead of just nodding along politely.)

If you sell Excel training for a living, you learn pretty quickly that there are two very different doors you can knock on inside a company.

One door is HR, or more specifically Learning and Development.

The other is the business itself: the CFO, controller, FP&A manager, operations lead, or whoever actually owns the spreadsheets, reports, deadlines, and rec...

A two-way lookup is one of those everyday data tasks where Excel gives you plenty of options, but none of them feel totally satisfying. It is hard to avoid some messy nesting, usually involving a mix of INDEX(), MATCH(), lookup functions, and more.

Somewhere in the middle of a discovery call, it is easy to feel yourself shrink.

The client starts describing a real problem: their analysts are drowning in manual work, the monthly close takes too long, nobody trusts the workbook… and too many people copying and pasting data because, at some point years ago, that became “the process.”

And instead of saying, “Ye...

The hardest part of running a data training session is rarely the material, pacing, or expectation setting.

The hardest part of running a data training session is rarely the material.

It is often the first ten minutes, when everyone opens their laptops and finds out whether the tools and files in front of them actually work.

That ...