Environmental Data Initiative Five Phases of Data Publishing Webinar - How to clean and format data using Excel, OpenRefine, and Excel

Key Info
URL - the landing page for the learning resource: 
https://www.youtube.com/watch
Description - a brief synopsis, abstract or summary of what the learning resource is about: 

This webinar provides an overview of some of the tools available for formatting and cleaning data,  guidance on tool suitability and limitations, and an example dataset and instructions for working with those tools.

This video in the Environmental Data Initiative (EDI) "Five Phases of Data Publishing" tutorial series covers the second phase of data publishing, cleaning data.

For more guidance from EDI on data cleaning, also see " Creating 'clean' data for archiving," located here:  https://www.youtube.com/watch?v=gW_-XTwJ1OA.

Authoring Person(s) Name: 
Colin Smith
Authoring Organization(s) Name: 
Environmental Data Initiative (EDI)
Access Cost: 
No fee
Primary language(s) in which the learning resource was originally published or made available: 
English
More info about
Keywords - short phrases describing what the learning resource is about: 
Data cleaning
Data publication
Data transformation
Data wrangling
Digital scholarship
Subject Discipline - subject domain(s) toward which the learning resource is targeted: 
Physical Sciences and Mathematics: Environmental Sciences
Published / Broadcast: 
Wednesday, February 14, 2018
Publisher - organization credited with publishing or broadcasting the learning resource: 
Environmental Data Initiative (EDI)
Media Type - designation of the form in which the content of the learning resource is represented, e.g., moving image: 
Event - time-based happening that is portrayed or covered by the learning resource, e.g., a webinar.
Educational Info
Purpose - primary educational reason for which the learning resource was created: 
Instruction - detailed information about aspects or processes related to data management or data skills.
Learning Resource Type - category of the learning resource from the point of view of a professional educator: 
Unit - long-range plan of instruction on a particular concept containing multiple, related lessons.
Target Audience - intended audience for which the learning resource was created: 
Early-career research scientist
Graduate student
Mid-career research scientist
Research faculty
Research scientist
Undergraduate student
Intended time to complete - approximate amount of time the average student will take to complete the learning resource: 
Up to 1 hour
Framework - A community-based organization plan or set of steps for education or training: 
FAIR Data Principles
Framework Node: FAIR: 
Accessible
Findable
Re-usable