Microsoft Excel 2007 Level 3 - Spreadsheet Analysis

Microsoft Excel 2007 Level 3
Spreadsheet Analysis

Course ID: S173S
Duration: 1 day

Prerequisites

Microsoft Excel 2007 Level 2

Course Objectives

After completing the course, participants will be able to:

Use absolute and mixed references in a formula, as well as using financial functions
Use the Goal Seek feature and data tables
Create and manage scenarios, as well as create scenario reports
Define and solve problems with Solver, as well as create reports
Understand and utilize the various tools used to audit workbooks

Course Content

Using Functions
Function Concepts ; Absolute and Mixed References ; Financial Functions

Projecting Figures
Goal Seek ; Data Tables

What-If Scenarios
Scenario Concepts ; Creating Scenarios ; Managing Scenarios ; Scenario Reports

Solver
Solver Concepts ; Defining the Problem ; Solving the Problem ; Solver Reports ; Solver Options

Auditing Workbooks
Auditing Concepts ; Tracing a Worksheet ; Evaluating Formulas ; Locating and Correcting Errors in Formulas ; Tracking Cells in a Workbook

More Information

For more information, contact us by phone or send us an e-mail.

Toll Free: (866) 926-5671

Halifax • Montreal • Ottawa • Toronto • Winnipeg
Regina • Saskatoon • Calgary • Edmonton • Vancouver