This video explains how to use the SCAN function in Excel, and shows how to apply it to an Excel challenge from the Microsoft Excel Collegiate Challenge (@MECC.college).