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.

How Minimum & Maximum in Excel Can Help Manage Finances in a Business. Managing your company's finances helps you assure that you know the state of your accounts receivable and payable, as well as ...

Office expert Susan Harkins teaches you two ways to highlight the lowest and highest values in an Excel row or column.

Functions are the driving force of any Microsoft Excel spreadsheet, generating a single value or an array of results based on certain arguments you input. However, combining—or nesting—functions ...

Excel's conditional formatting lets you formats cells based on the value of those cells or their formulas. Learn the basics of this amazing feature.

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.