This is my vlog!

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

Octopus Spreadsheets, Asking for Help and Conceptual Thinking

When asking for help with a spreadsheet, it's best to distill…

Replace Each x in a Matrix With Column Headers in PowerQuery

Imagine a grid that has students and subjects. In the Algebra…

Excel Weekend 4 - Summary with Cristiano Galvão and Oz du Soleil

ExcelWeekend 4 was a blast! Here, the founder, Cristiano Galvão…

Using Power Query to Keep Duplicate Records and Delete Single Records

It's easy to get rid of duplicate records with Excel's Power…

How to Import Excel Files with Power Query; BUT there's a PROBLEM

Here is a how-to for importing Excel files from a folder using…

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…