This is my vlog!

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

The Madness of How to Make Running Totals in Power Query

This video is a wild one! To make running totals in native Excel…

Using Power Query to Import Names To Make Dummy Data

I maintain a file of dummy data and I describe the 2 reasons…

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…