Tuesday, March 24, 2020

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!

Thursday, March 19, 2020

Simulate the Tabular Form Pivot Table Layout in Power Query


Sometimes our stakeholders want a table to looks like the Tabular format that comes from a Pivot Table but they don't want to see all that extra functionality from the Pivot Table. They want to see the Tabular format without repeating values in some of the columns so it looks "cleaner". We can actually simulate this using Power Query but it involves some M code (just a little bit).

Tuesday, March 17, 2020

Perform a Two Sample Test in Excel (t-test, unequal 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 excel-lent 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.