Not to be mistaken with Excel Tables, Data Tables are a tool that can be used to do "what if" type analysis and allows you to see the results of a calculation while varying up to two of the calculation inputs In this example we'll create a data table based on the accumulated value of a bank deposit that earns interest (ie how much money will we have after a given time at this Excel's Data Table tool works similarly to Goal Seek and Scenario Manager You can use table values to replace variables in a formula or function In this way, you can view whatif results withoutWhatIf Analysis in Excel allows you to try out different values (scenarios) for formulas The following example helps you master whatif analysis quickly and easily Assume you own a book store and have 100 books in storage You sell a certain % for the highest price of $50 and a certain % for the lower price of $
What If Analysis Goal Seek Scenario Manager And Data Table In Excel Step By Step Tutorial Youtube
