…Thanks again for working with Up and Running with Excel What-If Analysis.…I hope you've learned a lot and that…you can apply what you've learned to your business.…If you want to do further research, and this is a very rich…topic that I've only scratched the surface of, I have three resources to recommend.…The first two are books; and those are Excel Data…Analysis: Modeling and Simulation by Hector Guerrero, and also Microsoft Excel…2010: Data Analysis and Business Modeling by Wayne Winston.…
Finally, because you're already a…subscriber to the lynda.com Online Training…Library, you have access to the video series Wayne Winston on Analytics.…Wayne is the author of the second book.…He is absolutely brilliant and has a lot…of terrific insights on modeling and business data analysis.…I know you will get alot of out of those three resources.…Thanks again and good luck.…
- 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.