…When you summarize data in excel, it's easy to ask questions…such as what percentage of my revenue comes from the Northeast region?…It is a far different question to ask, how much do I need…to increase my revenue so the Northeast region accounts for 20% of the total?…Rather than create a complex formula and try multiple solutions, you can use…the goal seek feature to find answers to that type of question quickly.…For this movie I will use the goal seek sample file.…Which you can find in the chapter two folder of your exercise files archive.…This worksheet contains sales values for calendar year 2013…for five different regions; Pacific,…Mountain, Central, Southeast and Northeast.…
It also indicates the percentage that each of the regions accounts for.…As you can see, my northeast region is fairly low.…12.27%.…Now let's say that I want to find out how…much I would have to increases sales from the northeast region…for that region to account for 20% of the total.…And currently it's just over 12%, so let's say that I look at the total of…
- 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.