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

[@MyOnlineTrainingHub]

❓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]

Nice ma'am

[@SergioAlejandroCampos]

Hi Mynda. I love your video editing.

[@MyOnlineTrainingHub]

Thank you so much! I must admit that I’ve outsourced it nowadays 🤫

[@SergioAlejandroCampos]

@@MyOnlineTrainingHub Well, you picked a good editor. But look, the essence of the video is you, that's what's important.

[@abumaramable]

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

[@MyOnlineTrainingHub]

Wow, thank you!

[@romeothehavanese]

Fantastic! Just what i was looking for!

[@MyOnlineTrainingHub]

Great to hear! 🙏😊

[@TP014563]

Last conditional formatting trick was new to me, very handy indeed! Thanks for sharing...

[@MyOnlineTrainingHub]

Glad you discovered something new 😁

[@liumahir]

@@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]

@@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]

@@liumahir yes, that function works better i think. fix the issue when you do not have anything selected in the slicer.

[@DiamondRock2]

Amazing work Mynda, thanks for all the effort ❣

[@MyOnlineTrainingHub]

Glad you enjoyed it! 🙏😊

[@mohamadkuk]

This is awesome! thank you for this

[@MyOnlineTrainingHub]

So glad you liked it! 🙏😊

[@shoppersdream]

Nice, Mynda! Thank You!

[@MyOnlineTrainingHub]

Glad you liked it 🙏

[@aliniosif13]

learned a lot, you're a star!

[@MyOnlineTrainingHub]

Awesome to hear 🙏😊

[@chrism9037]

Awesome dashboard Mynda!

[@MyOnlineTrainingHub]

Thanks so much, Chris 😊🙏

[@TheJoshtheboss]

Top quality content as usual! Excellent dashboard.

[@MyOnlineTrainingHub]

Glad you like it! 🙏

[@TheJoshtheboss]

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.

[@chevadamrepique1609]

I love your work! thank you so much!

[@MyOnlineTrainingHub]

So pleased it's helpful 🙏

[@sherylleduna5367]

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

[@MyOnlineTrainingHub]

Glad you enjoyed it! 🙏

[@vick3379]

Simply amazing! Thank you for sharing this with us

[@MyOnlineTrainingHub]

Glad you enjoyed it! 😁🙏

[@sseemm]

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]

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]

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]

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.

[@SothearithKONGMrMuyKhmer]

Thanks so much for this tutorial. 🥰

[@MyOnlineTrainingHub]

You are so welcome! 🙏

[@mcarvalhocarvalho1873]

Precious. Thanks.

[@MyOnlineTrainingHub]

Thanks so much 🙏😊

[@m2badri]

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]

Glad you like it! 🙏

[@mausiemoo]

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

[@MyOnlineTrainingHub]

So glad it was helpful!

[@awesh1986]

Awesome video as usual.

[@MyOnlineTrainingHub]

Glad you enjoyed it 🙏😊

[@fishingispleasure2232]

Thanks Mynda you made my day 😊

[@MyOnlineTrainingHub]

Glad I could help! 😊

[@michaelmaharlika8569]

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]

Glad you enjoyed it! 🙏😊

[@MaureenPesch]

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

[@MyOnlineTrainingHub]

Glad you liked it! 🙏😊

[@ScottTeenier]

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

[@MyOnlineTrainingHub]

Thanks for your kind words, Scott!

[@viksabharwal2811]

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]

Thanks for your kind words!

[@anillpatel]

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]

Thanks so much 😊

[@StoicLifeHackss]

i followed your video step by step for 4 hours and i got it right the first time😊😊...thank you very much

[@MyOnlineTrainingHub]

That's awesome to hear!

[@StoicLifeHackss]

@@MyOnlineTrainingHub appreciate you

[@infamousprince88]

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

[@MyOnlineTrainingHub]

Great to hear you found it helpful 😊

[@infamousprince88]

@@MyOnlineTrainingHub are dashboards and scorecards similar deliverables?

[@MyOnlineTrainingHub]

Yes.

[@PareshGujarati]

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

[@MyOnlineTrainingHub]

So glad you liked it 🙏

[@heinzthedutch]

awesome stuff again! greetings from the netherlands.

[@MyOnlineTrainingHub]

Welcome! Thanks for watching 😊

[@gamizuco]

You are simply amazing. Thank you!

[@MyOnlineTrainingHub]

Thank you too! 🙏

[@BasitDurodola]

Your creativity is TOP notch👍

[@MyOnlineTrainingHub]

Thank you so much 😀

[@ashishshiriskar123]

awsome job... simply superb

[@MyOnlineTrainingHub]

Thank you so much 😀

[@robloxellicuti6002]

SO good and very useful.🌹🌹🌹

[@MyOnlineTrainingHub]

Glad you think so! 🙏

[@yulinliu850]

Excellent!!!👍❤

[@MyOnlineTrainingHub]

Thank you! 😃

[@ems_emil2299]

This is Awesome! thank you.

[@MyOnlineTrainingHub]

Glad you like it! 🙏😊

[@tihomirhristov77]

Excelsia is a Wizard 💚👌🏻

[@MyOnlineTrainingHub]

😁🙏

[@soundaryasuresh1845]

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

[@MyOnlineTrainingHub]

Awesome to hear 😁

[@olaoyeolayinka5394]

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

[@MyOnlineTrainingHub]

Glad it helped 😊

[@tfortanvir1336]

Just super 😮

[@MyOnlineTrainingHub]

Glad you found it helpful.

[@hanisalehal-ssenai1431]

Thanks so much

[@MyOnlineTrainingHub]

My pleasure 😊

[@IamTheReaper911]

That dashboard is................ ........EPIC 😎

[@MyOnlineTrainingHub]

😅 wondered where you were going for a moment! Thanks so much 🙏😁

[@DavidKlenkFurniture]

This is great, thanks Mynda.

[@MyOnlineTrainingHub]

Glad you liked it!

[@محمدعلي-ف7خ2ر]

last trick is amazing

[@MyOnlineTrainingHub]

Glad you liked it!

[@shannaandersonzongo8128]

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]

Wonderful to hear you'll be able to make use of it and save a load of money 😁

[@saadaljohani6565]

Thank you so much ❤

[@MyOnlineTrainingHub]

You're welcome 😊

[@EnmostMashcom]

Superb video. Kindly share one for sales vs purchases and usage. Thank you.

[@MyOnlineTrainingHub]

Thanks so much! Will keep your suggestion in mind.

[@MrDhunpagla]

Amazing 😊

[@MyOnlineTrainingHub]

Thanks so much 😊🙏

[@Shaft0]

Good to see you fixed the account issue 👍

[@MyOnlineTrainingHub]

Yeah me too 😅

[@Magiczone-tv]

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

[@alandrewgibson]

Wow thanks!

[@MyOnlineTrainingHub]

Welcome! 😊

[@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]

Hi Antonio, I answered this duplicate question on the blog page already. Please see my answer there.

[@aprilirvin4216]

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]

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: kzbin.info/www/bejne/j4CmXqN7ftp7pqM Here's the PivotTable video: kzbin.info/www/bejne/rILPd5yCisaqas0 Here's the Conditional Formatting video: kzbin.info/www/bejne/iKvdaoOvm9ycjLM

[@robertchetty5880]

Hi would you be so kind to produce a demonstration of dashboard containing trajectory chart in percentage please. Thank you for your help

[@MyOnlineTrainingHub]

Perhaps this is what you're after: www.myonlinetraininghub.com/excel-project-management-burn-down-and-burn-up-charts

[@UstedTubo187]

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]

Great to hear. This video explains conditional formatting in more detail and will answer your question: kzbin.info/www/bejne/iKvdaoOvm9ycjLM

[@UstedTubo187]

@@MyOnlineTrainingHubNice! Thanks for sharing that Mynda!

[@UstedTubo187]

@@MyOnlineTrainingHubFollow up. Just watched the video you shared. You explained it perfectly, as usual. Thanks again Mynda!

[@chenheyuan87]

Hi, could you guide me on how to rename the column header so that the updates are reflected on the dashboard.. I tried changing it but the data went missing in the graph

[@MyOnlineTrainingHub]

If you change the column header, you have to rebuild the PivotTable that used the previous column header. This will then update the chart.

[@vtanz]

Could you please create a simple project gantt chart. Thanks

[@MyOnlineTrainingHub]

Like this: kzbin.info/www/bejne/d3_dg6NjrpKcjZo or a project management dashboard with Gantt chart like this: kzbin.info/www/bejne/a6LXhJyliaplrbs

[@mamunahmed892]

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]

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.

[@BrendaSteyn]

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]

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]

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 👍

[@andinh8835]

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

[@MyOnlineTrainingHub]

The link is in the video description.

[@sveachristensen1796]

Love your videos, thank you. When you mention a special, could you please add the year that the specials are good for in the video, that way if we're watching this in 2025, we know we passed the special. 😊Thank you.

[@MyOnlineTrainingHub]

Great idea, will keep this in mind!

[@Sanja1234-y5e]

Hi dear can you do a video for simple book keeping

[@MyOnlineTrainingHub]

Thanks for the suggestion.

[@b326yr]

Please do an inventory management dashboard

[@MyOnlineTrainingHub]

Thanks for the suggestion.

[@deedubdolphinsdialogue9058]

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

[@MyOnlineTrainingHub]

I cover that scenario in this video: kzbin.info/www/bejne/g5SvgmadeqyVfrM

[@RhetoricalLanguage]

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]

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

[@Winniebakerz]

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]

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

[@chezza720]

Does this work if you are looking at median data for the month, not average?

[@MyOnlineTrainingHub]

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 😊

[@JohnYoo-ge6mn]

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

[@MyOnlineTrainingHub]

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.

[@arfanrasheed9941]

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]

I would use Power Query to unpivot those columns because your data needs to be in a tabular layout. See this video on unpivoting: kzbin.info/www/bejne/Y3qwop6daJqUmqM

[@arfanrasheed9941]

@@MyOnlineTrainingHub excellent video. But 1 thing is missing you didn't discuss multiple headers (more than two headers)

[@MyOnlineTrainingHub]

I cover that here: kzbin.info/www/bejne/Y3qwop6daJqUmqM

[@nazarkamal8831]

How you wre able to do like dis !! This is incredible 💕

[@MyOnlineTrainingHub]

Thank you so much 😀

[@user-fv9to3ip1k]

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]

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.

[@karaholliday185]

I’m making sure the outer text box is selected and doing everything you said but it’s not putting a value in the text box. It looks like it accepts the formula but the text box remains empty what am I doing wrong?

[@MyOnlineTrainingHub]

The text box will only accept a reference to another cell. You cannot put a formula in the formula bar, so maybe that's the problem...or maybe the text in the text box is white, and you cannot see it? If you're still stuck, post your question and sample Excel file on our forum where someone can help you further: www.myonlinetraininghub.com/excel-forum

[@abdelkaioumbouaicha]

📝 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]

AI is amazing, isn’t it!

[@viksabharwal2811]

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]

Thank you. As usual, the file link is in the video description. 😉

[@viksabharwal2811]

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]

I think the link was missing. It's here: bit.ly/3-step-dashboards

[@Sanja1234-y5e]

Can we do it by using jeda ai 😢

[@MyOnlineTrainingHub]

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.

[@Sanja1234-y5e]

@@MyOnlineTrainingHub Thank you so much 💓

[@CaribouDataScience]

3 steps?

[@MyOnlineTrainingHub]

1. Prepare your canvas 2. Analyse/visualise 3. Add interactive elements

[@steven.h0629]

👍😎✊

[@MyOnlineTrainingHub]

🙏😁

[@orhanozturk1183]

Broken link alert, i dont download

[@orhanozturk1183]

Sorry ok

[@MyOnlineTrainingHub]

Thought so 😉 hope you find it useful.

[@tanveerabbas3271]

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

[@wardsmaill8973]

😝 Promo'SM

[@MrLynch-ei4dc]

Awesome video lecture as always. Thank you. Also, will you marry me?

[@MyOnlineTrainingHub]

Glad you liked it 🙏 I’m already married 😉

[@sherifelgazar4089]

This is awesome! thank you for this

[@MyOnlineTrainingHub]

Glad you liked it!

[@marilubadillo8108]

Thanks very much

[@MyOnlineTrainingHub]

You're welcome 😊