Microsoft Excel Tips and Tricks
Use 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.
Credit Leila Gharani