Learn how to highlight dates before today and a specific date with and without using the Today() function in Microsoft Excel.

Use Excel's conditional formatting feature to look at a specific cell in the row, determine if it's negative or positive and format the row based on the results.

Deleting blank rows in an Excel data set isn't difficult, but Excel 2016 is the only version that offers predictable results.

Excel has over 475 formulas in its Functions Library, but we've selected the most popular, from date and time functions to mathematics and simple data manipulation.