Trace Error in Excel – Instructions and Video Lesson
Wednesday, March 15 2017
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
- Published in Excel 2013, Excel 2016, Latest, Microsoft, Office 2013, Office 2016, Office 365
No Comments
Change Worksheet Tab Color in Excel – Instructions
Thursday, February 23 2017
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
- Published in Excel 2013, Excel 2016, Latest, Microsoft, Office 2013, Office 2016, Office 365
Create a PivotChart in Excel- Instructions and Tutorial
Friday, January 20 2017
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
- Published in Excel 2013, Excel 2016, Latest, Microsoft, Office 2013, Office 2016
Goal Seek in Excel- Tutorial and Instructions
Wednesday, January 04 2017
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
- Published in Excel 2013, Excel 2016, Latest, Microsoft, Office 2013, Office 2016, Office 365
Use a Top 10 AutoFilter in Excel – Tutorial
Monday, December 05 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
- Published in Excel 2013, Excel 2016, Latest, Microsoft, Office 2013, Office 2016, Office 365
Function Compatibility in Excel – Tutorial
Tuesday, October 25 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
- Published in Excel 2013, Excel 2016, Latest, Microsoft, Office 2013, Office 2016, Office 365