Excel Tips


Excel Shortcuts - Current Region »

July 28, 2017

The next article in our list of Excel shortcuts involves the Current Region. Learn how to select all of the data set around the current cell.


Comparative Scatter Chart »

July 27, 2017

X-Y Scatter Charts with 2 series are difficult to create


Excel shortcuts - Ctrl+5 for Strikethrough »

July 27, 2017

I love to keep my To-Do lists in Excel. If you have a to-do list, you need a way to cross those things off the list. Strikethrough is the answer.


Paste New Chart Data »

July 26, 2017

Podcast 1978 introduced Custom List for the Fill Handle


Excel Shortcuts - Ctrl Period to Jump to Next Corner »

July 26, 2017

Today's Excel Shortcut is another navigation trick. Once you have a large range selected, you can jump to the next corner of the selection using Ctrl+Period.


Troubleshooting VLOOKUP »

July 25, 2017

Excel VLOOKUP is powerful, but it won't work when you have specific situations. Today, a look at how to troubleshoot VLOOKUP.


Excel Shortcuts - Ctrl+Arrow to Navigate »

July 25, 2017

Jump to the edge of your Excel data using Ctrl + [Shift] + Arrow to quickly navigate.


Perfect 1-Click Charts »

July 24, 2017

You do not have to re-create your charts each month


Excel Shortcuts - Ctrl+1 »

July 24, 2017

Excel Keyboard Shortcuts: Ctrl+1 to format the selection. By far, this was the most popular in our poll of your favorite Excel shortcut.