forecasting

TrustPilot

starstarstarstarstar Excellent

  • Home
  • Courses
  • Promotions
  • Schedule
  • Formats
  • Our Clients

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Forecasting

Forecasting

resolvedResolved · High Priority · Version 2010

Forecasting

How to identify which tool is the best for data analysis and forecasting

RE: Forecasting

Hi Khushbu,

Thank you for the forum question.

It depend on different aspects. Which kind of data do you have?

Do you work with linear data?
Do you work with seasonal data?
Do you work with exponential data?

You will need to identify which data you are working with and by testing the accuracy of the forecasting tools you will find the right tools to give you the most accurate forecast.

This can change over time but calculate tracking signal to make sure that you always work with an accurate forecasting model.


Kind regards

Jens Bonde
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
Best 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

Mon 16 May 2016: Automatically marked as resolved.


 

Excel tip:

Selecting your working range

In excel if you have an area you want to highlight, press Ctrl + * or Ctrl+Shift+8 (to get the *). This will select your working range.

View all Excel hints and tips


Server loaded in 0.05 secs.