From the course: Excel: Mastering Pivot Table Dashboards and Reports
Join today to access over 24,700 courses taught by industry experts.
Counting with a PivotTable - Microsoft Excel Tutorial
From the course: Excel: Mastering Pivot Table Dashboards and Reports
Counting with a PivotTable
- Okay, so now we're going to get into some real pivot table work. I'm in two, working with pivot tables. First thing first here is even though this looks like an Excel table, it looks like it's formatted like one. It is not an Excel table yet. So put your cursor anywhere in here. CTRL+T, my table has headers, we're cool. Okay, so now we have built it, it has called it table two. That would be tacky. I think that we could not survive this lesson if we kept it as table two. So let's call it orders, like that. Make life easy. Okay, so we're going to complete this one here that says count. So what do we want to do? We want to get a count of each item for a particular sales rep. So what we could do is, and what I have learned in the past as you go back to the original dataset here, hit pivot table, something like that. Alright, we don't need to do that. Why don't we need to do that? Well, because we created an…
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.