Using Financial and Statistical Functions in Microsoft Excel

3 Hours

Course Overview

This instructor-led course, through lecture and hands-on exploration, will introduce you to a variety of financial and statistical functions. You will also learn how to use the Scenario, Subtotal and Outline features. It is geared for users who have experience with Microsoft Excel and need to learn these more intermediate/advanced functions.

Course Objectives

Use a variety of financial functions: PV, FV, PMT, RATE, EFFECT and NOMINAL
Use a variety of statistical functions: COUNT, COUNTA, COUNTBLANK, COUNTIF, MODE, MEDIAN, STDEV and VAR
Perform a What-If Analysis using Scenarios on a range of data
Use the Subtotal and Outline features to quickly group and view details, subtotals, or grand totals

Course Outline

Using Financial Functions

Understanding 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
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

Using Data Analysis Tools

Creating Scenarios to Perform What-if Analysis
Showing Scenarios
Editing Scenarios
Summarizing Scenarios
Using the SUBTOTAL Feature
Outlining Worksheets
Creating Manual Outlines
Showing or Hiding Details
Ungrouping Columns and Rows
Clearing Outlines
Creating Automatic Outlines

Cost and Delivery Format Options

We offer the above listed class as a private group class in the following delivery formats. Any two 3-hour Microsoft classes must be scheduled on the same day to receive pricing (9:00 am to 12:00 pm and 1:00 pm to 4:00 pm).

Private Group Class: Live Virtual
1-4 students	$850
5-8 students	$1000
9-12 students*	$1100
*$35 per additional student

Private Group Class: At Your Location
1-4 students	$1100
5-8 students	$1250
9-12 students*	$1350
*$35 per additional student

Private Group Training

Private group classes are cost effective when you have a group of students who need the same course. Volume discounts of 5% to 20% are available when five or more training days are scheduled. For classes conducted at your location, you are responsible for the classroom setup which should include:

A computer for each student (with the appropriate software installed), and
An instructor workstation connected to a visual display (e.g., projector, smartboard, etc.).

Customization

Softek can easily customize a training course that covers the specific topics you require and integrate examples relevant to your work environment. Course customization is billed at $150 per hour and covers time needed to meet, discuss, prepare, and incorporate any specific examples into the training program. Once we have a better idea of what you have in mind, we will be glad to provide a specific price quote for the customization.