This is my vlog!

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

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 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…

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…