{"id":1490,"date":"2023-11-22T02:20:42","date_gmt":"2023-11-22T02:20:42","guid":{"rendered":"https:\/\/exceladvisor.org\/id\/unggul-terlebih-dahulu\/"},"modified":"2023-11-22T02:20:42","modified_gmt":"2023-11-22T02:20:42","slug":"unggul-terlebih-dahulu","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/id\/unggul-terlebih-dahulu\/","title":{"rendered":"Tutorial excel tingkat lanjut"},"content":{"rendered":"<div class=\"excel-before-content\" id=\"excel-4020047433\"><script type=\"text\/javascript\">\r\n\tatOptions = {\r\n\t\t'key' : 'c1158f160081d6540a8409e6925dab94',\r\n\t\t'format' : 'iframe',\r\n\t\t'height' : 250,\r\n\t\t'width' : 300,\r\n\t\t'params' : {}\r\n\t};\r\n<\/script>\r\n<script type=\"text\/javascript\" src=\"\/\/www.highperformanceformat.com\/c1158f160081d6540a8409e6925dab94\/invoke.js\"><\/script><\/div> <p>Tutorial Excel tingkat lanjut mencakup fitur-fitur Microsoft Excel yang lebih canggih. Tutorial ini dirancang untuk orang-orang yang sudah memiliki pemahaman dasar tentang Excel dan ingin memperdalam keterampilan mereka untuk tugas-tugas yang lebih kompleks dan analisis data.<\/p><p> Berikut adalah beberapa topik yang umum dibahas dalam tutorial Excel tingkat lanjut:<\/p><h2> Penggunaan lanjutan Microsoft Excel<\/h2><p> <strong>Rumus dan fungsi lanjutan:<\/strong><\/p><ul><li> Cakupan mendalam tentang fungsi kompleks seperti INDEX\/MATCH, SUMIFS, COUNTIFS, dan rumus array.<\/li><li> Gunakan fungsi logika seperti IFERROR, IF, AND OR untuk pengambilan keputusan tingkat lanjut.<\/li><\/ul><p> <strong>Analisis data dan tabel pivot:<\/strong><\/p><ul><li> Teknik tingkat lanjut untuk bekerja dengan tabel pivot dan diagram pivot.<\/li><li> Analisis data menggunakan fitur seperti pemotong, garis waktu, dan kolom kalkulasi.<\/li><\/ul><p> <strong>Power Query dan Power Pivot:<\/strong><\/p><ul><li> Pengenalan Power Query untuk membersihkan, mengubah, dan memuat data.<\/li><li> Menggunakan Power Pivot untuk pemodelan dan analisis data tingkat lanjut.<\/li><\/ul><p> <strong>Validasi data dan alat data tingkat lanjut:<\/strong><\/p><ul><li> Membuat daftar drop-down dinamis dan daftar drop-down dependen.<\/li><li> Teknik validasi data tingkat lanjut dan aturan validasi khusus.<\/li><\/ul><p> <strong>Pemetaan tingkat lanjut:<\/strong><\/p><ul><li> Membuat bagan kompleks seperti bagan kombo, bagan air terjun, dan bagan radar.<\/li><li> Menyesuaikan elemen bagan dan opsi pemformatan.<\/li><\/ul><p> <strong><a href=\"https:\/\/exceladvisor.org\/id\/vba\/\">Makro dan VBA<\/a> (Visual Basic untuk Aplikasi):<\/strong><\/p><ul><li> Pengantar otomatisasi menggunakan makro.<\/li><li> Menulis dan mengedit kode VBA untuk menyesuaikan fungsionalitas Excel.<\/li><\/ul><p> <strong>Fungsi data lanjutan:<\/strong><\/p><ul><li> Gunakan fungsi seperti LOOKUP, HLOOKUP, VLOOKUP untuk pemulihan data tingkat lanjut.<\/li><li> Gunakan fungsi database seperti DSUM, DAVERAGE, DCOUNT.<\/li><\/ul><p> <strong>Manajemen skenario dan analisis simulasi:<\/strong><\/p><ul><li> Lakukan analisis skenario tingkat lanjut dan buat ringkasan skenario.<\/li><li> Menggunakan Goal Seek dan Solver untuk masalah optimasi.<\/li><\/ul><p> <strong>Tabel dinamis:<\/strong><\/p><ul><li> Jelajahi fungsi array dinamis baru seperti SORT, FILTER, UNIQUE, dan SEQUENCE.<\/li><li> Manfaatkan rentang tumpahan untuk manipulasi data yang efisien.<\/li><\/ul><p> <strong>Fungsi keuangan dan statistik:<\/strong><\/p><ul><li> Penerapan fungsi keuangan untuk perhitungan terkait pinjaman, investasi dan anuitas.<\/li><li> Gunakan fungsi statistik untuk analisis data dan pengujian hipotesis.<\/li><\/ul><p> <strong>Kolaborasi dan berbagi:<\/strong><\/p><ul><li> Fitur berbagi dan kolaborasi tingkat lanjut, termasuk berbagi buku kerja, menggabungkan perubahan, dan meninjau komentar.<\/li><\/ul><p> <strong>Desain dan visualisasi dashboard:<\/strong><\/p><ul><li> Rancang dasbor interaktif menggunakan teknik visualisasi tingkat lanjut.<\/li><li> Integrasi kontrol formulir dan elemen interaktif.<\/li><\/ul><h2> Spreadsheet<\/h2><ul><li> <a style=\"outline: none;\" href=\"https:\/\/exceladvisor.org\/id\/mengkonsolidasikan\/\" data-wpil=\"url\">Gabungkan data dari beberapa lembar kerja menjadi satu lembar kerja di Excel<\/a><\/li><li> <a style=\"outline: none;\" href=\"https:\/\/exceladvisor.org\/id\/formulir-entri-data3\/\">Buat formulir entri data di Excel<\/a><\/li><\/ul><h2> Format<\/h2><ul><li> <a style=\"outline: none;\" href=\"https:\/\/exceladvisor.org\/id\/rumus-1\/\" data-wpil=\"url\">Rumus dalam format bersyarat<\/a><\/li><li> <a style=\"outline: none;\" href=\"https:\/\/exceladvisor.org\/id\/format-otomatis\/\">Opsi FORMAT OTOMATIS di Excel<\/a><\/li><li> <a style=\"outline: none;\" href=\"https:\/\/exceladvisor.org\/id\/sorot-garis-bergantian\/\">Sorot baris alternatif di Excel dengan contoh warna<\/a><\/li><li> <a style=\"outline: none;\" href=\"https:\/\/exceladvisor.org\/id\/permainan-ikon\/\" data-wpil=\"url\">Gunakan kumpulan ikon di Excel (pemformatan bersyarat)<\/a><\/li><li> <a style=\"outline: none;\" href=\"https:\/\/exceladvisor.org\/id\/font-terbaik\/\">5 Font Terbaik untuk Microsoft Excel<\/a><\/li><li> <a style=\"outline: none;\" href=\"https:\/\/exceladvisor.org\/id\/menyembunyikan-angka-nol\/\">Cara menyembunyikan nilai nol di Excel<\/a><\/li><\/ul><h2> Validasi data<\/h2><ul><li> <a style=\"outline: none;\" href=\"https:\/\/exceladvisor.org\/id\/rentang-tanggal-validasi-data\/\">Validasi data dengan rentang tanggal<\/a><\/li><li> <a style=\"outline: none;\" href=\"https:\/\/exceladvisor.org\/id\/daftar-drop-down-yang-bergantung\/\">Daftar drop-down dependen di Excel<\/a><\/li><li> <a style=\"outline: none;\" href=\"https:\/\/exceladvisor.org\/id\/daftar-dinamis\/\">Daftar drop-down dinamis di Excel<\/a><\/li><li> <a style=\"outline: none;\" href=\"https:\/\/exceladvisor.org\/id\/ya-tidak-ada-daftar-drop-down\/\">Buat Daftar Drop-Down Ya \u2013 Tidak di Excel<\/a><\/li><li> <a style=\"outline: none;\" href=\"https:\/\/exceladvisor.org\/id\/hapus-daftar-tarik-turun\/\">Hapus daftar drop-down (validasi data) di Excel<\/a><\/li><\/ul><h2> Untuk mencetak<\/h2><ul><li> <a style=\"outline: none;\" href=\"https:\/\/exceladvisor.org\/id\/mencetak-judul\/\">Terapkan Judul Cetak di Excel (atur baris 1 untuk mencetak di setiap halaman)<\/a><\/li><li> <a style=\"outline: none;\" href=\"https:\/\/exceladvisor.org\/id\/kertas-grafik\/\">Cetak kertas grafik di Excel (templat kotak persegi)<\/a><\/li><li> <a style=\"outline: none;\" href=\"https:\/\/exceladvisor.org\/id\/mengubah-orientasi-halaman\/\">Ubah orientasi halaman di Excel<\/a><\/li><li> <a style=\"outline: none;\" href=\"https:\/\/exceladvisor.org\/id\/margin-halaman\/\">Margin Halaman di Excel (Ubah dan Atur)<\/a><\/li><\/ul><h2> Pilihan<\/h2><ul><li> <a style=\"outline: none;\" href=\"https:\/\/exceladvisor.org\/id\/alat-kamera\/\">Alat Kamera Excel<\/a><\/li><li> <a style=\"outline: none;\" href=\"https:\/\/exceladvisor.org\/id\/pencarian-tujuan\/\">Pencari Sasaran di Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/jendela-arloji\/\">Jendela tontonan di Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/pemotong-excel\/\">Pemotong Excel (Panduan Lengkap)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/excel-secara-default-di-mac\/\">Jadikan Excel Default di Mac<\/a><\/li><li> <a style=\"outline: none;\" href=\"https:\/\/exceladvisor.org\/id\/mode-aman-excel\/\">Buka Excel dalam Mode Aman<\/a><\/li><li> <a style=\"outline: none;\" href=\"https:\/\/exceladvisor.org\/id\/mengosongkan-cache\/\">Hapus cache di Excel<\/a><\/li><li> <a style=\"outline: none;\" href=\"https:\/\/exceladvisor.org\/id\/seni-pintar\/\">Seni Cerdas di Excel<\/a><\/li><li> <a style=\"outline: none;\" href=\"https:\/\/exceladvisor.org\/id\/daftar-yang-dipersonalisasi\/\">Buat daftar kustom di Excel<\/a><\/li><li> <a style=\"outline: none;\" href=\"https:\/\/exceladvisor.org\/id\/pdf-di-excel\/\">Masukkan PDF ke Excel<\/a><\/li><li> <a style=\"outline: none;\" href=\"https:\/\/exceladvisor.org\/id\/koreksi-otomatis\/\">Gunakan Koreksi Otomatis di Excel<\/a><\/li><li> <a style=\"outline: none;\" href=\"https:\/\/exceladvisor.org\/id\/menyisipkan-gambar\/\">Sisipkan gambar ke dalam sel di Excel<\/a><\/li><li> <a style=\"outline: none;\" href=\"https:\/\/exceladvisor.org\/id\/menyematkan-file\/\">Sematkan file di Excel<\/a><\/li><li> Konversi PDF ke Excel<\/li><\/ul><h2> Pantai dan sel<\/h2><ul><li> <a style=\"outline: none;\" href=\"https:\/\/exceladvisor.org\/id\/alat-analisis-cepat\/\">Alat Analisis Cepat di Excel<\/a><\/li><li> <a style=\"outline: none;\" href=\"https:\/\/exceladvisor.org\/id\/menerapkan-beberapa-filter\/\">Terapkan beberapa filter ke kolom<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/sorot-nilai-atas-bawah\/\">Sorot nilai N atas dan bawah di Excel<\/a><\/li><li> <a style=\"outline: none;\" href=\"https:\/\/exceladvisor.org\/id\/kotak-centang\/\">Sisipkan kotak centang di Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/menggabungkan-sel-tanpa-kehilangan-data\/\">Gabungkan sel tanpa kehilangan data di Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/tempel-perkalian-khusus\/\">Kalikan di Excel menggunakan Paste Special<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/menambahkan-kode-batang\/\" data-wpil=\"url\">Tambahkan barcode di Excel (instal font)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/font-bawaan\/\">Font default (mengubah gaya, ukuran dan warna)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/menyaring-berdasarkan-warna\/\">Filter menurut warna di Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/mengganti-nama-tabel\/\">Ganti nama tabel di Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/nomor-kolom\/\">Nomor kolom di Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/sel-abu-abu\/\">Sel Abu-abu di Excel<\/a><\/li><li> <a style=\"outline: none;\" href=\"https:\/\/exceladvisor.org\/id\/membuat-sel-menjadi-lebih-besar\/\">Memperbesar sel di Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/hapus-tanda-hubung\/\">Hapus tanda hubung di Excel<\/a><\/li><li> <a style=\"outline: none;\" href=\"https:\/\/exceladvisor.org\/id\/temukan-sel-yang-digabungkan\/\">Temukan sel yang digabungkan di Excel<\/a><\/li><li> <a style=\"outline: none;\" href=\"https:\/\/exceladvisor.org\/id\/mengunci-sel-1\/\">Kunci Sel di Excel<\/a><\/li><li> <a style=\"outline: none;\" href=\"https:\/\/exceladvisor.org\/id\/temukan-rentang-nama\/\">Temukan berbagai nama di Excel<\/a><\/li><\/ul><h2> buku catatan<\/h2><ul><li> <a style=\"outline: none;\" href=\"https:\/\/exceladvisor.org\/id\/memperbaiki-file-excel-yang-rusak\/\">Perbaiki File Excel yang Rusak<\/a><\/li><li> <a style=\"outline: none;\" href=\"https:\/\/exceladvisor.org\/id\/memulihkan-file-yang-belum-disimpan\/\">Pulihkan file Excel yang belum disimpan saat Excel mogok<\/a><\/li><li> <a style=\"outline: none;\" href=\"https:\/\/exceladvisor.org\/id\/xlsx-ke-csv\/\">Simpan file Excel (workbook) dalam format CSV (XLSX TO CSV)<\/a><\/li><li> <a style=\"outline: none;\" href=\"https:\/\/exceladvisor.org\/id\/buka-file-teks\/\">Cara membuka file teks di Excel (.TXT)<\/a><\/li><\/ul><h2> Pemformatan bersyarat<\/h2><ul><li> <a style=\"outline: none;\" href=\"https:\/\/exceladvisor.org\/id\/pemformatan-bersyarat\/\">Panduan Lengkap Pemformatan Bersyarat di Excel<\/a><\/li><li> <a style=\"outline: none;\" href=\"https:\/\/exceladvisor.org\/id\/sel-kosong\/\">Terapkan Pemformatan Bersyarat pada Sel Kosong di Excel<\/a><\/li><li> <a style=\"outline: none;\" href=\"https:\/\/exceladvisor.org\/id\/membandingkan-kolom\/\">Bandingkan dua kolom menggunakan pemformatan bersyarat di Excel<\/a><\/li><li> <a style=\"outline: none;\" href=\"https:\/\/exceladvisor.org\/id\/sel-lain\/\">Terapkan pemformatan bersyarat berdasarkan sel lain di Excel<\/a><\/li><li> <a style=\"outline: none;\" href=\"https:\/\/exceladvisor.org\/id\/kolom-lain\/\">Terapkan pemformatan bersyarat berdasarkan kolom lain di Excel<\/a><\/li><li> <a style=\"outline: none;\" href=\"https:\/\/exceladvisor.org\/id\/menyalin\/\">Salin pemformatan bersyarat dari satu rentang ke rentang lainnya di Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/seluruh-kolom\/\">Terapkan pemformatan bersyarat ke seluruh kolom di Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/garis-sorot\/\">Sorot Baris Menggunakan Pemformatan Bersyarat di Excel<\/a><\/li><li> <a style=\"outline: none;\" href=\"https:\/\/exceladvisor.org\/id\/beberapa-kondisi\/\">Terapkan beberapa kondisi dalam pemformatan bersyarat di Excel<\/a><\/li><li> <a style=\"outline: none;\" href=\"https:\/\/exceladvisor.org\/id\/tidak-bekerja\/\">Mengapa pemformatan bersyarat tidak berfungsi di Excel<\/a><\/li><li> <a style=\"outline: none;\" href=\"https:\/\/exceladvisor.org\/id\/sel-berisi-teks\/\">Sorot jika sel berisi teks tertentu dengan format bersyarat di Excel<\/a><\/li><li> <a style=\"outline: none;\" href=\"https:\/\/exceladvisor.org\/id\/berdasarkan-tanggal-2\/\">Terapkan pemformatan bersyarat berdasarkan tanggal<\/a><\/li><li> <a style=\"outline: none;\" href=\"https:\/\/exceladvisor.org\/id\/skala-warna\/\">Menerapkan skala warna menggunakan pemformatan bersyarat<\/a><\/li><li> <a style=\"outline: none;\" href=\"https:\/\/exceladvisor.org\/id\/bilah-data\/\">Bilah Data di Excel Menggunakan Pemformatan Bersyarat<\/a><\/li><li> <a style=\"outline: none;\" href=\"https:\/\/exceladvisor.org\/id\/berhenti-jika-benar-2\/\">Hentikan IF True dalam Pemformatan Bersyarat<\/a><\/li><li> <a style=\"outline: none;\" href=\"https:\/\/exceladvisor.org\/id\/menemukan-duplikat-2\/\">Temukan dan sorot duplikat menggunakan pemformatan bersyarat<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/menarik\/\">Hapus pemformatan bersyarat di Excel<\/a><\/li><\/ul><h2> Mengeja<\/h2><ul><li> <a style=\"outline: none;\" href=\"https:\/\/exceladvisor.org\/id\/urutkan-secara-horizontal\/\">Urutkan secara horizontal di Excel<\/a><\/li><\/ul>","protected":false},"excerpt":{"rendered":"","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"ub_ctt_via":"","footnotes":""},"class_list":["post-1490","page","type-page","status-publish","hentry"],"featured_image_src":null,"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v25.4 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Excel Tingkat Lanjut: Fungsi, Rumus, Tip dan Tutorial 2023<\/title>\n<meta name=\"description\" content=\"Tutorial Excel tingkat lanjut mencakup fitur-fitur Microsoft Excel yang lebih canggih. Tutorial ini dirancang untuk\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/exceladvisor.org\/id\/unggul-terlebih-dahulu\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel Tingkat Lanjut: Fungsi, Rumus, Tip dan Tutorial 2023\" \/>\n<meta property=\"og:description\" content=\"Tutorial Excel tingkat lanjut mencakup fitur-fitur Microsoft Excel yang lebih canggih. Tutorial ini dirancang untuk\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/id\/unggul-terlebih-dahulu\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Estimasi waktu membaca\" \/>\n\t<meta name=\"twitter:data1\" content=\"4 menit\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/id\/unggul-terlebih-dahulu\/\",\"url\":\"https:\/\/exceladvisor.org\/id\/unggul-terlebih-dahulu\/\",\"name\":\"Excel Tingkat Lanjut: Fungsi, Rumus, Tip dan Tutorial 2023\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#website\"},\"datePublished\":\"2023-11-22T02:20:42+00:00\",\"description\":\"Tutorial Excel tingkat lanjut mencakup fitur-fitur Microsoft Excel yang lebih canggih. Tutorial ini dirancang untuk\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/unggul-terlebih-dahulu\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/id\/unggul-terlebih-dahulu\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/id\/unggul-terlebih-dahulu\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Rumah\",\"item\":\"https:\/\/exceladvisor.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Tutorial excel tingkat lanjut\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/exceladvisor.org\/id\/#website\",\"url\":\"https:\/\/exceladvisor.org\/id\/\",\"name\":\"Excel Advisor\",\"description\":\"Panduan utama Anda untuk mendominasi data!\",\"publisher\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/exceladvisor.org\/id\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"id\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/exceladvisor.org\/id\/#organization\",\"name\":\"Excel Advisor\",\"url\":\"https:\/\/exceladvisor.org\/id\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/exceladvisor.org\/id\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/exceladvisor.org\/id\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/id\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"width\":105,\"height\":36,\"caption\":\"Excel Advisor\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Excel Tingkat Lanjut: Fungsi, Rumus, Tip dan Tutorial 2023","description":"Tutorial Excel tingkat lanjut mencakup fitur-fitur Microsoft Excel yang lebih canggih. Tutorial ini dirancang untuk","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/exceladvisor.org\/id\/unggul-terlebih-dahulu\/","og_locale":"id_ID","og_type":"article","og_title":"Excel Tingkat Lanjut: Fungsi, Rumus, Tip dan Tutorial 2023","og_description":"Tutorial Excel tingkat lanjut mencakup fitur-fitur Microsoft Excel yang lebih canggih. Tutorial ini dirancang untuk","og_url":"https:\/\/exceladvisor.org\/id\/unggul-terlebih-dahulu\/","og_site_name":"Excel Advisor","twitter_card":"summary_large_image","twitter_misc":{"Estimasi waktu membaca":"4 menit"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/id\/unggul-terlebih-dahulu\/","url":"https:\/\/exceladvisor.org\/id\/unggul-terlebih-dahulu\/","name":"Excel Tingkat Lanjut: Fungsi, Rumus, Tip dan Tutorial 2023","isPartOf":{"@id":"https:\/\/exceladvisor.org\/id\/#website"},"datePublished":"2023-11-22T02:20:42+00:00","description":"Tutorial Excel tingkat lanjut mencakup fitur-fitur Microsoft Excel yang lebih canggih. Tutorial ini dirancang untuk","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/id\/unggul-terlebih-dahulu\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/id\/unggul-terlebih-dahulu\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/id\/unggul-terlebih-dahulu\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Rumah","item":"https:\/\/exceladvisor.org\/id\/"},{"@type":"ListItem","position":2,"name":"Tutorial excel tingkat lanjut"}]},{"@type":"WebSite","@id":"https:\/\/exceladvisor.org\/id\/#website","url":"https:\/\/exceladvisor.org\/id\/","name":"Excel Advisor","description":"Panduan utama Anda untuk mendominasi data!","publisher":{"@id":"https:\/\/exceladvisor.org\/id\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/exceladvisor.org\/id\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"id"},{"@type":"Organization","@id":"https:\/\/exceladvisor.org\/id\/#organization","name":"Excel Advisor","url":"https:\/\/exceladvisor.org\/id\/","logo":{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/exceladvisor.org\/id\/#\/schema\/logo\/image\/","url":"https:\/\/exceladvisor.org\/id\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","contentUrl":"https:\/\/exceladvisor.org\/id\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","width":105,"height":36,"caption":"Excel Advisor"},"image":{"@id":"https:\/\/exceladvisor.org\/id\/#\/schema\/logo\/image\/"}}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1490","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/comments?post=1490"}],"version-history":[{"count":0,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1490\/revisions"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/media?parent=1490"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}