info@commonwealthtca.com
Language  
English
French
Spanish
German
Italian
Russina
Arabic
Turkish
Home
Courses
Cities
Associations
Services
About Us
Contact Us
Course Category
→ Accounting and Finance
→ Administration and Secretarial
→ Auditing and Governance, Risk and Compliance
→ Banking, Insurance and Financial Services
→ Business Continuity and Crisis Management
→ Communication and Writing Skills
→ Construction Management
→ Contracts Management
→ Customer Service
→ Data Management and Business Intelligence
→ Digital Innovation and Transformation
→ Energy and Water Management
→ Financial Technology (FinTech)
→ Health, Safety and Environment
→ Human Resources and Training
→ Interpersonal Skills and Self Development
→ IT Management
→ Leadership and Management
→ Legal
→ Maintenance and Engineering
→ Marketing and Sales
→ Monetary Economics
→ Monitoring and Evaluation
→ Oil and Gas
→ Planning and Strategy Management
→ Port and Shipping Management
→ Procurement and Supply Chain Management
→ Project Management
→ Public Relations
→ Quality and Productivity
→ Security Management
→ Tourism Management
→ Transport and Logistics
More Links
→ Public Training Courses
→ Certified Training Courses

Spreadsheet Skills for Planning, Forecasting & Budgeting

Why Attend

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.

Overview

Course Outline

Schedule & Fees

Course Methodology

Instructor-led training that uses interactive learning methods, including class discussion, small group activities, and role-playing

Course Objectives

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)

Target Audience

Target Competencies

n/a

Day 1

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 keyboard shortcuts

  • Case study: create, build & protect a reusable template

Day 2

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 3

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 4

Beyond Budgeting

  • What is the 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 5

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 a capital structure (Case study Example)

  • Bond buybacks (Case study Example)

$2875

Victoria

Country: Seychelles

Duration: One week

Date: 22–26 Sep 2025

Register

$3275

Beijing

Country: China

Duration: One week

Date: 09–13 Feb 2026

Register