Spreadsheet Skills for Planning, Forecasting & Budgeting

Course CodeCO00063

Available Dates & Locations

This course is available in multiple locations and online. Choose the most suitable date and delivery method.

Doha

Dates

Doha

Venue / Hotel

-

Duration
1 Week
Price
€4,725
Madrid

Dates

Madrid

Venue / Hotel

-

Duration
1 Week
Price
€5,775
Manama

Dates

Manama

Venue / Hotel

Diplomatic Area 317, Manama | | Bahrain

Duration
1 Week
Price
€4,725
London

Dates

London

Venue / Hotel

82 - 83 Eccleston Square, Pimlico, London SW1V 1PS, UK

Duration
1 Week
Price
€5,775
London

Dates

London

Venue / Hotel

82 - 83 Eccleston Square, Pimlico, London SW1V 1PS, UK

Duration
1 Week
Price
€6,300
Istanbul

Dates

Istanbul

Venue / Hotel

DoubleTree by Hilton Istanbul Esentepe

19 Mayıs Mahallesi, 19 Mayis Street No 2 Sisli, 34360 Istanbul/İstanbul

Hotel Website
Duration
1 Week
Price
€6,300
Manama

Dates

Manama

Venue / Hotel

Diplomatic Area 317, Manama | | Bahrain

Duration
1 Week
Price
€4,725
London

Dates

London

Venue / Hotel

82 - 83 Eccleston Square, Pimlico, London SW1V 1PS, UK

Duration
1 Week
Price
€5,775
Venice

Dates

Venice

Venue / Hotel

-

Duration
1 Week
Price
€6,050
Madrid

Dates

Madrid

Venue / Hotel

-

Duration
1 Week
Price
€5,775
Milan

Dates

Milan

Venue / Hotel

-

Duration
1 Week
Price
€5,775
Rome

Dates

Rome

Venue / Hotel

Piazza Sallustio, 18, 00187 Roma RM, Italy

Duration
1 Week
Price
€6,050
Barcelona

Dates

Barcelona

Venue / Hotel

La Rambla, 128, 08002 Barcelona, Spain

Duration
1 Week
Price
€6,300

Course Overview

Planning, forecasting, and budgeting are essential for business success, and Excel® offers powerful tools to enhance these processes. This course teaches participants how to develop accurate models, perform what-if analyses, and optimize plans efficiently using techniques like goal seek, scenario manager, and solver. Designed for Excel® ’03 and ’07, the course includes practical demonstrations and templates for hands-on learning. Bring your laptop and gain skills to improve precision, save time, and drive business performance.

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)

Course Outline

  • 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