Is there information that you are constantly scrolling to find? Use “Groups” in Excel to bring the information to you. Drag-select the columns (or rows) that you wish to group Then click the Group command in the Outline group of

Subtracting dates can be easy. However, formatting the answer to be shown as a countdown to an event is a little tricky. First, let’s subtract our dates, to get the number of days between now and the event. This is

In the Formulas tab, in the Formula Auditing group, there is a command that helps you evaluate the formulas you have written. Example formula: =IF(A5>0,”True”,B5) To evaluate a formula, ensure you have that cell selected; then click the Evaluate Formula

In Excel, 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,

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

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

To add a query in a 2016 Excel spreadsheet, click the Data tab, then click the drop down for New Query command. This will open a display box that allows you to choose the workbook you want to run the

In some large Excel workbooks a dependent cell may refer to a precedent cell on another worksheet or many rows or columns away. The Excel Watch Window lets you see the dependent cell adjust as you make changes to the

Use Excel patterns as another way to color code your cells in Microsoft Excel. Select the cells you want to edit. Click on the drop down arrow in the bottom right corner of the font group under the Home Tab.