Unpivot Data with Null or Error Values in Power Query

If your familiar with Pivot Tables, it's basically taking a proper table and summarizing the data for further analysis. However what if you got a pivoted table (aka crosstab or contingency table) already and wanted to do the reverse? In Power Query, there's the option to unpivot (uncrosstab or sort of a transpose) a pivot table view. However it does certain things to the data if it has errors or null values and maybe you don't want Power Query to remove the empty cells or show the error cells. This video will cover both scenarios and the steps to address them.

Add Multiple Series of Data to X Y Scatter Chart

If you're creating a scatter plot it may begin with one series of x,y data. But later on you may want to put a second set of data or a second line into your chart. You may have 2 variables, 3 variables or multiple variables! Basically this are multiple groups or multiple sets of data and you'd want to plot two or more things at once. This vid will show you how to quickly add multiple scatter plots into your graph chart and even cover labeling your series of data. Well it covers more of how to label your series of data via the legend and even though Excel can give you two or more colors to separate out those series, you may want to use markers to help differentiate it more.

Calculate a Two Way ANOVA without Replication in Excel

If you're familiar with a one way ANOVA, then a two way (or two factor) ANOVA is not to different. What you're trying to do is compare the difference between two independent variables (or factors) to see if the interaction between the two factor affect each other. Excel gives you an easy way to calculate this ANOVA with the Data Analysis toolpak...but I'll also show you how to perform them manual calculations to see how Excel gets it's answers.