{"id":62446,"date":"2020-02-21T02:57:00","date_gmt":"2020-02-21T02:57:00","guid":{"rendered":"http:\/\/www.mu.my\/?p=62446"},"modified":"2020-03-17T03:47:20","modified_gmt":"2020-03-17T03:47:20","slug":"tip-advanced-menggunakan-microsoft-excel","status":"publish","type":"post","link":"https:\/\/www.mu.my\/ms\/tutorial\/tip-advanced-menggunakan-microsoft-excel\/","title":{"rendered":"Tip Advanced Menggunakan Microsoft Excel"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-post\" data-elementor-id=\"62446\" class=\"elementor elementor-62446 elementor-58260\" data-elementor-post-type=\"post\">\n\t\t\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-98b3917 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"98b3917\" 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-66659d1\" data-id=\"66659d1\" 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-ac62490 elementor-widget elementor-widget-heading\" data-id=\"ac62490\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">Kenapa anda perlu menggunakan tip-tip ini?\n<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-94943ed elementor-widget elementor-widget-text-editor\" data-id=\"94943ed\" 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>Kebanyakan dari kalangan kita mesti mahir menggunakan Microsoft Excel. Paling kurang pun mesti ramai yang tahu fungsi dan formula asas dalam Microsoft Excel, kan. Tapi, apa anda rasa kalau saya bagi tahu yang banyak lagi tips yang boleh digunakan dalam perisian ini, yang mungkin kita tak pernah tahu pun boleh digunakan, mungkin tak pernah dengar pun fungsi ni wujud. Jangan risau. Di sini, saya akan memberikan beberapa tips yang sangat berguna apabila menggunakan Microsoft Excel.<\/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<section class=\"elementor-section elementor-top-section elementor-element elementor-element-226f5ed elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"226f5ed\" 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-3cac824\" data-id=\"3cac824\" 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-d403e20 elementor-widget elementor-widget-spacer\" data-id=\"d403e20\" data-element_type=\"widget\" data-widget_type=\"spacer.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"elementor-spacer\">\n\t\t\t<div class=\"elementor-spacer-inner\"><\/div>\n\t\t<\/div>\n\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<section class=\"elementor-section elementor-top-section elementor-element elementor-element-d1269d3 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"d1269d3\" 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-62cfba3\" data-id=\"62cfba3\" 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-e3df94f elementor-widget elementor-widget-heading\" data-id=\"e3df94f\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">1. Beralih ke cell terakhir dalam baris atau lajur sekelip mata\n<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-802b146 elementor-widget elementor-widget-text-editor\" data-id=\"802b146\" 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>Jika anda berada di data paling awal, dan anda ingin beralih ke data terakhir dalam sekelip mata, tekan data pertama, kemudian tekan 2 kali pada garisan \/border bahagian bawah cell itu untuk beralih ke data terakhir dalam baris, atau tekan garisan \/border pada sebelah kanan untuk beralih ke data terakhir dalam lajur itu.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-798b2e3 elementor-widget elementor-widget-image\" data-id=\"798b2e3\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t<figure class=\"wp-caption\">\n\t\t\t\t\t\t\t\t\t\t<img fetchpriority=\"high\" decoding=\"async\" width=\"600\" height=\"442\" src=\"https:\/\/www.mu.my\/files\/uploads\/ezgif.com-video-to-gif.gif\" class=\"attachment-medium_large size-medium_large wp-image-58286\" alt=\"\" \/>\t\t\t\t\t\t\t\t\t\t\t<figcaption class=\"widget-image-caption wp-caption-text\">Beralih ke cell terakhir dalam baris<\/figcaption>\n\t\t\t\t\t\t\t\t\t\t<\/figure>\n\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-af0b450 elementor-widget elementor-widget-spacer\" data-id=\"af0b450\" data-element_type=\"widget\" data-widget_type=\"spacer.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"elementor-spacer\">\n\t\t\t<div class=\"elementor-spacer-inner\"><\/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-7b4e12a elementor-widget elementor-widget-image\" data-id=\"7b4e12a\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t<figure class=\"wp-caption\">\n\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" width=\"600\" height=\"211\" src=\"https:\/\/www.mu.my\/files\/uploads\/ezgif.com-video-to-gif-1.gif\" class=\"attachment-medium_large size-medium_large wp-image-58284\" alt=\"\" \/>\t\t\t\t\t\t\t\t\t\t\t<figcaption class=\"widget-image-caption wp-caption-text\">Beralih ke cell terakhir dalam lajur<\/figcaption>\n\t\t\t\t\t\t\t\t\t\t<\/figure>\n\t\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<section class=\"elementor-section elementor-top-section elementor-element elementor-element-be8cc32 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"be8cc32\" 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-2dea967\" data-id=\"2dea967\" 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-9d513a4 elementor-widget elementor-widget-text-editor\" data-id=\"9d513a4\" 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><strong>Tip Bonus:<\/strong><\/p><p>Anda boleh menekan 2 kali pada arah berlawanan untuk beralih ke cell terawal.<\/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<section class=\"elementor-section elementor-top-section elementor-element elementor-element-e63c5d2 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"e63c5d2\" 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-9a5fe53\" data-id=\"9a5fe53\" 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-fc21bf0 elementor-widget elementor-widget-spacer\" data-id=\"fc21bf0\" data-element_type=\"widget\" data-widget_type=\"spacer.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"elementor-spacer\">\n\t\t\t<div class=\"elementor-spacer-inner\"><\/div>\n\t\t<\/div>\n\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<section class=\"elementor-section elementor-top-section elementor-element elementor-element-fd13ec9 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"fd13ec9\" 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-bb343c9\" data-id=\"bb343c9\" 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-254398c elementor-widget elementor-widget-heading\" data-id=\"254398c\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">2. Membuang penduaan data\/ data yang sama\n<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-da11928 elementor-widget elementor-widget-text-editor\" data-id=\"da11928\" 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>Anda boleh membuang pendua\/ data yang sama dengan mengikuti langkah-langkah tersebut.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-05afa1f elementor-widget elementor-widget-image\" data-id=\"05afa1f\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" width=\"1024\" height=\"620\" src=\"https:\/\/www.mu.my\/files\/uploads\/Screenshot_1-1024x620.png\" class=\"attachment-large size-large wp-image-58452\" alt=\"\" srcset=\"https:\/\/www.mu.my\/files\/uploads\/Screenshot_1-1024x620.png 1024w, https:\/\/www.mu.my\/files\/uploads\/Screenshot_1-300x182.png 300w, https:\/\/www.mu.my\/files\/uploads\/Screenshot_1-768x465.png 768w, https:\/\/www.mu.my\/files\/uploads\/Screenshot_1-830x502.png 830w, https:\/\/www.mu.my\/files\/uploads\/Screenshot_1.png 1112w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-f2ac51b elementor-widget elementor-widget-text-editor\" data-id=\"f2ac51b\" 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<ul><li>Pertama sekali, pilih cell dan data yang anda ingin membuang penduaan.<\/li><\/ul>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-0a9a959 elementor-widget elementor-widget-image\" data-id=\"0a9a959\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"655\" height=\"131\" src=\"https:\/\/www.mu.my\/files\/uploads\/Screenshot_2.png\" class=\"attachment-large size-large wp-image-58454\" alt=\"\" srcset=\"https:\/\/www.mu.my\/files\/uploads\/Screenshot_2.png 655w, https:\/\/www.mu.my\/files\/uploads\/Screenshot_2-300x60.png 300w\" sizes=\"(max-width: 655px) 100vw, 655px\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-ffd7fae elementor-widget elementor-widget-text-editor\" data-id=\"ffd7fae\" 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<ul><li>Kemudian, pergi ke ribbon- terletak di ruang atas perisian, cari <strong>Data\u2192Remove Duplicates.<\/strong><\/li><\/ul>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-0867eb2 elementor-widget elementor-widget-image\" data-id=\"0867eb2\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"468\" height=\"302\" src=\"https:\/\/www.mu.my\/files\/uploads\/Screenshot_3.png\" class=\"attachment-woocommerce_single size-woocommerce_single wp-image-58456\" alt=\"\" srcset=\"https:\/\/www.mu.my\/files\/uploads\/Screenshot_3.png 468w, https:\/\/www.mu.my\/files\/uploads\/Screenshot_3-300x194.png 300w\" sizes=\"(max-width: 468px) 100vw, 468px\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-e19eed8 elementor-widget elementor-widget-text-editor\" data-id=\"e19eed8\" 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<ul><li style=\"font-weight: 400;\">Pilih header untuk ruang data yang anda ingin membuang penduaan data.<\/li><\/ul>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-d1be7fa elementor-widget elementor-widget-image\" data-id=\"d1be7fa\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"372\" src=\"https:\/\/www.mu.my\/files\/uploads\/Screenshot_4-1024x372.png\" class=\"attachment-large size-large wp-image-58458\" alt=\"\" srcset=\"https:\/\/www.mu.my\/files\/uploads\/Screenshot_4-1024x372.png 1024w, https:\/\/www.mu.my\/files\/uploads\/Screenshot_4-300x109.png 300w, https:\/\/www.mu.my\/files\/uploads\/Screenshot_4-768x279.png 768w, https:\/\/www.mu.my\/files\/uploads\/Screenshot_4-830x301.png 830w, https:\/\/www.mu.my\/files\/uploads\/Screenshot_4.png 1126w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-f487c5d elementor-widget elementor-widget-text-editor\" data-id=\"f487c5d\" 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<ul><li>Satu mesej akan keluar jika pembuangan berjaya, dan anda sudah siap membuang data yang sama yang sedia ada.<\/li><\/ul>\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<section class=\"elementor-section elementor-top-section elementor-element elementor-element-223a66f elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"223a66f\" 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-5755232\" data-id=\"5755232\" 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-12a0b0c elementor-widget elementor-widget-spacer\" data-id=\"12a0b0c\" data-element_type=\"widget\" data-widget_type=\"spacer.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"elementor-spacer\">\n\t\t\t<div class=\"elementor-spacer-inner\"><\/div>\n\t\t<\/div>\n\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<section class=\"elementor-section elementor-top-section elementor-element elementor-element-cb8125c elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"cb8125c\" 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-ad02692\" data-id=\"ad02692\" 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-330a82a elementor-widget elementor-widget-heading\" data-id=\"330a82a\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">3. Memilih cell dalam jumlah yang banyak dan isi data yang sama\n<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-da3fa28 elementor-widget elementor-widget-text-editor\" data-id=\"da3fa28\" 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>Jika anda ingin mengisi cell-cell kosong dengan data yang sama, ikut langkah di bawah.<\/p><ul><li>Mula-mula, tekan butang <strong>Ctrl<\/strong> dan pilih cell yang anda ingin masukkan data.<\/li><\/ul>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-faf9b82 elementor-widget elementor-widget-image\" data-id=\"faf9b82\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"300\" height=\"252\" src=\"https:\/\/www.mu.my\/files\/uploads\/ezgif.com-video-to-gif-3-1.gif\" class=\"attachment-large size-large wp-image-59151\" alt=\"\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-0db8615 elementor-widget elementor-widget-text-editor\" data-id=\"0db8615\" 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<ul><li>Kemudian, isikan data anda dan tekan <strong>Ctrl+Enter.<\/strong><\/li><\/ul>\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<section class=\"elementor-section elementor-top-section elementor-element elementor-element-c2d0f30 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"c2d0f30\" 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-f8ef4a5\" data-id=\"f8ef4a5\" 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-b640b11 elementor-widget elementor-widget-spacer\" data-id=\"b640b11\" data-element_type=\"widget\" data-widget_type=\"spacer.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"elementor-spacer\">\n\t\t\t<div class=\"elementor-spacer-inner\"><\/div>\n\t\t<\/div>\n\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<section class=\"elementor-section elementor-top-section elementor-element elementor-element-7ab9ce0 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"7ab9ce0\" 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-68f002f\" data-id=\"68f002f\" 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-541fb28 elementor-widget elementor-widget-heading\" data-id=\"541fb28\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">4. Autofill cell anda mengikut corak data yang telah ada\n<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-2c81722 elementor-widget elementor-widget-text-editor\" data-id=\"2c81722\" 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>Jika anda ingin mengisi cell anda dengan data yang berterusan, seperti masa, tarikh dan bulan, ikuti langkah-langkah yang ditunjukkan untuk memudahkan kerja anda.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-962703d elementor-widget elementor-widget-image\" data-id=\"962703d\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"539\" height=\"190\" src=\"https:\/\/www.mu.my\/files\/uploads\/autofill-1.png\" class=\"attachment-large size-large wp-image-60610\" alt=\"\" srcset=\"https:\/\/www.mu.my\/files\/uploads\/autofill-1.png 539w, https:\/\/www.mu.my\/files\/uploads\/autofill-1-300x106.png 300w\" sizes=\"(max-width: 539px) 100vw, 539px\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-24bfcd3 elementor-widget elementor-widget-text-editor\" data-id=\"24bfcd3\" 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<ul><li style=\"font-weight: 400;\">Pertama sekali, isi cell pertama dengan jenis data yang anda inginkan, contohnya tarikh, dan pilih cell itu.<\/li><\/ul>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-76e5598 elementor-widget elementor-widget-image\" data-id=\"76e5598\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"496\" height=\"167\" src=\"https:\/\/www.mu.my\/files\/uploads\/autofill-2.png\" class=\"attachment-large size-large wp-image-60614\" alt=\"\" srcset=\"https:\/\/www.mu.my\/files\/uploads\/autofill-2.png 496w, https:\/\/www.mu.my\/files\/uploads\/autofill-2-300x101.png 300w\" sizes=\"(max-width: 496px) 100vw, 496px\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-40d5582 elementor-widget elementor-widget-text-editor\" data-id=\"40d5582\" 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<ul><li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Kemudian, alih dan tekan fill handle<img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-60442 size-full\" src=\"http:\/\/www.mu.my\/files\/uploads\/fillhandle2-e1583478721221.png\" alt=\"\" width=\"51\" height=\"24\" \/>\u00a0&#8211; terletak di bucu kanan bahagian bawah cell, dan tarik samada ke tepi untuk mengisi lajur, atau ke bawah untuk mengisi baris, dan tarik sehingga ke cell terakhir data anda.<\/span><\/li><\/ul>\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<section class=\"elementor-section elementor-top-section elementor-element elementor-element-4e30320 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"4e30320\" 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-ad470ea\" data-id=\"ad470ea\" 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-35807da elementor-widget elementor-widget-spacer\" data-id=\"35807da\" data-element_type=\"widget\" data-widget_type=\"spacer.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"elementor-spacer\">\n\t\t\t<div class=\"elementor-spacer-inner\"><\/div>\n\t\t<\/div>\n\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<section class=\"elementor-section elementor-top-section elementor-element elementor-element-9bf2735 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"9bf2735\" 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-dc55360\" data-id=\"dc55360\" 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-dad2b53 elementor-widget elementor-widget-heading\" data-id=\"dad2b53\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">5.Transpose data di antara bentuk baris atau lajur\n<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-fdeb65f elementor-widget elementor-widget-text-editor\" data-id=\"fdeb65f\" 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>Transpose memudahkan anda memanipulasi data dari bentuk lajur kepada baris dan sebaliknya.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-24e7420 elementor-widget elementor-widget-image\" data-id=\"24e7420\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"267\" height=\"272\" src=\"https:\/\/www.mu.my\/files\/uploads\/transpose-1.2.png\" class=\"attachment-large size-large wp-image-60640\" alt=\"\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-e684187 elementor-widget elementor-widget-text-editor\" data-id=\"e684187\" 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<ul><li style=\"font-weight: 400;\">Pertama sekali, anda perlu pilih dan copy data yang anda ingin <strong>Transpose<\/strong>.<\/li><\/ul>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-db47f63 elementor-widget elementor-widget-image\" data-id=\"db47f63\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"217\" height=\"313\" src=\"https:\/\/www.mu.my\/files\/uploads\/transpose-2.png\" class=\"attachment-large size-large wp-image-60629\" alt=\"\" srcset=\"https:\/\/www.mu.my\/files\/uploads\/transpose-2.png 217w, https:\/\/www.mu.my\/files\/uploads\/transpose-2-208x300.png 208w\" sizes=\"(max-width: 217px) 100vw, 217px\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-7c16f68 elementor-widget elementor-widget-text-editor\" data-id=\"7c16f68\" 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<ul><li style=\"font-weight: 400;\">Kemudian, pilih mana-mana cell kosong yang anda ingin data itu dipaparkan, pergi ke ribbon\u00a0<strong>Home<\/strong>, dan pilih anak panah bawah pilihan\u00a0<strong>Paste<\/strong>.<\/li><\/ul>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-8e5f56e elementor-widget elementor-widget-image\" data-id=\"8e5f56e\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"196\" height=\"83\" src=\"https:\/\/www.mu.my\/files\/uploads\/transpose-3.png\" class=\"attachment-large size-large wp-image-60627\" alt=\"\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-6981c64 elementor-widget elementor-widget-text-editor\" data-id=\"6981c64\" 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>Beberapa pilihan akan diberikan. Gerakkan cursor anda ke bawah sekali dan tekan\u00a0<strong>Paste<\/strong> <strong>Special<\/strong>.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-aa5b88f elementor-widget elementor-widget-image\" data-id=\"aa5b88f\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"437\" height=\"353\" src=\"https:\/\/www.mu.my\/files\/uploads\/transpose-4.png\" class=\"attachment-large size-large wp-image-60625\" alt=\"\" srcset=\"https:\/\/www.mu.my\/files\/uploads\/transpose-4.png 437w, https:\/\/www.mu.my\/files\/uploads\/transpose-4-300x242.png 300w\" sizes=\"(max-width: 437px) 100vw, 437px\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-e46a9aa elementor-widget elementor-widget-text-editor\" data-id=\"e46a9aa\" 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<ul><li>Selepas itu, ada pop up yang akan keluar. Pilih <strong>Transpose<\/strong> dan tekan <strong>OK<\/strong>.<\/li><\/ul>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-a1d2dfb elementor-widget elementor-widget-image\" data-id=\"a1d2dfb\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"752\" height=\"77\" src=\"https:\/\/www.mu.my\/files\/uploads\/transpose-1.2.2.png\" class=\"attachment-large size-large wp-image-60638\" alt=\"\" srcset=\"https:\/\/www.mu.my\/files\/uploads\/transpose-1.2.2.png 752w, https:\/\/www.mu.my\/files\/uploads\/transpose-1.2.2-300x31.png 300w\" sizes=\"(max-width: 752px) 100vw, 752px\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-f9197a2 elementor-widget elementor-widget-text-editor\" data-id=\"f9197a2\" 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>Selepas anda tekan\u00a0<strong>OK<\/strong>, data anda akan dipaparkan dalam bentuk berlawanan dengan sebelumnya.<\/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<section class=\"elementor-section elementor-top-section elementor-element elementor-element-5e69ab8 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"5e69ab8\" 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-70fd023\" data-id=\"70fd023\" 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-510ed0f elementor-widget elementor-widget-spacer\" data-id=\"510ed0f\" data-element_type=\"widget\" data-widget_type=\"spacer.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"elementor-spacer\">\n\t\t\t<div class=\"elementor-spacer-inner\"><\/div>\n\t\t<\/div>\n\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<section class=\"elementor-section elementor-top-section elementor-element elementor-element-2838071 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"2838071\" 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-e601296\" data-id=\"e601296\" 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-b249941 elementor-widget elementor-widget-heading\" data-id=\"b249941\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">6. Muatkan ayat dalam cell menggunakan Wrap<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-710cd93 elementor-widget elementor-widget-text-editor\" data-id=\"710cd93\" 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>Wrap memudahkan anda memuatkan ayat yang panjang ke dalam satu cell tanpa anda perlu mengubah cell itu. Untuk melakukan Warp, tekan data anda, kemudian tekan butang <strong>Alt + Enter<\/strong> atau pergi ke <strong>Home\u2192Wrap Text<\/strong> dan tekan butang <strong>Wrap Text.<\/strong><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-8c526e9 elementor-widget elementor-widget-image\" data-id=\"8c526e9\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"409\" height=\"300\" src=\"https:\/\/www.mu.my\/files\/uploads\/ezgif.com-video-to-gif-4-1.gif\" class=\"attachment-2048x2048 size-2048x2048 wp-image-59149\" alt=\"\" \/>\t\t\t\t\t\t\t\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<section class=\"elementor-section elementor-top-section elementor-element elementor-element-5840def elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"5840def\" 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-72d6ccf\" data-id=\"72d6ccf\" 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-7ef7d0a elementor-widget elementor-widget-spacer\" data-id=\"7ef7d0a\" data-element_type=\"widget\" data-widget_type=\"spacer.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"elementor-spacer\">\n\t\t\t<div class=\"elementor-spacer-inner\"><\/div>\n\t\t<\/div>\n\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<section class=\"elementor-section elementor-top-section elementor-element elementor-element-a58bc77 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"a58bc77\" 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-5509766\" data-id=\"5509766\" 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-0cd949f elementor-widget elementor-widget-heading\" data-id=\"0cd949f\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">7. Flash fill\n<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-6549cc7 elementor-widget elementor-widget-text-editor\" data-id=\"6549cc7\" 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>Flash fill ialah salah satu kaedah berkesan untuk mengurus data yang banyak mengikut nilai baris di sebelahnya.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-cbb8834 elementor-widget elementor-widget-image\" data-id=\"cbb8834\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"449\" height=\"426\" src=\"https:\/\/www.mu.my\/files\/uploads\/flashfill1.png\" class=\"attachment-large size-large wp-image-60655\" alt=\"\" srcset=\"https:\/\/www.mu.my\/files\/uploads\/flashfill1.png 449w, https:\/\/www.mu.my\/files\/uploads\/flashfill1-300x285.png 300w\" sizes=\"(max-width: 449px) 100vw, 449px\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-c86ef8c elementor-widget elementor-widget-text-editor\" data-id=\"c86ef8c\" 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<ul><li style=\"font-weight: 400;\">Mula-mula, isi cell pertama dengan data yang bersesuaian.<\/li><\/ul>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-f97763f elementor-widget elementor-widget-image\" data-id=\"f97763f\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"432\" height=\"434\" src=\"https:\/\/www.mu.my\/files\/uploads\/flashfill2.png\" class=\"attachment-large size-large wp-image-60659\" alt=\"\" srcset=\"https:\/\/www.mu.my\/files\/uploads\/flashfill2.png 432w, https:\/\/www.mu.my\/files\/uploads\/flashfill2-300x300.png 300w, https:\/\/www.mu.my\/files\/uploads\/flashfill2-150x150.png 150w, https:\/\/www.mu.my\/files\/uploads\/flashfill2-100x100.png 100w\" sizes=\"(max-width: 432px) 100vw, 432px\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-189a345 elementor-widget elementor-widget-text-editor\" data-id=\"189a345\" 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<ul><li>Kemudian, pergi ke cell seterusnya dan tekan <strong>Ctrl + E.<\/strong><\/li><\/ul>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-31a9dc6 elementor-widget elementor-widget-image\" data-id=\"31a9dc6\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"448\" height=\"423\" src=\"https:\/\/www.mu.my\/files\/uploads\/flashfill3.png\" class=\"attachment-large size-large wp-image-60657\" alt=\"\" srcset=\"https:\/\/www.mu.my\/files\/uploads\/flashfill3.png 448w, https:\/\/www.mu.my\/files\/uploads\/flashfill3-300x283.png 300w\" sizes=\"(max-width: 448px) 100vw, 448px\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-d1dece5 elementor-widget elementor-widget-text-editor\" data-id=\"d1dece5\" 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<ul><li>Setelah anda tekan\u00a0<strong>Ctrl+E,<\/strong> Microsoft Excel akan mengisi cell kosong secara automatik dengan data yang sesuai mengikut data dari cell sebelumnya. Contohnya, dalam gambar ini, data yang diisi adalah bulan berdasarkan tarikh yang telah diberikan.<\/li><\/ul>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-197d572 elementor-widget elementor-widget-text-editor\" data-id=\"197d572\" 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><strong>Nota Penting!<\/strong><\/p><p>Flash Fill hanya boleh digunakan pada data dalam baris.<\/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<section class=\"elementor-section elementor-top-section elementor-element elementor-element-ee39a5c elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"ee39a5c\" 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-6f10edf\" data-id=\"6f10edf\" 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-30b5576 elementor-widget elementor-widget-spacer\" data-id=\"30b5576\" data-element_type=\"widget\" data-widget_type=\"spacer.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"elementor-spacer\">\n\t\t\t<div class=\"elementor-spacer-inner\"><\/div>\n\t\t<\/div>\n\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<section class=\"elementor-section elementor-top-section elementor-element elementor-element-efdcda1 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"efdcda1\" 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-0fffb1f\" data-id=\"0fffb1f\" 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-5aed8b7 elementor-widget elementor-widget-heading\" data-id=\"5aed8b7\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">8. Clipboard\n<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-d24fd30 elementor-widget elementor-widget-text-editor\" data-id=\"d24fd30\" 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>Untuk mengakses clipboard di dalam Excel, pergi ke ruang Home di bahagian atas perisian, cari clipboard, dan tekan butang di sebelahnya . Clipboard akan muncul di sebelah kiri spreadsheet anda.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-aff3324 elementor-widget elementor-widget-image\" data-id=\"aff3324\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"478\" height=\"627\" src=\"https:\/\/www.mu.my\/files\/uploads\/22-1.png\" class=\"attachment-large size-large wp-image-60468\" alt=\"\" srcset=\"https:\/\/www.mu.my\/files\/uploads\/22-1.png 478w, https:\/\/www.mu.my\/files\/uploads\/22-1-229x300.png 229w\" sizes=\"(max-width: 478px) 100vw, 478px\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-e470771 elementor-widget elementor-widget-text-editor\" data-id=\"e470771\" 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><strong>Apa kegunaan Clipboard?<\/strong><\/p><p>Apabila anda copy data dalam Microsoft Excel, data atau nilai yang anda copy akan disimpan di dalam clipboard, memudahkan anda untuk copy data itu berulang kali tanpa perlu pergi ke cell yang ada data itu. Clipboard juga membolehkan anda untuk copy lebih daripada satu data. Bila anda ingin copy data anda, copy sahaja dari clipboard.<\/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<section class=\"elementor-section elementor-top-section elementor-element elementor-element-48efe02 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"48efe02\" 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-c419417\" data-id=\"c419417\" 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-2ac8374 elementor-widget elementor-widget-spacer\" data-id=\"2ac8374\" data-element_type=\"widget\" data-widget_type=\"spacer.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"elementor-spacer\">\n\t\t\t<div class=\"elementor-spacer-inner\"><\/div>\n\t\t<\/div>\n\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<section class=\"elementor-section elementor-top-section elementor-element elementor-element-8d3fe4f elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"8d3fe4f\" 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-7ec7518\" data-id=\"7ec7518\" 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-096551f elementor-widget elementor-widget-heading\" data-id=\"096551f\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">9. Menukar nombor kepada nilai matawang\n<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-ba41659 elementor-widget elementor-widget-text-editor\" data-id=\"ba41659\" 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: 400;\">Ingin tukar nombor yang anda ada kepada nilai matawang? Pergi ke ruang Number di bawah Home dan tekan butang .<br \/><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-60671\" src=\"http:\/\/www.mu.my\/files\/uploads\/currency.png\" alt=\"\" width=\"43\" height=\"26\" \/> .<\/span><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-e47f76a elementor-widget elementor-widget-image\" data-id=\"e47f76a\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"660\" height=\"300\" src=\"https:\/\/www.mu.my\/files\/uploads\/ezgif.com-video-to-gif-5-2.gif\" class=\"attachment-large size-large wp-image-60472\" alt=\"\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-561acc9 elementor-widget elementor-widget-text-editor\" data-id=\"561acc9\" 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><strong>Tips Bonus:<\/strong><\/p><p>Kaedah ini boleh digunakan untuk hampir semua nilai wang yang ada.<\/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<section class=\"elementor-section elementor-top-section elementor-element elementor-element-c547885 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"c547885\" 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-08541bc\" data-id=\"08541bc\" 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-872ee89 elementor-widget elementor-widget-spacer\" data-id=\"872ee89\" data-element_type=\"widget\" data-widget_type=\"spacer.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"elementor-spacer\">\n\t\t\t<div class=\"elementor-spacer-inner\"><\/div>\n\t\t<\/div>\n\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<section class=\"elementor-section elementor-top-section elementor-element elementor-element-e17726b elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"e17726b\" 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-c6bcc16\" data-id=\"c6bcc16\" 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-cb0895d elementor-widget elementor-widget-heading\" data-id=\"cb0895d\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">10. Menyusun data\n<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-a8a5014 elementor-widget elementor-widget-text-editor\" data-id=\"a8a5014\" 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>Sort tool membenarkan anda menyusun data mentah atau raw data anda kepada susunan menaik atau menurun.\u00a0<\/p><ul><li>Mula-mula, pilih data yang anda ingin susun.<\/li><\/ul>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-4db8ac5 elementor-widget elementor-widget-image\" data-id=\"4db8ac5\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"449\" height=\"300\" src=\"https:\/\/www.mu.my\/files\/uploads\/ezgif.com-video-to-gif-6-2.gif\" class=\"attachment-large size-large wp-image-60480\" alt=\"\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-8612f2c elementor-widget elementor-widget-text-editor\" data-id=\"8612f2c\" 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<ul><li>Pergi ke ribbon <strong>Data<\/strong>, ruang <strong>Sort &amp; Filter<\/strong>, dan tekan butang <img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-60482\" src=\"http:\/\/www.mu.my\/files\/uploads\/a-2.png\" alt=\"\" width=\"30\" height=\"33\" \/> untuk turutan menaik.<\/li><\/ul>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-ba445ae elementor-widget elementor-widget-image\" data-id=\"ba445ae\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"455\" height=\"300\" src=\"https:\/\/www.mu.my\/files\/uploads\/ezgif.com-video-to-gif-7-2.gif\" class=\"attachment-large size-large wp-image-60478\" alt=\"\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-e30fb9b elementor-widget elementor-widget-text-editor\" data-id=\"e30fb9b\" 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<ul><li>Untuk turutan menurun pula, tekan butang <img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-60484\" src=\"http:\/\/www.mu.my\/files\/uploads\/b-2.png\" alt=\"\" width=\"28\" height=\"32\" \/> dan data anda akan disusun dalam susunan menurun.<\/li><\/ul>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-89218cb elementor-widget elementor-widget-text-editor\" data-id=\"89218cb\" 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><strong>Hati-hati!<\/strong><\/p><p>Apabila menggunakan sort untuk susun data, ada kalanya data di baris sebelahnya akan berubah sekali. Satu checkbox, seperti di atas akan keluar jika data yang anda pilih bersambung dengan data lain.<\/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<section class=\"elementor-section elementor-top-section elementor-element elementor-element-0a8e856 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"0a8e856\" 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-340d53b\" data-id=\"340d53b\" 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-af47172 elementor-widget elementor-widget-spacer\" data-id=\"af47172\" data-element_type=\"widget\" data-widget_type=\"spacer.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"elementor-spacer\">\n\t\t\t<div class=\"elementor-spacer-inner\"><\/div>\n\t\t<\/div>\n\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<section class=\"elementor-section elementor-top-section elementor-element elementor-element-fb12375 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"fb12375\" 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-e3a5a46\" data-id=\"e3a5a46\" 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-9b222b0 elementor-widget elementor-widget-heading\" data-id=\"9b222b0\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">11. Gantikan pelbagai data yang sama sekaligus\n<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-55f58e5 elementor-widget elementor-widget-text-editor\" data-id=\"55f58e5\" 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>Apabila mengurus data yang banyak dan sering berubah, seperti data beberapa umur individu, mesti bosan apabila perlu menukar data itu, satu per satu. Jika anda ingin kaedah yang mudah. anda tak akan menyesal datang ke sini. Ianya sangat mudah untuk tukar data yang banyak sekaligus sebenarnya.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-d74b723 elementor-widget elementor-widget-image\" data-id=\"d74b723\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"355\" height=\"433\" src=\"https:\/\/www.mu.my\/files\/uploads\/Screenshot_3-2-1.png\" class=\"attachment-large size-large wp-image-60553\" alt=\"\" srcset=\"https:\/\/www.mu.my\/files\/uploads\/Screenshot_3-2-1.png 355w, https:\/\/www.mu.my\/files\/uploads\/Screenshot_3-2-1-246x300.png 246w\" sizes=\"(max-width: 355px) 100vw, 355px\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-e283737 elementor-widget elementor-widget-text-editor\" data-id=\"e283737\" 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<ul><li>Pergi ke <strong>Home Tab \u279c Editing \u279c Find &amp; Replace \u279c Replace.<\/strong><\/li><\/ul>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-3b4f534 elementor-widget elementor-widget-image\" data-id=\"3b4f534\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"554\" height=\"289\" src=\"https:\/\/www.mu.my\/files\/uploads\/Screenshot_4-2.png\" class=\"attachment-large size-large wp-image-60551\" alt=\"\" srcset=\"https:\/\/www.mu.my\/files\/uploads\/Screenshot_4-2.png 554w, https:\/\/www.mu.my\/files\/uploads\/Screenshot_4-2-300x156.png 300w\" sizes=\"(max-width: 554px) 100vw, 554px\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-1ce5d38 elementor-widget elementor-widget-text-editor\" data-id=\"1ce5d38\" 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<ul><li><span style=\"font-weight: 400;\">A window will pop up. Input the words you want to replace on the first box, and on the next box, type the words that replacing it, then press <img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-60512\" src=\"http:\/\/www.mu.my\/files\/uploads\/Screenshot_5-1.png\" alt=\"\" width=\"82\" height=\"25\" \/>\u00a0<\/span><span style=\"font-weight: 400;\"> to replace all the value in the spreadsheet or <img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-60510\" src=\"http:\/\/www.mu.my\/files\/uploads\/Screenshot_6-1.png\" alt=\"\" width=\"80\" height=\"22\" \/> <\/span><span style=\"font-weight: 400;\">to replace only one value.<\/span><\/li><\/ul>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-9b526f0 elementor-widget elementor-widget-text-editor\" data-id=\"9b526f0\" 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><strong>Bonus Tips!<\/strong><\/p><p><span style=\"font-weight: 400;\">You can use the <img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-60508\" src=\"http:\/\/www.mu.my\/files\/uploads\/Screenshot_7-1.png\" alt=\"\" width=\"81\" height=\"24\" \/> button\u00a0<\/span><span style=\"font-weight: 400;\"> to find all the value mentioned written to be replaced. You can also use the<img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-60506\" src=\"http:\/\/www.mu.my\/files\/uploads\/Screenshot_8-1.png\" alt=\"\" width=\"80\" height=\"24\" \/> <\/span><span style=\"font-weight: 400;\"> button to find the value by order, from the first to the last.<\/span><\/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<section class=\"elementor-section elementor-top-section elementor-element elementor-element-8025283 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"8025283\" 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-ad49130\" data-id=\"ad49130\" 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-67687e9 elementor-widget elementor-widget-spacer\" data-id=\"67687e9\" data-element_type=\"widget\" data-widget_type=\"spacer.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"elementor-spacer\">\n\t\t\t<div class=\"elementor-spacer-inner\"><\/div>\n\t\t<\/div>\n\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<section class=\"elementor-section elementor-top-section elementor-element elementor-element-4ab1eed elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"4ab1eed\" 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-41b4229\" data-id=\"41b4229\" 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-701c42f elementor-widget elementor-widget-heading\" data-id=\"701c42f\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">12. Membuang semua cell yang terdapat kesilapan\n<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-945f534 elementor-widget elementor-widget-text-editor\" data-id=\"945f534\" 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>Membuang banyak cell yang terdapat kesilapan boleh dilakukan dengan mengikut langkah di bawah.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-0d7761b elementor-widget elementor-widget-image\" data-id=\"0d7761b\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"351\" height=\"423\" src=\"https:\/\/www.mu.my\/files\/uploads\/Screenshot_1-2-1.png\" class=\"attachment-large size-large wp-image-60557\" alt=\"\" srcset=\"https:\/\/www.mu.my\/files\/uploads\/Screenshot_1-2-1.png 351w, https:\/\/www.mu.my\/files\/uploads\/Screenshot_1-2-1-249x300.png 249w\" sizes=\"(max-width: 351px) 100vw, 351px\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-6265c0b elementor-widget elementor-widget-text-editor\" data-id=\"6265c0b\" 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<ul><li style=\"font-weight: 400;\">Pergi ke <strong>Home Tab \u279c Editing \u279c Find &amp; Replace \u279c Go To Special.<\/strong><\/li><\/ul>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-63a58a3 elementor-widget elementor-widget-image\" data-id=\"63a58a3\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"375\" height=\"366\" src=\"https:\/\/www.mu.my\/files\/uploads\/Screenshot_2-2-1.png\" class=\"attachment-large size-large wp-image-60555\" alt=\"\" srcset=\"https:\/\/www.mu.my\/files\/uploads\/Screenshot_2-2-1.png 375w, https:\/\/www.mu.my\/files\/uploads\/Screenshot_2-2-1-300x293.png 300w\" sizes=\"(max-width: 375px) 100vw, 375px\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-d8debbb elementor-widget elementor-widget-text-editor\" data-id=\"d8debbb\" 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<ul><li style=\"font-weight: 400;\">Pilih <strong>Formula \u279c Errors<\/strong> dan tekan ok.<\/li><\/ul>\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<section class=\"elementor-section elementor-top-section elementor-element elementor-element-3182a0f elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"3182a0f\" 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-92f03b5\" data-id=\"92f03b5\" 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-60f2078 elementor-widget elementor-widget-spacer\" data-id=\"60f2078\" data-element_type=\"widget\" data-widget_type=\"spacer.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"elementor-spacer\">\n\t\t\t<div class=\"elementor-spacer-inner\"><\/div>\n\t\t<\/div>\n\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<section class=\"elementor-section elementor-top-section elementor-element elementor-element-c5c65c6 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"c5c65c6\" 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-b7c8862\" data-id=\"b7c8862\" 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-dbb37d5 elementor-widget elementor-widget-heading\" data-id=\"dbb37d5\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">13. Guna Macro untuk memformat data secara automatik.\n<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-1c462ce elementor-widget elementor-widget-text-editor\" data-id=\"1c462ce\" 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>Macro adalah salah satu tip advanced yang digunakan oleh pengguna untuk mengurus data, seperti data kewangan, yang diterima setiap minggu. Macro membantu mengurangkan beban kerja anda. Dan untuk pengetahuan anda, satu Macroringkas tidak susah untuk dihasilkan sebenarnya. Anda boleh mula menghasilkan Macroanda mengikut langkah-langkah yang diberikan.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-2881dbd elementor-widget elementor-widget-image\" data-id=\"2881dbd\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"860\" height=\"703\" src=\"https:\/\/www.mu.my\/files\/uploads\/macro.png\" class=\"attachment-large size-large wp-image-60537\" alt=\"\" srcset=\"https:\/\/www.mu.my\/files\/uploads\/macro.png 860w, https:\/\/www.mu.my\/files\/uploads\/macro-300x245.png 300w, https:\/\/www.mu.my\/files\/uploads\/macro-768x628.png 768w, https:\/\/www.mu.my\/files\/uploads\/macro-830x678.png 830w\" sizes=\"(max-width: 860px) 100vw, 860px\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-58ea7bc elementor-widget elementor-widget-text-editor\" data-id=\"58ea7bc\" 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<ul><li style=\"font-weight: 400;\">Pergi ke <strong>File \u279c Options \u279c Customize Ribbons<\/strong> dan pada sebelah kanan pop up, pilih <strong>Developer<\/strong>.<\/li><\/ul>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-2ef7b75 elementor-widget elementor-widget-image\" data-id=\"2ef7b75\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"318\" height=\"261\" src=\"https:\/\/www.mu.my\/files\/uploads\/macro-2.png\" class=\"attachment-large size-large wp-image-60547\" alt=\"\" srcset=\"https:\/\/www.mu.my\/files\/uploads\/macro-2.png 318w, https:\/\/www.mu.my\/files\/uploads\/macro-2-300x246.png 300w\" sizes=\"(max-width: 318px) 100vw, 318px\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-42d1c66 elementor-widget elementor-widget-text-editor\" data-id=\"42d1c66\" 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<ul><li style=\"font-weight: 400;\">Kemudian, pergi ke ribbon <strong>Developer<\/strong> dan pilih <strong>Record Macro<\/strong>. Satu pop up akan keluar dan meminta anda isi nama Macro. Tekan <strong>OK<\/strong> dan mula hasilkan prosedur untuk Macro anda.<\/li><\/ul>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-5ea05cf elementor-widget elementor-widget-image\" data-id=\"5ea05cf\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"245\" height=\"270\" src=\"https:\/\/www.mu.my\/files\/uploads\/macro-4.png\" class=\"attachment-large size-large wp-image-60543\" alt=\"\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-c0672a0 elementor-widget elementor-widget-text-editor\" data-id=\"c0672a0\" 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<ul><li style=\"font-weight: 400;\">Setelah anda siap hasilkan Macro anda, dan bersedia untuk save Macro itu, tekan <strong>Stop Recording<\/strong>.<\/li><\/ul>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<section class=\"elementor-section elementor-inner-section elementor-element elementor-element-4749689 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"4749689\" 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-50 elementor-inner-column elementor-element elementor-element-c86da48\" data-id=\"c86da48\" 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-830b410 elementor-widget elementor-widget-image\" data-id=\"830b410\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"274\" height=\"240\" src=\"https:\/\/www.mu.my\/files\/uploads\/macro-5.png\" class=\"attachment-large size-large wp-image-60541\" alt=\"\" \/>\t\t\t\t\t\t\t\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<div class=\"elementor-column elementor-col-50 elementor-inner-column elementor-element elementor-element-4712144\" data-id=\"4712144\" 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-e26d3c4 elementor-widget elementor-widget-image\" data-id=\"e26d3c4\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"489\" height=\"405\" src=\"https:\/\/www.mu.my\/files\/uploads\/macro-6.png\" class=\"attachment-large size-large wp-image-60539\" alt=\"\" srcset=\"https:\/\/www.mu.my\/files\/uploads\/macro-6.png 489w, https:\/\/www.mu.my\/files\/uploads\/macro-6-300x248.png 300w\" sizes=\"(max-width: 489px) 100vw, 489px\" \/>\t\t\t\t\t\t\t\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 class=\"elementor-element elementor-element-18cfa40 elementor-widget elementor-widget-text-editor\" data-id=\"18cfa40\" 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<ul><li style=\"font-weight: 400;\">Apabila anda ingin menggunakan Macro itu, pergi ke ke ribbon <strong>Developer<\/strong> dan pilih <strong>Macro<\/strong>.<\/li><\/ul>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-5fa1939 elementor-widget elementor-widget-text-editor\" data-id=\"5fa1939\" 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><strong>Tip Bonus!<\/strong><\/p><p>Anda juga boleh record Macro anda dengan menekan butang yang terletak di bucu bawah kiri, sebelah perkataan\u00a0<strong>Ready<\/strong>.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-f8e66f5 elementor-widget elementor-widget-image\" data-id=\"f8e66f5\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"508\" height=\"91\" src=\"https:\/\/www.mu.my\/files\/uploads\/macro-1.png\" class=\"attachment-large size-large wp-image-60549\" alt=\"\" srcset=\"https:\/\/www.mu.my\/files\/uploads\/macro-1.png 508w, https:\/\/www.mu.my\/files\/uploads\/macro-1-300x54.png 300w, https:\/\/www.mu.my\/files\/uploads\/macro-1-500x91.png 500w\" sizes=\"(max-width: 508px) 100vw, 508px\" \/>\t\t\t\t\t\t\t\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<section class=\"elementor-section elementor-top-section elementor-element elementor-element-ccdb8bf elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"ccdb8bf\" 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-c670904\" data-id=\"c670904\" 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-85d1a03 elementor-widget elementor-widget-spacer\" data-id=\"85d1a03\" data-element_type=\"widget\" data-widget_type=\"spacer.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"elementor-spacer\">\n\t\t\t<div class=\"elementor-spacer-inner\"><\/div>\n\t\t<\/div>\n\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<section class=\"elementor-section elementor-top-section elementor-element elementor-element-69ebcfe elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"69ebcfe\" 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-022ddfd\" data-id=\"022ddfd\" 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-c2ec075 elementor-widget elementor-widget-heading\" data-id=\"c2ec075\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">14. Menetapkan lajur dan baris sebagai panduan spreadsheet\n<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-5dbaeb3 elementor-widget elementor-widget-text-editor\" data-id=\"5dbaeb3\" 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>Kadang kala, anda perlu guna panduan untuk isi data anda ke dalam cell yang betul, biasanya menggunakan header, apabila anda scroll ke bawah. Anda boleh tetapkan panduan ini menggunakan langkah berikut.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-b960dfd elementor-widget elementor-widget-text-editor\" data-id=\"b960dfd\" 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<ul><li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Pilih header yang anda ingin jadikan panduan, samada lajur atau baris.<\/span><\/li><\/ul>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-e77f3af elementor-widget elementor-widget-image\" data-id=\"e77f3af\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"586\" height=\"335\" src=\"https:\/\/www.mu.my\/files\/uploads\/sticky-row.png\" class=\"attachment-large size-large wp-image-60535\" alt=\"\" srcset=\"https:\/\/www.mu.my\/files\/uploads\/sticky-row.png 586w, https:\/\/www.mu.my\/files\/uploads\/sticky-row-300x172.png 300w\" sizes=\"(max-width: 586px) 100vw, 586px\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-65e94b9 elementor-widget elementor-widget-text-editor\" data-id=\"65e94b9\" 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<ul><li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Kemudian, pergi ke <\/span><b>View \u279c Freeze Panes<\/b><span style=\"font-weight: 400;\"> dan pilih\u00a0<strong>Freeze Panes.<\/strong><\/span><\/li><\/ul>\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<section class=\"elementor-section elementor-top-section elementor-element elementor-element-bb357df elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"bb357df\" 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-64627ad\" data-id=\"64627ad\" 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-f6b5945 elementor-widget elementor-widget-spacer\" data-id=\"f6b5945\" data-element_type=\"widget\" data-widget_type=\"spacer.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"elementor-spacer\">\n\t\t\t<div class=\"elementor-spacer-inner\"><\/div>\n\t\t<\/div>\n\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<section class=\"elementor-section elementor-top-section elementor-element elementor-element-e48dec7 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"e48dec7\" 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-4b4fb79\" data-id=\"4b4fb79\" 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-6673799 elementor-widget elementor-widget-heading\" data-id=\"6673799\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">15. Menggunakan Format Painter<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-50a6b2f elementor-widget elementor-widget-text-editor\" data-id=\"50a6b2f\" 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>Format Painter sangat berguna jika anda ingin menggunakan format dari table yang sedia ada untuk diimplimentasikan pada table yang baru.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-3f529c1 elementor-widget elementor-widget-image\" data-id=\"3f529c1\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"745\" height=\"396\" src=\"https:\/\/www.mu.my\/files\/uploads\/Format.png\" class=\"attachment-large size-large wp-image-60529\" alt=\"\" srcset=\"https:\/\/www.mu.my\/files\/uploads\/Format.png 745w, https:\/\/www.mu.my\/files\/uploads\/Format-300x159.png 300w\" sizes=\"(max-width: 745px) 100vw, 745px\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-92c7a75 elementor-widget elementor-widget-text-editor\" data-id=\"92c7a75\" 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<ul><li>Mula-mula, anda perlu pilih satu table yang lengkap untuk dijadikan format table baru itu.<\/li><\/ul>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-9b3335e elementor-widget elementor-widget-image\" data-id=\"9b3335e\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"268\" height=\"411\" src=\"https:\/\/www.mu.my\/files\/uploads\/format-2.png\" class=\"attachment-large size-large wp-image-60527\" alt=\"\" srcset=\"https:\/\/www.mu.my\/files\/uploads\/format-2.png 268w, https:\/\/www.mu.my\/files\/uploads\/format-2-196x300.png 196w\" sizes=\"(max-width: 268px) 100vw, 268px\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-708dd84 elementor-widget elementor-widget-text-editor\" data-id=\"708dd84\" 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<ul><li>Kemudian, pergi ke\u00a0<strong>Home <\/strong>dan tekan butang\u00a0\u00a0<img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-60575\" src=\"http:\/\/www.mu.my\/files\/uploads\/format-1.png\" alt=\"\" width=\"29\" height=\"24\" \/> sebelah pilihan <strong>Paste<\/strong>.<\/li><\/ul>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-fec22d4 elementor-widget elementor-widget-image\" data-id=\"fec22d4\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"802\" height=\"382\" src=\"https:\/\/www.mu.my\/files\/uploads\/format-3-1.png\" class=\"attachment-large size-large wp-image-60585\" alt=\"\" srcset=\"https:\/\/www.mu.my\/files\/uploads\/format-3-1.png 802w, https:\/\/www.mu.my\/files\/uploads\/format-3-1-300x143.png 300w, https:\/\/www.mu.my\/files\/uploads\/format-3-1-768x366.png 768w\" sizes=\"(max-width: 802px) 100vw, 802px\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-c336315 elementor-widget elementor-widget-text-editor\" data-id=\"c336315\" 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<ul><li>Apabila anda telah pilih Format Painter, cursor anda akan menjadi seperti ini <img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-60577 size-full\" src=\"http:\/\/www.mu.my\/files\/uploads\/format-2-1-e1583713117439.png\" alt=\"\" width=\"46\" height=\"23\" \/> . Ketika cursor anda dalam bentuk ini, pilih set data yang anda ingin tukar ke dalam format yang telah ditetapkan.<\/li><\/ul>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-cbd1932 elementor-widget elementor-widget-image\" data-id=\"cbd1932\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"810\" height=\"385\" src=\"https:\/\/www.mu.my\/files\/uploads\/format-4-1.png\" class=\"attachment-large size-large wp-image-60587\" alt=\"\" srcset=\"https:\/\/www.mu.my\/files\/uploads\/format-4-1.png 810w, https:\/\/www.mu.my\/files\/uploads\/format-4-1-300x143.png 300w, https:\/\/www.mu.my\/files\/uploads\/format-4-1-768x365.png 768w\" sizes=\"(max-width: 810px) 100vw, 810px\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-eb11ff7 elementor-widget elementor-widget-text-editor\" data-id=\"eb11ff7\" 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<ul><li>Selepas anda telah pilih data, anda hanya perlu tunggu Excel untuk memproses dan menetapkan format, dan data anda akan dipaparkan dalam format itu.<\/li><\/ul>\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<section class=\"elementor-section elementor-top-section elementor-element elementor-element-f25f38c elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"f25f38c\" 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-69d51cd\" data-id=\"69d51cd\" 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-bd64d64 elementor-widget elementor-widget-spacer\" data-id=\"bd64d64\" data-element_type=\"widget\" data-widget_type=\"spacer.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"elementor-spacer\">\n\t\t\t<div class=\"elementor-spacer-inner\"><\/div>\n\t\t<\/div>\n\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<section class=\"elementor-section elementor-top-section elementor-element elementor-element-72befe6 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"72befe6\" 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-3f6653e\" data-id=\"3f6653e\" 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-bf65a9e elementor-widget elementor-widget-heading\" data-id=\"bf65a9e\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">16. Menetapkan cell message untuk cell anda<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-54646da elementor-widget elementor-widget-text-editor\" data-id=\"54646da\" 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>Apabila berkolaborasi dengan orang lain dalam projek tertentu, kadang-kadang anda mahu pengguna lain mengelakkan melakukan perubahan pada cell yang telah anda buat. Untuk ini, anda mungkin ingin menggunakan cell message yang akan muncul ketika seseorang klik pada cell dan memaparkan mesej yang ditulis di atasnya.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-50037f7 elementor-widget elementor-widget-image\" data-id=\"50037f7\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"803\" height=\"40\" src=\"https:\/\/www.mu.my\/files\/uploads\/cell-message-1.png\" class=\"attachment-large size-large wp-image-60596\" alt=\"\" srcset=\"https:\/\/www.mu.my\/files\/uploads\/cell-message-1.png 803w, https:\/\/www.mu.my\/files\/uploads\/cell-message-1-300x15.png 300w, https:\/\/www.mu.my\/files\/uploads\/cell-message-1-768x38.png 768w\" sizes=\"(max-width: 803px) 100vw, 803px\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-f699c92 elementor-widget elementor-widget-text-editor\" data-id=\"f699c92\" 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<ul><li>Pilih cell atau data yang anda ingin paparkan mesej itu.<\/li><\/ul>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-8736b81 elementor-widget elementor-widget-image\" data-id=\"8736b81\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"305\" height=\"299\" src=\"https:\/\/www.mu.my\/files\/uploads\/cell-message.png\" class=\"attachment-large size-large wp-image-60533\" alt=\"\" srcset=\"https:\/\/www.mu.my\/files\/uploads\/cell-message.png 305w, https:\/\/www.mu.my\/files\/uploads\/cell-message-300x294.png 300w\" sizes=\"(max-width: 305px) 100vw, 305px\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-19750be elementor-widget elementor-widget-text-editor\" data-id=\"19750be\" 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<ul><li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Pergi ke <\/span><b>Data \u279c Data Tools <\/b><span style=\"font-weight: 400;\">dan tekan ikon <\/span><b>Data Validation <\/b><span style=\"font-weight: 400;\">terletak di bucu bawah kanan sebelah\u00a0<strong>Text to Columns.<\/strong><\/span><\/li><\/ul>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-077fbc4 elementor-widget elementor-widget-image\" data-id=\"077fbc4\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"413\" height=\"331\" src=\"https:\/\/www.mu.my\/files\/uploads\/data-validation-2.png\" class=\"attachment-large size-large wp-image-60531\" alt=\"\" srcset=\"https:\/\/www.mu.my\/files\/uploads\/data-validation-2.png 413w, https:\/\/www.mu.my\/files\/uploads\/data-validation-2-300x240.png 300w\" sizes=\"(max-width: 413px) 100vw, 413px\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-193c745 elementor-widget elementor-widget-text-editor\" data-id=\"193c745\" 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<ul><li>Masukkan mesej yang anda ingin paparkan ke dalam Input message box dan setelah selesai, tekan OK.<\/li><\/ul>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-a873e57 elementor-widget elementor-widget-image\" data-id=\"a873e57\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"814\" height=\"98\" src=\"https:\/\/www.mu.my\/files\/uploads\/cell-message-2.png\" class=\"attachment-large size-large wp-image-60602\" alt=\"\" srcset=\"https:\/\/www.mu.my\/files\/uploads\/cell-message-2.png 814w, https:\/\/www.mu.my\/files\/uploads\/cell-message-2-300x36.png 300w, https:\/\/www.mu.my\/files\/uploads\/cell-message-2-768x92.png 768w\" sizes=\"(max-width: 814px) 100vw, 814px\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-e628455 elementor-widget elementor-widget-text-editor\" data-id=\"e628455\" 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<ul><li>Apabila mesej anda siap ditetapkan, mesej anda akan dipaparkan seperti di dalam imej di atas.<\/li><\/ul>\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<section class=\"elementor-section elementor-top-section elementor-element elementor-element-f853465 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"f853465\" 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-e4df6cf\" data-id=\"e4df6cf\" 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-1d4e840 elementor-widget elementor-widget-spacer\" data-id=\"1d4e840\" data-element_type=\"widget\" data-widget_type=\"spacer.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"elementor-spacer\">\n\t\t\t<div class=\"elementor-spacer-inner\"><\/div>\n\t\t<\/div>\n\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<section class=\"elementor-section elementor-top-section elementor-element elementor-element-015ecfa elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"015ecfa\" 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-b4c2301\" data-id=\"b4c2301\" 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-611eeda elementor-widget elementor-widget-heading\" data-id=\"611eeda\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">Conclusions\n<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-e3a9223 elementor-widget elementor-widget-text-editor\" data-id=\"e3a9223\" 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: 400;\">Demikian adalah sebahagian daripada tips yang anda boleh gunakan dalam Microsoft Excel. Terima kasih kerana melawat ruang tutorial ini. Anda ingin tahu tips yang lain? Lawatilah laman web kami di <a href=\"http:\/\/www.mu.my\/en\/\" target=\"_blank\" rel=\"noopener\">mu.my<\/a> dan daftar untuk kursus Microsoft Excel Advanced untuk dapatkan lebih banyak tips dan pengetahuan yang berguna. Kami juga menyediakan pelbagai fungsi dan formula berguna di dalam kursus latihan kami.<\/span><\/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<section class=\"elementor-section elementor-top-section elementor-element elementor-element-3d56696 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"3d56696\" 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-16bdc4a\" data-id=\"16bdc4a\" 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-8c0e7b4 elementor-widget elementor-widget-spacer\" data-id=\"8c0e7b4\" data-element_type=\"widget\" data-widget_type=\"spacer.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"elementor-spacer\">\n\t\t\t<div class=\"elementor-spacer-inner\"><\/div>\n\t\t<\/div>\n\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<section class=\"elementor-section elementor-top-section elementor-element elementor-element-b01b325 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"b01b325\" 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-deeebdc\" data-id=\"deeebdc\" 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-0d41b45 elementor-widget elementor-widget-heading\" data-id=\"0d41b45\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">Post lain yang mungkin anda berminat untuk baca<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-f96f282 elementor-grid-2 elementor-grid-tablet-2 elementor-grid-mobile-1 elementor-posts--thumbnail-top elementor-widget elementor-widget-posts\" data-id=\"f96f282\" data-element_type=\"widget\" data-settings=\"{&quot;classic_columns&quot;:&quot;2&quot;,&quot;classic_columns_tablet&quot;:&quot;2&quot;,&quot;classic_columns_mobile&quot;:&quot;1&quot;,&quot;classic_row_gap&quot;:{&quot;unit&quot;:&quot;px&quot;,&quot;size&quot;:35,&quot;sizes&quot;:[]},&quot;classic_row_gap_tablet&quot;:{&quot;unit&quot;:&quot;px&quot;,&quot;size&quot;:&quot;&quot;,&quot;sizes&quot;:[]},&quot;classic_row_gap_mobile&quot;:{&quot;unit&quot;:&quot;px&quot;,&quot;size&quot;:&quot;&quot;,&quot;sizes&quot;:[]}}\" data-widget_type=\"posts.classic\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"elementor-posts-container elementor-posts elementor-posts--skin-classic elementor-grid\">\n\t\t\t\t<article class=\"elementor-post elementor-grid-item post-14170 post type-post status-publish format-standard has-post-thumbnail hentry category-berita\">\n\t\t\t\t<a class=\"elementor-post__thumbnail__link\" href=\"https:\/\/www.mu.my\/ms\/berita\/microsoft-excel-shortcuts-know\/\" tabindex=\"-1\" >\n\t\t\t<div class=\"elementor-post__thumbnail\"><img loading=\"lazy\" decoding=\"async\" width=\"300\" height=\"200\" src=\"https:\/\/www.mu.my\/files\/uploads\/advanced-excel-keyboard-shortcuts-1-300x200.jpg\" class=\"attachment-medium size-medium wp-image-24362\" alt=\"\" srcset=\"https:\/\/www.mu.my\/files\/uploads\/advanced-excel-keyboard-shortcuts-1-300x200.jpg 300w, https:\/\/www.mu.my\/files\/uploads\/advanced-excel-keyboard-shortcuts-1-450x300.jpg 450w, https:\/\/www.mu.my\/files\/uploads\/advanced-excel-keyboard-shortcuts-1.jpg 525w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/div>\n\t\t<\/a>\n\t\t\t\t<div class=\"elementor-post__text\">\n\t\t\t\t<h3 class=\"elementor-post__title\">\n\t\t\t<a href=\"https:\/\/www.mu.my\/ms\/berita\/microsoft-excel-shortcuts-know\/\" >\n\t\t\t\tShortcut Microsoft Excel yang Anda Perlu Tahu\t\t\t<\/a>\n\t\t<\/h3>\n\t\t\t\t<div class=\"elementor-post__excerpt\">\n\t\t\t<p>Berapa banyak shortcut yang anda tahu mengenai Microsoft Excel? Belajar shortcut Excel yang berguna ini untuk menjimatkan masa anda untuk spreadsheet! Ketahui lebih lanjut di&nbsp;www.mu.my<\/p>\n\t\t<\/div>\n\t\t\n\t\t<a class=\"elementor-post__read-more\" href=\"https:\/\/www.mu.my\/ms\/berita\/microsoft-excel-shortcuts-know\/\" aria-label=\"Read more about Shortcut Microsoft Excel yang Anda Perlu Tahu\" tabindex=\"-1\" >\n\t\t\tRead More \u00bb\t\t<\/a>\n\n\t\t\t\t<\/div>\n\t\t\t\t<\/article>\n\t\t\t\t<article class=\"elementor-post elementor-grid-item post-13223 post type-post status-publish format-standard hentry category-berita\">\n\t\t\t\t<div class=\"elementor-post__text\">\n\t\t\t\t<h3 class=\"elementor-post__title\">\n\t\t\t<a href=\"https:\/\/www.mu.my\/ms\/berita\/apakah-itu-pivottable\/\" >\n\t\t\t\tApakah itu PivotTable?\t\t\t<\/a>\n\t\t<\/h3>\n\t\t\t\t<div class=\"elementor-post__excerpt\">\n\t\t\t<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<\/p>\n\t\t<\/div>\n\t\t\n\t\t<a class=\"elementor-post__read-more\" href=\"https:\/\/www.mu.my\/ms\/berita\/apakah-itu-pivottable\/\" aria-label=\"Read more about Apakah itu PivotTable?\" tabindex=\"-1\" >\n\t\t\tRead More \u00bb\t\t<\/a>\n\n\t\t\t\t<\/div>\n\t\t\t\t<\/article>\n\t\t\t\t<\/div>\n\t\t\n\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>Kenapa anda perlu menggunakan tip-tip ini? Kebanyakan dari kalangan kita mesti mahir menggunakan Microsoft Excel. Paling kurang pun mesti ramai yang tahu fungsi dan formula asas dalam Microsoft Excel, kan. Tapi, apa anda rasa kalau saya bagi tahu yang banyak lagi tips yang boleh digunakan dalam perisian ini, yang mungkin kita tak pernah tahu pun &#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":11,"featured_media":62443,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[68],"tags":[],"class_list":["post-62446","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-tutorial"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v24.1 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Tip Advanced Menggunakan Microsoft Excel - MU DOT MY PLT - ICT Training &amp; Development Malaysia<\/title>\n<meta name=\"description\" content=\"Dalam tutorial ini akan disenaraikan beberapa tips dan kaedah berkesan yang boleh digunakan semasa anda sedang membuat kerja menggunakan 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:\/\/www.mu.my\/ms\/tutorial\/tip-advanced-menggunakan-microsoft-excel\/\" \/>\n<meta property=\"og:locale\" content=\"ms_MY\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Tip Advanced Menggunakan Microsoft Excel - MU DOT MY PLT - ICT Training &amp; Development Malaysia\" \/>\n<meta property=\"og:description\" content=\"Dalam tutorial ini akan disenaraikan beberapa tips dan kaedah berkesan yang boleh digunakan semasa anda sedang membuat kerja menggunakan Excel.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.mu.my\/ms\/tutorial\/tip-advanced-menggunakan-microsoft-excel\/\" \/>\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=\"2020-02-21T02:57:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2020-03-17T03:47:20+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.mu.my\/files\/uploads\/excel-training-2-768x425-1.png\" \/>\n\t<meta property=\"og:image:width\" content=\"768\" \/>\n\t<meta property=\"og:image:height\" content=\"425\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Reece Yong\" \/>\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=\"Reece Yong\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"7 minit\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.mu.my\/ms\/tutorial\/tip-advanced-menggunakan-microsoft-excel\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.mu.my\/ms\/tutorial\/tip-advanced-menggunakan-microsoft-excel\/\"},\"author\":{\"name\":\"Reece Yong\",\"@id\":\"https:\/\/www.mu.my\/ms\/#\/schema\/person\/c8301539619fa2f7c1a6bfda5fea023c\"},\"headline\":\"Tip Advanced Menggunakan Microsoft Excel\",\"datePublished\":\"2020-02-21T02:57:00+00:00\",\"dateModified\":\"2020-03-17T03:47:20+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.mu.my\/ms\/tutorial\/tip-advanced-menggunakan-microsoft-excel\/\"},\"wordCount\":1482,\"publisher\":{\"@id\":\"https:\/\/www.mu.my\/ms\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.mu.my\/ms\/tutorial\/tip-advanced-menggunakan-microsoft-excel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.mu.my\/files\/uploads\/excel-training-2-768x425-1.png\",\"articleSection\":[\"Tutorial\"],\"inLanguage\":\"ms-MY\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.mu.my\/ms\/tutorial\/tip-advanced-menggunakan-microsoft-excel\/\",\"url\":\"https:\/\/www.mu.my\/ms\/tutorial\/tip-advanced-menggunakan-microsoft-excel\/\",\"name\":\"Tip Advanced Menggunakan Microsoft Excel - MU DOT MY PLT - ICT Training & Development Malaysia\",\"isPartOf\":{\"@id\":\"https:\/\/www.mu.my\/ms\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.mu.my\/ms\/tutorial\/tip-advanced-menggunakan-microsoft-excel\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.mu.my\/ms\/tutorial\/tip-advanced-menggunakan-microsoft-excel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.mu.my\/files\/uploads\/excel-training-2-768x425-1.png\",\"datePublished\":\"2020-02-21T02:57:00+00:00\",\"dateModified\":\"2020-03-17T03:47:20+00:00\",\"description\":\"Dalam tutorial ini akan disenaraikan beberapa tips dan kaedah berkesan yang boleh digunakan semasa anda sedang membuat kerja menggunakan Excel.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.mu.my\/ms\/tutorial\/tip-advanced-menggunakan-microsoft-excel\/#breadcrumb\"},\"inLanguage\":\"ms-MY\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.mu.my\/ms\/tutorial\/tip-advanced-menggunakan-microsoft-excel\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"ms-MY\",\"@id\":\"https:\/\/www.mu.my\/ms\/tutorial\/tip-advanced-menggunakan-microsoft-excel\/#primaryimage\",\"url\":\"https:\/\/www.mu.my\/files\/uploads\/excel-training-2-768x425-1.png\",\"contentUrl\":\"https:\/\/www.mu.my\/files\/uploads\/excel-training-2-768x425-1.png\",\"width\":768,\"height\":425},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.mu.my\/ms\/tutorial\/tip-advanced-menggunakan-microsoft-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.mu.my\/ms\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Tip Advanced Menggunakan Microsoft Excel\"}]},{\"@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\/c8301539619fa2f7c1a6bfda5fea023c\",\"name\":\"Reece Yong\",\"url\":\"https:\/\/www.mu.my\/ms\/author\/reece-yong\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Tip Advanced Menggunakan Microsoft Excel - MU DOT MY PLT - ICT Training & Development Malaysia","description":"Dalam tutorial ini akan disenaraikan beberapa tips dan kaedah berkesan yang boleh digunakan semasa anda sedang membuat kerja menggunakan 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:\/\/www.mu.my\/ms\/tutorial\/tip-advanced-menggunakan-microsoft-excel\/","og_locale":"ms_MY","og_type":"article","og_title":"Tip Advanced Menggunakan Microsoft Excel - MU DOT MY PLT - ICT Training & Development Malaysia","og_description":"Dalam tutorial ini akan disenaraikan beberapa tips dan kaedah berkesan yang boleh digunakan semasa anda sedang membuat kerja menggunakan Excel.","og_url":"https:\/\/www.mu.my\/ms\/tutorial\/tip-advanced-menggunakan-microsoft-excel\/","og_site_name":"MU DOT MY PLT - ICT Training & Development Malaysia","article_publisher":"https:\/\/facebook.com\/mudotmy","article_published_time":"2020-02-21T02:57:00+00:00","article_modified_time":"2020-03-17T03:47:20+00:00","og_image":[{"width":768,"height":425,"url":"https:\/\/www.mu.my\/files\/uploads\/excel-training-2-768x425-1.png","type":"image\/png"}],"author":"Reece Yong","twitter_card":"summary_large_image","twitter_creator":"@mudotmy","twitter_site":"@mudotmy","twitter_misc":{"Written by":"Reece Yong","Est. reading time":"7 minit"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.mu.my\/ms\/tutorial\/tip-advanced-menggunakan-microsoft-excel\/#article","isPartOf":{"@id":"https:\/\/www.mu.my\/ms\/tutorial\/tip-advanced-menggunakan-microsoft-excel\/"},"author":{"name":"Reece Yong","@id":"https:\/\/www.mu.my\/ms\/#\/schema\/person\/c8301539619fa2f7c1a6bfda5fea023c"},"headline":"Tip Advanced Menggunakan Microsoft Excel","datePublished":"2020-02-21T02:57:00+00:00","dateModified":"2020-03-17T03:47:20+00:00","mainEntityOfPage":{"@id":"https:\/\/www.mu.my\/ms\/tutorial\/tip-advanced-menggunakan-microsoft-excel\/"},"wordCount":1482,"publisher":{"@id":"https:\/\/www.mu.my\/ms\/#organization"},"image":{"@id":"https:\/\/www.mu.my\/ms\/tutorial\/tip-advanced-menggunakan-microsoft-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/www.mu.my\/files\/uploads\/excel-training-2-768x425-1.png","articleSection":["Tutorial"],"inLanguage":"ms-MY"},{"@type":"WebPage","@id":"https:\/\/www.mu.my\/ms\/tutorial\/tip-advanced-menggunakan-microsoft-excel\/","url":"https:\/\/www.mu.my\/ms\/tutorial\/tip-advanced-menggunakan-microsoft-excel\/","name":"Tip Advanced Menggunakan Microsoft Excel - MU DOT MY PLT - ICT Training & Development Malaysia","isPartOf":{"@id":"https:\/\/www.mu.my\/ms\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.mu.my\/ms\/tutorial\/tip-advanced-menggunakan-microsoft-excel\/#primaryimage"},"image":{"@id":"https:\/\/www.mu.my\/ms\/tutorial\/tip-advanced-menggunakan-microsoft-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/www.mu.my\/files\/uploads\/excel-training-2-768x425-1.png","datePublished":"2020-02-21T02:57:00+00:00","dateModified":"2020-03-17T03:47:20+00:00","description":"Dalam tutorial ini akan disenaraikan beberapa tips dan kaedah berkesan yang boleh digunakan semasa anda sedang membuat kerja menggunakan Excel.","breadcrumb":{"@id":"https:\/\/www.mu.my\/ms\/tutorial\/tip-advanced-menggunakan-microsoft-excel\/#breadcrumb"},"inLanguage":"ms-MY","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.mu.my\/ms\/tutorial\/tip-advanced-menggunakan-microsoft-excel\/"]}]},{"@type":"ImageObject","inLanguage":"ms-MY","@id":"https:\/\/www.mu.my\/ms\/tutorial\/tip-advanced-menggunakan-microsoft-excel\/#primaryimage","url":"https:\/\/www.mu.my\/files\/uploads\/excel-training-2-768x425-1.png","contentUrl":"https:\/\/www.mu.my\/files\/uploads\/excel-training-2-768x425-1.png","width":768,"height":425},{"@type":"BreadcrumbList","@id":"https:\/\/www.mu.my\/ms\/tutorial\/tip-advanced-menggunakan-microsoft-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.mu.my\/ms\/"},{"@type":"ListItem","position":2,"name":"Tip Advanced Menggunakan Microsoft Excel"}]},{"@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\/c8301539619fa2f7c1a6bfda5fea023c","name":"Reece Yong","url":"https:\/\/www.mu.my\/ms\/author\/reece-yong\/"}]}},"_links":{"self":[{"href":"https:\/\/www.mu.my\/ms\/wp-json\/wp\/v2\/posts\/62446","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\/11"}],"replies":[{"embeddable":true,"href":"https:\/\/www.mu.my\/ms\/wp-json\/wp\/v2\/comments?post=62446"}],"version-history":[{"count":13,"href":"https:\/\/www.mu.my\/ms\/wp-json\/wp\/v2\/posts\/62446\/revisions"}],"predecessor-version":[{"id":62981,"href":"https:\/\/www.mu.my\/ms\/wp-json\/wp\/v2\/posts\/62446\/revisions\/62981"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.mu.my\/ms\/wp-json\/wp\/v2\/media\/62443"}],"wp:attachment":[{"href":"https:\/\/www.mu.my\/ms\/wp-json\/wp\/v2\/media?parent=62446"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.mu.my\/ms\/wp-json\/wp\/v2\/categories?post=62446"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.mu.my\/ms\/wp-json\/wp\/v2\/tags?post=62446"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}