Module 03 · Clean it in Power Query

Set the right data types

Change Tanggal to Date, check Jumlah, read the recipe in Applied Steps, then Close & Load.

Step by step5 minLesson 13 of 37 Members

This is the step people skip most often, and the one that causes the most trouble in later modules. A Tanggal column that isn’t a date type can’t be linked to the Kalender table, and a Jumlah column stored as text can’t be summed. Five seconds now saves an hour later. After that you read the full recipe in Applied Steps and go back to Excel.

Members only

Continue this course with a membership

Modules 1–2 of the Excel course are free. This lesson and 27 more are open to active members.

4 steps with a numbered picture
All 37 Excel lessons, plus the Power BI, Tableau & Data Viz courses
A new Excel & dashboard template every day, with resell rights
Take paid client projects on the Project Board

Become a member & unlock all Already a member? Sign in

One payment for 12 months, no automatic renewal. Back to the free lessons