商品詳情
LYNDA UP AND RUNNING WITH EXCEL WHAT IF ANALYSIS 視頻教學 英文教學版
商品編號:
本站售價:NT$200
碟片片數:1片
瀏覽次數:34484
|
【轉載TXT文檔】
|
您可能感興趣:
您可能也喜歡:
商品描述
軟體簡介:
Make better decisions for your business by taking a deeper dive into your
data with Microsoft Excel's analysis tools. In this advanced course, Curt
Frye shows how to analyze hypothetical business cases using formulas and
variable data. He'll show you how to build data tables, define alternative
data sets with scenarios, find target values with Goal Seek, and analyze
complex problems with Solver. The last two chapters show you how to create
a configurable model with sliders and check boxes and how to run a Monte
Carlo simulation.
Topics include:
‧Creating a scenario
‧Defining data tables
‧Finding a target value with Goal Seek
‧Defining constraints and running Solver
‧Creating a configurable model
‧Manipulating your model
‧Running a Monte Carlo simulation