A well-structured daily cleaning checklist in Excel should have the following columns:
| Area | Task | Frequency | Mon | Tue | Wed | Thu | Fri | Initials | Notes | | :--- | :--- | :--- | :--- | :--- | :--- | :--- | :--- | :--- | :--- | | Lobby | Disinfect door handles | Hourly | ☑ | ☑ | ☑ | ☑ | ☑ | AJ | | | Restroom | Refill soap dispensers | Daily | ☑ | ☑ | ☐ | ☑ | ☑ | ML | Out of soap | | Kitchen | Sanitize countertops | 2x daily | ☑ | ☑ | ☑ | ☑ | ☑ | TR | |
By protecting the sheet (except for the checkboxes and notes columns), a supervisor ensures that data cannot be tampered with. The file can be saved as a master template (e.g., Cleaning_Checklist_Template.xltx) and copied each week for a fresh start. checklist kebersihan harian excel portable
Add a shift selector (Morning, Afternoon, Night). Use =TEXT(NOW(),"dddd") to auto-populate the day of the week.
Save your file as Checklist_Kebersihan_Harian.xltx (Excel Template). This ensures every time you open it, it creates a new daily file without overwriting the master design. A well-structured daily cleaning checklist in Excel should
You do not need complex macros to make a powerful checklist. Here is how to structure your Checklist Kebersihan Harian Excel Portable file.
Kunci sel-sel yang berisi daftar tugas (Kolom A-C) agar tidak terhapus secara tidak sengaja saat diisi di HP. Use =TEXT(NOW(),"dddd") to auto-populate the day of the
Bukan berarti aplikasi Excel itu sendiri portable secara resmi, tetapi file checklist dan environment-nya bisa dijalankan dari USB tanpa meninggalkan data di komputer lokal.
.
LOVE