6 Places Remaining


Public sector organisations are having to make more effective business decisions and deliver services during a very challenging time. It is therefore essential that professionals are able to understand and utilise effective forecasting and trend analysis techniques, in order to handle these increased pressures.

This virtual Understanding Forecasting and Trends course gives those with a limited understanding of analysing forecasts and trends, the confidence to make more effective decisions, based on data reports.

By attending this Understanding Forecasting and Trends training course: you will gain a very practical overview of common forecasting techniques; the knowledge to utilise basic measures and correlation techniques when predicting trends, and the confidence to apply the right forecasting technique for your organisation.

Through a series of highly practical workshops and use of personal laptops, you will gain the confidence and knowledge to forecast and analyse trends. Leave the day with the ability to make greater sense of your data.

Unlocking the Power of Virtual

Our virtual courses have been designed with you in mind. From group exercises in breakout rooms to live chat, whiteboards and interactive polls, we use a range of tools and techniques to ensure that you can connect with your trainer; network and share best practice with your peers and leave the day with the skills you need.

Our courses provide you with an interactive and engaging learning environment that can be accessed from any location, helping you to continue to connect, learn and grow. Click here to discover more!

Please note this course will be using Zoom to deliver the day.

trainer photo
Branko Pecar
Statistics Consultant

Branko spent most of his career working for Emerson, a global and one of the largest process control equipment manufacturing corporations. His last position was VP Educational Services. In the past, he also lectured at University of Gloucestershire in several subjects, including quantitative methods and applications of Excel.

He published a series of books in statistics with a variety of publishers, such as McGraw Hill, Oxford University Press and Amazon. Almost all of these books are based around applying a variety of sophisticated methods using the simplest Excel syntax. He has been using Excel for over thirty ...

Read more

Learning Outcomes

  • Understand how you can forecast trends
  • Learn how forecasting and trends can improve the performance of your organisation
  • Confidently interpret data in the most meaningful way
  • Learn how to effectively forecast to help make more effective business decisions
  • Examine trends that may impact your organisation
All the Understanding ModernGov courses are Continuing Professional Development (CPD) certified, with signed certificates available upon request for event.

Enquire About In-House Training

To speak to someone about a bespoke training programme, please contact us:
0800 542 9414


Collapse all
09:30 - 09:45


09:45 - 10:00

Trainer's Welcome & Clarification of Learning Objectives

  • Overview of common forecasting techniques
  • Understand key terms such as: time series trends, averages and linear patterns
10:45 - 11:00


11:00 - 12:00

Workshop 2: How to choose the Right Forecasting Technique

  • Determine the purpose and desired outcome of the analysis – what do you want to discover: estimation, validation or prediction?
  • Understand different forecasting models: Linear Trends
  • Identify common patterns in your data, averages and begin interpreting data charts
12:00 - 13:00

Workshop 3: Correlation and Regression

  • Understand the difference between correlation and causation
  • Think about different variables, and their interaction
  • Learn to calculate and use Pearson rank and product moment calculations to show ‘fit’ with your models
  • Understand how to measure and graph two different variables
  • Learn how to conduct regression analysis
  • Interpret regression models to make predictions
13:00 - 13:45


13:45 - 14:00

Reflection Session

  • Trainer will review the day’s learning and the next stages of the course
  • Delegates will have time to ask questions and share views with one another
14:00 - 14:45

Workshop 4: Simple Trending

  • Use Excel to generate trends
  • Extrapolate trends
  • Measure the quality of your trend forecasts
14:45 - 15:00


15:00 - 16:00

Handling Seasonal data

  • Understand seasonality
  • Decomposition of time series into constituent parts
  • Introduction to exponential smoothing
  • Produce seasonal forecasts
16:00 - 16:15

Round Up and Key Takeaways


Central Government & Agencies - Virtual

Delegate Price
£345 + VAT

Local Government, Housing, Education & Health - Virtual

Delegate Price
£345 + VAT

Charity - Virtual

Delegate Price
£345 + VAT

Private Sector - Virtual

Delegate Price
£445 + VAT