From the course: Excel Data Visualization: Designing Custom Visualizations
Unlock this course with a free trial
Join today to access over 23,100 courses taught by industry experts.
Building a dynamic dashboard, part 1 - Microsoft Excel Tutorial
From the course: Excel Data Visualization: Designing Custom Visualizations
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…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Contents
-
-
-
(Locked)
Setting expectations1m 8s
-
(Locked)
Image overlay chart6m 1s
-
Binary ranges5m 2s
-
(Locked)
Automation with OFFSET and COUNTA7m 8s
-
(Locked)
Interactivity with form controls12m 30s
-
(Locked)
Animating changes over time14m 3s
-
(Locked)
Building a dynamic dashboard, part 116m 10s
-
(Locked)
Building a dynamic dashboard, part 212m 8s
-
(Locked)
Value-based formatting10m 10s
-
(Locked)
Dynamic series selection10m 26s
-
Custom pacing chart10m 23s
-
(Locked)
Custom gauge chart9m 58s
-
(Locked)
Visualizing percentages with arrays7m 16s
-
(Locked)
-