Use Wildcards to Lookup and Sum Up Values

Have you ever received a list and wanted to do a lookup to add some values up, but the looked up value was combined with other text? Sure you could try to pull out that looked up value into another column and then use it to help with the lookup process to perform the calculation, but that would be more steps. You could actually use a wildcard to help out in this situation to match the looked up values and then perform your sums. Click on the video to see what I'm talking about.

Calculate a Chi Square Test with Excel

A Chi (rhymes with the word "my" but starting out with a "k" like kite) squared test is used to determine the relationship between observed and expected values that are categorical variables. This means items that are counted, so this type of test would be used for continuous variables like weight or height. Excel has some useful functions that will perform Chi squared calculations BUT you'll still need to calculate out the Chi squared test statistic based on your data. Check out the video for two examples of Chi squared - goodness of fit and test for independence.

Perform a One Sample Proportion Test in Excel

This video covers how to perform a one sample test for proportion. This type of test used to estimate the proportion of a population. It compares the proportion to a target or reference value . Unfortunately Excel doesn't have a function in the Data Analysis Tool-pack to do this in a few steps, but it's not that hard if you lay out the calculations in a column and then re-use if needed.