Shortcut for Goal Seek in Excel
You can access Goal Seek in Excel using a keyboard shortcut by pressing Alt + A, followed by W, and then G.
How to use Goal Seek in Excel for What-If analysis with Examples
Goal Seek is a “What if – analysis” tool available in MS EXCEL to determine or calculate any input value based on the formula and the output/resultant value. In simple language, we can say, “What should be the input value of the given output”? The good thing about Goal Seek is that it performs all calculations behind the scenes. You are only asked to give these three parameters Set cell, To value, By changing cell.
Contact Us