Introduction to What-If Analysis in Microsoft Excel

Attend upcoming webinar and earn continuing education credits. Live Webinars   |   On-Demand   |   All-Access Plan Manage Preferences    |    View in Browser 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 Learn More Register Today Course Description   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 Learn More Register Today About The Presenter   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. Learn More Register Today All-Access Membership   ● 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 Learn More Upcoming Webinars TIN Solicitation Best Practices November 13 at 1 pm ET Learn More Assignments for the Benefit of Creditors: A Bankruptcy Alternative November 13 at 1 pm ET Learn More Tax Cuts and Jobs Act: Impact on Commercial Real Estate November 13 at 3 pm ET Learn More Questions? Please call us at 703-372-0550 Our Mailing Address: Clear Law Institute | 4601 N. Fairfax Dr., Ste 1200 | Arlington | VA | 22203 Remove me from future emails. Manage email preferences. This email was sent to virginia.duffy.planetduffy@blogger.com. If you are receiving it in error, please reply to this email.