From Financial Statements to KPI Dashboard [Part 2 to Controller KPI Dashboard]

[@CAAnmoldeepsingh]

I feel so lucky to have found this channel. Thanks for sharing your knowledge and experience. 💚

[@investorccc9532]

Thank you so much

[@jcv71]

Very good content but do you have to keep your head in that small box? No offense, but it's distracting.

[@TheFinancialController]

Fair enough:)

[@barajas3309]

Can you do videos about cost accounting, and inventory

[@daniokendo]

I use sumif and sumifs instead index formula

[@OnePercentPerfectionist]

How did you get previous month with index and match? Hmmm

[@medhagupta8417]

This is amazing! Thankyou!

[@omaralmaawali2635]

Do you have example KPIs for the activities? Example payroll posting KPI? Example Bank recansolarion kpi? Billing kpi? …etc

[@DreamFirms]

Thanks for another great content!

[@kekelwa6934]

Just stumbled upon you a few mins ago and amongst the vids I’ve watched so far this is a tenner 🙌🏾🙌🏾🙌🏾 You made those formulas look so easy, I’ve learnt tons in this video 🙏🏾 Thank you so much

[@MyDanikaka]

Nice Content !!! Would you can try to upload some viedos on Blacklines Stanbox ERP System or similar softwares #tcw786 #bt

[@PatrickOtienoOboge]

how can i get this file?

[@kaibaing4288]

Sir can you make a video on fictitious assets Preliminary exp,etc And why they are w/off against Equity holders during amalgamation. Would be great if you cover amalgamation accounting in a nutshell 🙏

[@Soulenergy31]

Left accounting more than 15 years, your videos are inspirational and motivational to go back!! But employers ask for experience;(

[@mahmoudalshami1557]

How to get this KPI?

[@larahporter8123]

Can someone explain to me why using an ndxmtch funtion instead of a VLOOKUP?

[@TheFinancialController]

See my recent video on why index match is better

[@larahporter8123]

@@TheFinancialController Thank you. I also discovered an ‘xlookup’ that can be used for the same purpose. Interesting.

[@JN-wd2xw]

Can you please do a video or series of them to show us shortcuts to work with large data sets? For instance, you have 100's of rows and columns and you want to apply formatting, what kind of shortcuts do you use to select the data all the way down to the end of the data set both at the bottom and to the right. Also, what shortcuts do you use to go up and down. I had to learn most of this through trial and error but it still doesnt come easy till someone shows it to you

[@ShivaPrasadrao1]

cant we use vlookup instead of index match ?

[@TheFinancialController]

Yes but I recommend index match for overall better experience and less errors

[@jonathansantiagojr.3742]

Hi Sir. Whats the formula of vs. prior months? Thank you

[@Darvin-Breen]

Please sir have a question. I'm currently registered under the department of economics and business in a university in Italy fir my bachelor's degree in business administration. Now I hear people say it is better to major in accounting , does this mean there is actually something called a bachelor's degree in accounting which is completely different from a bachelor's degree in business administration?

[@sebastianaguero485]

Well yes, I'm just finishing my Bba. If you already know you want to get into accounting and finance, go after that degree

[@minma02262]

Jesus. This is amazing content and information.

[@mageshjohn8553]

I regularly watching your videos it is very useful for me. Am working as subject matter expert in private company who handling all hospitality accounting.. your videos helping improve my accounting knowledge and excel... Thanks for your efforts and sharing your knowledge.. Good work sir 👏

[@TheFinancialController]

Thanks 🙏

[@pratapreddygummana]

Thank you very much sir

[@bachmytran6246]

Thank you so much

[@TheFinancialController]

You're most welcome

[@christiancoronado]

Can you do a video about integration?

[@luvuyosomdaka2603]

This is exactly what I needed. Thank you so much you are amazing!!!

[@TheFinancialController]

Glad it helped!

[@josephnkadi8874]

Can vlookup also be used instead of index? I really appreciate your video. I've never seen index or match been used on excel

[@NotBen101]

It can, but you need to specify the column number each time you use it making the function harder to automate.

[@raedbamoudah2512]

You are a master!

[@thoaivo5261]

Thanks a lot

[@justinbreexyy6426]

Nice!

[@TheKone51]

What's the formula for the prior month's value?

[@TheFinancialController]

It’s and Index/match but the month lookup has a “EOMONTH(x, -1). The “-1” makes it look at month prior

[@danielplatformsellerteam3071]

@@TheFinancialController Excellent Videos, could you paste a copy of the full formula for the prior months value? thanks

[@jeycee6807]

First ❤️😍

[@samueladewale1153]

Second

[@NotBen101]

Have you ever tried using the XBRL api? Would like to see creating something like this with python.

[@mahmoudalshami1557]

More details plz

[@jameszalez3410]

great video