OFFSET function in Excel

[@TheFinanceStoryteller]

Enjoyed this video? Then subscribe to the channel, and check out more "Excel how to" tips and tricks in this playlist: kzbin.info/www/bejne/rp_Vgnikac92qaM

[@nabeelal-shammari1441]

You are sir an absolute legend, keep up the good work.

[@TheFinanceStoryteller]

Thank you, Nabeel! Please spread the word. 😎

[@RetireCertain]

This is a great channel. Thank you.

[@TheFinanceStoryteller]

Glad you enjoy it! Thank you for watching and commenting.

[@konstancyja82]

Fascinating and so well explained!!

[@FRANKWHITE1996]

thanks for sharing

[@TheFinanceStoryteller]

Thanks for watching!

[@seuchyea]

Hello, can you help me with my business studies case study? I don’t really know how to do it (the topic is costs, scale of production and break even analysis)

[@TheFinanceStoryteller]

Sorry, that's not something I can help with. I do have a video on break even analysis though kzbin.info/www/bejne/qGmleq1rfpKUesU

[@seuchyea]

@@TheFinanceStoryteller alright then

[@jamiuadeniran2159]

Please how did you create this, was it through validation?

[@TheFinanceStoryteller]

Hi! The drop down box to select the year is made through data validation - list. It's in the Data tab of Excel. The chart on the left refers to =SERIES(;'YT views reporting'!$K$21:$K$32;'YT views reporting'!$L$21:$L$32;1) and the chart on the right =SERIES(;'YT views reporting'!$M$21:$M$24;'YT views reporting'!$N$21:$N$24;1) The data that is shown in those cells changes if a different reporting year is selected. The OFFSET function takes care of that.

[@jamiuadeniran2159]

@@TheFinanceStoryteller ohh thanks but can you please do a separate video showing how you came up with it from the scratch.

[@TheFinanceStoryteller]

Here's the link to my video specifically on the topic of drop down boxes: kzbin.info/www/bejne/aX_Vq4lsbphgf68

[@jamiuadeniran2159]

Alright then, thank you

[@dennismoe7071]

You sound a lot like the Eastory history channel.

[@TheFinanceStoryteller]

Hi Dennis! Is that a good or a bad thing? 🤓

[@dennismoe7071]

@@TheFinanceStoryteller Good thing! I just thought you might've had different channels for different topics, but probably not 😅

[@TheFinanceStoryteller]

Thanks for the tip, Dennis! I just watched a few videos of the Eastory channel, and really enjoyed them. The closest I ever got to making a video on history myself was the one called "history of accounting": kzbin.info/www/bejne/fnKvYaZ4mZ6ir8k