Microsoft Excel: Using Solver for Decision Analysis

Microsoft Excel: Using Solver for Decision Analysis

Website or Online Data - 2017
Rate this:
Learn how to leverage Solver-a Microsoft Office Excel add-in-to find optimal solutions to problems with multiple constraints.
Solver-a Microsoft Office Excel add-in-can help you analyze your data more efficiently. In this course, learn how to leverage Solver to find optimal solutions to problems with multiple constraints. Curt Frye explains how to install Solver, organize worksheets to make the data and summary operations clear, and find a solution using Solver. He also takes you through how to optimize investment portfolios by setting rules that limit the risk you're willing to take on, as well as how to change a model's parameters to analyze various scenarios. Plus, Curt shares how to define decision trees, represent a tree in an Excel table, and calculate the probability of reaching a node in your decision tree.LinkedIn Learning (Lynda.com) is a PMI Registered Education Provider. This course qualifies for professional development units (PDUs). To view the activity and PDU details for this course, click here.The PMI Registered Education Provider logo is a registered mark of the Project Management Institute, Inc.
Publisher: Carpenteria, CA lynda.com, 2017
Additional Contributors: lynda.com (Firm)

Related Resources


Opinion

From the critics


Community Activity

Comment

Add a Comment

There are no comments for this title yet.

Age Suitability

Add Age Suitability

There are no age suitabilities for this title yet.

Summary

Add a Summary

There are no summaries for this title yet.

Notices

Add Notices

There are no notices for this title yet.

Quotes

Add a Quote

There are no quotes for this title yet.

Explore Further

Recommendations

Subject Headings

  Loading...

Find it at GSPL

  Loading...
[]
[]
To Top