GROUPBY function: The future of COUNTIF SUMIF

Find out how to build and use the GROUPBY function in Excel 365. Group data, calculate summaries, and update instantly.

Intelligent Filters with Excel

Take your data analysis to the next level with intelligent filters in Excel. Find out how Slicers can improve efficiency, and accuracy.

Excel Tutorial – Filtering your data

Master Excel filtering techniques with this comprehensive tutorial. Learn how to filter and sort data in Excel with ease

Clear All Filters in Excel in one click.

Learn how to remove all the filters in Excel with just one click. This step-by-step guide will help you to improve your Excel skills

Add filter option for all your pivot table columns

Learn the trick to add filter options for all pivot table columns. Enable the Filter menu and access filtering and sorting for every column.

Use Filter for your data in Excel

One of the most useful and powerful tool in Excel is the Filter. It's easy to use and it contains many incredible options.

The FILTER Function in Excel

The FILTER function of Excel returns all the rows corresponding to a specific criteria. It's possible because of the Dynamic Arrays of Microsoft 365

How to return multiple rows with VLOOKUP

If you want to return many rows, you can't use the VLOOKUP function. But you can do the job with the FILTER function.