{"id":1611,"date":"2023-11-15T11:37:07","date_gmt":"2023-11-15T11:37:07","guid":{"rendered":"https:\/\/exceladvisor.org\/id\/referensi-3d\/"},"modified":"2023-12-06T06:13:47","modified_gmt":"2023-12-06T06:13:47","slug":"referensi-3d","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/id\/referensi-3d\/","title":{"rendered":"Bagaimana cara membuat referensi 3d di excel?"},"content":{"rendered":"<div class=\"excel-before-content\" id=\"excel-3036292739\"><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>Kita semua ingin menghemat waktu. Selain itu, menggunakan Referensi 3D di Excel dapat menghemat banyak waktu.<\/p><p> Ini seperti grafik atau gambar tiga dimensi dengan lebih dari satu fase. <span style=\"font-size: 1em;\">Kisaran normal adalah untuk sekelompok sel pada satu lembar kerja.<\/span><\/p><p> Misalnya, di =SUM(Sheet1!A1:A10), &#8220;A1:A10&#8221; adalah sekelompok sel yang direferensikan dari Sheet1.<\/p><p> Namun, referensi 3D adalah rentang sel di mana Anda bisa merujuk ke sel yang sama dari beberapa lembar kerja menggunakan satu referensi. Secara sederhana, merujuk pada sel atau rentang yang sama di beberapa lembar.<\/p><h2 id=\"h-create-a-3d-reference\" class=\"wp-block-heading\"> Buat referensi 3D<\/h2><p> Satu-satunya hal yang perlu Anda perhatikan sebelum menggunakan referensi 3D adalah semua lembar kerja harus berurutan. Mari saya tunjukkan sebuah contoh. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Ajouter-des-feuilles-de-calcul-pour-utiliser-la-plage-Excel-3D.png\" sizes=\"\" srcset=\"\" alt=\"Tambahkan lembar kerja untuk menggunakan rentang 3D Excel\"><\/figure><\/div><p> Sekarang di sini Anda memiliki 5 lembar kerja dalam satu buku kerja. Jadi jika Anda ingin menghitung jumlah range C5:D6 dari kelima lembar kerja, Anda perlu menggunakan rumus seperti di bawah ini.<\/p><pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=('2009'!A1:A10,'2010'!A1:A10,'2011'!A1:A10,'2012'!A1:A10,'2013'!A1:A10)<\/code><\/pre><p> Namun jika ingin membuat rumus 3D dengan referensi 3D maka akan seperti ini.<\/p><pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=SUM('2009:2013'!A1:A10)<\/code><\/pre><h2 id=\"h-how-3d-reference-works-in-excel\" class=\"wp-block-heading\"> Cara kerja referensi 3D di Excel<\/h2><p> Rumus rentang 3D selalu berfungsi di dua bagian berbeda. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Comment-fonctionne-la-gamme-Excel-3D-1.png\" sizes=\"\" srcset=\"\" alt=\"Cara kerja rentang 3D Excel\"><\/figure><\/div><ul><li> <strong>Pertama:<\/strong> Rentang Lembar Kerja: Seperti rentang sel, Anda perlu membuat rentang lembar kerja yang ingin Anda referensikan selnya. Rentang lembar kerja harus merupakan rentang kontinu. Pada contoh di atas, saya memiliki 5 spreadsheet dari tahun 2009 hingga 2013.<\/li><li> <strong>Kedua<\/strong> : Rentang sel. Rentang sel normal yang <span style=\"font-size: revert;\">ingin Anda rujuk di semua lembar kerja.<\/span><\/li><\/ul><h2 id=\"h-adding-a-new-worksheet\" class=\"wp-block-heading\"> Menambahkan spreadsheet baru<\/h2><p> Misalkan Anda menyisipkan lembar kerja antara tahun 2009 dan 2013. Secara otomatis akan menyertakan nilai rentang A1:A10 dari lembar baru dalam fungsi yang Anda gunakan. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Comment-creer-une-plage-3D5-1.png\" sizes=\"\" srcset=\"\" alt=\"informasi lebih lanjut tentang menambahkan lembar kerja baru ke rentang 3d\"><\/figure><\/div><h2 id=\"h-deleting-a-worksheet\" class=\"wp-block-heading\"> Menghapus spreadsheet:<\/h2><p> Jika Anda menghapus lembar kerja dari tahun 2009 hingga 2013. Ini secara otomatis akan mengecualikan nilai di sel C4 dari fungsi yang Anda gunakan.<\/p><h2 id=\"h-the-sequence-of-worksheets\" class=\"wp-block-heading\"> Urutan lembar kerja:<\/h2><p> Di sini, di contoh ini, rentang lembar kerja dimulai dari \u201cSheet 2009\u201d dan berakhir di \u201cSheet 2013\u201d. Intinya adalah jika Anda memindahkan sheet keluar dari rentang ini, sheet tersebut akan dikeluarkan dari perhitungan rumus.<\/p><h2 id=\"h-conclusion\" class=\"wp-block-heading\"> Kesimpulan<\/h2><p> Salah satu manfaat terpenting dari referensi 3D adalah dapat mempersingkat rumus kompleks Anda. Anda tidak perlu mereferensikan semua lembar kerja secara terpisah dalam rumus. Dan saya harap metode ini akan membantu Anda menulis rumus yang lebih baik.<\/p><p> Sekarang beritahu aku satu hal. Pernahkah Anda mencoba ini sebelumnya? Silakan bagikan pemikiran Anda dengan saya di bagian komentar, saya ingin mendengar pendapat Anda. Dan jangan lupa untuk berbagi dengan teman-teman Anda. <\/p><div class=\"gb-container gb-container-bafb25cc gb-container-download-2\"><div class=\"gb-grid-wrapper gb-grid-wrapper-91201309\"><div class=\"gb-grid-column gb-grid-column-15a917ef\"><div class=\"gb-container gb-container-15a917ef\"><h2 class=\"gb-headline gb-headline-f2deb261 gb-headline-text gb-headline-download-2\"> Dapatkan file Excelnya <\/h2><\/div><\/div><div class=\"gb-grid-column gb-grid-column-18357188\"><div class=\"gb-container gb-container-18357188\"><div class=\"gb-container gb-container-76cbe15e\"> <a class=\"gb-button gb-button-cb63d00a gb-button-text gb-button-download-2\" href=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/gamme-3d.xlsx\" rel=\"nofollow\">Unduh<\/a><\/div><\/div><\/div><\/div><\/div><div class=\"gb-container gb-container-0df56012 gb-container-mt\"> <a class=\"gb-button gb-button-f9f432f4 gb-button-text gb-button-mt-button\" href=\"https:\/\/exceladvisor.org\/id\/rumus\/\">Daftar rumus Excel<\/a><h2 class=\"gb-headline gb-headline-233444e8 gb-headline-text gb-headline-mt-heading\"> Rumus terkait <\/h2><div class=\"gb-grid-wrapper gb-grid-wrapper-a16fa65c gb-grid-wrapper-mt-grid\"><div class=\"gb-grid-column gb-grid-column-50d07e0d\"><div class=\"gb-container gb-container-50d07e0d\"><ul><li> <a href=\"https:\/\/exceladvisor.org\/id\/karakter-pengganti-2\/\">Wildcard di Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/menyembunyikan-rumus\/\">Sembunyikan rumus di Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/r1c1\/\">Gaya referensi R1C1 di Excel<\/a> <\/li><\/ul><\/div><\/div><div class=\"gb-grid-column gb-grid-column-5b4a0cf9\"><div class=\"gb-container gb-container-5b4a0cf9\"><\/div><\/div><\/div><\/div>","protected":false},"excerpt":{"rendered":"","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"open","ping_status":"closed","template":"","meta":{"ub_ctt_via":"","footnotes":""},"class_list":["post-1611","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>Bagaimana cara membuat referensi 3D di Excel? (Tutorial 2023)<\/title>\n<meta name=\"description\" content=\"Dengan referensi Excel 3D, Anda bisa mereferensikan rentang sel yang sama dari lembar kerja yang berbeda. Mungkin saja\" \/>\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\/referensi-3d\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Bagaimana cara membuat referensi 3D di Excel? (Tutorial 2023)\" \/>\n<meta property=\"og:description\" content=\"Dengan referensi Excel 3D, Anda bisa mereferensikan rentang sel yang sama dari lembar kerja yang berbeda. Mungkin saja\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/id\/referensi-3d\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-06T06:13:47+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Ajouter-des-feuilles-de-calcul-pour-utiliser-la-plage-Excel-3D.png\" \/>\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=\"2 menit\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/id\/referensi-3d\/\",\"url\":\"https:\/\/exceladvisor.org\/id\/referensi-3d\/\",\"name\":\"Bagaimana cara membuat referensi 3D di Excel? (Tutorial 2023)\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/referensi-3d\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/referensi-3d\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Ajouter-des-feuilles-de-calcul-pour-utiliser-la-plage-Excel-3D.png\",\"datePublished\":\"2023-11-15T11:37:07+00:00\",\"dateModified\":\"2023-12-06T06:13:47+00:00\",\"description\":\"Dengan referensi Excel 3D, Anda bisa mereferensikan rentang sel yang sama dari lembar kerja yang berbeda. Mungkin saja\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/referensi-3d\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/id\/referensi-3d\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/exceladvisor.org\/id\/referensi-3d\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Ajouter-des-feuilles-de-calcul-pour-utiliser-la-plage-Excel-3D.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Ajouter-des-feuilles-de-calcul-pour-utiliser-la-plage-Excel-3D.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/id\/referensi-3d\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Rumah\",\"item\":\"https:\/\/exceladvisor.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Bagaimana cara membuat referensi 3d di excel?\"}]},{\"@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":"Bagaimana cara membuat referensi 3D di Excel? (Tutorial 2023)","description":"Dengan referensi Excel 3D, Anda bisa mereferensikan rentang sel yang sama dari lembar kerja yang berbeda. Mungkin saja","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\/referensi-3d\/","og_locale":"id_ID","og_type":"article","og_title":"Bagaimana cara membuat referensi 3D di Excel? (Tutorial 2023)","og_description":"Dengan referensi Excel 3D, Anda bisa mereferensikan rentang sel yang sama dari lembar kerja yang berbeda. Mungkin saja","og_url":"https:\/\/exceladvisor.org\/id\/referensi-3d\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-06T06:13:47+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Ajouter-des-feuilles-de-calcul-pour-utiliser-la-plage-Excel-3D.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Estimasi waktu membaca":"2 menit"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/id\/referensi-3d\/","url":"https:\/\/exceladvisor.org\/id\/referensi-3d\/","name":"Bagaimana cara membuat referensi 3D di Excel? (Tutorial 2023)","isPartOf":{"@id":"https:\/\/exceladvisor.org\/id\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/id\/referensi-3d\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/id\/referensi-3d\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Ajouter-des-feuilles-de-calcul-pour-utiliser-la-plage-Excel-3D.png","datePublished":"2023-11-15T11:37:07+00:00","dateModified":"2023-12-06T06:13:47+00:00","description":"Dengan referensi Excel 3D, Anda bisa mereferensikan rentang sel yang sama dari lembar kerja yang berbeda. Mungkin saja","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/id\/referensi-3d\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/id\/referensi-3d\/"]}]},{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/exceladvisor.org\/id\/referensi-3d\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Ajouter-des-feuilles-de-calcul-pour-utiliser-la-plage-Excel-3D.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Ajouter-des-feuilles-de-calcul-pour-utiliser-la-plage-Excel-3D.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/id\/referensi-3d\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Rumah","item":"https:\/\/exceladvisor.org\/id\/"},{"@type":"ListItem","position":2,"name":"Bagaimana cara membuat referensi 3d di excel?"}]},{"@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\/1611","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=1611"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1611\/revisions"}],"predecessor-version":[{"id":2311,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1611\/revisions\/2311"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/media?parent=1611"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}