Blogs and Posts

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.