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.

Create a Progress Circle Chart in Excel

Have you seen those infographic charts that have concentric circles broken into smaller segments to represent a part of a whole? Like 50 percent of the concentric circle is shown to show like people like 50 percent of something? Plus there are multiple circles that represent additional series of data. This progress circle chart or progress ring chart is actually a doughnut chart and it's pretty easy to create so check out the video to learn how!