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.

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.

Select and name the multiple column data table you want to convert to a single column. Use your cursor to highlight the data table and right-click on the highlighted table.

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.

Excel's Data Model feature allows you to build relationships between data sets for easier reporting. Here's how to use it to make data analysis easier.

This column shows how to use the Data Table option in Excel’s What-If Analysis tool.