Filtering IMPORTRANGE data with QUERY in Google Sheets

Easter Eggs 🥚 and bonus useful formulas for the curious inside. Learn how to use the FILTER function in Google Sheets to filter source data within an IMPORTRANGE function with 4 key examples: 00:00 Intro 00:36 E.g. 1 - Filter a company&data. 05:37 E.g. 2 - Select only specific columns 08:23 E.g. 3 - Ordering by the &column 09:28 E.g. 4 - Filter by company and sales rep More advanced FILTER tips: If you like the video, check out my website: Here is the link to just Google Sheets tutorials: Sign up for my course: Google Sheets: Learn the Essentials with Three Detailed Projects Grab a Google Sheets Shortcuts Mousepad to help you memorise the Shortcuts. #GoogleWorkspace