Figure F After converting a data set to a Table, update the dependent references. When you create a Table object, Excel names it — use that name or give it a more meaningful name yourself.

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.

Working with a complete data set is a common task in Excel. You might want to move the data, apply a filter or common format, or convert the data to a table.