This is my vlog!

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

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…

Adding Line-Breaks in an Excel Cell: Using CHAR and SUBSTITUTE

In the previous video I showed how to retrieve Word data and…

Transferring Data from a Word Table and into Excel

Data is in tables in Microsoft Word and needs to be moved over…

Excel Challenge (Kevin Lehrbass): Get & Transform to List All Unique Pairs in a Class of 10 Students

Once again, Kevin Lehrbass (MySpreadsheetLab) and I are taking…

Announcement: Free Data-Cleansing & Power Query Training

FREE EXCEL ONLINE TRAINING (THIS WEEK ONLY): Power Query & Data…