Learn how to use Excel's new GROUPBY and PIVOTBY functions through five real-world examples, ranging from easy to hard. This ...

In Microsoft Excel, learn how to report time values by the hour using the underlying date serial value. Grouping records by dates or time is easy in Microsoft Excel, but it doesn’t make a great report ...

When you have such sheets which should be grouped, but they cannot be put next to each other, you can use colors. First, select them using Ctrl, and then right-click on any of them. In the menu, you ...

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 ...

Here’s how to link two or more Excel charts together for easy manipulation within a document or presentation. Sometimes, do you need to have two or more Excel charts displayed together, or wish to ...

PivotTables can do more than you think, from splitting reports by category to calculating unique counts and percentage growth ...