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...
Enroll Now - Select a section to enroll in
Type
2 week
Dates
May 08, 2024 to May 21, 2024
Total Number of Hours
16.0
Course Fee(s)
Standard Price $1,199.00
Section Notes

IMPORTANT COURSE INFORMATION

  • The courses in this certificate use Microsoft Excel 2016 for Windows. We highly recommend you use this version of Excel so you can easily replicate the tools and functions demonstrated in the course.
Type
2 week
Dates
Jul 03, 2024 to Jul 16, 2024
Total Number of Hours
16.0
Course Fee(s)
Standard Price $1,199.00
Section Notes

IMPORTANT COURSE INFORMATION

  • The courses in this certificate use Microsoft Excel 2016 for Windows. We highly recommend you use this version of Excel so you can easily replicate the tools and functions demonstrated in the course.
Type
2 week
Dates
Aug 28, 2024 to Sep 10, 2024
Total Number of Hours
16.0
Course Fee(s)
Standard Price $1,199.00
Section Notes

IMPORTANT COURSE INFORMATION

  • The courses in this certificate use Microsoft Excel 2016 for Windows. We highly recommend you use this version of Excel so you can easily replicate the tools and functions demonstrated in the course.
Type
2 week
Dates
Oct 23, 2024 to Nov 05, 2024
Total Number of Hours
16.0
Course Fee(s)
Standard Price $1,199.00
Section Notes

IMPORTANT COURSE INFORMATION

  • The courses in this certificate use Microsoft Excel 2016 for Windows. We highly recommend you use this version of Excel so you can easily replicate the tools and functions demonstrated in the course.
Type
2 week
Dates
Dec 18, 2024 to Dec 31, 2024
Total Number of Hours
16.0
Course Fee(s)
Standard Price $1,199.00
Section Notes

IMPORTANT COURSE INFORMATION

  • The courses in this certificate use Microsoft Excel 2016 for Windows. We highly recommend you use this version of Excel so you can easily replicate the tools and functions demonstrated in the course.
Required fields are indicated by .