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
Nov 20, 2024 to Dec 03, 2024
Total Number of Hours
16.0
Course Fee(s)
Contract Fee $100.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
Feb 12, 2025 to Feb 25, 2025
Total Number of Hours
16.0
Course Fee(s)
Contract Fee $100.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
May 07, 2025 to May 20, 2025
Total Number of Hours
16.0
Course Fee(s)
Contract Fee $100.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 30, 2025 to Aug 12, 2025
Total Number of Hours
16.0
Course Fee(s)
Contract Fee $100.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 22, 2025 to Nov 04, 2025
Total Number of Hours
16.0
Course Fee(s)
Contract Fee $100.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 .