Grab the file I used in the video from here 👉 pages.xelplus.com/forecasting-file
@hanhnguyenthi104
8 ай бұрын
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.
@teoxengineer
2 жыл бұрын
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.
@LeilaGharani
2 жыл бұрын
Glad the video was useful, Emre!
@trmibp9441
2 жыл бұрын
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!
@LeilaGharani
2 жыл бұрын
Thank you!
@alialfares2845
2 жыл бұрын
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 🌸
@isaacmwabila5830
2 жыл бұрын
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 👏👌🏽🙂
@Abhi2533
2 жыл бұрын
Leila Gharani you are "MVP" in teaching! Amazing work with such simplicity!
@DemetriPanici
2 жыл бұрын
A solid forecast gives people a great idea of what needs to be done. Great tips!
@LeilaGharani
2 жыл бұрын
Thank you!
@DietricWilliams
4 ай бұрын
This made my day! Saves a ton of time without having to manually using regression analysis formulas based on trendlines. THANK YOU!!
@Harka666
2 жыл бұрын
Great video as always! I wish you were making more financial stuff.
@LeilaGharani
2 жыл бұрын
I will 😊 I have some planned .
@mattschoular8844
2 жыл бұрын
Interesting. There are so many use cases for this tool as we approach the end of the year. Thanks Leila.
@LeilaGharani
2 жыл бұрын
Hope it will come in handy.
@tamarachirwa2024
2 жыл бұрын
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.
@anayafun
2 жыл бұрын
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
@uhsemehicieronlas3
2 жыл бұрын
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!
@khainguyenduy9742
2 жыл бұрын
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?
@latoriabaggs9796
2 жыл бұрын
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..
@davidlong3359
2 жыл бұрын
I thought I was good in excel right up until I found this channel.
@user-lb2gp8xp3l
Жыл бұрын
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.
@vijayarjunwadkar
2 жыл бұрын
Nice as usual! Appreciate your consistency and zeal to bring out the best in Excel and educate us every week! Thank you Leila! 😊👍
@LeilaGharani
2 жыл бұрын
Thanks for watching, Vijay!
@whitealliance9540
2 жыл бұрын
@Armando Aranda dude she goin have kids wit me before you lmao you aint a thugga hugga you aint got no swagger
@isyarakhairani8017
2 жыл бұрын
you deserve all the good things in this world, thank you for sharing!
@zatifkhan2120
2 жыл бұрын
I think, my emptiness and your forecasting video made me fall in love with you.
@shakiraasfoor7599
2 жыл бұрын
Looking Forward to more Accounting Topics..
@iam.DonWong
2 жыл бұрын
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.
@LeilaGharani
2 жыл бұрын
You can say you used an exponential triple smoothing algorithm 😎
@AlvinRyellPrada
2 жыл бұрын
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
2 жыл бұрын
That's great! Hope it will come in handy for you.
@syedmansoor2023
11 ай бұрын
Exactly what I'm looking for! Thanks for breaking it down into manageable chunks.
@ashishcastelino1571
2 жыл бұрын
My one stop for all excel related questions! Thank you Leila for sharing knowledge. God bless!!!
@redrum4486
2 жыл бұрын
you the GOAT, always coming in with these gems
@ShauHettiarachchi
Жыл бұрын
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! 🥰🥰🥰
@samuelofosu-wiredu1259
2 жыл бұрын
Great thanks for the info you bring us regularly.
@Coffeedrinkerer
2 жыл бұрын
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
@LeilaGharani
2 жыл бұрын
Glad I could help!
@casinogeno1
2 жыл бұрын
Love the shorter videos that give me great ideas/info. Thank you!!!
@LeilaGharani
2 жыл бұрын
Glad you like them!
@mazharhussain8871
11 ай бұрын
I love your voice , concept and language clarity .
@Leonardo-br6cw
2 жыл бұрын
I have no word...Just amazing!!! Immagine... I didn't know there was a forecast tab. Thank you
@LeilaGharani
2 жыл бұрын
Happy to help, Leonardo!
@Leonardo-br6cw
2 жыл бұрын
@@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
@GeertDelmulle
2 жыл бұрын
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).
@LeilaGharani
2 жыл бұрын
My pleasure, Geert! True, these are great functions.
@chipturner495
2 жыл бұрын
Yet another tool you've taught me! Thanks again and I'm forecasting greater success for you!
@user-mu5zw6ly9t
3 ай бұрын
Indeed such an educative video thank you for posting this for us.❤
@LeilaGharani
3 ай бұрын
My pleasure 😊
@SP-nx8qx
2 жыл бұрын
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
@LeilaGharani
2 жыл бұрын
😁
@user-xd2fk5gy9r
7 ай бұрын
thank you for the tutorials. everyone is excellent and extremely helpful.
@SabtechOnline
2 жыл бұрын
Thanks Leila, your tips are always inspirational in building my Data analysis carrier and KZitem channel growing positively
@savioseona
2 жыл бұрын
Wow. Yet another great feature of Excel I wasn't aware of. Thanks for sharing.
@arcusznik
2 жыл бұрын
I'm gonna try it this monday, hope it'll help me :)
@jedt3d
Ай бұрын
marvelous explanation! concise and informative! 🎉
@hn5312
10 ай бұрын
Thank you.... you are such a great teacher. I love your videos.
@AfzalKuhnaward
Жыл бұрын
@Leila, love your videos for all the hard work you do! Thank you!
@harshababu8321
2 жыл бұрын
More than the function I admire your explanation, and the super topics you deliver. 🙂🙂🙂
@LeilaGharani
2 жыл бұрын
Thank you! 😃
@abdallah.kandiel
2 жыл бұрын
Brilliant as always Happy Thursday your highness
@LeilaGharani
2 жыл бұрын
Thanks for watching!
@chh8860
2 жыл бұрын
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.
@LeilaGharani
2 жыл бұрын
Glad it's something you find helpful. Thanks for the laugh on the ETS 😂
@gigimalvassora9682
2 жыл бұрын
FANTASTIC!!! Thank you!
@hansscholl6346
2 жыл бұрын
Love It! Cool channel, thanks for having you here☺️
@Seftehandle
2 жыл бұрын
Im impressed Laila.we finance people eed more of this!!!!
@martapunsola2025
2 жыл бұрын
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
@danielricohuerta6956
Жыл бұрын
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
@LeilaGharani
Жыл бұрын
Great! Happy to have you aboard.
@abdullaalturabi6526
2 жыл бұрын
the terms used in the video reminded me of cfa days
@juanmd26121
2 жыл бұрын
You are a god of excel
@prakharmehrishi5284
2 жыл бұрын
I love your voice, love your skills ❤️
@afshindejbodi6702
2 жыл бұрын
I literally worked with this function 👍
@gecemetrosu9734
2 жыл бұрын
Very useful and intelligent teaching method
@LeilaGharani
2 жыл бұрын
Thank you!
@chrism9037
2 жыл бұрын
This is great, thanks Leila!
@LeilaGharani
2 жыл бұрын
Thanks for stopping by, Chris!
@tridibbiswas3361
2 жыл бұрын
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.
@Yachid
2 жыл бұрын
'Queen of Excel' 😉
@LeilaGharani
2 жыл бұрын
Unfortunately, we don't have any Mac in the office. But maybe it's time for that :) Thanks for the suggestion!
@Bill0102
8 ай бұрын
This material is top-notch. A similar book I read was a breakthrough for me. "Mastering Money Mindfulness" by Benjamin Hawk
@craftpassion1812
2 жыл бұрын
Always learn something new. This video came in very handy. Thankyou
@LeilaGharani
2 жыл бұрын
Glad to hear that!
@michaelsanders5938
2 жыл бұрын
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.
@CaribouDataScience
Жыл бұрын
Thanks, that was easy!
@LeilaGharani
Жыл бұрын
👍
@Allandy001
2 жыл бұрын
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!!!
@LeilaGharani
2 жыл бұрын
You're so welcome!
@munene11.11
Жыл бұрын
All my statistical lectures have been summed up with excel.
@samuelkodjoe1645
2 жыл бұрын
very insightful....loved it!!
@mirach274
Жыл бұрын
I love you Leila you are doing an amaziiiing job 💖 ❤ Thank you for your help 💜
@divyakanchi5773
2 жыл бұрын
Hi, your explanation is amazing. Thank you
@LeilaGharani
2 жыл бұрын
Glad it was helpful!
@shakibshaker7689
Жыл бұрын
Rolling Forecasting more video need.
@andrewkhan6126
Жыл бұрын
Thank you, this vide was extremely helpful. OMW to check the rest of your videos now!
@gianluigiredolfini6154
2 жыл бұрын
You are unbelievable thanks 🙏 so much
@LeilaGharani
2 жыл бұрын
You're most welcome, Gianluigi!
@sultanfolawiyo355
Ай бұрын
Thank you so much for this
@Silas832
2 жыл бұрын
Great Video, thank you very much!
@LeilaGharani
2 жыл бұрын
Glad you liked it!
@barttitulaerexcelbart9400
2 жыл бұрын
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.....😃
@LeilaGharani
2 жыл бұрын
Thanks for the tip, Bart!
@ibrahimolufisayo8401
2 жыл бұрын
Woow.... I'm awed. Econometrics made easy.
@tifouraamina1761
2 жыл бұрын
Impressive Liela 😃I'll use it for other purposes then financial analysis 😃you just gave me a great idea
@LeilaGharani
2 жыл бұрын
That's great to hear 👍
@jithgopi6310
2 жыл бұрын
Very good presentation..You sound soothing..
@jasonipfatsiong2062
2 жыл бұрын
That’s great very useful. Thank you so much Leila take special care
@SerdarTatar5665
5 ай бұрын
Ağzina sağlık ses hayran kaldım
@Seftehandle
2 жыл бұрын
Gorgeous, how come i didnt see this 2 days ago
@FaysalEasyExcel
2 жыл бұрын
Thanks Lelia for surprising me. wonderful excel chart idea.
@LeilaGharani
2 жыл бұрын
You're welcome 😊
@davidcooper3871
Жыл бұрын
Been looking for something like this!
@wooddog007
2 жыл бұрын
Good tutorial ... but was disappointed you did not explain what the "Include forecast statistics" tick box does.
@alimanchester
Жыл бұрын
Great, direct and it is too clear
@lindachall8372
5 ай бұрын
Thank you, I enjoy your videos
@LeilaGharani
5 ай бұрын
Glad you like them!
@ateeqahmad
2 жыл бұрын
Thanks so much for all your videos!!!
@LeilaGharani
2 жыл бұрын
Thank you!
@hacksawridge8
2 жыл бұрын
Great tip Leila! I really enjoy your videos, good stuff!
@DougHExcel
2 жыл бұрын
Revisiting your economics background on this one! Great video Leila!
@wayneedmondson1065
2 жыл бұрын
Hi Leila. Great video! Thanks for the Forecasting feature demo and also the explanation and details.. very helpful :)) Thumbs up!!
@ExcellentIdeasTips
2 жыл бұрын
Nice video and explanation. Now is time to forecast something :)
@ramaswamyg5919
2 жыл бұрын
Hi Leila! This is brilliant. Can I get the math behind the statistical points please (Eg: Formula of exponential forecasting) ?
@metimeOlympiad
2 жыл бұрын
Amazing 👏 and very useful 👌
@SyedMuzammilMahasanShahi
2 жыл бұрын
Thanks for this beautiful video.
@RajeshBachuRadhika
2 жыл бұрын
Thanks Leila for the video.. this is great help
@GP-ty8ix
2 жыл бұрын
Amazing how you made it to over million subs.
@justine9752
2 жыл бұрын
Just what i need. Thanks!
@rseeram
7 ай бұрын
Excellent Thanks Leila Gharani
@davep1875
2 жыл бұрын
Thanks for that video , very helpful!
@greenvaldnir
Ай бұрын
Many thanks !!!!!!!
@Tommie_Rogers
2 жыл бұрын
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
Пікірлер: 357