Learning Excel What-If Analysis.
(Online Course)
Author
Contributors
Published
Carpenteria, CA linkedin.com, 2022.
Format
Online Course
Status
Description
Loading Description...
Also in this Series
Checking series information...
More Details
Language
English
Notes
General Note
2/08/202212:00:00AM
Participants/Performers
Presenter: Curt Frye
Description
Find out how to analyze hypothetical business cases in Excel.
Description
Excel is a useful and versatile tool, but did you know you can also use it to analyze hypothetical business cases? Instructor Curt Frye walks you through the complete process. Curt begins by showing you how to create, define, edit, and delete scenarios, then goes into defining data tables. He explains how to use Goal Seek and Solver to create models, define constraints, and require integer solutions. Next, Curt covers ways to organize your analysis worksheet, use checkboxes to turn options on and off, and manipulate a worksheet model to analyze your business. Plus, he defines and demonstrates how to perform a Monte Carlo simulation.
System Details
Latest version of the following browsers: Chrome, Safari, Firefox, or Internet Explorer. Adobe Flash Player Plugin. JavaScript and cookies must be enabled. A broadband Internet connection.
Citations
APA Citation, 7th Edition (style guide)
Frye, C. (2022). Learning Excel What-If Analysis . linkedin.com.
Chicago / Turabian - Author Date Citation, 17th Edition (style guide)Frye, Curt. 2022. Learning Excel What-If Analysis. linkedin.com.
Chicago / Turabian - Humanities (Notes and Bibliography) Citation, 17th Edition (style guide)Frye, Curt. Learning Excel What-If Analysis linkedin.com, 2022.
MLA Citation, 9th Edition (style guide)Frye, Curt. Learning Excel What-If Analysis linkedin.com, 2022.
Note! Citations contain only title, author, edition, publisher, and year published. Citations should be used as a guideline and should be double checked for accuracy. Citation formats are based on standards as of August 2021.