CLRC offers its member constituents (including members of our five participating library systems and individual members) access to the entire lynda.com training library at no charge.
For more information on how to request an access code, please click here.
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
View this entire Up and Running with Excel What-If Analysis and more in the lynda.com library.
CLRC’s subscription to lynda.com is a service of the NY 3Rs Association, Inc., and is supported by Regional Bibliographic Data Bases and Interlibrary Resources Sharing (RBDB) funds.
