Excel Tips


Readable References »

August 14, 2017

VLOOKUP is awesome and my favorite function


Excel Shortcuts - Paste Names »

August 14, 2017

Excel Keyboard Shortcuts: F3 to paste name. This can be useful as you are creating formulas.


Ctrl+T Makes VLOOKUP Better »

August 11, 2017

In the last episode, Ctrl+T made the pivot table source expand


Excel Shortcuts - Show Formulas »

August 11, 2017

Sure, you can see one formula at a time by selecting the cell and looking in the formula bar. But what if you want to see every formula at once? Bring on Show Formulas mode.


MM »

August 10, 2017

To convert Roman numerals to Arabic, use =ARABIC


Excel Shortcuts - Select Whole Column/Row »

August 10, 2017

Excel offers some fast ways to select the whole column or row based on the currently active cell. Today, you will see how to remember each keyboard shortcut.


Pivot Table Why Count »

August 9, 2017

In a perfect world, numeric fields will Sum in a pivot table


Excel Shortcuts - Add to Selection »

August 9, 2017

Add to Selection in Excel. How to use Shift+F8 in Excel to Add to Selection.


Top Five Report »

August 8, 2017

The pivot table Top 10 Filter gives a total of the visible rows