Shoping cart:
Empty
Cheap Software
Search by Letter:
A B C D E F G H I J K L M N O P Q R S T U V W X Y Z All programs New Mac

Lynda.com Microsoft Excel Using Solver for Decision Analysis

10$
Buy!Download Size: 203.09 MB




Duration: 1h 43m
Video: AVC (.mp4) 1280x720 15&30fps
Audio: AAC 48KHz 2ch
Genre: eLearning
Level: Intermediate
Language: English

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.

Topics include:
- Finding target values using Goal Seek
- Finding a solution using Solver
- Tuning investment portfolios
- Organizing worksheets
- Creating objective and control formulas
- Experimenting with different constraints
- Optimizing resource placement
- Defining decision trees


Lynda.com Microsoft Excel Using Solver for Decision Analysis

10$
Buy!Download Size: 203.09 MB


Customers who bought this program also bought:


Lynda.com Google SketchUp 8 Essential Training (1 dvd) $15 BUY!


Software Store Deal of the Day

2010 SUPER PACK 4

2010 SUPER PACK 4

Unclude: Adobe Acrobat 9.0 Pro Extended (1 dvd), Adobe Photoshop CS5 Extended 12.0 (1 dvd), Autodesk Autocad LT 2011 (1 dvd), Corel WinDVD Pro 2010 10.0.5.291 Multilingual, CorelDRAW Graphics Suite X5 15.0.0.486, DVD Cloner VII 7.10.992, TechSmith Camtasia Studio 7.0.0

Real PriceSaving Deal of the Day View it »
$2960 94.6%229$BUY!
We recommend
Categories
© 2010-2017. All rights reserved.