Building Excel Dashboards doesn't need to be a slow process. When your data is structured correctly you can use the built in tools (that you probably already know), to build dashboards super fast. Let me show you how in the video below.
Download Workbook
Enter your email address below to download the sample workbook.
By submitting your email address you agree that we can email you our Excel newsletter.
Please enter a valid email address.
Download the Excel Workbook and follow along. Note: This is a .xlsx file please ensure your browser doesn't change the file extension on download.
Excel Dashboard Course
Now you know how quick and easy it can be to build Excel Dashboards, let me show you a load more techniques for building sophisticated reports that your employer will love. Take your skills to the next level with my Excel Dashboard course.
Power BI Organizational Data Types in Excel
Bonnie
Excellent video! I only had one issue and that was with the category slicer. Clicking on Accessories, Bikes, etc., the individual colors by category turned to blue (lines/columns) in all four charts instead. If all categories on the slicer are selected, the proper colors appear.
Mynda Treacy
Hi Bonnie,
This is a Pivot chart limitation. If you want specific colours to be retained when you filter using a Slicer, then you need to build a regular chart from a PivotTable.
Mynda
Matthew Lusk
Great video and I have subscribed to your channel. Thanks Mynda.
Matthew Lusk
Always good learning material. Thanks Mynda.
Mynda Treacy
Glad you liked it, Matthew! And great to have you as a subscriber to our channel 🙂
BRAHIM
Excellent video, Thanks,
Mynda Treacy
Our pleasure 🙂
Oksana
Hi Mynda,
This is an excellent video! Amazing! It’s gonna take me way more than 15 minutes but I’ll get it done.
I have a question: What if you needed to retrieve the data you have on the “Data” tab from an Internet source and update it periodically? How would you approach this task? Thanks!
Mynda Treacy
Glad you liked it, Oksana! To automate the gathering of data from the web, you can use Power Query: https://www.myonlinetraininghub.com/get-data-from-the-web-with-power-query
Laurence Rockwell
Excellent video. Well presented. Good idea to watch first then down load the example Excel file and try to replicate the process. My challenge: I am running build 14026.20270 and the slicer settings function in the ribbon is greyed out. How do I enable the slicer settings or for that matter any greyed out function? I purchased this copy of Excel with my computer. I keep getting this error message: “Your organization’s administrator turned off the service required to use this feature.”
Mynda Treacy
Thanks, Laurence. Have you tried accessing the Slicer settings via the right-click button on the Slicer?