Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

forecasting

ResolvedVersion 365

Jack has attended:
Excel Intermediate course

Forecasting

More info would be amazing on this

RE: 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

Sun 18 Dec 2022: Automatically marked as resolved.

Excel tip:

Sum Up All the Values in A Column

If you want to quickly calculate the Summed values of all cells in a column in Excel 2003 normally you would use the SUM formula. (eg if you wanted to calculate the values in Column C rows 10 to 25) the formula would be:

=SUM(C10:C25)

However, if you keep adding values to column C you would keep having to modify the above SUM formula which can get quite annoying.

To get around this you can sum all the values in a column using the following formula:

=SUM(COLUMN:COLUMN)

Which, in our example, would be:

=SUM(C:C)

NOTE You cannot place this formula in column C, or else Excel 2003 will show a circular reference error.

The formula must be placed in any other column, EXCEPT the one being calculated.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.