Excel Formulas

In investment analysis, value-at-risk, called VaR, is a measure of investment risk. Let’s learn how to do backtesting VaR in Microsoft Excel.

Ever needed to generate a full array of random values in Excel? This is a great way to test out formulas. Here's how to use RANDARRAY in Microsoft Excel.

True range is an indicator often used to measure volatility of investments such as stocks. Let’s learn how to calculate ATR in Microsoft Excel.

The concept of arrears refers to money owed that should have been paid in the past. Let’s learn how to calculate arrears in Microsoft Excel.

Akaike’s Information Criterion, or AIC for short, is a commonly-used statistical measurement. Let’s learn how to calculate AIC in Microsoft Excel.

Microsoft Excel’s Research tool is a useful feature designed as a reference aid. Let’s learn how to disable Research in Microsoft Excel.