Forecasting in Excel Made SIMPLE (include seasonality & make predictions)

Hi Leila. Does Office 365 have this tool? And does it matter which version, for example, personal vs business? Thank you.

Thank you.... you are such a great teacher. I love your videos.

Very nice, thanks you 😊🥰🥰

Awesome 👌 👏

Hello! thanks for all your videos. Always very useful. Do you have any idea how to avoid having negative values? (can't have -500 USD of sales) thanks!

I love your voice , concept and language clarity .

... thank you..very useful for my DBA....

Exactly what I'm looking for! Thanks for breaking it down into manageable chunks.

This is such a brilliant content! Do you have an alternative for this kind of problem in Google Sheet?

what type of statistics is this example?

Thank you, this vide was extremely helpful. OMW to check the rest of your videos now!

Great Presentation and very useful. Do you have more forecasting examples?

That's it? You just press one button and you're done? There's got to be more to this

Pretty helpful, thanks a lot!

Hi Leila, if the timeline isn't evenly spaced. how can it be fixed? thanks

Should this include inventory data also?

is there not any way to automate the whole process if we have 1000+ Sku's and we have to do Inventory Planning.

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.

Amazing video

Where is the forecast section sheet

Hi, do you have a tutorial for forecasting call volumes and AHT for a contact centre?

this is not forecasting

Data source?

All my statistical lectures have been summed up with excel.

Please tell how can i change date to months in horizontal axis

Thanks, that was easy!

Hi. I have fuel sales data of everyday with me and I forecast it for next 90 days. The thing is there are two seasonality - weekly and yearly. I have been using the weekly seasonality by adding "7" in the FORECAST.ETS formula. But how can 2 seasonalities be added in a forecast?

More confused than I was before.

SHE IS SO BEAUTIFUL.

This was useful< question how do I adjust the parameter to ensure that the lower limit does not go under zero. In theory, you can't have negative sales

Can I use more than 2 data sets?

Just noticed we have the same keyboard. Personally, I highly recommend it to all who read this. :) Logitech K780

@Leila, love your videos for all the hard work you do! Thank you!

A forecast can’t be created because the timeline isn’t evenly spaced. The dates or numbers in a valid timeline must have a consistent gap between consecutive points. This is an error if I plug in your exact dates or any others that are irregular. I have been unable to find a solution to this. The only fix I found was only using the year and not the exact date for each quarter.

Is there a way for simultaneously forecasting 200+ SKU's?

Thank you very much for your video. Can we do rolling window? Like I have 1000 time series but a want to use 50 historical to forecast 5 observation in the future but I roll along the data so if doing mannualy it will take a lot of time.

Been looking for something like this!

I LOVE YOU LEILA))))

Hi, it would be helpful if you can provide the link for downloading the excel file that you use for demonstration, so that we can practice on the same and check at every stage if we are doing correctly

Quick question, Leila. Is the Excel forecast only used for data with seasonality?

This is great. How long has this been around? This would have saved me a ton of time had I known about it, oh 10 years ago. Doing this with a calculator and finding Slope, Y-intercept and solving Y = mX+b sucked.

thank you for the tutorials. everyone is excellent and extremely helpful.

Very gret video, i like very mach. kep up de god vork

Helpful!

I love you Leila you are doing an amaziiiing job 💖 ❤ Thank you for your help 💜

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! 🥰🥰🥰

Perfect

what if i want to forecast sales for more than one item