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.


How to Forecast Call Volume in Excel: 2 Quick Steps

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: Time Series Forecasting Methods in Excel


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 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: How to Do Budgeting and Forecasting in Excel


Things to Remember


Download Practice Workbook

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


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 are always responsive to your queries. Stay tuned and keep learning.


Related Articles


<< Go Back to Forecasting in Excel |Excel for Finance | Learn Excel

What is ExcelDemy?

ExcelDemy - Learn Excel & Get Excel Solutions Center provides online Excel training , Excel consultancy services , free Excel tutorials, free support , and free Excel Templates for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Wasim Akram
Wasim Akram

Wasim Akram holds a BSc degree in Industrial and Production Engineering from Ahsanullah University of Science and Technology. Over the past 2 years, he has been actively contributing to the ExcelDemy project, where he has authored more than 150 articles. Now, he is working as an Excel VBA and Content Developer. He likes learning new things about Microsoft Office, especially Excel VBA, Power Query, Data Analysis, and Excel Statistics. He is also very interested in machine learning and... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo