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 ...
Reporting lots of large values in Excel is probably a good thing, but if you want them to be readable, try this easy technique. The article, Use a custom format in Excel to display easier to read ...
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 the top ...