Prerequisites
To ensure your success, we recommend you first take the following course (or have
equivalent knowledge): Excel Essential training (Code: 20130)
Course Overview
Learn how to perform data analysis using Excel’s most popular features such as
Goal Seek and Solver.
Excel Spreadsheet Analysis Topics
1. Using Functions
2. Function Concepts
3. Absolute and Mixed References
4. Financial Functions
5. Goal Seek
6. Data Tables
7. What-If Scenarios
8. Scenario Concepts
9. Creating Scenarios
10.Managing Scenarios
11.Scenario Reports
12.Solver Concepts
13.Defining the Problem
14.Solving the Problem
15.Solver Reports
16.Solver Options
17.Auditing Workbooks
18.Auditing Concepts
19.Tracing a Worksheet
20.Evaluating Formulas
21.Locating & Correcting Errors in Formulas
22.Tracking Cells in a Workbook
