Professional Training
4.9 (165 Reviews)

Excel Forecasting and Data Analysis

STL, In London (+21 locations)
Length
1 day
Price
300 GBP excl. VAT
Next course start
3 June, 2024 (+50 start dates)
Course delivery
Classroom, Virtual Classroom
Length
1 day
Price
300 GBP excl. VAT
Next course start
3 June, 2024 (+50 start dates)
Course delivery
Classroom, Virtual Classroom
Leave your details so the provider can get in touch

Excel Forecasting and Data Analysis

STL courses


  • At the end of this course you will understand how you can forecast in Excel using different methods based on seasonal, linear or exponential data. You will be able to calculate forecast errors to update your forecast model to assure more accurate forecasts. You will able to do trend analysis, break-even analysis, calculate correlation coefficient and creating statistical analysis using Excel's analysis toolpak.
    You will also be able to clearly visualise trends and forecasts in Excel charts.

    This course is a part of a wider portfolio of our Excel software training courses.

What to expect

  • Courses never cancelled .
  • Restaurant lunch .
  • Last minute rescheduling .
  • 24 month delegate support forum .
  • And more... .

Upcoming start dates

Choose between 50 start dates

3 June, 2024

  • Classroom
  • London
  • English

1 July, 2024

  • Virtual Classroom
  • Online
  • English

3 July, 2024

  • Classroom
  • London
  • English

31 July, 2024

  • Virtual Classroom
  • Online
  • English

2 August, 2024

  • Classroom
  • London
  • English

30 August, 2024

  • Virtual Classroom
  • Online
  • English

2 September, 2024

  • Classroom
  • London
  • English

30 September, 2024

  • Virtual Classroom
  • Online
  • English

2 October, 2024

  • Classroom
  • London
  • English

30 October, 2024

  • Virtual Classroom
  • Online
  • English

1 November, 2024

  • Classroom
  • London
  • English

29 November, 2024

  • Virtual Classroom
  • Online
  • English

2 December, 2024

  • Classroom
  • London
  • English

2 January, 2025

  • Virtual Classroom
  • Online
  • English

3 January, 2025

  • Classroom
  • London
  • English

31 January, 2025

  • Virtual Classroom
  • Online
  • English

3 February, 2025

  • Classroom
  • London
  • English

3 March, 2025

  • Virtual Classroom
  • Online
  • English

5 March, 2025

  • Classroom
  • London
  • English

2 April, 2025

  • Virtual Classroom
  • Online
  • English

4 April, 2025

  • Classroom
  • London
  • English

2 May, 2025

  • Virtual Classroom
  • Online
  • English

6 May, 2025

  • Classroom
  • London
  • English

2 June, 2025

  • Virtual Classroom
  • Online
  • English

5 June, 2025

  • Classroom
  • London
  • English

2 July, 2025

  • Virtual Classroom
  • Online
  • English

4 July, 2025

  • Classroom
  • London
  • English

Enquire for more information

  • Classroom
  • Aberdeen
  • English

Enquire for more information

  • Classroom
  • Bedford
  • English

Enquire for more information

  • Classroom
  • Belfast
  • English

Enquire for more information

  • Classroom
  • Birmingham
  • English

Enquire for more information

  • Classroom
  • Bristol
  • English

Enquire for more information

  • Classroom
  • Burnley
  • English

Enquire for more information

  • Classroom
  • Cardiff
  • English

Enquire for more information

  • Classroom
  • Edinburgh
  • English

Enquire for more information

  • Classroom
  • Edinburgh
  • English

Enquire for more information

  • Classroom
  • Glasgow
  • English

Enquire for more information

  • Classroom
  • Leeds
  • English

Enquire for more information

  • Classroom
  • Leicester
  • English

Enquire for more information

  • Classroom
  • Liverpool
  • English

Enquire for more information

  • Classroom
  • London
  • English

Enquire for more information

  • Classroom
  • Manchester
  • English

Enquire for more information

  • Classroom
  • Newport
  • English

Enquire for more information

  • Classroom
  • Nottingham
  • English

Enquire for more information

  • Classroom
  • Portsmouth
  • English

Enquire for more information

  • Classroom
  • Sheffield
  • English

Enquire for more information

  • Classroom
  • Southampton
  • English

Enquire for more information

  • Classroom
  • Sunderland
  • English

Enquire for more information

  • Classroom
  • Wolverhampton
  • English

Enquire for more information

  • Virtual Classroom
  • Online
  • English

Suitability - Who should attend?



This Microsoft Excel Forecasting and Data Analysis course is aimed at people who want to expand their knowledge into forecasting and more specialised analytical functionality offered by Microsoft Excel.

Learn more about the Excel training spreadsheet.

Training Course Content



Plan a forecast Model

Which data can be forecasted?
Set up the source data the right way to get an efficient model
Decide which method is the right for your data or should I use more methods?
How can I measure the accuracy of the forecast?
Which measurement method is the best for my data?
How can I track that I am using the right forecasting model over time
Maintenance of the forecast models

Forecasting Methods

Linear Regression
Forecast Function
Trend Function
Slope and Intercept Function
Exponential Regression
Growth Function
Exponential Smoothing
Data Analysis Tool Exponential Smoothing
Naïve Forecast
Moving Average
Data Analysis Tool Moving Average
Seasonal Forecasting

Measuring Forecast Accuracy

Forecast Error/Deviation
Forecast Absolute Error/Deviation
Forecast Percentage Error/Deviation
Forecast absolute percentage error/deviation
Square Error
Standard Error
MAD (Mean Absolute Deviation)
MSQ (Mean Square Error)
MPE (Mean Percentage Error)
MAPE (Mean Absolute Percentage Error)
TSE (Tracking Signal Error)

Using the solver to optimise forecasts

Optimise Exponential Smoothing Forecasts
Optimise Weighted Moving Average Forecasts
Optimise Seasonal Forecasts

Trends and forecasting using charts

Chart Types
Trendlines
Equations
R2
Visualise Forecasts and Forecast accuracy

Comparing Forecasting Methods and Models

Accuracy and visualisation

Manipulate Forecasts using What-If Analysis

Scenarios Manager
Goal Seek
Data Tables

Correlation Coefficient

Correl Function
The Data Analysis Tool Correlation
Display Correlation Coefficient in Scatter Chart

Break-Even Analysis

Break-Even Modelling
Calculate Break-Even
Visualise Break-Even
Use Goal Seek to analyse Break-Even

Data Analysis Tools

Descriptive Statistics
Histogram
Regression
Sampling
Rank and Percentile

Expenses



List price £350, promotional rates available. STL are the only company to offer a dynamic pricing and availability model, updated live on our site, daily on this portal. Closed group training options available (at your offices, UK wide/International or our London Venues). Contact us below.

Request information - obligation free

Contact course provider

Fill out your details to find out more about Excel Forecasting and Data Analysis.

  Contact the provider

  Get more information

  Register your interest

Country *

reCAPTCHA logo This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Customer Outreach Award

customer-outreach-badge-2019

We believe that it should be easy for you to find and compare training courses. 

Our Customer Outreach Award is presented to trusted providers who are excellent at responding to enquiries, making your search quicker, more efficient and easier, too.

Reviews by course attendees

Average rating 4.9

Based on 165 reviews.
Write a review!
5/5
Kieren International Programmes Officer
30 Nov 2023

Most useful topic: Automation; pivot table slicers

5/5
Eve Research Funding Manager
30 Nov 2023

Jens was fantastic - obviously an expert; explained everything clearly and gave us additional time when needed. The course itself is very interesting and useful; I will be recom...

Show more
5/5
Nikki Analyst
02 Oct 2023

Course content met specification; and Jens was Brilliant; very knowledgeable and patient. Would have liked a bit more time reviewing formulas and rationale during exercises. Whi...

Show more
STL
1 Northey Street, 2nd Floor, CA House
E14 8BT London

STL

Helping businesses improve performance with proven learning and development solutions. London-based with a global reach. STL seek to provide an unrivalled value and quality service, enabled by our strong working culture. Our 500+ courses deliver learning solutions across leadership and...

Read more and show all courses with this provider

Ads