Analyze hypothetical business cases using Excel formulas and variable data.
- Hi, I'm Curt Frye. Welcome to Up and Running with Excel What-If Analysis. In this course, I will show you how to use Excel to answer business questions, using variable data. I'll start by demonstrating how to define alternative data sets, using scenarios. And then move on to varying formula inputs, using one and a two variable data tables. Next I'll show you how to find a target value using Goal Seek, and then how to analyze complex problems using Solver. The final two chapters demonstrate the power of building models into your Excel worksheets.
Chapter three shows you how vary inputs into a model, using tools such as Sliders and Check Boxes. While Chapter four, shows you how to create a Monte Carlos simulation, using random events to model a business process. All of these methods provide the power and flexibility you need to make good decisions for your company. I'm sure you'll find that your time with Up and Running with Excel What-If Analysis will be time well spent. Dive right in.
- 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.