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.

Here's how to create a pivot table in Excel to slice and dice your data, letting you perform in-depth analyses and spot important trends.