Oz du Soleil

By day, he tussles with Crap Data in Excel, blazing trails through data’s dusty badlands. By night, he’s a keen collector of kaleidoscopes. With a fiery passion for teaching and a vicious spirit in the wild west of data, Oz has taught classes for Xfinity, Northwestern University, and the World Health Organization, empowering students around the globe, from Perth, Australia; Sofia, Bulgaria, and São Paulo, Brazil.
You can catch Oz in action on YouTube at ‘Excel on Fire’ his many courses on the LinkedIn Library and books co-authored with Bill Jelen, Mr. Excel.

Manipulating Data with Power Query's Joins and Appends

DEC 8 | 2:30 PM - 3:30 PM

You’re faced with 2 datasets that need to be merged, compared, or parsed. Lots of data and you have to do it over and over again with needs like:

Bring data from dataset A and match with the records in dataset B—if there are matches
Identify the records that are in B but not also in A
Isolate the data that’s in both A and B
Power Query and the 6 joins/merges are what you need!

This session will be a thrilling and thorough odyssey through Power Query’s 6 joins, unveiling their power, and knowing when a join is preferable to the mighty XLOOKUP.

Hosts Microsoft Excel World Championship 2023 - Finals

DEC 9 | 7:00 PM - 10:00 PM