Skip to content Skip to site navigation Skip to service navigation

Excel Level 3 - Spreadsheet Analysis (Virtual Class)

Class Sessions

No classes match your filter. Remove or modify some filters to try again.

Class Code

ITS-V0117

Class Description

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.