Using Financial and Statistical Functions

Using Financial Functions

Understandig Basic Financial Terms

Understanding Excel’s Financial Syntax Components

Using PV to Calculate Present Value

Using FV to Calculate Future Value

Using PMT to Calculate Payments

Using RATE to Calculate Interest Rate

Comparing EFFECT and
NOMINAL Functions

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

Using the COUNTIFS Function to Count Based on Multiple Conditions

Using Statistical Functions (cont.)

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