EXC10SA: Microsoft Excel 2010 Level 3 - Spreadsheet Analysis

$355.00
$355.00
$355.00
$355.00
$355.00
$355.00
$355.00
Start Date Time Days Price GTR Availability
May 15, 2017 09:00 (EST) 1 $355.00 Register
May 15, 2017 09:00 (EST) 1 $355.00 Register
June 26, 2017 09:00 (EST) 1 $355.00 Register
June 26, 2017 09:00 (EST) 1 $355.00 Register
August 11, 2017 09:00 (EST) 1 $355.00 Register
September 25, 2017 09:00 (EST) 1 $355.00 Register
October 30, 2017 09:00 (EST) 1 $355.00 Register

Duration: 1 Day

Course Description
In this course, you will learn how to perform data analysis using Excel’s most popular features.

Prerequisites
To ensure your success, we recommend you first take one of the following courses or have equivalent knowledge: Microsoft Office Excel 2010 – Level 2.

Course Objectives
Upon completion of the course, participants will be able to accomplish the following:

  • 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

Audience
This course is meant for people with a sound working knowledge of Microsoft Excel.

Course Details

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 & Correcting Errors in Formulas
  • Tracking Cells in a Workbook