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.

Excel tables have many benefits that regular spreadsheets lack. The biggest is the option to use data from multiple tables to create queries and reports.

Learn the criteria expression for finding blank cells using Excel's Advanced Filter feature. A few weeks ago, I showed you how to use And and Or operators with Excel’s Advanced Filter feature.

How to unfilter a column in Excel You can unfilter data that has been sorted in either a column, multiple columns, or the whole sheet, but the process is a little different for each.

If the Excel Date Filter is not grouping by month, enable grouping dates in the AutoFilter menu, set dates in the proper format, etc.

This post will show you how to filter or sort Excel data using Cell Color and Font Color the easy way. This helps organize cells & improve productivity.

How to Filter Every 5th Item in Excel. When manipulating large amounts of data in an Excel spreadsheet, it can be challenging or time-consuming to select specific items by hand.

Learn how to improve your productivity by creating custom Excel shortcuts to improve efficiency when using spreadsheets in Microsoft's ...

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.