How to Use the FILTER Function in Excel - Excel FILTER Tutorial

In this Filter Function tutorial, we teach you how to use the very useful FILTER formula in Excel.

The FILTER function in Excel is one of the useful functions in Excel. It allows you to filter data sets within tables ranges using a function, rather than the normal dropdown arrows.

Not only is this a great time-saving tool, but it also makes filtering a range of data for analysis as easy as pie. In this Excel FILTER tutorial, we quickly show you how to use this function using some different scenarios.

💻 Watch more free popular training tutorials from Simon Sez IT:

🔥Check out our FREE 300+ hour training course playlist here ➡️

💬Stay in touch!

🔔 Subscribe to our channel:

If you enjoyed the video, please give a thumbs up 👍🏽 ;-)

[SimonSezIT]

🔥Check out our FREE 300+ hour training course playlist here ➡

[MathewUtting]

Thanks for this quick and clear tutorial.

This might have been added afterwards, but at 5:00 setting the validation source to be =$N$4# will allow it to update the list when then filter dynamically updates

[fzzouraki]

i really love your tutorials if only you added the excel file so we could follow along.
thanks in advance.

[evedgard]

Is it possible to put a nested formula to return results? Example, my dropdown should return a ratio and my source/table data have numbers in two columns that I want to use as divisor and dividend?

[Manoj-fiks]

Do we have these features in MS Office 2016 ?
Because some of these functions does not work in Excel 2016

[ubaidillahmuhammad]

nice. put practiced file in the description...