Year to Date (YTD) Analysis in
Автор: YouExcel Tutorials
Загружено: 2021-09-10
Просмотров: 12577
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: XLOOKUP || INDEX/MATCH ...
Year-Over-Year (YoY) analysis • Year-Over-Year (YoY) analysis in Excel || ...
EBITDA Bridge || Waterfall Chart • What is EBITDA? || EBITDA Bridge || Waterf...
🔽Download the file here https://docs.google.com/spreadsheets/...
📢“As the mountains surround Jerusalem, so the LORD surrounds his people both now and forevermore.” Psalm 125:2 (NIV)
#msexcel #youexceltutorials
Доступные форматы для скачивания:
Скачать видео mp4
-
Информация по загрузке:
