Congratulations!

Data Preparation in Excel

Iason Prassides

Content Developer, DataCamp

Chapter 1

  • Ways to import data
    • Using different file types

Cartoon image of people loading and transferring files into a computer

Data Preparation in Excel

Chapter 1

  • Ways to import data
    • Using different file types
  • Clean our data
    • Remove duplicates feature

An image of a broom cleaning source code and remove duplicates

Data Preparation in Excel

Chapter 1

  • Ways to import data
    • Using different file types
  • Clean our data
    • Remove duplicates feature
  • Added and manipulated data
    • Utilized Excel fill features

Filling in the missing piece of a puzzle

Data Preparation in Excel

Chapter 2

  • Learned new text functions
    • Combined text strings together

Cartoon image of people using puzzle shapes with letters on to build a word.

Data Preparation in Excel

Chapter 2

  • Learned new text functions
    • Combined text strings together
  • Learned new date functions
    • Added extra date information to our dataset

Image of a group of people searching a calendar and marking things.

Data Preparation in Excel

Chapter 2

  • Learned new text functions
    • Combined text strings together
  • Learned new date functions
    • Added extra date information to our dataset
  • Considered security and protection in Excel
    • Protecting specific worksheets

Image of two people protecting a computer and mobile screen

Data Preparation in Excel

Chapter 3

  • Used logical operators
    • Created flags for filtering

Images of the word TRUE in green, and FALSE in red.

Data Preparation in Excel

Chapter 3

  • Used logical operators
    • Created flags for filtering
  • Nested functions using IF() function
    • Added new categorical variables

Image of a woman thinking about possible directions or outcomes to take, with three arrows behind her showing different directions.

Data Preparation in Excel

Chapter 3

  • Used logical operators
    • Created flags for filtering
  • Nested functions using IF() function
    • Added new categorical variables
  • Sharing is caring
    • Notes and comments when sharing files

A selection of word clouds and speech bubbles all in different colors.

Data Preparation in Excel

Chapter 4

  • Lookup functions
    • Bring information in from other sheets

A woman holding up a magnifying glass with a file on a screen in the background.

Data Preparation in Excel

Chapter 4

  • Lookup functions
    • Bring information in from other sheets
  • PivotTables
    • Summarize data in dynamic tables

An image of many different financial objects around, and working on a table like grid on a screen.

Data Preparation in Excel

The Excel journey!

Data Preparation in Excel

Preparing Video For Download...