Excel Tips
August 30, 2017
Excel Distinct Count or Unique Count. Pivot tables will offer a distinct count, if you check one tiny box as you create the pivot table.
Excel Shortcut - Close Workbook »
August 29, 2017
Here is a quick way to close the active workbook in Excel. You won't close Excel. Just the active workbook.
Eliminate VLOOKUP with Data Model »
August 29, 2017
Avoid VLOOKUP using the Data Model. So, you have two tables that need joined with VLOOKUP before you can do a pivot table. If you have Excel 2013 or newer on a Windows PC, you can now do this simply and easily.
Excel Shortcut - Snap to Grid »
August 28, 2017
So you are drawing some shapes in Excel and you need them to line up with the Excel grid. Snap to Grid is the answer.
August 28, 2017
Do you hate Excel's GETPIVOTDATA function? Why does it appear? How can you prevent it? Is there a good use for GETPIVOTDATA?
Excel Shortcut - Add Filter Dropdowns »
August 25, 2017
Excel keyboard shortcut for turning on the filter dropdowns in Excel.
August 25, 2017
Before going to the web, make your dashboard look less like Excel
Excel Shortcut - F4 to Repeat »
August 24, 2017
My favorite shortcut in Excel is F4 to Repeat the Last Command. If you are stuck with deleting hundreds of tiny columns between the columns, this command is awesome.