slider-1
"I can show you the WHEN and WHY,
not just the HOW"
Oz
"I can show you the WHEN and WHY,
not just the HOW"
2017-01-22 20.21.27
"We've gotta whoop Crap Data's ass every chance we get!"

Who is Oz?

I am an Excel developer, blogger, trainer, co-host of ExcelTV, raconteur and Excel MVP. I’m known for a fierce commitment to empowering people who don’t have an IT team or the skillset to manage their own data.

I am also the lead author of Guerrilla Data Analysis 2nd Ed., co-written with Mr. Excel, Bill Jelen. I relocated to Portland, OR in 2014 after 19 years in Chicago, and I’m known for my passion for ghost pepper Sriracha.

My latest publications

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…

What do people say about me?

John

Oz reached into my brain, grabbed my problems, put them on his screen and… pooof! …they were gone!

John
Anna

Oz is blowing my mind. I just got comfortable moving from VLOOKUP to INDEX-MATCH!! Its like watching a street magician

Anna
Mike

Just wanted to follow-up and let you know that your solution worked perfectly. I designed the budget template, after taking the course,  with PowerQuery in mind.  This will save us hours each month when we have to update.

Mike
Donna Bruce

Your solution was quick to implement and very easy to follow. Thanks again.

Donna Bruce