This is my vlog!

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

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…

Excel Power Query Data Cleansing Part 2 Clean Extract Data Using Formulas Analytical Tools

In this 2nd of a 3 part training series on Excel Power Query…

Excel Power Query Data Cleansing Part 1 Different Ways to Format Data Using Power Query

In this 1st of a 3 part training series on Excel Power Query…

Let's Celebrate Clean Data and 1000 Subscribers!

Thanks to everyone who's subscribed, commented, sent in questions…

Excel's Get and Transform: Handling Leading Zeros and a Little M-Code

(Download the workbook here: http://datascopic.net/leading-zeros) Here's…

3 More Warnings re: Get and Transform: Disappearing Headers, Conditional Columns, Strange Duplicates

Here's another video that offers warnings about Excel's Get and…

Unstack Data that is Separated by Bold Text: Challenge w/Kevin Lehrbass - Formulas, VBA, Power Query

Problem: a tall column of data that needs to be unstacked and…

3 Warnings about Excel's Get and Transform Feature

Excel's Get & Transform is a fantastic tool, but there are some…

3 ways to compare and clean lists in Excel: VLOOKUP, MATCH, Get & Transform Left Anti-Join

Someone posted an urgent request. Some contacts from a small…