Moving from worksheet to worksheet doesn’t mean you have to move your hand off the keyboard with this cool shortcut. To change to the next worksheet to the right, enter CTRL + PGDN. Conversely, to change to the worksheet to

Microsoft Excel 2013 introduced a new feature that lets you differentiate data at a glance: Conditional formatting. This handy tool will apply colors to a cell’s font and background depending on the conditions you’ve set – for instance, if you

Create a named group of cells to be used in formulas or to quickly navigate back to the group. To do so, first, select the group of cells to be named. In this case, we will use a list of

If the DateValue Command doesn’t work, use text to columns to reformat text into dates. For more ways to make Excel work for you, take a training course from AdvantEdge Training & Consulting!

Some data from other programs can come in as text instead of dates. Use the command DateValue to change text to a date. For more ways to make Excel work for you, take a training course from AdvantEdge Training &

Use these simple keystrokes to simply select multiple columns or rows of data in Microsoft Excel For more ways to make Excel work for you, take a training course from AdvantEdge Training & Consulting!

Change your X and Y axis in Microsoft Excel to turn your columns into rows and rows into columns. For more ways to make Excel work for you, take a training course from AdvantEdge Training & Consulting!

Quickly clean duplicate data from data sets in Excel with the Remove Duplicates button. For more ways to make Excel work for you, take a training course from AdvantEdge Training & Consulting!

Sometimes in Excel, you will need to repeat an action several times. This can be cumbersome if the command is hidden a few menus deep. This video shows how to use Control Y to repeat an action in Excel with

Selecting a large data table by highlighting and dragging the mouse can sometimes be difficult in Microsoft Excel, especially with a large amount of data. Excel 2010 makes it easy to select an entire data table using one keystroke. To