|
SYNOPSIS:
This course introduces the skills necessary for using advanced functions.
It includes tasks such as creating data series, using lookup and logical
functions, rounding numbers and creating and using data tables. Students
will also learn how to solve problems, use scenarios and goal seek, and
protect worksheets.
PREREQUISITES:
Excel users who want to learn how to effectively use the financial formulae.
OBJECTIVES:
l Working
with Data Series
l Using Lookup Functions
l Using Logical Functions
l Rounding Numbers
l Using Scenarios & Goal Seeking
l Using Data Tables
l Solving Problems
l Using Worksheet Protection
DURATION:
One Day
|
THIS MODULE INCLUDES:
Working with Data Series
Using the Series command; creating a linear series, a date series, a growth
series, and an AutoFill series; using a stop value.
Using Lookup Functions
Using lookup functions, VLOOKUP, and HLOOKUP.
Using Logical Functions
Using logical, IF, nested IFs, ISERROR, AND, and OR functions.
Rounding Numbers
Using the ROUND function, limiting the precision of numbers.
Using Scenarios and Goal Seeking
Using the Scenario Manager; creating, displaying, and editing a scenario;
creating a scenario report; using goal seek.
Using Data Tables
Using data tables; placing formulae in data tables; creating one-variable
and two-variable tables.
Solving Problems
Using Solver, saving a solution as a scenario, restoring the original
values, changing a constraint, creating a Solver report, using scenarios
to view solutions.
Using Worksheet Protection
Unlocking
cells in a worksheet; protecting and unprotecting a worksheet, protecting
and unprotecting a workbook, opening a protected file, assigning and removing
a password; setting manual and automatic calculation.
|
