Have you ever grouped data in Excel only to find your months sorted alphabetically instead of chronologically? It’s a frustrating quirk of the GROUPBY function, one that can turn a clean dataset into ...

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

Often, in the course of putting together a lengthy set of data in Microsoft Excel, users will want to rearrange their cells or add a new one to an established row (in addition to making graphs, which ...