This is my vlog!

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

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…

Complex IF Formula Converted to 2-Way Lookup with INDEX-MATCH-MATCH

0:00 - what we're up to 1:21 - looking at the problem 5:12 -…

Referencing Queries with Get & Transform: Segmenting, Cleaning and Appending a Messy Dataset

"Reference a Query" is a feature in Excel's Get and Transform,…

Celebrating 1000 Subscribers to Excel on Fire

Thanks for all of the suggestions on what we could do with…

Excel Power Query Data Cleansing Part 3 Consolidate Workbooks Worksheets Using Power Query

In this final video of the 3 part training series on Excel Power…