Right-click and select "Group," then "Days." Enter "7" in the "Number of days" box to group by week. Click "OK" and verify that you have correctly converted daily data to weekly data.

Determine your company's daily sales goals by analyzing previously collected data based on past performance. Launch Microsoft Excel and type your daily sales goal in the first cell of column A. If ...