K2's Excel Budgeting Techniques - On Demand (2 hours)

Course Description

Excel provides an outstanding variety of tools for accumulating, analyzing, and reporting budgetary data. This session focuses on the analytical features available in Excel for preparing budgets.

Major Topics

• Performing regression analysis for forecasting
• Using data tables for sensitivity analysis
• Implementing linear programming with Goal Seek and Solver
• Calculating moving averages automatically with built-in Excel functionality
• Employing Scenario Manager for comparative budget reporting

Learning Objectives

Upon completing this course, you should be able to:

• Differentiate between one-way and two-way data tables for forecasting revenues and expenses
• Specify the four components of the regression equation
• List some of the regression functions available in Excel
• Describe the general procedure for using Solver in the budget process
• Identify three automated methods of consolidating budget data

Who Should Attend: Accounting and financial professionals involved in the budget process who want to use Excel more effectively

Course Level: Intermediate

CPE Credits: 2 Hours Computer Software and Applications  

Prerequisites: Good working knowledge of Excel

Advance Preparation: None

Instructional Delivery Method: QAS on-demand learning, including review and final exam questions. To earn credit, participants must pass the final exam with a score of 70% or better within one year of registering for this course. Participants may attempt take the final exam up to 10 times.