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
Custom Color Schemes in Publisher: Overview You create custom color schemes in Publisher to apply colors you select to publication elements in a consistent way. To create custom color schemes in Publisher, click the “Page Design” tab in the Ribbon. Then click the “More” button in the lower right corner of the “Schemes” list.
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.
Workbook Protection in Excel: Overview When you apply workbook protection in Excel, users cannot add, delete, hide, rename, or move workbook worksheets. You can also provide an optional password that must be entered before the workbook can be unprotected. This option is also a bit risky, because if you forget the password, you cannot
The Publisher User Interface: Overview The picture below is of the Publisher user interface after opening a new, blank publication. A publication is the file type created in Publisher. Within a publication you create and modify text and graphic objects on the pages in the publication. When you close a publication, Publisher then prompts
Inserting and Deleting Worksheets in Excel: Overview In this tutorial, you will learn about inserting and deleting worksheets in Excel. Inserting and deleting worksheets in Excel is a critical skill to possess when working with Microsoft Excel workbooks. To insert a single new worksheet to the right of the currently selected worksheet, click