Webinar

K2's Excel Budgeting Techniques

  • Friday, December 22, 2017

    3:30pm – 5:30pm
  • 2
    CREDITS
    Computer Software and Applications

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.

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

Highlights

  • 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
  • Additional Information

    Designed For

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

    Vendor

    K2 Enterprises

    Advanced Preparation

    None

    Prerequisite

    Good working knowledge of Excel

    Field of Study

    Computer Software and Applications

    Course Number

    1780420

    Level of Knowledge

    Intermediate

    Add to Cart

    View All Courses