Spreadsheet Skills for Planning, Forecasting & Budgeting

Created by LEC Team
Last updated Mon, 27-Mar-2023
Download as pdf

The applications will focus on 3 important aspects of service and financial administration - tactical planning, smart forecasting, and practical budgeting. Delegates will certainly find out just how available the power of Excel is to give reasonable forecasts as well as prepare flexible budget plans. The effect on efficiency in planning and control and also as a result ROI for business and/or departments will certainly be shocking.

Educating Purposes of Spreadsheet Abilities for Preparation, Forecasting & Budgeting


  • Browse the attributes and features of Excel
  • Compare information as well as a result in spreadsheet architecture
  • Analyze monetary declarations to intend ahead
  • Construct effective financial preparation models
  • Usage forecasting strategies for spending plan prep work


Day 1
Introduction to Spreadsheets using Excel
  • The power of Excel for building financial models

  • The Ribbons of Excel with their commands and functions

  • Using formulae: Copying, anchoring, and special pasting

  • Using functions: financial, statistical, and mathematical

  • Review of the financial objectives of business: ROI, ROA, ROE

  • Overview of Financial Statements

Case Study: Building a Quick Access Toolbar in Excel and applying it to the analysis of financial statements of a division.



Day 2
Proper Planning
  • Classical strategic planning models

  • Cost-Volume-Profit Analysis and Break-Even as a planning example

  • Economic Order Quantity as a planning example

  • What-if analysis to build scenario's and test sensitivity

  • Maximizing and optimizing techniques

  • Linear programming and Solver as optimising tools

Case Study: Preparing a planning model and subjecting it to a range of sensitivity analysis in a manufacturing environment.



Day 3
Fantastic Forecasting
  • Forecasting in perspective - the Past vs. the Future

  • The necessity to apply a range of different forecasting methods:

    • Qualitative Models used in forecasting

    • Quantitative Models focussing on time series and regressions methodology

  • Forecasting growth rates

  • Recording, applying, and modifying forecast assumptions

Case Study: Applying the forecasting functions in Excel to past data and building a model offering various scenario's



Day 4
Beyond Budgeting
  • The budget process: Timing and Cycles

  • Setting budgeting objectives and tolerance levels

  • Budgeting Techniques

  • "Beyond Budgeting" compared to traditional budgeting principles

  • Operating and Capital budgets

  • Monthly reporting procedures and timely action

Case Study: Building budget based on assumptions - Operating Budget, Cash Budget & Capital Budget



Day 5
Putting it together – building the comprehensive model
  • Considering the financing mix in strategy

  • Considering the Return to Shareholder as the primary indicator

  • Build your planning model

  • Build your forecasting model

  • Build your budgeting model

  • Link these together in a review

Case Study: Building an integrated planning, forecasting & budgeting model


Enquiry form
+ View more
Other related courses
00:00:00 Hours
Updated Mon, 27-Mar-2023
0 0 $0
00:00:00 Hours
Updated Mon, 27-Mar-2023
0 0 $0
00:00:00 Hours
0 0 $0
00:00:00 Hours
Updated Mon, 27-Mar-2023
0 0 $0
00:00:00 Hours
Updated Mon, 27-Mar-2023
0 0 $0
Dates Venues Price Details