One of the biggest advantages of Python in Excel is that it brings more advanced analytical tools directly into the workbook environment where so much business data already lives. Time series analysis …
Python in Excel: How to forecast time series data with ARIMA
In a previous post, we looked at how Copilot in Excel can help us build an ARIMA forecast with Python. That approach has some real advantages: Copilot can help generate code, explain unfamiliar …
Continue Reading about Python in Excel: How to forecast time series data with ARIMA →
How to evaluate forecast accuracy in Excel, Part 2: Using Copilot
In a previous post we built and evaluated forecasts in Excel using native Excel functions and features: We split the data into training and testing sets and used MAE, RMSE, and MAPE to measure …
Continue Reading about How to evaluate forecast accuracy in Excel, Part 2: Using Copilot →
Python in Excel: How to do time series decomposition
When analyzing financial or accounting data, you’ve likely noticed that many key metrics follow seasonal patterns: think monthly sales spikes, quarterly revenue fluctuations, or annual budgeting …
Continue Reading about Python in Excel: How to do time series decomposition →