The Excel FORECAST Function

Подписаться 1,5 млн

Просмотров 570 тыс.

50% 1

Learn how to use the Excel FORECAST function to forecast the future, based upon past results. ***Consider supporting Technology for Teachers and Students on Patreon***: / technologyforteachersa... See my entire playlist of Excel videos: bit.ly/tech4excel Here is the practice file that goes with this video: bit.ly/excelforecast #excel #exceltutorial

Хобби

Опубликовано:

4 окт 2020

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 106

@remorrey Год назад

Absolutely well done! (Coming from a 76 year old MBA degree holder). I appreciate your getting right to the point with minimal branding info and unnecessary chit/chat.

@vilmamorales1855 Год назад

The simplest yet the best excel tutorial ever! Kudos!

@dmitriyshepher2493 Год назад

The best video of this function. I spent almost 4 hours to read boring articles. Thank you!

@elenabina1934 2 года назад

Thank you! Explained in a very simple way!

@pibidenalanka987 9 месяцев назад

Very important concept, very simple, and explained well. Thank you very much.

@tommicahmatila Год назад

Very simple and clear. Thank you for the help

@BeverlyMoore 3 года назад

Thank you, learning so much

@johnricktagalog2964 2 года назад

BIG HELP,, to refresh this subject thank you

@lameessy2302 3 года назад

Amazing function💜

@Hekokurd 2 года назад

Thank you so much for the quick help!

@AfricanTalesOasis 2 месяца назад

Thank you so much, Straight to the point. Love it!

@asugarholicslife Год назад

Thank you for this helpful video! I'm doing a report for work right now

@ynyslochtyn 2 года назад

Nice when things are simple!

@thesistips 3 года назад

Great one. It's really helpful and well organised. Thank you for sharing 😊😊

@srinagarmagazine9250 2 года назад

Can u please help me with this question..... You have a PIVOT for a data set of the range A1: H25, will changing the value in cell B:32 change the projections in the PIVOT?

@AlongtheRiverLife 3 года назад

Great, was notified this was posted!

@byankafitiari 2 года назад

thank you so much.. your video is really helpful

@cemdogan8736 2 года назад

Simple, perfect and very useful explanation. Thank you.

@srinagarmagazine9250 2 года назад

Can u please help me with this question..... You have a PIVOT for a data set of the range A1: H25, will changing the value in cell B:32 change the projections in the PIVOT?

@soudamininayak9697 Год назад

Thank you much it helped me to complete my project❤

@subramanirangasamy3320 3 года назад

Good Learning to me ..thanks

@engtahawatany7429 3 года назад

thanks for you support sir , really u saved me

@DilwaleChawlaJi Год назад

Great effort and kudos to you for the great work.

@domwings4329 3 года назад

Learning is fun w this video

@williammalusi1089 2 года назад

VERY HELPFUL

@bmore4101029 2 года назад

Thank you! This was a big help for my assignment for school!

@srinagarmagazine9250 2 года назад

Can u please help me with this question..... You have a PIVOT for a data set of the range A1: H25, will changing the value in cell B:32 change the projections in the PIVOT?

@srinagarmagazine9250 2 года назад

Can u please help me with this question..... You have a PIVOT for a data set of the range A1: H25, will changing the value in cell B:32 change the projections in the PIVOT?

@SG-mt3pe 3 года назад

Great Sir.

@Gumnaam12girl 2 года назад

Thank you sir so much

@ddduva4440 2 года назад

Helpful ty👏🏼👏🏼👏🏼

@khalidalgethmi8628 Год назад

Thank you very much

@firstnamesecondname5341 3 года назад

Here’s me mucking around up with compound interest rates when forecast is a lot more straight forward 👍

@clydesweetfeetlivingston1180 3 года назад

Ur nan is straight forward

@michaelmohanaraj1795 3 года назад

@@clydesweetfeetlivingston1180 💀😭😭

@thomaslebarre9089 3 года назад

thank you

@imtiyazrisaldar3211 Год назад

Thank you sir

@Larry21924 4 месяца назад

This is some top-notch content. I read a book with a similar topic, and it was absolutely incredible. "Game Theory and the Pursuit of Algorithmic Fairness" by Jack Frostwell

@luzcombs8415 5 месяцев назад

Thank you !!!!!

@AJ-et3vf 2 года назад

Very nice!

@ArchnaVijay Год назад

Hi nice informative video , what if we have quarters in each year , and i want to see forecasted values for 2035 Q1 ?

@Silas832 2 года назад

Thanks

@dawanesunil7847 Год назад

Thank QQQ Sir,

@pennym.2380 3 года назад

Thank you

@srinagarmagazine9250 2 года назад

Can u please help me with this question..... You have a PIVOT for a data set of the range A1: H25, will changing the value in cell B:32 change the projections in the PIVOT?

@user-fe9hu2zj1z 7 месяцев назад

Amazing!!!

@watcher211 2 года назад

Thanks!

@techteachersandstudents 2 года назад

Thank YOU so much for saying "Thanks!."

@hassanalianees5530 2 года назад

brilliant. Thanks a lot. Love and respect.

@srinagarmagazine9250 2 года назад

Bhai... Can u please help me with this question..... You have a PIVOT for a data set of the range A1: H25, will changing the value in cell B:32 change the projections in the PIVOT?

@hassanalianees5530 2 года назад

@@srinagarmagazine9250 yes it will be changed dynamically and if not then you may go to the Data Tab on excel and click on Refresh All. Then changes will be applied

@srinagarmagazine9250 2 года назад

So, the answer is yes, right?

@hassanalianees5530 2 года назад

@@srinagarmagazine9250 yes

@srinagarmagazine9250 2 года назад

@@hassanalianees5530 thanks a lot brother!

@mahkal1357 Год назад

excellent

@uncutsceneonline4596 День назад

Excel useful for (update existing previous year financial model)

@damongt4 2 года назад

Hi, would it matter if you used months?

@FromGambit 3 года назад

The house price known data was in $ round hundreds, so you might wrap the FORECAST in =ROUND([your expression],-2). The savings account was opened with a nominal amount of $10 then did nothing for two years, so your forecast might exclude the first data line. Thanks for the intro to FORECAST functions, I've not used them before.

@srinagarmagazine9250 2 года назад

Can u please help me with this question..... You have a PIVOT for a data set of the range A1: H25, will changing the value in cell B:32 change the projections in the PIVOT?

@HabiburRahman-xs9gb 2 года назад

Why is this video hard to find? the best video on this topic..there are shi*t tone of other videos getting a lot of views !

@gjyminiaviary1782 2 месяца назад

I use it to get a horizon

@suleimanshaik 3 года назад

thanks :-)

@brocklesnar4336 2 года назад

Awesome

@arnaudchekap8483 2 года назад

How can you do that with the month?

@solidworksandexcel9257 3 года назад

great

@elizabethpena653 Год назад

how do you know the percentage increase on your home value?

@chetanymca 2 года назад

Good stuff! One question, this function forecasts for an increasing value trend. What if there are dips in between and some seasonality, which function should we use then?

@srinagarmagazine9250 2 года назад

Can u please help me with this question..... You have a PIVOT for a data set of the range A1: H25, will changing the value in cell B:32 change the projections in the PIVOT?

@misbahuddinathar4982 Год назад

@@srinagarmagazine9250 nope

@lugia8888 Год назад

@@misbahuddinathar4982 yes

@abhishekkaushal6564 9 месяцев назад

@@srinagarmagazine9250yes, it will change ...but you have to refresh the Excel sheet.

@willrose5424 Год назад

Does it work for the lotto?

@Kirito-mt7bj Год назад

How do we get the forecast chart after getting forecast/linear forecast cuz it says forecasting can't be created without two or more valid time/value data points

@haifajo 2 года назад

what if the value for B13 is not known yet! i used =forecast(F1, $B$2:$E$2, $B$1:$E$1) and it gave me the answer but that was only for including data for Oct and Jan while i couldnt include data for Nov and Dec..

@XxwastralxX 2 месяца назад

nice

@fachri5092 2 года назад

thankyouuuuu

@prashantk.a.6849 6 месяцев назад

Is it mandatory that x value is numerical

@matthewws5694 3 года назад

Is the forecast method using linear regression /curve fitting?

@neerajjainification 2 года назад

Linear

@GilThunder99 6 месяцев назад

what if ur asked to forecast for the next 20 data points?

@user-dm4ct4qc9b 8 месяцев назад

😊😊

@aglow9267 Год назад

Does this work on excel for mac

@MankiratSingh Год назад

Is it possible to forecast a month based on days (for example, if we spend $1,000 in 10 days, how much money can we expect to spend at the end of the month)?

@willrose5424 Год назад

If you add natural disasters, traffic accidents, or unemployment then yes

@TheJaninev 9 месяцев назад

How do I do it in months?

@prashantk.a.6849 6 месяцев назад

Kin Excel 2019, this function does give error

@pr3ttyb0yfl4cko Год назад

Why does mine shows "N/A"? I have 3 years for known x and 3 values for known y, it can't forecast the 4th value for year 4 and shows "N/A" instead. Please help.

@Dexter101x 3 года назад

House value in London, UK doesn't follow the said forecast function, a lot of people are exaggerating their prices 😂

@richardlim6436 10 месяцев назад

🙏🏻👍🏻

@igorzerebni132 2 года назад

Is there any way i can use months(text) instead of year or date(number)?

@srinagarmagazine9250 2 года назад

Can u please help me with this question..... You have a PIVOT for a data set of the range A1: H25, will changing the value in cell B:32 change the projections in the PIVOT?

@reb2229 2 года назад

You might be able to change the months (if you have them as dates (based on format like 01/01/2022, 01/02/2022)) to "General" (in the Home->Number section) and that will give you a placeholder number almost. This worked for me as I was dealing with daily dates (and predictions based on that)

@PritamPaul717 3 месяца назад

❤🙂👍

@JASMINEDAYON-sl3ri Месяц назад

sorry im confused what function you used when you put the values. you skipped that part

@LeonardoValente_ 2 года назад

What if you want to know which year you will have 160K $ ?

@alectobi144 2 года назад

you have to use the future value function: just google future value calculator in google (dozens of different websites)

@1999gtp 3 года назад

I like the function, but the forecast seems a bit off. $100K in the first 20 years, and only $40K growth in the last 15 years... I wouldn't sell my home.. :)

@norpriest521 3 года назад

Which is the best forecast function in excel?

@marksummers463 2 года назад

Actually, Big Tech DOES know your saving habits.

@thomasdietz2211 Месяц назад

its not a "," but a ";"

@Eden-kc5nv 6 месяцев назад

DOESNT WORK

@alihaiderilyas2244 Год назад

dis viedo not wokr at all, i vant you reconsider your life

@fredrikkjeldsen5426 Год назад

your video was bad

@george_anak_lihi Год назад

❤🎉😊

@mrCetus 2 года назад

Thank you so much for the quick help!

@srinagarmagazine9250 2 года назад

Can u please help me with this question..... You have a PIVOT for a data set of the range A1: H25, will changing the value in cell B:32 change the projections in the PIVOT?