You can convert daily data to weekly data in Excel by creating a pivot table, and grouping the rows in the pivot table in groups of seven days, or one week.

Excel Tables offer a range of features for working with list-style data.

In addition, you can add a function to each column in the Table. Figure D: Add the Totals Row to a Table to summarize data. SEE: How to use TODAY () to highlight fast-approaching dates in Excel.