/  Spreadsheet Skills for Planning, Forecasting and Budgeting Training

Spreadsheet Skills for Planning, Forecasting and Budgeting Training

BMC Training provides a training course in Spreadsheet Skills for Planning, Forecasting and Budgeting in Finance , Accounting and Budgeting

Course Title
Venue
Start Date
End Date
  • Dubai
    27 - 10 - 2019
    31 - 10 - 2019
  • Paris
    27 - 10 - 2019
    31 - 10 - 2019
  • Hong Kong
    27 - 10 - 2019
    31 - 10 - 2019
  • Kuala Lumpur
    17 - 11 - 2019
    21 - 11 - 2019
  • Rome
    17 - 11 - 2019
    21 - 11 - 2019
  • Rome
    17 - 11 - 2019
    21 - 11 - 2019
  • Barcelona
    17 - 11 - 2019
    21 - 11 - 2019
  • Zurich
    17 - 11 - 2019
    21 - 11 - 2019
  • Dubai
    24 - 11 - 2019
    28 - 11 - 2019
  • Paris
    24 - 11 - 2019
    28 - 11 - 2019
  • Hong Kong
    24 - 11 - 2019
    28 - 11 - 2019
  • London
    3 - 11 - 2019
    7 - 11 - 2019
  • Madrid
    3 - 11 - 2019
    7 - 11 - 2019
  • Munich
    3 - 11 - 2019
    7 - 11 - 2019
  • Berlin
    3 - 11 - 2019
    7 - 11 - 2019
  • New York
    3 - 11 - 2019
    7 - 11 - 2019
  • Istanbul
    10 - 11 - 2019
    14 - 11 - 2019
  • Bali
    10 - 11 - 2019
    14 - 11 - 2019
  • Singapore
    10 - 11 - 2019
    14 - 11 - 2019
  • Washington
    10 - 11 - 2019
    14 - 11 - 2019
  • Dubai
    10 - 11 - 2019
    14 - 11 - 2019
  • Paris
    10 - 11 - 2019
    14 - 11 - 2019
  • Hong Kong
    10 - 11 - 2019
    14 - 11 - 2019
  • London
    15 - 12 - 2019
    19 - 12 - 2019
  • Madrid
    15 - 12 - 2019
    19 - 12 - 2019
  • Munich
    15 - 12 - 2019
    19 - 12 - 2019
  • Berlin
    15 - 12 - 2019
    19 - 12 - 2019
  • New York
    15 - 12 - 2019
    19 - 12 - 2019
  • Dubai
    22 - 12 - 2019
    26 - 12 - 2019
  • Paris
    22 - 12 - 2019
    26 - 12 - 2019
  • Hong Kong
    22 - 12 - 2019
    26 - 12 - 2019
  • Istanbul
    8 - 12 - 2019
    12 - 12 - 2019
  • Bali
    8 - 12 - 2019
    12 - 12 - 2019
  • Singapore
    8 - 12 - 2019
    12 - 12 - 2019
  • Washington
    8 - 12 - 2019
    12 - 12 - 2019
  • Kuala Lumpur
    1 - 12 - 2019
    5 - 12 - 2019
  • Rome
    1 - 12 - 2019
    5 - 12 - 2019
  • Rome
    1 - 12 - 2019
    5 - 12 - 2019
  • Barcelona
    1 - 12 - 2019
    5 - 12 - 2019
  • Zurich
    1 - 12 - 2019
    5 - 12 - 2019
  • Kuala Lumpur
    26 - 1 - 2020
    30 - 1 - 2020
  • Rome
    26 - 1 - 2020
    30 - 1 - 2020
  • Rome
    26 - 1 - 2020
    30 - 1 - 2020
  • Barcelona
    26 - 1 - 2020
    30 - 1 - 2020
  • Zurich
    26 - 1 - 2020
    30 - 1 - 2020
  • Dubai
    19 - 1 - 2020
    23 - 1 - 2020
  • Paris
    19 - 1 - 2020
    23 - 1 - 2020
  • Hong Kong
    19 - 1 - 2020
    23 - 1 - 2020
  • London
    12 - 1 - 2020
    16 - 1 - 2020
  • Madrid
    12 - 1 - 2020
    16 - 1 - 2020
  • Munich
    12 - 1 - 2020
    16 - 1 - 2020
  • Berlin
    12 - 1 - 2020
    16 - 1 - 2020
  • New York
    12 - 1 - 2020
    16 - 1 - 2020
  • Istanbul
    5 - 1 - 2020
    9 - 1 - 2020
  • Bali
    5 - 1 - 2020
    9 - 1 - 2020
  • Singapore
    5 - 1 - 2020
    9 - 1 - 2020
  • Washington
    5 - 1 - 2020
    9 - 1 - 2020
  • Dubai
    5 - 1 - 2020
    9 - 1 - 2020
  • Paris
    5 - 1 - 2020
    9 - 1 - 2020
  • Hong Kong
    5 - 1 - 2020
    9 - 1 - 2020
  • London
    23 - 2 - 2020
    27 - 2 - 2020
  • Madrid
    23 - 2 - 2020
    27 - 2 - 2020
  • Munich
    23 - 2 - 2020
    27 - 2 - 2020
  • Berlin
    23 - 2 - 2020
    27 - 2 - 2020
  • New York
    23 - 2 - 2020
    27 - 2 - 2020
  • Dubai
    16 - 2 - 2020
    20 - 2 - 2020
  • Paris
    16 - 2 - 2020
    20 - 2 - 2020
  • Hong Kong
    16 - 2 - 2020
    20 - 2 - 2020
  • Istanbul
    9 - 2 - 2020
    13 - 2 - 2020
  • Bali
    9 - 2 - 2020
    13 - 2 - 2020
  • Singapore
    9 - 2 - 2020
    13 - 2 - 2020
  • Washington
    9 - 2 - 2020
    13 - 2 - 2020
  • Kuala Lumpur
    2 - 2 - 2020
    6 - 2 - 2020
  • Rome
    2 - 2 - 2020
    6 - 2 - 2020
  • Rome
    2 - 2 - 2020
    6 - 2 - 2020
  • Barcelona
    2 - 2 - 2020
    6 - 2 - 2020
  • Zurich
    2 - 2 - 2020
    6 - 2 - 2020
  • Kuala Lumpur
    15 - 3 - 2020
    19 - 3 - 2020
  • Rome
    15 - 3 - 2020
    19 - 3 - 2020
  • Rome
    15 - 3 - 2020
    19 - 3 - 2020
  • Barcelona
    15 - 3 - 2020
    19 - 3 - 2020
  • Zurich
    15 - 3 - 2020
    19 - 3 - 2020
  • Dubai
    8 - 3 - 2020
    12 - 3 - 2020
  • Paris
    8 - 3 - 2020
    12 - 3 - 2020
  • Hong Kong
    8 - 3 - 2020
    12 - 3 - 2020
  • London
    1 - 3 - 2020
    5 - 3 - 2020
  • Madrid
    1 - 3 - 2020
    5 - 3 - 2020
  • Munich
    1 - 3 - 2020
    5 - 3 - 2020
  • Berlin
    1 - 3 - 2020
    5 - 3 - 2020
  • New York
    1 - 3 - 2020
    5 - 3 - 2020
  • Istanbul
    22 - 3 - 2020
    26 - 3 - 2020
  • Bali
    22 - 3 - 2020
    26 - 3 - 2020
  • Singapore
    22 - 3 - 2020
    26 - 3 - 2020
  • Washington
    22 - 3 - 2020
    26 - 3 - 2020
  • Dubai
    22 - 3 - 2020
    26 - 3 - 2020
  • Paris
    22 - 3 - 2020
    26 - 3 - 2020
  • Hong Kong
    22 - 3 - 2020
    26 - 3 - 2020
  • London
    26 - 4 - 2020
    30 - 4 - 2020
  • Madrid
    26 - 4 - 2020
    30 - 4 - 2020
  • Munich
    26 - 4 - 2020
    30 - 4 - 2020
  • Berlin
    26 - 4 - 2020
    30 - 4 - 2020
  • New York
    26 - 4 - 2020
    30 - 4 - 2020
  • Dubai
    5 - 4 - 2020
    9 - 4 - 2020
  • Paris
    5 - 4 - 2020
    9 - 4 - 2020
  • Hong Kong
    5 - 4 - 2020
    9 - 4 - 2020
  • Istanbul
    12 - 4 - 2020
    16 - 4 - 2020
  • Bali
    12 - 4 - 2020
    16 - 4 - 2020
  • Singapore
    12 - 4 - 2020
    16 - 4 - 2020
  • Washington
    12 - 4 - 2020
    16 - 4 - 2020
  • Kuala Lumpur
    19 - 4 - 2020
    23 - 4 - 2020
  • Rome
    19 - 4 - 2020
    23 - 4 - 2020
  • Rome
    19 - 4 - 2020
    23 - 4 - 2020
  • Barcelona
    19 - 4 - 2020
    23 - 4 - 2020
  • Zurich
    19 - 4 - 2020
    23 - 4 - 2020
  • Kuala Lumpur
    10 - 5 - 2020
    14 - 5 - 2020
  • Rome
    10 - 5 - 2020
    14 - 5 - 2020
  • Rome
    10 - 5 - 2020
    14 - 5 - 2020
  • Barcelona
    10 - 5 - 2020
    14 - 5 - 2020
  • Zurich
    10 - 5 - 2020
    14 - 5 - 2020
  • Dubai
    3 - 5 - 2020
    7 - 5 - 2020
  • Paris
    3 - 5 - 2020
    7 - 5 - 2020
  • Hong Kong
    3 - 5 - 2020
    7 - 5 - 2020
  • London
    17 - 5 - 2020
    21 - 5 - 2020
  • Madrid
    17 - 5 - 2020
    21 - 5 - 2020
  • Munich
    17 - 5 - 2020
    21 - 5 - 2020
  • Berlin
    17 - 5 - 2020
    21 - 5 - 2020
  • New York
    17 - 5 - 2020
    21 - 5 - 2020
  • Istanbul
    24 - 5 - 2020
    28 - 5 - 2020
  • Bali
    24 - 5 - 2020
    28 - 5 - 2020
  • Singapore
    24 - 5 - 2020
    28 - 5 - 2020
  • Washington
    24 - 5 - 2020
    28 - 5 - 2020
  • Dubai
    24 - 5 - 2020
    28 - 5 - 2020
  • Paris
    24 - 5 - 2020
    28 - 5 - 2020
  • Hong Kong
    24 - 5 - 2020
    28 - 5 - 2020
  • London
    14 - 6 - 2020
    18 - 6 - 2020
  • Madrid
    14 - 6 - 2020
    18 - 6 - 2020
  • Munich
    14 - 6 - 2020
    18 - 6 - 2020
  • Berlin
    14 - 6 - 2020
    18 - 6 - 2020
  • New York
    14 - 6 - 2020
    18 - 6 - 2020
  • Dubai
    21 - 6 - 2020
    25 - 6 - 2020
  • Paris
    21 - 6 - 2020
    25 - 6 - 2020
  • Hong Kong
    21 - 6 - 2020
    25 - 6 - 2020
  • Istanbul
    28 - 6 - 2020
    2 - 7 - 2020
  • Bali
    28 - 6 - 2020
    2 - 7 - 2020
  • Singapore
    28 - 6 - 2020
    2 - 7 - 2020
  • Washington
    28 - 6 - 2020
    2 - 7 - 2020
  • Kuala Lumpur
    7 - 6 - 2020
    11 - 6 - 2020
  • Rome
    7 - 6 - 2020
    11 - 6 - 2020
  • Rome
    7 - 6 - 2020
    11 - 6 - 2020
  • Barcelona
    7 - 6 - 2020
    11 - 6 - 2020
  • Zurich
    7 - 6 - 2020
    11 - 6 - 2020
  • Kuala Lumpur
    5 - 7 - 2020
    9 - 7 - 2020
  • Rome
    5 - 7 - 2020
    9 - 7 - 2020
  • Rome
    5 - 7 - 2020
    9 - 7 - 2020
  • Barcelona
    5 - 7 - 2020
    9 - 7 - 2020
  • Zurich
    5 - 7 - 2020
    9 - 7 - 2020
  • Dubai
    12 - 7 - 2020
    16 - 7 - 2020
  • Paris
    12 - 7 - 2020
    16 - 7 - 2020
  • Hong Kong
    12 - 7 - 2020
    16 - 7 - 2020
  • Dubai
    19 - 7 - 2020
    23 - 7 - 2020
  • Paris
    19 - 7 - 2020
    23 - 7 - 2020
  • Hong Kong
    19 - 7 - 2020
    23 - 7 - 2020
  • Istanbul
    26 - 7 - 2020
    30 - 7 - 2020
  • Bali
    26 - 7 - 2020
    30 - 7 - 2020
  • Singapore
    26 - 7 - 2020
    30 - 7 - 2020
  • Washington
    26 - 7 - 2020
    30 - 7 - 2020
  • Dubai
    26 - 7 - 2020
    30 - 7 - 2020
  • Paris
    26 - 7 - 2020
    30 - 7 - 2020
  • Hong Kong
    26 - 7 - 2020
    30 - 7 - 2020
  • London
    2 - 8 - 2020
    6 - 8 - 2020
  • Madrid
    2 - 8 - 2020
    6 - 8 - 2020
  • Munich
    2 - 8 - 2020
    6 - 8 - 2020
  • Berlin
    2 - 8 - 2020
    6 - 8 - 2020
  • New York
    2 - 8 - 2020
    6 - 8 - 2020
  • Dubai
    9 - 8 - 2020
    13 - 8 - 2020
  • Paris
    9 - 8 - 2020
    13 - 8 - 2020
  • Hong Kong
    9 - 8 - 2020
    13 - 8 - 2020
  • Istanbul
    16 - 8 - 2020
    20 - 8 - 2020
  • Bali
    16 - 8 - 2020
    20 - 8 - 2020
  • Singapore
    16 - 8 - 2020
    20 - 8 - 2020
  • Washington
    16 - 8 - 2020
    20 - 8 - 2020
  • Kuala Lumpur
    23 - 8 - 2020
    27 - 8 - 2020
  • Rome
    23 - 8 - 2020
    27 - 8 - 2020
  • Rome
    23 - 8 - 2020
    27 - 8 - 2020
  • Barcelona
    23 - 8 - 2020
    27 - 8 - 2020
  • Zurich
    23 - 8 - 2020
    27 - 8 - 2020
  • Kuala Lumpur
    27 - 9 - 2020
    1 - 10 - 2020
  • Rome
    27 - 9 - 2020
    1 - 10 - 2020
  • Rome
    27 - 9 - 2020
    1 - 10 - 2020
  • Barcelona
    27 - 9 - 2020
    1 - 10 - 2020
  • Zurich
    27 - 9 - 2020
    1 - 10 - 2020
  • Dubai
    6 - 9 - 2020
    10 - 9 - 2020
  • Paris
    6 - 9 - 2020
    10 - 9 - 2020
  • Hong Kong
    6 - 9 - 2020
    10 - 9 - 2020
  • London
    13 - 9 - 2020
    17 - 9 - 2020
  • Madrid
    13 - 9 - 2020
    17 - 9 - 2020
  • Munich
    13 - 9 - 2020
    17 - 9 - 2020
  • Berlin
    13 - 9 - 2020
    17 - 9 - 2020
  • New York
    13 - 9 - 2020
    17 - 9 - 2020
  • Istanbul
    20 - 9 - 2020
    24 - 9 - 2020
  • Bali
    20 - 9 - 2020
    24 - 9 - 2020
  • Singapore
    20 - 9 - 2020
    24 - 9 - 2020
  • Washington
    20 - 9 - 2020
    24 - 9 - 2020
  • Dubai
    20 - 9 - 2020
    24 - 9 - 2020
  • Paris
    20 - 9 - 2020
    24 - 9 - 2020
  • Hong Kong
    20 - 9 - 2020
    24 - 9 - 2020
  • Istanbul
    4 - 10 - 2020
    8 - 10 - 2020
  • Bali
    4 - 10 - 2020
    8 - 10 - 2020
  • Singapore
    4 - 10 - 2020
    8 - 10 - 2020
  • Washington
    4 - 10 - 2020
    8 - 10 - 2020

Intorduction

This hands-on, practical course will demonstrate how you can develop spreadsheet models to create a forecast, which can then be utilised to generate business plans and operating budgets with the use Excel® as it is used in practice. The applications will be focused on three crucial aspects of business and financial management - strategic planning, intelligent forecasting and realistic budgeting. Delegates will learn how accessible the power of Excel® is to provide realistic forecasts and prepare flexible budgets. The impact on efficiency in planning and control and therefore return on investment for companies and/or divisions will be startling.

This course will feature:

  • Mastery of the power of Excel®
  • What functions to use from the Excel toolkit
  • Principles of strategic planning and budgeting
  • Mathematical forecasting models will be demystified
  • Building financial models enabling "what if" analysis

Objectives

  • Navigate through the features and functions of Excel®
  • Distinguish between data and output in spreadsheet architecture
  • Analyze financial statements in order to plan ahead
  • Build effective financial planning models
  • Use forecasting techniques for budget preparation

Content

Day One

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 Two

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 Three

Fantastic Forecasting

  • Forecasting in perspective - the Past vs. the Future
  • 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 Four

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 Five

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 review

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

Courses Search

Recent Posts

Connect with us

IFRS Preparation. (5 Days)Available in London - Dubai - Istanbul - Kuala Lumpur

Join our Civil and Construction Engineering Training Courses , Electrical and Power Engineering Training Courses and Facilities Management Training

Technical Training Courses

Newsletter