Skip to main content
HomeExcel

Course

Data Preparation in Excel

BeginnerSkill Level
4.8+
1,972 reviews
Updated 02/2025
Understand how to prepare Excel data through logical functions, nested formulas, lookup functions, and PivotTables.
Start Course for Free

Included withPremium or Teams

ExcelData Preparation3 hours9 videos28 Exercises2,250 XP53,336Statement of Accomplishment

Create Your Free Account

or

By continuing, you accept our Terms of Use, our Privacy Policy and that your data is stored in the USA.
Group

Training 2 or more people?

Try DataCamp for Business

Loved by learners at thousands of companies

Course Description

Starting data preparation in Excel

In this course, you’ll learn how to prepare and clean raw data in Excel worksheets. This course focuses on helping you utilize the numerous features in Excel that allow you to bring in data from different sources and prepare the data by filtering, deduping, and organizing your columns and rows to ensure subsequent analysis tasks are done as efficiently as possible.

Useful functions to prepare data

As well as the built-in features Excel offers, you will learn to use different functions to handle and manipulate dates and text strings.

Nesting logical functions

You will be introduced to logical functions that will allow you to create new flags and categories within your raw data while understanding how different logical functions can be combined in nested formulas.

Lookups and new table types

You will also understand how to use lookup functions in Excel to bring in data from different sheets and identify specific results within large datasets. Finally, you will get your first glimpse of PivotTables - a powerful Excel feature that allows you to summarize and analyze large volumes of data using dynamic tables.

Prerequisites

Introduction to Excel
1

Starting Data Preparation in Excel

Start Chapter
2

Functions for Data Preparation

Start Chapter
3

Conditional Formulas

Start Chapter
4

Lookups and Data Transformation

Start Chapter
Data Preparation in Excel
Course
Complete

Earn Statement of Accomplishment

Add this credential to your LinkedIn profile, resume, or CV
Share it on social media and in your performance review

Included withPremium or Teams

Enroll Now

Don’t just take our word for it

*4.8
from 1,972 reviews
82%
17%
1%
0%
0%
  • Shanuka
    about 3 hours

  • AHMED MOHAMMED AHMED
    about 4 hours

  • An
    about 5 hours

  • Saroop
    about 6 hours

  • Hoa
    about 9 hours

  • Piero Raúl
    about 11 hours

Shanuka

AHMED MOHAMMED AHMED

Saroop

FAQs

Join over 17 million learners and start Data Preparation in Excel today!

Create Your Free Account

or

By continuing, you accept our Terms of Use, our Privacy Policy and that your data is stored in the USA.