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 to create a real estate dashboard in Power BI, Part 2: Building the dashboard
In a previous post, I showed how to take a tenancy schedule from a real estate brochure PDF and turn it into a Power BI dashboard. In the last post, we focused on retrieving and cleaning the …
How to create a real estate dashboard in Power BI, Part 1: Data cleaning
Later this month I’m running a free webinar with Bayfield Training, a leading provider of real estate and financial modeling courses. Like most industries, real estate can get a big boost from solid …
Continue Reading about How to create a real estate dashboard in Power BI, Part 1: Data cleaning →
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 →