Excel Budgeting Techniques

Overview:

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

Course Content:

In this course, you will gain knowledge about the following 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 Will Benefit: 

Accounting and financial professionals involved in the budget process who want to use Excel more effectively.