Change PivotTable settings for titles and summaries

- [Instructor] If you work with pivot tables, … you should be aware of some settings that you can change. … And they relate to a report layout, … and other kinds of layouts as well, … and also the way Excel handles dates in pivot tables. … I've got a worksheet here that's about 900 rows. … It's not sorted, although often it would be. … But it doesn't need to be if we're about to create … a pivot table from it. … There are no empty rows, no empty columns on the list. … So I'll simply click on any cell within the list, … go to the insert tab on the ribbon, … off to the left. … Pivot table. … Excel figures out the extent of the data, I'll click okay. … We're on a new worksheet. … And off to the right is that pivot table field list. … I'll click the box for salesperson, … because that's a text field it automatically goes into … what we call the rows area. … Rows down the left hand side. … We'll do the same thing for region. … And then drag the word customer into … what we call the columns area. …