$89.00 / year
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.
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.