The Excel Filter function is a powerful and versatile tool that can transform your data analysis workflow, dramatically boosting your productivity.

Learn how to use Excel FILTER, XLOOKUP, and SUMIFS functions to streamline workflows and make smarter data-driven decisions.

Currently, if you filter a dataset, the results are displayed in the same set of rows and columns where the raw data was located. However, the Filter function can be placed anywhere in the workbook.

You can filter data in Excel based on either certain parameters in columns or over the whole sheet, and you can later unfilter the sheet.

Excel's filtering feature is helpful, but add a bit of creativity and it becomes much more. Susan Harkins explains.

Move beyond the basics of sums and averages. These tips open up all kinds of opportunities for working with spreadsheet data.

If you've have lots of data and lots of analysis to do, but little time or skill, you need Excel's Power Pivot feature. Here's how to get started with it.

Microsoft Excel's VLookup formula permits you to search large spreadsheets for specific data, one of Excel's lookup and reference functions. You can use VLookup between sheets within an Excel ...

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