Up and Running with Excel What-if analysis

1. 03 Creating a Configurable Model03_03 Creating check boxes.mp423.78 MB
2. 02 Creating Goal Seek And Solver Models02_04 Defining constraints and running Solver.mp415.72 MB
3. 03 Creating a Configurable Model03_02 Creating a slider.mp413.09 MB
4. 04 Performing Monte Carlo Simulation04_02 Creating an input table.mp411.21 MB
5. 04 Performing Monte Carlo Simulation04_04 Running and evaluating your simulation.mp410.53 MB
6. 01 Defining Scenarios and Data table01_02 Showing and hiding scenarios.mp410.35 MB
7. 02 Creating Goal Seek And Solver Models02_05 Requiring integer solutions.mp410.15 MB
8. 00 Introduction00_01 Welcome.mp49.47 MB
9. 04 Performing Monte Carlo Simulation04_01 Crafting a scenario.mp49.17 MB
10. 01 Defining Scenarios and Data table01_01 Creating a scenario.mp48.94 MB
11. 02 Creating Goal Seek And Solver Models02_03 Setting up a Solver worksheet.mp48.7 MB
12. 02 Creating Goal Seek And Solver Models02_01 Finding a target value using Goal Seek.mp48.58 MB
13. 01 Defining Scenarios and Data table01_04 Editing and deleting scenarios.mp48.33 MB
14. 04 Performing Monte Carlo Simulation04_03 Calculating demand.mp48.12 MB
15. 01 Defining Scenarios and Data table01_03 Summarizing scenarios.mp48.03 MB
16. 01 Defining Scenarios and Data table01_05 Defining a one-variable data table.mp47.6 MB
17. 03 Creating a Configurable Model03_04 Manipulating your model.mp47.25 MB
18. 03 Creating a Configurable Model03_01 Organizing your analysis worksheet.mp46.85 MB
19. 01 Defining Scenarios and Data table01_06 Defining a two-variable data table.mp46.4 MB
20. 02 Creating Goal Seek And Solver Models02_02 Activating Solver.mp45.32 MB
21. 05 Conclusion05_01 Next steps.mp42.18 MB
22. 00 Introduction00_02 What you should know before watching this course.mp41.11 MB
23. 00 Introduction00_03 Using the excersice files.mp41010.16 KB
24. Exercise FilesChapter01TaxAndIncome.xlsx33.22 KB
25. Exercise FilesChapter01TaxRateIncrease.xlsx33.17 KB
26. Exercise FilesChapter01EditAndDelete.xlsx22.99 KB
27. Exercise FilesChapter01ShowAndHide.xlsx22.99 KB
28. Exercise FilesChapter01Summarize.xlsx22.99 KB
29. Exercise FilesChapter02Goal Seek.xlsx22.89 KB
30. Exercise FilesChapter01CreateScenario.xlsx22.75 KB
31. Exercise FilesChapter03Manipulate.xlsx14.86 KB
32. Exercise FilesChapter04RunModel.xlsx12.44 KB
33. Exercise FilesChapter04Lookup.xlsx12.36 KB
34. Exercise FilesChapter03CheckBoxes.xlsx12.15 KB
35. Exercise FilesChapter02IntegerSolutions.xlsx10.94 KB
36. Exercise FilesChapter02SolverModel.xlsx10.9 KB
37. Exercise FilesChapter02SolverOptimization.xlsx10.85 KB
38. Exercise FilesChapter04InputTable.xlsx10 KB
39. Exercise FilesChapter04MonteCarloSetup.xlsx9.91 KB
40. Exercise FilesChapter03Sliders.xlsx9.64 KB
41. Exercise FilesChapter03ModelSetUp.xlsx9.64 KB