From the course: Excel: Managing and Analyzing Data

Unlock this course with a free trial

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

Building a summary sheet or basic dashboard

Building a summary sheet or basic dashboard - Microsoft Excel Tutorial

From the course: Excel: Managing and Analyzing Data

Start my 1-month free trial Buy for my team

Building a summary sheet or basic dashboard

“

- [Instructor] When we're managing and analyzing data, it often helps to be able to create summaries so that we have an at-a-glance view of important details. In this data set, we are responsible for sending out shirts to the people on the Fizz Project. We see Rhonda Aames ordered a small size shirt. It's been sent and we have an address on file, but then we get down to Ant Hopkins also requested a small, we don't have an address, and of course no shirt has been sent. But then we get down to Lazurus Wheat. We do have an address, no shirt has been sent, and Lazurus has requested a double extra large. Let's go over here. This is where we're going to create our summary page. Sometimes these are called dashboards, and we think sometimes of dashboards as being really elaborate and interactive, but still they are a summary that gives you insights so that you aren't scrolling up and down looking in your data. Here we go. My cursor is in that data set and I'm going to start by creating…

Contents