This is my vlog!

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

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…

Announcement: Free Data-Cleansing & Power Query Training

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

Wanderlust Travel Tag | Oz du Soleil

/
Taking you for a drive around Portland, OR while I answer 10…

Excel Ignited Day 16 The Ultimate Doggone VLOOKUP Tutorial

/
I never expected to do a VLOOKUP tutorial because there are so…

Excel Ignited Day 15: Tables, Slicers, VLOOKUP

/
Revisiting Excel Tables! Using tables is a good habit to get…

Excel's IF, AND, and OR Functions | Excel Ignited Day 14 | SSSDEVA

/
This video picks up exactly where Day 13 stopped. Here's that…

Excel's AND and OR functions | Excel Ignited Day 13 | SSSVEDA

/
Continuing the series for Excel beginners, this video shows the…

FunkyFunktionFriday - Consolidating 7 Worksheets using Simple M Code (The Big Payback)

/
This was a real question that came to me. Someone has 113 worksheets…