What’s the difference between a table and a range of columns and rows on an Excel spreadsheet? How do I create and populate tables? And, once a table is created, how do we custom filter, format ...

Microsoft Excel's new FILTER() function is a great tool for reporting and dashboards. We'll show you how to use it to get more done.

You can filter data in Excel based on either certain parameters in columns or over the whole sheet.

Advance Filter in Microsoft Excel is easy to use. Learn how to filter data based on complex conditions in Excel the right way.

Whether you're tired of losing your spot when collaborating or you want to customize the way you view your data, sheet views in Microsoft Excel are for you.

Imagine you’re working on a massive Excel spreadsheet, trying to sift through rows upon rows of data to find specific information. You’ve tried VLOOKUP and XLOOKUP, but they just don’t cut ...

One typical application for Excel is to find information in a list of data. The simplest way to do this is filtering the data so that Excel does the work of finding the pertinent information for you ...

You can alphabetize data in an Excel spreadsheet by row or column using the "Sort" feature, or through the "Data" and "Home" tabs.

Freezing a row in Microsoft Excel or Google Sheets can organize your spreadsheet and make sorting through data a breeze. Here's how to do it.