Attend upcoming webinar and earn continuing education credits. Introduction to What-If Analysis in Microsoft Excel | | | | | | | November | | 27 | 3 pm - 4:40 pm ET | | Presenter: David Ringstrom, an author and nationally recognized instructor | | Credits: CPE (Credit Details) | | Can't attend live? By registering, you will be able to view the course live, view a recording at any time after the live presentation, or both. | | Viewing Options: View on your computer, tablet, or smartphone | | | | | | | | | | 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 make use of 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 to perform basic what-if analyses, allowing you to solve for a single value. You will then 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 Excel 2016. You will learn to recognize any differences in Excel 2013, 2010, or 2007 during the presentation, and will receive detailed handouts. You will also receive an Excel workbook that includes most of the examples reviewed during the webinar. Who should attend: Practitioners seeking to understand the what-if problem-solving capabilities in Excel. You will learn how to: - Avoid writing repetitive formulas using Excel's Data Table feature
- Contrast Excel's Data Table feature with traditional approaches used in spreadsheets
- Utilize the PMT worksheet function to calculate loan payment amounts
- Utilize a work-around that will let you go beyond the 32-input limit built into Scenario Manager
- Use Excel's Solver feature, and save Solver results to Excel's Scenario Manager for reuse
- Utilize the CUMIPMT worksheet function to calculate interest amounts for any period of a loan without utilizing an amortization table
- Implement a simple Excel macro that will empower you to apply multiple scenarios at once when you have more than 32 inputs
- Enable Excel's Solver Add-in for more complex what-if analyses
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
| | | | | | | David H. Ringstrom, CPA, is an author and nationally recognized instructor who teaches scores of webinars each year. His Excel courses are based on 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. | | | | | | | | | ● Earn continuing education credit for no additional fee ● Access courses on your computer, tablet, or smartphone ● More than 75 live webinars each month ● More than 1,500 on-demand courses | | | | | |
No comments:
Post a Comment