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

Pre-Microsoft 365: How to use the Advanced Filter in Excel Once Excel introduced the AutoFilter feature, Excel’s original filtering features were often ignored.

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

How to Include All Rows for Filters in Excel. Microsoft Excel helps you sort your data for analysis by providing a Filter command. For example, when you want to sort number values from low to high ...

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

Learn how to filter data using wild cards and other complex criteria using Advanced Filter in Excel.

Organize your Excel spreadsheet so that each row represents a new and unique record and each column contains categories of information. This organization allows you to use the sort and filter ...

Pivot tables generate great reports in Microsoft Excel, but adding a filter or two can make them even more flexible. Here's how.

Learn how to embed insert a PDF File in an Excel sheet in an easy way. Inserted PDF Files can be sorted, filtered and hidden along with cells ...

You can search in Excel with the Search Sheet bar, and use Find and Replace to swap out terms or values. Here's how to do it.

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.