This is my vlog!

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

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…

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…