To extract and sort non-adjacent arrays in your data, nest the CHOOSECOLS or CHOOSEROWS functions inside your SORT or SORTBY ...

Learn about how to create a table in Excel so you can start presenting your data to others in a more professional manner.

Wondering how to sort a bar chart without sorting data in Excel? If yes, then we have got you covered right here.

Here's how to create a pivot table in Excel to slice and dice your data, letting you perform in-depth analyses and spot important trends.

You can sort data by dates in Microsoft Excel and Excel Online. Learn how to sort all the columns according to date column using this tutorial.

There are lots of ways to return the top or bottom n records from a data set in Microsoft Excel, but the new dynamic array functions make doing so easier than ever.

Spread the loveMicrosoft Excel provides a convenient way to store and organize data in an orderly manner. One of the best features of this popular spreadsheet software is the ability to create tables.