Excel Tips


Excel Shortcuts - Formula AutoComplete »

August 8, 2017

Why does Excel offer a function name without letting me select the function I want? When I start to type =VLOO in Excel, they know that I want VLOOKUP and even show me VLOOKUP. But how do I select it? Enter returns an error.


Easy Year-over-Year »

August 7, 2017

Start with multiple years of data


Excel Shortcuts - Non-Contiguous Cells »

August 7, 2017

Today's article covers how to select non-contiguous cells in Excel. Sure - you can hold down Ctrl while selecting multiple ranges. But there are other ways.


Copy Subtotals »

August 4, 2017

Copy subtotals.


Excel Shortcuts - Next Worksheet »

August 4, 2017

How to jump to the next (or previous) worksheet in Excel. This is the next in our series of keyboard shortcut tricks for Excel.


Format Subtotal Rows »

August 3, 2017

Excel bolds one column on the Subtotal Rows


Excel Shortcuts - AutoSum »

August 3, 2017

Excel faster way to AutoSum. This is an Excel keyboard shortcut for summing data.


Fill Text on Subtotals »

August 2, 2017

If you need additional text on a subtotal row


Excel Shortcuts - Active Cell »

August 2, 2017

Excel - bring the active cell back in to view. It is easy to find that you can no longer see the active cell. This trick will bring the active cell back in to view.