Using NumXL - NumXL Articles

On this page, find free resources on using NumXL functions and wizards in Microsoft Excel for data analysis and forecasting.

Featured image for interpolation 101 blog.

Interpolation 101

In this issue, we tackle the Interpolation function in NumXL using an example + FAQs for different methods (e.g., step, cubic spline, etc.).

Read More »
Image depicts Philae - an island in the reservoir of the Aswan Low Dam, downstream of the Aswan Dam and Lake Nasser, Egypt

Hurst Exponent in Excel

What exactly is the Hurst Exponent? How do we use it in Excel? And how do we interpret the calculated values? In our latest issue of Tips & Tricks, we will go over the Hurst exponent in-depth to help you develop intuition and insight into the subject.

Read More »
Featured image for the Back-testing in Excel blog.

Backtesting in Excel

The article is about how to do Backtesting in Microsoft Excel, it’s modeling refers to a predictive model’s testing using historical data.

Read More »