{"id":13223,"date":"2017-06-09T13:16:42","date_gmt":"2017-06-09T05:16:42","guid":{"rendered":"http:\/\/www.mu.my\/what-is-a-pivottable\/"},"modified":"2020-03-30T06:15:52","modified_gmt":"2020-03-30T06:15:52","slug":"apakah-itu-pivottable","status":"publish","type":"post","link":"https:\/\/www.mu.my\/ms\/berita\/apakah-itu-pivottable\/","title":{"rendered":"Apakah itu PivotTable?"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-post\" data-elementor-id=\"13223\" class=\"elementor elementor-13223 elementor-bc-flex-widget\" data-elementor-post-type=\"post\">\n\t\t\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-876adc3 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"876adc3\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-3ce357c\" data-id=\"3ce357c\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-59d38b8 elementor-widget elementor-widget-image-gallery\" data-id=\"59d38b8\" data-element_type=\"widget\" data-widget_type=\"image-gallery.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"elementor-image-gallery\">\n\t\t\t<div id='gallery-1' class='gallery galleryid-13223 gallery-columns-1 gallery-size-full'><figure class='gallery-item'>\n\t\t\t<div class='gallery-icon landscape'>\n\t\t\t\t<a data-elementor-open-lightbox=\"yes\" data-elementor-lightbox-slideshow=\"59d38b8\" data-elementor-lightbox-title=\"pivot-table-551x350\" data-e-action-hash=\"#elementor-action%3Aaction%3Dlightbox%26settings%3DeyJpZCI6Mjk2ODgsInVybCI6Imh0dHBzOlwvXC93d3cubXUubXlcL2ZpbGVzXC91cGxvYWRzXC9waXZvdC10YWJsZS01NTF4MzUwLTMuanBnIiwic2xpZGVzaG93IjoiNTlkMzhiOCJ9\" href='https:\/\/www.mu.my\/files\/uploads\/pivot-table-551x350-3.jpg'><img fetchpriority=\"high\" decoding=\"async\" width=\"551\" height=\"350\" src=\"https:\/\/www.mu.my\/files\/uploads\/pivot-table-551x350-3.jpg\" class=\"attachment-full size-full\" alt=\"\" srcset=\"https:\/\/www.mu.my\/files\/uploads\/pivot-table-551x350-3.jpg 551w, https:\/\/www.mu.my\/files\/uploads\/pivot-table-551x350-3-300x191.jpg 300w\" sizes=\"(max-width: 551px) 100vw, 551px\" \/><\/a>\n\t\t\t<\/div><\/figure>\n\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-70d4ef5 elementor-widget elementor-widget-text-editor\" data-id=\"70d4ef5\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p><span style=\"font-weight: bold;\">PivotTable<\/span>\u00a0merupakan salah satu ciri yang paling hebat di dalam Excel. Ia akan menjimatkan anda\u00a0 banyak masa untuk\u00a0<span style=\"font-weight: bold;\">meringkaskan set data yang besar dan terperinci menjadi satu laporan yang sangat bermakna.<\/span><\/p><p>Katakan anda mempunyai sebuah lembaran kerja yang mengandungi data jualan bulanan dan anda ingin tahu pelanggan dari kawasan yang mana mempunyai jumlah jualan tertinggi dalam bulan ini. Anda boleh dan sudah tentu akan melihat lembaran kerja tersebut dan menyusun secara manual dan mengira data dan membuat jadual baru yang diringkaskan.<\/p><p>Tetapi bagaimana pula jika data anda mengandungi beribu-ribu data yang beribu-ribu baris? Dengan menggunakan PivotTable boleh secara automatik agregat kesemua data dan mengira jumlah dengan hanya beberapa klik sahaja. Anda sentiasa boleh menukar bagaimana paparan rajah mengikut keperluan anda.<\/p><p>Anda juga boleh membuat\u00a0<span style=\"font-weight: bold;\">PivotChart<\/span>\u00a0yang berasaskan PivotTable dengan mengunakan penyaring dengan secara mudah dapat membandingkan nombor-nombor ini. PivotChart akan dikemaskini secara automatik apabila anda melakukan PivotTable.<\/p><p>Ingin mempunyai pemahaman yang lebih baik untuk PivotTables atau PivotCharts? Mendaftarlah\u00a0<a href=\"http:\/\/www.mu.my\/ms\/kursus\/kursus-microsoft-excel-lanjutan\/\"><span style=\"font-weight: bold;\">Kursus Microsoft Excel Lanjutan<\/span><\/a>\u00a0dengan kami untuk belajar lebih lanjut mengenai Excel dan pelbagai lagi ciri-cirinya yang hebat.<\/p><p><span style=\"font-weight: bold;\"><a href=\"http:\/\/www.mu.my\/ms\/kursus\/kursus-microsoft-excel-lanjutan\/\">Kursus Microsoft Excel Lanjutan<\/a><\/span>\u00a0yang akan datang adalah pada 13-14 Julai 2017.<\/p><p>Hubungi kami\u00a0<a href=\"mailto:info@mu.my\" target=\"_blank\" rel=\"noopener\">info@mu.my<\/a>\u00a0atau 03-8011 6639<\/p><p><span style=\"background-color: rgba(255, 255, 255, 0); letter-spacing: 0px;\"><span style=\"background-color: rgba(255, 255, 255, 0); letter-spacing: 0px;\">Ketahui lebih lanjut tentang excel di\u00a0<\/span><\/span><a style=\"background-color: rgba(255, 255, 255, 0); letter-spacing: 0px;\" href=\"http:\/\/excel.my\/\" target=\"_blank\" rel=\"noopener\">excel.my<\/a><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"<p>PivotTable&nbsp;merupakan salah satu ciri yang paling hebat di dalam Excel. Ia akan menjimatkan anda&nbsp; banyak masa untuk&nbsp;meringkaskan set data yang besar dan terperinci menjadi satu laporan yang sangat bermakna. Katakan anda mempunyai sebuah lembaran kerja yang mengandungi data jualan bulanan dan anda ingin tahu pelanggan dari kawasan yang mana mempunyai jumlah jualan tertinggi dalam bulan &#8230; <a title=\"Apakah itu PivotTable?\" class=\"read-more\" href=\"https:\/\/www.mu.my\/ms\/berita\/apakah-itu-pivottable\/\" aria-label=\"Read more about Apakah itu PivotTable?\">Read more<\/a><\/p>\n","protected":false},"author":5,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[178],"tags":[],"class_list":["post-13223","post","type-post","status-publish","format-standard","hentry","category-berita"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v24.1 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Apakah itu PivotTable? - MU DOT MY PLT - ICT Training &amp; Development Malaysia<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.mu.my\/ms\/berita\/apakah-itu-pivottable\/\" \/>\n<meta property=\"og:locale\" content=\"ms_MY\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Apakah itu PivotTable? - MU DOT MY PLT - ICT Training &amp; Development Malaysia\" \/>\n<meta property=\"og:description\" content=\"PivotTable&nbsp;merupakan salah satu ciri yang paling hebat di dalam Excel. Ia akan menjimatkan anda&nbsp; banyak masa untuk&nbsp;meringkaskan set data yang besar dan terperinci menjadi satu laporan yang sangat bermakna. Katakan anda mempunyai sebuah lembaran kerja yang mengandungi data jualan bulanan dan anda ingin tahu pelanggan dari kawasan yang mana mempunyai jumlah jualan tertinggi dalam bulan ... Read more\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.mu.my\/ms\/berita\/apakah-itu-pivottable\/\" \/>\n<meta property=\"og:site_name\" content=\"MU DOT MY PLT - ICT Training &amp; Development Malaysia\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/facebook.com\/mudotmy\" \/>\n<meta property=\"article:published_time\" content=\"2017-06-09T05:16:42+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2020-03-30T06:15:52+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/www.mu.my\/files\/uploads\/pivot-table-551x350-3.jpg\" \/>\n<meta name=\"author\" content=\"Sam S\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@mudotmy\" \/>\n<meta name=\"twitter:site\" content=\"@mudotmy\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Sam S\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minit\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.mu.my\/ms\/berita\/apakah-itu-pivottable\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.mu.my\/ms\/berita\/apakah-itu-pivottable\/\"},\"author\":{\"name\":\"Sam S\",\"@id\":\"https:\/\/www.mu.my\/ms\/#\/schema\/person\/d957efddd16e2298098bba24e7e8f6e4\"},\"headline\":\"Apakah itu PivotTable?\",\"datePublished\":\"2017-06-09T05:16:42+00:00\",\"dateModified\":\"2020-03-30T06:15:52+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.mu.my\/ms\/berita\/apakah-itu-pivottable\/\"},\"wordCount\":216,\"publisher\":{\"@id\":\"https:\/\/www.mu.my\/ms\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.mu.my\/ms\/berita\/apakah-itu-pivottable\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/www.mu.my\/files\/uploads\/pivot-table-551x350-3.jpg\",\"articleSection\":[\"Berita\"],\"inLanguage\":\"ms-MY\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.mu.my\/ms\/berita\/apakah-itu-pivottable\/\",\"url\":\"https:\/\/www.mu.my\/ms\/berita\/apakah-itu-pivottable\/\",\"name\":\"Apakah itu PivotTable? - MU DOT MY PLT - ICT Training & Development Malaysia\",\"isPartOf\":{\"@id\":\"https:\/\/www.mu.my\/ms\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.mu.my\/ms\/berita\/apakah-itu-pivottable\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.mu.my\/ms\/berita\/apakah-itu-pivottable\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/www.mu.my\/files\/uploads\/pivot-table-551x350-3.jpg\",\"datePublished\":\"2017-06-09T05:16:42+00:00\",\"dateModified\":\"2020-03-30T06:15:52+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.mu.my\/ms\/berita\/apakah-itu-pivottable\/#breadcrumb\"},\"inLanguage\":\"ms-MY\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.mu.my\/ms\/berita\/apakah-itu-pivottable\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"ms-MY\",\"@id\":\"https:\/\/www.mu.my\/ms\/berita\/apakah-itu-pivottable\/#primaryimage\",\"url\":\"http:\/\/www.mu.my\/files\/uploads\/pivot-table-551x350-3.jpg\",\"contentUrl\":\"http:\/\/www.mu.my\/files\/uploads\/pivot-table-551x350-3.jpg\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.mu.my\/ms\/berita\/apakah-itu-pivottable\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.mu.my\/ms\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Apakah itu PivotTable?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.mu.my\/ms\/#website\",\"url\":\"https:\/\/www.mu.my\/ms\/\",\"name\":\"MU DOT MY PLT - ICT Training & Development Malaysia\",\"description\":\"extracting knowledge\",\"publisher\":{\"@id\":\"https:\/\/www.mu.my\/ms\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.mu.my\/ms\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"ms-MY\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.mu.my\/ms\/#organization\",\"name\":\"MU DOT MY PLT\",\"url\":\"https:\/\/www.mu.my\/ms\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"ms-MY\",\"@id\":\"https:\/\/www.mu.my\/ms\/#\/schema\/logo\/image\/\",\"url\":\"http:\/\/www.mu.my\/files\/uploads\/MU-logo.png\",\"contentUrl\":\"http:\/\/www.mu.my\/files\/uploads\/MU-logo.png\",\"width\":502,\"height\":476,\"caption\":\"MU DOT MY PLT\"},\"image\":{\"@id\":\"https:\/\/www.mu.my\/ms\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/facebook.com\/mudotmy\",\"https:\/\/x.com\/mudotmy\",\"https:\/\/instagram.com\/mudotmyplt\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.mu.my\/ms\/#\/schema\/person\/d957efddd16e2298098bba24e7e8f6e4\",\"name\":\"Sam S\",\"url\":\"https:\/\/www.mu.my\/ms\/author\/muadmin\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Apakah itu PivotTable? - MU DOT MY PLT - ICT Training & Development Malaysia","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:\/\/www.mu.my\/ms\/berita\/apakah-itu-pivottable\/","og_locale":"ms_MY","og_type":"article","og_title":"Apakah itu PivotTable? - MU DOT MY PLT - ICT Training & Development Malaysia","og_description":"PivotTable&nbsp;merupakan salah satu ciri yang paling hebat di dalam Excel. Ia akan menjimatkan anda&nbsp; banyak masa untuk&nbsp;meringkaskan set data yang besar dan terperinci menjadi satu laporan yang sangat bermakna. Katakan anda mempunyai sebuah lembaran kerja yang mengandungi data jualan bulanan dan anda ingin tahu pelanggan dari kawasan yang mana mempunyai jumlah jualan tertinggi dalam bulan ... Read more","og_url":"https:\/\/www.mu.my\/ms\/berita\/apakah-itu-pivottable\/","og_site_name":"MU DOT MY PLT - ICT Training & Development Malaysia","article_publisher":"https:\/\/facebook.com\/mudotmy","article_published_time":"2017-06-09T05:16:42+00:00","article_modified_time":"2020-03-30T06:15:52+00:00","og_image":[{"url":"http:\/\/www.mu.my\/files\/uploads\/pivot-table-551x350-3.jpg","type":"","width":"","height":""}],"author":"Sam S","twitter_card":"summary_large_image","twitter_creator":"@mudotmy","twitter_site":"@mudotmy","twitter_misc":{"Written by":"Sam S","Est. reading time":"1 minit"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.mu.my\/ms\/berita\/apakah-itu-pivottable\/#article","isPartOf":{"@id":"https:\/\/www.mu.my\/ms\/berita\/apakah-itu-pivottable\/"},"author":{"name":"Sam S","@id":"https:\/\/www.mu.my\/ms\/#\/schema\/person\/d957efddd16e2298098bba24e7e8f6e4"},"headline":"Apakah itu PivotTable?","datePublished":"2017-06-09T05:16:42+00:00","dateModified":"2020-03-30T06:15:52+00:00","mainEntityOfPage":{"@id":"https:\/\/www.mu.my\/ms\/berita\/apakah-itu-pivottable\/"},"wordCount":216,"publisher":{"@id":"https:\/\/www.mu.my\/ms\/#organization"},"image":{"@id":"https:\/\/www.mu.my\/ms\/berita\/apakah-itu-pivottable\/#primaryimage"},"thumbnailUrl":"http:\/\/www.mu.my\/files\/uploads\/pivot-table-551x350-3.jpg","articleSection":["Berita"],"inLanguage":"ms-MY"},{"@type":"WebPage","@id":"https:\/\/www.mu.my\/ms\/berita\/apakah-itu-pivottable\/","url":"https:\/\/www.mu.my\/ms\/berita\/apakah-itu-pivottable\/","name":"Apakah itu PivotTable? - MU DOT MY PLT - ICT Training & Development Malaysia","isPartOf":{"@id":"https:\/\/www.mu.my\/ms\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.mu.my\/ms\/berita\/apakah-itu-pivottable\/#primaryimage"},"image":{"@id":"https:\/\/www.mu.my\/ms\/berita\/apakah-itu-pivottable\/#primaryimage"},"thumbnailUrl":"http:\/\/www.mu.my\/files\/uploads\/pivot-table-551x350-3.jpg","datePublished":"2017-06-09T05:16:42+00:00","dateModified":"2020-03-30T06:15:52+00:00","breadcrumb":{"@id":"https:\/\/www.mu.my\/ms\/berita\/apakah-itu-pivottable\/#breadcrumb"},"inLanguage":"ms-MY","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.mu.my\/ms\/berita\/apakah-itu-pivottable\/"]}]},{"@type":"ImageObject","inLanguage":"ms-MY","@id":"https:\/\/www.mu.my\/ms\/berita\/apakah-itu-pivottable\/#primaryimage","url":"http:\/\/www.mu.my\/files\/uploads\/pivot-table-551x350-3.jpg","contentUrl":"http:\/\/www.mu.my\/files\/uploads\/pivot-table-551x350-3.jpg"},{"@type":"BreadcrumbList","@id":"https:\/\/www.mu.my\/ms\/berita\/apakah-itu-pivottable\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.mu.my\/ms\/"},{"@type":"ListItem","position":2,"name":"Apakah itu PivotTable?"}]},{"@type":"WebSite","@id":"https:\/\/www.mu.my\/ms\/#website","url":"https:\/\/www.mu.my\/ms\/","name":"MU DOT MY PLT - ICT Training & Development Malaysia","description":"extracting knowledge","publisher":{"@id":"https:\/\/www.mu.my\/ms\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.mu.my\/ms\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"ms-MY"},{"@type":"Organization","@id":"https:\/\/www.mu.my\/ms\/#organization","name":"MU DOT MY PLT","url":"https:\/\/www.mu.my\/ms\/","logo":{"@type":"ImageObject","inLanguage":"ms-MY","@id":"https:\/\/www.mu.my\/ms\/#\/schema\/logo\/image\/","url":"http:\/\/www.mu.my\/files\/uploads\/MU-logo.png","contentUrl":"http:\/\/www.mu.my\/files\/uploads\/MU-logo.png","width":502,"height":476,"caption":"MU DOT MY PLT"},"image":{"@id":"https:\/\/www.mu.my\/ms\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/facebook.com\/mudotmy","https:\/\/x.com\/mudotmy","https:\/\/instagram.com\/mudotmyplt"]},{"@type":"Person","@id":"https:\/\/www.mu.my\/ms\/#\/schema\/person\/d957efddd16e2298098bba24e7e8f6e4","name":"Sam S","url":"https:\/\/www.mu.my\/ms\/author\/muadmin\/"}]}},"_links":{"self":[{"href":"https:\/\/www.mu.my\/ms\/wp-json\/wp\/v2\/posts\/13223","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.mu.my\/ms\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.mu.my\/ms\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.mu.my\/ms\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/www.mu.my\/ms\/wp-json\/wp\/v2\/comments?post=13223"}],"version-history":[{"count":7,"href":"https:\/\/www.mu.my\/ms\/wp-json\/wp\/v2\/posts\/13223\/revisions"}],"predecessor-version":[{"id":64119,"href":"https:\/\/www.mu.my\/ms\/wp-json\/wp\/v2\/posts\/13223\/revisions\/64119"}],"wp:attachment":[{"href":"https:\/\/www.mu.my\/ms\/wp-json\/wp\/v2\/media?parent=13223"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.mu.my\/ms\/wp-json\/wp\/v2\/categories?post=13223"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.mu.my\/ms\/wp-json\/wp\/v2\/tags?post=13223"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}