{"id":666,"date":"2019-02-04T21:53:00","date_gmt":"2019-02-04T21:53:00","guid":{"rendered":"http:\/\/178.128.221.236\/paitototo\/dewatogel\/index.php\/2019\/02\/04\/28-rumus-excel-di-dunia-kerja-paling-penting-wajib-tahu\/"},"modified":"2019-02-04T21:53:00","modified_gmt":"2019-02-04T21:53:00","slug":"28-rumus-excel-di-dunia-kerja-paling-penting-wajib-tahu","status":"publish","type":"post","link":"http:\/\/www.paitodewatogel.net\/index.php\/2019\/02\/04\/28-rumus-excel-di-dunia-kerja-paling-penting-wajib-tahu\/","title":{"rendered":"28 Rumus Excel di Dunia Kerja Paling Penting | Wajib Tahu!"},"content":{"rendered":"<div style=\"text-align: center;\"><a href=\"http:\/\/www.dewagongball.com\/link.php?member=nextiruz\" target=\"_blank\" rel=\"noopener noreferrer\"><img loading=\"lazy\" decoding=\"async\" border=\"0\" height=\"274\" src=\"https:\/\/2.bp.blogspot.com\/-Odt6xQ1qiQ0\/XFiv1aG2VII\/AAAAAAAAJaU\/ywMLzOjYLuoFS8GiY8ujpraUkuDZzrnRACK4BGAYYCw\/s640\/rumus-excel-bannerx-c589b.jpg\" width=\"640\" \/><\/a><\/div>\n<div style=\"background-color: white; color: #2d2d2d; font-family: &quot;Open Sans&quot;; font-size: 16px; line-height: 31px; margin-bottom: 20px; margin-top: 15px;\">Bagi pelajar atau pekerja kantoran, pasti sudah tidak asing lagi dengan&nbsp;<span style=\"font-weight: 700;\"><a href=\"http:\/\/www.dewagongball.com\/link.php?member=nextiruz\" target=\"_blank\" rel=\"noopener noreferrer\">Microsoft Excel<\/a><\/span>.<\/div>\n<div style=\"background-color: white; color: #2d2d2d; font-family: &quot;Open Sans&quot;; font-size: 16px; line-height: 31px; margin-bottom: 20px;\"><a data-href=\"https:\/\/jalantikus.com\/tips\/software-edit-video-terbaik\/\" href=\"http:\/\/www.dewagongball.com\/link.php?member=nextiruz\" style=\"-webkit-tap-highlight-color: rgba(255, 255, 255, 0); color: #ce0a46; outline: 0px; text-decoration-line: none;\" target=\"_blank\" rel=\"noopener noreferrer\"><em>Software<\/em><\/a>&nbsp;pengolah angka terbaik buatan <a href=\"http:\/\/www.dewagongball.com\/link.php?member=nextiruz\" target=\"_blank\" rel=\"noopener noreferrer\">Microsoft <\/a>ini terbukti mampu mempercepat penggunannya saat menghitung beragam angka.<\/div>\n<div style=\"background-color: white; box-sizing: border-box; color: #2d2d2d; font-family: &quot;Open Sans&quot;; font-size: 16px; margin-left: auto; margin-right: auto; max-height: none; max-width: 300px; overflow: hidden; position: relative;\"><\/div>\n<div style=\"background-color: white; box-sizing: border-box; color: #2d2d2d; font-family: &quot;Open Sans&quot;; font-size: 16px; margin-left: auto; margin-right: auto; max-height: none; max-width: 320px; overflow: hidden; position: relative;\"><\/div>\n<div style=\"background-color: white; box-sizing: border-box; color: #2d2d2d; font-family: &quot;Open Sans&quot;; font-size: 16px; margin-left: auto; margin-right: auto; max-height: 120px; max-width: 728px; overflow: hidden; position: relative;\"><\/div>\n<div style=\"background-color: white; color: #2d2d2d; font-family: &quot;Open Sans&quot;; font-size: 16px; line-height: 31px; margin-bottom: 20px;\">Nah, kunci sukses memakai&nbsp;<a data-href=\"https:\/\/jalantikus.com\/apps\/microsoft-excel\/\" href=\"http:\/\/www.dewagongball.com\/link.php?member=nextiruz\" style=\"-webkit-tap-highlight-color: rgba(255, 255, 255, 0); color: #ce0a46; outline: 0px; text-decoration-line: none;\" target=\"_blank\" rel=\"noopener noreferrer\">Microsoft Excel<\/a>&nbsp;adalah dengan memanfaatkan rumus-rumusnya untuk memudahkan perhitungan. Sayangnya, banyak orang nggak tahu apa saja&nbsp;<a href=\"http:\/\/www.dewagongball.com\/link.php?member=nextiruz\" target=\"_blank\" rel=\"noopener noreferrer\"><span style=\"font-weight: 700;\">rumus Excel<\/span>&nbsp;<\/a>yang bisa digunakan.<\/div>\n<div style=\"background-color: white; color: #2d2d2d; font-family: &quot;Open Sans&quot;; font-size: 16px; line-height: 31px; margin-bottom: 20px;\">Apakah kamu salah satunya?<\/div>\n<div style=\"background-color: white; color: #2d2d2d; font-family: &quot;Open Sans&quot;; font-size: 16px; line-height: 31px; margin-bottom: 20px;\">Jangan khawatir. <a href=\"http:\/\/www.dewagongball.com\/link.php?member=nextiruz\" target=\"_blank\" rel=\"noopener noreferrer\">DewaTogel <\/a>punya contekan daftar rumus Excel penting yang wajib kamu tahu.<\/div>\n<h2 style=\"background-color: white; color: #2d2d2d; font-family: &quot;Open Sans&quot;; font-size: 22px; line-height: 35px; margin-bottom: 15px; padding-right: 10px;\">Tentang Microsoft Excel<\/h2>\n<div style=\"text-align: center;\"><a href=\"http:\/\/www.dewagongball.com\/link.php?member=nextiruz\" target=\"_blank\" rel=\"noopener noreferrer\"><img loading=\"lazy\" decoding=\"async\" border=\"0\" height=\"364\" src=\"https:\/\/3.bp.blogspot.com\/-a-Y113al7mc\/XFiwFVLHHoI\/AAAAAAAAJag\/Q1Ri0aEYAIwNk99sSugz937DVA86ZFxpACK4BGAYYCw\/s640\/rumus-excel-di-dunia-kerja-0-77c25.jpeg\" width=\"640\" \/><\/a><\/div>\n<div>\n<div style=\"background-color: white; color: #2d2d2d; font-family: &quot;Open Sans&quot;; font-size: 16px; line-height: 31px; margin-bottom: 20px;\">Sebelum mengetahui rumus-rumus apa saja yang ada di&nbsp;<span style=\"font-weight: 700;\"><a href=\"http:\/\/www.dewagongball.com\/link.php?member=nextiruz\" target=\"_blank\" rel=\"noopener noreferrer\">Microsoft Excel<\/a><\/span>, ada baiknya kamu tahu dulu geng serba-serbi tentang&nbsp;<a href=\"http:\/\/www.dewagongball.com\/link.php?member=nextiruz\" target=\"_blank\" rel=\"noopener noreferrer\"><em>software<\/em>&nbsp;<\/a>tersebut.<\/div>\n<div style=\"background-color: white; color: #2d2d2d; font-family: &quot;Open Sans&quot;; font-size: 16px; line-height: 31px; margin-bottom: 20px;\"><span style=\"font-weight: 700;\"><a href=\"http:\/\/www.dewagongball.com\/link.php?member=nextiruz\" target=\"_blank\" rel=\"noopener noreferrer\">Microsoft Office Excel<\/a><\/span>&nbsp;atau sering hanya disebut dengan&nbsp;<span style=\"font-weight: 700;\"><a href=\"http:\/\/www.dewagongball.com\/link.php?member=nextiruz\" target=\"_blank\" rel=\"noopener noreferrer\">Excel<\/a><\/span>&nbsp;merupakan sebuah program&nbsp;<a href=\"http:\/\/www.dewagongball.com\/link.php?member=nextiruz\" target=\"_blank\" rel=\"noopener noreferrer\"><em>spreadsheet<\/em>&nbsp;<\/a>atau lembar kerja yang bisa kamu gunakan di PC maupun handphone.<\/div>\n<div style=\"background-color: white; color: #2d2d2d; font-family: &quot;Open Sans&quot;; font-size: 16px; line-height: 31px; margin-bottom: 20px;\">Sebagai bagian dari keluarga besar dari Microsoft Office, Excel memiliki fitur untuk melakukan kalkulasi dan pembuatan grafik yang lebih mudah.<\/div>\n<h3 style=\"background-color: white; color: #2d2d2d; font-family: &quot;Open Sans&quot;; font-size: 19px; line-height: 30px; margin-bottom: 18px;\">Sejarah Microsoft Excel<\/h3>\n<div style=\"background-color: white; color: #2d2d2d; font-family: &quot;Open Sans&quot;; font-size: 16px; line-height: 31px; margin-bottom: 20px;\">Sebelum bernama Excel,&nbsp;<em>software<\/em>&nbsp;ini pertama kali rilis dengan nama&nbsp;<span style=\"font-weight: 700;\"><a href=\"http:\/\/www.dewagongball.com\/link.php?member=nextiruz\" target=\"_blank\" rel=\"noopener noreferrer\">Multiplan<\/a><\/span>&nbsp;pada tahun 1982. Microsoft melakukan itu untuk menyaingi software&nbsp;<em><a href=\"http:\/\/www.dewagongball.com\/link.php?member=nextiruz\" target=\"_blank\" rel=\"noopener noreferrer\">spreadsheet<\/a><\/em>&nbsp;lainnya, terutama&nbsp;<span style=\"font-weight: 700;\"><a href=\"http:\/\/www.dewagongball.com\/link.php?member=nextiruz\" target=\"_blank\" rel=\"noopener noreferrer\">Lotus 1-2-3<\/a><\/span>.<\/div>\n<div style=\"background-color: white; color: #2d2d2d; font-family: &quot;Open Sans&quot;; font-size: 16px; line-height: 31px; margin-bottom: 20px;\">Karena gagal bersaing, akhirnya Microsoft mengganti namanya menjadi Excel pada tahun 1985 untuk&nbsp;<span style=\"font-weight: 700;\"><a href=\"http:\/\/www.dewagongball.com\/link.php?member=nextiruz\" target=\"_blank\" rel=\"noopener noreferrer\">Macintosh<\/a><\/span>-nya Apple. Untuk versi&nbsp;<span style=\"font-weight: 700;\"><a href=\"http:\/\/www.dewagongball.com\/link.php?member=nextiruz\" target=\"_blank\" rel=\"noopener noreferrer\">Windows<\/a><\/span>-nya sendiri baru rilis dua tahun kemudian, yakni 1987.<\/div>\n<div style=\"background-color: white; color: #2d2d2d; font-family: &quot;Open Sans&quot;; font-size: 16px; line-height: 31px; margin-bottom: 20px;\">Semenjak itu, Excel mulai menggusur posisi Lotus 1-2-3 sebagai&nbsp;<em><a href=\"http:\/\/www.dewagongball.com\/link.php?member=nextiruz\" target=\"_blank\" rel=\"noopener noreferrer\">software spreadsheet<\/a><\/em>&nbsp;paling populer untuk mengolah data-data.<\/div>\n<h3 style=\"background-color: white; color: #2d2d2d; font-family: &quot;Open Sans&quot;; font-size: 19px; line-height: 30px; margin-bottom: 18px;\">Fungsi Microsoft Excel<\/h3>\n<div style=\"background-color: white; color: #2d2d2d; font-family: &quot;Open Sans&quot;; font-size: 16px; line-height: 31px; margin-bottom: 20px;\">Pada&nbsp;<span style=\"font-weight: 700;\"><a href=\"http:\/\/www.dewagongball.com\/link.php?member=nextiruz\" target=\"_blank\" rel=\"noopener noreferrer\">Microsoft Excel<\/a><\/span>, kita akan berkerja dalam sebuah satu&nbsp;<span style=\"font-weight: 700;\"><em><a href=\"http:\/\/www.dewagongball.com\/link.php?member=nextiruz\" target=\"_blank\" rel=\"noopener noreferrer\">workbook<\/a><\/em><\/span>. Di dalam satu&nbsp;<em>workbook<\/em>, terdapat beberapa&nbsp;<em><a href=\"http:\/\/www.dewagongball.com\/link.php?member=nextiruz\" target=\"_blank\" rel=\"noopener noreferrer\">worksheet<\/a><\/em>&nbsp;yang bisa kamu gunakan untuk memisahkan data yang berbeda, sehingga kamu tidak perlu membuat&nbsp;<em><a href=\"http:\/\/www.dewagongball.com\/link.php?member=nextiruz\" target=\"_blank\" rel=\"noopener noreferrer\">workbook<\/a><\/em>&nbsp;yang baru.<\/div>\n<div style=\"background-color: white; color: #2d2d2d; font-family: &quot;Open Sans&quot;; font-size: 16px; line-height: 31px; margin-bottom: 20px;\">Excel merupakan aplikasi yang diperuntukkan untuk <a href=\"http:\/\/www.dewagongball.com\/link.php?member=nextiruz\" target=\"_blank\" rel=\"noopener noreferrer\">mengolah data secara otomatis<\/a>, baik data berupa perhitungan dasar (<a href=\"http:\/\/www.dewagongball.com\/link.php?member=nextiruz\" target=\"_blank\" rel=\"noopener noreferrer\">tambah, kurang, bagi, kali<\/a>) maupun penggunaan fungsi yang lebih kompleks.<\/div>\n<div style=\"background-color: white; color: #2d2d2d; font-family: &quot;Open Sans&quot;; font-size: 16px; line-height: 31px; margin-bottom: 20px;\">Selain untuk mengolah data, Excel juga bisa digunakan untuk menyelesaikan berbagai keperluan administrasi karena kemampuannya yang dapat menampung jumlah data yang besar.<\/div>\n<div style=\"background-color: white; color: #2d2d2d; font-family: &quot;Open Sans&quot;; font-size: 16px; line-height: 31px; margin-bottom: 20px;\">Dengan kemampuannya yang dapat menemukan dengan cepatnya menemukan pola dan proses pada data, Excel cocok untuk digunakan untuk membuat:<\/div>\n<ul style=\"background-color: white; color: #2d2d2d; font-family: &quot;Open Sans&quot;; font-size: 16px; list-style: none; padding-left: 0px;\">\n<li style=\"line-height: 30px;\">\n<div style=\"padding-left: 40px; position: relative;\">\n<div style=\"line-height: 31px; margin-bottom: 20px;\"><a href=\"http:\/\/www.dewagongball.com\/link.php?member=nextiruz\" target=\"_blank\" rel=\"noopener noreferrer\">Membuat laporan keuangan perusahaan<\/a>, seperti laba dan rugi perusahaan, gaji karyawan, dan lain sebagainya.<\/div>\n<\/div>\n<\/li>\n<li style=\"line-height: 30px;\">\n<div style=\"padding-left: 40px; position: relative;\">\n<div style=\"line-height: 31px; margin-bottom: 20px;\"><a href=\"http:\/\/www.dewagongball.com\/link.php?member=nextiruz\" target=\"_blank\" rel=\"noopener noreferrer\">Membuat daftar presensi untuk suatu acara<\/a>, walaupun kamu juga bisa menggunakan Microsoft Word.<\/div>\n<\/div>\n<\/li>\n<li style=\"line-height: 30px;\">\n<div style=\"padding-left: 40px; position: relative;\">\n<div style=\"line-height: 31px; margin-bottom: 20px;\"><a href=\"http:\/\/www.dewagongball.com\/link.php?member=nextiruz\" target=\"_blank\" rel=\"noopener noreferrer\">Membuat daftar nilai untuk guru maupun dosen<\/a> karena Excel mampu melakukan fitur seperti mencari nilai rata-rata, mencari nilai tengah, mencari nilai maksimum minimum, dan lain-lain.<\/div>\n<\/div>\n<\/li>\n<li style=\"line-height: 30px;\">\n<div style=\"padding-left: 40px; position: relative;\">\n<div style=\"line-height: 31px; margin-bottom: 20px;\"><a href=\"http:\/\/www.dewagongball.com\/link.php?member=nextiruz\" target=\"_blank\" rel=\"noopener noreferrer\">Menghitung data dengan cepat<\/a>, tidak hanya perhitungan dasar namun juga variasinya.<\/div>\n<\/div>\n<\/li>\n<li style=\"line-height: 30px;\">\n<div style=\"padding-left: 40px; position: relative;\">\n<div style=\"line-height: 31px; margin-bottom: 20px;\"><a href=\"http:\/\/www.dewagongball.com\/link.php?member=nextiruz\" target=\"_blank\" rel=\"noopener noreferrer\">Membuat grafik dan tabel untuk sebuah tabel data<\/a>. Contohnya, grafik pertumbungan&nbsp;<em><a href=\"http:\/\/www.dewagongball.com\/link.php?member=nextiruz\" target=\"_blank\" rel=\"noopener noreferrer\">traffic<\/a><\/em>&nbsp;sebuah website, grafik pertumbuhan ekonomi, dan lain sebagainya.<\/div>\n<\/div>\n<\/li>\n<li style=\"line-height: 30px;\">\n<div style=\"padding-left: 40px; position: relative;\">\n<div style=\"line-height: 31px; margin-bottom: 20px;\">Menyajikan data secara tepat, rapi, dan akurat<\/div>\n<\/div>\n<\/li>\n<\/ul>\n<h3 style=\"background-color: white; color: #2d2d2d; font-family: &quot;Open Sans&quot;; font-size: 19px; line-height: 30px; margin-bottom: 18px;\">Kelebihan Microsoft Excel<\/h3>\n<div style=\"background-color: white; color: #2d2d2d; font-family: &quot;Open Sans&quot;; font-size: 16px; line-height: 31px; margin-bottom: 20px;\">Salah satu hal yang menyebabkan Microsoft Excel populer adalah antarmukanya yang ramah dan fitur-fiturnya yang cukup lengkap.<\/div>\n<div style=\"background-color: white; color: #2d2d2d; font-family: &quot;Open Sans&quot;; font-size: 16px; line-height: 31px; margin-bottom: 20px;\">Sama seperti&nbsp;<em><a href=\"http:\/\/www.dewagongball.com\/link.php?member=nextiruz\" target=\"_blank\" rel=\"noopener noreferrer\">software spreadsheet<\/a><\/em>&nbsp;lainnya, Excel memiliki sel yang tersusun atas baris dan kolom. Data yang bisa ditampung oleh Excel adalah&nbsp;<span style=\"font-weight: 700;\"><a href=\"http:\/\/www.dewagongball.com\/link.php?member=nextiruz\" target=\"_blank\" rel=\"noopener noreferrer\">1 juta baris<\/a><\/span>&nbsp;dan&nbsp;<span style=\"font-weight: 700;\"><a href=\"http:\/\/www.dewagongball.com\/link.php?member=nextiruz\" target=\"_blank\" rel=\"noopener noreferrer\">16 ribu kolom<\/a><\/span>.<\/div>\n<div style=\"background-color: white; color: #2d2d2d; font-family: &quot;Open Sans&quot;; font-size: 16px; line-height: 31px; margin-bottom: 20px;\">Dengan kemampuannya untuk menampung data yang masif ini, Excel akan mempermudah kita dalam mengolah data yang kita punya untuk dianalisa dan direpresentasikan dalam bentuk grafik maupun&nbsp;<em><a href=\"http:\/\/www.dewagongball.com\/link.php?member=nextiruz\" target=\"_blank\" rel=\"noopener noreferrer\">chart<\/a><\/em>.<\/div>\n<div style=\"background-color: white; color: #2d2d2d; font-family: &quot;Open Sans&quot;; font-size: 16px; line-height: 31px; margin-bottom: 20px;\">Selain itu,&nbsp;<a href=\"http:\/\/www.dewagongball.com\/link.php?member=nextiruz\" target=\"_blank\" rel=\"noopener noreferrer\"><em>software<\/em>&nbsp;<\/a>ini memiliki formula dan rumus yang lengkap. Apalagi, sekarang kamu bisa mengakses aplikasi Excel melalui&nbsp;<a href=\"http:\/\/www.dewagongball.com\/link.php?member=nextiruz\" target=\"_blank\" rel=\"noopener noreferrer\"><em>smartphone<\/em>&nbsp;<\/a>yang kamu miliki.<\/div>\n<h3 style=\"background-color: white; color: #2d2d2d; font-family: &quot;Open Sans&quot;; font-size: 19px; line-height: 30px; margin-bottom: 18px;\">Kekurangan Microsoft Excel<\/h3>\n<div style=\"background-color: white; color: #2d2d2d; font-family: &quot;Open Sans&quot;; font-size: 16px; line-height: 31px; margin-bottom: 20px;\">Di balik semua kelebihannya tersebut, tentu Excel memiliki beberapa kekurangan. Salah satunya adalah&nbsp;<em>software<\/em>&nbsp;ini akan memakan <a href=\"http:\/\/www.dewagongball.com\/link.php?member=nextiruz\" target=\"_blank\" rel=\"noopener noreferrer\">RAM <\/a>yang cukup besar ketika dioperasikan.<\/div>\n<div style=\"background-color: white; color: #2d2d2d; font-family: &quot;Open Sans&quot;; font-size: 16px; line-height: 31px; margin-bottom: 20px;\">Selain itu, terlalu lengkapnya rumus yang dimiliki membuat pengguna baru membutuhkan waktu yang cukup panjang untuk memahami fungsi dari rumus-rumus tersebut.<\/div>\n<div style=\"background-color: white; color: #2d2d2d; font-family: &quot;Open Sans&quot;; font-size: 16px; line-height: 31px; margin-bottom: 20px;\"><a href=\"http:\/\/www.dewagongball.com\/link.php?member=nextiruz\" target=\"_blank\" rel=\"noopener noreferrer\">Fungsi auto kalkulasi<\/a> yang dimiliki Excel juga bisa membuatmu mengalami error apabila salah dalam memasukkan rumus.<\/div>\n<h2 style=\"background-color: white; color: #2d2d2d; font-family: &quot;Open Sans&quot;; font-size: 22px; line-height: 35px; margin-bottom: 15px; padding-right: 10px;\">Jenis-Jenis File Microsoft Excel<\/h2>\n<div style=\"background-color: white; color: #2d2d2d; font-family: &quot;Open Sans&quot;; font-size: 16px; line-height: 31px; margin-bottom: 20px;\">Mungkin kamu belum tahu nih geng kalu sebenarnya Excel memiliki beberapa tipe yang berbeda-beda lo! Supaya enggak bingung apa aja <a href=\"http:\/\/www.dewagongball.com\/link.php?member=nextiruz\" target=\"_blank\" rel=\"noopener noreferrer\">jenis file Excel<\/a>, langsung aja yuk baca artikel di bawah ini!<\/div>\n<h3 style=\"background-color: white; color: #2d2d2d; font-family: &quot;Open Sans&quot;; font-size: 19px; line-height: 30px; margin-bottom: 18px;\"><a href=\"http:\/\/www.dewagongball.com\/link.php?member=nextiruz\" target=\"_blank\" rel=\"noopener noreferrer\">Format .xls<\/a><\/h3>\n<div style=\"background-color: white; color: #2d2d2d; font-family: &quot;Open Sans&quot;; font-size: 16px; line-height: 31px; margin-bottom: 20px;\">Format ini merupakan format&nbsp;<em>default<\/em>&nbsp;dari Excel sebelum versi 12 (Excel 2003 ke bawah)<\/div>\n<h3 style=\"background-color: white; color: #2d2d2d; font-family: &quot;Open Sans&quot;; font-size: 19px; line-height: 30px; margin-bottom: 18px;\"><a href=\"http:\/\/www.dewagongball.com\/link.php?member=nextiruz\" target=\"_blank\" rel=\"noopener noreferrer\">Format .xlsx<\/a><\/h3>\n<div style=\"background-color: white; color: #2d2d2d; font-family: &quot;Open Sans&quot;; font-size: 16px; line-height: 31px; margin-bottom: 20px;\">Format&nbsp;<em>default<\/em>&nbsp;untuk versi Excel 2003 ke atas yang telah berbasis&nbsp;<span style=\"font-weight: 700;\">XML<\/span>&nbsp;(Extensible Markup Languange). Adanya XML akan membuat keperluan bertukar data antar sistem yang beragam menjadi lebih mudah.<\/div>\n<h3 style=\"background-color: white; color: #2d2d2d; font-family: &quot;Open Sans&quot;; font-size: 19px; line-height: 30px; margin-bottom: 18px;\"><a href=\"http:\/\/www.dewagongball.com\/link.php?member=nextiruz\" target=\"_blank\" rel=\"noopener noreferrer\">Format .xlt<\/a><\/h3>\n<div style=\"background-color: white; color: #2d2d2d; font-family: &quot;Open Sans&quot;; font-size: 16px; line-height: 31px; margin-bottom: 20px;\">Format untuk&nbsp;<em>template worksheet<\/em>&nbsp;Excel untuk versi 12 ke bawah. Format yang satu ini masih berbasis&nbsp;<span style=\"font-weight: 700;\">BIFF<\/span>&nbsp;(Binary Interchange File Format) dan mampu menyimpan&nbsp;<span style=\"font-weight: 700;\">macro VBA<\/span>&nbsp;(Visual Basic for Application).<\/div>\n<h3 style=\"background-color: white; color: #2d2d2d; font-family: &quot;Open Sans&quot;; font-size: 19px; line-height: 30px; margin-bottom: 18px;\">Format Excel Selengkapnya . . .<\/h3>\n<h3 style=\"background-color: white; color: #2d2d2d; font-family: &quot;Open Sans&quot;; font-size: 19px; line-height: 30px; margin-bottom: 18px;\"><a href=\"http:\/\/www.dewagongball.com\/link.php?member=nextiruz\" target=\"_blank\" rel=\"noopener noreferrer\">Format .XML<\/a><\/h3>\n<div style=\"background-color: white; color: #2d2d2d; font-family: &quot;Open Sans&quot;; font-size: 16px; line-height: 31px; margin-bottom: 20px;\">Disebut juga sebagai&nbsp;<span style=\"font-weight: 700;\">XML Spreadsheet<\/span>, format ini tidak mampu menampung&nbsp;<em>macro VBA<\/em>.<\/div>\n<h3 style=\"background-color: white; color: #2d2d2d; font-family: &quot;Open Sans&quot;; font-size: 19px; line-height: 30px; margin-bottom: 18px;\"><a href=\"http:\/\/www.dewagongball.com\/link.php?member=nextiruz\" target=\"_blank\" rel=\"noopener noreferrer\">Format .xla<\/a><\/h3>\n<div style=\"background-color: white; color: #2d2d2d; font-family: &quot;Open Sans&quot;; font-size: 16px; line-height: 31px; margin-bottom: 20px;\">Merupakan format&nbsp;<em>default<\/em>&nbsp;untuk&nbsp;<span style=\"font-weight: 700;\">Excel Add-in<\/span>&nbsp;sebelum Excel 2003. Add-in sendiri adalah sebuah tambahan yang dapat menyediakan perintah dan fitur opsional untuk Microsoft Excel.<\/div>\n<h3 style=\"background-color: white; color: #2d2d2d; font-family: &quot;Open Sans&quot;; font-size: 19px; line-height: 30px; margin-bottom: 18px;\"><a href=\"http:\/\/www.dewagongball.com\/link.php?member=nextiruz\" target=\"_blank\" rel=\"noopener noreferrer\">Format .xlsm<\/a><\/h3>\n<div style=\"background-color: white; color: #2d2d2d; font-family: &quot;Open Sans&quot;; font-size: 16px; line-height: 31px; margin-bottom: 20px;\">Merupakan format&nbsp;<em>worksheet<\/em>&nbsp;untuk Microsoft Excel 2003 ke atas. Format ini telah berbasais XML dan mampu menyimpan&nbsp;<em>macro VBA<\/em>.<\/div>\n<h3 style=\"background-color: white; color: #2d2d2d; font-family: &quot;Open Sans&quot;; font-size: 19px; line-height: 30px; margin-bottom: 18px;\"><a href=\"http:\/\/www.dewagongball.com\/link.php?member=nextiruz\" target=\"_blank\" rel=\"noopener noreferrer\">Format .xlsb<\/a><\/h3>\n<div style=\"background-color: white; color: #2d2d2d; font-family: &quot;Open Sans&quot;; font-size: 16px; line-height: 31px; margin-bottom: 20px;\">Format&nbsp;<em>worksheet<\/em>&nbsp;yang berbasis XML namun dikodekan dalam bentuk bilangan biner. Keunggulan dari format ini adalah cepatnya pemrosesan data mengingat jenis Excel yang satu ini memang ditujukan untuk memproses&nbsp;<em>worksheet<\/em>&nbsp;yang sangat besar.<\/div>\n<h3 style=\"background-color: white; color: #2d2d2d; font-family: &quot;Open Sans&quot;; font-size: 19px; line-height: 30px; margin-bottom: 18px;\"><a href=\"http:\/\/www.dewagongball.com\/link.php?member=nextiruz\" target=\"_blank\" rel=\"noopener noreferrer\">Format .xltm<\/a><\/h3>\n<div style=\"background-color: white; color: #2d2d2d; font-family: &quot;Open Sans&quot;; font-size: 16px; line-height: 31px; margin-bottom: 20px;\">Merupakan pengganti dari format&nbsp;<span style=\"font-weight: 700;\">.xlt<\/span>&nbsp;yang mampu menyimpan&nbsp;<em>macro VBA<\/em>&nbsp;dan memiliki basis XML.<\/div>\n<h3 style=\"background-color: white; color: #2d2d2d; font-family: &quot;Open Sans&quot;; font-size: 19px; line-height: 30px; margin-bottom: 18px;\"><a href=\"http:\/\/www.dewagongball.com\/link.php?member=nextiruz\" target=\"_blank\" rel=\"noopener noreferrer\">Format .xlam<\/a><\/h3>\n<div style=\"background-color: white; color: #2d2d2d; font-family: &quot;Open Sans&quot;; font-size: 16px; line-height: 31px; margin-bottom: 20px;\">Merupakan format untuk&nbsp;<em>Excel Add-in<\/em>&nbsp;yang secara&nbsp;<em>default<\/em>&nbsp;mampu menangani&nbsp;<em>macro VBA<\/em>.<\/div>\n<div style=\"background-color: white; color: #2d2d2d; font-family: &quot;Open Sans&quot;; font-size: 16px; line-height: 31px; margin-bottom: 20px;\">Nah, setelah mengetahui sekelumit fakta tentang Microsoft Excel, saatnya untuk mengetahui&nbsp;<span style=\"font-weight: 700;\">rumus Excel<\/span>&nbsp;apa saja sih yang sering digunakan di dunia kerja.<\/div>\n<h2 style=\"background-color: white; color: #2d2d2d; font-family: &quot;Open Sans&quot;; font-size: 22px; line-height: 35px; margin-bottom: 15px; padding-right: 10px;\">Rumus Excel di Dunia Kerja yang Sering Dipakai<\/h2>\n<div style=\"background-color: white; color: #2d2d2d; font-family: &quot;Open Sans&quot;; font-size: 16px; line-height: 31px; margin-bottom: 20px;\">Udah punya aplikasinya? Kalau udah, kali ini&nbsp;<b><a href=\"http:\/\/www.dewagongball.com\/link.php?member=nextiruz\" target=\"_blank\" rel=\"noopener noreferrer\">DewaTogel&nbsp;<\/a><\/b>akan membagikan&nbsp;<span style=\"font-weight: 700;\">kumpulan rumus Excel lengkap beserta fungsinya<\/span>. Supaya cepat, kamu bisa menggunakan&nbsp;<span style=\"font-weight: 700;\">Ctrl + F<\/span>. Berikut daftarnya!<\/div>\n<h3 style=\"background-color: white; color: #2d2d2d; font-family: &quot;Open Sans&quot;; font-size: 19px; line-height: 30px; margin-bottom: 18px;\"><a href=\"http:\/\/www.dewagongball.com\/link.php?member=nextiruz\" target=\"_blank\" rel=\"noopener noreferrer\">IF<\/a><\/h3>\n<div style=\"background-color: white; color: #2d2d2d; font-family: &quot;Open Sans&quot;; font-size: 16px; line-height: 31px; margin-bottom: 20px;\">Fungsi&nbsp;<span style=\"font-weight: 700;\">rumus Excel IF<\/span>&nbsp;adalah mengambil salah satu dari dua nilai berdasarkan suatu kondisi. Logikanya sama seperti IF pada bahasa pemograman. Dalam satu fungsi, kamu bisa meletakkan beberapa IF tergantung kebutuhan.<\/div>\n<ul style=\"background-color: white; color: #2d2d2d; font-family: &quot;Open Sans&quot;; font-size: 16px; list-style: none; padding-left: 0px;\">\n<li style=\"line-height: 30px;\">\n<div style=\"padding-left: 40px; position: relative;\">\n<div style=\"line-height: 31px; margin-bottom: 20px;\">Rumus IF<code style=\"background-color: #fff7f7; border-radius: 15px; color: #654445; display: block; font-family: &quot;Open Sans&quot;; font-size: 15px; margin: 30px 15px; padding: 10px 25px; position: relative; text-align: center;\">IF(logical_test,[value_if_true],[value_if_false])<\/code><\/div>\n<\/div>\n<\/li>\n<li style=\"line-height: 30px;\">\n<div style=\"padding-left: 40px; position: relative;\">\n<div style=\"line-height: 31px; margin-bottom: 20px;\">Contoh IF<code style=\"background-color: #fff7f7; border-radius: 15px; color: #654445; display: block; font-family: &quot;Open Sans&quot;; font-size: 15px; margin: 30px 15px; padding: 10px 25px; position: relative; text-align: center;\">=IF(2&amp;lt;3,\"Benar\",\"Salah\") &amp;gt; \"Benar\" =IF(2&amp;gt;3,\"Benar\",\"Salah\") &amp;gt; \"Salah\"<\/code><\/div>\n<\/div>\n<\/li>\n<\/ul>\n<h3 style=\"background-color: white; color: #2d2d2d; font-family: &quot;Open Sans&quot;; font-size: 19px; line-height: 30px; margin-bottom: 18px;\"><a href=\"http:\/\/www.dewagongball.com\/link.php?member=nextiruz\" target=\"_blank\" rel=\"noopener noreferrer\">SUM<\/a><\/h3>\n<div style=\"background-color: white; color: #2d2d2d; font-family: &quot;Open Sans&quot;; font-size: 16px; line-height: 31px; margin-bottom: 20px;\">Fungsi&nbsp;<span style=\"font-weight: 700;\">rumus Excel SUM<\/span>&nbsp;adalah menjumlahkan sekumpulan angka. Yang bisa kamu jumlahkan bisa berupa angka-angka maupun kolom ke kolom.<\/div>\n<div style=\"background-color: white; color: #2d2d2d; font-family: &quot;Open Sans&quot;; font-size: 16px; line-height: 31px; margin-bottom: 20px;\">Contohnya, kamu ingin menjumlah data dari kolom A1 hingga A25, maka kamu tinggal menggunakan rumus ini dengan menyeleksi kolom A1 hingga A25.<\/div>\n<ul style=\"background-color: white; color: #2d2d2d; font-family: &quot;Open Sans&quot;; font-size: 16px; list-style: none; padding-left: 0px;\">\n<li style=\"line-height: 30px;\">\n<div style=\"padding-left: 40px; position: relative;\">\n<div style=\"line-height: 31px; margin-bottom: 20px;\">Rumus SUM<code style=\"background-color: #fff7f7; border-radius: 15px; color: #654445; display: block; font-family: &quot;Open Sans&quot;; font-size: 15px; margin: 30px 15px; padding: 10px 25px; position: relative; text-align: center;\">Sum(number1,[number2],..]<\/code><\/div>\n<\/div>\n<\/li>\n<li style=\"line-height: 30px;\">\n<div style=\"padding-left: 40px; position: relative;\">\n<div style=\"line-height: 31px; margin-bottom: 20px;\">Contoh SUM<code style=\"background-color: #fff7f7; border-radius: 15px; color: #654445; display: block; font-family: &quot;Open Sans&quot;; font-size: 15px; margin: 30px 15px; padding: 10px 25px; position: relative; text-align: center;\">=sum(2,3,5,6,11) &amp;gt; 28 =sum(A1:A25)<\/code><\/div>\n<\/div>\n<\/li>\n<\/ul>\n<h3 style=\"background-color: white; color: #2d2d2d; font-family: &quot;Open Sans&quot;; font-size: 19px; line-height: 30px; margin-bottom: 18px;\"><a href=\"http:\/\/www.dewagongball.com\/link.php?member=nextiruz\" target=\"_blank\" rel=\"noopener noreferrer\">Count<\/a><\/h3>\n<div style=\"background-color: white; color: #2d2d2d; font-family: &quot;Open Sans&quot;; font-size: 16px; line-height: 31px; margin-bottom: 20px;\">Fungsi&nbsp;<span style=\"font-weight: 700;\">rumus Excel Count<\/span>&nbsp;hampir sama dengan fungsi Sum, yakni menghitung jumlah&nbsp;<em>cell<\/em>&nbsp;yang berisi angka.<\/div>\n<ul style=\"background-color: white; color: #2d2d2d; font-family: &quot;Open Sans&quot;; font-size: 16px; list-style: none; padding-left: 0px;\">\n<li style=\"line-height: 30px;\">\n<div style=\"padding-left: 40px; position: relative;\">\n<div style=\"line-height: 31px; margin-bottom: 20px;\">Rumus Count<code style=\"background-color: #fff7f7; border-radius: 15px; color: #654445; display: block; font-family: &quot;Open Sans&quot;; font-size: 15px; margin: 30px 15px; padding: 10px 25px; position: relative; text-align: center;\">count(value1,[value2],..]<\/code><\/div>\n<\/div>\n<\/li>\n<li style=\"line-height: 30px;\">\n<div style=\"padding-left: 40px; position: relative;\">\n<div style=\"line-height: 31px; margin-bottom: 20px;\">Contoh Count<code style=\"background-color: #fff7f7; border-radius: 15px; color: #654445; display: block; font-family: &quot;Open Sans&quot;; font-size: 15px; margin: 30px 15px; padding: 10px 25px; position: relative; text-align: center;\">=count(a1:a10)<\/code><\/div>\n<\/div>\n<\/li>\n<\/ul>\n<h3 style=\"background-color: white; color: #2d2d2d; font-family: &quot;Open Sans&quot;; font-size: 19px; line-height: 30px; margin-bottom: 18px;\"><a href=\"http:\/\/www.dewagongball.com\/link.php?member=nextiruz\" target=\"_blank\" rel=\"noopener noreferrer\">CountA<\/a><\/h3>\n<div style=\"background-color: white; color: #2d2d2d; font-family: &quot;Open Sans&quot;; font-size: 16px; line-height: 31px; margin-bottom: 20px;\">Fungsi&nbsp;<span style=\"font-weight: 700;\">rumus Excel CountA<\/span>&nbsp;adalah menghitung jumlah&nbsp;<em>cell<\/em>&nbsp;yang ada datanya.<\/div>\n<ul style=\"background-color: white; color: #2d2d2d; font-family: &quot;Open Sans&quot;; font-size: 16px; list-style: none; padding-left: 0px;\">\n<li style=\"line-height: 30px;\">\n<div style=\"padding-left: 40px; position: relative;\">\n<div style=\"line-height: 31px; margin-bottom: 20px;\">Rumus CountA<code style=\"background-color: #fff7f7; border-radius: 15px; color: #654445; display: block; font-family: &quot;Open Sans&quot;; font-size: 15px; margin: 30px 15px; padding: 10px 25px; position: relative; text-align: center;\">counta(value1,[value2],..]<\/code><\/div>\n<\/div>\n<\/li>\n<li style=\"line-height: 30px;\">\n<div style=\"padding-left: 40px; position: relative;\">\n<div style=\"line-height: 31px; margin-bottom: 20px;\">Contoh CountA<code style=\"background-color: #fff7f7; border-radius: 15px; color: #654445; display: block; font-family: &quot;Open Sans&quot;; font-size: 15px; margin: 30px 15px; padding: 10px 25px; position: relative; text-align: center;\">=counta(a1:a10)<\/code><\/div>\n<\/div>\n<\/li>\n<\/ul>\n<h3 style=\"background-color: white; color: #2d2d2d; font-family: &quot;Open Sans&quot;; font-size: 19px; line-height: 30px; margin-bottom: 18px;\"><a href=\"http:\/\/www.dewagongball.com\/link.php?member=nextiruz\" target=\"_blank\" rel=\"noopener noreferrer\">CountIF<\/a><\/h3>\n<div style=\"background-color: white; color: #2d2d2d; font-family: &quot;Open Sans&quot;; font-size: 16px; line-height: 31px; margin-bottom: 20px;\">Fungsi&nbsp;<span style=\"font-weight: 700;\">rumus Excel CountIF<\/span>&nbsp;adalah menghitung jumlah&nbsp;<em>cell<\/em>&nbsp;pada suatu&nbsp;<em>range<\/em>&nbsp;yang punya satu kriteria tertentu.<\/div>\n<ul style=\"background-color: white; color: #2d2d2d; font-family: &quot;Open Sans&quot;; font-size: 16px; list-style: none; padding-left: 0px;\">\n<li style=\"line-height: 30px;\">\n<div style=\"padding-left: 40px; position: relative;\">\n<div style=\"line-height: 31px; margin-bottom: 20px;\">Rumus CountIF<code style=\"background-color: #fff7f7; border-radius: 15px; color: #654445; display: block; font-family: &quot;Open Sans&quot;; font-size: 15px; margin: 30px 15px; padding: 10px 25px; position: relative; text-align: center;\">countif(range,criteria)<\/code><\/div>\n<\/div>\n<\/li>\n<li style=\"line-height: 30px;\">\n<div style=\"padding-left: 40px; position: relative;\">\n<div style=\"line-height: 31px; margin-bottom: 20px;\">Contoh CountIF<code style=\"background-color: #fff7f7; border-radius: 15px; color: #654445; display: block; font-family: &quot;Open Sans&quot;; font-size: 15px; margin: 30px 15px; padding: 10px 25px; position: relative; text-align: center;\">=countif(a1:a10,\"A\")<\/code><\/div>\n<\/div>\n<\/li>\n<\/ul>\n<h3 style=\"background-color: white; color: #2d2d2d; font-family: &quot;Open Sans&quot;; font-size: 19px; line-height: 30px; margin-bottom: 18px;\">Rumus Excel Selengkapnya . . .<\/h3>\n<h3 style=\"background-color: white; color: #2d2d2d; font-family: &quot;Open Sans&quot;; font-size: 19px; line-height: 30px; margin-bottom: 18px;\"><a href=\"http:\/\/www.dewagongball.com\/link.php?member=nextiruz\" target=\"_blank\" rel=\"noopener noreferrer\">SumIF<\/a><\/h3>\n<div style=\"background-color: white; color: #2d2d2d; font-family: &quot;Open Sans&quot;; font-size: 16px; line-height: 31px; margin-bottom: 20px;\">Fungsi&nbsp;<span style=\"font-weight: 700;\">rumus Excel SumIF<\/span>&nbsp;adalah menjumlahkan suatu&nbsp;<em>item<\/em>&nbsp;di tabel yang cocok dengan kondisi tertentu.<\/div>\n<ul style=\"background-color: white; color: #2d2d2d; font-family: &quot;Open Sans&quot;; font-size: 16px; list-style: none; padding-left: 0px;\">\n<li style=\"line-height: 30px;\">\n<div style=\"padding-left: 40px; position: relative;\">\n<div style=\"line-height: 31px; margin-bottom: 20px;\">Rumus SumIF<code style=\"background-color: #fff7f7; border-radius: 15px; color: #654445; display: block; font-family: &quot;Open Sans&quot;; font-size: 15px; margin: 30px 15px; padding: 10px 25px; position: relative; text-align: center;\">sumif(range,criteria,[sum_range])<\/code><\/div>\n<\/div>\n<\/li>\n<li style=\"line-height: 30px;\">\n<div style=\"padding-left: 40px; position: relative;\">\n<div style=\"line-height: 31px; margin-bottom: 20px;\">Contoh SumIF<code style=\"background-color: #fff7f7; border-radius: 15px; color: #654445; display: block; font-family: &quot;Open Sans&quot;; font-size: 15px; margin: 30px 15px; padding: 10px 25px; position: relative; text-align: center;\">=sumif(a1:a6,\"Tempe\",B1:B6)<\/code><\/div>\n<\/div>\n<\/li>\n<\/ul>\n<h3 style=\"background-color: white; color: #2d2d2d; font-family: &quot;Open Sans&quot;; font-size: 19px; line-height: 30px; margin-bottom: 18px;\"><a href=\"http:\/\/www.dewagongball.com\/link.php?member=nextiruz\" target=\"_blank\" rel=\"noopener noreferrer\">Match<\/a><\/h3>\n<div style=\"background-color: white; color: #2d2d2d; font-family: &quot;Open Sans&quot;; font-size: 16px; line-height: 31px; margin-bottom: 20px;\">Fungsi&nbsp;<span style=\"font-weight: 700;\">rumus Excel Match<\/span>&nbsp;adalah menunjukkan posisi relatif suatu&nbsp;<em>item<\/em>&nbsp;di tabel yang cocok dengan kondisi atau kriteria tertentu.<\/div>\n<div style=\"background-color: white; color: #2d2d2d; font-family: &quot;Open Sans&quot;; font-size: 16px; line-height: 31px; margin-bottom: 20px;\">Misalnya, kita ingin mencari apakah di sebuah tabel&nbsp;<span style=\"font-weight: 700;\">ada nama orang<\/span>&nbsp;tertentu, kamu bisa menggunakan fungsi yang satu ini.<\/div>\n<ul style=\"background-color: white; color: #2d2d2d; font-family: &quot;Open Sans&quot;; font-size: 16px; list-style: none; padding-left: 0px;\">\n<li style=\"line-height: 30px;\">\n<div style=\"padding-left: 40px; position: relative;\">\n<div style=\"line-height: 31px; margin-bottom: 20px;\">Rumus Match<code style=\"background-color: #fff7f7; border-radius: 15px; color: #654445; display: block; font-family: &quot;Open Sans&quot;; font-size: 15px; margin: 30px 15px; padding: 10px 25px; position: relative; text-align: center;\">match(lookup_value,lookup_array,[match_type])<\/code><\/div>\n<\/div>\n<\/li>\n<li style=\"line-height: 30px;\">\n<div style=\"padding-left: 40px; position: relative;\">\n<div style=\"line-height: 31px; margin-bottom: 20px;\">Contoh Match<code style=\"background-color: #fff7f7; border-radius: 15px; color: #654445; display: block; font-family: &quot;Open Sans&quot;; font-size: 15px; margin: 30px 15px; padding: 10px 25px; position: relative; text-align: center;\">=match(\"Jojon\",A1:A20,0)<\/code><\/div>\n<\/div>\n<\/li>\n<\/ul>\n<h3 style=\"background-color: white; color: #2d2d2d; font-family: &quot;Open Sans&quot;; font-size: 19px; line-height: 30px; margin-bottom: 18px;\"><a href=\"http:\/\/www.dewagongball.com\/link.php?member=nextiruz\" target=\"_blank\" rel=\"noopener noreferrer\">VLookUp<\/a><\/h3>\n<div style=\"background-color: white; color: #2d2d2d; font-family: &quot;Open Sans&quot;; font-size: 16px; line-height: 31px; margin-bottom: 20px;\">Fungsi&nbsp;<span style=\"font-weight: 700;\">rumus Excel VLookUp<\/span>&nbsp;adalah mencari suatu&nbsp;<em>item<\/em>&nbsp;di kolom, di tabel, dan mengambil nilai yang ada di kolom lain pada tabel tersebut.<\/div>\n<div style=\"background-color: white; color: #2d2d2d; font-family: &quot;Open Sans&quot;; font-size: 16px; line-height: 31px; margin-bottom: 20px;\">Contohnya, kita ingin&nbsp;<span style=\"font-weight: 700;\">mencari tahu kapan<\/span>&nbsp;ulang tahun atau jumlah anak karyawan tertentu. Data yang ingin ditampilkan harus diambil dari sebuah tabel yang disusun dalam format vertikal.<\/div>\n<ul style=\"background-color: white; color: #2d2d2d; font-family: &quot;Open Sans&quot;; font-size: 16px; list-style: none; padding-left: 0px;\">\n<li style=\"line-height: 30px;\">\n<div style=\"padding-left: 40px; position: relative;\">\n<div style=\"line-height: 31px; margin-bottom: 20px;\">Rumus VLookUp<code style=\"background-color: #fff7f7; border-radius: 15px; color: #654445; display: block; font-family: &quot;Open Sans&quot;; font-size: 15px; margin: 30px 15px; padding: 10px 25px; position: relative; text-align: center;\">vlokup(lookup_value,lookup_array,[match_type])<\/code><\/div>\n<\/div>\n<\/li>\n<li style=\"line-height: 30px;\">\n<div style=\"padding-left: 40px; position: relative;\">\n<div style=\"line-height: 31px; margin-bottom: 20px;\">Contoh VLookUp<code style=\"background-color: #fff7f7; border-radius: 15px; color: #654445; display: block; font-family: &quot;Open Sans&quot;; font-size: 15px; margin: 30px 15px; padding: 10px 25px; position: relative; text-align: center;\">=vlookup(\"Jojon\",A1:C11,3,0)<\/code><\/div>\n<\/div>\n<\/li>\n<\/ul>\n<h3 style=\"background-color: white; color: #2d2d2d; font-family: &quot;Open Sans&quot;; font-size: 19px; line-height: 30px; margin-bottom: 18px;\"><a href=\"http:\/\/www.dewagongball.com\/link.php?member=nextiruz\" target=\"_blank\" rel=\"noopener noreferrer\">HLookUp<\/a><\/h3>\n<div style=\"background-color: white; color: #2d2d2d; font-family: &quot;Open Sans&quot;; font-size: 16px; line-height: 31px; margin-bottom: 20px;\">Sama dengan&nbsp;<span style=\"font-weight: 700;\">VlookUp<\/span>, hanya saja pada rumus&nbsp;<span style=\"font-weight: 700;\">HlookUP<\/span>&nbsp;data yang diambil harus secara horizontal.<\/div>\n<ul style=\"background-color: white; color: #2d2d2d; font-family: &quot;Open Sans&quot;; font-size: 16px; list-style: none; padding-left: 0px;\">\n<li style=\"line-height: 30px;\">\n<div style=\"padding-left: 40px; position: relative;\">\n<div style=\"line-height: 31px; margin-bottom: 20px;\">Rumus HLookUp<code style=\"background-color: #fff7f7; border-radius: 15px; color: #654445; display: block; font-family: &quot;Open Sans&quot;; font-size: 15px; margin: 30px 15px; padding: 10px 25px; position: relative; text-align: center;\">=HLOOKUP(lookup_value,lookup_array,[match_type])<\/code><\/div>\n<\/div>\n<\/li>\n<li style=\"line-height: 30px;\">\n<div style=\"padding-left: 40px; position: relative;\">\n<div style=\"line-height: 31px; margin-bottom: 20px;\">Contoh HLookUp<code style=\"background-color: #fff7f7; border-radius: 15px; color: #654445; display: block; font-family: &quot;Open Sans&quot;; font-size: 15px; margin: 30px 15px; padding: 10px 25px; position: relative; text-align: center;\">=HLOOKUP(\"Jojon\",A1:C11,3,0)<\/code><\/div>\n<\/div>\n<\/li>\n<\/ul>\n<h3 style=\"background-color: white; color: #2d2d2d; font-family: &quot;Open Sans&quot;; font-size: 19px; line-height: 30px; margin-bottom: 18px;\"><a href=\"http:\/\/www.dewagongball.com\/link.php?member=nextiruz\" target=\"_blank\" rel=\"noopener noreferrer\">SumIf<\/a><\/h3>\n<div style=\"background-color: white; color: #2d2d2d; font-family: &quot;Open Sans&quot;; font-size: 16px; line-height: 31px; margin-bottom: 20px;\">Fungsi&nbsp;<span style=\"font-weight: 700;\">rumus Excel SumIfs<\/span>&nbsp;adalah mencari suatu&nbsp;<em>item<\/em>&nbsp;di kolom, di tabel, dan mengambil nilai yang ada di kolom lain pada tabel tersebut.<\/div>\n<div style=\"background-color: white; color: #2d2d2d; font-family: &quot;Open Sans&quot;; font-size: 16px; line-height: 31px; margin-bottom: 20px;\">Misalnya kita ingin&nbsp;<span style=\"font-weight: 700;\">mencari tahu kapan<\/span>&nbsp;ulang tahun atau jumlah anak karyawan tertentu.<\/div>\n<ul style=\"background-color: white; color: #2d2d2d; font-family: &quot;Open Sans&quot;; font-size: 16px; list-style: none; padding-left: 0px;\">\n<li style=\"line-height: 30px;\">\n<div style=\"padding-left: 40px; position: relative;\">\n<div style=\"line-height: 31px; margin-bottom: 20px;\">Rumus SumIfs<code style=\"background-color: #fff7f7; border-radius: 15px; color: #654445; display: block; font-family: &quot;Open Sans&quot;; font-size: 15px; margin: 30px 15px; padding: 10px 25px; position: relative; text-align: center;\">sumifs(sum_range,criteria_range1,criteria1,criteria_range2,criteria2,...)<\/code><\/div>\n<\/div>\n<\/li>\n<li style=\"line-height: 30px;\">\n<div style=\"padding-left: 40px; position: relative;\">\n<div style=\"line-height: 31px; margin-bottom: 20px;\">Contoh SumIfs<code style=\"background-color: #fff7f7; border-radius: 15px; color: #654445; display: block; font-family: &quot;Open Sans&quot;; font-size: 15px; margin: 30px 15px; padding: 10px 25px; position: relative; text-align: center;\">=sumifs(d1:d10,a1:a10,'Jojon\",E1:E10,\"Februari\")<\/code><\/div>\n<\/div>\n<\/li>\n<\/ul>\n<h3 style=\"background-color: white; color: #2d2d2d; font-family: &quot;Open Sans&quot;; font-size: 19px; line-height: 30px; margin-bottom: 18px;\"><a href=\"http:\/\/www.dewagongball.com\/link.php?member=nextiruz\" target=\"_blank\" rel=\"noopener noreferrer\">Round<\/a><\/h3>\n<div style=\"background-color: white; color: #2d2d2d; font-family: &quot;Open Sans&quot;; font-size: 16px; line-height: 31px; margin-bottom: 20px;\">Fungsi&nbsp;<span style=\"font-weight: 700;\">rumus Excel Round<\/span>&nbsp;adalah membulatkan angka ke angka desimal sesuai yang kamu inginkan.<\/div>\n<ul style=\"background-color: white; color: #2d2d2d; font-family: &quot;Open Sans&quot;; font-size: 16px; list-style: none; padding-left: 0px;\">\n<li style=\"line-height: 30px;\">\n<div style=\"padding-left: 40px; position: relative;\">\n<div style=\"line-height: 31px; margin-bottom: 20px;\">Rumus Round<code style=\"background-color: #fff7f7; border-radius: 15px; color: #654445; display: block; font-family: &quot;Open Sans&quot;; font-size: 15px; margin: 30px 15px; padding: 10px 25px; position: relative; text-align: center;\">round(number,num_digit)<\/code><\/div>\n<\/div>\n<\/li>\n<li style=\"line-height: 30px;\">\n<div style=\"padding-left: 40px; position: relative;\">\n<div style=\"line-height: 31px; margin-bottom: 20px;\">Contoh Round<code style=\"background-color: #fff7f7; border-radius: 15px; color: #654445; display: block; font-family: &quot;Open Sans&quot;; font-size: 15px; margin: 30px 15px; padding: 10px 25px; position: relative; text-align: center;\">=round(12:3456789,2)<\/code><\/div>\n<\/div>\n<\/li>\n<\/ul>\n<h3 style=\"background-color: white; color: #2d2d2d; font-family: &quot;Open Sans&quot;; font-size: 19px; line-height: 30px; margin-bottom: 18px;\"><a href=\"http:\/\/www.dewagongball.com\/link.php?member=nextiruz\" target=\"_blank\" rel=\"noopener noreferrer\">Trim<\/a><\/h3>\n<div style=\"background-color: white; color: #2d2d2d; font-family: &quot;Open Sans&quot;; font-size: 16px; line-height: 31px; margin-bottom: 20px;\">Fungsi&nbsp;<span style=\"font-weight: 700;\">rumus Excel Trim<\/span>&nbsp;adalah membenarkan teks dengan cara menghapus spasi yang terlalu banyak. Rumus ini cocok untuk merapikan sebuah tabel data.<\/div>\n<ul style=\"background-color: white; color: #2d2d2d; font-family: &quot;Open Sans&quot;; font-size: 16px; list-style: none; padding-left: 0px;\">\n<li style=\"line-height: 30px;\">\n<div style=\"padding-left: 40px; position: relative;\">\n<div style=\"line-height: 31px; margin-bottom: 20px;\">Rumus Trim<code style=\"background-color: #fff7f7; border-radius: 15px; color: #654445; display: block; font-family: &quot;Open Sans&quot;; font-size: 15px; margin: 30px 15px; padding: 10px 25px; position: relative; text-align: center;\">trim(text)<\/code><\/div>\n<\/div>\n<\/li>\n<li style=\"line-height: 30px;\">\n<div style=\"padding-left: 40px; position: relative;\">\n<div style=\"line-height: 31px; margin-bottom: 20px;\">Contoh Trim<code style=\"background-color: #fff7f7; border-radius: 15px; color: #654445; display: block; font-family: &quot;Open Sans&quot;; font-size: 15px; margin: 30px 15px; padding: 10px 25px; position: relative; text-align: center;\">=trim(\"Ini adalah rumus excel yang mudah dipelajari \")<\/code><\/div>\n<\/div>\n<\/li>\n<\/ul>\n<h3 style=\"background-color: white; color: #2d2d2d; font-family: &quot;Open Sans&quot;; font-size: 19px; line-height: 30px; margin-bottom: 18px;\"><a href=\"http:\/\/www.dewagongball.com\/link.php?member=nextiruz\" target=\"_blank\" rel=\"noopener noreferrer\">Clean<\/a><\/h3>\n<div style=\"background-color: white; color: #2d2d2d; font-family: &quot;Open Sans&quot;; font-size: 16px; line-height: 31px; margin-bottom: 20px;\">Hampir mirip dengan&nbsp;<span style=\"font-weight: 700;\">Trim<\/span>, hanya saja rumus&nbsp;<span style=\"font-weight: 700;\">Clean<\/span>&nbsp;digunakan untuk menghilangkan karakter yang tidak bisa dicetak (<em>non printable character<\/em>).<\/div>\n<ul style=\"background-color: white; color: #2d2d2d; font-family: &quot;Open Sans&quot;; font-size: 16px; list-style: none; padding-left: 0px;\">\n<li style=\"line-height: 30px;\">\n<div style=\"padding-left: 40px; position: relative;\">\n<div style=\"line-height: 31px; margin-bottom: 20px;\">Rumus Clean<code style=\"background-color: #fff7f7; border-radius: 15px; color: #654445; display: block; font-family: &quot;Open Sans&quot;; font-size: 15px; margin: 30px 15px; padding: 10px 25px; position: relative; text-align: center;\">=CLEAN(&lt;em&gt;cell&lt;\/em&gt; yang ingin dibersihkan))<\/code><\/div>\n<\/div>\n<\/li>\n<li style=\"line-height: 30px;\">\n<div style=\"padding-left: 40px; position: relative;\">\n<div style=\"line-height: 31px; margin-bottom: 20px;\">Contoh CLEAN<code style=\"background-color: #fff7f7; border-radius: 15px; color: #654445; display: block; font-family: &quot;Open Sans&quot;; font-size: 15px; margin: 30px 15px; padding: 10px 25px; position: relative; text-align: center;\">=CLEAN(B2)<\/code><\/div>\n<\/div>\n<\/li>\n<\/ul>\n<h3 style=\"background-color: white; color: #2d2d2d; font-family: &quot;Open Sans&quot;; font-size: 19px; line-height: 30px; margin-bottom: 18px;\"><a href=\"http:\/\/www.dewagongball.com\/link.php?member=nextiruz\" target=\"_blank\" rel=\"noopener noreferrer\">Proper<\/a><\/h3>\n<div style=\"background-color: white; color: #2d2d2d; font-family: &quot;Open Sans&quot;; font-size: 16px; line-height: 31px; margin-bottom: 20px;\">Fungsi rumus Excel Proper adalah mengubah teks ke bentuk&nbsp;<em>proper case<\/em>&nbsp;(huruf pertama jadi huruf kapital).<\/div>\n<ul style=\"background-color: white; color: #2d2d2d; font-family: &quot;Open Sans&quot;; font-size: 16px; list-style: none; padding-left: 0px;\">\n<li style=\"line-height: 30px;\">\n<div style=\"padding-left: 40px; position: relative;\">\n<div style=\"line-height: 31px; margin-bottom: 20px;\">Rumus Proper<code style=\"background-color: #fff7f7; border-radius: 15px; color: #654445; display: block; font-family: &quot;Open Sans&quot;; font-size: 15px; margin: 30px 15px; padding: 10px 25px; position: relative; text-align: center;\">Proper(text)<\/code><\/div>\n<\/div>\n<\/li>\n<li style=\"line-height: 30px;\">\n<div style=\"padding-left: 40px; position: relative;\">\n<div style=\"line-height: 31px; margin-bottom: 20px;\">Contoh Proper<code style=\"background-color: #fff7f7; border-radius: 15px; color: #654445; display: block; font-family: &quot;Open Sans&quot;; font-size: 15px; margin: 30px 15px; padding: 10px 25px; position: relative; text-align: center;\">=proper(\"ini aDalah rumUS eXcel yang mudah diPelajari\") &amp;gt; Ini Adalah Rumus Excel Yang Mudah Dipelajari<\/code><\/div>\n<\/div>\n<\/li>\n<\/ul>\n<h3 style=\"background-color: white; color: #2d2d2d; font-family: &quot;Open Sans&quot;; font-size: 19px; line-height: 30px; margin-bottom: 18px;\"><a href=\"http:\/\/www.dewagongball.com\/link.php?member=nextiruz\" target=\"_blank\" rel=\"noopener noreferrer\">Upper<\/a><\/h3>\n<div style=\"background-color: white; color: #2d2d2d; font-family: &quot;Open Sans&quot;; font-size: 16px; line-height: 31px; margin-bottom: 20px;\">Fungsi&nbsp;<span style=\"font-weight: 700;\">rumus Excel Upper<\/span>&nbsp;adalah mengubah teks ke bentuk&nbsp;<em>upper case<\/em>&nbsp;alias huruf kapital semua.<\/div>\n<ul style=\"background-color: white; color: #2d2d2d; font-family: &quot;Open Sans&quot;; font-size: 16px; list-style: none; padding-left: 0px;\">\n<li style=\"line-height: 30px;\">\n<div style=\"padding-left: 40px; position: relative;\">\n<div style=\"line-height: 31px; margin-bottom: 20px;\">Rumus Upper<code style=\"background-color: #fff7f7; border-radius: 15px; color: #654445; display: block; font-family: &quot;Open Sans&quot;; font-size: 15px; margin: 30px 15px; padding: 10px 25px; position: relative; text-align: center;\">Upper(text)<\/code><\/div>\n<\/div>\n<\/li>\n<li style=\"line-height: 30px;\">\n<div style=\"padding-left: 40px; position: relative;\">\n<div style=\"line-height: 31px; margin-bottom: 20px;\">Contoh Upper<code style=\"background-color: #fff7f7; border-radius: 15px; color: #654445; display: block; font-family: &quot;Open Sans&quot;; font-size: 15px; margin: 30px 15px; padding: 10px 25px; position: relative; text-align: center;\">=upper(\"ini adalah rumus excel sederhana di dunia kerja\") &amp;gt; INI ADALAH RUMUS EXCEL SEDERHANA DI DUNIA KERJA<\/code><\/div>\n<\/div>\n<\/li>\n<\/ul>\n<h3 style=\"background-color: white; color: #2d2d2d; font-family: &quot;Open Sans&quot;; font-size: 19px; line-height: 30px; margin-bottom: 18px;\"><a href=\"http:\/\/www.dewagongball.com\/link.php?member=nextiruz\" target=\"_blank\" rel=\"noopener noreferrer\">Lower<\/a><\/h3>\n<div style=\"background-color: white; color: #2d2d2d; font-family: &quot;Open Sans&quot;; font-size: 16px; line-height: 31px; margin-bottom: 20px;\">Fungsi&nbsp;<span style=\"font-weight: 700;\">rumus Excel Lower<\/span>&nbsp;adalah untuk mengubah teks ke bentuk&nbsp;<em>lower case<\/em>&nbsp;(huruf kecil semua).<\/div>\n<ul style=\"background-color: white; color: #2d2d2d; font-family: &quot;Open Sans&quot;; font-size: 16px; list-style: none; padding-left: 0px;\">\n<li style=\"line-height: 30px;\">\n<div style=\"padding-left: 40px; position: relative;\">\n<div style=\"line-height: 31px; margin-bottom: 20px;\">Rumus Lower<code style=\"background-color: #fff7f7; border-radius: 15px; color: #654445; display: block; font-family: &quot;Open Sans&quot;; font-size: 15px; margin: 30px 15px; padding: 10px 25px; position: relative; text-align: center;\">lower(text)<\/code><\/div>\n<\/div>\n<\/li>\n<li style=\"line-height: 30px;\">\n<div style=\"padding-left: 40px; position: relative;\">\n<div style=\"line-height: 31px; margin-bottom: 20px;\">Contoh Lower<code style=\"background-color: #fff7f7; border-radius: 15px; color: #654445; display: block; font-family: &quot;Open Sans&quot;; font-size: 15px; margin: 30px 15px; padding: 10px 25px; position: relative; text-align: center;\">=lower(\"Jangan Lupa download aplikasi JalanTikus\") &amp;gt; jangan lupa download aplikasi jalantikus<\/code><\/div>\n<\/div>\n<\/li>\n<\/ul>\n<h3 style=\"background-color: white; color: #2d2d2d; font-family: &quot;Open Sans&quot;; font-size: 19px; line-height: 30px; margin-bottom: 18px;\"><a href=\"http:\/\/www.dewagongball.com\/link.php?member=nextiruz\" target=\"_blank\" rel=\"noopener noreferrer\">Average<\/a><\/h3>\n<div style=\"background-color: white; color: #2d2d2d; font-family: &quot;Open Sans&quot;; font-size: 16px; line-height: 31px; margin-bottom: 20px;\">Fungsi&nbsp;<span style=\"font-weight: 700;\">rumus Excel Average<\/span>&nbsp;bisa kamu gunakan untuk mencari nilai rata-rata dari sebuah data.<\/div>\n<ul style=\"background-color: white; color: #2d2d2d; font-family: &quot;Open Sans&quot;; font-size: 16px; list-style: none; padding-left: 0px;\">\n<li style=\"line-height: 30px;\">\n<div style=\"padding-left: 40px; position: relative;\">\n<div style=\"line-height: 31px; margin-bottom: 20px;\">Rumus Average<code style=\"background-color: #fff7f7; border-radius: 15px; color: #654445; display: block; font-family: &quot;Open Sans&quot;; font-size: 15px; margin: 30px 15px; padding: 10px 25px; position: relative; text-align: center;\">=AVERAGE(number1:number2)<\/code><\/div>\n<\/div>\n<\/li>\n<li style=\"line-height: 30px;\">\n<div style=\"padding-left: 40px; position: relative;\">\n<div style=\"line-height: 31px; margin-bottom: 20px;\">Contoh Average<code style=\"background-color: #fff7f7; border-radius: 15px; color: #654445; display: block; font-family: &quot;Open Sans&quot;; font-size: 15px; margin: 30px 15px; padding: 10px 25px; position: relative; text-align: center;\">=AVERAGE(L3:L6)<\/code><\/div>\n<\/div>\n<\/li>\n<\/ul>\n<h3 style=\"background-color: white; color: #2d2d2d; font-family: &quot;Open Sans&quot;; font-size: 19px; line-height: 30px; margin-bottom: 18px;\"><a href=\"http:\/\/www.dewagongball.com\/link.php?member=nextiruz\" target=\"_blank\" rel=\"noopener noreferrer\">Max<\/a><\/h3>\n<div style=\"background-color: white; color: #2d2d2d; font-family: &quot;Open Sans&quot;; font-size: 16px; line-height: 31px; margin-bottom: 20px;\">Kalau kamu ingin mencari nilai tertinggi pada sebaris deretan angka, kamu bisa menggunakan rumus&nbsp;<span style=\"font-weight: 700;\">Max<\/span>.<\/div>\n<ul style=\"background-color: white; color: #2d2d2d; font-family: &quot;Open Sans&quot;; font-size: 16px; list-style: none; padding-left: 0px;\">\n<li style=\"line-height: 30px;\">\n<div style=\"padding-left: 40px; position: relative;\">\n<div style=\"line-height: 31px; margin-bottom: 20px;\">Rumus Max<code style=\"background-color: #fff7f7; border-radius: 15px; color: #654445; display: block; font-family: &quot;Open Sans&quot;; font-size: 15px; margin: 30px 15px; padding: 10px 25px; position: relative; text-align: center;\">=MAX(number1:number2)<\/code><\/div>\n<\/div>\n<\/li>\n<li style=\"line-height: 30px;\">\n<div style=\"padding-left: 40px; position: relative;\">\n<div style=\"line-height: 31px; margin-bottom: 20px;\">Contoh Max<code style=\"background-color: #fff7f7; border-radius: 15px; color: #654445; display: block; font-family: &quot;Open Sans&quot;; font-size: 15px; margin: 30px 15px; padding: 10px 25px; position: relative; text-align: center;\">=MAX(L3:L6)<\/code><\/div>\n<\/div>\n<\/li>\n<\/ul>\n<h3 style=\"background-color: white; color: #2d2d2d; font-family: &quot;Open Sans&quot;; font-size: 19px; line-height: 30px; margin-bottom: 18px;\"><a href=\"http:\/\/www.dewagongball.com\/link.php?member=nextiruz\" target=\"_blank\" rel=\"noopener noreferrer\">Min<\/a><\/h3>\n<div style=\"background-color: white; color: #2d2d2d; font-family: &quot;Open Sans&quot;; font-size: 16px; line-height: 31px; margin-bottom: 20px;\">Sebaliknya, kalau kamu ingin mencari nilai terendah pada sebaris deretan angka, kamu bisa menggunakan rumus&nbsp;<span style=\"font-weight: 700;\">Min<\/span>.<\/div>\n<ul style=\"background-color: white; color: #2d2d2d; font-family: &quot;Open Sans&quot;; font-size: 16px; list-style: none; padding-left: 0px;\">\n<li style=\"line-height: 30px;\">\n<div style=\"padding-left: 40px; position: relative;\">\n<div style=\"line-height: 31px; margin-bottom: 20px;\">Rumus Min<code style=\"background-color: #fff7f7; border-radius: 15px; color: #654445; display: block; font-family: &quot;Open Sans&quot;; font-size: 15px; margin: 30px 15px; padding: 10px 25px; position: relative; text-align: center;\">=MIN(number1:number2)<\/code><\/div>\n<\/div>\n<\/li>\n<li style=\"line-height: 30px;\">\n<div style=\"padding-left: 40px; position: relative;\">\n<div style=\"line-height: 31px; margin-bottom: 20px;\">Contoh Min<code style=\"background-color: #fff7f7; border-radius: 15px; color: #654445; display: block; font-family: &quot;Open Sans&quot;; font-size: 15px; margin: 30px 15px; padding: 10px 25px; position: relative; text-align: center;\">=MIN(L3:L6)<\/code><\/div>\n<\/div>\n<\/li>\n<\/ul>\n<h3 style=\"background-color: white; color: #2d2d2d; font-family: &quot;Open Sans&quot;; font-size: 19px; line-height: 30px; margin-bottom: 18px;\"><a href=\"http:\/\/www.dewagongball.com\/link.php?member=nextiruz\" target=\"_blank\" rel=\"noopener noreferrer\">Concatenate<\/a><\/h3>\n<div style=\"background-color: white; color: #2d2d2d; font-family: &quot;Open Sans&quot;; font-size: 16px; line-height: 31px; margin-bottom: 20px;\">Ketika kamu ingin menggabungkan beberapa nilai pada&nbsp;<em>cell<\/em>&nbsp;dengan beberapa modifikasi kata, kamu bisa menggunakan rumus&nbsp;<span style=\"font-weight: 700;\">Concatenate<\/span>.<\/div>\n<ul style=\"background-color: white; color: #2d2d2d; font-family: &quot;Open Sans&quot;; font-size: 16px; list-style: none; padding-left: 0px;\">\n<li style=\"line-height: 30px;\">\n<div style=\"padding-left: 40px; position: relative;\">\n<div style=\"line-height: 31px; margin-bottom: 20px;\">Rumus Concatenate<code style=\"background-color: #fff7f7; border-radius: 15px; color: #654445; display: block; font-family: &quot;Open Sans&quot;; font-size: 15px; margin: 30px 15px; padding: 10px 25px; position: relative; text-align: center;\">=CONCATENATE(text1;text2;...)<\/code><\/div>\n<\/div>\n<\/li>\n<li style=\"line-height: 30px;\">\n<div style=\"padding-left: 40px; position: relative;\">\n<div style=\"line-height: 31px; margin-bottom: 20px;\">Contoh Concatenate<code style=\"background-color: #fff7f7; border-radius: 15px; color: #654445; display: block; font-family: &quot;Open Sans&quot;; font-size: 15px; margin: 30px 15px; padding: 10px 25px; position: relative; text-align: center;\">= CONCATENATE( Pembaca ;K6; Jumlahnya ;L6)<\/code><\/div>\n<\/div>\n<\/li>\n<\/ul>\n<h3 style=\"background-color: white; color: #2d2d2d; font-family: &quot;Open Sans&quot;; font-size: 19px; line-height: 30px; margin-bottom: 18px;\"><a href=\"http:\/\/www.dewagongball.com\/link.php?member=nextiruz\" target=\"_blank\" rel=\"noopener noreferrer\">Left<\/a><\/h3>\n<div style=\"background-color: white; color: #2d2d2d; font-family: &quot;Open Sans&quot;; font-size: 16px; line-height: 31px; margin-bottom: 20px;\">Kalau kamu butuh mengambil beberapa karakter dalam sebuah kata ataupun angka, gunakan rumus&nbsp;<span style=\"font-weight: 700;\">Left<\/span>. Misalnya pada kata <a href=\"http:\/\/www.dewagongball.com\/link.php?member=nextiruz\" target=\"_blank\" rel=\"noopener noreferrer\">RUMUSJITU <\/a>. kamu bisa mengambil kata RUMUS -nya saja.<\/div>\n<ul style=\"background-color: white; color: #2d2d2d; font-family: &quot;Open Sans&quot;; font-size: 16px; list-style: none; padding-left: 0px;\">\n<li style=\"line-height: 30px;\">\n<div style=\"padding-left: 40px; position: relative;\">\n<div style=\"line-height: 31px; margin-bottom: 20px;\">Rumus Left<code style=\"background-color: #fff7f7; border-radius: 15px; color: #654445; display: block; font-family: &quot;Open Sans&quot;; font-size: 15px; margin: 30px 15px; padding: 10px 25px; position: relative; text-align: center;\">=LEFT(cell yang mau diambil;jumlah karakter yang ingin ditampilkan)<\/code><\/div>\n<\/div>\n<\/li>\n<li style=\"line-height: 30px;\">\n<div style=\"padding-left: 40px; position: relative;\">\n<div style=\"line-height: 31px; margin-bottom: 20px;\">Contoh Left<code style=\"background-color: #fff7f7; border-radius: 15px; color: #654445; display: block; font-family: &quot;Open Sans&quot;; font-size: 15px; margin: 30px 15px; padding: 10px 25px; position: relative; text-align: center;\">=LEFT(B25;5)<\/code><\/div>\n<\/div>\n<\/li>\n<\/ul>\n<h3 style=\"background-color: white; color: #2d2d2d; font-family: &quot;Open Sans&quot;; font-size: 19px; line-height: 30px; margin-bottom: 18px;\"><a href=\"http:\/\/www.dewagongball.com\/link.php?member=nextiruz\" target=\"_blank\" rel=\"noopener noreferrer\">Right<\/a><\/h3>\n<div style=\"background-color: white; color: #2d2d2d; font-family: &quot;Open Sans&quot;; font-size: 16px; line-height: 31px; margin-bottom: 20px;\">Sama seperti rumus&nbsp;<span style=\"font-weight: 700;\">Left<\/span>, hanya saja rumus&nbsp;<span style=\"font-weight: 700;\">Right<\/span>&nbsp;mengambil karakter dari sebelah kanan.<\/div>\n<ul style=\"background-color: white; color: #2d2d2d; font-family: &quot;Open Sans&quot;; font-size: 16px; list-style: none; padding-left: 0px;\">\n<li style=\"line-height: 30px;\">\n<div style=\"padding-left: 40px; position: relative;\">\n<div style=\"line-height: 31px; margin-bottom: 20px;\">Rumus Right<code style=\"background-color: #fff7f7; border-radius: 15px; color: #654445; display: block; font-family: &quot;Open Sans&quot;; font-size: 15px; margin: 30px 15px; padding: 10px 25px; position: relative; text-align: center;\">=RIGHT(cell yang mau diambil;jumlah karakter yang ingin ditampilkan)<\/code><\/div>\n<\/div>\n<\/li>\n<li style=\"line-height: 30px;\">\n<div style=\"padding-left: 40px; position: relative;\">\n<div style=\"line-height: 31px; margin-bottom: 20px;\">Contoh Right<code style=\"background-color: #fff7f7; border-radius: 15px; color: #654445; display: block; font-family: &quot;Open Sans&quot;; font-size: 15px; margin: 30px 15px; padding: 10px 25px; position: relative; text-align: center;\">=RIGHT(B25;5)<\/code><\/div>\n<\/div>\n<\/li>\n<\/ul>\n<h3 style=\"background-color: white; color: #2d2d2d; font-family: &quot;Open Sans&quot;; font-size: 19px; line-height: 30px; margin-bottom: 18px;\"><a href=\"http:\/\/www.dewagongball.com\/link.php?member=nextiruz\" target=\"_blank\" rel=\"noopener noreferrer\">Mid<\/a><\/h3>\n<div style=\"background-color: white; color: #2d2d2d; font-family: &quot;Open Sans&quot;; font-size: 16px; line-height: 31px; margin-bottom: 20px;\">Sama seperti rumus&nbsp;<span style=\"font-weight: 700;\">Left<\/span>&nbsp;dan&nbsp;<span style=\"font-weight: 700;\">Right<\/span>, hanya saja rumus&nbsp;<span style=\"font-weight: 700;\">Mid<\/span>&nbsp;mengambil karakter dari tengah-tengah.<\/div>\n<ul style=\"background-color: white; color: #2d2d2d; font-family: &quot;Open Sans&quot;; font-size: 16px; list-style: none; padding-left: 0px;\">\n<li style=\"line-height: 30px;\">\n<div style=\"padding-left: 40px; position: relative;\">\n<div style=\"line-height: 31px; margin-bottom: 20px;\">Rumus Mid<code style=\"background-color: #fff7f7; border-radius: 15px; color: #654445; display: block; font-family: &quot;Open Sans&quot;; font-size: 15px; margin: 30px 15px; padding: 10px 25px; position: relative; text-align: center;\">=MID(cell yang mau diambil;jumlah karakter yang ingin ditampilkan)<\/code><\/div>\n<\/div>\n<\/li>\n<li style=\"line-height: 30px;\">\n<div style=\"padding-left: 40px; position: relative;\">\n<div style=\"line-height: 31px; margin-bottom: 20px;\">Contoh MID<code style=\"background-color: #fff7f7; border-radius: 15px; color: #654445; display: block; font-family: &quot;Open Sans&quot;; font-size: 15px; margin: 30px 15px; padding: 10px 25px; position: relative; text-align: center;\">=MID(B25;5)<\/code><\/div>\n<\/div>\n<\/li>\n<\/ul>\n<h3 style=\"background-color: white; color: #2d2d2d; font-family: &quot;Open Sans&quot;; font-size: 19px; line-height: 30px; margin-bottom: 18px;\"><a href=\"http:\/\/www.dewagongball.com\/link.php?member=nextiruz\" target=\"_blank\" rel=\"noopener noreferrer\">Rept<\/a><\/h3>\n<div style=\"background-color: white; color: #2d2d2d; font-family: &quot;Open Sans&quot;; font-size: 16px; line-height: 31px; margin-bottom: 20px;\">Jika kamu ingin menghitung berapa banyak suara ketika pemilihan ketua OSIS, kamu bisa menggunakan rumus&nbsp;<span style=\"font-weight: 700;\">Rept<\/span>. Misal, satu suara kamu lambangkan dengan&nbsp;<span style=\"font-weight: 700;\">Turus ( | )<\/span>, maka kamu bisa menghitung berapa banyak Turus yang ada pada tabel.<\/div>\n<ul style=\"background-color: white; color: #2d2d2d; font-family: &quot;Open Sans&quot;; font-size: 16px; list-style: none; padding-left: 0px;\">\n<li style=\"line-height: 30px;\">\n<div style=\"padding-left: 40px; position: relative;\">\n<div style=\"line-height: 31px; margin-bottom: 20px;\">Rumus Rept<code style=\"background-color: #fff7f7; border-radius: 15px; color: #654445; display: block; font-family: &quot;Open Sans&quot;; font-size: 15px; margin: 30px 15px; padding: 10px 25px; position: relative; text-align: center;\">=REPT( | ;berapa banyak pengulangan)<\/code><\/div>\n<\/div>\n<\/li>\n<li style=\"line-height: 30px;\">\n<div style=\"padding-left: 40px; position: relative;\">\n<div style=\"line-height: 31px; margin-bottom: 20px;\">Contoh Rept<code style=\"background-color: #fff7f7; border-radius: 15px; color: #654445; display: block; font-family: &quot;Open Sans&quot;; font-size: 15px; margin: 30px 15px; padding: 10px 25px; position: relative; text-align: center;\">=REPT( | ;(B25\/$B$30)*100)<\/code><\/div>\n<\/div>\n<\/li>\n<\/ul>\n<h3 style=\"background-color: white; color: #2d2d2d; font-family: &quot;Open Sans&quot;; font-size: 19px; line-height: 30px; margin-bottom: 18px;\"><a href=\"http:\/\/www.dewagongball.com\/link.php?member=nextiruz\" target=\"_blank\" rel=\"noopener noreferrer\">Date<\/a><\/h3>\n<div style=\"background-color: white; color: #2d2d2d; font-family: &quot;Open Sans&quot;; font-size: 16px; line-height: 31px; margin-bottom: 20px;\">Jika kamu ingin menambahkan tanggal pada file Excel-mu, kamu bisa menggunakan rumus&nbsp;<span style=\"font-weight: 700;\">Date<\/span>.<\/div>\n<ul style=\"background-color: white; color: #2d2d2d; font-family: &quot;Open Sans&quot;; font-size: 16px; list-style: none; padding-left: 0px;\">\n<li style=\"line-height: 30px;\">\n<div style=\"padding-left: 40px; position: relative;\">\n<div style=\"line-height: 31px; margin-bottom: 20px;\">Rumus Date<code style=\"background-color: #fff7f7; border-radius: 15px; color: #654445; display: block; font-family: &quot;Open Sans&quot;; font-size: 15px; margin: 30px 15px; padding: 10px 25px; position: relative; text-align: center;\">=DATE(year;month;day)<\/code><\/div>\n<\/div>\n<\/li>\n<li style=\"line-height: 30px;\">\n<div style=\"padding-left: 40px; position: relative;\">\n<div style=\"line-height: 31px; margin-bottom: 20px;\">Contoh Date<code style=\"background-color: #fff7f7; border-radius: 15px; color: #654445; display: block; font-family: &quot;Open Sans&quot;; font-size: 15px; margin: 30px 15px; padding: 10px 25px; position: relative; text-align: center;\">=DATE(2019;2;1)<\/code><\/div>\n<\/div>\n<\/li>\n<\/ul>\n<h3 style=\"background-color: white; color: #2d2d2d; font-family: &quot;Open Sans&quot;; font-size: 19px; line-height: 30px; margin-bottom: 18px;\"><a href=\"http:\/\/www.dewagongball.com\/link.php?member=nextiruz\" target=\"_blank\" rel=\"noopener noreferrer\">Year<\/a><\/h3>\n<div style=\"background-color: white; color: #2d2d2d; font-family: &quot;Open Sans&quot;; font-size: 16px; line-height: 31px; margin-bottom: 20px;\">Rumus&nbsp;<span style=\"font-weight: 700;\">Year<\/span>&nbsp;digunakan apabila kamu hendak mengambil data tahun pada sebuah&nbsp;<em>cell<\/em>&nbsp;berformat tanggal.<\/div>\n<ul style=\"background-color: white; color: #2d2d2d; font-family: &quot;Open Sans&quot;; font-size: 16px; list-style: none; padding-left: 0px;\">\n<li style=\"line-height: 30px;\">\n<div style=\"padding-left: 40px; position: relative;\">\n<div style=\"line-height: 31px; margin-bottom: 20px;\">Rumus Year<code style=\"background-color: #fff7f7; border-radius: 15px; color: #654445; display: block; font-family: &quot;Open Sans&quot;; font-size: 15px; margin: 30px 15px; padding: 10px 25px; position: relative; text-align: center;\">=YEAR(&lt;em&gt;cell&lt;\/em&gt; yang ingin diambil datanya)<\/code><\/div>\n<\/div>\n<\/li>\n<li style=\"line-height: 30px;\">\n<div style=\"padding-left: 40px; position: relative;\">\n<div style=\"line-height: 31px; margin-bottom: 20px;\">Contoh Year<code style=\"background-color: #fff7f7; border-radius: 15px; color: #654445; display: block; font-family: &quot;Open Sans&quot;; font-size: 15px; margin: 30px 15px; padding: 10px 25px; position: relative; text-align: center;\">=YEAR(B3)<\/code><\/div>\n<\/div>\n<\/li>\n<\/ul>\n<h3 style=\"background-color: white; color: #2d2d2d; font-family: &quot;Open Sans&quot;; font-size: 19px; line-height: 30px; margin-bottom: 18px;\"><a href=\"http:\/\/www.dewagongball.com\/link.php?member=nextiruz\" target=\"_blank\" rel=\"noopener noreferrer\">Month<\/a><\/h3>\n<div style=\"background-color: white; color: #2d2d2d; font-family: &quot;Open Sans&quot;; font-size: 16px; line-height: 31px; margin-bottom: 20px;\">Rumus&nbsp;<span style=\"font-weight: 700;\">Month<\/span>&nbsp;digunakan apabila kamu hendak mengambil data bulan pada sebuah&nbsp;<em>cell<\/em>&nbsp;berformat tanggal.<\/div>\n<ul style=\"background-color: white; color: #2d2d2d; font-family: &quot;Open Sans&quot;; font-size: 16px; list-style: none; padding-left: 0px;\">\n<li style=\"line-height: 30px;\">\n<div style=\"padding-left: 40px; position: relative;\">\n<div style=\"line-height: 31px; margin-bottom: 20px;\">Rumus Month<code style=\"background-color: #fff7f7; border-radius: 15px; color: #654445; display: block; font-family: &quot;Open Sans&quot;; font-size: 15px; margin: 30px 15px; padding: 10px 25px; position: relative; text-align: center;\">=MONTH(&lt;em&gt;cell&lt;\/em&gt; yang ingin diambil datanya)<\/code><\/div>\n<\/div>\n<\/li>\n<li style=\"line-height: 30px;\">\n<div style=\"padding-left: 40px; position: relative;\">\n<div style=\"line-height: 31px; margin-bottom: 20px;\">Contoh Month<code style=\"background-color: #fff7f7; border-radius: 15px; color: #654445; display: block; font-family: &quot;Open Sans&quot;; font-size: 15px; margin: 30px 15px; padding: 10px 25px; position: relative; text-align: center;\">=MONTH(B3)<\/code><\/div>\n<\/div>\n<\/li>\n<\/ul>\n<h3 style=\"background-color: white; color: #2d2d2d; font-family: &quot;Open Sans&quot;; font-size: 19px; line-height: 30px; margin-bottom: 18px;\"><a href=\"http:\/\/www.dewagongball.com\/link.php?member=nextiruz\" target=\"_blank\" rel=\"noopener noreferrer\">Day<\/a><\/h3>\n<div style=\"background-color: white; color: #2d2d2d; font-family: &quot;Open Sans&quot;; font-size: 16px; line-height: 31px; margin-bottom: 20px;\">Rumus&nbsp;<span style=\"font-weight: 700;\">Day<\/span>&nbsp;digunakan apabila kamu hendak mengambil data hari pada sebuah&nbsp;<em>cell<\/em>&nbsp;berformat tanggal.<\/div>\n<ul style=\"background-color: white; color: #2d2d2d; font-family: &quot;Open Sans&quot;; font-size: 16px; list-style: none; padding-left: 0px;\">\n<li style=\"line-height: 30px;\">\n<div style=\"padding-left: 40px; position: relative;\">\n<div style=\"line-height: 31px; margin-bottom: 20px;\">Rumus Day<code style=\"background-color: #fff7f7; border-radius: 15px; color: #654445; display: block; font-family: &quot;Open Sans&quot;; font-size: 15px; margin: 30px 15px; padding: 10px 25px; position: relative; text-align: center;\">=DAY(&lt;em&gt;cell&lt;\/em&gt; yang ingin diambil datanya)<\/code><\/div>\n<\/div>\n<\/li>\n<li style=\"line-height: 30px;\">\n<div style=\"padding-left: 40px; position: relative;\">\n<div style=\"line-height: 31px; margin-bottom: 20px;\">Contoh DAY<code style=\"background-color: #fff7f7; border-radius: 15px; color: #654445; display: block; font-family: &quot;Open Sans&quot;; font-size: 15px; margin: 30px 15px; padding: 10px 25px; position: relative; text-align: center;\">=DAY(B3)<\/code><\/div>\n<\/div>\n<\/li>\n<\/ul>\n<h3 style=\"background-color: white; color: #2d2d2d; font-family: &quot;Open Sans&quot;; font-size: 19px; line-height: 30px; margin-bottom: 18px;\">Itulah beragam<span style=\"font-size: 16px; font-weight: 400;\">&nbsp;<\/span><span style=\"font-size: 16px;\">rumus Excel<\/span><span style=\"font-size: 16px; font-weight: 400;\">&nbsp;<\/span><span style=\"font-size: 16px; font-weight: 400;\">di dunia kerja yang paling sering digunakan yang bisa <a href=\"http:\/\/www.dewagongball.com\/link.php?member=nextiruz\" target=\"_blank\" rel=\"noopener noreferrer\">DewaTogel <\/a>berikan. Selamat Mencoba Guys..<\/span><\/h3>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>Bagi pelajar atau pekerja kantoran, pasti sudah tidak asing lagi dengan&nbsp;Microsoft Excel. Software&nbsp;pengolah angka terbaik buatan Microsoft ini terbukti mampu mempercepat penggunannya saat menghitung beragam angka. Nah, kunci sukses memakai&nbsp;Microsoft Excel&nbsp;adalah dengan memanfaatkan rumus-rumusnya untuk memudahkan perhitungan. Sayangnya, banyak orang nggak tahu apa saja&nbsp;rumus Excel&nbsp;yang bisa digunakan. Apakah kamu salah satunya? Jangan khawatir. DewaTogel punya <\/p>\n<div class=\"read-more-text\"><a href=\"http:\/\/www.paitodewatogel.net\/index.php\/2019\/02\/04\/28-rumus-excel-di-dunia-kerja-paling-penting-wajib-tahu\/\" class=\"read-more\">continue reading<\/a><\/div>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[526,525,529,530,521,522,531,532,528,527,520,523,524],"tags":[],"class_list":["post-666","post","type-post","status-publish","format-standard","hentry","category-cara","category-data","category-excel","category-lotus-1-2-3","category-macintosh","category-microsoft","category-multiplan","category-rumus","category-software","category-spreadsheet","category-tips","category-windows","category-workbook"],"_links":{"self":[{"href":"http:\/\/www.paitodewatogel.net\/index.php\/wp-json\/wp\/v2\/posts\/666","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.paitodewatogel.net\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.paitodewatogel.net\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.paitodewatogel.net\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.paitodewatogel.net\/index.php\/wp-json\/wp\/v2\/comments?post=666"}],"version-history":[{"count":0,"href":"http:\/\/www.paitodewatogel.net\/index.php\/wp-json\/wp\/v2\/posts\/666\/revisions"}],"wp:attachment":[{"href":"http:\/\/www.paitodewatogel.net\/index.php\/wp-json\/wp\/v2\/media?parent=666"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.paitodewatogel.net\/index.php\/wp-json\/wp\/v2\/categories?post=666"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.paitodewatogel.net\/index.php\/wp-json\/wp\/v2\/tags?post=666"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}