Spreadsheet Skills for Planning, Forecasting & Budgeting

Course Info

Length: 1 Week

City: Kuala Lumpur

Type: In Classroom

Available Dates

  • Nov-04-2024

    Kuala Lumpur

  • Dec-02-2024

    Kuala Lumpur

  • Dec-30-2024

    Kuala Lumpur

  • Jan-27-2025

    Kuala Lumpur

  • Feb-24-2025

    Kuala Lumpur

  • Mar-24-2025

    Kuala Lumpur

  • Apr-28-2025

    Kuala Lumpur

  • May-26-2025

    Kuala Lumpur

  • June-30-2025

    Kuala Lumpur

  • July-28-2025

    Kuala Lumpur

  • Aug-25-2025

    Kuala Lumpur

  • Sep-29-2025

    Kuala Lumpur

  • Oct-27-2025

    Kuala Lumpur

  • Nov-24-2025

    Kuala Lumpur

  • Dec-29-2025

    Kuala Lumpur

Dates in Other Venues

  • Oct-14-2024

    Singapore

  • Oct-14-2024

    Paris

  • Oct-21-2024

    Barcelona

  • Oct-21-2024

    Dubai

  • Nov-04-2024

    Istanbul

  • Nov-11-2024

    Paris

  • Nov-11-2024

    Singapore

  • Nov-18-2024

    Barcelona

  • Nov-18-2024

    Dubai

  • Dec-02-2024

    Istanbul

  • Dec-09-2024

    Singapore

  • Dec-09-2024

    Paris

  • Dec-16-2024

    Barcelona

  • Dec-16-2024

    Dubai

  • Dec-23-2024

    Istanbul

  • Jan-06-2025

    Singapore

  • Jan-06-2025

    Paris

  • Jan-13-2025

    Amsterdam

  • Jan-13-2025

    London

  • Jan-20-2025

    Barcelona

  • Jan-20-2025

    Dubai

  • Jan-27-2025

    Istanbul

  • Feb-03-2025

    Paris

  • Feb-03-2025

    Singapore

  • Feb-10-2025

    London

  • Feb-10-2025

    Amsterdam

  • Feb-17-2025

    Barcelona

  • Feb-17-2025

    Dubai

  • Feb-24-2025

    Istanbul

  • Mar-03-2025

    Paris

  • Mar-03-2025

    Singapore

  • Mar-10-2025

    London

  • Mar-10-2025

    Amsterdam

  • Mar-17-2025

    Barcelona

  • Mar-17-2025

    Dubai

  • Mar-24-2025

    Istanbul

  • Apr-07-2025

    Singapore

  • Apr-07-2025

    Paris

  • Apr-14-2025

    Amsterdam

  • Apr-14-2025

    London

  • Apr-21-2025

    Dubai

  • Apr-21-2025

    Barcelona

  • Apr-28-2025

    Istanbul

  • May-05-2025

    Paris

  • May-05-2025

    Singapore

  • May-12-2025

    Amsterdam

  • May-12-2025

    London

  • May-19-2025

    Dubai

  • May-19-2025

    Barcelona

  • May-26-2025

    Istanbul

  • June-02-2025

    Paris

  • June-02-2025

    Singapore

  • June-09-2025

    London

  • June-09-2025

    Amsterdam

  • June-16-2025

    Barcelona

  • June-16-2025

    Dubai

  • June-23-2025

    Istanbul

  • June-30-2025

    Singapore

  • June-30-2025

    Paris

  • July-07-2025

    Singapore

  • July-07-2025

    Paris

  • July-14-2025

    Amsterdam

  • July-14-2025

    London

  • July-21-2025

    Dubai

  • July-21-2025

    Barcelona

  • July-28-2025

    Istanbul

  • Aug-04-2025

    Singapore

  • Aug-04-2025

    Paris

  • Aug-11-2025

    Amsterdam

  • Aug-11-2025

    London

  • Aug-18-2025

    Dubai

  • Aug-18-2025

    Barcelona

  • Aug-25-2025

    Istanbul

  • Sep-01-2025

    Singapore

  • Sep-01-2025

    Paris

  • Sep-08-2025

    Amsterdam

  • Sep-08-2025

    London

  • Sep-15-2025

    Barcelona

  • Sep-15-2025

    Dubai

  • Sep-22-2025

    Istanbul

  • Sep-29-2025

    Singapore

  • Sep-29-2025

    Paris

  • Oct-06-2025

    Singapore

  • Oct-06-2025

    Paris

  • Oct-13-2025

    London

  • Oct-13-2025

    Amsterdam

  • Oct-20-2025

    Dubai

  • Oct-20-2025

    Barcelona

  • Oct-27-2025

    Istanbul

  • Nov-03-2025

    Paris

  • Nov-03-2025

    Singapore

  • Nov-10-2025

    London

  • Nov-10-2025

    Amsterdam

  • Nov-17-2025

    Barcelona

  • Nov-17-2025

    Dubai

  • Nov-24-2025

    Istanbul

  • Dec-01-2025

    Paris

  • Dec-01-2025

    Singapore

  • Dec-08-2025

    London

  • Dec-08-2025

    Amsterdam

  • Dec-15-2025

    Dubai

  • Dec-15-2025

    Barcelona

  • Dec-22-2025

    Istanbul

  • Dec-29-2025

    Singapore

  • Dec-29-2025

    Paris

Course Details

Course Outline

5 days course

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

 

Proper Planning:
 
  • Introduction to planning
  • What-if analysis:
    • Scenario analysis techniques
    • Sensitivity analysis using spinners & scroll bars
  • Economic Order Quantity (EOQ)
  • Build out Data tables to see an entire range of options
  • 1-way Data tables
  • 2-way Data tables
  • Maximizing vs. optimizing techniques
  • Utilizing The Goal Seek command to calculate a reverse equation
  • Using Solver to calculate optimal product mix, distribution problems & capital budgeting

 

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

 

Beyond Budgeting:
 
  • What is a budget?
  • How to build a simple budget
  • Build a Flexible Budget Model
  • Build out a complete budget
  • Operating budget elements
  • Financial budget elements
  • Linking them
  • What is the Variance Analysis report & why is it important to improve your budget
  • Calculating variance analysis to see what must be changed

 

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

Course Video