Create interactive excel dashboard in 5 simple steps #exceldashboard #exceltutorial #pivottable

In this video we will set up an amazing dashboard in microsoft excel from scratch. We will learn lots of concepts in this video. Some key concepts we will learn are:

- Pivot tables / slicers
- Data Analysis
- Custom formatting
- Working with shapes.
- Design and colors.

Timestamps:

00:00 - Intro
02:00 - Wireframing the dashboard
04:15 - Determine data points required
06:17 - Setting up workings and pivottables
22:00 - Building up the dashboard
31:30 - Final touches and formatting

#exceltipsandtricks #exceldashboard #pivottables #excelcharts #excelmacros

[Vee-ofeb]

Have just created my first ever dashboard after watching your video - absolutely brilliant, thank you so much!! My boss was impressed too 🙂

[Vee-ofeb]

Absolutely mind blowing! Thank you for such an informative video. Looking forward to building my own Dashboard now 🙂

[Member]

Beautiful! So glad you put so much thought into the explanation and the timing of this video. I enjoyed the zooming in too. Thanks so much for sharing!

[emsy]

Fantastic example!! Very interesting and informative. Easy to follow ❤
I can’t wait to build my own dashboard using these techniques!! 🎉

[emmatrombone]

Thank you very much. I am starting a career in Data Analysis and I have been getting my excel skills up to speed. This is very informative. Blessings

[Jahid-Lipu]

Excellent expression to create a dashboard with data.

[halilvatansever]

Greetings from Turkey,
I follow even though I am not fluent in English.
I commend you too, Fantastic example!! Very interesting and informative. Easy to follow ❤
I can’t wait to build my own dashboard using these techniques!! 🎉

[SpaceTacos]

This was a PHENOMENAL VIDEO!!! Thank you so much. Will absolutely be using this at my new job!! 💖

[aadeorukhkar]

This is bloody brilliant! Thanks SO MUCH!

[name_it]

I was looking for totally different video about formating. I am so very tired of this enormously heavy buttons/shapes setups with VBA, while looking for something simple and elegant. Thank you so much. Greetings from Germany.

[ucwgvxv]

Best dashboard video tutorial. Thanks so much.

[olalowosamuel]

This is the best excel training i had ever had in years. It was so easy to follow and direct. However, in a case where you have large filter list, how then do you work that out. Also, i observed this could only be done when you have enough data. However, this is a great lesson. Thank you @skillnator.

[Jolmesu]

You are a life saver, amazing and so simple to follow

[gcinamatsebula]

You teach well. All the relevant aspects are included in your video. Brilliant!!!

[abdullahyangin]

you are most amazing and brilliant teacher I have ever seen.You give the explanation so clearly.I understand all of steps.Thank you so much.I am really grateful.

[Noob-ngof]

So clean, easy to follow through. Just earned yourself a subscriber mate.

[blinddog]

Amazing video. Thank you for putting in the time for others.

[nicolask]

Awesome!! We have some reports that are currently displayed in raw pivot tables, which i aesthetically dislike. Though with your tutorial i think i'll be able to display the data in a flexible but waay better looking way! Thanks alot!😊

[therngeek]

Loved the video and deep discussion about each step and concept. Thank you so much for sharing!!

[parshuramnangare]

You have created an excellent dashboard, thanks a lot for this informative video.