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.

Calculate Median in PivotTable

Pivot Tables are one of the greatest analytical tools in Excel for it's capability to slice and dice data. It can summarize data by sum, average and even standard deviation. But the one of the basic statistical measures is the median and unfortunately that is missing from the pivot table options. Fortunately you can include that option in and it just involves creating the pivot table and adding it into the data model to write a simple DAX measure. See how it works by watching this short video.