Sometimes you may have a lot of data in your document, and it can be difficult to read; luckily, Microsoft Excel has a feature called Group which you can use to organize your data into sections that ...

I can easily achieve the same result with a pivot table by dragging the Salesperson field into Rows and the Sales field into ...

When you compile data in a list, you often need to answer questions such as “How much revenue did the West Coast office generate last month?” or “What was the average number of customers served at ...

Q: How do I add a percentage-of-total column in a PivotTable in Excel 2010? Your PivotTable will now display the same two columns of data both numerically and as a percentage of total, as pictured ...

Three ways to return the average age for a group using Excel Your email has been sent Summarizing data is a common task in Excel, and there's usually more than one way to do so. Susan Harkins explains ...

Q. I usually like Excel PivotTables, but because they don’t allow me to do certain things, such as delete cells or insert new columns or rows, I’m wondering if there is a reasonable alternative? A.