Forecasting in Excel Tutorial

Excellent! This is super smooth and very helpful.

Hi, I used Mac version of excel and I don’t see the Forecast function on the ribbon. Is this something I need to install?

Very well presented and easy to follow

I actually appreciate your videos. They are educative. However, please do a video on how to analyze plant populations.

Great video, best so far comparing to other YT stars.

This is a phenomenal explanation of forecasting. So straightforward and simple even though it handles all the tricks of forecasting the trendline, stat. equation, forecasting model. The simplicity of the tutorial is 👌. Excellent job with this video Kevin!!!

Hey Kevin, how accurate did these forecasts come to be?

Than you ❤

RFM ANanlysis using excel please

but forecast sheet is not available on mac.

Why my forecast trend doesn't have date?

Kevin, did it work? Did you actually get the 1.2 million views a year from then?

🎉 Thank you buddy. It's so nice what you are doing. May God bless you. Amina

Nice video, I have data spanning over 32 Cell-Column, and 46,733 Cell-Row. ( That is 32 Columns by 46,733 Rows) Which method can I use to carry out forecast on this data using Microsoft Excel?

How would you that forecast for many SKU simultaneously

Goof learning video sit. Thank u

very nice. I need to learn with seasonal data. Plz make a lecture on that

Thank you. This has been very helpful material. You explained it very clearly and simply.

How do you get to the "format trendline option" in iMAC?

Whenever I'm searching for any video and I don't see your tutorial on it, I feel very sad and this is because I find it very easy understanding your tutorials. Thanks alot for all you do.

3rdly, there is forecast function as well

Your video was really good but it would have helped if you could have shown the statistical info table and explain what each term means.

how do i activate the forecast tab on excel 2013

Great video, but man, an 11 min video with 4 ads.

thank you!!!

Awesome

How do I extract the forecasted values to my spreadsheet

please can you share a video on vlookup. thanks.. by the way, ur tutorials are awesome..!!!

Kevin, your example used daily data....I'm trying to use quarterly data and Excel doesn't like that and won't forecast, how do you work around this?

Hi Kevin, your tutorials has helped me alot. One of my biggest downfalls is understanding Forecasting. I think I got it but I have an issue I want to run by you. We just started a new report in January. It has data for December, January, February but nothing for March, April, May. They held all the data from those months and entered them for June. The problem is how do you forecasting this type of table with such a huge gap?

Hi Kevin, thank you for the video. When I did the Forecast Sheet, it didn't take the dates. It only used numbers. Any suggestions?

Hi Kevin, that was exactly the functionality I needed and you presented it beautifully. Thanks a million!

Hi Kevin, When plotting the prediction intervals on the chart, I noticed the chart doesn’t update when you select the log tic box. Is there a way around this or do you know how? I need the prediction intervals to adjust based on logarithmic scale. Thanks

I am an industrial engineer, I've take forecasting course in University , unfortunately your 11 minutes was more worthy and understandable than that coarse , thank you so much.

Solved my problem. Thanks Kevin !

loved this..i have been using excel for a year now and v=never used forecast inbuilt feature...thanks @kevin you have just explained the most powerful tool for my day to day operations.

I do not succeed to display lower and upper confidence bound in the table, only confidence interval row appears? Any thoughts please?

Hey there Kevin. First off thank you for the videos. The way you explain how to use excel and its overall features has been easy to understand. In short, it has been very helpful and has given me more confidence when using this application for my work. Thanks again, I hope your channel continues to grow. Good luck!

Hi kevin can we use 3 variables in forecast? Like YoY Plan vs Actual with Projections?

"Let's say you work at, say........a workplace.." XD That was so random. Anyway, I've marked this video. Will definitely reference it when I'm learning. Really appreciate the presence and work of channels like this; helping people upskill themselves.

Are you the world best in Excel?

Thank you very much for explaining in such a simple way 👍👍

What if you have forecast by a product? Can this forecast sheet help with that as well?

Too much learning <3

My God... that was perfect... thank you so much, Kevin!

Magnificent - I've had people try and get me to learn R just to do this type of forecasting. In the space of 11 minutes - I'm now a confident forecaster! Just like all your other videos - brilliant and easy to follow!

How about using the
Excel 2013?

You are a great teacher!

This is actually so useful for forecasting financial ratios. Thank you so much