Spreadsheet Skills for Planning, Forecasting & Budgeting

Download full courses list Excel Download full courses list PDF

Spreadsheet Skills for Planning, Forecasting & Budgeting

Category

Finance, Accounting & Budgeting Training Courses

Code

FA-165

City

Auckland (New Zealand)

Hotel

Hotel Meeting Room

Duration

One week 25Hour
2024-04-22 2024-04-26

Fees

5450 €
Durations for This Course
Register for this course
Content Training Methodology
The Course

Planning, Forecasting & Budgeting are 3 of the most important functions in business. Performed properly they can lead to exceptional success. Yet many people do not use the tools available to them to their best advantage. In this course we will leverage the power of Excel® to demonstrate how to improve your forecasting, planning and budgeting. By developing better spreadsheets & models, planning is more accurate, forecasting is more precise & budgeting is more attainable. And the time to develop these is dramatically reduced.

Forecasts, plans and budgets may be improved through extensive what-if analysis to find key factors for management to monitor. Furthermore, these tools can be easily transferred into business plans which provide the guide to the overall performance of the firm.

Techniques you will master include:
  • goal seek
  • scenario manager
  • sensitivity analysis
  • solver
  • decision models

The course's usefulness is enhanced by the fact that it is designed to apply to both Excel® ’03 & ‘07 - to enable you to use it more effectively.

The course demonstrates every technique discussed using Excel® templates that will be provided all delegates so bring your laptop to optimize the experience.

The Goals
On completion of this course delegates will be able to:
  • Fully understand the various Excel® tools available to perform planning, forecasting & budgeting
  • Perform sophisticated “what-if” scenarios to improve decision making
  • Know what Excel® techniques to use in a given situation
  • Properly use some of the most advanced spreadsheet techniques
  • Know when to take a chance & when not to
  • Learn to use & expand a range of Excel® models (provided)
The Process

The training comprises teaching sessions covering each topic area with the theory blended with practical application. Additionally, real world examples & case studies will be used so that the Delegates will be able to apply these techniques immediately. Delegates will use the provided Excel® templates to apply their new knowledge case studies to reinforce the concepts.

The Benefits
The organization will benefit by:
  • Having Experts in-house to develop advanced decision support models
  • Increased productivity of personnel involved in planning, forecasting & budgeting
  • Improved performance of plans developed into budgets
  • Better ways to plan & measure results of forecasts
  • Realizing better options when facing forecasting choices
  • Better integration between functional areas leading to better decisions
The Results
The delegate will benefit by:
  • Developing an improved understanding of how well prepared Excel® models benefit the corporate in today’s challenging world.
  • Really understanding the risks & rewards of various planning decisions
  • Being able to calculate the impact of alternative inputs on critical outputs
  • Understanding to cost/benefit of every decision
  • Enhancing their knowledge with the use of the models in the case studies
  • Significantly increasing their Excel® analysis skills
The Programme Content
Day One
Introduction to Spreadsheets using Excel®
  • Worksheet fundamentals
  • Using the F4 key for Relative & Absolute cell references
  • Expose ALL formulas in a worksheet using the built in function for faster review
  • Naming cells & ranges for quicker, more accurate work
  • Freeze panes, columns & rows for easier viewing while scrolling
  • Protecting cells & ranges to stabilize models
  • Function wizard benefits
  • Linking cells from various worksheets to reduce errors
  • Secret key board shortcuts
  • Case study: create, build & protect a reusable template
Day Two
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
  • Case study & template for using Solver to plan the Optimal product mix
Day Three
Fantastic Forecasting
  • What is forecasting?
  • Qualitative techniques & their uses
  • Quantitative techniques & their uses
    • Smoothing techniques
    • Regression analysis
    • Time series analysis
  • Forecasting growth rates for verification
  • Internal (IGR)
  • Sustainable (SGR)
  • MIN and MAX functions
  • MEDIAN, MODE & AVERAGE functions
  • GEOMEAN to calculate Average Growth Rate (AGR)
  • When to use RANK, QUARTILE & PERCENTILE
  • Case study & template: Use the GEOMEAN function to calculate your AGR
Day Four
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
  • Case study & template: Build a complete budget
Day Five
Putting it together – building the comprehensive model
  • Build your planning model
  • Build your forecasting model
  • Build your budgeting model
  • Link these together
  • Leverage optimization through capital structure (Case study Example)
  • Bond buybacks (Case study Example)
Copy course link
Send me course brochure
Download course brochure
Re-call me
Course inquire
Tailored Courses
Send to Friend
Group Offer
print
Register for this course

Another durations and cities for the same course

Courses Filter

City

DUBAI (UAE)
Kuala Lumpur (Malaysia)
Amman (Jordan)
Jakarta (Indonesia)
Sharm ElShaikh (Egypt)
Amsterdam (Netherlands)
Casablanca (Morocco)
Paris (France)
Istanbul (Turkey)
Singapore (Singapore)
Manama (Bahrain)
Washington (US)
Beirut (Lebanon)
Barcelona (Spain)
Kuwait (Kuwait)
Budapest (Hungary)
Athens (Greece)
Copenhagen (Denmark)
Berlin (Germany)
Brussels (Belgium)
Bucharest (Romania)
Zurich (Switzerland)
Hamburg (Germany)
Moscow (Russia)
Marrakesh (Morocco)
Beijing (China)
Doha (Qatar)
Bangkok (Thailand)
Muscat (Oman)
Toronto (Canada)
Cyprus (Larnaka)
Cairo (Egypt)
Madrid (Spain)
London (UK)
Jeddah (Saudi Arabia)
Stockholm (Sweden)
Geneva (Switzerland)
Vienna (Austria)
Munich (Germany)
Prague (Czech Republic)
Rome (Italy)
Hong Kong
Dublin (Ireland)
Dammam (Saudi Arabia)
Auckland (New Zealand)
Abha (Saudi Arabia)
Trabzon (Turkey)
Abu Dhabi (UAE)
Florence (Italy)
Tunisia
Marbella (Spain)
Riyadh (Saudi Arabia)
New York (US)
Tbilisi (Georgia)
Kiev
Frankfurt (Germany)
Malaga (Spain)
Yerevan (Armenia)
Baku (Azerbaijan)
Zagreb (Croatia)
ONLINE
Hurghada (Egypt)
Results --->  Of Courses
Download result list
33

Spreadsheet Skills for Planning, Forecasting & Budgeting

2024-04-08 2024-04-12
Offline 5450 €
Dublin-(Ireland)

Spreadsheet Skills for Planning, Forecasting & Budgeting

2024-04-21 2024-04-25
Offline 3450 €
Casablanca-(Morocco)

Spreadsheet Skills for Planning, Forecasting & Budgeting

2024-04-22 2024-04-26
Offline 5450 €
Auckland-(New-Zealand)

Spreadsheet Skills for Planning, Forecasting & Budgeting

2024-04-22 2024-04-26
Offline 2950 €
Istanbul-(Turkey)

Spreadsheet Skills for Planning, Forecasting & Budgeting

2024-04-29 2024-05-03
Offline 4950 €
Budapest-(Hungary)

Spreadsheet Skills for Planning, Forecasting & Budgeting

2024-04-29 2024-05-03
Offline 4950 €
Yerevan-(Armenia)

Spreadsheet Skills for Planning, Forecasting & Budgeting

2024-04-29 2024-05-03
Offline 5450 €
Cyprus-(Larnaka)

Spreadsheet Skills for Planning, Forecasting & Budgeting

2024-05-06 2024-05-10
Offline 5450 €
Malaga-(Spain)

Spreadsheet Skills for Planning, Forecasting & Budgeting

2024-05-20 2024-05-24
Offline 4450 €
Trabzon-(Turkey)

Spreadsheet Skills for Planning, Forecasting & Budgeting

2024-05-20 2024-05-24
Offline 5450 €
Zurich-(Switzerland)

Spreadsheet Skills for Planning, Forecasting & Budgeting

2024-05-20 2024-05-24
Offline 5450 €
Geneva-(Switzerland)

Spreadsheet Skills for Planning, Forecasting & Budgeting

2024-05-27 2024-05-31
Offline 4950 €
Zagreb-(Croatia)

Spreadsheet Skills for Planning, Forecasting & Budgeting

2024-05-27 2024-05-31
Offline 3950 €
Jakarta-(Indonesia)

Spreadsheet Skills for Planning, Forecasting & Budgeting

2024-06-03 2024-06-07
Offline 4950 €
Baku-(Azerbaijan)

Spreadsheet Skills for Planning, Forecasting & Budgeting

2024-06-17 2024-06-21
Offline 5450 €
Vienna-(Austria)

Spreadsheet Skills for Planning, Forecasting & Budgeting

2024-07-01 2024-07-05
Offline 2950 €
Istanbul-(Turkey)

Spreadsheet Skills for Planning, Forecasting & Budgeting

2024-07-08 2024-07-12
Offline 5450 €
Rome-(Italy)

Spreadsheet Skills for Planning, Forecasting & Budgeting

2024-07-14 2024-07-18
Offline 2550 €
Cairo-(Egypt)

Spreadsheet Skills for Planning, Forecasting & Budgeting

2024-07-14 2024-07-18
Offline 2950 €
Amman-(Jordan)

Spreadsheet Skills for Planning, Forecasting & Budgeting

2024-07-29 2024-08-02
Offline 5450 €
Hamburg-(Germany)

Spreadsheet Skills for Planning, Forecasting & Budgeting

2024-07-29 2024-08-02
Offline 4950 €
Budapest-(Hungary)

Spreadsheet Skills for Planning, Forecasting & Budgeting

2024-08-04 2024-08-08
Offline 2550 €
Beirut-(Lebanon)

Spreadsheet Skills for Planning, Forecasting & Budgeting

2024-08-04 2024-08-08
Offline 2950 €
Sharm-ElShaikh-(Egypt)

Spreadsheet Skills for Planning, Forecasting & Budgeting

2024-08-05 2024-08-09
Offline 5450 €
Athens-(Greece)

Spreadsheet Skills for Planning, Forecasting & Budgeting

2024-08-11 2024-08-15
Offline 3450 €
Muscat-(Oman)

Spreadsheet Skills for Planning, Forecasting & Budgeting

2024-08-12 2024-08-16
Offline 5450 €
Marbella-(Spain)

Spreadsheet Skills for Planning, Forecasting & Budgeting

2024-08-12 2024-08-16
Offline 4950 €
Bucharest-(Romania)

Spreadsheet Skills for Planning, Forecasting & Budgeting

2024-08-26 2024-08-30
Offline 5450 €
Prague-(Czech-Republic)

Spreadsheet Skills for Planning, Forecasting & Budgeting

2024-09-09 2024-09-13
Offline 5450 €
Copenhagen-(Denmark)

Spreadsheet Skills for Planning, Forecasting & Budgeting

2024-09-29 2024-10-03
Offline 3450 €
Marrakesh-(Morocco)

Spreadsheet Skills for Planning, Forecasting & Budgeting

2024-10-07 2024-10-11
Offline 5950 €
Singapore-(Singapore)

Spreadsheet Skills for Planning, Forecasting & Budgeting

2024-10-27 2024-10-31
Offline 2950 €
Manama-(Bahrain)

Spreadsheet Skills for Planning, Forecasting & Budgeting

2024-10-28 2024-11-01
Offline 5450 €
Munich-(Germany)

Other courses from the same category

Registration Form

Inquiry Form

A tailored course application form

Brochure Request Form

Send to a Friend

Sample contact me back

Group Offer Form

Scandinavian Academy for Training and Development AB

Training services provider in the Kingdom of Sweden
Registration number : 7431 - 559173

Copyright © 2023 - All Rights Reserved to the Scandinavian Academy for Training and Development AB