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

Goal Seek in Excel- Instructions and Video Lesson

Goal Seek in Excel- Instructions and Video Lesson: A picture of the “Goal Seek” dialog box in Excel.
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
Read more
No Comments

Create Calculated Columns in Power Pivot in Excel – Instructions

Create Calculated Columns in Power Pivot in Excel - Instructions: A picture of a user creating a calculated column in the data model window of Power Pivot in Excel by typing a simple formula.
Create Calculated Columns in Power Pivot in Excel: Overview             This lesson shows you how to create calculated columns in Power Pivot in Excel. You can create calculated columns and measures from the tables in the Power Pivot data model. Doing this lets you create table values that you can then add to PivotTables and
Read more
No Comments

The Pv Function- Excel for Lawyers Tutorial and Video Lesson

The Pv Function- Excel for Lawyers Tutorial: A picture of a user creating a formula that uses the Pv function in Excel.
The Pv Function: Overview             This lesson shows you how to use the Pv function in Excel. Most of the functions that a lawyer needs to know assist them in business and financial computations. You can use these functions to help both the law firm as well as its clients.
Read more
No Comments

The Fv Function- Excel for Lawyers Tutorial

The Fv Function- Excel for Lawyers Tutorial: A picture of the Fv function being used in Excel.
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
Read more
No Comments

Create a Calculated Field in Access – Instructions

Create a Calculated Field in Access - Instructions: A picture of a calculated field in an Access query.
Create a Calculated Field in Access: Overview             You can easily create a calculated field in Access queries. A calculated field is a field that derives its value by performing a function on values from other table fields. It can also calculate values entered by hand. The field’s data only appears for the duration of
Read more
No Comments

Insert Table Formulas in Word – Instructions

Insert Table Formulas in Word - Instructions: A picture of the default formula that Word suggests in the
Insert Table Formulas in Word: Overview             You can insert table formulas in Word tables to perform simple mathematical functions on data. To insert table formulas in Word that add, subtract, multiply, and divide numbers in the table cells, you insert formulas into cells where you want to show the answers to the mathematical operations
Read more
No Comments

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