Lynda - Up and Running with Excel What-if Analysis (Size: 202.19 MB)
| | | 01_02 Showing and hiding scenarios.mp4 | 10.35 MB |
| | | 01_01 Creating a scenario.mp4 | 8.94 MB |
| | | 01_04 Editing and deleting scenarios.mp4 | 8.33 MB |
| | | 01_03 Summarizing scenarios.mp4 | 8.03 MB |
| | | 01_05 Defining a one-variable data table.mp4 | 7.6 MB |
| | | 01_06 Defining a two-variable data table.mp4 | 6.4 MB |
| | | 02_04 Defining constraints and running Solver.mp4 | 15.72 MB |
| | | 02_05 Requiring integer solutions.mp4 | 10.15 MB |
| | | 02_03 Setting up a Solver worksheet.mp4 | 8.7 MB |
| | | 02_01 Finding a target value using Goal Seek.mp4 | 8.58 MB |
| | | 02_02 Activating Solver.mp4 | 5.32 MB |
| | | 03_03 Creating check boxes.mp4 | 23.78 MB |
| | | 03_02 Creating a slider.mp4 | 13.09 MB |
| | | 03_04 Manipulating your model.mp4 | 7.25 MB |
| | | 03_01 Organizing your analysis worksheet.mp4 | 6.85 MB |
| | | 04_02 Creating an input table.mp4 | 11.21 MB |
| | | 04_04 Running and evaluating your simulation.mp4 | 10.53 MB |
| | | 04_01 Crafting a scenario.mp4 | 9.17 MB |
| | | 04_03 Calculating demand.mp4 | 8.12 MB |
| | | 05_01 Next steps.mp4 | 2.18 MB |
| | | TaxAndIncome.xlsx | 33.22 KB |
| | | TaxRateIncrease.xlsx | 33.17 KB |
| | | summarize.xlsx | 22.99 KB |
| | | EditAndDelete.xlsx | 22.99 KB |
| | | ShowAndHide.xlsx | 22.99 KB |
| | | CreateScenario.xlsx | 22.75 KB |
| | | goal seek.xlsx | 22.89 KB |
| | | IntegerSolutions.xlsx | 10.94 KB |
| | | SolverModel.xlsx | 10.9 KB |
| | | SolverOptimization.xlsx | 10.85 KB |
| | | Manipulate.xlsx | 14.86 KB |
| | | CheckBoxes.xlsx | 12.15 KB |
| | | Sliders.xlsx | 9.64 KB |
| | | ModelSetup.xlsx | 9.64 KB |
| | | RunModel.xlsx | 12.44 KB |
| | | LookUp.xlsx | 12.36 KB |
| | | InputTable.xlsx | 10 KB |
| | | MonteCarloSetup.xlsx | 9.91 KB |
| | | 00_01 welcome.mp4 | 9.47 MB |
| | | 00_02 What you should know before watching this course.mp4 | 1.11 MB |
| | | 00_03 Using the excersice files.mp4 | 1010.16 KB |
Description
Make better decisions for your business by taking a deeper dive into your data with Microsoft Excel's analysis tools. In this advanced course, Curt Frye shows how to analyze hypothetical business cases using formulas and variable data. He'll show you how to build data tables, define alternative data sets with scenarios, find target values with Goal Seek, and analyze complex problems with Solver. The last two chapters show you how to create a configurable model with sliders and check boxes and how to run a Monte Carlo simulation.
Topics include:
- Creating a scenario
- Defining data tables
- Finding a target value with Goal Seek
- Defining constraints and running Solver
- Creating a configurable model
- Manipulating your model
- Running a Monte Carlo simulation
Related Torrents
| torrent name |
size |
seed |
leech |
|
|
128.49 MB |
24 |
4 |
Sharing Widget
All Comments