Data Manipulation In Excel

About This Course

This is a customized course which covers most effective used of data manipulation techniques to clean dirty data so that can create an organize and correct data format in the report.

Learning Objectives

By the end of the course, learner will be able to:

  • Import data from txt, csv, and unprotected PDF file
  • Clean dirty data


Learners must have advance knowledge & skill in Microsoft Excel.


Target Audience

Learners who need to compile and create a powerful analysis report by using the most effective tips & tricks in Microsoft Excel.

Training Outline

  1. Import Data from External Sources
  2. Arrange Data in Column and Row
  3. Remove Blank Cells or Spaces
  4. Convert Data into the Correct Format
  5. Identify and Remove the Duplicate Data
  6. Find & Replace Data
  7. Changing the Case of Text
  8. Sorting