Create interactive excel dashboard in 5 simple steps
HTML-код
- Опубликовано: 19 июн 2024
- 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
Instagram: / skillnator0
Full youtube excel playlist: • Microsoft Excel
Link to the file: drive.google.com/drive/folder...
#exceltipsandtricks #exceldashboard #pivottables #excelcharts #excelmacros
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!
Absolutely mind blowing! Thank you for such an informative video. Looking forward to building my own Dashboard now 🙂
Have just created my first ever dashboard after watching your video - absolutely brilliant, thank you so much!! My boss was impressed too 🙂
Fantastic example!! Very interesting and informative. Easy to follow ❤
I can’t wait to build my own dashboard using these techniques!! 🎉
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
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!! 🎉
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.
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.
You teach well. All the relevant aspects are included in your video. Brilliant!!!
This was a PHENOMENAL VIDEO!!! Thank you so much. Will absolutely be using this at my new job!! 💖
Excellent expression to create a dashboard with data.
Best dashboard video tutorial. Thanks so much.
This is bloody brilliant! Thanks SO MUCH!
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.
You are a life saver, amazing and so simple to follow
Amazing video. Thank you for putting in the time for others.
simply to understand and easy to follow, thank you very much
Great video with excellent examples and techniques
Very informative and useful video i have ever seen so far on excel dashboard
if only i could like this video a million time! Appreciate the effort to guide us through, it is fantastic and absolutely helpful.
Thank you so much! Clear explanation and steps.
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!😊
I have been watching your video and it is excellent. Thank you so much for sharing this knowledge. I appreciate it.
Loved the video and deep discussion about each step and concept. Thank you so much for sharing!!
Thank you!
Your approach is systematic and very neat!
Thanks for Creating us outstanding exposure to dashboard
Love it!!! Thank you for sharing. You are amazing 🎉
You have created an excellent dashboard, thanks a lot for this informative video.
Thank you!! Glad you liked it!!
So clean, easy to follow through. Just earned yourself a subscriber mate.
Thanks for the sub!
Thanks for this video .. very useful and we can practice now,
You are a lifesafer. Thank you
Lifesaver!! Thank you!
Learnt a lot from this. Thank you.
Thank you so much. This is mind blowing video
This is so useful, thank you for sharing
Gracias por compartir tus conocimientos
amaaaaaaaaaazing !
very easy to follow and detailed enough to get lost while following along.
i wish to see a video on creating a dashboard of multiple data sets (to connect multiple tables).
Absolutely amazing.
Thank you so much, Very helpful.
Thanks for the video. It was really helpful.
Amazing content, learnt a lot. Thanks
Very Nice.... interestingly and informative video
wooo
thanks very much
specials thank for sample file
I can follow your video step by step
Perfect! Well done.
Awesome video and I learned a lot of Excel tricks 🙌🏼
This is awesome !! Thank you for sharing!
Thanks for watching!
terrific job, thank you.
Very interesting.I like very much, thank you, I will tray to make a dashboard.
Thank you very much. I do wish you have good healthy and wealthy forever!!!
Wow. Thanks for sharing bro. Very informative.
Absolutely brilliant
It is very useful lesson. Thanks
thank you very much for the information 👍
deserve subscribe bro ! your dashboard video course was absolutley great easy to follow ! thanks
Thank you so much!!
I watched some others too, but this one is excellent!
Very Cool teacher!!!!! from Thailand.
Thank u so much for your effort.
thanks for the useful knowledge. May God give you health and blessings
Thank you so much!!
Thanks a lot for this video. Great inspiration.
Glad you enjoyed it!
Excellent presentation
Thanks a lot for a great video.
Great Job, great job and, again, great job! 🙏
That really work POGchamp
Excellent Job!
Thank you for smart work
so talented. respect
Awesome explanation!
awesome tutorial
Fantastic!
great work!
Awesome video - just earned yourself a subscriber.
Nicely done.
thank you so much for this very helpful video ♥
Glad it was helpful!
Too Good! Very easy to understand and follow! Thank you. I was wondering if something similar can be created for Google Sheets? I will really appreciate your help on this. Thanks
Great video, thank you. How about creating a dynamic report showing the totals in this format: This Month, Last Month and this quarter, last quarter and this year, last year at all times without any extra steps. something like a dashboard which always only automatically calculates and shows above mentioned values?
Thank you very much!! ❤
You are Welcome!!
Could you please a video explaining the last part of adding button to dashboard and linking them in a little more detail. It would be really useful.
Excellent teacher
very nice !!!!
thank you
THANK YOU!!!!
Very good!
Great work
Awesome job
Great! 🎉
This video is awesome! Just have one question. When you add data for maybe further years, I think you will get errors, or? how could you prevent that?
You just got a new subscruber. Your tutorials ate the best
This is so awesome
Hi, very well done
It is amazing how much of my daily excel is done with pivot and slicers
I use it for both production and and sales, i also extract multiple back order reports from myob for each month to highlight delays in the past
SumIF, vlookup and Pivot basically cover 90% of my daily formulae used
It's very helpful video. I am able to understand and follow each step. However, when I tried to cut & paste the slicers to the report sheet, Excel does not allow me to do it. I can only paste in picture or bitmap only. Do I need to activate anything else in Excel?
Fantastic
Very nice 👍👍👍
You're awesome bro❤
Awesome. But I wish to know how you managed to put that switch formula over that table array without clicking in the cell. I mean the shortcut key you clicked
A great dashboard creatıon vıdeo. Congratulatıons. 🙂
Thank you! Cheers!
Super!!🤩
Excellent job
Thank you! Cheers!
amazing!
thanks a lot sir
Thank you 🙏
Welcome!!
Thank You