Excel Tips


Wiring Slicers »

August 24, 2017

One set of slicers can run multiple pivot tables!


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.


Dashboard Sparklines »

August 23, 2017

Sparklines are word-sized charts


Excel Shortcut - Macro Security »

August 23, 2017

I love VBA macros in Excel. But if I give someone a small macro, and if you've never used macros, you need to enable macros on your copy of Excel. Today, a keyboard shortcut to make this simpler.


Slicers »

August 22, 2017

Pivot Filters have been around


Excel Shortcut - Insert Chart »

August 22, 2017

Continuing our Excel Keyboard Shortcut series - there is a keyboard short cut to create a default chart in Excel. While that shortcut is great if your job is to create a clustered column chart, what if you want to create some other type of chart in response to pressing Alt+F1?


Excel Shortcut - Paste Special »

August 22, 2017

Excel Keyboard Shortcuts for Paste Special Values. How to quickly convert Excel formulas to Values. You will be surprised at the faster ways to do these common tasks.


Pivot Charts »

August 21, 2017

Building a pivot chart to summarize a data set


Excel Shortcut - Insert Worksheet »

August 21, 2017

Today, a few different Excel shortcuts to insert a new worksheet.