Excel Forecasting and Data Analysis

STL
4.3
24 reviews
  • Very much organized, instructed me a ton, went at a decent pace, limited class measure so simple to make inquiries and get singular direction.
    ← | →
  • I undertook a Forecasting and Analysis course drove by Jens. He was to a great degree proficient and energetic, and extremely cheerful to answer questions. We worked through numerous illustrations and situations to get a far reaching perspective of the theme which I could handle pragmatic way. The offsite lunch was exceptionally decent. I would prescribe STL for Excel tutelage.
    ← | →
  • Truly discovered this class intriguing. Was helped to remember various things that I had overlooked how to do in Excel that will make my life such a great amount of less demanding on specific reports. Jens was truly an amazing instructor and kept the class engaged and collaborated well with the class.
    ← | →

Course

In London

£ 201-500

The best Excel courses

See all

See all

Description

  • Start date

    Different dates available

Rated excellent on Trustpilot!

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

This course is also offered as inhouse. STL may go to your premises or you can visit our venue in London.

Facilities

Location

Start date

London
See map
12 Bloomsbury Square, WC1A 2LP

Start date

Different dates availableEnrolment now open
London
See map
2nd Floor, Cruising Association House 1 Northey Street, E14 8BT

Start date

Different dates availableEnrolment now open

About this course

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.

Completion of our Excel advanced course or equivalent knowledge.

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

Fill in your details to get a reply

We will only publish your name and question

Reviews

4.3
fantastic
  • Very much organized, instructed me a ton, went at a decent pace, limited class measure so simple to make inquiries and get singular direction.
    ← | →
  • I undertook a Forecasting and Analysis course drove by Jens. He was to a great degree proficient and energetic, and extremely cheerful to answer questions. We worked through numerous illustrations and situations to get a far reaching perspective of the theme which I could handle pragmatic way. The offsite lunch was exceptionally decent. I would prescribe STL for Excel tutelage.
    ← | →
  • Truly discovered this class intriguing. Was helped to remember various things that I had overlooked how to do in Excel that will make my life such a great amount of less demanding on specific reports. Jens was truly an amazing instructor and kept the class engaged and collaborated well with the class.
    ← | →
100%
4.3
fantastic

Course rating

Recommended

Centre rating

Customer

4.5
03/10/2016
What I would highlight: Very much organized, instructed me a ton, went at a decent pace, limited class measure so simple to make inquiries and get singular direction.
What could be improved: No negative aspects.
Would you recommend this course?: Yes

Gary Fenn

4.5
05/09/2016
What I would highlight: I undertook a Forecasting and Analysis course drove by Jens. He was to a great degree proficient and energetic, and extremely cheerful to answer questions. We worked through numerous illustrations and situations to get a far reaching perspective of the theme which I could handle pragmatic way. The offsite lunch was exceptionally decent. I would prescribe STL for Excel tutelage.
What could be improved: Nothing.
Would you recommend this course?: Yes

Roxanna

4.0
09/08/2016
What I would highlight: Truly discovered this class intriguing. Was helped to remember various things that I had overlooked how to do in Excel that will make my life such a great amount of less demanding on specific reports. Jens was truly an amazing instructor and kept the class engaged and collaborated well with the class.
What could be improved: Everything was positive.
Would you recommend this course?: Yes

Tovo

5.0
05/08/2016
What I would highlight: The course was simple to comprehend and straightforward and the educator extremely quiet and accommodating. I would prescribe it to companions and partners who are intrigued to grow their insight in Excel.
What could be improved: Nothing bad.
Would you recommend this course?: Yes

Margaret

4.5
28/10/2015
What I would highlight: Just undertook my second Excel course which affirmed my worries from the first. The instructional strategy is not great, as its too simple to create duplicate of what is written into cells by replicating what the coach does, without really understanding what you are doing. This possibly is the consequence of attempting to pack a lot into the day. Having a foreordained outcome all prepared set out that will be made before the day's over, advances the method of simply duplicating formulae to make the endorsed result, instead of encouraging the reasoning and arranging process behind choosing the capacities and show required.
What could be improved: Nothing.
Would you recommend this course?: Yes
See all
*All reviews collected by Emagister & iAgora have been verified

This centre's achievements

2017

All courses are up to date

The average rating is higher than 3.7

More than 50 reviews in the last 12 months

This centre has featured on Emagister for 7 years

Subjects

  • Forecasting
  • MS Excel
  • Excel
  • Microsoft excel training
  • Microsoft Excel
  • Forecast Model
  • Forecasting Methods
  • Linear Regression
  • Forecast Function
  • Trend Function
  • Exponential Regression
  • Data analysis
  • Seasonal Forecasting
  • Measuring Forecast Accuracy
  • Moving Average

Course programme

Plan a forecast ModelWhich data can be forecasted?Set up the source data the right way to get an efficient modelDecide 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 timeMaintenance of the forecast models
Forecasting MethodsLinear RegressionForecast FunctionTrend FunctionSlope & Intercept FunctionExponential RegressionGrowth FunctionExponential SmoothingData Analysis Tool Exponential SmoothingNaïve ForecastMoving AverageData Analysis Tool Moving AverageSeasonal Forecasting
Measuring Forecast AccuracyForecast Error/DeviationForecast Absolute Error/DeviationForecast Percentage Error/DeviationForecast absolute percentage error/deviationSquare ErrorStandard ErrorMAD (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 forecastsOptimise Exponential Smoothing ForecastsOptimise Weighted Moving Average ForecastsOptimise Seasonal Forecasts
Trends and forecasting using chartsChart TypesTrendlinesEquationsR2Visualise Forecasts & Forecast accuracy
Comparing Forecasting Methods and ModelsAccuracy and visualisation
Manipulate Forecasts using What-If AnalysisScenarios ManagerGoal SeekData Tables
Correlation CoefficientCorrel FunctionThe Data Analysis Tool CorrelationDisplay Correlation Coefficient in Scatter Chart
Break-Even AnalysisBreak-Even ModellingCalculate Break-EvenVisualise Break-EvenUse Goal Seek to analyse Break-Even
Data Analysis ToolsDescriptive StatisticsHistogramRegressionSamplingRank & Percentile


Additional information

We include hot restaurant lunch in all training courses. In addition to that, our courses are never cancelled.

See related categories

Excel Forecasting and Data Analysis

£ 201-500

The best Excel courses

See all

See all