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