Excel 2016 Level 3 – Spreadsheet Analysis

Excel 2016 Level 3 - Spreadsheet Analysis

Duration: 1 Day

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

  • 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

Prerequisites: Intermediate level of Excel.

Review

  • Absolute and Mixed References

Projecting Figures

  • Goal Seek
  • Data Tables

What-If Scenarios

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

Introduction to Solver

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

Auditing Workbooks

  • Auditing Concepts
  • Tracing a Worksheet
  • Evaluating Formulas
  • Tracking Cells in a Workbook
X