From the course: Excel: Creating a Basic Dashboard
Join today to access over 24,800 courses taught by industry experts.
Extend your dashboard using hidden rows - Microsoft Excel Tutorial
From the course: Excel: Creating a Basic Dashboard
Extend your dashboard using hidden rows
- [Instructor] Dashboard summarized data in a compact format. You should avoid the temptations to display too many items on a dashboard, but there will be times when you want to make certain information available even if it's not shown all the time. You can do so by hiding or grouping worksheet rows that contains some of the details displayed in the dashboard. I will show you how to enable users to show or high detail rows in this movie. My sample file is 0204 hidden. And you can find it in the chapter two folder of the exercise files collection. In this workbook, I have the start of a dashboard that summarizes category sales. And then I have a color scheme that shows yellow for good performance, green for excellent performance. And if I had anything less than good, it would be displayed with red indicating that there is a problem. And you can see the rules that I use. What constitutes excellent or good performance…
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.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.