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!

Create All Possible Combinations from Two or More Lists in Power Query

If you have two or more list and wanted to figure out all the possible combinations of the items of those list, it would be called a cross join, many to many join or a cartesian join. This can actually be done easily with Power Query. It shouldn't take too long if your source list are small. But if your list are bigger, you could potentially have output that could be a table of several million rows or records. If you know Excel, it does support 1M+ records in a single worksheet, but not over 2 million records. An example in this video will cover 4M+ records but the workaround is to separate the records into a million each and put all of it into a text file. See the video to learn how generate all possible combinations from two or more list.via IFTTT