This is my vlog!

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

Connect Power Query to a Dynamic Dropdown List

Can Excel's Power Query (Get and Transform) be used as contents…

Excel Data-Cleansing: When Data CanNOT be Cleansed

This is Crap data at its worst--a dataset that cannot be cleansed.…

Running Totals in Excel's Power Query: the easy way

As follow up to my previous video on making running totals in…

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…