Excel What-If Analysis Data Table

nnnn

Microsoft Excel Tips and Tricks

nUse an Excel Data Table What-if Analysis to quickly create multiple results based on a formula you already have. The data table in Excel will allow you to change values in some cells and come up with different answers to the problem. This is what Microsoft Excel’s What-if Analysis Data Table does best – it allows you to experiment with different input variables.nnnn

Credit Leila Gharani

n