Learn how to perform data analysis using Excel's most popular features such as Goal Seek and Solver.
In this virtual class, learn to accomplish the following:
- Use absolute and mixed references in a formula, as well as using financial functions
- 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
Topics include:
Using Functions
- Function Concepts
- Absolute and Mixed References
- Financial Functions
Projecting Figures
- Goal Seek
- Data Tables
What-If Scenarios
- Scenario Concepts
- Creating Scenarios
- Managing Scenarios
- Scenario Reports
Solver
- 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
University IT Technology Training classes are only available to Stanford University staff, faculty, or students. A valid SUNet ID is needed in order to enroll in a class.
