Data analysis using “what if” analysis in Excel 2010

Overview 

Excel 2010 Provides powerful data analytics tools that allow you to explore large amounts of data and make informed decisions based on that data. Using the Goal Seek and Solver tools you can extract the required results from the formulas, determining the data the formula needs. and you can use the additional components of the “what if” analysis, data tables, and scenarios to anticipate patterns of worksheet results and see how changing values in formulas affects formula results. Prerequisites Knowledge of basic text processing, calculations and spreadsheets; familiarization with the Microsoft Office work environment; Understanding the Functionality of the Internet and Web Pages

Target Audience

End Users Wanting to Gain Advanced Dexterity in Using Microsoft Excel 2010.

Objectives

• Using “What If” Analysis Tools
• Use the Goal Seek tool to analyze data
• Use Solver tool to perform data analysis
• create scenarios using Scenario Manager
• manage Excel “what if” scenarios
• create a data table for “what if” analysis
• recognize how to project values in a series
• use “what if” analysis to find out how to get the desired result
• use “what if” analysis to determine the maximum or minimum value of a cells, changing other cells
• use “what if” analysis to predict results in the most favorable and unfavorable scenario
• use “what if” analysis to explore a possible set of results at a glance