[Ultimate Guide] Using Goal Seek in Excel (With Examples) |
您所在的位置:网站首页 › Excel goal seek › [Ultimate Guide] Using Goal Seek in Excel (With Examples) |
The Goal Seek tool can be used to determine an unknown numerical figure to seek a particular goal number. Microsoft Excel can be used for analyzing highly utilitarian metrics like demand and sales forecasting, predicting, mathematical calculations, and more. Steps to use Goal Seek in ExcelLet鈥檚 get started with this ultimate step-by-step guide to using the Goal seek option correctly for achieving different objectives. ![]() For instance, you have a set of sales data for 3 months of four products. Every month you reach your minimum sales goal of 75% for all four products collectively. In the third month, you add a fifth product to your store and want to predict the number of units to be sold in a month to achieve the minimum 75% sales. We use goal seek to predict this data. Applying Goal Seek for prediction![]() ![]() You now get a random predicted figure that will be required to achieve a minimum of 75% sales per month keeping all others figures the same. ![]() Limitations: Note that you would require to determine manually for every unknown figure every time you perform a Goal Seek in excel. Dragging the cell data upward or downward will not predict the right figures for you. Also, Goal Seek can be performed to find out only one unknown figure of a row or column in a database. More Examples of Goal SeekGoal Seek in Excel can be used to find lost, uncalculated or predictable data in a database. For example, in the COVID-19 era, your school runs examinations for 6 subjects. But examinations of only 5 subjects were given by all students after which a lockdown was imposed. You are now supposed to reckon a predicted mark for students in the 6th subject. Here is how Goal Seek can help- ![]() There are two types of students here- an average and a nerd. You have to predict a figure for a mark lost based on the marks obtained in other 5 subjects, for the 6th subject. Let鈥檚 begin- ![]() This figure will help you determine a number in Goal seek settings to set as the goal TOTAL to be achieved to predict a mark for the 6th subject. ![]() ![]() ![]() This is how Goal Seek in Excel can help you in different ways to analyze different types of data. ConclusionThis article was a detailed guide on Goal Seek in Excel and how it could be used in different scenarios. If you have any questions, drop a comment below and we will answer them! |
CopyRight 2018-2019 办公设备维修网 版权所有 豫ICP备15022753号-3 |