Year to Date (YTD) Analysis in
Вставка
- Опубліковано 26 сер 2024
- In this video, you will learn the meaning of YTD analysis and the period it covers, the difference between YTD and YoY and how to sum a dynamic range with Index/Match and Xlookup.
Please check out other videos on my channel and don't forget to comment, like, share, subscribe and click the bell icon so you'll get a notification when the next video is uploaded. Thanks!
Content
00:03 Intro
00:26 Meaning of YTD analysis
00:54 The period YTD covers
01:43 Difference between YTD and YoY
02:36 Presentation of YTD analysis
03:19 Basic sum of range
04:19 Sum a dynamic range with Index/Match
06:51 Sum a dynamic range with Xlookup
08:20 Conclusion
Connect with me on:
👉Instagram and Facebook @youexceltutorials
👉Twitter @youexceltutor
👉LinkedIn @bunmisanusi
🎬Check these videos:
XLOOKUP || INDEX/MATCH • Multiple Criteria: XLO...
Year-Over-Year (YoY) analysis • Year-Over-Year (YoY) a...
EBITDA Bridge || Waterfall Chart • What is EBITDA? || EBI...
🔽Download the file here docs.google.co...
📢“As the mountains surround Jerusalem, so the LORD surrounds his people both now and forevermore.” Psalm 125:2 (NIV)
#msexcel #youexceltutorials
You explained it very good. Thanks so much.
Thank You! Very much needed video content 👍👌
I'm glad you found it useful. Thanks Vankatesh!
Thanks for sharing this. Very much needed as we are heading towards the end of year financials🙌🏼🙌🏼🙌🏼
Thanks for watching sis! Glad you found it useful.
Thanks for sharing. It is very helpful
I'm glad you found it helpful. Thanks Chandni!
Excellent video. Very well explained and broken-down. Thank you :)
Thanks for your kind feedback Farid!
Great explanation very clear.
best
very helpful. where do i find the file?
docs.google.com/spreadsheets/u/3/d/10F3_z2oAecasIho1RJGdT-mdG5LeoCqQ/htmlview
nice job, sir. where is dwnload the file here ?
Thanks Ubaidillah. The link has been added.