EXC16SA: Microsoft Excel 2016 Level 3 - Spreadsheet Analysis

$355.00
$355.00
$355.00
$355.00
$355.00
$355.00
Start Date Time Days Price GTR Availability
April 10, 2017 09:00 (EST) 1 $355.00 Register
May 29, 2017 09:00 (EST) 1 $355.00 Register
July 11, 2017 09:00 (EST) 1 $355.00 Register
August 30, 2017 09:00 (EST) 1 $355.00 Register
October 18, 2017 09:00 (EST) 1 $355.00 Register
December 13, 2017 09:00 (EST) 1 $355.00 Register

Duration: 1 Day

Who should attend?
This course is intended for participants who are familiar with Microsoft Office Excel 2016.

Prerequisites    
Microsoft Office Excel 2016 – 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

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