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
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
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”
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
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
Create a KPI in Power Pivot for Excel: Overview Creating measures within the data model in Power Pivot then lets you create a KPI in Power Pivot for Excel. KPI stands for Key Performance Indicator. A KPI is a value, and often associated symbol, that gauges the performance of a base field in attaining
Conditional Formatting in Excel: Overview Conditional formatting in Excel lets you define criteria for cells which change the way the cells look in the worksheet, but only if the cells’ values match the criteria. For example, you could create a conditional formatting criterion that makes a worksheet cell appear with a red fill color
What is an IOLTA Account?: Overview The question “What is an IOLTA account?” is a question many new lawyers ask. Legal professionals use an IOLTA, or Interest on Lawyer’s Trust Account, to hold client funds separately from the funds of a law firm or individual lawyer. An IOLTA account is an interest-bearing checking account.