K2's Budgeting and Forecasting Tools and Techniques
Are your budgeting and forecasting processes working as well for you as they should? Probably not, because many organizations report that these activities consume tremendous amounts of time and yield only marginal benefits. In this course, you will learn how to achieve a greater return on your budgeting and forecasting investment by taking advantage of various tools and techniques available in today’s market.
In addition to learning how to utilize Excel more effectively, you will also learn about other tools, such as Budget Maestro, PROPHIX, and Host Analytics can improve budgeting results. Additionally, you will learn how to reduce your dependency on Excel to obtain better results in less time. Importantly, you will also learn how to account for risk and uncertainty in your models and why doing so is a best practice. If you are involved in budgeting and forecasting activities, you will not want to miss this opportunity to identify how to reduce the amount of time you spend on these tasks, while simultaneously increasing their value.
“Great variety of examples were presented which allows for everyone to take away something to use at work. Great PDF of material covered. I appreciate the spreadsheet download which can be reviewed after the class as well. Good job.” C.T., CPA UT
CPE Credit: Recommended for 4 hours Accounting and 4 hours Computer Software and Applications
Instructional delivery method: Group-live demo and discussion using color computer projection – laptop friendly, with access to demonstration files
Prerequisites: Fundamental knowledge of Microsoft Office Excel 2013 newer
Program level: Intermediate
Advance preparation: None
Who should attend: Business professionals involved in budgeting and forecasting activities
Upon completing this course, you should be able to:
- Identify and implement best techniques to secure sensitive information in Excel workbooks and also to collaborate with others
- Apply specific Excel techniques for interacting with the accounting system, when linking data into budgeting and forecasting models
- Identify situations when you should use various Excel techniques such as Data Tables, Goal Seek, Solver, Scenario Manager, Regression Analysis, and Monte Carlo simulations
- Implement various Excel functions – including NPV, IRR, XNPV, and XIRR – in capital budgeting situations, and identify the various methods by which Excel computes depreciation
- Compare and contrast Excel with other budgeting and forecasting applications and describe situations where using other solutions is preferable