Leaving Blank values in Excel
Use this tip to return a blank field from an IF statement. For more ways to make Excel work for you, take a training course from AdvantEdge Training & Consulting!
Leaving Blank values in Excel Read Post »
Use this tip to return a blank field from an IF statement. For more ways to make Excel work for you, take a training course from AdvantEdge Training & Consulting!
Leaving Blank values in Excel Read Post »
View two Excel worksheets at the same time by opening a second window and arranging them vertically or horizontally. For more ways to make Excel work for you, take training course from AdvantEdge Training & Consulting!
View two Excel worksheets in the same screen Read Post »
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
Creating an Excel template Read Post »
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
Excel: Insert a Timeline Read Post »
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!
Pivot Table Slicer quickly filters data in Excel Read Post »
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!
Conditional formatting simplifies reading data Read Post »
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
Use “Groups” to bring the information to you – Excel Read Post »
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,
Creating a countdown for two dates – Excel Read Post »
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
Excel: Evaluating Formulas Read Post »