Finding information about functions can be difficult, especially if you do not know the name of the function, or if you are trying to find a function that will do what you need. Two ways to find help with functions

Freeze Panes in Excel allow users to scroll for information and still have the ability to match column and row headers, allowing a user to not need to constantly scroll back and forth in a worksheet to figure out which

All too often, we believe our Excel files are something they are not. An example of this is when someone instructs us to use an Excel template, but the file is actually a regular notebook. This can lead to disaster,

The light gray Excel gridlines are a normal part of Excel workbooks when opening a new blank workbook. For some, these gridlines are annoying. Unfortunately, there are no default settings for eliminating gridlines in new workbooks. However, there are a

Are you tired of holding printed sheets next to each other to compare the row or column headers? Ever wonder how to get the header rows or columns to show up on each printed page of an Excel worksheet? This

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