17
Feb 2021
Cara membuat Absen Online dengan Google Formulir + rekap Bulan, Semester, Tahunan | Part 2
Bismillahirrohmanirrohim Video Ke-12, semoga bermanfaat, tentang Cara membuat Daftar Hadir Online dengan Google Formulir + Rekap Bulan, Semester, Tahunan File Google Spreadsheet : https://bit.ly/2OPa8eS Link Formulir : https://bit.ly/30Jgh1A Part 1 : https://youtu.be/d-qpmKrTo2U RUMUS : TGL DAFTAR =arrayformula(if(row(A:A)=1;”TANGGAL DAFTAR”;ARRAYFORMULA(IF((A:A)=””;””;TEXT(A:A;”DD/MM/YYYY”))))) KODE =arrayformula(if(row(A:A)=1;”Kode”;ARRAYFORMULA(C:C&text(F:F;”DD/MM/YYYY”)))) KEHADIRAN =arrayformula(if(row(A:A)=1;”Kehadiran”;ARRAYFORMULA(IF((A:A)=””;””;if(E:E=”Hadir”;”H”;if(E:E=”Sakit”;”S”;if(E:E=”Izin”;”i”))))))) REKAP ABSENSI BULANAN =iferror(VLOOKUP(CONCATENATE($D6;text(E$5;”DD/MM/YYYY”));RESPON!$G:$H;2;0);”a”) rumus yang lain bisa di lihat di file Google Spreadsheet diatas.
17
Feb 2021
Cara membuat Absen Online dengan Google Formulir + Rekap Bulan, Semester, Tahunan | Part 1
Bismillahirrohmanirrohim Video Ke-11, semoga bermanfaat, tentang Cara membuat Daftar Hadir Online dengan Google Formulir + Rekap Bulan, Semester, Tahunan File Google Spreadsheet : https://bit.ly/2OPa8eS Link Formulir : https://bit.ly/30Jgh1A Part 2 : https://youtu.be/3zU0Xe13r7s RUMUS : TGL DAFTAR =arrayformula(if(row(A:A)=1;”TANGGAL DAFTAR”;ARRAYFORMULA(IF((A:A)=””;””;TEXT(A:A;”DD/MM/YYYY”))))) KODE =arrayformula(if(row(A:A)=1;”Kode”;ARRAYFORMULA(C:C&text(F:F;”DD/MM/YYYY”)))) KEHADIRAN =arrayformula(if(row(A:A)=1;”Kehadiran”;ARRAYFORMULA(IF((A:A)=””;””;if(E:E=”Hadir”;”H”;if(E:E=”Sakit”;”S”;if(E:E=”Izin”;”i”))))))) REKAP ABSENSI BULANAN =iferror(VLOOKUP(CONCATENATE($D6;text(E$5;”DD/MM/YYYY”));RESPON!$G:$H;2;0);”a”) rumus yang lain bisa di lihat di file Google Spreadsheet diatas.
17
Feb 2021
Buat tugas Classroom di HP Android | No PC No Laptop
Bismillahirrohmanirrohim Video Ke-10, semoga bermanfaat, tentang cara Buat Tugas Classroom di HP Android Part 1 : Install Google Device Policy di HP Android/Aktivasi Akun G Suite for Education https://www.youtube.com/watch?v=oPba8… Part 2 : Install Google Classroom di HP Android https://www.youtube.com/watch?v=T84Oj… Part 3 : Install Google Chrome di HP Android https://www.youtube.com/watch?v=t-PTs… Part 4 : Install Google Calendar di HP Android https://www.youtube.com/watch?v=Dafgt… Part...
17
Feb 2021
Install Aplikasi Google Meet, Media Tatap Muka secara Virtual | Part 5
Bismillahirrohmanirrohim Video Kedelapan, semoga bermanfaat, tentang cara install Google Meet (Media Tatap Muka Virtual) Part 1 : Install Google Device Policy di HP Android/Aktivasi Akun G Suite for Education https://www.youtube.com/watch?v=oPba8… Part 2 : Install Google Classroom di HP Android https://www.youtube.com/watch?v=T84Oj… Part 3 : Install Google Chrome di HP Android https://www.youtube.com/watch?v=t-PTs… Part 4 : Install Google Calendar di HP Android https://www.youtube.com/watch?v=Dafgt…...
17
Feb 2021
Cara Install Google Calendar sinkronisasi dengan Jadwal Pelajaran | Part 4
Bismillahirrohmanirrohim Video Ketujuh, semoga bermanfaat, tentang cara install Google Calendar dan Sinkronisasi Jadwal Pelajaran Part 1 : Install Google Device Policy di HP Android/Aktivasi Akun G Suite for Education https://www.youtube.com/watch?v=oPba8… Part 2 : Install Google Classroom di HP Android https://www.youtube.com/watch?v=T84Oj… Part 3 : Install Google Chrome di HP Android https://www.youtube.com/watch?v=t-PTs… Part 5 : Install Google Meet di HP Android https://www.youtube.com/watch?v=p9rZL…...
17
Feb 2021
Install Google Chrome + Login Akun G Suite | Part 3
Bismillahirrohmanirrohim Video Keenam, semoga bermanfaat, tentang cara install Google Chrome dan Login menggunakan akun G Suite for Education Part 1 : Install Google Device Policy di HP Android/Aktivasi Akun G Suite for Education https://www.youtube.com/watch?v=oPba8… Part 2 : Install Google Classroom di HP Android https://www.youtube.com/watch?v=T84Oj… Part 4 : Install Google Calendar di HP Android https://www.youtube.com/watch?v=Dafgt… Part 5 : Install Google Meet...
17
Feb 2021
Install Google Classroom+Login Akun G Suite | Part 2
Bismillahirrohmanirrohim Video Kelima, semoga bermanfaat, tentang cara install Google Classroom dan Login menggunakan akun G Suite for Education Part 1 : Install Google Device Policy di HP Android/Aktivasi Akun G Suite for Education https://www.youtube.com/watch?v=oPba8… Part 3 : Install Google Chrome di HP Android https://www.youtube.com/watch?v=t-PTs… Part 4 : Install Google Calendar di HP Android https://www.youtube.com/watch?v=Dafgt… Part 5 : Install Google Meet...
17
Feb 2021
Aktivasi Akun G Suite for Education di HP Android | Part 1
Bismillahirrohmanirrohim Video Keempat, semoga bermanfaat, tentang cara aktivasi akun G Suite for Education dengan Google Device Policy Part 2 : Install Google Classroom di HP Android https://www.youtube.com/watch?v=T84Oj… Part 3 : Install Google Chrome di HP Android https://www.youtube.com/watch?v=t-PTs… Part 4 : Install Google Calendar di HP Android https://www.youtube.com/watch?v=Dafgt… Part 5 : Install Google Meet di HP Android https://www.youtube.com/watch?v=p9rZL… #GoogleDevicePolicy #GSE...
Komentar Terbaru