Analytics & AI for Modern Excel
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 →
Whether you're a seasoned financial analyst or a data-proficient professional, understanding the calculation of investment returns can help assess the profitability and risks of various assets. This …
Continue Reading about Python in Excel: How to calculate investment returns →
We often hear as professionals that it's not about the tools we use but about understanding the problem. However, the tools we use fundamentally shape how we see and address those problems. They can …
Continue Reading about How FP&A managers can get more from Excel →
Monte Carlo simulations leverage probability and randomness to simulate processes multiple times, exploring a wide range of possible outcomes. This approach can illuminate the inherent uncertainty and …
Continue Reading about Python in Excel: How to run a Monte Carlo simulation →
One of my favorite applications of Python is time series analysis, particularly through the use of the Pandas package. This package was designed, in large part, to handle time series data in ways that …
Continue Reading about Python in Excel: How to create a running total →
For those interested in learning Python for Excel, a key area to explore is time series analysis. In particular, Python's Pandas package is specifically designed to handle time series data …
Continue Reading about Python in Excel: How to create moving averages →
