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

 March 8, 2009  Posted by  Software Tagged with: , , ,  Add comments

Leave a Reply