XL Edge
A free Excel add-in, and the guides that teach it.
XL Edge puts a library of LAMBDA functions in the ribbon, then builds on it: Monte Carlo simulation from distributions to finished charts, forecasting from seasonal ARIMA to multivariate VAR, regression and statistical diagnostics, bootstrapping and portfolio optimization, and years of productivity macros. The guides below take one tool at a time through a worked example.
Free to use and free to modify, MIT licensed. Windows Excel; the LAMBDA functions need Microsoft 365 or Excel 2024.
XL Edge Guides
One tool, one worked example, every number tied to a workbook.
Each guide is a PDF and an example workbook whose numbers it quotes, so you can follow along cell by cell. The workbooks carry their own functions and calculate without XL Edge installed; they need Excel for Microsoft 365.
BootstrapHow sure are your numbers?9 pages · PDF and example workbookRead the guide
Confidence EllipseAn interval for two variables at once7 pages · PDF and example workbookRead the guide
CopulaWhen your inputs move together11 pages · PDF and example workbookRead the guide
CorrelogramReading a series' memory7 pages · PDF and example workbookRead the guide
Monte CarloShould we build Plant 2?14 pages · PDF and example workbookRead the guide
Multivariate Time SeriesSeries that move together: VAR and VECM10 pages · PDF and example workbookRead the guide
Outliers and LeverageFinding the observations that don't fit7 pages · PDF and example workbookRead the guide
PortfolioThe efficient frontier in four formulas6 pages · PDF and example workbookRead the guide
SARIMAForecasting a series with a yearly rhythm9 pages · PDF and example workbookRead the guide