In this HowTech written tutorial, we’re going to show you how to group data in Excel 2016 pivot tables.

Don't forget to check out our main channel [ Ссылка ] for more free how-to videos!
Join us on Facebook
[ Ссылка ]
Our App
[ Ссылка ]

To start, you will first need a pivot table. Go under the Insert Tab and click PivotTable.

Select the area if your cursor wasn’t already in the area and click OK.

Drag and drop the fields to their appropriate positions.

To group data, select the data, right-click it and click Group.

You can also change Group settings on dates for example. Right-click the date and click Group.

You will see more options, choose the ones you want and click OK.

This is a HowTech tutorial, visit our website and watch our videos for more.

свернуть