K2's Budgeting and Forecasting Tools and Techniques

K2's Budgeting and Forecasting Tools and Techniques

Course Description



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

Course Information

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

Learning Objectives

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
Share on facebook
Share on twitter
Share on linkedin