A 3D reference is when the information from a cell in a different worksheet is pulled to a worksheet needing the information. Example: If your separated worksheets are laid out with information from each quarter (ie: Q1, Q2, Q3, Q4

Instead of scanning all of the information in a spreadsheet, use conditional formatting to highlight when issues exist. Then all you will need to do is look for colorful indicators. Example: The conditional formatting formula, in this case, is: Conditional

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!