Blogs and Posts

Excel “What-if Analysis Webinar

• By: Garry Feldman
• Date: January 29, 2016

U.S. Computer Connection, www.uscomputer.com, and Computer Training Solutions, www.computertrainingsolutions.biz presents Excel “What-if Analysis”.

We are frequently using values from our Excel workbooks to create formulas resulting from our raw data – ex: multiplying the sales volume by the price to arrive at the gross sales. Sometimes, we may want to arrive at a particular answer – how much I can afford to pay per month on a car loan, by working backwards to figure out how much I can afford to borrow, or for how long. This type of analysis is called What-If.

The webinar will deal with three types of what-if analysis.

• Goal Seek – which allows you to reach a specific answer by altering one variable.
• Solver – Allows you to reach an optimal or specific answer by modifying one or more variables.
• Scenarios – Look at potential alternatives using different choices for more than one variable – and saving a variety of scenarios.

Each function will be demonstrated and explained, and questions can be asked while you are on line at the Webinar. and Computer Training Solutions, www.computertrainingsolutions.biz presents Excel “What-if Analysis”.

We are frequently using values from our Excel workbooks to create formulas resulting from our raw data – ex: multiplying the sales volume by the price to arrive at the gross sales. Sometimes, we may want to arrive at a particular answer – how much I can afford to pay per month on a car loan, by working backwards to figure out how much I can afford to borrow, or for how long. This type of analysis is called What-If.

The webinar will deal with three types of what-if analysis.

• Goal Seek – which allows you to reach a specific answer by altering one variable.
• Solver – Allows you to reach an optimal or specific answer by modifying one or more variables.
• Scenarios – Look at potential alternatives using different choices for more than one variable – and saving a variety of scenarios.

Each function will be demonstrated and explained, and questions can be asked while you are on line at the Webinar.