EXC10SA: Microsoft Excel 2010 Level 3 - Spreadsheet Analysis

Start Date Time Days Price GTR Availability
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
August 11, 2017 09:00 (EST) 1 $355.00 Register
September 25, 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