Monday, November 2, 2009

Using Goal Seek

"What If” scenarios are a valuable instrument for nearly any business. Excel provides a great tool to accomplish this by automatically making changes in a variable using Goal Seek (it can save you a ton of work, and make you look good in the process).

Using a very simple example, let’s say that you are a call center sales manager, and you know the approximate number of calls you are going to receive for the next month, as well as the sales goal that has been set by the executive branch. You wish to know the call-to-sale-conversion-rate so you can advise your staff. A rudimentary calculator can be created in the cells of your Excel worksheet as follows:

Number of Calls x Conversion Rate = Number of Sales (e.g. C4*C5 = C6)

After filling in the values for C4 and C6, you can use Goal Seek to calculate the required value for C5.

Obviously, this tool can be used to greater advantage with more complex scenarios, but you get the picture. Goal Seek can be a handy tool for the boardroom or any planning venue. Give it a try sometime!

1 comment:

Forex Signals Provider said...

USA Forex Signal Provide best forex signals in the world . USA Forex Signal Provide free forex trading signals daily.
What are the criteria for selecting USA Forex Signal provider for you?
When you add USA Forex Signal provider, lead not look it to your reside account without the compulsion of investigation. These systems are primarily based on complicated statistical mathematics and algorithms in analyzing marketplace trends, predict, and predictions. USA Forex Signal is a worldwide and adeptly-known Forex signals Company. It is worldwide just about 400+ country SMS and worldwide Email coverage Forex Signals Company. It is top most accurate forex signals free providers. There are lots of things which they manage to pay for to satisfy customer’s obsession and it incorporates the finding out method. These automated upon the web trading services proclamation you to review and trade hundreds of trading systems and Forex signals, stocks, and commodities.
USA Forex Signal: http://www.usaforexsignal.com/