Download file used in the video with step by step instructions and links to more tutorials:

In this video you will learn how to create an interactive dashboard from scratch using the built in Excel tools. No add-ins or VBA/Macros. Just plain Excel.

Applies to Excel 2007 onward for Windows & Excel 2016 onward for Mac.

Subscribe to my free newsletter and get my 100 Tips & Tricks eBook here:

Nguồn:https://madisonrep.org/

35 Comments

Ken Heinz

February 15, 2020

Wow. I'm an excel novice….you make it look so easy, and I could follow along quite well. You're quite a good instructor. I look forward to seeing more. Thanks for the hard work you obviously have put into your craft…it's inspirational.

Reply

Owley _09

February 15, 2020

OMG. This is really helpful!!!!!! Ilove you already!!!

Reply

Russell Swats

February 15, 2020

But I don't see PivotChart in my Excel on my office PC. Can I do all of this without PivotChart?

Reply

cambike

February 15, 2020

Tip – Use powerbi instead

Reply

Krishna Mogulluri

February 15, 2020

Well done!
I have a query on slicer. Can I restrict the items selection ability on slicer by setting up items as radio buttons? Thank you.

Reply

Martin G Osburn III

February 15, 2020

Excellent video. Thank you!

Reply

Zamasomi Msomi

February 15, 2020

Aaamazing 👍

Reply

Joseph Lagadon

February 15, 2020

wow, that's wow. thanks a lot

Reply

Noel Colon

February 15, 2020

WOW……that’s amazing new subscriber!

Reply

shuihuai lui

February 15, 2020

good english!!

Reply

Dawn P

February 15, 2020

This was outstanding! Thank you so much for the great webinar. It was comprehensive, easy to follow along and you provided enough detail that the end-user can immediately walk away and start applying the tips that were shared. Thank you very much!!

Reply

chimchim

February 15, 2020

Omgg thank youu. But i have just a littttle question: Can we transfer the final excel dashboard to be on a web page? If yes how. That it keeps updating automatically

Reply

Fatima Rodriguez Fernández

February 15, 2020

Amazing ! very useful! great and simple tutorial 🙂

Reply

Nathan Winslow

February 15, 2020

A lot of affordable and even free crm solutions have cropped up that offer similar kinds of dashboards without the hassle of learning excel. So, what’s the value in knowing excel in 2020 and beyond?

Reply

constantineprime

February 15, 2020

what did the pie chart do yo you??

Reply

Eman khalaf

February 15, 2020

Thank you so much.i have followed your steps on my data and it really works.one question please I hope you answe me, I have pasted new data to the original sheet but it was not reflected in the dashboard.what I should do?

Reply

Nagaraju D

February 15, 2020

Thanks for your efforts in putting valuable inputs …

Reply

Chao Peng

February 15, 2020

You rescue my career! Thank you very much! (From China)

Reply

Alok Ghosh

February 15, 2020

Fantabulous tutorial…

Reply

ACTUARIAL CLASS OF 2017

February 15, 2020

Thanks so much for this… you have been of great help

Reply

Ananda Van der Westhuizen

February 15, 2020

Thank you so much!

Reply

Karina XW

February 15, 2020

This way of illustrating the result is so much more clever. Thanks so much. I'm addicted to your channel.

Reply

FLjock01

February 15, 2020

This is an incredibly valuable tutorial. Thank you!

Reply

Francisco Mora

February 15, 2020

Thanks Mynda, excellent tutorial.

Reply

Incredible Photo Stories

February 15, 2020

Great video! Where can I download this example in Excel.

Reply

Ram Krishna

February 15, 2020

How to build Interactive Excel Dashboards, Thank you so much for showing how to build a dashboard in Excel. I managed to follow your presentation while I build exactly same Excel Dashboards with different sets of data. YOU ARE DOING A GREAT JOB!!!

Reply

Excel Visual

February 15, 2020

Excellent

Reply

Nick Issaev

February 15, 2020

Excellent tutorial! Thank you for sharing!

Reply

Akram Maad

February 15, 2020

Wow what a useful tutorial , thank you

Reply

Matthew Garcia

February 15, 2020

I enjoyed learning from your video – it is highly informative and simple to grasp…definitely will help me demonstrate my proficiency in Excel for my portfolio… Thank You

Reply

Jerin Jose

February 15, 2020

Thank u for this video and nice presentation..God bless

Reply

Peter H. Koller

February 15, 2020

Good morning, I am looking for a spreadsheet that can do the following. I have 20 field service technicians installing cameras into trucks, some installations can take 2 hours and some 8 hours depending on what the customer requires. I could have a technician doing 3 installations taking 2 hours each = 6 hours for the day another technicians doing one installation taking 8 hours and anything in between is also possibility. I need to determine technician utilization, based on jobs done per day/week/month/quarter and year. Having a good visual dashboard and graphs would be great. I hope you can assist me. Regards Peter email: [email protected]

Reply

meenakshi chakravarty

February 15, 2020

Hello, Could you show us how we could insert buttons saying 'chart' which shows the charts & 'table' which would show the numbers in a tabular format for the same set of data

Reply

Jeff Wang

February 15, 2020

Thanks Mynda! This is the best Excel teaching video I have seen.

Reply

Wrickey Nelson

February 15, 2020

Thanks, enjoy this much

Reply

Leave a Reply