From the course: Excel Data Visualization: Designing Custom Visualizations

Unlock this course with a free trial

Join today to access over 22,400 courses taught by industry experts.

Building a dynamic dashboard, part 1

Building a dynamic dashboard, part 1

- [Instructor] The next two demos are all about building dynamic dashboards. And that's a really hot topic in Excel because it requires you to tie together a number of different skills. You have to use formulas and functions to dynamically pull in the right pieces of your data. You have to use charts and graphs to visualize your data in meaningful way. And you have to combine all that to essentially transform a raw dataset into a clean and interactive user interface. So in the Dynamic Dashboard tab, I've built out a simple framework for Dashboard that we're going to start populating. And if you check this little plus box up here above Column Q that will actually reveal the raw data which at this point lives in Columns A through P. And just if you're curious about how to set that up, you can just select any grouping of columns or rows. Then in the data tab, there's this group option here. And that just consolidates them so that you can hide them from view. In this case I've got my raw…

Contents