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.
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
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?
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?
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?
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?
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?
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?
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
Nice tutorial, but...extrapolating beyond the range of x-values to get a corresponding y-value is "bad statistics." The x-values used should either be an intermediate year or one close to the x-values.
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..
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.
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?
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.
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?
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)
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?
@@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
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)?
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.. :)
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?
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?
![[Live] : ONE 169 วันนี้!! "อนาโตลี vs อูมาร์"](http://i.ytimg.com/vi/IK3YZVWuFJg/mqdefault.jpg)
![[LIVE] : ONE ลุมพินี 86 | คู่เอก "คมเพชร vs ชาติพยัคฆ์"](http://i.ytimg.com/vi/m3q_dRYDuU8/mqdefault.jpg)
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.
The best video of this function. I spent almost 4 hours to read boring articles. Thank you!
The simplest yet the best excel tutorial ever! Kudos!
Here’s me mucking around up with compound interest rates when forecast is a lot more straight forward 👍
Ur nan is straight forward
@@clydesweetfeetlivingston1180 💀😭😭
Thank you for sharing a simple example
Thank you for this helpful video! I'm doing a report for work right now
Thank you! Explained in a very simple way!
Very important concept, very simple, and explained well. Thank you very much.
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
Thank you much it helped me to complete my project❤
Thank you, learning so much
Thank you so much, Straight to the point. Love it!
Thank you! This was a big help for my assignment for school!
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?
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?
Nice when things are simple!
Hi nice informative video , what if we have quarters in each year , and i want to see forecasted values for 2035 Q1 ?
Great, thanx bro... I use for stock and derivative market forecasting
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?
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 nope
@@misbahuddinathar4982 yes
@@srinagarmagazine9250yes, it will change ...but you have to refresh the Excel sheet.
BIG HELP,, to refresh this subject thank you
Very helpful 👌
Thank you!
Great effort and kudos to you for the great work.
thank you so much.. your video is really helpful
Great one. It's really helpful and well organised.
Thank you for sharing 😊😊
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?
Very simple and clear. Thank you for the help
Learning is fun w this video
Great, was notified this was posted!
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 !
thanks 4 the rescue
Thank you !!!!!
Thank you very much
Hi, would it matter if you used months?
Simple, perfect and very useful explanation. Thank you.
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?
Amazing function💜
Thank you sir
Amazing!!!
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
Excel useful for (update existing previous year financial model)
Does it work for the lotto?
Thank you so much for the quick help!
Is it mandatory that x value is numerical
thanks for you support sir , really u saved me
How can you do that with the month?
what if ur asked to forecast for the next 20 data points?
how do you know the percentage increase on your home value?
Thanks
Good Learning to me ..thanks
Great Sir.
Nice tutorial, but...extrapolating beyond the range of x-values to get a corresponding y-value is "bad statistics." The x-values used should either be an intermediate year or one close to the x-values.
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..
Does this work on excel for mac
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.
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?
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.
Thanks!
Thank YOU so much for saying "Thanks!."
Very nice!
VERY HELPFUL
Thank you sir so much
thank you
Is there any way i can use months(text) instead of year or date(number)?
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?
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)
Helpful ty👏🏼👏🏼👏🏼
excellent
Is the forecast method using linear regression /curve fitting?
Linear
How do I do it in months?
brilliant. Thanks a lot. Love and respect.
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?
@@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
So, the answer is yes, right?
@@srinagarmagazine9250 yes
@@hassanalianees5530 thanks a lot brother!
sorry im confused what function you used when you put the values. you skipped that part
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)?
If you add natural disasters, traffic accidents, or unemployment then yes
Kin Excel 2019, this function does give error
Thank QQQ Sir,
I use it to get a horizon
nice
thankyouuuuu
Awesome
thanks :-)
House value in London, UK doesn't follow the said forecast function, a lot of people are exaggerating their prices 😂
💗
great
What if you want to know which year you will have 160K $ ?
you have to use the future value function: just google future value calculator in google (dozens of different websites)
😊😊
🙏🏻👍🏻
❤🙂👍
Actually, Big Tech DOES know your saving habits.
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.. :)
Which is the best forecast function in excel?
its not a "," but a ";"
DOESNT WORK
dis viedo not wokr at all, i vant you reconsider your life
your video was bad
Thank you so much for the quick help!
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?
Thank you
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?