Mar 082009

Data Table is a What If Analysis Function to find out result by altering an input cell in Excel.

For example, you may want to see impact on your revenue or profit by altering per unit price of your product.

Go to What If Analysis in Data tab and select Data Table. Enter Row Input cell (if you are filling data horizontally) or Column Input Cell (If you are filing data vertically) or both if you are filling data vertically as well as horizontally.

datatable thumb Using What If Analysis Function Data Table in Excel image

Leave a Reply