课程: Excel Weekly Challenge

免费学习该课程！

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

Get data ready for a PivotTable

Get data ready for a PivotTable - Microsoft Excel教程

课程: Excel Weekly Challenge

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

Get data ready for a PivotTable

“

- [Instructor] Are you ready to make a pivot table, that's what we have to do today. Here we've got three data sets, Marshall County, Canyon County and Kidder County. We've got people and fines that have been applied against them. We need a pivot table that will give us a total amount of fines by region and by license. For example, we want to see the total amount of fines for everybody with a license 1-E in region G. In order to get the data ready for the pivot table we've got to separate that field that has region, license and fine all together, and clear any empty rows and columns then make the pivot table. So if you've got that, go ahead, pause the video, come back, I'll show you a way to do it. Okay you're back, let's dive into this. First of all we've got to get the data all stacked up. I'm going to go here, delete, shift cells up, I'm going to grab this, drag it underneath. Next I'm going to split the columns in…

内容