Fill data into a data set by customizing the ribbon to include Excel Data Forms. For more ways to make Excel work for you, take a training course from AdvantEdge Training & Consulting!

Creating an Excel template allows a person to reuse a workbook setup over and over, without the need to reinvent the wheel every time. The workbook being used for the template needs to have old data cleared out (i.e., the

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

Pivot Tables are useful for analyzing large amounts of data. Pivot Table slicers quickly filter the data being reviewed to narrow your view. Overwhelmed by Pivot Tables and Charts?  AdvantEdge Training & Consulting has a class for that!

This tip explains how to use conditional formatting in Excel to show values greater than and less than a figure. For more ways to make Excel work for you, take a training course from AdvantEdge Training & Consulting!

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

Subtracting dates can be easy. However, formatting the answer to be shown as a countdown to an event is a little tricky. But we can create a countdown timer in Excel to do just that: First, let’s subtract our dates,

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

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