Get instant live expert help on how to forecast in excel based on historical data

“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.

Here are some problems that our users have asked and received explanations on

I am trying to forecast sales for a car dealership based off of historical data. I also have to take into account interest rates and predicted interest rates. I am not excel save and every time I use the forecast command I get null values back. I just don't know how to make them work and need some help.
Solved by T. B. in 11 mins
How to forecast sales? How do I use my data and the formulas in excel?
Solved by O. J. in 16 mins
I'm creating an excel sheet to forecast the number of required employees based on matrices that I set up. I would like to add a drop down on the forecast detail tab, that has all the job codes on the other tabs, and when a job code is selected from the drop down, the forecast is calculated based on the sales matrix in its associated tab.
Solved by B. B. in 22 mins
I need help understanding Excel's Forecast formula. I have a year's worth of historical sales data and need it to be projected forward. Please help me understand if the model is linear or logarithmic, etc.
Solved by V. E. in 20 mins
I'm creating an excel sheet to forecast the number of required employees based sales and on matrices that I set up. I added a drop down on the forecast detail tab, that has all the job code names of the other tabs. What I need is when a job code is selected from the drop down, the forecast is calculated based on the sales matrix in its associated tab.
Solved by G. Y. in 26 mins