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 2010 Level 3 - Spreadsheet Analysis

GK# 8250

Course Overview

TOP

This course with hands-on labs provides you with the knowledge and skills to work with the advanced spreadsheet analysis features and functionality of Microsoft Excel 2010.

What You'll Learn

TOP
  • Create formulas using absolute and mixed references and financial functions
  • Use the Goal Seek feature and data tables
  • Create and manage scenarios and scenario reports
  • Define and solve problems with Solver
  • Create Solver reports
  • Understand and use 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 who are familiar with Microsoft Office Excel 2010

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

Virtual Classroom Live

Experience expert-led online training from the convenience of your home, office or anywhere with an internet connection.

Duration: 1 day

Request this course in a different delivery format.
Enroll