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.