For a finance team, finishing the spreadsheet is often just one part of finishing the report. Someone still needs to explain a variance, follow up on a question from the review meeting, draft the …
How to choose an AI model in Copilot in Excel
You open Copilot in Excel to get some work done.... Now there's another decision to make: which AI model should you use? Microsoft is adding more choices. In September 2026, it announced Grok …
Continue Reading about How to choose an AI model in Copilot in Excel →
How to build a better run rate analysis with Python in Excel
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 …
Continue Reading about How to build a better run rate analysis with Python in Excel →
How to do survival analysis with Python in Excel
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 …
Continue Reading about How to do survival analysis with Python in Excel →
How to build custom fiscal calendars with Python in Excel
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 …
Continue Reading about How to build custom fiscal calendars with Python in Excel →
How to explore your Python in Excel environment
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 …
Continue Reading about How to explore your Python in Excel environment →