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.

I have a worksheet containing data in rows and columns and i want it change or rotate the data of row to column and vice-versa, for that i have to use feature named transpose. lets learn this from ...

If you've have lots of data and lots of analysis to do, but little time or skill, you need Excel's Power Pivot feature. Here's how to get started with it.

Before we dive into pivot tables in Excel, letâ s have a quick word about it. A pivot table is a powerful tool in Excel to summarize and analyze your vast database in different ways.