How to filter in excel - 5 different methods

Multiple different ways to filter numbers in excel: 1) Filter in place 2) Autofilter - filter based on cell value 3) Advanced filter 4) Using a pivot table 5) Using power query 6) Dynamic array FILTER formula -------------------------------------------------------------------------------- #exceltips #exceltutorials #msexcel SUBSCRIBE: https://goo.gl/c46YPs Microsoft Office 365, 2016, Office Insider, Version 1908 --------------------------------------------------------------------------------- IF YOU LIKED THIS VIDEO YOU MAY ALSO LIKE: - How to filter using vlookup in excel https://youtu.be/or6vcScX6mM - How to use vlookup to find the 2nd, 3rd or Nth match in excel https://youtu.be/1KlIitbjUlw - What are excels 7 new dynamic array formulas https://youtu.be/obBecMXFf2I