Year to Date (YTD) Analysis in
HTML-код
- Опубликовано: 11 сен 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.
Extraordinarily concise.
many thanks!
using Excel 365 insider:
=LET(
unpiv, LAMBDA(arr,
LET(
_col, COLUMNS(arr)-1,
_fil, ROWS(arr)-1,
_reg, SEQUENCE(_fil*_col),
arrFils, INDEX(DROP(CHOOSECOLS(arr,1),1),ROUNDUP(_reg/_col,0)),
arrCols, INDEX(DROP(CHOOSEROWS(arr,1),,1),MOD(_reg-1,_col)+1),
arrDatos, TOCOL(DROP(DROP(arr,1),,1)),
arrkey, HSTACK(SEQUENCE(ROWS(CHOOSECOLS(arr,1))),CHOOSECOLS(arr,1)),
arrMesesKey, HSTACK(SEQUENCE(12),{"Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec"}),
res, HSTACK(arrFils,arrCols,arrDatos),
x, HSTACK(XLOOKUP(CHOOSECOLS(res,1),CHOOSECOLS(arrkey,2),CHOOSECOLS(arrkey,1)),
CHOOSECOLS(res,1),
XLOOKUP(CHOOSECOLS(res,2),CHOOSECOLS(arrMesesKey,2), CHOOSECOLS(arrMesesKey,1)),
CHOOSECOLS(res,2,3)
),
x)
),
mth, 5,
y_a, unpiv('2021'!A3:M16),
y_b, unpiv('2020'!A3:M16),
grp_a, GROUPBY(CHOOSECOLS(y_a,1,2),CHOOSECOLS(y_a,5),SUM,0,0,,CHOOSECOLS(y_a,3)
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.
Thank You! Very much needed video content 👍👌
I'm glad you found it useful. Thanks Vankatesh!
Excellent video. Very well explained and broken-down. Thank you :)
Thanks for your kind feedback Farid!
Thanks for sharing. It is very helpful
I'm glad you found it helpful. Thanks Chandni!
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.