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

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.


Download Practice Workbook

Download this practice workbook to exercise while you are reading this article.


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.

Forecast Call Volume in Excel


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)

Forecast Call Volume in Excel

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

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

Read More: Forecasting in Excel Using FORECAST Function & Auto Fill Handle Tool

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.

Forecast Call Volume in Excel

  • 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.

Forecast Call Volume in Excel

Read More: FORECAST Function in Excel (with other Forecasting Functions)


Things to Remember


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

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

Leave a reply

ExcelDemy
Logo