Excel Tips
Excel Shortcut - Convert Text to Numbers »
August 31, 2017
Excel convert text numbers to real numbers. Why aren't my VLOOKUPs working? Why won't this formula calculate? Maybe it is because your numbers are stored as text! Do you see a green triangle in the corner of each cell? If so, this will solve your problem.
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 - See Hidden Cells »
August 30, 2017
Do you think that you've hidden column G in Excel and no one will ever see it? Watch out for the sneaky person who uses F5 to select cells in the hidden column and then gets the data from the Formula Bar.
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 - 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.
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 - 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 25, 2017
Before going to the web, make your dashboard look less like Excel
Excel Shortcut - Add Filter Dropdowns »
August 25, 2017
Excel keyboard shortcut for turning on the filter dropdowns in Excel.