Speaking at IgniteChicago
"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!"

Join my Newsletter

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

Pants on Fire Storytelling Show: Oz du Soleil learns the danger of playing cards with strangers

/
Pants on Fire is a storytelling event in Portland, OR where…

Aggregating Joins in Power Query: the mysteries

/
This video explores Aggregating Joins. These are strange because…

Test Your Knowledge on Excel Joins with this 10-Question Quiz

/
My past few videos have covered Joins and other methods for…

Retrieve The Correct Column Header (Leila Gharani Kevin Lehrbass Excel Challenge)

/
This came from Leila Gharani Original Video https://youtu.be/OJLfPc9YlqE Then…

Power Query: Split Column by Delimiter and Split into Rows

/
So, you've got a bunch of data all in one cell. You need to…

Cross Joins in Power Query: Measuring Student Progress

/
In this video we're measuring student progress against program…

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
JoAnn

I really have to thank you. I have learned so much from you! Because of things like this my reputation at work has exploded. And it’s the kind of rep you want to have at work. Your passion on the subject makes you stand out. I can tell you truly do understand! And that you truly do want to make things less stressful. Those two things rang true in my heart. That’s the way I feel but not many people get it. How can I even begin to thank you??

JoAnn
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