Live Chat
Monday - Friday 8am - 6pm EST Chat Now
Contact Us
Monday - Friday 8am - 8pm EST 1-866-716-6688 Other Contact Options
Checkout

Cart () Loading...

    • Quantity:
    • Delivery:
    • Dates:
    • Location:

    $

Microsoft Excel 2007 Level 3 - Spreadsheet Analysis

GK# 8758

Course Overview

TOP

In this 1-day course, you will learn advanced functions related to spreadsheet analysis in Excel 2007.

Schedule

TOP
  • Delivery Format:
  • Date:
  • Location:
  • Access Period:

$

What You'll Learn

TOP
  • 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
  • Utilize the various tools used to audit workbooks

Outline

TOP
Viewing outline for:

Classroom Live Outline

1. Using Functions

  • Function Concepts
  • Absolute and Mixed References
  • Financial Functions

2. Projecting Figures

  • Goal Seek
  • Data Tables

3. What-If Scenarios

  • Scenario Concepts
  • Creating Scenarios
  • Managing Scenarios
  • Scenario Reports

4. Solver

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

5. Auditing Workbooks

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

Prerequisites

TOP

Who Should Attend

TOP

Those familiar with Microsoft Office Excel 2007 who want to learn more advanced skills in Data List Management

Follow-On Courses

TOP
Course Delivery

This course is available in the following formats:

Classroom Live

Receive face-to-face instruction at one of our training center locations.

Duration: 1 day

Request this course in a different delivery format.
Enroll