Ever wonder how somebody created a dropdown list in Excel? There are two ways to do this. 1. Create the list in Excel somewhere, or have your list handy, so you can type the choices in your list. 2. Select

Creating an Excel template allows a person to reuse a workbook setup over and over, without the need to recreate the wheel every time, nor continuously to clean out old information. By using a template, your workbook is ready and

A Timeline can be inserted into your PivotChart, if dates are listed in your table. After you insert your PivotChart, add a Timeline, located in the Filters group of the Insert tab. Watch this short video to see a Timeline

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