Perform a Two Sample Proportion Test in Excel

When we want to compared the proportion of two groups (or samples), a suitable way to do this is with a two sample proportion hypothesis test. The question we're trying to answer is if there is a significant difference between the the proportion of the two groups/samples. This could be something like do the proportions of a drug effect females the same way they affect males or if the proportions of one group voting over a topic the same as another group. Too bad there is no tool to select a few cell ranges and gave an output (like t-test in the Excel Data Analysis Tookpak), but it's not too bad to manually lay out some cells and go through the formulas/functions to perform the hypothesis test.

Create a Calendar Table based on Start and End Date Inputs

If you're into building data models and your tables include dates, a good thing to have is a separate calendar table. You may want to create a calendar table that has the date, month name, year day name, etc. This gives you ways to slice and dice the data for further analysis and also a way to uniformly reference your other tables to one calendar table. It's fairly easy to create a list of dates in Excel by having a start date and incrementing by one day, but that is static. You'll always need to update it when new data comes in. The preferable way to do this is to automate it and that's when Power Query comes into play.

Animate a Social Media Phone Feed in PowerPoint

PowerPoint is great for animations and if you wanted to simulate a mobile phone screen as if someone was to browse through their social media feeds, this can be done in most versions of PowerPoint quite easily. In the latest versions of PPT (Office or Microsoft 365 subscription or 2019), you can use the Morph feature to do this. If you don't have those PPT versions, this can be done via the animation command. This video will show both examples of how to animate scrolling through a feed on a mobile phone image.