I make quick and easy Excel and Power Query tutorials.

New videos every week. I also take special requests -- just leave a comment on one of my videos!

Easily reformat your data to make it ready for Pivot Table analysis using Unpivot
5:32
Easily reformat your data to make it ready for Pivot Table analysis using Unpivot
Build a randomizer tool to randomize your data automatically using Excel Power Query
6:18
Build a randomizer tool to randomize your data automatically using Excel Power Query
VLOOKUP with multiple lookup values | Excel Power Query
4:40
VLOOKUP with multiple lookup values | Excel Power Query
Remove duplicates without losing any info | Excel Power Query
4:18
Remove duplicates without losing any info | Excel Power Query
Automatically Find and Replace | Excel Power Query Tips & Tricks
3:06
Automatically Find and Replace | Excel Power Query Tips & Tricks
Easy Combo Charts (Line + Bar) | Excel Tips & Tricks
2:45
Easy Combo Charts (Line + Bar) | Excel Tips & Tricks
Custom Funtions in Excel Power Query | Excel Tips & Tricks
6:26
Custom Funtions in Excel Power Query | Excel Tips & Tricks
Remove Duplicates Using Power Query | Excel Tips & Tricks
4:12
Remove Duplicates Using Power Query | Excel Tips & Tricks
GROUP BY - No More Pivot Tables! | Power Query Basics | Excel Tips & Tricks
6:12
GROUP BY - No More Pivot Tables! | Power Query Basics | Excel Tips & Tricks
Dependent Dropdown Lists in Excel | Excel Tips & Tricks 017
5:22
Dependent Dropdown Lists in Excel | Excel Tips & Tricks 017
Auto Combine Excel Files with Power Query
2:49
Auto Combine Excel Files with Power Query
Custom Columns & If Statements | Power Query 101 | Excel Tips & Tricks
4:32
Custom Columns & If Statements | Power Query 101 | Excel Tips & Tricks
Merge Tables without VLOOKUPS | Power Query 101 | Easy Excel Tutorials
4:06
Merge Tables without VLOOKUPS | Power Query 101 | Easy Excel Tutorials
Freeze First Row or Column of Your Worksheet | Excel Tips & Tricks 016
2:41
Freeze First Row or Column of Your Worksheet | Excel Tips & Tricks 016
VLOOKUP from Multiple Sheets | Excel Tips & Tricks 015
3:05
VLOOKUP from Multiple Sheets | Excel Tips & Tricks 015
Easy Pie in Pie Charts | Excel Tips & Tricks
3:00
Easy Pie in Pie Charts | Excel Tips & Tricks
How to Make a Pivot Chart | Easy Excel Tutorials 013
3:37
How to Make a Pivot Chart | Easy Excel Tutorials 013
How to Randomize Data | Easy Excel Tutorials 012
2:21
How to Randomize Data | Easy Excel Tutorials 012
Find and Remove Duplicates | Easy Excel Tutorials 011
2:55
Find and Remove Duplicates | Easy Excel Tutorials 011
Conditional counting with COUNTIF formula | Easy Excel Tutorials 010
3:07
Conditional counting with COUNTIF formula | Easy Excel Tutorials 010
How to Make a Dropdown List | Easy Excel Tutorials 009
3:12
How to Make a Dropdown List | Easy Excel Tutorials 009
Lock Cells in Excel to protect them from being changed | Easy Excel Tutorials 008
2:11
Lock Cells in Excel to protect them from being changed | Easy Excel Tutorials 008
Combine Text with Concatenate Formula | Easy Excel Tutorials 007
2:46
Combine Text with Concatenate Formula | Easy Excel Tutorials 007
Average, Min, Max, Mode & Median Quick Excel Summary Functions | Excel Tutorials for Beginners 005
2:03
Average, Min, Max, Mode & Median Quick Excel Summary Functions | Excel Tutorials for Beginners 005
Pivot Tables with Calculated Items | Excel Tips & Tricks
3:14
Pivot Tables with Calculated Items | Excel Tips & Tricks