Skip to Main Content
Computing with Excel and VBA
book

Computing with Excel and VBA

by S.I. Krishan
August 2008
Beginner to intermediate content levelBeginner to intermediate
298 pages
10h 49m
English
Jones & Bartlett Learning
Content preview from Computing with Excel and VBA
Chapter 9 Data Analysis and Simulation218
tool, known as the Solver, to deal with such problems. The Solver works by carrying
out a smart search over all possible solutions. Details of Solver and how to use it are
beyond the scope of this book.
Scenario Manager
We have already looked at the Data Table and Goal Seeking features of the What-If-
Analysis command in Excel. The remaining option of the What-If-Analysis is the Scenario
Manager feature that enables you to define different scenarios and the correspond-
ing outcome in each case. The Scenario Manager is a useful tool to summarize different
options for an activity, say budgeting ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Excel Programming with VBA Starter

Excel Programming with VBA Starter

Robert F Martin
Programming Excel with VBA and .NET

Programming Excel with VBA and .NET

Jeff Webb, Steve Saunders

Publisher Resources

ISBN: 9780763756680