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