K2's Excel Budgeting Techniques

  • Friday, December 22, 2017

    3:30pm – 5:30pm
  • 2
    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.


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


  • 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


    K2 Enterprises

    Advanced Preparation



    Good working knowledge of Excel

    Field of Study

    Computer Software and Applications

    Course Number


    Level of Knowledge


    Add to Cart

    View All Courses