🏫 Learn the fundamentals of Excel in just 2 hours: kevinstratvert.thinkific.com ⏭ Watch next - playlist with all my free tutorial videos on how to use Excel: ruclips.net/p/PLlKpQrBME6xLYoubjOqowzcCCd0ivQVLY
Kevin, do you have any video about Multiple Linear Regression, in this video you mentioned only regarding single dataset but what about if our data is multivariate which need several trendline. Thank you
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!
"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.
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.
Failed my Excel test 3 times because of one question-Forecasting. Watched about 5 videos for clearance. Kevin you just made it so clear. You are the man...🔥💯💯💯 Thank you.
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!!!
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.
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.
Wow!! x3 ---- I learned so much in just 11 minutes...and I didn't need to watch the video over again because your explanation was just ...concise, precise!! You're such an efficient and effective Teacher! Thank you so much, Mr. Stravert!
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!
This is absolutely wonderful!! I can´t believe how quickly I got my forecasting done thanks to your video! Thank you for sharing. Following for more content :)
Kevin, Could you do a demonstration for sales forecasting? 5 customers, forecasting Sales for next year by quarter. Using 3 years of historical sales by quarter as the basis for your model? Using the forecast function vs. graph? I will use your graph to show sales by industry trending but for budget planning sales forecast by customer is needed to calculate the totals for each industry. Thanks for considering this idea.
This is the best explanation on forecasting. One problem however, is that on Mac, the forecasting function doesn't show. Any workaround? A video would be fantastic!!
I just found your channel. You solved issue which I was sondering about instantly. +1 sub from me! Keep up good work! I would be so gratefull to see more data anlysis methods in MS Excel ;)
Hi Kevin. It was very detailed and informative. Would really appreciate if you made a video on descriptive and inferential statistics with an example the same way as this video.
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?
Great job sir. Thank you; one question, I have daily data inputs for the past month, but using the "Forecast Sheet" It won't let me go out past 1 week? Any help is appreciated! Ryan
Awesome video! Quick question, hopefully you or some of the responders can assist? is there a way that forecasting can be used in a Dynamic way? Ie if you have a good estimate through historical data of what items you are going to use to service a vehicle fleet going, however, that fleet will have ongoing planned reductions can excel forecast what items will no longer be needed?
Nice & concise video. However I can't see Forecast sheet ribbon in my Excel. May be it's not available for Mac. Is there any workaround / other option for the same ?
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?
Kevin, looks we can use the forecast sheet first and then apply the forecast adding/using the trend line and forward periods. Does that make sense or is that a wrong method?
Can you tell us how to force the trendline to only consider the linear portion of a curved plot, but without removing data points? So that the trendline has a different slope. Thanks.
Thank you Kevin. This was really useful. How to change the exponential Y values into exact values?. For Example Y= 23825x - 5E+07. I want to get the exact values of 5E+07.
I would like to know if you can link 2 workbooks together and when you make changes on either one will it link and keep the formulas on each workbook and same information?
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
Hi kevin, it does not appear as a calendar on my forecast end instead it appears to choose numerical would u please suggest ?..thank you very much ! :)
Hello, I constructed a trendline for my sigmoidal graph in excel (Concentration vs Absorbance curve) however it generates an inaccurate equation which gives answers outside of the range of my data. What do you think can be the cause of this? Anyone that knows this, please reply. I need an answer as soon as possible.
![Monthly Budgeting & Forecasting Model [Template Included]](http://i.ytimg.com/vi/yJcL4et-ClY/mqdefault.jpg)
![Blox Fruits Dragon Rework Update [Full Stream]](http://i.ytimg.com/vi/EqDAp8udhm0/mqdefault.jpg)
🏫 Learn the fundamentals of Excel in just 2 hours: kevinstratvert.thinkific.com
⏭ Watch next - playlist with all my free tutorial videos on how to use Excel: ruclips.net/p/PLlKpQrBME6xLYoubjOqowzcCCd0ivQVLY
Kevin, do you have any video about Multiple Linear Regression, in this video you mentioned only regarding single dataset but what about if our data is multivariate which need several trendline. Thank you
I'm an Inventory analyst and new in this job this really help my reporting ability and performance boost in my job. Great video thank you
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!
"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.
When you use the Exponential trendline you can see the line gets more exponential in nature.
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.
Failed my Excel test 3 times because of one question-Forecasting. Watched about 5 videos for clearance. Kevin you just made it so clear. You are the man...🔥💯💯💯 Thank you.
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!!!
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.
Love this. You’re really good at breaking things down and making them seem simple
You are literally my excel professor thank you so much for having the best tutorials that are so easy to follow along with!!!
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.
Wow!! x3 ---- I learned so much in just 11 minutes...and I didn't need to watch the video over again because your explanation was just ...concise, precise!! You're such an efficient and effective Teacher! Thank you so much, Mr. Stravert!
Excellent! This is super smooth and very helpful.
Definitely a good skill to learn for corporate accounting
but forecast sheet is not available on mac.
🎉 Thank you buddy. It's so nice what you are doing. May God bless you. Amina
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!
This is absolutely wonderful!! I can´t believe how quickly I got my forecasting done thanks to your video! Thank you for sharing. Following for more content :)
Great video, best so far comparing to other YT stars.
I actually appreciate your videos. They are educative. However, please do a video on how to analyze plant populations.
Straight to the point. That is why I like you
Thank you. This has been very helpful material. You explained it very clearly and simply.
My God... that was perfect... thank you so much, Kevin!
Thanks a lot Kevin for this video... wonderful illustration and you made it so simple to understand with good explanation.
Appreciate the note Meenu! Glad it was helpful.
Very nice Kevin. Thank you for sharing, great content!
This is actually so useful for forecasting financial ratios. Thank you so much
Kevin, Could you do a demonstration for sales forecasting? 5 customers, forecasting Sales for next year by quarter. Using 3 years of historical sales by quarter as the basis for your model? Using the forecast function vs. graph? I will use your graph to show sales by industry trending but for budget planning sales forecast by customer is needed to calculate the totals for each industry. Thanks for considering this idea.
Very well presented and easy to follow
Hi Kevin, that was exactly the functionality I needed and you presented it beautifully. Thanks a million!
Kevin, you are the best. And thank you for supporting me on my youtube channel.
Thank you very much for explaining in such a simple way 👍👍
This is the best explanation on forecasting. One problem however, is that on Mac, the forecasting function doesn't show. Any workaround? A video would be fantastic!!
Solved my problem. Thanks Kevin !
Hi Kevin...great job.. and i love all of your videos... so educational.. and really helps me a lot.. thank you Kevin..
Hey Kev thanks again for all these informational videos! U rock!
Thanks for the note TouRon! I like your informational videos as well!
Kevin Stratvert makes my day bro!!! THANK YOU! Im glad you like it!! 🙏🙏🙏☺️☺️☺️☺️
very nice. I need to learn with seasonal data. Plz make a lecture on that
Thank you for the tutorial. I loved the trendline and the forecast, both.
TQ Kevin for your beneficial sharing.. love its.
You are a great teacher!
Wonderful. Absolutely solved my problem. Thanks for making your videos.
I just found your channel. You solved issue which I was sondering about instantly. +1 sub from me! Keep up good work! I would be so gratefull to see more data anlysis methods in MS Excel ;)
Thanks a lot 🙏🏻🙏🏻
Amazing Video, Thanks for sharing!
Hi Kevin. It was very detailed and informative. Would really appreciate if you made a video on descriptive and inferential statistics with an example the same way as this video.
Thank you Kevin
Excellent, you explain so well! Thank you!
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?
Thanks, this was really useful. Just what I was looking for.
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?
Great job sir. Thank you; one question, I have daily data inputs for the past month, but using the "Forecast Sheet" It won't let me go out past 1 week?
Any help is appreciated!
Ryan
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.
Awesome video! Quick question, hopefully you or some of the responders can assist? is there a way that forecasting can be used in a Dynamic way? Ie if you have a good estimate through historical data of what items you are going to use to service a vehicle fleet going, however, that fleet will have ongoing planned reductions can excel forecast what items will no longer be needed?
Thanks Kevin
"Work in a workplace." lol. Great video, thank you for the demonstration!
Nice & concise video. However I can't see Forecast sheet ribbon in my Excel. May be it's not available for Mac. Is there any workaround / other option for the same ?
Goof learning video sit. Thank u
Thanks, this was really useful.
This was great. Thanks for sharing.
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?
Kevin, looks we can use the forecast sheet first and then apply the forecast adding/using the trend line and forward periods. Does that make sense or is that a wrong method?
Can you tell us how to force the trendline to only consider the linear portion of a curved plot, but without removing data points? So that the trendline has a different slope. Thanks.
How do you get to the "format trendline option" in iMAC?
What if you have forecast by a product? Can this forecast sheet help with that as well?
thank you!!!
How do I extract the forecasted values to my spreadsheet
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?
Thank you Kevin. This was really useful. How to change the exponential Y values into exact values?. For Example Y= 23825x - 5E+07. I want to get the exact values of 5E+07.
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?
So, we are now in 2021. Was the forecast correct, Kevin?
Hey Kevin, how accurate did these forecasts come to be?
This was great!
Nice video. I want to analyse recovery percentage of a court. I have recovery data for 10 years. How do I show the trend in percentage terms?
I would like to know if you can link 2 workbooks together and when you make changes on either one will it link and keep the formulas on each workbook and same information?
Great Video as always, Prof. Kevin. Can you please get us a video on spend analytics, Inventory Service Level, and Fill rate in excel? Thank you.
How do you do this forecast graph with a Mac? I have Excel 2016 and I do not have the Forecast Sheets option.
How would you that forecast for many SKU simultaneously
Than you ❤
Hi kevin can we use 3 variables in forecast? Like YoY Plan vs Actual with Projections?
It seems there is a limit on how far out forecast will go. Is that correct?
Great video! Question, how did you get the dates to consolidate from day to month?
please can you share a video on vlookup. thanks.. by the way, ur tutorials are awesome..!!!
How about using the
Excel 2013?
Thanks
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
How can I make my axis remain at zero and not go negative?
Hi kevin, it does not appear as a calendar on my forecast end instead it appears to choose numerical would u please suggest ?..thank you very much ! :)
Too much learning
Please i want to backcast data, how do i do that?
Hi, may I know which year or type of excel that you are using, as I can’t find a “+” sigh when clicking the graph to make a trending line
What is actual results of view that u have predicated?
how do i activate the forecast tab on excel 2013
Hello, I constructed a trendline for my sigmoidal graph in excel (Concentration vs Absorbance curve) however it generates an inaccurate equation which gives answers outside of the range of my data. What do you think can be the cause of this? Anyone that knows this, please reply. I need an answer as soon as possible.
can you add a vertical line to show when you might reach a certain goal within the forecast? like when would you hit the 150000 mark as an example
you could just put the desired mark as a y value in the equation and solve it showing x=...but I think you already solved it by now :-)
How to plot one forecast line graph when I have multiple columns?
Do I need to do the forecast column by column?
RFM ANanlysis using excel please
thanks alot
3rdly, there is forecast function as well
How'd it come out?
Nice
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?