❓What's one unique dataset you're eager to visualize using the techniques from this tutorial? Master Excel now with 20% off all courses until Feb 15, 2024: bit.ly/excelcourses130224
@Marwatkk
6 ай бұрын
Nice ma'am
@abumaramable
7 ай бұрын
You have an amazing ability to adapt data to appear in this beautiful, harmonious and useful form.
@MyOnlineTrainingHub
7 ай бұрын
Wow, thank you!
@TP014563
7 ай бұрын
Last conditional formatting trick was new to me, very handy indeed! Thanks for sharing...
@MyOnlineTrainingHub
7 ай бұрын
Glad you discovered something new 😁
@liumahir
7 ай бұрын
@@MyOnlineTrainingHubWould an And Function make sense here? Like AND($D10=Analysis!$A$10;Analysis!$A$12="") With this function the purple frames will only be shown, if you select a name from the slicer.
@SimplyDigitalLK
6 ай бұрын
@@MyOnlineTrainingHub for some reason, when i update the data, this formating trick get modified and will only work for the first column. no idea why is that. Also when i dont have any name selected - its still showcasing the selection - while there is none.
@SimplyDigitalLK
6 ай бұрын
@@liumahir yes, that function works better i think. fix the issue when you do not have anything selected in the slicer.
@mausiemoo
2 ай бұрын
Out of all the tutorials I have been watching, this one is straight to the point and easy to understand. Thank you!
@MyOnlineTrainingHub
2 ай бұрын
So glad it was helpful!
@anillpatel
3 ай бұрын
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....,
@MyOnlineTrainingHub
3 ай бұрын
Thanks so much 😊
@DiamondRock2
7 ай бұрын
Amazing work Mynda, thanks for all the effort ❣
@MyOnlineTrainingHub
7 ай бұрын
Glad you enjoyed it! 🙏😊
@SergioAlejandroCampos
7 ай бұрын
Hi Mynda. I love your video editing.
@MyOnlineTrainingHub
7 ай бұрын
Thank you so much! I must admit that I’ve outsourced it nowadays 🤫
@SergioAlejandroCampos
7 ай бұрын
@@MyOnlineTrainingHub Well, you picked a good editor. But look, the essence of the video is you, that's what's important.
@aliniosif13
7 ай бұрын
learned a lot, you're a star!
@MyOnlineTrainingHub
7 ай бұрын
Awesome to hear 🙏😊
@chevadamrepique1609
Ай бұрын
I love your work! thank you so much!
@MyOnlineTrainingHub
Ай бұрын
So pleased it's helpful 🙏
@romeothehavanese
6 ай бұрын
Fantastic! Just what i was looking for!
@MyOnlineTrainingHub
6 ай бұрын
Great to hear! 🙏😊
@chrism9037
7 ай бұрын
Awesome dashboard Mynda!
@MyOnlineTrainingHub
7 ай бұрын
Thanks so much, Chris 😊🙏
@TheJoshtheboss
7 ай бұрын
Top quality content as usual! Excellent dashboard.
@MyOnlineTrainingHub
7 ай бұрын
Glad you like it! 🙏
@TheJoshtheboss
7 ай бұрын
Hi Mynda, sorry to be so bold but I have content suggestion for 1 video which I think many people would find very useful. I would like to create a quick comparison spreadsheet for buying a car, where you compare costs of HP, PCP and PCH (leasing). I am not sure where to start. 1. I think just creating 3 separate tables perhaps. And then using charts 2. Another approach, maybe having 1 table and then use pivot charts. But for this task I don't think this approach is the most suited, probably 3 separate tables still best. 3. I am thinking if the What if analysis tools are suitable for this? I am a bit confused where to start with this. I think a video on this would be fantastic, as many people are faced with tough budgetary questions when buying a car.
@viksabharwal2811
3 ай бұрын
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
@MyOnlineTrainingHub
3 ай бұрын
Thanks for your kind words!
@mohamadkuk
7 ай бұрын
This is awesome! thank you for this
@MyOnlineTrainingHub
7 ай бұрын
So glad you liked it! 🙏😊
@olaoyeolayinka5394
3 ай бұрын
Struggling to really understand the dashboard . Thank for this video. I will try and practise and watch it over and over again
@MyOnlineTrainingHub
3 ай бұрын
Glad it helped 😊
@IamTheReaper911
7 ай бұрын
That dashboard is................ ........EPIC 😎
@MyOnlineTrainingHub
7 ай бұрын
😅 wondered where you were going for a moment! Thanks so much 🙏😁
@ScottTeenier
2 ай бұрын
You are the one and only leader. You excel. Love it.
@MyOnlineTrainingHub
2 ай бұрын
Thanks for your kind words, Scott!
@m2badri
6 ай бұрын
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!👍
@MyOnlineTrainingHub
6 ай бұрын
Glad you like it! 🙏
@mcarvalhocarvalho1873
7 ай бұрын
Precious. Thanks.
@MyOnlineTrainingHub
7 ай бұрын
Thanks so much 🙏😊
@sseemm
7 ай бұрын
Thanks Mynda, One tiny tiny remark : it would be better to drop the name in the filter section of the pivot table and use it for the conditionnal formatting instead of using another pivot table with names in the rows. bcz, if the prson didn't select any name from the slicer, we will still have "Alex" being highlighted in the table, but if we add a filter to the first Pivot table, we can use it as the base of our conditionnal formatting. The filter will either show "All"" or "the active name in the slicer"
@MyOnlineTrainingHub
7 ай бұрын
Love that idea 👍 I sometimes build an error message into the dashboard if people select multiple names none of the charts display, but I was on a time constraint with this video 😉
@kathimills7699
7 ай бұрын
Taking that idea a little further -- the conditional formatting after Refresh only shows it being applied the the name, not the other PT fields in the video. Sorry I haven't had time to play with the download yet but I've been bitten by that quirk before and so I was specifically looking for it. Would using the name as a filter instead address that also?
@liumahir
7 ай бұрын
I have tried to solve this issue with the AND function in the Conditional Formatting. My second logical condition would be to see that A12 in the analysis sheet is empty, which happens only if you select one name. It works fine for me.
@MaureenPesch
6 ай бұрын
Great dashboard as always! I especially love the trick to conditionally format the selected name.
@MyOnlineTrainingHub
5 ай бұрын
Glad you liked it! 🙏😊
@BasitDurodola
27 күн бұрын
Your creativity is TOP notch👍
@MyOnlineTrainingHub
26 күн бұрын
Thank you so much 😀
@gamizuco
4 ай бұрын
You are simply amazing. Thank you!
@MyOnlineTrainingHub
4 ай бұрын
Thank you too! 🙏
@awesh1986
7 ай бұрын
Awesome video as usual.
@MyOnlineTrainingHub
7 ай бұрын
Glad you enjoyed it 🙏😊
@michaelmaharlika8569
7 ай бұрын
So very awesome and thank you for sharing, this dashboard says a lot about your understanding of data and how to visualize them correctly.
@MyOnlineTrainingHub
7 ай бұрын
Glad you enjoyed it! 🙏😊
@sherylleduna5367
5 ай бұрын
I've been a huge fan! Thank you for making this video. :) God bless!
@MyOnlineTrainingHub
5 ай бұрын
Glad you enjoyed it! 🙏
@soundaryasuresh1845
7 ай бұрын
I tried this in my excel and enjoyed the results. Thank you mam
@MyOnlineTrainingHub
7 ай бұрын
Awesome to hear 😁
@Sunjetnewstv
2 ай бұрын
My boss is just doing a great job here, refreshing my head
@heinzthedutch
7 ай бұрын
awesome stuff again! greetings from the netherlands.
@MyOnlineTrainingHub
7 ай бұрын
Welcome! Thanks for watching 😊
@shannaandersonzongo8128
5 ай бұрын
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.
@MyOnlineTrainingHub
5 ай бұрын
Wonderful to hear you'll be able to make use of it and save a load of money 😁
@hanisalehal-ssenai1431
7 ай бұрын
Thanks so much
@MyOnlineTrainingHub
7 ай бұрын
My pleasure 😊
@robloxellicuti6002
5 ай бұрын
SO good and very useful.🌹🌹🌹
@MyOnlineTrainingHub
5 ай бұрын
Glad you think so! 🙏
@vick3379
7 ай бұрын
Simply amazing! Thank you for sharing this with us
@MyOnlineTrainingHub
7 ай бұрын
Glad you enjoyed it! 😁🙏
@ems_emil2299
5 ай бұрын
This is Awesome! thank you.
@MyOnlineTrainingHub
5 ай бұрын
Glad you like it! 🙏😊
@DavidKlenkFurniture
7 ай бұрын
This is great, thanks Mynda.
@MyOnlineTrainingHub
7 ай бұрын
Glad you liked it!
@ashishshiriskar123
6 ай бұрын
awsome job... simply superb
@MyOnlineTrainingHub
6 ай бұрын
Thank you so much 😀
@alandrewgibson
5 ай бұрын
Wow thanks!
@MyOnlineTrainingHub
5 ай бұрын
Welcome! 😊
@EnmostMashcom
7 ай бұрын
Superb video. Kindly share one for sales vs purchases and usage. Thank you.
@MyOnlineTrainingHub
7 ай бұрын
Thanks so much! Will keep your suggestion in mind.
@saadaljohani6565
7 ай бұрын
Thank you so much ❤
@MyOnlineTrainingHub
7 ай бұрын
You're welcome 😊
@yulinliu850
7 ай бұрын
Excellent!!!👍❤
@MyOnlineTrainingHub
7 ай бұрын
Thank you! 😃
@viksabharwal2811
3 ай бұрын
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.
@MyOnlineTrainingHub
3 ай бұрын
Thank you. As usual, the file link is in the video description. 😉
@viksabharwal2811
3 ай бұрын
Thanks, Mynda, for such a prompt response. Much appreciated. you are "THEEEE BEST" tutor for these courses. I do not see any other videos from anyone if I am serious about REALLY learning a concept. Mynda, I cannot see the sample file , after checking again. What am I doing wrong?
@MyOnlineTrainingHub
3 ай бұрын
I think the link was missing. It's here: bit.ly/3-step-dashboards
@MrDhunpagla
7 ай бұрын
Amazing 😊
@MyOnlineTrainingHub
7 ай бұрын
Thanks so much 😊🙏
@UstedTubo187
7 ай бұрын
I like that name highlight trick using the conditional formatting and the slicer! I don't quite understand why picking that top cell makes it check the entire column for the name though. I'll have to look at that more closely.
@MyOnlineTrainingHub
7 ай бұрын
Great to hear. This video explains conditional formatting in more detail and will answer your question: kzitem.info/news/bejne/s7Cwn4Svn6maiYY
@UstedTubo187
7 ай бұрын
@@MyOnlineTrainingHubNice! Thanks for sharing that Mynda!
@UstedTubo187
7 ай бұрын
@@MyOnlineTrainingHubFollow up. Just watched the video you shared. You explained it perfectly, as usual. Thanks again Mynda!
@Wahj12345
2 ай бұрын
Hi dear can you do a video for simple book keeping
@MyOnlineTrainingHub
2 ай бұрын
Thanks for the suggestion.
@aprilirvin4216
5 ай бұрын
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
@MyOnlineTrainingHub
5 ай бұрын
You can use Power Query to first append the data from the sheets together into one table, then you can extract the data you want with either Power Query or a PivotTable, and use Conditional Formatting for the traffic lights. I don't have one video covering all these steps, but I do have individual videos on these topics. Here's the Power Query video: kzitem.info/news/bejne/uoV5k6R7gqd5o3Y Here's the PivotTable video: kzitem.info/news/bejne/14eirJ2CjpOoZ6A Here's the Conditional Formatting video: kzitem.info/news/bejne/s7Cwn4Svn6maiYY
@vtanz
5 ай бұрын
Could you please create a simple project gantt chart. Thanks
@MyOnlineTrainingHub
5 ай бұрын
Like this: kzitem.info/news/bejne/ooSwuKRjsl-aim0 or a project management dashboard with Gantt chart like this: kzitem.info/news/bejne/lqequZ2ljXdjqo4
@mamunahmed892
2 ай бұрын
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?
@MyOnlineTrainingHub
2 ай бұрын
Depends how many departments you have. If there's only a few, you could use a simple line or clustered column chart. If there's a lot, then maybe sparklines.
@Winniebakerz
5 ай бұрын
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?
@MyOnlineTrainingHub
5 ай бұрын
That sounds very odd. I wonder if the dashboard sheet is protected? You're welcome to post your question and sample Excel file on our forum where someone can help you further: www.myonlinetraininghub.com/excel-forum
@nazarkamal8831
7 ай бұрын
How you wre able to do like dis !! This is incredible 💕
@MyOnlineTrainingHub
7 ай бұрын
Thank you so much 😀
@andinh8835
5 ай бұрын
Can I have the data sheet to practice? Thanks a lot!
@MyOnlineTrainingHub
5 ай бұрын
The link is in the video description.
@JohnYoo-ge6mn
4 ай бұрын
the interactive slicers does not seem to work when opened in the Mac version of Excel is there a fix for that
@MyOnlineTrainingHub
4 ай бұрын
There’s no reason why the slicers wouldn’t work on a Mac 🤔 they won’t work on an iPad, but a Mac should be fine.
@deedubdolphinsdialogue9058
5 ай бұрын
How can I put a map of the US in the dashboard and be interactive with a slicer?
@MyOnlineTrainingHub
5 ай бұрын
I cover that scenario in this video: kzitem.info/news/bejne/rpmCt2edfnmTe4Y
@BrendaSteyn
7 ай бұрын
Hi Mynda, I'm wondering if you have dashboards, pivot tables, etc. that are used with screen readers and would be accessible for people with disability?
@MyOnlineTrainingHub
7 ай бұрын
great question. I don't have anything specifically for this, sorry. I'm not sure how good Excel is at reading charts. You could always download one of my files and test it out.
@BrendaSteyn
7 ай бұрын
Thanks for your reply, I sincerely appreciate it. We've recently had some internal training regarding accessibility and well it's complicated. Nothing we do on a day-to-day basis will currently work. More chances to learn tho 👍
@chezza720
7 ай бұрын
Does this work if you are looking at median data for the month, not average?
@MyOnlineTrainingHub
7 ай бұрын
You can apply these techniques to any data. As for summarising median values, you could find the min, max, average or median of the medians 😊
@RhetoricalLanguage
7 ай бұрын
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
@MyOnlineTrainingHub
7 ай бұрын
Should be straight forward. Please post your question and sample Excel file on our forum where someone can help you further: www.myonlinetraininghub.com/excel-forum
@arfanrasheed9941
7 ай бұрын
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.
@MyOnlineTrainingHub
7 ай бұрын
I would use Power Query to unpivot those columns because your data needs to be in a tabular layout. See this video on unpivoting: kzitem.info/news/bejne/jn-D15-dbGeSl3Y
@arfanrasheed9941
7 ай бұрын
@@MyOnlineTrainingHub excellent video. But 1 thing is missing you didn't discuss multiple headers (more than two headers)
@MyOnlineTrainingHub
7 ай бұрын
I cover that here: kzitem.info/news/bejne/jn-D15-dbGeSl3Y
@user-fv9to3ip1k
5 ай бұрын
We need to know how to calculate a field. This is a great video but you skipped an important step = Values in the columns sections of pivot field. If you don't show that then no one is getting passed minute 7:50.
@MyOnlineTrainingHub
5 ай бұрын
The PivotTable calculates/sums the field/column when you check the box to include the field in the PivotTable. This data is already in the source table you see at 8:00 (see the column headers of the table are the same that you see in the PivotTable field list at 8:08). As I check the boxes to include the 'Total Calls', 'Calls Reached' etc. the PivotTable knows these columns/fields contain numbers to it automatically adds them to the Value fields area and sums them for me. All this is shown in the video. There are no hidden steps I do outside of the video.
@antoniocurri910
Күн бұрын
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
@MyOnlineTrainingHub
19 сағат бұрын
Hi Antonio, I answered this duplicate question on the blog page already. Please see my answer there.
@Wahj12345
2 ай бұрын
Can we do it by using jeda ai 😢
@MyOnlineTrainingHub
2 ай бұрын
Possibly, but AI is really only good for one off analysis. If you want to use the report again next month, it's more efficient and robust to build it in Excel or Power BI.
@Wahj12345
2 ай бұрын
@@MyOnlineTrainingHub Thank you so much 💓
@abdelkaioumbouaicha
7 ай бұрын
📝 Summary of Key Points: 📌 The presenter demonstrates how to create an interactive dashboard in Excel using fictional outbound sales call data. They follow three steps: cohesive design elements, analysis and visualization of metrics, and adding interactive elements for data exploration. 🧐 The presenter sets up the dashboard canvas, changes the color theme, and adds headings. They insert shapes for key performance indicators (KPIs), icons for metrics, and a slicer to filter data based on salesperson names. 🚀 The presenter formats the data as an Excel table, creates a pivot table for analysis, and adds number formatting and slicers for filtering. They also insert text boxes to display KPI values and labels, and format them accordingly. 🚀 The presenter creates pivot tables and column charts to visualize the data. They format the charts, add titles, and adjust the axis settings. They also add conditional formatting to highlight selected salesperson names in the KPI table. 🚀 The presenter demonstrates how to update the dashboard with new data by copying and pasting it into the data table and refreshing the dashboard. 💡 Additional Insights and Observations: 💬 "The dashboard is designed to analyze and visualize key metrics from fictional outbound sales call data." 📊 The presenter emphasizes the importance of cohesive design elements and visually appealing charts to create an informative dashboard. 🌐 The video provides a step-by-step guide and practical tips for creating an interactive dashboard in Excel. 📣 Concluding Remarks: The video offers a comprehensive tutorial on creating an interactive dashboard in Excel. By following the presenter's three-step process, viewers can learn how to design, analyze, and visualize key metrics effectively. The use of fictional sales call data makes it easier to understand and apply the concepts demonstrated in the video. Overall, this tutorial is a valuable resource for anyone looking to create informative and visually appealing dashboards in Excel. Generated using TalkBud
@MyOnlineTrainingHub
7 ай бұрын
AI is amazing, isn’t it!
@CaribouDataScience
7 ай бұрын
3 steps?
@MyOnlineTrainingHub
7 ай бұрын
1. Prepare your canvas 2. Analyse/visualise 3. Add interactive elements
@orhanozturk1183
7 ай бұрын
Broken link alert, i dont download
@orhanozturk1183
7 ай бұрын
Sorry ok
@MyOnlineTrainingHub
7 ай бұрын
Thought so 😉 hope you find it useful.
@MrLynch-ei4dc
7 ай бұрын
Awesome video lecture as always. Thank you. Also, will you marry me?
@MyOnlineTrainingHub
7 ай бұрын
Glad you liked it 🙏 I’m already married 😉
@sherifelgazar4089
6 ай бұрын
This is awesome! thank you for this
@MyOnlineTrainingHub
6 ай бұрын
Glad you liked it!
@marilubadillo8108
7 ай бұрын
Thanks very much
@MyOnlineTrainingHub
7 ай бұрын
You're welcome 😊
@shoppersdream
4 ай бұрын
Nice, Mynda! Thank You!
@MyOnlineTrainingHub
4 ай бұрын
Glad you liked it 🙏
@PareshGujarati
4 ай бұрын
Thank you very much for the in-detail explanation. Best explanation on dashboard so far.
Пікірлер: 171