Build the ULTIMATE Excel Dashboard from Scratch

[@KenjiExplains]

📊 Get 25% OFF Financial Edge courses using code KENJI25: bit.ly/3weTzPo

[@solomonbhandari-young4154]

YES

[@belfama852]

sir, may I request a tutorial video of personal income dashboard that can be interactive?

[@pragyanvaishnav1834]

I am enjoying the journey with you 🥰🥰 But the excel file isn't downloading do you have another way to download it

[@Jonathan_iykee]

Please how do I get the data set

[@parshuramnangare8577]

Dear Kenji, I just can't stop thanking you for the value you have added in my life through your amazing excel knowledge. God bless you and thank you so much once again. love from India.

[@dynamics9000]

"Formal education will make you a living; self-education will make you a fortune." - Jim Rohn, This quote helped me to grow and hope it helps you too, a fellow creator,,,,

[@bthfjyvjiuyh]

❤ love it

[@ey5644]

Thank you so much for taking the time and showing how to do this! Thanks!

[@KenjiExplains]

Thank you for supporting! 😁

[@ChasingMyLiberty]

I know you’re the Obi-Wan Kenobi of explaining everything finance but I wanted to say I am proud of your progress and quick growth. Been following for a time long before 100k. Keep up the good work.

[@muhammaduseram9405]

after watching tons of tutorial on dashboard, this was the most professional and cool looking. Thanks

[@emmanuelochulor3928]

I duff my heart for you. You are VERRRYYYYYY GOOD!

[@angelitojrgolimlim1841]

Man this is very useful, I cant thank you enough for every knowledge I obtained by listening to your lessons.

[@felipecardenas1233]

I have been watching many of your videos and you are very clear at explaining. I am really thankful for your content

[@dawnfelton8596]

This video was great! You got straight to the point! I love what I am able to do. I start a new data job next week and can't wait to demonstrate these new skills.

[@KenjiExplains]

Awesome to hear best of luck!

[@romelciptoadi4200]

Wew, congratulation for your new position. May I ask how we can land a data job? I am struggling to get one, my main field is in healthcare since I am also a Physician, thank you

[@dawnfelton8596]

@@romelciptoadi4200 I started by getting a Google Data Analytics Professional Certificate. After completing the course through Coursera, it took me a little under 5 months to get a data job.

[@dorisenyingone550]

@@dawnfelton8596 Same for me .. took me 4months after getting the Google data Analytics certificate to get a data analyst position

[@abdulsaidmkamara7305]

That Report Connections is a Powerful Tool That i am going to implement at work.

[@Adeyeye_seyison]

Your videos are ALWAYS top notch... thanks a million sir for adding values to our lives

[@mohamedabdo-xg6tw]

WOW I just built a dashboard for my work using excel following this Tutorial. I am a python Fan but not having to deal with environment settings and deployment issues this approach is amazing. thank you for sharing the Knowledge.

[@beriliandokusnadianto2205]

Thanks Kenji for the sharing! Very insightful and impactful. May God bless your career. From Indonesia. Wait for another video...

[@jamesarchieodena4107]

Thank you so much kenji ... You are not just handsome but so helpful in making our lives better and easy... You are so cute... 💗💗💗😍😍😍

[@hunterburns]

Awesome boss! That's something I've been expecting from you and now you have finally done it. Take love 💖

[@KenjiExplains]

Hope you enjoyed it!

[@victorbegnini5754]

Awesome, Kenji! A good way to recap some concepts, expand knowledge and showcase our XP. All thanks to you and your efforts. Thanks a million!

[@oluwasogoabbey4269]

Please were you able to use the data

[@victorbegnini5754]

@@oluwasogoabbey4269 at first I wasn’t. But I downloaded the dataset from Kaggle , worked my way out, and followed along with the video 🙂

[@qasimkazmi5913]

this was the first video I have watched of yours, full of value. Appreciated

[@josab8966]

You make it look so easy. Whew. Thanks for this Kenji

[@The-Hungry-Glut]

This is something useful I can see many uses of it in the daily reports I create, this can up the notch a lot more than regular pivot data copied and pasted on emails Thanks Kenji 👍

[@KenjiExplains]

Glad it was helpful!

[@letslearnwithpc6064]

What a lovely session, brother. Beautiful. Pls do one HR dashboard .

[@ragragrec1]

production value 100%. Loved this!!

[@olukimkan3837]

I like the simplicity of your style very interesting, No unnecessary force or pressure.

[@GidongLinog]

You r the best dashboard Sifu on the planet .. thank you

[@nasirhalimah7021]

Your are indeed a life saver. Job well done bro

[@gmoneyfunk6974]

I really appreciate your video and that you give us an example to work on while we are viewing the video. My example came out pretty good thanks to your instructions. My only critique is to add how to customize the slicers, since you went past that part. I was trying to make one to match yours and it left me with the question on how I can make one.

[@aderojuabolaji9721]

I have always wondered how dope professional dashboards are built in excel. After watching this video, I stopped wondering 😎. Thank you ❤️

[@AlexanderShapaka-jv4wh]

Thank you, really great content, delivered at a excellent pace, voice tone and language :)

[@marinethmarcos9130]

You're a great teacher Kenji!! :)

[@purple_scorp146]

Thanks Kenji, this is exactly what I needed to know

[@aashishsharma6706]

One of the best video of dashboard so far thanks !

[@michaelomosebi6374]

Thanks Kenji. I believe I can go ahead to build my dashboard now Also, your videos are clean...video and sound

[@taiwotitilope8332]

Best video of my life literally thumps up K👍🏽👍🏽👍🏽

[@md.sakerurrahmanauntor1389]

Thanks Kenji for making this tutorial.However By the help of your tutorial,I have learnt to make Dashboard.

[@narandarnanavati5449]

Thanks Kenji for such an amazing video. I thought we could only create dashboards in Power bi and tableau

[@yamilvogeld.2385]

What a nice dashboad! Thank you very much I learned a lot from this video Kenji!

[@diegoaguilera4411]

This is quality dude, you make it look super easy!

[@KenjiExplains]

Thank you Diego!

[@Joeyleander27]

This is really great content, learning how to use excel through your videos!

[@KenjiExplains]

Great to hear!

[@TaufiqCandra]

I'm your new subscriber, thanks a lot for providing me very insightful video. I totally love it. It means a lot for me. Keep up the good work!

[@KenjiExplains]

Welcome aboard!

[@DrJohnPollard]

Very present presenter. Get's right to it. Makes it look easy. Well done!

[@aryanmanu5488]

finally something worth the time.

[@sikanderkhan8383]

Beautiful and simple explaination to create a interactive dashboard

[@Thihgi]

Awesome. Btw I would like to share my experience in the last step - report connections: I met an issue 'Report Connections Slicer Not Showing All Pivot Tables' because in the sheet Sales Trend I chose data as in the video, but I filled 'table1' for the 3 rest tables as I named the data as table 1. When I fill the data in the same way in 4 tables, it works

[@JamaicaFlores-mb1wq]

Thank you so much sir.. A very big help.. God bless you sir abundantly.

[@bipl8989]

Kool! That's exactly what I've been looking for. Thanks.

[@BiancaGodeanu]

Really great!!! Extremily efficient!! Thank you!!

[@chilieu2621]

I do enjoy your videos. I am starting to build better excel skills and this tutorial is awesome.

[@fortune7399]

You are the one I was looking for. Thank you!

[@markatoe7074]

This is really helpful and well detailed ..kudos

[@dianemetzloff7993]

Your awesome im going to try this over the weekend

[@maricelascinas888]

thank you for sharing , its very helpful for my presentation and cost data analysis :-)❤❤❤😊😊😊

[@abhigyanbhatt5691]

I am so glad that I came across your channel❤❤

[@KenjiExplains]

Love to hear it!

[@ilililililil3939]

Videos on Power Bi would be Great too! I am at a big 4 firm and it’s basically the standard dashboard that they want you to use

[@KenjiExplains]

Thanks for the comment! Noted the suggestion :)

[@ironpurush0978]

Hey man, I am looking for my first data analyst role. Can you help me?

[@BronsonKiprono]

Great stuff. Thanks for doing this. I am learning a lot.

[@josiasdiaz6127]

Hey @KenjiExplains, thank you! it has been very helpful. Though I got stuck at the part of connecting the slicers to the different Pivot tables. I did have pivot tables from different tables, not the same table. Do you think that's the reason my slicers are not connecting to my pivot tables? Any help is much appreciated!

[@rhowson4838]

Such a good video Kenji!

[@KenjiExplains]

Thank you!

[@mstark77]

Excellent video and walk-through tutorial.

[@brunokadiat87]

Thank you for the tutorial, much appreciate. However I have a question: I have three sheets: Summary, 101 (for tenant 1), and 102 (for tenant 2). The Summary sheet has a table that summarize all the tenants info, with columns for Unit No, Balance Due, Tenant Name, Telephone. On the Tenant sheets (101 and 102), I want to link specific cells to the corresponding columns in the Summary sheet. This way, the Summary sheet will be automatically updated with information from the Tenant sheets. For example, on each Tenant sheet, there is a cell (I7) for Unit No. that I want to link to the Unit No column on the summary, Cell K5 to link to the Balance Due column, Cell C7 to link to the Tenant Names column, and Cell C9 to link to the Telephone column. In that I way, I will have first row for tenant 101 and all the details second row for tenant 102 and all the details, and so on. I know I can use “=’101’!I7 for refence, but what if I have 1000 tenants? This will be a lot of work. So I want a formula or VBA code to automatically and dynamically update the Summary sheet even if additional tenant sheets are added. Is it possible?

[@kimams4588]

Great Video. Thanks a lot for your knowledge sharing!

[@graceifere3210]

Great work on this video! 😀

[@KenjiExplains]

Thanks Grace!

[@philvuk]

Wow makes it super easy and straight forward !

[@KenjiExplains]

Great to hear!

[@emmanuelnwachukwu6071]

Thank you.. this was very instructive

[@kutulloletageng1069]

Thank you sir, how did you get that dark blue color for slicer buttons, i am struggling with it

[@rileygla23]

Ur a legend Kenji

[@vikramadityarathore97]

Hey Kenji enjoyed your previous video when you shared facts about yourself. Congrats for 100k subs and many more to come. If possible could you make a video on mergers and acquisitions and concept of synergy.

[@KenjiExplains]

Thank you! I don't think that's a topic I'll be covering soon as I don't know it too well sorry

[@vikramadityarathore97]

@@KenjiExplains no problem mate , if you can do interview related videos for different profiles apart from your insightful excel videos it would be great.

[@AdeKaryadi]

Amazing, beautiful dashboard. My inspiration chanel. 👍

[@techbase583]

Thanks for this video! however map chart is not taking any effect according to the slicer clicks...please advise..Many thanks.

[@areebagul8107]

Very well explained thanks❤

[@zackymotovlogko104]

Thanks Kenji, this helps me a lot.

[@KenjiExplains]

Glad to hear it!

[@ghashanti]

Thank you for this great tutorial.

[@lecturesfromleeds614]

You know for the "Sales in USD" could you replace that with a drop down box that converts between different currencies and automatically updates with the exchange rate?

[@ali8bilal]

Such a brilliant work 👏

[@VijayKumar69]

Thank you for such a nice video!

[@ColinKotch28]

Excellent video. I am using a Mac. When I insert the titled map, some of the states do not populate. I even changed the data type to geography. Any thoughts?

[@vanassarinputtasan8125]

Thank you so much Kenji

[@rosspascoe7223]

An easy macro can be added to the "data" sheet to update the pivot tables automaticaly. If not for that the dashboard is what is needed for most businesses! Love your content, keep it up I always learn new information watching these.

[@KenjiExplains]

Thanks for the input Ross great point!

[@jhisanmahmud3108]

I am using Excel 2016. I cannot use maps in dashboard. It's 3d dashboard. I cannot find the maps you use in this tutorial. How can I use maps like you used in this tutorial in Excel 2016. Thank you so much.

[@Capturingthemoment]

Hi kenji. Thanks for the awesome video. Super helpful. Looking forward to more videos and content. Side note: I am trying to build a dashboard as part of my academic project and plan to use this data. For the project, I would need to provide references to the origin of the data. Are you able to pls provide a bit of context on the data source? Pls and thank you!

[@jorgehenrique9248]

Thanks for your videos Kenji.

[@KenjiExplains]

Glad you like them!

[@jacintodaveiga1668]

Well done keep it up 🤝👌🏾👌🏾

[@olopadeshuaib7119]

nice tutorial. well explanatory. But why is it that i am not able to see the maps on my insert button. i am using excel 2016 by the way

[@saidfawzy]

A real great video .. Thanks so much for your kindness

[@asopok]

Thanks for this wonderful video. Can I add the dataset to my portfolio?

[@MohammadIfam1]

Thank you for this. Quick Q - If we make any new edits to the data sheet, will the dashboard automatically recognize the changes and update accordingly?

[@Skippy24]

You're the BEST!

[@gospelmoto2833]

Thanks Kenji! awesome. I have a little problem - I can't see the other pivot tables to link. I see only one - the Sales in USD. Why is that? Thanks for the help.

[@voiceofsoul7865]

It's an awesome video. Thank you.

[@carlacristine9338]

super super awesome. Thank you

[@knowledgevoyage8828]

Love your tutorials, excellent work

[@thenewdataguy]

Thanks for inspiration, looks really good!

[@KenjiExplains]

Thanks for watching!

[@nicshar8421]

Thanks for the video. Can you make an interactive Dashboard from data that was queried using the Analyze Data functionality?

[@akankshagupta5042]

Hi Kenji I am struggling with an excel/numbers sheet which helps me Same Product+ daily purchase + sale, balance inventory and margins. Also carry over of the balance inventory to next day while next day I am buying more commodity

[@xiskagaming3374]

Thank you so much, I learnt a lot from you.

[@KenjiExplains]

Glad to hear that!

[@amiraqistina3227]

Hey Kenji, can you show us the GETPIVOTDATA function slowly? Its kinda too fast and i couldnt get it.

[@ibrahimibneismail9237]

Love you sir ❤

[@DavidGomez-le7if]

Great video 😃👍🏼,

[@dougadiaby8815]

Amazing video thank for presentation

[@ahmedeid-bz8gd]

Great you are , one simple question : i tried more than once to add table style to my excel to be my preference , it works , but when i closed my file can not find it a gain what is my problem ?

[@Forsworn378]

Hi Kenji, thanks for the video. It has been really informative and a good practice as well. As we are not able to insert a map from the pivot table, the slicer inserted does not work when toggling between the regions and the map is not updated. Is there a way around that?

[@Moncef.M]

Same problem here

[@nickandreoglou2871]

To fix this problem right-click on the chart, press "Select Data" and then in the "Chart data range" select the data from the pivot table. Hope that helps

[@ቅይጥወጎች]

Thank you 🎉