Live
Excel Efficiency: What-If Analysis
Price: FREE
Jun. 27, 2019 Thursday
11:00 AM - 12:00 PM (Pacific)
1 Hour
David Ringstrom President and CPA, Accounting Advisors Inc
In this presentation by Excel expert David Ringstrom, you’ll learn about the What-If Analysis tools available within Excel’s Data menu. David explains how and when to make use of the Scenario Manager, as well as how to use the Data Table feature to compare calculation results based on two or three inputs. In addition, he gives a brief overview of Excel’s Solver feature and demonstrates how to use Excel’s Goal Seek feature.
David demonstrates every technique at least twice: first, on a PowerPoint slide with numbered steps, and second, in Excel 2019. David draws your attention to any differences in the older versions of Excel (2016, 2013, and earlier) during the presentation as well as in his detailed handouts. You’ll also discover some features only available in Office 365 but not in Excel 2019. David also provides an Excel workbook that includes most of the examples he uses during the webcast.
Office 365 is a subscription-based product that provides new-feature updates as often as monthly. Conversely, the perpetual licensed versions of Excel have feature sets that don’t change. Perpetual licensed versions have year numbers, such as Excel 2019, Excel 2016, and so on.
David demonstrates every technique at least twice: first, on a PowerPoint slide with numbered steps, and second, in Excel 2019. David draws your attention to any differences in the older versions of Excel (2016, 2013, and earlier) during the presentation as well as in his detailed handouts. You’ll also discover some features only available in Office 365 but not in Excel 2019. David also provides an Excel workbook that includes most of the examples he uses during the webcast.
Office 365 is a subscription-based product that provides new-feature updates as often as monthly. Conversely, the perpetual licensed versions of Excel have feature sets that don’t change. Perpetual licensed versions have year numbers, such as Excel 2019, Excel 2016, and so on.
Learning Objectives
After attending this event you will be able to:
Describe how to apply Excel’s Solver Add-in for more complex what-if analyses.
Apply the PMT worksheet function to calculate loan payment amounts.
Define how to make one workbook serve multiple purposes by way of Excel’s Scenario Manager.
Speakers
David Ringstrom
President and CPA, Accounting Advisors Inc
David H. Ringstrom is a CPA and owner of Accounting Advisors, Inc., an Atlanta-based spreadsheet consulting firm that he started in 1991. David speaks at conferences on Excel and presents scores of webinars each year. He is an author and served as the technical editor for over 30 books on accounting software. Some of his freelance articles on spreadsheets have been published internationally.
Moderated by Jennifer Robbins
Illumeo Webinar Manager
Jennifer is a marketing specialist and the webinar manager for Illumeo. She has been a part of more than 300 webinar presentations, supporting our expert presenters and Illumeo users alike. When she’s not moderating webinars, she’s creating and managing marketing content.
