Make a Professional Excel Dashboard From Scratch Using Real-World Data

Make a beautiful interactive Excel dashboard in just 20 minutes.

In this tutorial we'll make an awesome, interactive Excel dashboard completely from scratch on the richest people in the world, where we can filter by certain criteria, navigate across the different sections, and refresh our data, and much more. Doing this efficiently has taken me years to learn, so let me show the full workflow step by step. First, we'll analyze the dataset to identify the relevant areas with pivot tables. Second, we'll lay out the dashboard structure with shapes and textboxes. Third, we'll create the KPIs (Key Performance Indicators) and charts / visuals like a combo chart and a bar chart. Finally, we'll make the dashboard dynamic with pivot table slicers and a navigation bar using hyperlinks so we can navigate across the different worksheets.

LEARN:

▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬

Chapters:
0:00​ -​ Dashboard Workflow
0:40​ - Data Analysis
5:10​ - Dashboard Structure
9:40​ - Charts & Visuals
16:17​ - Making it Interactive

[ashfaqahmad]

Amazing! So simple, straightforward yet such a powerful visualization method. Thank you Kenji and keep these videos coming! 😊

[nicolasnagela]

Spectacular dashboard, Kenji! Thanks for teaching Excel that well! Regards from Argentina!

[IbrahimKhalilibrahimhafi]

you are the best teacher in YouTube platform

[TheNancystella]

You’re the best teacher Kenji. Lots of respect and appreciation from India

[DesiVibesUnlimited]

Actully I'm watching video from another chanel but the problem is they put too much spices on their video, i just see your video nd seems like interesting. its ossum bro thanks keep it up from india

[antoniop.]

I am speechless. It is so motivating. I love your videos. I always learn something watching them. Wonderful. Thank you very much, Kenji!!!

[magdyali]

REALY MUCH APPRECIATED YOUR KIND EFFORT AND THANKS FOR YOUR TIME

[MooreEastMidlands]

Great video - super easy to follow, thank you!

[garystroup]

Bro…were you monitoring my search history today 😂.

[osman]

Thank you so much for this amazing video. Very clear, very professional.

[abulhassan]

Thank you so much for teaching. I love all your videos. Love from India

[pinkyshroff]

Superrr…guess this video is definitely for masses….wish you cld create one such
analysis dashboard for health sector

[mohsenqureshi]

This was fantastic. Thank you! ❤
Would you be able to show how we could keep updating the original data, or add rows to it later, and have the rest of the dashboard pick up on those changes?

[Irshadali-cujq]

That's a very professional dashboard❤

[tun-tunninc.]

I work in supply chain and this is fanta. Thank u.

[DebanjanPramanick]

Which should learn first ? SQL or MySQL. Please guide🙏

[christophermarais]

Thanks is this exact spreadsheet available to download please

[yosiarizki]

sorry, out of topic, what makes two identical excel files have different file sizes? even 3 times as much. thankyou

[ahmedshalaby]

why we get error from the pivot when we try to reference any cell from it?

[karthikbala]

Can u plz create Finance Dashboard in excel in Real world scenarios