FORECAST.LINEAR & FORECAST.ETS Functions in Excel 2016

Download the featured file here (towards bottom of page)
www.bluepecantraining.com/port...
The FORECAST.ETS predicts a future value based on historical values. It uses the Exponential Triple Smoothing (ETS) algorithm. The FORECAST.LINEAR function makes a prediction using a simple linear regression.
------------------------

[@kg7760]

Great Video! I've been watching videos all the day, and yours is just Wow. Thank you!

[@VishalSharma-rn7mt]

Very well explained the Forecast concept, great video Chester

[@ythens]

Simple and clear. Thanks mate

[@georgiosgrigoriou2216]

Great video Chester thank you very much !

[@naravindnair]

Great video Chester. Thank you.

[@Tgarth99]

You are very articulate!

[@dr.vinishp]

Very well explained. Thank you so much

[@ChesterTugwell]

Glad it was helpful!

[@freespeech7747]

Really useful a clear tutorial

[@mghayadar]

This is Awesome. Thank You Very Much. :)

[@bulliethepirate]

Very helpful and clear . Thanks a lot

[@DrMuhammadEddieb]

very great explanation for Excel forecast, I'm really thankful for your explanation. Best Regards

[@zoutube19]

Thanks!

[@Berghiker]

How do you connect uneven spaces between dots on a line chart? Is this possible with excel?

[@edwardlicayan5054]

If I have zeroes that I don't want to be counted on my data, how do I go about it while still using the forecast formula?

[@jennyhe31]

Hi Chester, I have followed your step to create a table. In m table, when calculated the linear forecast (the first one function you showed to us), why does my excel cannot put x axis as time period (the format such as date, same as yours), it only can calculate by pure numbers. For example, my excel, only can the date as the time period by the number of 1,2,3,4,5 … for presenting the months. Once I put the date format as the x axis for using forecast function, the value came out as error.

[@GrupoLibertyNETCLUB]

How can I find the algorithm to Forecast linear function, do you know?

[@NeverBeenThereBefore]

It's in the video

[@johnypayeras]

where can I find the option prevision on a MacBook?

[@alatengbay5577]

Why do you say it's 95%