Тёмный

Interactive Excel Dashboard for BETTER Data Visualization (Free Download) 

MyOnlineTrainingHub
Подписаться 613 тыс.
Просмотров 25 тыс.
50% 1

Build an interactive Excel dashboard for better data visualization in less than 20 minutes .
❗Master Excel with 20% off all my courses until May 16, 2024: bit.ly/visualization24courses
⬇️ Download the example file here and follow along: bit.ly/visualization24file
LEARN MORE
===========
📰 EXCEL NEWSLETTER - join 450K+ subscribers here: www.myonlinetraininghub.com/e...
🎯 FOLLOW me on LinkedIn: / myndatreacy
💬 EXCEL QUESTIONS: Get help on our Excel Forum: www.myonlinetraininghub.com/e...
#Excel #ExcelDashboard #ExcelDashboardTutorial

Наука

Опубликовано:

 

13 май 2024

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 70   
@MyOnlineTrainingHub
@MyOnlineTrainingHub Месяц назад
❓What is the biggest challenge you've faced when creating dashboards, and how did you overcome it? Master Excel with 20% off all my courses until May 16, 2024: bit.ly/visualization24courses
@sarahbelle2140
@sarahbelle2140 Месяц назад
I'm having a heck of a time because my budget and actual data is formatted by month in columns. When trying to create a relationship between workbooks, it doesn't work. I've all but given up. 😢
@stephanebarret2517
@stephanebarret2517 22 дня назад
@@sarahbelle2140 Hi Sarah; I would recommend to use Power Query and unpivot columns
@ddlast6
@ddlast6 20 дней назад
My pivot table with sales per month does not arrange the months chronologically.. My months are arranged alphabetically and I am unable to formart it into a chronological order.. How do i go about it
@mohamedihthishammubaraksad3354
@mohamedihthishammubaraksad3354 14 дней назад
biggest challenge is keeping up with your speed of showing but it was really good
@sarahbelle2140
@sarahbelle2140 13 дней назад
@ddlast6 there is likely an easier way, but I've started using this format for months. 01 - January, 02 - February, etc, this way they'll always be in order. Good luck!
@rtrbs8383
@rtrbs8383 Месяц назад
Hi Mynda you are the👑 Queen of Dashboard👑 Inserting the Shape to chart for shadow effect is killer
@MyOnlineTrainingHub
@MyOnlineTrainingHub Месяц назад
Thanks so much! 😃
@ReimaginedbySteve
@ReimaginedbySteve Месяц назад
Incredible Mynda.🤩What I love about your videos is that you have a natural talent for design too which makes a big difference. A lot of people doing what you do don't have both elements.
@MyOnlineTrainingHub
@MyOnlineTrainingHub Месяц назад
Thank you so much! ☺️ 🙏
@Seftehandle
@Seftehandle Месяц назад
It took me almost 2 hours, but I completed it without so much details to shapes (last couple of minutes). It really gave me some guidance to building Dashboard, which part of data to use for which kind of charts, what and how to format, all in all, excellent tutorial.
@MyOnlineTrainingHub
@MyOnlineTrainingHub Месяц назад
Congratulations! Great effort 👏
@ivanbork4175
@ivanbork4175 Месяц назад
Hi Mynda I must say that your inspiration is fantastic, the techniques in this video may be well known, but the way you design it and make it work together is truly admirable.
@MyOnlineTrainingHub
@MyOnlineTrainingHub Месяц назад
Thanks for your kind words, Ivan! 🥰
@chrism9037
@chrism9037 Месяц назад
I love these dashboard videos, thanks Mynda!
@MyOnlineTrainingHub
@MyOnlineTrainingHub Месяц назад
Thanks for your support, Chris 😊🙏
@Luciano_mp
@Luciano_mp Месяц назад
Useful and beautiful! Nice work Mynda! Than you!
@MyOnlineTrainingHub
@MyOnlineTrainingHub Месяц назад
Glad you like it! 😊🙏
@DatawithHimanshu
@DatawithHimanshu 11 дней назад
I always love your work and content. So much to learn from your channel. Thank you 😊.
@MyOnlineTrainingHub
@MyOnlineTrainingHub 11 дней назад
So nice of you 🙏😊
@zavoina
@zavoina Месяц назад
I get a kick out of the "Dashnord" on the agenda - you are a real person and not AI. :)
@MyOnlineTrainingHub
@MyOnlineTrainingHub Месяц назад
😆 didn’t spot that! Thanks for watching 🙏
@halsigmund3426
@halsigmund3426 Месяц назад
I was thinking maybe they use dashnords in Nordic countries. 😉
@RonDavidowicz
@RonDavidowicz Месяц назад
Or did the AI do it to make you believe she’s real??
@mcarvalhocarvalho1873
@mcarvalhocarvalho1873 Месяц назад
Thank you so much. One more spectacular experience.
@MyOnlineTrainingHub
@MyOnlineTrainingHub Месяц назад
Glad you enjoyed it! 🙏😊
@arbazahmad7177
@arbazahmad7177 Месяц назад
Excellent. Thanks for sharing.
@MyOnlineTrainingHub
@MyOnlineTrainingHub Месяц назад
Thanks so much!
@DL12able
@DL12able 29 дней назад
Lovely just you are and your lesson! you are naturally gifted to teach! I swallowed it like kids meal under a year, this is only because of you! 'The last excellency is simplicity' that is the way you went through. Blessed!
@MyOnlineTrainingHub
@MyOnlineTrainingHub 29 дней назад
Thanks for your kind words!
@tiger131071
@tiger131071 Месяц назад
Looks wonderful 🤩
@MyOnlineTrainingHub
@MyOnlineTrainingHub Месяц назад
Thank you 😋
@moruffkazeem7574
@moruffkazeem7574 29 дней назад
Thanks a lot for this. Quite insightful.
@MyOnlineTrainingHub
@MyOnlineTrainingHub 29 дней назад
Glad you enjoyed it!
@tibibara
@tibibara 8 дней назад
I really-really like the design of this dashboard and the color theme - thanks! ;-)
@MyOnlineTrainingHub
@MyOnlineTrainingHub 8 дней назад
That's wonderful to hear 🙏
@benosborne413
@benosborne413 Месяц назад
EXCELLENT. Thanks
@MyOnlineTrainingHub
@MyOnlineTrainingHub Месяц назад
Thanks for watching!
@shoppersdream
@shoppersdream Месяц назад
Nice, Mynda! Thanks
@MyOnlineTrainingHub
@MyOnlineTrainingHub Месяц назад
Glad you liked it 🙏
@muhammadsadiq2330
@muhammadsadiq2330 Месяц назад
Very nice in short time
@MyOnlineTrainingHub
@MyOnlineTrainingHub Месяц назад
Thank you ☺️ glad you liked it.
@ronnyvrijsen1
@ronnyvrijsen1 Месяц назад
Really inspiring 👍
@MyOnlineTrainingHub
@MyOnlineTrainingHub Месяц назад
Glad to hear that 🙏😊
@sseemm
@sseemm Месяц назад
Thank you Mynda ❤❤
@MyOnlineTrainingHub
@MyOnlineTrainingHub Месяц назад
Thanks for watching 🙏😊
@jugubitrus7295
@jugubitrus7295 Месяц назад
Keep up sir the good work.
@MyOnlineTrainingHub
@MyOnlineTrainingHub Месяц назад
Thank you, I will 😊
@user-ec3rm9wr1n
@user-ec3rm9wr1n Месяц назад
Love it 😍😀...
@MyOnlineTrainingHub
@MyOnlineTrainingHub Месяц назад
Thank you! 😊
@nikolayvelichkov228
@nikolayvelichkov228 Месяц назад
Thank you. The tricky things I have which ruin the pretty dashboard are big deviation between categories or sales and negative profit numbers. It'd be nice to see how you manage it in the next videos. Thanks again.
@MyOnlineTrainingHub
@MyOnlineTrainingHub Месяц назад
Instead of thinking about how to make the dashboard pretty, better to focus on what's the most important point you're trying to convey and choose a chart that makes it easy for the reader to see this. It might be that the chart you're using is perfect, but your data is just disparate. I cover some options for visualising disparate data here: www.myonlinetraininghub.com/charting-disparate-data-in-excel
@Trivikram24
@Trivikram24 Месяц назад
Thank you , your videos really helped me a lot and made excel easy.. I always gets confused, having a doubt while making pivot table .. How do I know which data colums should I keep in values , which in rows and columns , can you clarify me this .. and also after selecting how to select the perfect graph. I am confused whether to select bar chart line.. can you clarify me please or make a video on this ... Thank you
@MyOnlineTrainingHub
@MyOnlineTrainingHub Месяц назад
Great to hear. There's no golden rule for PivotTables other than fields containing numbers typically go in the Value fields because these are the ones you want to sum/average/count etc., but it's not strictly limited to this type of data. As for the chart types, I cover this in my Excel Dashboard course: www.myonlinetraininghub.com/excel-dashboard-course
@nazarkamal8831
@nazarkamal8831 Месяц назад
Can't believe this is done in excel!!! Better than power BI
@MyOnlineTrainingHub
@MyOnlineTrainingHub Месяц назад
Thank so much ☺️🙏
@amosinoh
@amosinoh Месяц назад
Hi, can I know the version of Excel that you're using for this presentation? Thank you.
@MyOnlineTrainingHub
@MyOnlineTrainingHub Месяц назад
Microsoft 365, but it will work in Excel 2016 onward.
@mercypena2200
@mercypena2200 Месяц назад
Can I create a map for my city, as you created a map for a country?
@MyOnlineTrainingHub
@MyOnlineTrainingHub Месяц назад
The built in Excel maps only map to the state level of detail. You can use the 3D maps though: www.myonlinetraininghub.com/excel-3d-maps
@jenniferbrown7539
@jenniferbrown7539 6 дней назад
This is hard to figure out. So I’m trying to make a graph that shows my credit cards and loans. I wanted to show the Limit and the balance per month on top of each other. That’s easy, the issue I have is the total. Once I place a slicer, I want the “total” to be the current month balance and with slicers show per month. But I can’t figure out how to make them all be seen at the same time without showing every month. I hope the explanation is understandable. I don’t want all the months to be seen, I want the legend to only be the loans name and slicer filter per month.
@MyOnlineTrainingHub
@MyOnlineTrainingHub 6 дней назад
Hi Jennifer, Please post your question and sample Excel file on our forum where someone can help you further: www.myonlinetraininghub.com/excel-forum
@juanesocampo1075
@juanesocampo1075 Месяц назад
Hi, I'm Juan Carlos Ocampo. A good idea is to post the videos in different languages, such as Spanish, for example.
@MyOnlineTrainingHub
@MyOnlineTrainingHub Месяц назад
Hopefully, RU-vid will translate it automatically for you soon.
@Khan-mc3gi
@Khan-mc3gi Месяц назад
How u give black colour to sheet
@MyOnlineTrainingHub
@MyOnlineTrainingHub Месяц назад
I showed that at the beginning. select all the cells and set the cell fill colour.
@bexigao
@bexigao Месяц назад
First
@MyOnlineTrainingHub
@MyOnlineTrainingHub Месяц назад
Thanks for watching!
@user-cb4ps2jo5j
@user-cb4ps2jo5j 12 часов назад
Thank you for this video! Very good. @myonlinetraininghub What video software do you use? This instructional video is very well edited, and honestly, I'd love instruction on how to make instructional videos, so details on video-making software for this specific use case is at the top of the most-needed list. :)
@MyOnlineTrainingHub
@MyOnlineTrainingHub 7 часов назад
Thank you! I use Camtasia Studio for the screen capture and then I have an editor who uses Premiere Pro.
Далее
10 Excel Formulas That Will Set You Apart (Cheat Sheet)
18:04
Мышка на механике?! Ну почти!
00:48
Don't Do This: Top 5 Mistakes in Data Visualization
6:02
Try This New Formula Instead of Pivot Tables
12:08
Просмотров 197 тыс.
5 Excel Secrets You'll Be Embarrassed You Didn't Know
17:32
Make an Interactive Excel Dashboard in 4 Simple Steps!
19:41
AI от Apple - ОБЪЯСНЯЕМ
24:19
Просмотров 126 тыс.