Add a Random Number in Power Query

If you need to create random numbers in excel it's easy to use the RAND() function for a few numbers, but if you want to create a large amount of random numbers that might be a challenge. So if you wanted half a million or more numbers, think about using Power Query to do this. Also if you have a list of names (500K or more) and you wanted to randomly choose 100, adding a random number to that list and choosing a hundred random names from that list can be done in Power Query. See the video to learn how.

Make it Easier to Share Power Query Relative File Location (XLSX source)

If you share Excel files with Power Query queries, you notice that it can be "broken" if you the source data is referenced outside of the worksheet itself. This video will cover how to get around an simple query that references another Excel (.xlsx) file

Perform a One Sample t-test in Excel (for Mean)

This video cover two ways to perform a student t test for a one sample mean. A common statistical method to test a null hypothesis against an alternate hypothesis. It's used when you are comparing quantitative (and continuous) sample data against a given population mean.