…Some worksheet calculations depend on changing one variable such…as a tax rate to determine a final value.…If you're not sure which tax rate will be in effect for a given period, but you…want to see the range of possible values you will have to pay for a set of rates.…You can create a one variable data table in a worksheet to display those values.…For this movie, I will use the tax rate increase sample workbook,…which you can find in the chapter one folder of your exercise…files archive.…This worksheet calculates the tax that will be due for a…taxable income of $14 million with a base tax rate of 3%.…
Note also in cell E3, I have a value for change.…And that is the amount the tax rate could go up.…And you see the range of possible values here, from F3 to F5.…So for this instance, I'm assuming that the tax rate will go…up by 1, 2, or 3%. The formula in cell G2 finds the tax…amount due by multiplying the taxable income in cell E4 by the…tax rate in cell E5, plus the change which is displayed in cell E3.…
And cell E3 is the one that we're going to change when we create our data table.…
- Explain how to create a scenario in Excel.
- Identify the two input values that should be used to create a two variable data table.
- Recall what the Excel feature Goal Seek is used for.
- Recognize the three things that must be separated from one another to make reading a worksheet with multiple units easier.
- Describe the tools that Excel provides to manipulate data.
- Break down the steps required to recalculate a worksheet's formulas.
Skill Level Intermediate
1. Defining Scenarios and Data Tables
2. Creating Goal Seek and Solver Models
3. Creating a Configurable Model
4. Performing Monte Carlo Simulation
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.