Data cleansing should be viewed as a skill unto itself. Not all data needs in with a dashboard or automated tool. 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 and Power Query.
We’re going to look at strategies and what Excel features to use when so that we can get whatever we need from our data.