Analytics & AI for Modern Excel
Many business and data analysis questions ultimately come down to one basic comparison: Which values appear in one table but not another? In accounting, that might mean finding invoice numbers …
Continue Reading about How to find unmatched items with Python in Excel →
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 →
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) →
One of the biggest advantages of Python in Excel is that it brings more advanced analytical tools directly into the workbook environment where so much business data already lives. Time series analysis …
For some time now, I've been encouraging people to check their public libraries for access to LinkedIn Learning. In fact, I even wrote a post about it. But shame on me, because I wasn't sharing …
Continue Reading about How to access my O’Reilly content for free through your public library →
If you are coming up as a new analyst right now, the picture you are getting from outside the field has to be confusing. You read every other day that AI is about to flatten finance, that the analyst …
Continue Reading about How new Excel users can set themselves apart now →
