Course Overview:

This course covers Data Tables, Goal Seek, and Scenario Manager. You will learn how to use One-Way and Two-Way data tables to do sensitivity analysis. If you know the result that you want from a formula, but are not sure what input value the formula needs to get that result, then learning Goal Seek will help.

Finally you will learn how to use the scenario manager, which will help you create scenarios and see how they affect your output.

Key Topics:

• Learn how to create a One-Way data table to analyze how a single input affects multiple outputs
• Learn how to create a Two-Way data table to analyze how two spreadsheet inputs affect a single output
• How to use goal seek to get a desired output
• How the scenario manager can be used to describe how scenarios involving multiple spreadsheet inputs influence multiple spreadsheet outputs

Who Will Benefit?

Any professional that uses Microsoft Excel for analysis. Learning one-way and two-way data tables expedites sensitivity analysis. This coupled with goal seek and scenario manager will allow you to analyze data faster and more efficiently.