Excel Tip - Rounding and Integer Function

Excel has quite a few different rounding functions, but did you know about the INT (integer) function? It’s so simple to use and will always round a value down to the nearest whole number…

Excel Tip - Leading Zeros

Have you tried entering data in Excel with a leading zero; say a part number or a telephone number? Then you’ll have noticed that Excel removes the zero; here’s the solution…

Excel Tip - Select All

Excel has some really handy shortcuts for selecting ranges of data on your worksheet. Find out how to select the active region of cells and much more…

Excel Tip - Compare Files

Have you ever had two different versions of the same Excel workbook, and you need to know the differences?  Here’s the answer…

Excel Tip - Identifying Formulas (Video)

Excel has a really useful shortcut that can automatically identify & select cells containing formulas in worksheets. This is particularly useful when working on others’ data, but also helpful when you suspect a formula may have gone missing…