最新消息:网盘下载利器JDownloader--|--发布资讯--|--解压出错.密码问题

Lynda – Microsoft Excel: Using Solver for Decision Analysis

其他教程 killking 0评论
Lynda - Microsoft Excel: Using Solver for Decision Analysis

Lynda - Microsoft Excel: Using Solver for Decision Analysis

Size: 213 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 - Microsoft Excel: Using Solver for Decision Analysis
Download 百度云
链接: https://pan.baidu.com/s/1slz1o8P 密码: 4hpk

您必须 登录 才能发表评论!