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.

Extract Hyperlinks from Sentences in a Column

If you were to pull out hyperlinks (or URLs) from a table, it would be fairly easy if it were in the beginning or end of the contents in a cell by using some combinations of the LEFT, MID, SEARCH or FIND functions. But if the URL in the text cells were all over the place and part of a paragraph in a cell, it might be more challenging or could involved using VBA. Common cases would be to pull out URLs with http, https or www and this video will show how to extract those type of URLs using Power Query.