# How to Forecast Call Volume in Excel (with Quick Steps)

Get FREE Advanced Excel Exercises with Solutions!

If you are working as a manager in a call center company then it is a must to forecast call volume. Sometimes it becomes difficult to calculate due to various variables. I have found a simple way of forecasting call volume with a dataset containing all the data. In this article, I am going to share with you how to forecast call volume in excel.

## 2 Quick Steps to Forecast Call Volume in Excel

In the following article, I have shared 2 quick and easy steps to forecast call volume in excel.

Suppose we have a dataset of yearly call volume divided into different months. Now first we will calculate the Total calls in a year and then forecast call volume for the upcoming years.

### Step 1: Use SUM Function to Get Total Call Volume of Each Year

• Choose a cell to write the formula. Here I have selected cell (C15).
• Apply the following formula-
`=SUM(C5:N5)`

• Press Enter.
• Drag the “fill handle” down to fill all the cells.

• Thus we got total call years in a new column.

### Step 2: Forecast Total Call Volume in Excel

• Now let’s calculate the total call volume for the upcoming years.
• To do so select a cell. Here I have selected a cell (F15).
• Put the formula down-
`=FORECAST.ETS(E15:E20,C15:C22,B15:B22)`

Where,

• The FORECAST.ETS function returns a predicted value according to the existing value given in the string.

• Hit the Enter
• Pull the “fill handle” down to fill all the cells with the output.

• Finally, we have our forecasted call volume for the upcoming few years in an excel sheet.

## Conclusion

In this article, I have tried to cover all the simple methods to forecast call volume in excel. Take a tour of the practice workbook and download the file to practice by yourself. Hope you find it useful. Please inform us in the comment section about your experience. We, the Exceldemy team, are always responsive to your queries. Stay tuned and keep learning.

## Related Articles

Wasim Akram

Hi! my name is Wasim Akram. I am a graduate in mechanical engineering from Ahsanullah University of Science & Technology. I am passionate about learning new things and writing articles. I write article about Microsoft Excel and it's my favourite thing to do.

We will be happy to hear your thoughts

Advanced Excel Exercises with Solutions PDF