Module 03 · Clean it in Power Query

Remove the columns you don't need

Remove Source.Name and Catatan so the file is lighter and refreshes faster.

Step by step4 minLesson 11 of 37 Members

Not every column is used in the dashboard. Source.Name only holds the file name (the month is already in Tanggal), and Catatan is almost always empty: only 44 of the 1,056 rows have a note. Every unused column makes the file heavier and refresh slower, so we remove both at once.

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.

3 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