Online Tutorials, IT Courses, technical information's about advanced devices
Oct 21, 2021
What- if Analysis Goal Seek in Excel | Advanced Features of Excel | Goal Seek Malayalam Tutorial
What- if Analysis Goal Seek in Excel | Advanced Features of Excel | Goal Seek Malayalam Tutorial
Excel's Goal Seek tool is in the Data Tools Tab as a part of What-If Analysis in the Excel Ribbon.
Goal seek can be described as follows:
• It is the opposite of a formula: instead of finding the end result, you give it the end result and it gives you the input
• It eliminates the trial and error process
• It is like guessing on speed. It’s useful for situations where you want quick answers
• It is a simplified Solver
The main advantage of Goal seek is that you don’t have to change your Excel formulas or turn a formula field to an input field.
No comments:
Post a Comment