Microsoft Excel’s RANK.EQ() function ranks a set of values, but in a busy sheet, the top-ranking items might get lost. You can combine RANK.EQ() with a conditional formatting rule to highlight ...

There are two ways to calculate a conditional average in Excel, both involve some logic and some special functions.

This week's tutorial covers a number functions in Google's Spreadsheet app, Google Sheets. Here we take a practical look at using weekdays in calculations, introduce 'if' statements and learn how to ...

Manually combing through spreadsheets with large datasets can be a massive headache at times. Luckily, conditional formatting exists in Microsoft Excel specifically for this reason.