Excel Level 3 - Spreadsheet Analysis (Virtual Class)

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.