Click a cell in the date column of the pivot table that Excel created in the spreadsheet. Right-click and select "Group," then "Days." Enter "7" in the "Number of days" box to group by week.

Learn three quick and easy techniques to summarize data in Microsoft Excel. These methods will help you save time and analyze data effectively.