This is my vlog!

Here you will find stuff that matters, Excel tutorials, and interesting things that I like. Enjoy it!

Test Your PowerQuery Instinct With This 5 Question Quiz

Download the workbook here: http://datascopic.net/GTInstinct LET'S…

How to Split Columns with Power Query with Variable Delimiters

It's easy to split columns by delimiter but there's a problem…

Paqui One-Chip Challenge 2017

Here it is! My Paqui One-Chip Challenge video. This chip is…

Insert a Line-Feed Between Every 3rd Character Using Excel's Power Query

This video responds to a question: how can you add a line-feed…

Pants on Fire Storytelling Show: Oz du Soleil learns the danger of playing cards with strangers

Pants on Fire is a storytelling event in Portland, OR where…

Aggregating Joins in Power Query: the mysteries

This video explores Aggregating Joins. These are strange because…

Test Your Knowledge on Excel Joins with this 10-Question Quiz

My past few videos have covered Joins and other methods for…

Retrieve The Correct Column Header (Leila Gharani Kevin Lehrbass Excel Challenge)

This came from Leila Gharani Original Video https://youtu.be/OJLfPc9YlqE Then…

Power Query: Split Column by Delimiter and Split into Rows

So, you've got a bunch of data all in one cell. You need to…

Cross Joins in Power Query: Measuring Student Progress

In this video we're measuring student progress against program…

The Missing Donation Receipts: Using a Power Query Anti-Join against Multiple Records and Criteria

This is real! A non-profit needs to determine which tax receipts…

The 6 Joins in Power Query: Explained

You've seen the Joins in other videos, but here is a fun overview…