Trace Error in Excel – Instructions and Video Lesson
Tuesday, November 12 2019
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, Excel 2019, Excel for Office 365, Latest, Microsoft, Office 2013, Office 2016, Office 2019, Office 365
No Comments
Create a PivotChart in Excel- Instructions and Tutorial
Thursday, October 31 2019
Create a PivotChart in Excel: Overview You can create a PivotChart in Excel to show the data from an associated PivotTable in a graphic format. You can create a PivotChart in Excel either independently from or along with an associated PivotTable in Excel. Alternatively, you can also add a PivotChart to an existing PivotTable
- Published in Excel 2013, Excel 2016, Excel 2019, Excel for Office 365, Latest, Microsoft, Office 2013, Office 2016, Office 2019, Office 365
Recover Unsaved Workbooks in Excel – Instructions
Tuesday, October 29 2019
Recover Unsaved Workbooks in Excel: Overview You can try to recover unsaved workbooks in Excel. To see if Excel has automatically saved a copy of an unsaved workbook, click the “File” tab in the Ribbon. Then click the “Open” command at the left side of the backstage view. In the area to the right
- Published in Excel 2016, Excel 2019, Excel for Office 365, Latest, Microsoft, Office 2016, Office 2019, Office 365
Custom Regions in 3D Maps in Excel – Instructions
Friday, October 25 2019
Custom Regions in 3D Maps in Excel: Overview Custom Regions in 3D Maps in Excel: Importing Custom Regions You can import your own custom regions in 3D Maps in Excel, if needed. Custom regions in 3D Maps in Excel are defined geospatial regions saved as either “kml” or “shp” files. You often create these
- Published in Excel 2019, Excel for Office 365, Latest, Microsoft, Office 2019, Office 365
Create a 3D Map in Excel – Instructions
Wednesday, October 23 2019
Create a 3D Map in Excel: Overview Create a 3D Map in Excel: Creating a New Tour After enabling the 3D Maps add-in in Excel, you can then create a 3D Map in Excel. To create a 3D Map in Excel, click the “Insert” tab in the Ribbon. Then directly click the “3D Maps”
- Published in Excel 2019, Excel for Office 365, Latest, Microsoft, Office 2019, Office 365
Function Compatibility in Excel – Instructions
Friday, October 18 2019
Function Compatibility in Excel: Overview Function compatibility in Excel supports older functions that have been replaced by newer versions of those functions. In Excel, 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 functions have
- Published in Excel 2013, Excel 2016, Excel 2019, Excel for Office 365, Latest, Microsoft, Office 2013, Office 2016, Office 2019, Office 365