课程: Excel: Tracking Data Easily and Efficiently

今天就学习课程吧！

今天就开通帐号，24,600 门业界名师课程任您挑！

Building and using a PivotTable

Building and using a PivotTable - Microsoft Excel教程

课程: Excel: Tracking Data Easily and Efficiently

开始一个月试用 购买团队方案

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…

内容