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

Most companies use a uniform format for their email addresses, either first letter of first name with the last name or first dot last name. This video shows you how to use Excel functions =left and =concatenate to automatically generate