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

Part I of the KPI Dashboard video (watch this 1st):

My Merch:

My Best-Selling Products:

Get My “Controller KPI Dashboard” (Excel + Course) with the most important P&L and Balance Sheet KPIs:

Get My “Night Before the Accounting Interview Guide” including All Levels Q&A:

📈 Get $25 off MY ONLINE COURSE ON FINANCIAL METRICS (code: Save25)

------------------------------------------------------------------

---------------------------------------------------------------------
Hang Out with me on social media:

DISCLAIMER: Links included in this description might be affiliate links. If you happen to purchase a product or service with the links that I provide I may receive a small commission. There is no additional charge to you! Thank you for supporting my channel so I can continue to provide you with free content each week!
All views expressed on my channel are mine alone. Not intended as financial or professional advice

[CAAnmoldeepsingh]

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

[kekelwa]

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

[mageshjohn]

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 👏

[barajas]

Can you do videos about cost accounting, and inventory

[Soulenergy]

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

[daniokendo]

I use sumif and sumifs instead index formula

[luvuyosomdaka]

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

[omaralmaawali]

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

[kaibaing]

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 🙏

[JN-wdxw]

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

[OnePercentPerfectionist]

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

[jonathansantiagojr.]

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

[minma]

Jesus. This is amazing content and information.

[NotBen]

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

[ShivaPrasadrao]

cant we use vlookup instead of index match ?

[josephnkadi]

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

[larahporter]

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

[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?

[TheKone]

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

[jcv]

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