Free
Course

Data Manipulation in Excel

Learn how to import, clean, validate, and protect data in Microsoft Excel.

4.41 out of 5 stars
This course includes
2,693 learners enrolled
This course includes
  • Skill level

    Beginner
  • Time to complete

    Average based on combined completion rates — individual pacing in lessons, projects, and quizzes may vary
     
    1 hour
  • Projects

    1
  • Prerequisites

    None

About this course

Continue your Excel learning journey with Data Manipulation in Excel. Microsoft Excel is among the most widely used technologies for sharing and distributing data. Learn how to clean, validate, and protect datasets in Excel

Skills you'll gain

  • Import data from a variety of sources

  • Clean and inspect data

  • Protect data in advance of distribution

Syllabus

The platform

Hands-on learning

Animated GIF of an AI provided error explanation within Codecademy's learning environment
An AI-generated hint within the instructions of a Codecademy project
Animated GIF of Codecademy's Job Readiness Checker tool generating a compatibility report for a senior software engineer role
Animated GIF of building a phone screen interview using Codecademy's Interview Simulator
A fill-in-the-blank JavaScript question in a Codecademy assessment
Meet the creator of the course
Ada Morse
Data Science Instructional Designer at Codecademy
Ada is a Data Science Instructional Designer at Codecademy. Her background is in mathematics, with a Ph.D. focused on the design of self-assembling DNA nanostructures. Ada has worked on courses across our Data Science catalog, covering topics including Python, Excel, and Data Engineering.

Earn a certificate of completion

Show your network you've done the work by earning a certificate of completion for each course or path you finish.
  • Show proofReceive a certificate that demonstrates you've completed a course or path.
  • Build a collectionThe more courses and paths you complete, the more certificates you collect.
  • Share with your networkEasily add certificates of completion to your LinkedIn profile to share your accomplishments.

Data Manipulation in Excel course ratings and reviews

4.41 out of 5 stars
133 ratings
  1. 5 stars
  2. 4 stars
  3. 3 stars
  4. 2 stars
  5. 1 star
  • The progress I have made since starting to use codecademy is immense! I can study for short periods or long periods at my own convenience - mostly late in the evenings.
    Chris
    Codecademy Learner @ USA
  • I felt like I learned months in a week. I love how Codecademy uses learning by practice and gives great challenges to help the learner to understand a new concept and subject.
    Rodrigo
    Codecademy Learner @ UK
  • Brilliant learning experience. Very interactive. Literally a game changer if you're learning on your own.
    John-Andrew
    Codecademy Learner @ USA

Our learners work at

  • Google Logo
  • Meta Logo
  • Apple Logo
  • EA Logo
  • Amazon Logo
  • IBM Logo
  • Microsoft Logo
  • Reddit Logo
  • Spotify Logo
  • Uber Logo
  • YouTube Logo
  • Instagram Logo

Join over 50 million learners and start Data Manipulation in Excel today!

Unlock additional features with a paid plan

  • Practice Projects

    Guided projects that help you solidify the skills and concepts you're learning.
  • Assessments

    Auto-graded quizzes and immediate feedback help you reinforce your skills as you learn.
  • Certificate of Completion

    Earn a document to prove you've completed a course or path that you can share with your network.