Frye, Curt
Microsoft Excel: Using Solver for Decision Analysis
eMedium

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.

Dieses Medium ist ein elektronisches Medium (eLearning). Sie können dieses Medium im eMedien-Portal Ihrer Bibliothek ansehen, entleihen oder vormerken.
Zum Download / Zur Anzeige

Weiterführende Informationen

Personen: Frye, Curt

Frye, Curt:
Microsoft Excel: Using Solver for Decision Analysis : LinkedIn, 2017. - 01:43:14.00

Zugangsnummer: EM-1505192365
eMedium