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.
Негізгі бет What- if Analysis Using Data table in Excel | Advanced Features of Excel | Malayalam Tutorial
Пікірлер: 2