Dirty Data Exterminator
Oz du Soleil is an Excel developer, blogger, trainer, videographer, raconteur and Microsoft Excel MVP. Check out his work on his YouTube channel.
He is known for a colorful and fierce commitment to empowering people who don’t have an IT team or the skillset to manage their own data.
Oz du Soleil is also a lead author of the book Guerrilla Data Analysis 2nd Ed. co-written with Mr. Excel, Bill Jelen.
Oz passionately describes his mission as follows:
Oz depicts himself in this battlefield of Excel data, “I spent years helping to rid the world of crap data. For my efforts, my blog was selected among the world’s best. I’m always looking for fellow data warriors to join me in this battle!”
Data cleansing should be viewed as a skill unto itself. But, just about everything requires some form of data cleansing or reshaping. This session will take on real-world data cleansing using various Excel features—from the old, tried and true to the brand new and powerful. From ordinary formulas and pivot tables to XLOOKUP, Dynamic Arrays […]