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. Sorts are a ...

Microsoft Excel is arguably the greatest spreadsheet application from Redmond, and there’s a good reason so many number crunchers use it for all of their number crunching needs. While using Microsoft ...

Tired of struggling with pivot tables every time you need to summarize your data in Excel? You’re in luck! Excel’s new GROUPBY and PIVOTBY functions are here to make your life easier. These powerful ...

The SORT and SORTBY functions let you extract certain columns and rows from a dataset and sort them in a certain order, all while preserving the source data. Even though they work in similar ways, ...