This is my vlog!

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

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…

Segmenting a List into 8 Pieces using Excel's Power Query (Get and Transform)

WARNING: this is a fast-paced overview. Don't worry if you…

Creating a Variable Hyperlink in Excel

This is cool! The problem: 11 worksheets and hundreds of codes Objective:…

Power Query: Summing Data from Specific Ranges

This is a CRAZY one! Kevin Lehrbass presented this problem: A…

How to Stack Columns of Data in Excel: Formula Method, Power Query Method

Lately, there have been a number of requests for stacking data…

Power Query: Stacking Columns of Data (Unpivot, Split Columns by delimiter, and everything!)

This was interesting, and the solution is sweet. We've got…

The Wildest Excel Spreadsheet Ever: HLOOKUP and the Importance of Building a Model

NOTE: This video isn't about the details. It's the thought process.…

Excel Power Query: Clear Line-Breaks (A correction to the previous video)

Here's a quick video correcting 2 things from the previous video:…

Excel Power Query: Import Data from Web Page and Clear Line-Breaks

Power Query has Clean and Trim features, but sometimes those…

Power Query Merging Columns and M Code (managing nulls and excess delimiters)

In this video, I go deeper into the issue of clearing excessive…

Power Query Merge Columns

More about working with Excel's Get & Transform (aka Power…