Learn how to use the new FILTER function in Excel to create dynamic filters. These dynamic filters will update filter results immediately when data changes. My entire playlist of Excel tutorials: http://bit.ly/tech4excel ***Consider supporting Technology for Teachers and Students on Patreon***:   / technologyforteachersandstudents   Here's the practice file that goes with this video: http://bit.ly/filterfunction #exceltutorial #excel