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