Or, put another way, Goal Seek determines input values needed to achieve a specific goal. For our purposes, Excel’s Goal Seek feature lets you adjust a value used in a formula to achieve a specific goal. Technically, Goal Seek is a process of calculating a value by performing what-if analysis on a given set of values. For your convenience, you can download the example. This tool tells you how variables must change to achieve a specific goal. You might be asking what a what-if tool is these tools show you the impact of making a change without impacting the actual data. Each example will be simple, but they will include enough information that you can start using these features on your own. We’ll review the options, discuss when to use them, and then implement all three tools. So, over the next few months, I’ll introduce you to Excel’s what-if analysis tools: I often respond to readers with “Have you tried a data table?” Invariably, they don’t know how to implement the feature–sometimes, they don’t even know what a data table is. If you ask me, Excel’s what-if analysis tools are under-used. Stop guessing! Susan Harkins shows you how to use Excel's Goal Seek what-if analysis tool to achieve your goals. How to use Excel’s Goal Seek analysis tool
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |