Webinar Details

Accelerate Excel: Tools for What-If Analysis

Thursday, June 28, 2018

12:00 p.m. Mountain time (MT)

Program Description

Excel expert David Ringstrom, CPA, highlights the What-If Analysis tools available within Microsoft Excel’s Data menu in this valuable webcast. You’ll learn how and when to make use of Excel’s Scenario Manager, how to implement the Data Table feature to compare calculation results based on two or three inputs, how Excel’s Goal Seek feature empowers you to perform basic what-if analyses to solve for a single value, and much more.

David demonstrates every technique at least twice: first, on a PowerPoint slide with numbered steps, and second, in Excel 2016. He’ll draw to your attention any differences in Excel 2013, 2010, or 2007 during the presentation as well as in his detailed handouts. David also provides an Excel workbook that includes most of the examples he uses during the webcast.

Topics Typically Covered

Avoiding the need to write repetitive formulas using Excel’s Data Table feature.
Comparing the results of multiple scenarios within a pivot table.
Contrasting Excel’s Data Table feature with traditional approaches used in spreadsheets.
Enabling Excel’s Solver Add-in for more complex what-if analyses.
Enhancing the Summary Report generated by the Scenario Manager with range names.
Exploring Excel’s Goal Seek feature, which can be used to solve for a single missing input.
Exploring Excel’s Scenario Manager feature that enables you to store various sets of inputs, such as best case, worst case, and most likely, but without having to replicate worksheets or workbooks.
Exploring the Forecast Sheet feature in Excel 2016, which can extrapolate trends based on existing data in your spreadsheets.
Implementing a simple Excel macro that will empower you to apply multiple scenarios at once when you have more than 32 inputs.
Learning how to save Solver results to Excel’s Scenario Manager for reuse.
Learning the basics of Excel’s Solver feature.
Merging scenarios from other workbooks into your present workbook.

Learning Objectives

After completing this webinar, attendees will be able to:

Identify when to use Excel’s Goal Seek feature versus Solver.
Demonstrate how to use the Data Table feature in Excel to compare calculation results based on varying inputs.
Define how to make one workbook serve multiple purposes by way of Excel’s Scenario Manager.

Who Should Attend

Practitioners seeking to understand the what-if problem-solving capabilities in Excel.

Presenter(s)

David H. Ringstrom, CPA
Mr. Ringstrom is an author and nationally recognized instructor who teaches scores of webinars each year. His Excel courses are based on over 25 years of consulting and teaching experience. David’s mantra is “Either you work Excel, or it works you,” so he focuses on what he sees users don’t, but should, know about Microsoft Excel. His goal is to empower you to use Excel more effectively. To learn more about David, you can view his LinkedIn profile and follow him on Facebook or Twitter (@excelwriter).

CPE Credit

Program Level: Intermediate	Prerequisites: Experience Using Excel to Store Data	Advanced Preparation: None
Delivery Method: Group Internet-Based	CPE Credits: Two (2) Hours	Fields of Study: Computer Software & Applications

Buy Now