In the Goal Seek window, set the following parameters:.
Click Data – > What If Analysis -> Goal Seek… to open the Goal Seek tool. Using the numbers above, let’s assume we want to find out how many units we would need to sell to break-even. The grey cells are the variables, if any of the variables change, the final profit changes. Based on the sales units, sales price, cost price and fixed costs, we calculate a profit. The scenario we’re using is a simple business case. The Goal Seek feature determines the input required to achieve a specific outcome. Then you’ll be able to work along with examples and see the solution in action, plus the file will be useful for future reference.ĭownload the file: 0022 Automated Goal Seek.zip I recommend you download the example file for this post. Wouldn’t it be great if we could make it work with a single click, or maybe automate it completely? Well… guess what, that’s exactly what we’re going to do. It’s hidden away in the Data menu so you need to know it’s there to find it. While probably one of the best features in Excel, Goal Seek is quite clunky to use. I’ve not used the technique extensively to date, but it seems to be a useful approach. This got my mind buzzing with ideas, so I wanted to share it with you, along with a few of my own developments. 
I recently attended an online meetup where Danielle Stein Fairhurst shared a technique involving Excel’s Goal Seek feature operated by a macro.
0 kommentar(er)
