Forecasting

Hi Jack,

Thank you for the forum question.

To create a accurate forecasting model you will need to understand which variables affect your numbers.

You will need to fully in depth understand all patterns, seasonality, and correlation in your data set.

Based on this you will need to find the forecast model, which return the most accurate forecast.

We have many tools in Excel, which can help us with all this.

We have forecast functions, which can handle linear regression, non linear regression, correlation, growth and much much more.

It is difficult for me to point you in the right direction. I do not know your data and patterns.

We have a one day forecasting and data analysis course, which will give you the knowledge.


Kind regards

Jens Bonde
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector