Join Dennis Taylor for an in-depth discussion in this video Custom grouping in PivotTables, part of Excel Tips Weekly.
- One of Excel's most powerful and creative tools…is called a PivotTable, and when you work with…large amounts of data, list-type data,…PivotTable is great for coming up…with quick summary information.…It has standard techniques for grouping data,…say by date or time, but you can also create…your own custom groupings.…I'm going to create a PivotTable based on this data.…It's some 900 rows.…It covers data over a two-year period.…We're tracking sales by different sales people here.…On the Insert tab in the ribbon,…we can create a PivotTable, and in Excel 2013…there's a new feature called Recommended PivotTables.…
Give that a chance,…because sometimes the layouts that you see here…might be, if not exact, at least close to something…that you might want.…So as I'm looking through this list here,…I'm thinking, well this list here that shows…the labels consisting of the products…is fairly close to what I want.…So I'll just double-click this option.…And suddenly, on a new sheet, we've got a PivotTable.…Off to the right is the PivotTable Field list.…
Skill Level Appropriate for all
Excel Tips - New This Week
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.