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.

Ranking within a Group with Power Query

There's not really a ranking feature within Power Query like RANK.EQ or the DAX function RANKX. However that should stop you from ranking values in Power Query. That's the beauty of Excel...there's just many different ways to do similar things and this video showcases how you can rank stuff using Power Query.