Thanks for your content! It’s a surprise to me every video doesn’t have millions of views! Your free content alone is enough to help some drastically increase their skillset & income!
boss. You are true ninja of excel... learning lot from you... can you make more videos on nice charts to impress boss.. current charts in excel are really boring to visualize ....
Awesome video! I’m excited to try this out. I’d be interested in learning how these Excel forecasting methods could be applied to a forecast involving thousands of products
If I were you. I would make an ABC analysis on the products, and differentiate the forecasts depending on their grade. "A" products which are extremely important for the revenue should have more safety stock, larger thresholds etc. 🙂 An additional XYZ analysis could also prove beneficial for the above as insight into demand variability is important.
@ that’s a good point that I left out for simplicity. I’m going beyond the ABC/XYZ analysis right now to implement my forecast. Many of my products have higher value, reasonably high volume but significantly less volume than items that are simply high volume. I use a loose example of a hammer and then nails just for demonstration. This forecast build is done in Python. But I have requests for an Excel-based forecast since that’s friendly to most end users to understand and adjust as they see fit.
Did so many of these in college😂 really useful in many areas. We used in forestry to estimate forests (native or planted) volumes in wood. Because just imagine having to measure an entire forest, tree by tree. We just did a few randomly positioned 50x100m rectangles, than measure tree by tree only inside of them. Then took the data to estimate, confidence intervals was 95%, but in pharmacy and medicine it goes way up high to 98 or 99%.
Thank you for the video! Just one question, can you tell me how the growth rates are calculated for the outbound years (in this case, 2025 and 2026)? Does Excel use the 2021 to 2024 trends per quarter to calculate their respective growth rates?
Thank you for your videos mate.. . Crypto education is what the world needs the most right now. I don’t think that buy and hold is a valid investment strategy anymore. Not too diluted and to a degree, follows Sophia’s trading ideas and signal tips for your portfolio growth and aggressiveness. She is a woman who has not only taught me what the cryptocurrency trading world looks like but a secret to uplift my finance. Buying crypto and waiting for the price to shoot up is not the best way to invest in the market but buying and trading is. Sophia Haney’s trade signaIs does the heavy lifting, generating competitive returns for crypto traders and investors in the form of money and peace of mind. Time in the market vs. timing the market. If you keep that mentality as an investor, you will stay calm during the storm! Within some months I was making a lot more money and have continued on that same path...
Can't share much here, I take guidance from ‘Sophia E Haney’ a renowned figure in her industry with over two decades of work experience. I'd suggest you research her further on the web.
I agree that there are strategies that could be put in place for solid gains regardless of economy or market condition, but such executions are usually carried out by investment experts or advisors with experience…
i wonder why those topics are not included in the courses you charge so much for, yet you teach them for free on youtube. nothing about forecasting or even regression analysis on your excel courses. why charge so much for them then? i honestly feel very cheated for buying your courses. I can just learn it for free on youtube.
🔥 Take our Finance & Valuation Course: www.careerprinciples.com/courses/finance-valuation-course
When I see pop up from Kenji I’m excited because I know I’m learning something new this week.
Thank you so much for the kind comment :)
Facts!
Thanks for your content! It’s a surprise to me every video doesn’t have millions of views! Your free content alone is enough to help some drastically increase their skillset & income!
Really well explained and demonstrated. This was a confusing formula for me before i saw this. Thank you Ken
Thank you! Gonna watch this later, I was just trying to learn about forecasting revenues in excel
Great video! Truly helpful! Concise and clear explanation!Thank you
Concise, well explained and very informative. Very many thanks, Kenji. Best regards. Ken
I always learn something watching your videos. Thank you very much, Kenji!!
Really helpful. All your videos are informative and well explained. Thank you !
Great video! I learn a lot from you
Great video again, Kenji!
Thank you!
Really helpful!! Thanks
Thank you nice presentation.
boss. You are true ninja of excel... learning lot from you... can you make more videos on nice charts to impress boss.. current charts in excel are really boring to visualize ....
Thank you Kenji
Thanks for watching :)
Really great video, thanks!
You’re welcome!
Awesome video! I’m excited to try this out. I’d be interested in learning how these Excel forecasting methods could be applied to a forecast involving thousands of products
If I were you. I would make an ABC analysis on the products, and differentiate the forecasts depending on their grade.
"A" products which are extremely important for the revenue should have more safety stock, larger thresholds etc. 🙂
An additional XYZ analysis could also prove beneficial for the above as insight into demand variability is important.
@ that’s a good point that I left out for simplicity. I’m going beyond the ABC/XYZ analysis right now to implement my forecast. Many of my products have higher value, reasonably high volume but significantly less volume than items that are simply high volume. I use a loose example of a hammer and then nails just for demonstration.
This forecast build is done in Python. But I have requests for an Excel-based forecast since that’s friendly to most end users to understand and adjust as they see fit.
Best as always ❤
Thank you so much 😀
Great video.
Great …. thank you Kenji
Bravo 👏
Thanks man ,really helpful
Glad to hear that!
Thank you
Thanks
Cool!
Thank you for the step by step lessons....according to Google, MAC doesn't have the Forecast Sheet, any suggestions?
thanks! can you do video on regression in excel?
Noted! thank you
Did so many of these in college😂 really useful in many areas. We used in forestry to estimate forests (native or planted) volumes in wood. Because just imagine having to measure an entire forest, tree by tree. We just did a few randomly positioned 50x100m rectangles, than measure tree by tree only inside of them. Then took the data to estimate, confidence intervals was 95%, but in pharmacy and medicine it goes way up high to 98 or 99%.
@@KenjiExplainswill be nice to review this, please bring simple and multiple examples!!! Thank you ❤
does this work for forecasting different line item in a financial statement?
My wife is trying to become an Analyst, I'm Building a nice PC for her, just need the Office, any ideas?
it's a great career path, can be interesting and rewarding, also my cousin found Office in BNH Software..
Congrats to your wife, nice choice, for Office I agree with Mark, any would do..
Can you elaborate if i want to forecast with another factors such as macroeconomic and industry factor
Thank you for the video! Just one question, can you tell me how the growth rates are calculated for the outbound years (in this case, 2025 and 2026)? Does Excel use the 2021 to 2024 trends per quarter to calculate their respective growth rates?
hi could you please do a bookkeeping system on excel
How does this method to compare to using ARIMA to machine learning regression with Python?
Hi Kenji, i work with Excel 365 Mac and cannot find the forecast sheet, where do i find it?
Hey just checked on a Mac as well and can't seem to find it. It could be that it's not a feature in Excel for Mac unfortunately
Could be worth trying the web version as that sometimes has features Excel for Mac doesn't
Wow forecast sheet
Change business to enterprise?
What If The Data Mentioned Only month not In A Date Value
Add a column with date value y taking the last date of the month.
Hi
Hey!
i think sumif does the same trick
A forecast is a forecast.
It never comes out.
Forecast sheet unavailable in Mac. Just another example of Microsoft being microsoft
Thank you for your videos mate.. . Crypto education is what the world needs the most right now. I don’t think that buy and hold is a valid investment strategy anymore. Not too diluted and to a degree, follows Sophia’s trading ideas and signal tips for your portfolio growth and aggressiveness. She is a woman who has not only taught me what the cryptocurrency trading world looks like but a secret to uplift my finance. Buying crypto and waiting for the price to shoot up is not the best way to invest in the market but buying and trading is. Sophia Haney’s trade signaIs does the heavy lifting, generating competitive returns for crypto traders and investors in the form of money and peace of mind. Time in the market vs. timing the market. If you keep that mentality as an investor, you will stay calm during the storm! Within some months I was making a lot more money and have continued on that same path...
Can't share much here, I take guidance from ‘Sophia E Haney’ a renowned figure in her industry with over two decades of work experience. I'd suggest you research her further on the web.
Use her name to quickly conduct an internet search.
SHE’S MOSTLY ON TELEGRAMS APPS WITH HER NAME.
Sophiahaney she’s verified
I agree that there are strategies that could be put in place for solid gains regardless of economy or market condition, but such executions are usually carried out by investment experts or advisors with experience…
i wonder why those topics are not included in the courses you charge so much for, yet you teach them for free on youtube. nothing about forecasting or even regression analysis on your excel courses. why charge so much for them then? i honestly feel very cheated for buying your courses. I can just learn it for free on youtube.
Thank you Kenji
Thanks for watching!