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.

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-

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

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.

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

Things to Remember

• You can also use the FORECAST function against the FORECAST.ETS function to get the forecasted output.

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

• How to Do Budgeting and Forecasting in Excel (2 Suitable Ways)
• Forecast in Excel Based on Historical Data (4 Suitable Methods)
• How to Forecast Revenue Growth in Excel (5 Handy Methods)
• Forecast Sales Using Regression Analysis in Excel (3 Methods)
• How to Forecast Sales in Excel (5 Easy Ways)
• Forecast Sales Growth Rate in Excel (6 Methods)
• How to Forecast Revenue in Excel (6 Simple Methods)