Learn how to use Excel's new GROUPBY and PIVOTBY functions through five real-world examples, ranging from easy to hard. This tutorial covers: - Basic GROUPBY to calculate the sum of revenue by ...

Excel’s ascending and descending sort options are powerful tools, but they won’t always sort values in a familiar and meaningful way. When this is the case, you might need a custom sort. Sorting is a ...

Have you ever struggled to sort data in Excel in a way that truly fits your needs? Imagine trying to organize a list of regions not alphabetically, but in a specific order like “North, South, East, ...

When an ordinary alphabetical or numerical sort in Microsoft Excel won’t do, check out the advanced sorting options or add a custom sort pattern. Excel has several advanced sorting options, but most ...

Have you ever found yourself wrestling with Excel, trying to make sense of messy data or create reports that actually tell a story? Whether you’re a seasoned pro or just starting out, Excel can ...

If that's not clear, here's a screenshot of what I mean. I happen to be viewing that in Excel 2007 but they're using E2k3. This grouping/"outline" is an Excel thing. This was generated by an ...