Want to keep yourself up to date with the latest news from Stringfest Analytics?
Subscribe using the "Follow" button below and we provide you with customized updates, via topic or tag, that get delivered to your email address, your smartphone or on your dedicated news page on follow.it.
You can unsubscribe at any time painlessly.
Title of Stringfest Analytics: "Stringfest Analytics - Analytics & AI for Modern Excel"
Is this your feed? Claim it!
A run rate can be as simple as taking the latest month and multiplying it by 12. That simplicity is also exactly why run rates can be misleading.
If August is normally a soft month, annualizing August can make the business look weaker than it really is. A three-month average may smooth things out, but it can still be distorted by quarter-end billing. A seasonality-adju...
Ever tried to figure out how long it takes your customers to pay their invoices?
At first, this sounds pretty straightforward. Take the invoices that have been paid, calculate the number of days between the invoice date and payment date, and find the average.
But what about the invoices that haven’t been paid yet?
Ever tried to figure out how long it ...
Excel analysts can spend a surprising amount of time teaching Excel how their company’s calendar works.
The calendar says the year starts in January. Your company might say it starts in July. A week is seven days, but your reporting process may care very specifically about which day that week starts. Then there are month-end cutoffs, fiscal quarters, reporting periods,...
Once you’ve been working in a Python in Excel workbook for a while, it’s easy to lose track of what you’ve already created: was the DataFrame called sales or sales_df? Did the tax rate come in as a number or a one-cell DataFrame? Is that region list still there?
In something like VS Code or Spyder, you’d normally have an environment pane off to the side showing you the...
Microsoft licensing and availability can be, let’s say, a little complicated.
And with a tool like Python in Excel, essentially one tool sitting inside another, it is reasonable to wonder: Do I already have access? Do I need to pay extra? Are there licensing limitations I should know about?
In this post, I want to briefly walk through how Python in Excel availab...