Keyword Lookup with Power Query

If you have user that want you make an easier keyword lookup for a table of records, you could tell them to just filter the table or put some lookup formula (like VLOOKUP) together for them. But if they just want some easy to use field where they type up something and click here to get the results, maybe another solution would be to use Power Query. But remember to tell them that this is a case sensitive keyword search!

Perform a Two Sample Test in Excel (t-test, equal variances)

When you're trying to compare two population samples to see if the difference is significant or based on random chance, you're likely to perform a t-test for your hypothesis testing. Another thing to think about is to determine if it is a equal or unequal variance t-test. Excel provide an neat feature in the Data Analysis Toolpak to do this easily and I'll cover it, but also show how to use the formulas to manually figure it out.

Make it Easier to Share Power Query Relative File Location (Text or TXT)

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 a text (.txt) file. There will be another video later because this is the simpler solution that involves adjusting the Power Query privacy setting to get around the Formula.Firewall error message.