There's a lot going on in these formulaic conditional rules in Microsoft Excel that highlight the smallest and largest values within a period of years.

Learn what Value at Risk is, what it indicates about a portfolio, its pros and cons, and how to calculate the VaR of a portfolio using Microsoft Excel.