Build a BEAUTIFUL KPI dashboard

[@urszulalipka-zawadzka3262]

Amazing idea. I've just done my first financial dashboard in Excel with your video. And I discoverd a lot of keyboard shortcuts (in my country Excel has some tiny differences, of course). Really thanks for your content 👏

[@yourcfoguy]

Love hearing that! Thanks for taking the time to write this out

[@bevhales6951]

You’re a brilliant teacher - thanks for being thorough and concise. I’m off to create my own version thanks to you. Definitely got a new subscriber here!

[@yourcfoguy]

Welcome!

[@simonspeed86]

That's great! An additional suggestion if doesn't work having the triangle up and down in the cell format: you are probably typing the 3 buttons at the same time. Instead, it will work by simply typing: alt+30 for up and alt+31 for down.

[@yourcfoguy]

Good call! Thanks for sharing

[@nosensecomedy]

Great love this, just helped me upgrade the look of my Dashboard!

[@yourcfoguy]

Nicely done!

[@monicabozzi82]

This looked so amazing!! I am definitely going to incorporate at the new job I just started 💕

[@yourcfoguy]

Glad you enjoyed this! Good luck on the new job

[@loneranger7535]

how neat this looks- loved it

[@yourcfoguy]

Glad you enjoyed it!

[@KrishnaKumar-zn9kg]

Good presentation.

[@henryksoto5464]

Genius!!! 🎉 God bless you 🙏🏼

[@yourcfoguy]

Thanks for watching!

[@racheallola8058]

This is awesome josh, thanks

[@yourcfoguy]

Glad you liked it!

[@hley1510]

Impressive.

[@ssbpl94]

Amazing👍

[@yourcfoguy]

Thanks for watching!

[@waterflow24]

Favourite part has to be using the formulas xlookups, iferror and the data validation list format. As an accountant, financier I reckon this is very important still 😃

[@yourcfoguy]

Nice! That's great feedback...thanks for sharing :)

[@kennganga537]

Kindly build a Management Accounts report. P&L, balance sheet and most important, management kpis

[@yourcfoguy]

Thanks for the feedback, will give that some thought!

[@tanzaaa]

Thanks Josh for this beautiful KPI dashboard ! I was populating mine until I hit a snag , for some reason the Xlookup is not reading from the other tab . Do you know what could be the reason for that ?

[@yourcfoguy]

Weird! What error message are you receiving?

[@tanzaaa]

@@yourcfoguy At first , there was one related to X lookup formula which I didn't find in the Fx lists because I was using an older version of Excel. I ended up using the Excel for Web version , however , when using the X Lookup , It didn't read from the Financial tab. Do you know what could be the reason for this?

[@yourcfoguy]

The formula for Xlookup is referencing the financials table. Did you convert the range to a table by typing CTRL T? If not, u can just point to the range rather than using a table. Does that solve things?

[@tanzaaa]

@@yourcfoguy I am pretty sure something is off on my end ! I tried various scenarios but still not working :(