Speaker – Oz du Soleil – The Active Cell

SPEAKER

Oz du Soleil

By day, he wrestles with Crap Data in Excel, taming the orneriest of the ornery. When the workbooks are closed, Oz is a kaleidoscope collector and maker, and is happiest on long roadtrips.

Oz wields 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—including Perth, Australia; Sofia, Bulgaria, and São Paulo, Brazil—to get the most from their data via Excel and Power Query.

Based in Las Vegas, you can catch Oz in action on YouTube at Excel on Fire; his many courses on the LinkedIn Library; books co-authored with Bill Jelen, Mr. Excel; and the lively commentary he’s done for MEWC and MECC competitions.

Nov 30 | 10:15 AM - 11:15 AM

Build a Reusable Data Cleaning Workflow

You want a basic dashboard. A shift scheduler. Or just get enrollment data in one place so it can be sorted and filtered—and update when the data changes. Straightforward needs.

But the data won’t cooperate.

Source data is scattered hither and yon. Formats are all over the place. There are gaps that need to be filled in.

Basic needs that immediately have you probing dark alleys amidst shadowy figures who mean you no good.

But … Excel’s Power Query! Your tool for heroism and success.

Join Oz for this hands-on session where you’ll learn to use Power Query as an automated data-cleansing tool. This session will be rooted in real world needs. Sweeping data into one place with consistent formatting, peeling out what you don’t need … weaving together real solutions that make data useful and cooperative so that you can do anything you need to do.

At the end of this session you’ll know how to apply fundamental data-cleansing techniques and build an automated process with Excel’s Power Query.

Learning Objectives

By the end of this session, you will: