Excel Forecasting and Data Analysis

Course summary
1 day
240 - 250 GBP excl. VAT
Open / Scheduled
Next available date: 21/04/2020 09:30 - London
Course Dates
21/04/2020 09:30  (English)
250 GBP
21/07/2020 09:30  (English)
240 GBP
04/09/2020 09:30  (English)
240 GBP
20/10/2020 09:30  (English)
240 GBP
04/12/2020 09:30  (English)
240 GBP
19/01/2021 09:30  (English)
240 GBP
STL courses

Excel Forecasting and Data Analysis

Courses never cancelled. Restaurant lunch. Last minute rescheduling. 24 month delegate support forum. And more... 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.

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
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
Rank and Percentile


List price £350 per delegate. Promotional rates apply: see event listings for current prices. On-site training also available: Contact us.

Be Inspired! Watch the Video


Election Analysis Excel Dashboard

Best STL

Using an Excel Dashboard to analyse and visually display May 2015 UK General Election Poll data from the web.

Provider: STL

STL - Microsoft Training

STL - Helping businesses deliver productivity and efficiency gains

Learning solutions from leadership and management training programmes to business intelligence and applications training. London based with a global reach....

Read more and show all courses with this provider

Request information - obligation free

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

  Contact the provider

  Get more information

  Register your interest

Customer Outreach Award


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.

Contact information for STL


Greater London
STL, 2nd Floor, Cruising Association House
E14 8BT 1 Northey Street

 Show phone number

Reviews by course attendees

Average rating 4.9

Based on 48 reviews

Klaudia Sulekova; Financial Planning & Analysis Manager
Most useful topic: all
Virginie Boirel; Sr Revenue Manager
Khushbu Behal-aggarwal; Project Co-ordinator
It was a great wrkshop. for better gauging the value; it will be nic to structure the course over 2 days with more classroom exercises and seeing different scenarios data.

Similar Courses

Request information

Find out more about this Excel Forecasting and Data Analysis course - simply fill out your details:

U.K. L&D Report: 2018 - Benchmark Your Workplace Learning Strategy

Are you curious about the L&D strategies of some of the U.K.'s top companies?

Find out what they're up to in findcourses.co.uk's second annual U.K. L&D Report!


Learn more

Find a course for you!

  Read the course
 summary on this page

 Fill in your details and Request information

 Receive all the info you need

Find more courses here