From the course: Excel: Tracking Data Easily and Efficiently

Unlock the full course today

Join today to access over 22,800 courses taught by industry experts or purchase this course individually.

Building and using a PivotTable

Building and using a PivotTable - Microsoft Excel Tutorial

From the course: Excel: Tracking Data Easily and Efficiently

Start my 1-month free trial

Building and using a PivotTable

“

- [Instructor] Let's look at some more ways that pivot tables can be so helpful for us. Right here, I have the transaction data and over on the right side, we have the list of reps and who their supervisors are. Now let's build a pivot table. Now wait a minute, hold on a second. If you agreed with me, you should have said, ah, stop, put it in a table first. Yes, and if you said that, you would be right. Okay, format as table, I'm going to grab this purple. Table does have headers, and, okay, and get rid of filter buttons. Here we go. Cursor's in the dataset. Insert pivot table. Yep, new worksheet. Let's look at the Product Lines in the row headers, Sale Amount in the values and Accounts in the columns. All right, click away, the field pane goes away. Look at that. Alright, a lot of information here. One thing we can do with pivot tables, I want to click inside and then go to Insert, Slicers. I want to grab the…

Contents