If the unit price AND number of units sold changes, use the two-input What-If Table.Ĭreate Absolute and/or Relative Macros to automate common, repetitive tasks.Īdd buttons, sliders, and checkboxes to a worksheet to create a "user-friendly" interface for less experienced users. When a single variable like the unit price changes, use a one-input What-If Table. To compare several scenarios, you can create a report that summarizes them on the same page.ĭata Tables allow you to analyze data and produce a table to show the results. The user can then switch to any of these new scenarios to view different results in the worksheet. A scenario is a set of values that a user can create and save and then substitute at any time in the worksheet. Scenarios are part of a group of commands that can be called what-if analysis tools. Solver is a tool that helps you find solutions to problems involving multiple variables. In our Advanced Excel class, we cover many of the most important functions, including IF, Ifs, VLookup, HLookup, XLookup, SumIf, and Concatenate. When the desired result of a calculated cell is known, but not the input value that calculation needs to reach that result, you can use Goal Seek. Goal Seek allows you to calculate an unknown value in a given formula, but is only useful for problems that involve finding a single variable.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |