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.

Visit More : Students FM Youtube

What- if Analysis Using Data table in Excel | Advanced Features of Excel | Malayalam Tutorial

 

Excel offers either one input or two input data table. Both are available under the Data tab, What-if analysis. You need both input and dependent cells to do a data table. A Data Table allows you to have multiple inputs and see how different inputs values would impact the result. This is extremely useful to analyze a problem in Excel.

https://www.youtube.com/watch?v=hAPmKg1F-fw