Awesome tutorial and tip! Expand with pivot table, formulas, slicers, add a target column and I have an interactive chart for my users and the 90 products I report on monthly. Awesome. Thank you
You put so much effort into teaching us noobs about forecast tool and I got excited about wrapping dates with custom formatting 😜 Another great video btw 😊
All your videos are awesome. Being recently arrived in a position with a lot of reports, they are very useful to me. I observed that a lot of functionalities rely on having real good & usable data. Did you do about it dealing exclusively on the quality of entry data ? I’m sure many of the roadblock I face today come from data rather than issues in using then.
Hi, i have office 365 on Mac and on excel, i dont have the "forecasting sheet" in my data ribbon... can you advice whether this feature is or isnt available on Mac?
Not sure you’d have enough data points for it to work. You also need data at evenly spaced time intervals. I don’t know your data though so it might work.
Thanks for it, very useful video! I wonder if someone can advise, the demonstrated data on the video are only time based, how about if we have data also with regions? i.e. US, UK etc. sales in January, Feb....? It looks excel forecasting function can only based the forecasting in time series without other regional elements. Thanks in advance
Not sure. I'd give it a go and you'll soon find out if you can run the Forecast sheet tool twice for different data sets in the same sheet. Alternatively, you can use the functions it generates to build the forecasts yourself.
I was doing this by hand which can take a while. I was going to try and figure out an upper limit where I transfer funds from one investment to another to build that one up.
Hi Mynda, I have a pivot table where as the first columns has months (Jan, Feb, Mars, etc). The forecast worksheet can not been created. It tells me that the timeline is not evenly spaced. How come? So it looks when dates are grouped YY/MM does does not may work. Any thoughts please?
You can download the file on this page (www.myonlinetraininghub.com/excel-forecast-sheet), and in that file you'll see there's a sheet called 'Forecast Sheet'.
It doesn't appear to do anything when you press it, but once you apply the format and then wrap the text in the cell you'll see it forces a carriage return in the cell.
Strange! According to Microsoft, Excel 2019 has the Forecast sheets: support.microsoft.com/en-us/office/create-a-forecast-in-excel-for-windows-22c500da-6da7-45e5-bfdc-60a7062329fd
It would be more helpful if you use real sales data instead of simple data. In reality, we have to apply forecasting for sales data from multiple data from previous years and data are not that simple with equal distribution.
The data is real Hawaii visitor numbers. Forecasting can be applied to anything, but the accuracy of it will subject to many factors. If your data doesn't follow a repeating pattern, then it will be difficult to forecast with any level of accuracy.
Thank you so much. Not everyone will share knowledge free these days. You an an exception. God bless you
It's my pleasure 😊
Awesome tutorial and tip!
Expand with pivot table, formulas, slicers, add a target column and I have an interactive chart for my users and the 90 products I report on monthly. Awesome. Thank you
Glad you’ll be able to make use of it, Charlie.
Thanks Mynda. The axes formatting was a great tip to learn even if we don't use the forecast function.
Glad it was worth your time, Kim :-)
Yup. That was something new for me as well. 🥰
Indeed something new for me too, thanks Mynda.
I couldn't pick up what you said return--- when type "CNTL + J"... though.
You put so much effort into teaching us noobs about forecast tool and I got excited about wrapping dates with custom formatting 😜
Another great video btw 😊
Great to hear you found it helpful 😊
All your videos are awesome. Being recently arrived in a position with a lot of reports, they are very useful to me.
I observed that a lot of functionalities rely on having real good & usable data. Did you do about it dealing exclusively on the quality of entry data ? I’m sure many of the roadblock I face today come from data rather than issues in using then.
Yes, the correct data structure is key. I use power query to clean my data: www.myonlinetraininghub.com/introduction-to-power-query
Thanks Mynda, great overview. Plus I learn a new tip for custom formats and shortcut CTRL+J 👍John
Great to hear!
Nice tutorial!!!! I liked how you presented.
Thank you! Cheers!
Hi Mynda!Great Tutorial Plus Cool Tips...Thank You :)
Cheers, Darryl 😊
This is an awesome tool! Thanks a lot Mynda.
Glad you like it 😊
Thanks Mynda, I know it is there but need to use it more often!
Yes, me too, Chris 😊
Great one Mynda! Thanks for showing this feature. Thumbs up!!
Cheers, Wayne 😊
Very Insightful....Thanks a million!
My pleasure 😊
"Wrapped down onto the next line" ..The showstopper!!!
:-) glad you liked that tip!
Cool tip for the custom format of dates. Gonna steel that 🙂
Glad you liked it 😊
Thank you so much it was helpfull.
I'm so glad!
First time I knew about it, thanks alot
Glad I could teach you something new, Ahmad :-)
Great video as usual ❤
Thank you so much 😀
Thank you so much, do we have a feasibility to get the interval wise and Day wise forecast as-well?
If the source data is at the day level then it will forecast accordingly.
Hi, i have office 365 on Mac and on excel, i dont have the "forecasting sheet" in my data ribbon... can you advice whether this feature is or isnt available on Mac?
It's not available for Mac, sorry.
Thanks, great video.
Thank you 😊
Hello Mynda, that's really interesting, thank you! Do you think that this would work with examination grades?
Not sure you’d have enough data points for it to work. You also need data at evenly spaced time intervals. I don’t know your data though so it might work.
Thanks for it, very useful video! I wonder if someone can advise, the demonstrated data on the video are only time based, how about if we have data also with regions? i.e. US, UK etc. sales in January, Feb....? It looks excel forecasting function can only based the forecasting in time series without other regional elements. Thanks in advance
You'd have to forecast each region separately.
Thank you for sharing. Is it possible to forecast for multiple products/ items in the same data sheet?
Not sure. I'd give it a go and you'll soon find out if you can run the Forecast sheet tool twice for different data sets in the same sheet. Alternatively, you can use the functions it generates to build the forecasts yourself.
@@MyOnlineTrainingHub Great and thank you for your advice! I look forward to hearing from you soon.
Great video!
Glad you enjoyed it :-)
I was doing this by hand which can take a while. I was going to try and figure out an upper limit where I transfer funds from one investment to another to build that one up.
Hope it was helpful :-)
Thanks and good tips, I've excel 2012 & can't see forecast function. Is there a way to get it? Thanks
It's only available in 2016 onward, so you'd have to upgrade your version of Excel to get it.
Hi Mynda, I have a pivot table where as the first columns has months (Jan, Feb, Mars, etc). The forecast worksheet can not been created. It tells me that the timeline is not evenly spaced. How come? So it looks when dates are grouped YY/MM does does not may work. Any thoughts please?
You need to add a column containing complete dates e.g. 1/1/2024 etc.
great video can you make similar videos of other ms office tools
Will do 👍
Is it possible to use dynamic ranges? I am pulling my data using Power Query and it updates daily adding a new row.
Yes, you can reference dynamic ranges with the FORECAST functions.
great
Thank you!
How can I find the forecast sheet? I can't find it in DATA
You can download the file on this page (www.myonlinetraininghub.com/excel-forecast-sheet), and in that file you'll see there's a sheet called 'Forecast Sheet'.
My CTRL+J does nothing. Is there a setting or a trick to this?
It doesn't appear to do anything when you press it, but once you apply the format and then wrap the text in the cell you'll see it forces a carriage return in the cell.
My 2019 doesn't have the Forecast
Strange! According to Microsoft, Excel 2019 has the Forecast sheets: support.microsoft.com/en-us/office/create-a-forecast-in-excel-for-windows-22c500da-6da7-45e5-bfdc-60a7062329fd
It would be more helpful if you use real sales data instead of simple data. In reality, we have to apply forecasting for sales data from multiple data from previous years and data are not that simple with equal distribution.
The data is real Hawaii visitor numbers. Forecasting can be applied to anything, but the accuracy of it will subject to many factors. If your data doesn't follow a repeating pattern, then it will be difficult to forecast with any level of accuracy.
@5:20 mm ctrl j, yy