Convert a Series of Column Pairs into a Table

Got a table that is a series of pair column attributes? Like one column is Date and the right next to it is Quantity, but instead of one pair of this Date-Quantity column pairs, you have multiple ones? How are you supposed to do any proper analysis or charting on this? If this was a small table, copy/paste/transpose might work, but if it was a larger table or something you'd have to convert on a recurring basis it would get tedious. Well that's where Power Query comes in to save you...see the video to learn more

Calculate Z Scores in Excel

What is a Z-score? Well it helps you measure how far a value is from the mean (or average) of a group of values. It quickly helps you find out if the number is an outlier or within the "normal" confines of a group of values. This video will show you how to use the STANDARDIZE function as well as the formula to figure out a z-score

Calculate a One Way ANOVA in Excel

If you're trying to check if survey data for different group (two or more) are truly random and nothing is suspect about them, you're probably going to use  ANOVA (Analysis of variance) to test.   This video will cover how to use Excel to perform a one way ANOVA test the easy way (using the Analysis Toolpack) and the other way in a more manual but descriptive approach.