From the course: Excel 2016 Essential Training

Unlock the full course today

Join today to access over 22,400 courses taught by industry experts or purchase this course individually.

Grouping by date and time

Grouping by date and time

From the course: Excel 2016 Essential Training

Start my 1-month free trial

Grouping by date and time

- We're looking at a PivotTable on a worksheet called DateGrouping. It's based on the data in the Creating sheet in this workbook, and if you saw prior movies in this series, you recognize the data. The PivotTable Field list is off to the right, and right now we're showing Date, and that doesn't look very promising. More or less PivotTables seem to be compact and concise, this one certainly isn't. We're covering data over a two-year period, and this just goes on and on and on. It's a bit shorter than the source data but still, not very compact. We'd like to be able to group this data by maybe month, or year, or quarter, something like that. And all we really need to do is to right click one of these dates. Now, before we do this, recognize that the date here is in the Row label's area of this PivotTable, you see the checkmark up above, there's the Date field name. So we'll right click on one of these dates over in column A, any one, and choose Group. A prompt comes up saying Months…

Contents