From the course: Excel PivotTables: Mastering PivotTables and PivotCharts

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Designing interactive dashboards

Designing interactive dashboards - Microsoft Excel Tutorial

From the course: Excel PivotTables: Mastering PivotTables and PivotCharts

Start my 1-month free trial

Designing interactive dashboards

“

- [Instructor] All right, so we've covered quite a bit in this section. We've inserted a number of different pivot table views, built out different types of charts, and practiced adding slicers and timelines. And that's all great, but things do still look a little bit messy and disorganized here. So in this lecture, I'd like to demonstrate how we can take all of these elements that we just learned and combine them into a clean, dynamic, and powerful user-facing dashboard. Now keep in mind that there are a number of different ways to approach dashboard design, and there really are no right or wrong answers. So, what I'm going to do is show you some of my personal tips and tricks, and you can either follow along exactly or use them as a direction to help create your own modified approach. So in this case, my first step will be to adjust the properties of all of my elements, all of the charts, plus my slicer and timeline. And I can do this in one fell swoop by Control + selecting all of…

Contents