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
Prerequisites
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
- Import Data from External Sources
- Arrange Data in Column and Row
- Remove Blank Cells or Spaces
- Convert Data into the Correct Format
- Identify and Remove the Duplicate Data
- Find & Replace Data
- Changing the Case of Text
- Sorting