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.

You have a table on paper but need the data listed in Excel? There's a simple trick for importing.