Sankey Diagram in Power BI

Sankey Diagrams show how data flows from one entity to another. You'd think that it would be difficult to create but with Power BI and the Visuals marketplace from Microsoft, you can create a simple Sankey chart to have provide some interactivity or just copy/paste to a presentation or infographic.

Google Sheets - Lookup the Last Matching Value

If you've worked with most lookup functions (like VLOOKUP, LOOKUP, etc.) it will bring back the first matching value in the range you selected. However there may be times when you want to see the last matching value from your lookups. In this video it will go through two examples of how to get the last matching value from a lookup with Google Sheets. One will be using the LOOKUP function (along with other functions) and the other will be a crazy combination of INDEX, IF, ARRAYFORMULA, ROW AND LARGE.

Unpivot Multiple Columns | Added Columns Changes

To unpivot a report or table used to be a difficult process, but it's become a much easier process with Power Query feature in Excel. Still there are things to consider when using the unpivot feature because when column changes with adds it DOES depend on how the unpivot is done and where the column is added.