Loading...

Course Description

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.

Faculty Author

Kathryn Caggiano

Benefits to the Learner

  • Transform the structure of your data by completing missing data and converting data to the right format
  • Find and fix common errors found in both text and numeric data
  • Augment your dataset with new data fields using existing and supplemental information sources

Target Audience

  • Finance professionals
  • Data analysts
  • Data scientists
  • Business analysts
  • Engineers
  • Managers and executives
  • Students who need in-depth Excel knowledge

Applies Towards the Following Certificates

Loading...
Cornell College of Engineering
Thank you for your interest in this course. Unfortunately, the course you have selected is currently not open for enrollment. Please complete a Course Inquiry so that we may promptly notify you when enrollment opens.
Required fields are indicated by .