Ready to Checkout?


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

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

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

View Formulas in a Table in Word: Overview             You can view formulas in a table in Word easily. If you create a large table in Word that contains many formulas, you may have difficulty remembering which cells contain formulas and which cells contain ordinary numeric entries. To view formulas in a table in Word,

Key Liquidity Ratios: Overview             This lesson will describe the calculations used to perform three key liquidity ratios: the current ratio, the quick ratio, and the cash ratio. The most commonly-calculated liquidity ratio is known as the current ratio. The current ratio measures an organization’s ability to meet short-term obligations. Typically, a current ratio result

Create Calculated Columns in Power Pivot in Excel 2016: Overview             This lesson shows you how to create calculated columns in Power Pivot in Excel 2016. You can create calculated columns and measures from the tables shown in the Power Pivot data model to create values within a table which you can then add to

The Fv Function: Overview             The Fv function assists you in determining the future value of an investment based on periodic but constant payments with a constant interest rate. The future value is the total amount that a series of payments will be worth at a specified future time. For example, if you saved $100

The Pv Function: Overview             Most of the functions that a lawyer needs to know assist them in business and financial computations. These functions can be used both for the law firm as well as for its clients- for example; figuring out the future value of a purchased asset is often useful for both parties.