Hello Leila, thank you for your video. I have a question, hope you can help me out. I am looking for a forecasting method of copper price. Considering that I have historical price of copper, and other influencing factors such as: supply & demand, energy costs, alternative metals (aluminum, zinc,etc.), macroeconomic conditions, national policies,etc. In this case, which forecasting methods is suitable to use? Thank you.
Hello Leila, Today I updated my budget estimates for the next period and tried to derive the results by applying the rules specified in his tutorial. It was just a coincidence for me that you shared this explanatory tutorial today. Thanks to you, I have identified my shortcomings in my estimations and have already corrected them. The forecasting algorithm in Excel is very beneficial for data analysts and project managers like us, and learning these tips from a finance and excel expert like you is invaluable. Thank you so much again.
I worked with this to identify trends in products and services sold to help see where we needed to pay more attention in growing the company, great functions tho and everything was explained really good!
I learned from your videos many functions: FILTER, SORT, ISNUMBER,... and many others! I'm happy to learn still from you this new function (for me)! Thank you Leila 👏👌🏽🙂
I really like that lately you had been choosing statistical functionality of excel to present as professional tutorials .. Thanks alot that is highly needed and helpful 🌸
Lelia, following you from last four years and you always surprise me with excel functionality which is there but I don't know until you make it known to others.. Good functionality but there are lots of constraints to develop strong forecast. Excel developments are mind blowing...wooohoooo
This looks very useful... similar to what I'd do manually. It'd be useful if you can explain further the excel formula and the logic behind it to be able to adjust the results and present them to an audience. Love your content! I am looking forward to the new DAX and power pivot course!
Excuse me but may I ask you a little about the actual demand forecasting job? I'm working in production, but I'm looking for more knowlege about the Supply Chain, especially in Demand forecasting, then I had an interview with an Retailer company, the director told me that the time cycle series forecast is just a so basic method in that major, but I've found a lot on the Internet and I just see all kind of that "basic" method. Like Moving Average, Exponential Smoothing, Regression Analysis,.. Is there any more knowlege (or method) I need to learn if I want to work in Demand Planning Jobs?
I dont work as a demand planner but very close. I would say there is no the best method for forecasting, you just need to make your own towards your needs. Moving average doesnt match when you have a lot of oscilations in demanding. You have to set up your method which follows trends, seasonality, sales, etc. More variables in one formulas…. Also, you have warehouse for that, if you didnt plan as good as you need, your stock will cover you for X days. Maybe my topic isnt helpful but i am at your service for additional questions..
your my savior thank you so much !! I've been watching a lot of forecasting and my brain is gonna explode but when i came to you're video its easier to understand. so thank you.
Thursday Mornings With Leila ... (with hot black coffee and a small slice of crumb cake) ... always eagerly anticipated ... rarely (if ever) disappointed. LOVE IT ... LOVE IT ... LOVE IT!!! ... directly relevant for me ... I was totally unaware of this gem from the Excel vault (beautifully explained by Lady Leila ... no surprise) ... I have been stringing together a series of Excel functions nested a few layers deep. I am definitely looking forward to taking this function for a spin ... thank you ... thank you ... thank you. PS Thankfully Leila did not begin the video with "Exponential Triple Smoothing" ... 😲 ... or I might have slumped over my desk clutching my heart.
I find this is awesome if you go back to the actual data and start eliminating peaks and valleys that you know were one-offs, and watch the forecast get adjusted automatically. That's the good side of this function. The bad side is when you're presenting the forecast to the VP of Sales and the CFO, and they ask you so what did you base your forecast on? and you're like "ahhhh, dunno, some excel logarithm that I don't understand" LOL
Wow definitely this is a powerful tool I would love to use this function to forecast how many calls we will get in our centre. I feel so enabled watching your tutorial ❤️
@@LeilaGharani I need a big favor: I will open a small restaurant, and I need the formula to calculate how many staff (Kitchen and Service) I need to hire for the opening based on an average of 60 to 80 covers per day. Can you help or is it not your field? Thank you very much in advance.....Leonardo
Literally was looking for this yesterday for a cost volume model I need to pull together. This is great as I wasn’t sure how to pull the seasonality from previous data
Ma'am you're amazing!! I did a budget based in school forecast, buy when I saw yours, I did it better, so thanks so much and I've subscribed at your channel
It’s a nice quick and easy way to do forecasting… the challenge will be how to explain the “model” to your stakeholder, bosses clients on how you arrived to your numbers.
I m so happy to discover this functionality.big thanks Leila. Of course you need to consider the environment after using the formulas but still Save the time to fill in gaps
Your videos have always been my source for go to for anything Excel. Thank you for the sharing these videos. Could you share a video on the feature differences in Excel for Windows and Mac.
Hi Leila. I use a remarkably similar method. I place 0's (zeros) for the number of 0's I need and then use the # symbol for the number of numerical digits. Guess they are the same, just slightly different
Great Video Leila! This function also works with less regular seasonality, like a peak in december and a low in summer. One remark (as usual...), great idea to compare actuals with forecast in order to show the reliablity of the forecast. But if you create a new one, you should always (in my oppinion) use the latest actuals available. Also interesting to explore all FORECAST functions, there is so much gold in Excel.....😃
Hi Leila, it's so gud to c ur videos always...all this knowledge really helps for people who want to excel or r always eager to learn something new...can u plz upload a video on budgeting in excel...it wud really help..
Thx, how very timely, lol - - - I waz chart'ng weightz for my new [wk.15] kitten, Misty; I tabled the data, then chart'd same - & I waz think'ng, 'I wound'r, how to predict the successive wkz'
Grab the file I used in the video from here 👉 pages.xelplus.com/forecasting-file
Hello Leila, thank you for your video. I have a question, hope you can help me out. I am looking for a forecasting method of copper price. Considering that I have historical price of copper, and other influencing factors such as: supply & demand, energy costs, alternative metals (aluminum, zinc,etc.), macroeconomic conditions, national policies,etc. In this case, which forecasting methods is suitable to use?
Thank you.
Hello Leila,
Today I updated my budget estimates for the next period and tried to derive the results by applying the rules specified in his tutorial. It was just a coincidence for me that you shared this explanatory tutorial today.
Thanks to you, I have identified my shortcomings in my estimations and have already corrected them.
The forecasting algorithm in Excel is very beneficial for data analysts and project managers like us, and learning these tips from a finance and excel expert like you is invaluable.
Thank you so much again.
Glad the video was useful, Emre!
I worked with this to identify trends in products and services sold to help see where we needed to pay more attention in growing the company, great functions tho and everything was explained really good!
Thank you!
I learned from your videos many functions: FILTER, SORT, ISNUMBER,... and many others!
I'm happy to learn still from you this new function (for me)!
Thank you Leila 👏👌🏽🙂
I really like that lately you had been choosing statistical functionality of excel to present as professional tutorials .. Thanks alot that is highly needed and helpful 🌸
This made my day! Saves a ton of time without having to manually using regression analysis formulas based on trendlines. THANK YOU!!
Leila Gharani you are "MVP" in teaching! Amazing work with such simplicity!
Lelia, following you from last four years and you always surprise me with excel functionality which is there but I don't know until you make it known to others..
Good functionality but there are lots of constraints to develop strong forecast.
Excel developments are mind blowing...wooohoooo
A solid forecast gives people a great idea of what needs to be done. Great tips!
Thank you!
Great video as always! I wish you were making more financial stuff.
I will 😊 I have some planned .
Interesting. There are so many use cases for this tool as we approach the end of the year. Thanks Leila.
Hope it will come in handy.
This looks very useful... similar to what I'd do manually. It'd be useful if you can explain further the excel formula and the logic behind it to be able to adjust the results and present them to an audience.
Love your content! I am looking forward to the new DAX and power pivot course!
Excuse me but may I ask you a little about the actual demand forecasting job?
I'm working in production, but I'm looking for more knowlege about the Supply Chain, especially in Demand forecasting, then I had an interview with an Retailer company, the director told me that the time cycle series forecast is just a so basic method in that major, but I've found a lot on the Internet and I just see all kind of that "basic" method. Like Moving Average, Exponential Smoothing, Regression Analysis,..
Is there any more knowlege (or method) I need to learn if I want to work in Demand Planning Jobs?
I dont work as a demand planner but very close. I would say there is no the best method for forecasting, you just need to make your own towards your needs. Moving average doesnt match when you have a lot of oscilations in demanding. You have to set up your method which follows trends, seasonality, sales, etc. More variables in one formulas…. Also, you have warehouse for that, if you didnt plan as good as you need, your stock will cover you for X days. Maybe my topic isnt helpful but i am at your service for additional questions..
Leila, you are a star⭐,I am a beginner and didn't have a clue on what I was doing. You made it so easy to understand. Thank you xxx.
your my savior thank you so much !! I've been watching a lot of forecasting and my brain is gonna explode but when i came to you're video its easier to understand. so thank you.
I think, my emptiness and your forecasting video made me fall in love with you.
you deserve all the good things in this world, thank you for sharing!
I thought I was good in excel right up until I found this channel.
Nice as usual! Appreciate your consistency and zeal to bring out the best in Excel and educate us every week! Thank you Leila! 😊👍
Thanks for watching, Vijay!
@Armando Aranda dude she goin have kids wit me before you lmao you aint a thugga hugga you aint got no swagger
Thursday Mornings With Leila ... (with hot black coffee and a small slice of crumb cake) ... always eagerly anticipated ... rarely (if ever) disappointed.
LOVE IT ... LOVE IT ... LOVE IT!!! ... directly relevant for me ... I was totally unaware of this gem from the Excel vault (beautifully explained by Lady Leila ... no surprise) ... I have been stringing together a series of Excel functions nested a few layers deep. I am definitely looking forward to taking this function for a spin ... thank you ... thank you ... thank you.
PS
Thankfully Leila did not begin the video with "Exponential Triple Smoothing" ... 😲 ... or I might have slumped over my desk clutching my heart.
Glad it's something you find helpful. Thanks for the laugh on the ETS 😂
I find this is awesome if you go back to the actual data and start eliminating peaks and valleys that you know were one-offs, and watch the forecast get adjusted automatically. That's the good side of this function. The bad side is when you're presenting the forecast to the VP of Sales and the CFO, and they ask you so what did you base your forecast on? and you're like "ahhhh, dunno, some excel logarithm that I don't understand" LOL
😁
Wow definitely this is a powerful tool
I would love to use this function to forecast how many calls we will get in our centre. I feel so enabled watching your tutorial ❤️
That's great! Hope it will come in handy for you.
you the GOAT, always coming in with these gems
Indeed such an educative video thank you for posting this for us.❤
My pleasure 😊
Looking Forward to more Accounting Topics..
I have no word...Just amazing!!! Immagine... I didn't know there was a forecast tab. Thank you
Happy to help, Leonardo!
@@LeilaGharani I need a big favor: I will open a small restaurant, and I need the formula to calculate how many staff (Kitchen and Service) I need to hire for the opening based on an average of 60 to 80 covers per day. Can you help or is it not your field? Thank you very much in advance.....Leonardo
Great thanks for the info you bring us regularly.
Dont know what else to say, but I absolutely LOVE you! So much clarity and by the end of your video I've resolved my issue as well! 🥰🥰🥰
Literally was looking for this yesterday for a cost volume model I need to pull together. This is great as I wasn’t sure how to pull the seasonality from previous data
Glad I could help!
I love your voice , concept and language clarity .
Love the shorter videos that give me great ideas/info. Thank you!!!
Glad you like them!
Exactly what I'm looking for! Thanks for breaking it down into manageable chunks.
marvelous explanation! concise and informative! 🎉
I'm gonna try it this monday, hope it'll help me :)
thank you for the tutorials. everyone is excellent and extremely helpful.
My one stop for all excel related questions! Thank you Leila for sharing knowledge. God bless!!!
Thank you for this valuable lesson.
We don’t use these specialised functions enough (and as I remember this, it sure has grown over the years).
My pleasure, Geert! True, these are great functions.
Ma'am you're amazing!! I did a budget based in school forecast, buy when I saw yours, I did it better, so thanks so much and I've subscribed at your channel
Great! Happy to have you aboard.
Yet another tool you've taught me! Thanks again and I'm forecasting greater success for you!
It’s a nice quick and easy way to do forecasting… the challenge will be how to explain the “model” to your stakeholder, bosses clients on how you arrived to your numbers.
You can say you used an exponential triple smoothing algorithm 😎
Love It! Cool channel, thanks for having you here☺️
Thank you.... you are such a great teacher. I love your videos.
Wow. Yet another great feature of Excel I wasn't aware of. Thanks for sharing.
Thanks Leila, your tips are always inspirational in building my Data analysis carrier and UA-cam channel growing positively
This material is top-notch. A similar book I read was a breakthrough for me. "Mastering Money Mindfulness" by Benjamin Hawk
Brilliant as always
Happy Thursday your highness
Thanks for watching!
More than the function I admire your explanation, and the super topics you deliver. 🙂🙂🙂
Thank you! 😃
@Leila, love your videos for all the hard work you do! Thank you!
I m so happy to discover this functionality.big thanks Leila. Of course you need to consider the environment after using the formulas but still Save the time to fill in gaps
Leila, thanks for the another very useful video. And my regular request for you to do an ASMR channel or podcast.....I love you voice. Thanks.
Your videos have always been my source for go to for anything Excel. Thank you for the sharing these videos. Could you share a video on the feature differences in Excel for Windows and Mac.
'Queen of Excel' 😉
Unfortunately, we don't have any Mac in the office. But maybe it's time for that :) Thanks for the suggestion!
Hi Leila!
This is brilliant.
Can I get the math behind the statistical points please (Eg: Formula of exponential forecasting) ?
Always learn something new. This video came in very handy. Thankyou
Glad to hear that!
Very useful and intelligent teaching method
Thank you!
Thank you so much for this
FANTASTIC!!!
Thank you!
Thank you, this vide was extremely helpful. OMW to check the rest of your videos now!
I love you Leila you are doing an amaziiiing job 💖 ❤ Thank you for your help 💜
Hi Leila. I use a remarkably similar method. I place 0's (zeros) for the number of 0's I need and then use the # symbol for the number of numerical digits. Guess they are the same, just slightly different
the terms used in the video reminded me of cfa days
very insightful....loved it!!
Im impressed Laila.we finance people eed more of this!!!!
Great Video, thank you very much!
Glad you liked it!
Thanks, that was easy!
👍
Hi, your explanation is amazing. Thank you
Glad it was helpful!
Thank you, I enjoy your videos
Glad you like them!
This is great, thanks Leila!
Thanks for stopping by, Chris!
Amazing. Very useful for my work. I do forecasts all the time and I have to always do a lot of calculations. Thank you Leila!!!
You're so welcome!
Good tutorial ... but was disappointed you did not explain what the "Include forecast statistics" tick box does.
I love your voice, love your skills ❤️
Thanks so much for all your videos!!!
Thank you!
Very good presentation..You sound soothing..
Impressive Liela 😃I'll use it for other purposes then financial analysis 😃you just gave me a great idea
That's great to hear 👍
You are unbelievable thanks 🙏 so much
You're most welcome, Gianluigi!
Great Video Leila! This function also works with less regular seasonality, like a peak in december and a low in summer. One remark (as usual...), great idea to compare actuals with forecast in order to show the reliablity of the forecast. But if you create a new one, you should always (in my oppinion) use the latest actuals available. Also interesting to explore all FORECAST functions, there is so much gold in Excel.....😃
Thanks for the tip, Bart!
Been looking for something like this!
Thank you.
I literally worked with this function 👍
Ağzina sağlık ses hayran kaldım
That’s great very useful. Thank you so much Leila take special care
Great tip Leila! I really enjoy your videos, good stuff!
This is awesome, thank you so much
All my statistical lectures have been summed up with excel.
Rolling Forecasting more video need.
Nice video and explanation. Now is time to forecast something :)
Hi Leila, it's so gud to c ur videos always...all this knowledge really helps for people who want to excel or r always eager to learn something new...can u plz upload a video on budgeting in excel...it wud really help..
Thanks Lelia for surprising me. wonderful excel chart idea.
You're welcome 😊
Thanks for this beautiful video.
Thanks Leila for the video.. this is great help
Gorgeous, how come i didnt see this 2 days ago
Many thanks !!!!!!!
Thanks for that video , very helpful!
Very gret video, i like very mach. kep up de god vork
Great, direct and it is too clear
Hi Leila. Great video! Thanks for the Forecasting feature demo and also the explanation and details.. very helpful :)) Thumbs up!!
Thanks ! this was so helpful
Can you show a similar video for manpower forecasting / requirement ?
... thank you..very useful for my DBA....
Thanks lot Maam this will be great help for me...in past I did ask for any assistance on glide paths, these would certainly suffice it.. thanks again
My pleasure 😊
You are a god of excel
Thx, how very timely, lol - - -
I waz chart'ng weightz for
my new [wk.15] kitten, Misty;
I tabled the data, then chart'd same -
& I waz think'ng, 'I wound'r,
how to predict the successive wkz'