Trace Error in Excel – Instructions and Video Lesson

Trace Error in Excel - Instructions: A picture of formula auditing arrows shown in a worksheet after using the Trace Error tool in Excel.
Trace Error in Excel: Overview             Trace Error in Excel lets you trace arrows back to cells referenced by a formula if it displays an error. The Trace Error tool is available when auditing a worksheet within a workbook. Note that the formula cell that you select must contain an error to use the Trace Error
Read more
No Comments

Change Worksheet Tab Color in Excel – Instructions

Change Worksheet Tab Color in Excel - Instructions: A picture of a user changing the worksheet tab color in Excel.
Change Worksheet Tab Color in Excel: Overview             You can change worksheet tab color in Excel, if desired. To do this, first select the worksheet tab whose tab color you wish to change. Next, click the “Home” tab in the Ribbon. Then click the “Format” button in the “Cells” button group. Then roll your mouse
Read more
No Comments

Format a PivotTable in Excel – Instructions and Video

Format a PivotTable in Excel: A picture showing the “Design” tab of the “PivotTable Tools” contextual tab in the Ribbon of Excel.
Format a PivotTable in Excel: Overview             You can apply preset styles to format a PivotTable in Excel. To format a PivotTable in Excel, click into any cell in the PivotTable. Then click the “Design” tab of the “PivotTable Tools” contextual tab within the Ribbon. Then click the desired style to apply from the listing
Read more
No Comments

Create a PivotChart in Excel- Instructions and Tutorial

Create a PivotChart in Excel: A picture of a user creating a PivotChart and PivotTable in Excel.
Create a PivotChart in Excel: Overview             When you create a PivotChart in Excel, you can show the data from an associated PivotTable in a graphic format. You can create a PivotChart in Excel along with an associated PivotTable. You can then manipulate the PivotChart data in the same way you
Read more
No Comments

Goal Seek in Excel- Tutorial and Instructions

Goal Seek in Excel- Tutorial: A picture that shows how to use Goal Seek in Excel.
Goal Seek in Excel: Overview             You can use Goal Seek in Excel when you know the result you want a formula to return, but do not know the value needed to create the desired result. Anytime you have a situation where you know the result that you need to obtain, but are unsure of
Read more
No Comments

Use a Top 10 AutoFilter in Excel – Tutorial

Use a Top 10 AutoFilter in Excel – Tutorial: A picture of the “Top 10 AutoFilter” dialog box in Excel 2016.
Use a Top 10 AutoFilter in Excel: Overview             You can use a Top 10 AutoFilter in Excel to show a specified number of the top or bottom percent or items in a field within the table. When you use a Top 10 AutoFilter in Excel, it defaults to showing the top 10 percent of
Read more
No Comments

Timeline Options in Excel – Tutorial

Timeline Options in Excel - Tutorial: A picture of a user modifying the appearance of a timeline in Excel 2016.
Timeline Options in Excel: Overview             This lesson shows you how to set timeline options in Excel. After inserting a timeline, an “Options” tab within a new “Timeline Tools” contextual tab then appears in the Ribbon. This tab appears within the Ribbon any time you have the timeline selected within the worksheet. You use the
Read more
No Comments

Function Compatibility in Excel – Tutorial

Function Compatibility in Excel - Tutorial: A picture of the “Compatibility” functions in Excel 2016.
Function Compatibility in Excel: Overview             Function compatibility in Excel supports older functions that have been replaced by newer versions of those functions. Starting in Excel 2013, some older formula functions have been replaced with new versions. These replacements occur to increase their accuracy and to better reflect their purpose. These new, more accurate statistical
Read more
No Comments