Excel - Filter Function Tutorial - Dynamic Arrays, Multiple Criteria, Filter to List

Learn how to use FILTER function in Microsoft Excel. We'll start this tutorial by reviewing dynamic logical arrays, then apply them within FILTER function, create multiple AND type of conditions, filter to dates, filter a range to a list of values & other tips and tricks. This tutorial is compatible with insider version of Office 365 & Google Sheets. Hopefully, at some point when you're watching it Microsoft will have it released in their regular build. Support the Channel on Patreon: https://www.patreon.com/chicagocomputerclasses #excel #filter