Lynda - Up and Running with Excel What-If Analysis
English | 1h 10m | AVC (.mp4) 960x540 15fps | AAC 48KHz 2ch | 202 Mb
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.
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
[Tutorials] Lynda - Up and Running with Excel What-If Analysis Fast Download via Rapidshare Hotfile Fileserve Filesonic Megaupload, [Tutorials] Lynda - Up and Running with Excel What-If Analysis Torrents and Emule Download or anything related.