This is my vlog!

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

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…

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…