Multiple Keywords Search with Power Query

If you wanted to search for some keyword(s) you could use Ctrl+F (and select Find All) to do this. If there was one value in the column entries, a lookup might work (like VLOOKUP) or using the merge feature in Power Query, but if you needed to lookup a word in a string of text in the cell, those lookup feature don't work that way. If you had many keywords or a list of them, this makes it even more challenging. Also if you wanted to give this to your stakeholders and provide some interactivity and hide the steps for them to do this without using VBA or show functions in your worksheet, think about using Power Query to do this.

Using the One Character Excel Functions (T Function | N Function)

Did you know there a one character functions in Excel? There is on one alphabetical character in this function and there are two in all of Excel (for now). One is the T() function and the other is the N() function. By themselves they really don't provide too much use, but if you think creatively on how to use them, they both may have a use. See how...

Select Records in One Table that Aren't in Another Table

This video will cover the Anti Join feature in Excel Power Query. The scenario it fits would be where you want to select all records from one table that doesn't exist in another table. So when we are trying to check whether an item does not exist in another table it's going to be an anti join. Another example is when we are trying to find something that hasn't happened. However in this video we'll cover something that doesn't exist rather that something that didn't happen. So check it out!