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.

Let’s say you are showing data to students and you want to talk about the changes in certain data over time. You can quickly highlight the trends by using sparklines, which are mini graphs of selected ...