Analytics & AI for Modern Excel
Copilot has been around for a couple of years now, and we’ve seen the flood of “Copilot” tools across Microsoft. Many of them have been underwhelming. Even Copilot in Excel, for all its promise, felt …
Continue Reading about How to get started with Agent Mode in Excel →
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 …
As an Excel trainer, MVP, and tech enthusiast, I can tell you firsthand: a ton of VBA code is still out there. Enough that if you're coming into certain sectors (hello, finance!), you'll need to take …
Continue Reading about Copilot for Excel: How to work with VBA macros →
The efficient frontier is a cornerstone of modern portfolio theory, representing the optimal combination of assets that maximizes returns for a given level of risk. Traditionally, building and …
Continue Reading about Python in Excel: How to visualize the efficient frontier →
Excel is essential for finance professionals, who are among its most intensive users. Many recent Excel features, like dynamic arrays, are genuinely transforming how they work. Previously, financial …
Continue Reading about How to build a DCF model in Excel with dynamic arrays →
Excel offers a vast number of functions, and one category that usually requires me to double-check my notes is financial functions—things like calculating loan repayments, future values, and similar …
Continue Reading about Copilot in Excel: How to work with financial functions →
