If you work in finance, accounting, or a related field, chances are you’ve had to put together a forecast... and then explain why you built it the way you did. Excel makes that process feel …
Python in Excel: How to understand the random walk with Copilot
As an Excel analyst, you've probably had moments where your data seemed to show clear trends,profits rising, sales dropping, or costs climbing steadily. But sometimes, these apparent patterns might …
Continue Reading about Python in Excel: How to understand the random walk with Copilot →
Python in Excel: How to check Benford’s Law with Copilot
Numbers don’t spread out evenly across digits. In many real datasets, the leading digit “1” shows up about 30% of the time while “9” hardly appears. That’s Benford’s Law. If your numbers don’t follow …
Continue Reading about Python in Excel: How to check Benford’s Law with Copilot →
How I became an Excel trainer… the Stringfest origin story
Whenever I get asked the same thing two or three times, I figure it's worth turning into a post. So I am genuinely surprised I haven't written about how I became an Excel trainer yet. I've written …
Continue Reading about How I became an Excel trainer… the Stringfest origin story →
Python in Excel: How to do price elasticity analysis with Copilot
Understanding how price changes affect customer demand is one of the most valuable insights you can bring to your business. This concept, known as price elasticity of demand, helps answer practical …
Continue Reading about Python in Excel: How to do price elasticity analysis with Copilot →
Copilot in Excel: How to do social influencer analysis with Python
Understanding who your most influential customers are—those who consistently recommend your business—is essential for sustainable, cost-effective growth. This approach, called social influencer …
Continue Reading about Copilot in Excel: How to do social influencer analysis with Python →