LYNDA UP AND RUNNING WITH EXCEL WHAT IF ANALYSIS 視頻教學 英文教學版
碟片編號:TIC2765
碟片數量:1片
銷售價格:200
瀏覽次數:34480
軟體簡介:
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