![]() The spreadsheet shows sales forecast for a convenience store. Let's create a one variable data table to start with. If you're creating a two variable data table, then you fill in both text boxes. One cell becomes the Row Input cell that substitutes values you've entered across columns of a single row – and vice versa. If you're creating a one variable data table, you choose one cell in your worksheet to use as either the Row Input Cell or as the Column Input Cell. The dialogue box above has two text boxes: Row Input Cell and Column Input Cell. To start a what-if analysis, click the Data tab, then go to the What-if Analysis button in the Forecast group.Ĭhoose Data Table from the dropdown menu. Let's walk through it step by step. We're going to do a what-if analysis with a one variable data table. If you're lost as to what we mean at this point, don't worry. A two variable table substitutes a series of possible values for two values in one formula. ![]() Scenarios. This lets you set up and test different cases (best case scenario).Įxcel 2016 will support two types of data tables: a one variable data table and a two variable data table. The one variable data table substitutes a series of possible values for a single value in a formula. Goal seeking. This lets you to discover what it takes to reach a certain objective. This lets you see how changing one or two values will affect the bottom line. However, in this article, we're going to cover three:ĭata tables. There are all types of what-if analyses that Excel can do. It would be a big mistake for anyone to chalk Excel up to a fancy calculator that simply creates fancy spreadsheets and performs calculations.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |