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