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 - 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 - Flash Fill (Video)

In older versions of Excel, if you wanted to extract data from cells or combine data from cells you had to use formulas. Now you can use a really handy technique called ‘Flash Fill’ without the use of formulas...

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…

Excel Tip - Quick Table Shortcut

One of the most powerful features in Excel is to convert a range of data into a Table. You can create a table via the Home tab or via the Data tab but there is also a quick keyboard method, which is a lot faster...