Skip to main content
HomeExcel

Data Preparation in Excel

4.5+
32 reviews
Beginner

Understand how to prepare Excel data through logical functions, nested formulas, lookup functions, and PivotTables.

Start Course for Free
3 hours9 videos28 exercises35,243 learnersTrophyStatement of Accomplishment

Create Your Free Account

GoogleLinkedInFacebook

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.
For Business

Training 2 or more people?

Get your team access to the full DataCamp platform, including all the features.
DataCamp for BusinessFor a bespoke solution book a demo.

In the following Tracks

Excel Fundamentals

Go To Track
  1. 1

    Starting Data Preparation in Excel

    Free

    In this chapter, you’ll learn different ways to source and import your raw data into Excel. You will then start your preparation of raw data by removing duplicates added in error and filling in the missing parts of your data that will help you prepare the best dataset for analytical use.

    Play Chapter Now
    The data preparation journey
    50 xp
    Data preparation steps
    100 xp
    Load and clean data
    50 xp
    Importing files
    100 xp
    Deduping
    100 xp
    Flashy filling
    100 xp
    Series filling
    100 xp
  2. 2

    Functions for Data Preparation

    In this chapter, you’ll learn how to use text category functions to combine text strings with useful variables for better analysis. You will also utilize some of Excel's date and time functions, taking simple date columns to a new level.

    Play Chapter Now
    Text and date functions
    50 xp
    Which function category?
    100 xp
    More functions, better preparation
    50 xp
    Equal length
    100 xp
    Joining together
    100 xp
    Dates and more
    100 xp
  3. 3

    Conditional Formulas

    In this chapter, you’ll learn how to use logical functions to create conditional formulas for new flags and filters for your data. You will combine the logical operators to create nested formulas, specifically using the IF function to create new category data. Additionally, you will understand how to differentiate between notes and comments in Excel and use them effectively to share information with others.

    Play Chapter Now
    Using logical functions in formulas
    50 xp
    Which conditional formula is right?
    50 xp
    Logical data preparation
    50 xp
    To be, or NOT to be
    100 xp
    Functions two by two
    100 xp
    Well nested IF functions
    100 xp
    Notes and comments
    100 xp
  4. 4

    Lookups and Data Transformation

    In this chapter, you’ll finish by looking at some important lookup and reference functions available within Excel, specifically the VLOOKUP and HLOOKUP functions. Additionally, you’ll be introduced to the powerful world of PivotTables, which helps you summarize and analyze large volumes of data through dynamic tables.

    Play Chapter Now
    Lookups and PivotTables
    50 xp
    Good arguments
    50 xp
    Referencing and summarization
    50 xp
    Look up, not down
    100 xp
    Pivot. Pivot!
    100 xp
    A category of products
    100 xp
    Grand total percentages
    100 xp
    Congratulations!
    50 xp
For Business

Training 2 or more people?

Get your team access to the full DataCamp platform, including all the features.

In the following Tracks

Excel Fundamentals

Go To Track

datasets

Exercises and DatasetsExcel Formula Translations

collaborators

Collaborator's avatar
Carl Rosseel
Collaborator's avatar
Jess Ahmet

prerequisites

Introduction to Excel
Iason Prassides HeadshotIason Prassides

Content Developer at DataCamp

Iason holds a Master’s degree in Chemistry from UCL and is now a Curriculum Manager at DataCamp. He is also a certified Power BI data analyst. Prior to working at DataCamp, Iason held a number of analytics roles within a range of industries across different countries. Having a passion for education, data, and storytelling, he has found a great place at DataCamp to develop engaging content for learning. As an avid sports fan, he has a keen interest in sports statistics.
See More

Don’t just take our word for it

*4.5
from 32 reviews
75%
16%
6%
0%
3%
Sort by
  • Khin C.
    2 days

    Excellent!

  • Srijan P.
    2 months

    Kudos to the team at DataCamp.

  • Shanmuga M.
    6 months

    Excellent!

  • Priscilla C.
    7 months

    I felt like actually working as a Jr in a real project

  • Kwame B.
    7 months

    I like the approach to learning.

"Excellent!"

Khin C.

"Kudos to the team at DataCamp."

Srijan P.

"Excellent!"

Shanmuga M.

FAQs

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

Create Your Free Account

GoogleLinkedInFacebook

or

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