Excel: Using Solver for Decision Analysis
Focused View
Curt Frye
1:53:02
293 View
01 - Optimize your analysis in Excel.mp4
00:31
02 - What you should know before starting.mp4
01:02
01 - Find target values using Goal Seek.mp4
03:30
02 - Introduce linear, nonlinear, and evolutionary programming.mp4
02:12
03 - Install the Solver add-in on Windows.mp4
01:41
04 - Organize a worksheet for use in Solver.mp4
03:42
05 - Find a solution using Solver.mp4
04:29
06 - Challenge Create a Solver model.mp4
01:59
07 - Solution Create a Solver model.mp4
05:35
01 - Introduce the problem.mp4
02:24
02 - Organize the worksheet.mp4
02:34
03 - Create objective and control formulas.mp4
03:26
04 - Create and run the Solver model.mp4
06:11
05 - Experiment with different constraints.mp4
04:26
06 - Challenge Tune an investment portfolio.mp4
02:01
07 - Solution Tune an investment portfolio.mp4
06:24
01 - Introduce the problem.mp4
01:39
02 - Organize the worksheet.mp4
03:56
03 - Map store and depot locations.mp4
02:21
04 - Create objective and control formulas.mp4
03:36
05 - Create and run the Solver model.mp4
06:07
06 - Extend the model by adding population density.mp4
02:38
07 - Challenge Optimize resource placement.mp4
01:47
08 - Solution Optimize resource placement.mp4
09:43
01 - Introduce the problem.mp4
02:46
02 - Organize the worksheet.mp4
05:43
03 - Calculate the probability of reaching a node.mp4
05:20
04 - Calculate the expected value for the tree.mp4
04:48
05 - Challenge Define a decision tree.mp4
02:05
06 - Solution Define a decision tree.mp4
07:05
01 - Additional resources.mp4
01:21
Description
You can use Excel's Solver function to find optimal solutions to a wide range of problems, from simple to complex. In this course, Excel power user Curt Frye shows you how, with a wide range of potential challenges. Curt explains the basics of working with Solver and gives you a chance to create a Solver model. He steps through how to tune investment portfolios, then goes over the specific approach that you need to use Solver for resource placement analysis. Plus, Curt covers the process of decision tree analysis in Excel.
More details
User Reviews
Rating
average 0
Focused display
Category
Curt Frye
Instructor's CoursesI'm president and founder of Technology and Society, Incorporated, an Oregon "C" Corporation that encompasses my work as a course developer, writer, and speaker. I offer programs on effective teamwork, personal development, and business storytelling. BA (political science) and MBA.
Linkedin Learning
View courses Linkedin LearningLinkedIn Learning is an American online learning provider. It provides video courses taught by industry experts in software, creative, and business skills. It is a subsidiary of LinkedIn. All the courses on LinkedIn fall into four categories: Business, Creative, Technology and Certifications.
It was founded in 1995 by Lynda Weinman as Lynda.com before being acquired by LinkedIn in 2015. Microsoft acquired LinkedIn in December 2016.
- language english
- Training sessions 31
- duration 1:53:02
- Release Date 2022/12/28
