The TRUTH about Filter - Advanced filter techniques in Excel and Power Query

★ Want to automate Excel? Check out our training academy ★ https://exceloffthegrid.com/academy ★ Get the example file ★ Sign up for our free Insiders program and get the example file: https://exceloffthegrid.com/insiders-signup/ File Reference for this video: 0245 Truth about Filter.zip ★ About this video ★ The video builds on the Reporting & Analysis blueprint introduced in earlier videos, focusing specifically on two key steps: Reshape and Calculate. Within these steps, we go into advanced filter techniques in Excel and Power Query and identify when to use each tool. By the end of the video, you will understand how filter in Excel and Power Query really works, so you can take your skills to the next level. 0:00 Introduction 0:15 Two types of filter and when to use them 1:47 Partial text filter (Functions & Power Query) 7:14 Filter by list (Functions & Power Query) 10:31 Filter all if blank (Functions and Power Query) 14:35 Wrap-up Watch the previous video about the Reporting & Analysis Blueprint: https://youtu.be/TLVQ_LSGyEQ ★ Download 30 most useful Excel VBA Macros ebook for FREE ★ https://exceloffthegrid.com/ ★ Where to find Excel Off The Grid ★ Blog: https://exceloffthegrid.com Twitter: https://twitter.com/exceloffthegrid #MsExcel