From the course: Excel Tips Weekly

Unlock this course with a free trial

Join today to access over 22,600 courses taught by industry experts.

Change PivotTable settings for titles and summaries

Change PivotTable settings for titles and summaries - Microsoft Excel Tutorial

From the course: Excel Tips Weekly

Start my 1-month free trial Buy for my team

Change PivotTable settings for titles and summaries

“

- [Instructor] If you work with pivot tables, 2 you should be aware of some settings that you can change, 3 and they relate to a report layout 4 and other kinds of layouts as well, 5 and also the way Excel handles dates in pivot tables. 6 I've got a worksheet here that's about 900 rows. 7 It's not sorted, although often it would be, 8 but it doesn't need to be 9 if we're about to create a pivot table from it. 10 There are no empty rows, no empty columns in the list, 11 so I'll simply click on any cell within the list, 12 go to the insert tab of the ribbon, 13 off to the left, pivot table. 14 Excel figures out the extent of the data. 15 I'll click okay, we're on a new worksheet, 16 and off to the right is that pivot table field list. 17 I'll click the box for salesperson 18 because that's a text field. 19 It automatically goes into what we call the rows area, 20 rows down the left hand side. 21 I'll do the same thing…

Contents