Have you ever received a dataset that contains useful information but you can't quite get your hands on it? The data may not be in the right format, may have errors, or perhaps require additional elements. Though these usability issues can make it difficult or even impossible to get answers to important questions, we can often transform a dataset like this into something ready to use when it has an underlying structure.

In this course, you will discover how to make data usable by following a disciplined process of transforming, cleaning, and synthesizing data. You will gain hands-on practice getting your data ready by using filters and logical functions to structure data, identify errors, and create a “clean” dataset. Upon completion of this course, you will have developed the skills necessary to create a transformed dataset in Excel that you can then use to develop informative dashboards or perform critical analyses.