This course has passed.


Do you want to improve your organisation’s performance, service delivery and make better business decisions? The ability to analyse and interpret statistical information is what you need.

Our 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.

Learn how to confidently identify and predict trends, meaningfully interpret data and identify the right forecasting technique for your organisation.

Take an active part throughout the day, using Excel spreadsheets, practical examples, interactive learning tasks and theory.

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 we will use Zoom to virtually deliver this course

trainer photo
Robert Grant
Trainer, Coach and Writer on Statistics

Robert is a trainer, coach and writer on statistics and working in data science, especially data visualisation and Bayesian models.

He taught statistics and research methods to postgraduate clinical research students at St George’s Medical School and Kingston University (2010-2017), and contributed to many health services and biomedical research projects in this time. His freelance clients include Harvard Medical School, The Economist, and the Cabinet Office.

He is a fellow of the Royal Statistical Society and served on their statistical computing committee from 2012-16. He worked on clinical audits, analysing hospital quality and safety ...

Read more

Learning Outcomes

  • Examine trends that may impact your organisation
  • Confidently interpret trend data in the most meaningful way
  • Understand how you can calculate trends and make forecasts
  • Learn how to effectively forecast to help make more effective business decisions
  • Learn how forecasting and trends can improve the performance of 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
[email protected]


Collapse all
09:30 - 09:45


09:45 - 10:00

Trainer's Welcome & Clarification of Learning Objectives

10:00 - 10:45

Workshop 1: Understanding the Language of Forecasting and Trends

  • Overview of common forecasting techniques
  • Understand key terms such as: time series, moving averages and seasonal effects
  • Examine a public sector data set in Excel and generate moving averages and charts
10:45 - 11:00


11:00 - 12:00

Workshop 2: How to choose the Right Forecasting Technique

  • Use Excel to identify common patterns in your data
  • Interpret charts in published trend analysis and forecasts
  • Practise using Excel to prepare a data set for trend analysis and forecasting
  • Understand different forecasting models: Linear trends and autocorrelation
  • Determine the purpose and desired outcome of the analysis – what do you want to discover: estimation, validation or prediction?
12:00 - 13:00

Workshop 3: Correlation and Regression

  • Learn ways of assessing how well your models fit the data
  • Generate predictions from linear and autoregression models
  • Learn how to conduct autoregression analysis on time series data
  • Think about predictor variables and their interactions in a public sector data set
  • Understand the difference between correlation and causation, and use the Pearson coefficient
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

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


15:00 - 16:00

Handling Seasonal data

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

Round Up and Key Takeaways