Excel Tips
Replicate Pivot Table For Each Rep »
August 16, 2017
There is an easy way to replicate a pivot table for each rep, product, whatever
Excel Shortcuts - Formatting with !@#$%^ »
August 15, 2017
Today's Excel shortcut is actually six shortcuts. Ctrl+Shift+ the numbers one through six each perform some numeric formatting. Today, I will show you how to remember the formatting associated with the six keys.
Excel Shortcuts - Paste Names »
August 14, 2017
Excel Keyboard Shortcuts: F3 to paste name. This can be useful as you are creating formulas.
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.
August 11, 2017
In the last episode, Ctrl+T made the pivot table source expand
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.