Prerequisites
To ensure your success, we recommend you first take the following course (or have equivalent knowledge): Excel Basic Level.
Course overview
Learn how to perform data analysis using Excel 2016’s most popular features such as Goal Seek and Solver.
Excel Spreadsheet Analysis Topics
- Using Functions
- FunctionConcepts
- Absolute and Mixed References
- Financial Functions
- GoalSeek
- DataTables
- What-If Scenarios
- ScenarioConcepts
- CreatingScenarios
- Managing Scenarios
- Scenario Reports
- 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
