Curriculum
Memahami Rumus Rumus pada Microsoft Excel
Belajar Rumus Excel
0/46
-
1. Cara Mengacak Data Excel jadi Random pake Rumus RAND
Pratinjau -
2. Cara Mengatasi Error #N/A dengan IFERROR
Pratinjau
-
3. Cara menghitung umur/usia pake rumus Excel
Pratinjau
-
4. Menghitung Absensi Hari Kerja dengan Rumus NETWORKDAYSSorry, this lesson is currently locked. You need to complete "3. Cara menghitung umur/usia pake rumus Excel" before accessing it.
-
5. Belajar Rumus IF Bertingkat (Nested IF)Sorry, this lesson is currently locked. You need to complete "4. Menghitung Absensi Hari Kerja dengan Rumus NETWORKDAYS" before accessing it.
-
6. Belajar Rumus AVERAGEIFSorry, this lesson is currently locked. You need to complete "5. Belajar Rumus IF Bertingkat (Nested IF)" before accessing it.
-
7. Mengubah Angka menjadi Angka Romawi dengan rumus ROMANSorry, this lesson is currently locked. You need to complete "6. Belajar Rumus AVERAGEIF" before accessing it.
-
8. Belajar Rumus VLOOKUPSorry, this lesson is currently locked. You need to complete "7. Mengubah Angka menjadi Angka Romawi dengan rumus ROMAN" before accessing it.
-
9. Cara Membulatkan ke Atas untuk Ratusan atau Ribuan TerdekatSorry, this lesson is currently locked. You need to complete "8. Belajar Rumus VLOOKUP" before accessing it.
-
10. Cara Membulatkan Data Angka DesimalSorry, this lesson is currently locked. You need to complete "9. Cara Membulatkan ke Atas untuk Ratusan atau Ribuan Terdekat" before accessing it.
-
11. Cara Menggunakan Rumus VLOOKUP dan HLOOKUPSorry, this lesson is currently locked. You need to complete "10. Cara Membulatkan Data Angka Desimal" before accessing it.
-
12. Menjumlahkan Data dengan Rumus SUM, SUMIF, dan SUMIFSSorry, this lesson is currently locked. You need to complete "11. Cara Menggunakan Rumus VLOOKUP dan HLOOKUP" before accessing it.
-
13. 25 RUMUS EXCEL PALING PENTINGSorry, this lesson is currently locked. You need to complete "12. Menjumlahkan Data dengan Rumus SUM, SUMIF, dan SUMIFS" before accessing it.
-
14. Wajib Bisa 15 Rumus Excel Untuk Tes Admin Dan Seleksi Kerja (2021)Sorry, this lesson is currently locked. You need to complete "13. 25 RUMUS EXCEL PALING PENTING" before accessing it.
-
15. Rumus Count, Countif, Dan CountifsSorry, this lesson is currently locked. You need to complete "14. Wajib Bisa 15 Rumus Excel Untuk Tes Admin Dan Seleksi Kerja (2021)" before accessing it.
-
16. Belajar Rumus Average, Averageif, Dan AverageifsSorry, this lesson is currently locked. You need to complete "15. Rumus Count, Countif, Dan Countifs" before accessing it.
-
17. Cara VLOOKUP Data ke Kiri dengan Rumus Index MatchSorry, this lesson is currently locked. You need to complete "16. Belajar Rumus Average, Averageif, Dan Averageifs" before accessing it.
-
18. Belajar Kombinasi Rumus VLOOKUP dengan Left, Mid, dan RightSorry, this lesson is currently locked. You need to complete "17. Cara VLOOKUP Data ke Kiri dengan Rumus Index Match" before accessing it.
-
19. Cara Menghitung Persentase di ExcelSorry, this lesson is currently locked. You need to complete "18. Belajar Kombinasi Rumus VLOOKUP dengan Left, Mid, dan Right" before accessing it.
-
20. Mencari 3 Nilai Terbesar dan Terkecil di Excel dengan LARGE dan SMALLSorry, this lesson is currently locked. You need to complete "19. Cara Menghitung Persentase di Excel" before accessing it.
-
21. 8 Rumus untuk Mengolah Data WaktuSorry, this lesson is currently locked. You need to complete "20. Mencari 3 Nilai Terbesar dan Terkecil di Excel dengan LARGE dan SMALL" before accessing it.
-
22. Cara Menggunakan Rumus SUMPRODUCT di ExcelSorry, this lesson is currently locked. You need to complete "21. 8 Rumus untuk Mengolah Data Waktu" before accessing it.
-
23. Cara Menghitung Tanggal Kadaluwarsa (Expiry Date) dengan Rumus EDATE dan EOMONTHSorry, this lesson is currently locked. You need to complete "22. Cara Menggunakan Rumus SUMPRODUCT di Excel" before accessing it.
-
24. Cara Menggunakan Rumus XLOOKUP di ExcelSorry, this lesson is currently locked. You need to complete "23. Cara Menghitung Tanggal Kadaluwarsa (Expiry Date) dengan Rumus EDATE dan EOMONTH" before accessing it.
-
25. Cara Menggunakan Rumus Aggregate untuk Menjumlahkan Data dengan FilterSorry, this lesson is currently locked. You need to complete "24. Cara Menggunakan Rumus XLOOKUP di Excel" before accessing it.
-
26. Cara Paling Mudah Menggabungkan Banyak Sel di ExcelSorry, this lesson is currently locked. You need to complete "25. Cara Menggunakan Rumus Aggregate untuk Menjumlahkan Data dengan Filter" before accessing it.
-
27. Cara Mencari Nilai Terbesar dan Terkecil dengan KriteriaSorry, this lesson is currently locked. You need to complete "26. Cara Paling Mudah Menggabungkan Banyak Sel di Excel" before accessing it.
-
28. Cara Menghitung Banyak Sel Kosong dengan Rumus COUNTBLANKSorry, this lesson is currently locked. You need to complete "27. Cara Mencari Nilai Terbesar dan Terkecil dengan Kriteria" before accessing it.
-
29. Cara Membuat Banyak Hyperlink dengan CepatSorry, this lesson is currently locked. You need to complete "28. Cara Menghitung Banyak Sel Kosong dengan Rumus COUNTBLANK" before accessing it.
-
30. Cara Menggunakan Rumus Index MatchSorry, this lesson is currently locked. You need to complete "29. Cara Membuat Banyak Hyperlink dengan Cepat" before accessing it.
-
31. Memahami Bedanya Count, Counta, dan CountblankSorry, this lesson is currently locked. You need to complete "30. Cara Menggunakan Rumus Index Match" before accessing it.
-
32. Cara Menggunakan Rumus Left, Mid, dan RightSorry, this lesson is currently locked. You need to complete "31. Memahami Bedanya Count, Counta, dan Countblank" before accessing it.
-
33. Mengekstrak Data dengan Kombinasi Rumus LEFT, RIGHT, FIND, dan LENSorry, this lesson is currently locked. You need to complete "32. Cara Menggunakan Rumus Left, Mid, dan Right" before accessing it.
-
34. 5 Cara Menjumlahkan Data di ExcelSorry, this lesson is currently locked. You need to complete "33. Mengekstrak Data dengan Kombinasi Rumus LEFT, RIGHT, FIND, dan LEN" before accessing it.
-
35. Cara Menghitung Diskon di ExcelSorry, this lesson is currently locked. You need to complete "34. 5 Cara Menjumlahkan Data di Excel" before accessing it.
-
36. Cara Menghitung Tanggal di Masa DepanSorry, this lesson is currently locked. You need to complete "35. Cara Menghitung Diskon di Excel" before accessing it.
-
37. 8 Rumus Statistik di Excel yang Lo Wajib Bisa!Sorry, this lesson is currently locked. You need to complete "36. Cara Menghitung Tanggal di Masa Depan" before accessing it.
-
38. 4 Cara Menggabungkan Data di ExcelSorry, this lesson is currently locked. You need to complete "37. 8 Rumus Statistik di Excel yang Lo Wajib Bisa!" before accessing it.
-
39. Cara Menggunakan Wildcard di ExcelSorry, this lesson is currently locked. You need to complete "38. 4 Cara Menggabungkan Data di Excel" before accessing it.
-
40. 3 Cara Menghitung Umur di ExcelSorry, this lesson is currently locked. You need to complete "39. Cara Menggunakan Wildcard di Excel" before accessing it.
-
41. 30 Menit Jago Rumus IFSorry, this lesson is currently locked. You need to complete "40. 3 Cara Menghitung Umur di Excel" before accessing it.
-
42. Cara Menjumlahkan Data dengan 2 Kriteria - Tutorial Rumus SUMIFSSorry, this lesson is currently locked. You need to complete "41. 30 Menit Jago Rumus IF" before accessing it.
-
43. Cara Jago Excel dengan ChatGPTSorry, this lesson is currently locked. You need to complete "42. Cara Menjumlahkan Data dengan 2 Kriteria - Tutorial Rumus SUMIFS" before accessing it.
-
44. 3 Contoh Mengekstrak Data dengan Rumus Left dan FindSorry, this lesson is currently locked. You need to complete "43. Cara Jago Excel dengan ChatGPT" before accessing it.
-
45. Cara Menggunakan Rumus IF dengan Kriteria WaktuSorry, this lesson is currently locked. You need to complete "44. 3 Contoh Mengekstrak Data dengan Rumus Left dan Find" before accessing it.
-
46. 4 Alasan Kenapa Rumus VLOOKUP Lo Error N/A (dan cara ngatasinnya!)Sorry, this lesson is currently locked. You need to complete "45. Cara Menggunakan Rumus IF dengan Kriteria Waktu" before accessing it.
Tugas Praktek
0/1
Video