Data cleaning dengan microsoft excel

Practical Excel techniques for messy data

Real-world data is rarely clean, and this course — taught in Indonesian — focuses on the everyday techniques needed to fix it inside Microsoft Excel before any analysis can happen. Rather than covering Excel broadly, it stays tightly scoped to the specific functions and workflows used for data cleaning.

What you'll learn

• Checking spelling and standardizing text entries
• Key Excel functions commonly used for data cleaning
• Removing extra spaces and filling in missing data
• Converting text to numeric values and removing duplicate rows
• Flagging errors and normalizing upper/lower case text

Who it's for

Beginners working with spreadsheets — analysts, students, or anyone handling messy datasets — who want a focused toolkit for getting data analysis-ready in Excel.