Excel's GROUPBY function lets you group and aggregate data based on certain fields in your table of data. It also offers arguments that allow you to sort and filter your data, so you can tailor ...

Excel Group feature allows users to group rows or columns. Ungroup is used to ungroup a range of cells or data that were previously grouped.

Step by step guide to group Worksheets in Excel to apply common changes. It is useful when you need to apply the same formula, data or column.

In Microsoft Excel, you can permanently hide columns containing data you don't need to have on show. However, grouping columns is often a better way to achieve the same outcome, especially if you ...

How to Automatically Sort a List Alphabetically in Microsoft Excel. When you are organizing data for your company in a spreadsheet using Microsoft Excel, you do not have to manually edit the ...

Q: I use Excel’s Group tool to expand and collapse our employees’ weekly timesheet data, but it takes forever to group each section individually for each of my 300-plus employees. Can you tell me how ...

Using Microsoft Excel 2007, you can protect worksheets in order to keep other users from making changes. Unfortunately, this protection applies to everything on the worksheet, including groups.

Sorting is one of Microsoft Excel's easiest tasks. Click; you're done! At least until you need to sort by multiple columns. For this sort task, you'll need a custom sort. Here's how.

Need to know your organization's YOY results? Susan Harkins will show you how to make a PivotChart in Microsoft Excel.