Microsoft Excel Scenario Analysis

Course | August 13 | 1:30-4 p.m. | 28 University Hall

 Human Resources

This course details the process of analyzing data scenarios using Microsoft Excel calculations and feature sets. Emphasis is placed on detection of cell and range equivalencies and anomalies. Learning Objectives * Create formulas and functions to validate equal cell values or detect discrepancies. * Generate Sparklines to graphically render variations in data sets. * Create conditional functions to perform scenario-based calculations. * Transpose data ranges via duplication and linked array functions. * Define multiple range or cell values using the Scenario Manager. * Determine exact cell target values using Goal Seek and the Solver Add-in to reverse engineer formulas and functions. * Generate one-variable and two-variable Data Tables to perform calculation arrays.

  Register online

 ksamsell@berkeley.edu