In this practical webinar, Excel expert, David Ringstrom, CPA, gets you up to speed on the What-If Analysis tools available within Excel’s Data menu. You will learn how and when to use Excel’s Scenario Manager, as well as how to use the Data Table feature to compare calculation results based on two or three inputs. You will also learn how to use Excel’s Goal Seek feature, which allows you to solve for a single value and to perform basic what-if analyses. In addition, you will receive a brief overview of Excel’s Solver feature.
You will see each technique demonstrated at least twice: first, on a PowerPoint slide with numbered steps, and second, in the subscription-based Office 365 version of Excel. David draws your attention to any differences in the older versions of Excel (2019, 2016, 2013, and earlier) during the presentation, as well as in his detailed handouts. You will also receive an Excel workbook that includes most of the examples used 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.
You will learn how to:
- Utilize the CUMIPMT worksheet function to calculate interest amounts for any period of a loan without utilizing an amortization table.
- Avoid the need to write repetitive formulas using Excel’s Data Table feature.
- Enable Excel’s Solver Add-in for more complex what-if analyses.
- Explore Excel’s Goal Seek feature, which can be used to solve for a single missing input.
- Explore the Forecast Sheet feature in Excel 2016, which can extrapolate trends based on existing data in your spreadsheets.
- Save Solver results to Excel’s Scenario Manager for reuse.
- Implement a simple Excel macro that will empower you to apply multiple scenarios at once when you have more than 32 inputs.
- Utilize a work-around that will let you go beyond the 32-input limit built into Scenario Manager.
- Describe the basics of Excel’s Solver feature.
Upon course completion, you will be able to:
- Identify when to use Excel’s Goal Seek feature versus Solver.
- Determine 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.
Prerequisites: None. Experience using Excel to store lists of data is recommended.
Advance Preparation: None
Program Level: Intermediate
Field of Study: Computer & Software Applications (2 hours)
Credit Type: Self-Study credit (Please note that to receive Self-Study credit you will need to complete a final exam after viewing the webinar.)