->
Lynda - Learning Excel What-If Analysis - 150165
Lynda - Learning Excel What-If Analysis
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.


Table of Contents

  • Introduction
  • 1. Defining Scenarios and Data Tables
  • 2. Creating Goal Seek and Solver Models
  • 3. Creating a Configurable Model
  • 4. Performing Monte Carlo Simulation
  • Conclusion
  • Lynda - Learning Excel What-If Analysis


     TO MAC USERS: If RAR password doesn't work, use this archive program: 

    RAR Expander 0.8.5 Beta 4  and extract password protected files without error.


     TO WIN USERS: If RAR password doesn't work, use this archive program: 

    Latest Winrar  and extract password protected files without error.


     Coktum   |  

    Information
    Members of Guests cannot leave comments.




    rss