Interactive Excel Dashboard Tutorial in 3 Steps (+ FREE Template)

Interactive Excel Dashboard Tutorial in 3 Steps (+ FREE Template)

MyOnlineTrainingHub

9 месяцев назад

139,920 Просмотров

Ссылки и html тэги не поддерживаются


Комментарии:

@MrDhunpagla
@MrDhunpagla - 14.02.2024 21:11

Amazing 😊

Ответить
@soundaryasuresh1845
@soundaryasuresh1845 - 15.02.2024 10:13

I tried this in my excel and enjoyed the results. Thank you mam

Ответить
@heinzthedutch
@heinzthedutch - 16.02.2024 22:56

awesome stuff again! greetings from the netherlands.

Ответить
@marilubadillo8108
@marilubadillo8108 - 17.02.2024 03:50

Thanks very much

Ответить
@abumaramable
@abumaramable - 17.02.2024 13:21

You have an amazing ability to adapt data to appear in this beautiful, harmonious and useful form.

Ответить
@vick3379
@vick3379 - 18.02.2024 19:35

Simply amazing! Thank you for sharing this with us

Ответить
@saadaljohani6565
@saadaljohani6565 - 19.02.2024 12:58

Thank you so much ❤

Ответить
@arfanrasheed9941
@arfanrasheed9941 - 19.02.2024 20:00

What if the new data is in coulmn instead of row, means if new data will go to next columns? I am asking it as I deal with attendance and test performance of a college students having different subjects.

Ответить
@tihomirhristov77
@tihomirhristov77 - 21.02.2024 15:54

Excelsia is a Wizard 💚👌🏻

Ответить
@RhetoricalLanguage
@RhetoricalLanguage - 23.02.2024 09:10

Hello Mynda, I have come across a query and hope you can suggest some solution to it. I have a list of Stock names in a table (which obviously has Exchange & Stock Code in bracket at the end). I can't seem to get the text in a new cell (outside table) in anyway, tried, TEXT, SEARCH, LEN.. nothing seem to be working. Do you have any workaround? Thank You

Ответить
@m2badri
@m2badri - 02.03.2024 13:56

Amazing! I didn't realize that such good looking and insightful dashboards can be built using Excel data. Thanks for making this YT video. Truly appreciate your time and efforts!👍

Ответить
@sherifelgazar4089
@sherifelgazar4089 - 03.03.2024 15:12

This is awesome! thank you for this

Ответить
@romeothehavanese
@romeothehavanese - 15.03.2024 10:07

Fantastic! Just what i was looking for!

Ответить
@wardsmaill8973
@wardsmaill8973 - 20.03.2024 18:09

😝 Promo'SM

Ответить
@ashishshiriskar123
@ashishshiriskar123 - 25.03.2024 11:19

awsome job... simply superb

Ответить
@MaureenPesch
@MaureenPesch - 31.03.2024 06:20

Great dashboard as always! I especially love the trick to conditionally format the selected name.

Ответить
@ems_emil2299
@ems_emil2299 - 01.04.2024 02:32

This is Awesome! thank you.

Ответить
@alandrewgibson
@alandrewgibson - 05.04.2024 01:18

Wow thanks!

Ответить
@sherylleduna5367
@sherylleduna5367 - 06.04.2024 18:26

I've been a huge fan! Thank you for making this video. :) God bless!

Ответить
@deedubdolphinsdialogue9058
@deedubdolphinsdialogue9058 - 11.04.2024 06:50

How can I put a map of the US in the dashboard and be interactive with a slicer?

Ответить
@andinh8835
@andinh8835 - 14.04.2024 08:48

Can I have the data sheet to practice? Thanks a lot!

Ответить
@aprilirvin4216
@aprilirvin4216 - 15.04.2024 23:11

Do you have any videos on exporting expiries from multiple sheets onto a dashboard. I’m looking for a traffic light system that summarises upcoming expiries, expired and current stock holdings

Ответить
@Winniebakerz
@Winniebakerz - 16.04.2024 17:13

Thanks you for sharing. I tried and faced a problem, It doesn't work when I cut the slicer and paste to another sheet. The slicer cannot paste on the dashboard sheet. Could you advise how to solve the issue?

Ответить
@robloxellicuti6002
@robloxellicuti6002 - 17.04.2024 04:46

SO good and very useful.🌹🌹🌹

Ответить
@shannaandersonzongo8128
@shannaandersonzongo8128 - 24.04.2024 18:01

This was amazing! I’ve been really wanting to do something like this for my board reports, but didn’t realize it could be done so nicely in Excel. I was thinking we’d need another subscription to a different tool.

Ответить
@vtanz
@vtanz - 25.04.2024 07:28

Could you please create a simple project gantt chart. Thanks

Ответить
@PareshGujarati
@PareshGujarati - 07.05.2024 14:07

Thank you very much for the in-detail explanation. Best explanation on dashboard so far.

Ответить
@gamizuco
@gamizuco - 12.05.2024 20:42

You are simply amazing. Thank you!

Ответить
@JohnYoo-ge6mn
@JohnYoo-ge6mn - 14.05.2024 20:54

the interactive slicers does not seem to work when opened in the Mac version of Excel is there a fix for that

Ответить
@shoppersdream
@shoppersdream - 19.05.2024 18:21

Nice, Mynda! Thank You!

Ответить
@olaoyeolayinka5394
@olaoyeolayinka5394 - 04.06.2024 01:11

Struggling to really understand the dashboard . Thank for this video. I will try and practise and watch it over and over again

Ответить
@anillpatel
@anillpatel - 07.06.2024 18:32

Very well-created Dashboard.
Brilliant Colour Scheme.
Excellent use of Data Bars and subtle use of Gradient to highlight figures.
The Conditional Formatting to highlight the Sales Agent is fantastic. Simple, yet very effective.
Thanks Mynda....,

Ответить
@viksabharwal2811
@viksabharwal2811 - 18.06.2024 23:51

Your mode of instruction is so easy to understand . Thanks, Mynda. Can we, please, get the sample Excel file to practice like the other videos.

Ответить
@viksabharwal2811
@viksabharwal2811 - 27.06.2024 18:28

Thanks, Mynda
You are too kind. I wish you all the best, now and always
I just love learning from you, a plethora of knowledge that you impart in an impeccable fashion, easy to comprehend

Ответить
@ScottTeenier
@ScottTeenier - 03.07.2024 05:17

You are the one and only leader. You excel. Love it.

Ответить
@Morganafrika
@Morganafrika - 08.07.2024 04:24

My boss is just doing a great job here, refreshing my head

Ответить
@mausiemoo
@mausiemoo - 09.07.2024 10:57

Out of all the tutorials I have been watching, this one is straight to the point and easy to understand. Thank you!

Ответить
@mamunahmed892
@mamunahmed892 - 12.07.2024 14:35

How can I show month on month changes in staff absence for each department in my organisation in a nice chart? What would you recommend?

Ответить
@Sanja1234-y5e
@Sanja1234-y5e - 25.07.2024 09:54

Can we do it by using jeda ai 😢

Ответить
@Sanja1234-y5e
@Sanja1234-y5e - 27.07.2024 10:30

Hi dear can you do a video for simple book keeping

Ответить
@Mary-h2w
@Mary-h2w - 28.07.2024 13:50

Amazing video, A friend of mine referred me to a financial adviser sometime ago and we got to talking about investment and money. I started investing with $150k and in the first 2 months, my portfolio was reading $274,800. Crazy right!, I decided to reinvest my profit and get more interesting. For over a year we have been working together making consistent profit just bought my second home 2 weeks ago and care for my family.

Ответить
@chevadamrepique1609
@chevadamrepique1609 - 18.08.2024 12:16

I love your work! thank you so much!

Ответить
@BasitDurodola
@BasitDurodola - 31.08.2024 22:59

Your creativity is TOP notch👍

Ответить
@antoniocurri910
@antoniocurri910 - 26.09.2024 17:51

Hi Mynda,
I saw your video on how to make a dashboard in 3 steps: really very useful and educational. But I have a problem when I update the pivot table with formatting both with data bars and with icons (you know I tried to put the traffic lights ...) the formatting of the columns with the icons is lost. I use the Mac version 16.90. How can I keep this formatting even after updating the data?
Many thanks for all the suggestions you want to give me.
Best regards Antonio

Ответить
@tanveerabbas3271
@tanveerabbas3271 - 29.09.2024 22:06

mynda plz marry me so i can become an expert like you😅

Ответить
@TinfoilHat007
@TinfoilHat007 - 10.10.2024 12:07

What about when you are trying to create a dashboard from multiple sources, each imported to your sheet through power query? If you want to be able to have data that expands and contracts dependent of the slicer button selected, how do you prevent that data from upsetting the rest of the dashboard?

Ответить
@infamousprince88
@infamousprince88 - 11.10.2024 07:38

Hi - thanks for this. Very very helpful walkthrough that I’ll be coming back to for future use!

Ответить
@tfortanvir1336
@tfortanvir1336 - 25.10.2024 23:48

Just super 😮

Ответить