Using Financial and Statistical Functions

Using Financial Functions

Understanding Basic Financial Terms

Understanding Excel’s Financial Syntax Components

Using the PV Function to Calculate Present Value

Using the PV Function to Calculate Present Value

Using the FV Function to Calculate Future Value

Using the PMT Function to Calculate Payments

Using the RATE Function to Calculate Interest Rate

Comparing the EFFECT and NOMINAL Functions

Using the EFFECT Function

Using the NOMINAL Function

Creating Named Ranges from Selections

Using Statistical Functions

Using the COUNT Function to Count a List of Numbers

Using the COUNTA Function to Count Non-Empty Cells

Using the COUNTBLANK Function to Count the Blank Cells

Using the COUNTIF Function to Count Based on a Criteria

Understanding the AVERAGE and MEDIAN Functions

Using the MODE Function to Find the Most Common Cell

Using the STDEV Function in Excel

Using the VAR Function to Determine the Variance

Analyzing Data

Finding Values with Goal Seek

Using Solver

Creating Scenarios

Showing Scenarios

Editing Scenarios

Summarizing Scenarios