Create an Interactive Excel Dashboard In Under 3 MINUTES!

In this Interactive Excel Dashboard tutorial you will learn how to use & create an Excel Pivot Table and Interactive Excel Dashboard for Beginners or Advanced users. Download the Practice Excel Workbooks 👉www.myexcelonl...
This Excel Dashboard tutorial can be created in Excel 2010, Excel 2013, Excel 2016, Excel 2019 or Office 365 !
Within 3 MINUTES you will learn how to create an Interactive Excel Dashboard using Excel Pivot Tables, Slicers & Pivot Charts.
Download the Practice Excel Workbooks 👉www.myexcelonl...
------------
🔥 OUR BEST EXCEL RESOURCES 🔥
👨‍🏫 Get 30+ Excel & Office Courses & support for ONLY $1💵 (all levels covered)
Learn Formulas, Macros, VBA, Pivot Tables, Power Query, Power Pivot, Power BI, Charts, Financial Modeling, Dashboards, Word, PowerPoint, Outlook, Access, OneNote, Teams, Project, PowerApps, PowerAutomate, Visio, Forms & MORE!
Join Now for ONLY $1 (LIMITED TIME OFFER) 👉 www.myexcelonl...
📚 Download Our Free 101 Excel Tips & Tricks E-Book:
Download for FREE 👉www.myexcelonl...
💻 Access 1,000+ Free Excel & Office tutorials over at our award-winning blog:
Access for FREE 👉www.myexcelonl...
📚Get All Our 101 Excel E-Book series on Formulas, Macros & Pivot Tables:
www.myexcelonl...
📚101 Most Popular Excel Formulas Paperback on Amazon:
www.amazon.com...
📚101 Ready To Use Excel Macros Paperback on Amazon:
www.amazon.com...
📚101 Best Excel Tips & Tricks Paperback on Amazon:
www.amazon.com...
👷 Excel Consulting Services:
www.myexcelonl...
💻 Looking for more Microsoft Excel & Office tutorials? Check out our playlist below:
www.youtube.co...
------------
Feel free to comment and ask questions about this Microsoft Excel tutorial below and we will get back to you with the answer ASAP!
If you enjoyed the video, please give a thumbs up, comment, share.
Do not forget to SUBSCRIBE to this channel to get our new Microsoft Excel tutorials delivered straight to you each week! Thank You :)
Cheers,
JOHN MICHALOUDIS
Chief Inspirational Officer & Microsoft MVP
www.myexcelonl...
❤️ Let’s connect on social ❤️
LinkedIn: / johnmichaloudis
Instagram: / myexcelonline
Pinterest: / pins
Facebook: / myexcelonline
Twitter: / myexcelonline
#MyExcelOnline #MsExcel #Dashboards

[@janewells6112]

A great “taste” of dashboards and pivot tables, helped me get a basic (very basic) understanding of them & possibilities they may offer. Thanks, it was fun.

[@MyExcelOnline]

Great to hear! Love that you were able to expand your Excel skills!

[@AmazingAnwar]

no useless talks on point fast simple salute bro

[@MyExcelOnline]

Thank you!

[@2000sunsunny]

Thank you for your speed for 3 min dashboard. Anyway I put the video in slow motion and completed in 20 min :)

[@MyExcelOnline]

Nice work!

[@hassanjadeedi69]

This was amazingly summarized- well done you just make my day. Many thanks

[@MyExcelOnline]

My pleasure!

[@Alastair-ix8pz]

Brilliant video. Thank you so much! Finally managed to build my first interactive Excel dashboard with slicers. You're a star👍

[@MyExcelOnline]

Fantastic! So glad we were able to help!

[@nutella_drifter]

I have been working with slicers for a while and I had no idea they could be assigned to any (or all) pivot tables in the file. Thanks for the hint and the excellent tutorial.

[@MyExcelOnline]

Glad you enjoyed it! You can have multiple Slicers from the same data source which can control your Pivot Tables and Pivot Charts!

[@vijayarjunwadkar]

3 cheers for 3 minutes dashboard! Thanks for this quick and very useful video! 😊👍

[@MyExcelOnline]

So glad it was helpful!

[@sagarpanchal624]

You did well job. But people are not come here in Rush to learn something, explain to them in easy way that they can understand.

[@MyExcelOnline]

Thanks for the feedback. Glad you liked it.

[@madonnacullinan8286]

Very helpful. Will use this in my current projects for work and give me something to learn and do in COVID lockdown which we are currently in a snap lockdown. thank you for your generosity in making it free too, cheers!

[@MyExcelOnline]

Glad it was helpful! Continue on learning!

[@acoba8352]

Hey Madonna...having gained some excel skills and in real need of enhancing them through experience. How would you advice me on getting excel tasks?

[@aliunal4584]

Congratulations. Hello from Turkey.

[@MyExcelOnline]

Thanks and welcome

[@divyakanchi5773]

You cleared my doubts easyly in slicer report connection.. Felt like God... Thank you..

[@MyExcelOnline]

Happy to help! Glad you got it to work. Thanks for letting us know.

[@ExcelTutorials1]

This guy practiced making this a few times before he recorded. lol. For real though, awesome video!! I love the approach that you take!

[@MyExcelOnline]

So glad you liked it and you find it to be easily understandable. It is hard to get it succinctly on the first try!

[@titifash74]

Bravo!!!! Awesome, now let me get on with my Dashboard building i have no excuses

[@MyExcelOnline]

Go for it! Thanks for watching.

[@ahsan4510]

I also made my dashboard after watching this video. Thanks

[@MyExcelOnline]

Oh, that's great 👍

[@nishantshaliwan1193]

You nailed it bro Superb 👏👏👏👏👏

[@MyExcelOnline]

Thank you so much 😀 Thanks for watching and taking the time to comment.

[@Abaaaaaaaaaaaa]

Thank you for teaching me. I needed this for my work.

[@MyExcelOnline]

You are so welcome! Glad you learned something.

[@aladinzahran]

Great presentation, awesome work. I learned a lot and I am doing my own dashboard. Thanks

[@MyExcelOnline]

That's awesome to hear Aladdin and keep on EXCELling!

[@fitnessturtle959]

This video saved my internship

[@MyExcelOnline]

Nice! So much of learning technical skills is learning how to find the answer. Glad you found us.

[@phoenixsilverman1616]

Excellent job

[@MyExcelOnline]

Thank you! Cheers!

[@sakariyeali9364]

it is amazing, thank you so much. I was thinking first time that dashboard is difficult I learned bacause of you

[@MyExcelOnline]

So glad we could help! Thanks so much for watching!

[@prasadnutalapati4392]

simply excellent and awesome eplanation

[@MyExcelOnline]

Glad you liked it! Thanks for watching.

[@nani60fpsvideos35]

EXCELLENT WORK !!!!!!!!! THANK YOU .

[@MyExcelOnline]

Our pleasure! Glad you liked it!

[@fantamadydoumbouya1526]

You are the best ever

[@MyExcelOnline]

Awwww, thank you! So glad you like our channel.

[@ayahadhichannel614]

great presentation .sir

[@MyExcelOnline]

Thank you!

[@piyushrajmishra]

fast and informative.

[@MyExcelOnline]

Glad you think so!

[@veenasingh6489]

Big thanks buddy

[@MyExcelOnline]

Any time!

[@rendibramantoro9364]

Awesome! Thanks for share, i will try this tutorial, but i think i can't make it 3 minute in 1st time :D

[@MyExcelOnline]

Please let us know if you have any questions when you are able to watch more.

[@subirchatterjee1937]

i learned a lot! thanks..

[@MyExcelOnline]

Glad to hear it! You are welcome.

[@gilleric77]

Great so quickly

[@MyExcelOnline]

Glad you liked it!

[@bijaymuduli1171]

Superv sir. You just see it in 5 minutes......

[@MyExcelOnline]

Thanks for watching!

[@notacontentprovider]

Brilliant, thank you. Although this is an old video, it is still relevant today and is just what I need for an end-of-year report.

[@MyExcelOnline]

Glad it was helpful!

[@MyExcelOnline]

Yes! Some of Excel's functionality is pretty timeless in its usefulness.

[@oanphong61]

Thank you!!

[@MyExcelOnline]

You're welcome! Thanks for watching!

[@crackcompetitiveexams7]

Thanks a lot brother , best video so far

[@MyExcelOnline]

Most welcome. Thanks for watching!

[@ykBaffa]

Thank you chief, bravo!!!

[@MyExcelOnline]

You're welcome!

[@hassanmohammed7308]

Thanks

[@MyExcelOnline]

No problem

[@hedger48]

thanks, i'm making my chart bars specific colors but whenever i change the slicers, the colors revert back to standard. can you help?

[@MyExcelOnline]

Are you using Excel 365? Maybe try saving right after you change them?

[@glo007]

Brilliant!

[@MyExcelOnline]

Thanks! Glad you liked it!

[@ibrahemarafa4444]

EXCELLENT EXPLINATION

[@MyExcelOnline]

You are welcome and I hope you learned the power of using Pivot Tables!

[@petermckenzie5124]

Incredible 🎉 are you Jedi..?

[@MyExcelOnline]

HAHA. No... Glad you liked it.

[@777you7tube]

It's a great video thank you so much. I have one question, can you please help - in Slicer: report connection, I am unable to see all three pivot tables. It's only showing one or in another slicer, it is showing 2 pivot tables.

[@MyExcelOnline]

Make sure that the Pivot Tables are created from the same data source, or else you cannot connect them.

[@user-tb4ug7yf4y]

hi i use excel 2013 and the slicer-options are greyed-out. What do i have to do to activate them? great tutorial by the way

[@MyExcelOnline]

+‫אבי לוי‬‎ You will first need to create a Pivot Table and then you need to click inside the Pivot Table and go to PivoTable Tools > Analyze > Insert Slicers. Thanks, John

[@vaibhavmagare1588]

Thank you

[@MyExcelOnline]

You're welcome! Thanks for watching.

[@jagdishparikh2766]

incredible , you have shown very easy way to create dash board in short time

[@MyExcelOnline]

+Jagdish Parikh Excel is easy Jagdish! Thanks, John

[@jodibur7418]

Thanks...

[@MyExcelOnline]

Im glad you liked this Excel Dashboard tutorial Jo!

[@vikramraghuwanshi9455]

Briliant bro.

[@MyExcelOnline]

Thanks!

[@hekimaambangile2512]

This is amazing

[@MyExcelOnline]

Thank you!

[@OzduSoleilDATA]

NICE ONE!

[@MyExcelOnline]

+Oz du Soleil Cheers Oz!

[@deadlyslayer3251]

Hopefully learned a lot from you

[@MyExcelOnline]

Glad to hear that!

[@piyushbhade8160]

Love this video...

[@MyExcelOnline]

Thank you! So glad you watched it!

[@Zelduh.]

This satisfies my OCD

[@MyExcelOnline]

HAHA! Glad we could provide that service.

[@muhammadbilal3900]

Excellent

[@MyExcelOnline]

Thank you! Cheers!

[@bharathgowdajr8911]

Awesome Superb

[@MyExcelOnline]

Thanks!

[@Wacc1611]

Is there anyway to get slicer option in excel 2007? btw nice video...

[@MyExcelOnline]

Hi. Thanks for the question! You could try this: Insert a new column in your spreadsheet and enter the name “Slices” for this field. Open up the ribbon at the top of Excel and click on Data > More Conditional Formatting Options ー> New Item Type > Columnar report with list slices that will be automatically saved as part of your workbook when you save it ().

[@MyExcelOnline]

And glad you liked the video!

[@emmanuelibanga8238]

God bless you!!

[@MyExcelOnline]

God bless you as well!

[@Jay-so8se]

Great video. Is there any way to do this using live data with auto refresh capabilities

[@MyExcelOnline]

Thanks for watching! If you go under Data and then click the arrow next to Refresh All there is an option for Connection Properties. In there is a setting you can change to refresh data every x minutes.

[@christinembuti9318]

Wow! Great. Wish to learn more.

[@MyExcelOnline]

More to come!

[@AdeKaryadi]

Nice tutorial, thanks

[@MyExcelOnline]

Glad you enjoyed this Excel Dashboards tutorial

[@AdeKaryadi]

@@MyExcelOnline Thank you very much

[@arun4846]

Superb ❤️❤️❤️

[@MyExcelOnline]

Thanks 🤗

[@zee.khan86]

Amazing!

[@MyExcelOnline]

Thank you! Cheers!

[@EdSongoku]

Could you have just copied the pivot table to another cell and just chosen other fields?

[@MyExcelOnline]

Thanks for the good questions and for watching! There are often more than one way to do things in Excel.

[@Cris-hk4cn]

Excellent presentation. Thanks

[@MyExcelOnline]

You are welcome!

[@sa5er1234]

I have a question, when I am updating the data base with fresh raw data (Same format), the pivot table & chart are not being updated. I have to redo the whole thing again every time I get new data. Any advise?

[@MyExcelOnline]

Yes. If you click in the top left cell of the Pivot Table, you can right click and hit Refresh. Hope that helps.

[@LoveLife-xv9bz]

Wait how did you insert timer? Awesome presentation!!

[@MyExcelOnline]

Thank you! It's not inserted, it's an app.

[@stephencyriltan4212]

thanks Boss

[@MyExcelOnline]

Any time

[@efratav1]

excellent. a tutorial should be 3 to 5 mins. good job

[@MyExcelOnline]

You are welcome Francis & feel free to share this Excel tutorial with your friends & colleagues :) Cheers, John

[@parameshparam5197]

Hi I have 10 delivery associates ( each have 40 to 60 shipments) and I want to automatically track their delivery attempts and rejects and delivered shipments for every hour can you please do the video on that

[@MyExcelOnline]

Hi Thanks for the request. I would recommend keeping track of every deliver and its status, so your columns would be associates, date, time, and status. And then you could use a pivot table to calculate the metrics you are looking for. We have more on Pivot Tables here: kzbin.info/aero/PLWSweFpA2PEgMcjQK_v2irmLaNS9BfLc2 Hope that helps! If not, please feel free to comment again on anything missing.

[@sniperking7555]

Wow! It's so helpful.thank you

[@MyExcelOnline]

So glad you liked it!

[@rubenestrada669]

LEGEND! wow this was impressive!

[@MyExcelOnline]

Thanks!

[@fsm6426]

Great, very useful! Thanx 👍👍👍👍

[@MyExcelOnline]

You are welcome!

[@nidhal7184]

Does such tools available on EXCEL 2007 ?

[@MyExcelOnline]

It's hit or miss on tools going back that far to 2007. Sorry. There is a free version of Excel at office.com if you would like to try that one.

[@gauravbatra5532]

Excellent tutorial 👍🏻 but Can’t find the link to download the spreadsheet. It only has ebook(pdf) to download.

[@MyExcelOnline]

You can use this link to download our examples files: www.myexcelonline.com/excel-pivottable-course-workbooks-download-yt

[@jerrymiles7804]

Outstanding!

[@MyExcelOnline]

Thank you! Cheers!

[@anicitapinto1143]

What are the basic skills required to create dashboards

[@MyExcelOnline]

We have a video on that! kzbin.info/www/bejne/oqm5lYyoecujh6M

[@arpandoshi9878]

Excellent 👍👍

[@MyExcelOnline]

Thank you! Cheers!

[@saranidissanayake9030]

Wow excellent job. easy and quick instructions.

[@MyExcelOnline]

You are welcome Sarani!

[@matklategunungganang5648]

great..great..

[@MyExcelOnline]

Thanks!

[@bhavneshparikh8283]

Can be available only receivable deshboard in excel? Pl share it

[@MyExcelOnline]

We have a whole dashboard series going on right now so check out the past few weeks and continue to watch for more!

[@abulatinchrist2754]

Amazing tutorial, Sir. First time watch and subscribe.

[@MyExcelOnline]

Thank you and I hope you learned lots from this Excel tutorial!

[@msbutterfly714]

I mean I like that your keeping it going but that was a little too fast haha. You are knowledgeable so slowing down a bit would be great. THank you

[@MyExcelOnline]

Thanks for your feedback. We are trying to slow down future videos. This one is a little older. Could I recommend watching this one on half speed? You can change the settings in KZbin when watching.

[@chenupy77]

Wow No words , Thanks for the info

[@MyExcelOnline]

Glad you enjoyed it 👍

[@vikramraghuwanshi9455]

Hey bro do you have any practise vedios , or file son on vlookup ?

[@MyExcelOnline]

Yes we do! Check out our playlist here: kzbin.info/www/bejne/aHKwhpipoq-XpLc

[@puresoul8690]

right from the first screen shot that appears of the Excel sheet, we have 2 tabs already there..Data I can understand but where do you get that 'Dashboard' sheet in there..? Please let me know..!

[@MyExcelOnline]

Hello, This is a normal Sheet and then I double clicked to rename it to DASHBOARD. I hope this is what you were after. Thanks, John

[@belindamano5550]

Love this !Good job !!

[@MyExcelOnline]

So glad you liked it!

[@musicalwanderings7380]

That was fun and informative!!! Cool!

[@MyExcelOnline]

Glad you enjoyed it! We love it when people have fun learning Excel because we think it is a lot of fun as well.

[@tashadeluca]

Wow this was so helpful!! Thank you

[@MyExcelOnline]

Glad it was helpful!

[@muhammedfaseed6102]

How did you make the dashboard displayed on this video

[@MyExcelOnline]

We have a pivot table and dashboard playlist here. Check it out! kzbin.info/aero/PLWSweFpA2PEgMcjQK_v2irmLaNS9BfLc2

[@Soulenergy31]

Outstanding!!!! Jon

[@MyExcelOnline]

Saul Espinoza Thanks Saul, I'm glad you enjoyed it :)

[@natmze]

Wow. Thank you thank you

[@MyExcelOnline]

You are welcome 🙏

[@johnsagayaraaj5249]

Super buddy I hear the sound of confidence in this AV. COOL.

[@MyExcelOnline]

Glad you enjoyed our Excel tutorial Serell!

[@joe.mariannetargonski8997]

Awesome!

[@MyExcelOnline]

+Joe.Marianne Targonski Glad you liked it! Cheers, John

[@manzurekhoda7013]

Thanks mate! very helpful...

[@MyExcelOnline]

You are welcome Manzur!

[@danmilan2410]

How do I create a blank space for my dashboard?

[@MyExcelOnline]

Hi Dan. Are you referring to the background for the sheet to be all white without gridlines? If you go to the View ribbon, you can take the gridlines off as well as the column headers.

[@gargijain3800]

Is it necessary that there is only one data table? I mean, can we connect slicers from different data tables?

[@MyExcelOnline]

You cannot connect slicers from different data tables

[@gargijain3800]

@@MyExcelOnline Thanks a lot for this wonderful video.

[@MyExcelOnline]

You are welcome Gargi 😀

[@martinmarmol6999]

Love this video and your podcast. I can start applying it now to a project I have at work. Thanks!

[@MyExcelOnline]

+Martin Marmol Thanks for your kind words and I am glad that you like my material :) Cheers, John

[@zachariahemanuel4017]

I realize I'm pretty randomly asking but does anyone know of a good site to stream new movies online?

[@ariesgregory1072]

@Zachariah Emanuel Flixportal :)

[@zachariahemanuel4017]

@Aries Gregory thank you, I signed up and it seems to work :D I really appreciate it !!

[@ariesgregory1072]

@Zachariah Emanuel No problem :D

[@MyExcelOnline]

💻Access 1,000+ Microsoft Excel video training tutorials covering Formulas, Macros, VBA, Pivot Tables, Power Query, Power Pivot, Power BI, Charts, Financial Modeling, Dashboards, Word, PowerPoint, Outlook, Access, OneNote, Teams & MORE! JOIN TODAY TO ADVANCE YOUR EXCEL SKILLS 👉 www.myexcelonline.com/107-42.html

[@randomgaming7287]

does anyone know which dataset is this

[@Fal01100]

Hi ..i am really enjoying your video...Please i need help ..actually i want to know that for example i have a grocery store and i want to make a spread sheet that automatically tell me remaining items in my store ....means if i have 50 boxes and 1 day they are sold 3 ,then 2 ,then 4..so i want result that automatically give me result 48 -3=47-2=45-4=41 plz help

[@MyExcelOnline]

In one cell put your starting boxes. Then have a row of cells with the dates and next to that enter the boxes that get sold. Then have another cell with a formula that deducts the starting boxes cell with the range of all the dates that have the “sold” cells!

[@Fal01100]

@@MyExcelOnline Thank u soooooo much for ur reply....my problem is solved. thanks a lot

[@MyExcelOnline]

You are welcome Mobi 😀

[@sanjaydesai8263]

Great Sir can i get template?

[@MyExcelOnline]

Yes, sure. Sign up on our website here: www.myexcelonline.com/

[@mikkamon]

Mind blown

[@MyExcelOnline]

Glad you learned!

[@inception2084]

Useful👌👌

[@MyExcelOnline]

Glad to hear that