I am slowly going through Statistical Analysis with Excel book and I am making simulation worksheets to understand the concepts.
I have created the the worksheet with two populations and two pulled samples to get my mind on standard error of the difference between means which is used in Two-Sample Hypothesis Testing. I have used both Z-Test (when populations variances are known) and T-Test (when we don't know population data).
You can download the Excel workbook HERE. The file is around 11MB due population data (are we simulating or not? :) )