From the course: Excel: Dashboards for Beginners
Unlock the full course today
Join today to access over 24,500 courses taught by industry experts.
Get familiar with the data - Microsoft Excel Tutorial
From the course: Excel: Dashboards for Beginners
Get familiar with the data
- [Instructor] Now that we finished learning about the components of a dashboard and how to build them with pivot tables, Now it's time to learn how to build a pivot table from scratch using some raw data like we have here. Now, let me show you what the pivot table will look like eventually. So this is what the ending version's going to look like, and I'll make this maximize so we can see that we have a timeline here and this timeline follows what we learned. I'll clear that filter. As well we also have a slicer here that affects what's in view. What we're looking at is a total sales over time, as well as who our top 10 sales people were. If I clear these filters you can see it actually does go to the top 10. So I'm going to show you how to do that. Now, the steps to get there look like this. So first, what we need to do is we need to take this all here and turn it into an Excel table. Next, we're going to create a few…
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.