MS 365 Excel Basics #10 Part 03: FILTER Array Function to Dynamically Filter!

Download Excel File: https://people.highline.edu/mgirvin/AllClasses/218M365/Content/ExcelBasics10-Part-03-FILTER.xlsx Full free YouTube class: https://www.youtube.com/playlist?list=PLrRPvpgDmw0k7ocn_EnBaSJ6RwLDOZdfo pdf notes: https://people.highline.edu/mgirvin/AllClasses/218M365/Content/ExcelBasics10-Parts-01-02-03 The Only App That Matters book by Mike Girvin at Amazon: https://www.amazon.com/stores/Mike-excelisfun-Girvin/author/B009Q5T4P2?ccs_id=70eb6de0-afb4-4979-a9a7-a1bdc0089ad3 Excel Basics Video #2: https://www.youtube.com/watch?v=r7jbrNjbp68&list=PLrRPvpgDmw0k7ocn_EnBaSJ6RwLDOZdfo&index=2 Excel Basics Video #5: https://www.youtube.com/watch?v=cRmEVw89FUE&list=PLrRPvpgDmw0k7ocn_EnBaSJ6RwLDOZdfo&index=5 Excel Basics Video #6: https://www.youtube.com/watch?v=iJj4rYhlzmo&list=PLrRPvpgDmw0k7ocn_EnBaSJ6RwLDOZdfo&index=7 In this video learn about the FILTER Array Function: Topics: 1. (00:00) Introduction 2. (00:12) Download File 3. (00:28) Use FILTER. Example 2: Filter to get a list of a SalesRep’s customers based on a single condition array logical test 4. (02:03) Use FILTER. Example 1: Filter using an OR Logical Test Across Two Columns. 5. (04:20) Summary 6. (04:33) Close Using the gear icon setting button below the video, you can watch subtitles in these languages: Afrikaans, Arabic, Bengali (some videos), Bangla, Dutch, Filipino, French, Hindi, Indonesian, Khmer, Malay, Malayalam, Nepali, Persian, Polish, Spanish, Swahili, Tamil, Telugu, Thai, Tibetan, Urdu, Vietnamese. Using the gear icon setting button below the video, you can listen to an audio track in these translated languages: French, German, Hindi, Indonesian, Italian, Japanese, Portuguese, and Spanish. #excel #excelisfun #groupby #dataanalysis #Sort #filter #excel #excel365 #excelisfun #highlinecollege #mikegirvin #freeexcellessons #excelformulas #excelfunctions