Attend upcoming webinar and earn continuing education credits. Forecasting with Excel's Powerful Sensitivity Tools | | | | | | | November | | 9 | 3 pm - 4:40 pm ET | | Presenter: Miles Hutchinson, CGMA, president of Sales Tax Advisors, Inc. | | 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 | | | | | | | | | | Financial analysis is an area of opportunity and risk. Analysis should incorporate tests of sensitivity to changes in key variables using the most advanced tools available. Typical financial models do not effectively utilize these tools. This exposes the analyst to blind spots in analysis. In this webinar, you will learn how to become more proficient in financial analysis using Excel. Upon completion of the course, you will be able to: - List the 20 rules of effective model design
- Apply Scroll Bars to individual cells to flex them over their relative ranges with the touch of your mouse
- Use Goal Seek to discover how much a single variable must move to reach a desired outcome
- Use Data Tables with one or two-inputs to deliver an array of outcomes from your model in just seconds
- Use Scenario Manager to store selected groupings of inputs and resulting outcomes
- Use Scenario Manager to consolidate all "versions" of your model into one file
- Use the standard Scenario Summary to compare your Scenarios automatically
| | | | | | | Miles Hutchinson, CGMA, is the president of Sales Tax Advisors, Inc. Mr. Hutchinson was previously an auditor at PWC and the Chief Financial Officer of a billion dollar real estate development company. Mr. Hutchinson has presented over 2,500 seminars and training sessions on topics such as financial analysis and modeling, accounting, strategic planning, and SOX compliance. He is a graduate of University of Missouri – Kansas City. | | | | | | | | | ● 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,300 on-demand courses | | | | | |
No comments:
Post a Comment