{"id":1923,"date":"2023-10-28T01:26:59","date_gmt":"2023-10-28T01:26:59","guid":{"rendered":"https:\/\/exceladvisor.org\/id\/sorot-nilai-atas-bawah\/"},"modified":"2023-12-06T06:19:28","modified_gmt":"2023-12-06T06:19:28","slug":"sorot-nilai-atas-bawah","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/id\/sorot-nilai-atas-bawah\/","title":{"rendered":"Bagaimana cara menyorot nilai n atas dan bawah?"},"content":{"rendered":"<div class=\"excel-before-content\" id=\"excel-3312406739\"><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>Cara terbaik untuk menyorot nilai dari atas ke bawah adalah dengan menggunakan pemformatan bersyarat. Ini cepat dan mudah, dan hanya membutuhkan beberapa klik. Namun, bagian terbaiknya adalah Anda bahkan tidak perlu menulis rumus untuk ini.<\/p><p> Saya telah menggunakannya sejak saya mendapatkan pekerjaan pertama saya. bos saya menelepon saya Kapan pun dengan semacam laporan, saya melakukannya tanpa gagal menyoroti nilai atas dan bawah. Dan jika Anda belum menggunakannya, izinkan saya memberi tahu Anda cara menggunakannya. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-10058\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/comment-mettre-en-surbrillance-les-valeurs-n-superieures-inferieures-dans-le-tableau-de-donnees-Excel-1.png\" sizes=\"auto, \" srcset=\"\" alt=\"cara menyorot nilai n atas bawah pada tabel data excel\" width=\"202\" height=\"555\"><\/figure><\/div><p> Di bawah ini saya memiliki tabel dengan penjualan per hari dan saya ingin menyorot 10 hari teratas dengan penjualan tertinggi (tabelnya agak panjang di sini).<\/p><h2 class=\"wp-block-heading\"> Sorot 10 nilai teratas<\/h2><ul><li> Pertama, pilih data yang ingin Anda soroti nilai tertingginya.<\/li><li> Buka tab Beranda -&gt; Gaya -&gt; Pemformatan Bersyarat -&gt; Aturan Atas\/Bawah -&gt; 10 Teratas. <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-10056\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/comment-mettre-en-surbrillance-les-n-valeurs-les-plus-basses-dans-la-regle-excel-top-botm-1.png\" sizes=\"auto, \" srcset=\"\" alt=\"cara menyorot nilai n terendah di excel top botm rule\" width=\"357\" height=\"412\"><\/figure><\/div><ul><li> Sekarang di jendela pop-up Anda memiliki dua hal untuk ditentukan.<ol><li> Jumlah nilai yang akan disorot ( <em>10 teratas untuk saat ini<\/em> ).<\/li><li> Pemformatan yang digunakan untuk menyorot nilai. <\/li><\/ol><\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-10054\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/comment-mettre-en-surbrillance-les-n-valeurs-superieures-inferieures-au-format-Excel-pour-mettre-en-surbrillance-les-cellules-1.png\" sizes=\"auto, \" srcset=\"\" alt=\"cara menyorot nilai n atas bawah pada tabel data excel\" width=\"307\" height=\"190\"><\/figure><\/div><ul><li> Setelah itu klik OK. <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-10059\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/comment-mettre-en-surbrillance-les-valeurs-n-superieures-inferieures-dans-Excel-avec-le-formatage-1.png\" sizes=\"auto, \" srcset=\"\" alt=\"cara menyorot nilai n atas bawah di excel dengan format\" width=\"202\" height=\"555\"><\/figure><\/div><p> Ini akan langsung menyorot 10 nilai pertama dari data dengan gaya pemformatan yang Anda sebutkan.<\/p><h2 class=\"wp-block-heading\"> Sorot 10 nilai terakhir<\/h2><p> Untuk menyorot 10 nilai terakhir, Anda dapat mengikuti langkah yang sama. Namun alih-alih 10 teratas, cukup klik 10 terbawah, dan sisanya sama.<\/p><ul><li> Pilih jumlah nilai yang akan disorot.<\/li><li> Dan, format yang digunakan.<\/li><\/ul><h2 class=\"wp-block-heading\"> Apa lagi? <\/h2><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-10055\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/comment-mettre-en-surbrillance-les-valeurs-n-superieures-inferieures-dans-Excel-autres-options-1.png\" sizes=\"auto, \" srcset=\"\" alt=\"cara menyorot nilai n atas bawah di excel opsi lainnya\" width=\"176\" height=\"266\"><\/figure><\/div><p> Dalam opsi aturan atas\/bawah pemformatan bersyarat, Anda memiliki opsi berguna lainnya.<\/p><ul><li> <strong>10% Teratas<\/strong> \u2013 Gunakan ini untuk menyorot nilai teratas yang setara dengan 10% data.<\/li><li> <strong>10% Terbawah<\/strong> \u2013 Sorot nilai terbawah yang setara dengan 10% data.<\/li><li> <strong>Di Atas Rata-Rata<\/strong> \u2013 Untuk menyorot nilai yang berada di atas nilai rata-rata suatu data.<\/li><li> <strong>Di Bawah Rata-Rata<\/strong> \u2013 Gunakan opsi ini untuk menyorot nilai di bawah nilai rata-rata data.<\/li><\/ul><p> Seperti yang saya katakan sebelumnya, saya menyorot nilai teratas dan terbawah di semua laporan saya. Dan ini juga membantu orang lain mendapatkan gambaran singkat, meskipun datanya hanya berupa tabel.<\/p><div class=\"gb-container gb-container-4db6181c gb-container-mt\"> <a class=\"gb-button gb-button-c5897111 gb-button-text gb-button-mt-button\" href=\"https:\/\/exceladvisor.org\/id\/unggul-terlebih-dahulu\/\">Tutorial Excel Tingkat Lanjut<\/a><h2 class=\"gb-headline gb-headline-665e5f6b gb-headline-text gb-headline-mt-heading\"> Tutorial terkait <\/h2><div class=\"gb-grid-wrapper gb-grid-wrapper-a20baf7c gb-grid-wrapper-mt-grid\"><div class=\"gb-grid-column gb-grid-column-65ddf67e\"><div class=\"gb-container gb-container-65ddf67e\"><ul><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 kode batang di Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/font-bawaan\/\">Ubah font default di Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/menyaring-berdasarkan-warna\/\">Filter menurut warna di Excel<\/a><\/li><\/ul><\/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-1923","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>Sorot nilai N atas dan bawah<\/title>\n<meta name=\"description\" content=\"Pada artikel ini, Anda akan mempelajari cara menyorot nilai atas dan bawah di Excel.\" \/>\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\/sorot-nilai-atas-bawah\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Sorot nilai N atas dan bawah\" \/>\n<meta property=\"og:description\" content=\"Pada artikel ini, Anda akan mempelajari cara menyorot nilai atas dan bawah di Excel.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/id\/sorot-nilai-atas-bawah\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-06T06:19:28+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/comment-mettre-en-surbrillance-les-valeurs-n-superieures-inferieures-dans-le-tableau-de-donnees-Excel-1.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\/sorot-nilai-atas-bawah\/\",\"url\":\"https:\/\/exceladvisor.org\/id\/sorot-nilai-atas-bawah\/\",\"name\":\"Sorot nilai N atas dan bawah\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/sorot-nilai-atas-bawah\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/sorot-nilai-atas-bawah\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/comment-mettre-en-surbrillance-les-valeurs-n-superieures-inferieures-dans-le-tableau-de-donnees-Excel-1.png\",\"datePublished\":\"2023-10-28T01:26:59+00:00\",\"dateModified\":\"2023-12-06T06:19:28+00:00\",\"description\":\"Pada artikel ini, Anda akan mempelajari cara menyorot nilai atas dan bawah di Excel.\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/sorot-nilai-atas-bawah\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/id\/sorot-nilai-atas-bawah\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/exceladvisor.org\/id\/sorot-nilai-atas-bawah\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/comment-mettre-en-surbrillance-les-valeurs-n-superieures-inferieures-dans-le-tableau-de-donnees-Excel-1.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/comment-mettre-en-surbrillance-les-valeurs-n-superieures-inferieures-dans-le-tableau-de-donnees-Excel-1.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/id\/sorot-nilai-atas-bawah\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Rumah\",\"item\":\"https:\/\/exceladvisor.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Bagaimana cara menyorot nilai n atas dan bawah?\"}]},{\"@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":"Sorot nilai N atas dan bawah","description":"Pada artikel ini, Anda akan mempelajari cara menyorot nilai atas dan bawah di Excel.","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\/sorot-nilai-atas-bawah\/","og_locale":"id_ID","og_type":"article","og_title":"Sorot nilai N atas dan bawah","og_description":"Pada artikel ini, Anda akan mempelajari cara menyorot nilai atas dan bawah di Excel.","og_url":"https:\/\/exceladvisor.org\/id\/sorot-nilai-atas-bawah\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-06T06:19:28+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/comment-mettre-en-surbrillance-les-valeurs-n-superieures-inferieures-dans-le-tableau-de-donnees-Excel-1.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\/sorot-nilai-atas-bawah\/","url":"https:\/\/exceladvisor.org\/id\/sorot-nilai-atas-bawah\/","name":"Sorot nilai N atas dan bawah","isPartOf":{"@id":"https:\/\/exceladvisor.org\/id\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/id\/sorot-nilai-atas-bawah\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/id\/sorot-nilai-atas-bawah\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/comment-mettre-en-surbrillance-les-valeurs-n-superieures-inferieures-dans-le-tableau-de-donnees-Excel-1.png","datePublished":"2023-10-28T01:26:59+00:00","dateModified":"2023-12-06T06:19:28+00:00","description":"Pada artikel ini, Anda akan mempelajari cara menyorot nilai atas dan bawah di Excel.","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/id\/sorot-nilai-atas-bawah\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/id\/sorot-nilai-atas-bawah\/"]}]},{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/exceladvisor.org\/id\/sorot-nilai-atas-bawah\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/comment-mettre-en-surbrillance-les-valeurs-n-superieures-inferieures-dans-le-tableau-de-donnees-Excel-1.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/comment-mettre-en-surbrillance-les-valeurs-n-superieures-inferieures-dans-le-tableau-de-donnees-Excel-1.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/id\/sorot-nilai-atas-bawah\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Rumah","item":"https:\/\/exceladvisor.org\/id\/"},{"@type":"ListItem","position":2,"name":"Bagaimana cara menyorot nilai n atas dan bawah?"}]},{"@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\/1923","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=1923"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1923\/revisions"}],"predecessor-version":[{"id":2855,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1923\/revisions\/2855"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/media?parent=1923"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}