Analytics & AI for Modern Excel
This month I crossed 500,000 learners on LinkedIn Learning. And if you add up every cohort, every corporate session, every conference workshop and one-off engagement over almost ten years of doing …
Continue Reading about What I’ve learned by teaching half a million people Excel →
(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 …
Continue Reading about Python in Excel: How to understand data types →
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 …
Continue Reading about How to sell Excel training to HR vs business leaders →
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 …
Continue Reading about How to create a two-way lookup with Python in Excel →
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 …
Continue Reading about How to stop apologizing for your Excel training offer →
The hardest part of running a data training session is rarely the material, pacing, or expectation setting. It is often the first ten minutes, when a room full of people open their laptops and …
Continue Reading about How to run a data training tech check (free downloads) →
