Start learning with our library of video tutorials taught by experts. Get started
Viewers: in countries Watching now:
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.
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 two variable data tables. Next, I'll show you how to find a target values 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 to vary inputs into a model, using tools such as sliders and checkboxes, while chapter four, shows you how to create a Monte Carlo 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.
There are currently no FAQs about Up and Running with Excel What-If Analysis.
Access exercise files from a button right under the course name.
Search within course videos and transcripts, and jump right to the results.
Remove icons showing you already watched videos if you want to start over.
Make the video wide, narrow, full-screen, or pop the player out of the page into its own window.
Click on text in the transcript to jump to that spot in the video. As the video plays, the relevant spot in the transcript will be highlighted.