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

Custom 3D Maps in Excel – Instructions

Custom 3D Maps in Excel - Instructions: A picture of a user setting the custom map options for a custom 3D map in Excel.
Custom 3D Maps in Excel: Overview             You can easily create custom 3D maps in Excel. When you create a new scene in a 3D Maps tour, it is associated with a map. By default, the “World Map” is used for most scenes. However, you can also create custom 3D maps from image files, if
Read more
No Comments

Create a PivotChart in Excel- Instructions and Tutorial

Create a PivotChart in Excel: A picture of a user adding fields to the “PivotChart Fields” task pane in Excel.
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
Read more
No Comments

Recover Unsaved Workbooks in Excel – Instructions

Recover Unsaved Workbooks in Excel - Instructions: A picture of an unsaved workbook recovered by Microsoft Excel.
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
Read more
No Comments

Custom Regions in 3D Maps in Excel – Instructions

Custom Regions in 3D Maps in Excel - Instructions: A picture of the “Import Custom Region Set” dialog box in the 3D Maps window in Excel.
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
Read more
No Comments

Create a 3D Map in Excel – Instructions

Create a 3D Map in Excel - Instructions: A picture of a user creating a new 3D Maps tour in Excel.
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”
Read more
No Comments

Function Compatibility in Excel – Instructions

Function Compatibility in Excel - Instructions: A picture of the “Compatibility” functions in Excel.
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
Read more
No Comments

Timeline Options in Excel – Instructions

Timeline Options in Excel - Instructions: A picture of a user modifying the appearance of a timeline in Excel.
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 in the Ribbon any time you select the timeline within the worksheet. You use the buttons
Read more
No Comments