Back to all functions

The FORECAST function can predict future sales given previous numbers. Here we have a list of periods, and how much is sold per period.
In order to find the predicted sales numbers for periods 13 through 16, we’ll write Equals, FORECAST, select the period for which we want the sales, select the previous sales, make them an absolute reference, select the periods for those sales, and make them absolute as well.
We are given the predicted sales number for period 13.
If we drag down, we’ll receive the sales numbers for each of the missing periods.
This lesson has shown the FORECAST function, which returns a predicted sales number based on previous sales numbers.

Popular courses

The Excel Functions Guide

Deepen and develop your Excel Functions skills

Learn how to efficiently manage databases, clear text in cells, and retrieve values from other tables. The course also walks...

Excel Essentials

Get a better understanding of the Excel workflow

Learn to feel more comfortable in Excel. This course will help quickly develop your knowledge in Excel. Excel Essentials is...

Contact us for assistance in finding right course

Excel for your profession

The Excel course for Procurement and Logistic professionals

Excel for professionals working within procurement and logisticians

In cooperation with organisations and professionals within the industry, Learnesy have developed an Excel course that is adapted to those...

Looking for something custom made? Contact us and we will make sure to meet your requirements.