{"id":58260,"date":"2020-02-21T00:33:16","date_gmt":"2020-02-21T00:33:16","guid":{"rendered":"http:\/\/www.mu.my\/?p=58260"},"modified":"2020-03-17T07:29:23","modified_gmt":"2020-03-17T07:29:23","slug":"top-10-advanced-tips-in-microsoft-excel-en","status":"publish","type":"post","link":"https:\/\/www.mu.my\/en\/tutorials\/top-10-advanced-tips-in-microsoft-excel-en\/","title":{"rendered":"Advanced Tips in Microsoft Excel"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-post\" data-elementor-id=\"58260\" class=\"elementor 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\">Why You Should Consider Using These Advanced Tips?<\/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><span style=\"font-weight: 400;\">Some of us might have been familiar with Microsoft Excel. While others knew some basic functions or formulas. Regardless of which side you\u2019re in, there are still many tips and tricks when using the software that we might not know, let alone be aware of their purpose. Well, fear not. In this tutorial, I will provide you with Top 10 Advanced Tips in Microsoft Excel you can apply when doing your work using Microsoft Excel.<\/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-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-7f3dba3 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"7f3dba3\" 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-664f795\" data-id=\"664f795\" 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-5ed6cd4 elementor-widget elementor-widget-heading\" data-id=\"5ed6cd4\" 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-medium\">Let's start with the advanced tips...<\/h2>\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. Quickly shift to the last cell in the column or row.<\/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>The first advanced tips is to quickly shift from the first cell to the last cell in the data, either from column-to-column, or row-to-row. What you have to do is simply go to the border of the cell, and then double click on the bottom border to transition to the last active cell in the column. As for shifting from row-to-row, double click on the right side of the cell border.<\/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\">Shift to the last cell in the column<\/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\">Shift to the last cell in the row<\/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>Bonus Tips:<\/strong><\/p><p><span style=\"font-weight: 400;\">You can also double click on the opposite side of the box to shift to the first cell.<\/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-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. Removing duplicates.<\/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><span style=\"font-weight: 400;\">Removing duplication of any data becomes an easy task when using this advanced tips. You can use it to remove both words and number values.<\/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-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><span style=\"font-weight: 400;\">First, select all the cells or data that you want to remove duplications.<\/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-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><span id=\"docs-internal-guid-2068f677-7fff-9369-3ce5-83616f280503\"><span style=\"font-size: 14pt; font-family: Arial; background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline; white-space: pre-wrap;\">Next, go to ribbon situated on top of the software, go to <\/span><span style=\"font-size: 14pt; font-family: Arial; background-color: transparent; font-weight: bold; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline; white-space: pre-wrap;\">Data\u2192Remove Duplicates.<\/span><\/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-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;\"><span style=\"font-weight: 400;\">Select the header for the duplicated data, and click ok.<\/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-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><span style=\"font-weight: 400;\">A thread will be displayed once your duplication removal succeeds, click ok and you are ready to go.<\/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-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. Selecting multiple cells to insert the same 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-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><span style=\"font-weight: 400;\">If you plan on putting the same data or value into cells on either different cells or row, this method fits perfectly for that task.<\/span><\/p><ul><li><span style=\"font-weight: 400;\">First, hold the Ctrl button and select all the cells you need to put data in it.<\/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-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>Next, type in the data you need to put, and press Ctrl + Enter.<\/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 cells by data pattern\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><span style=\"font-weight: 400;\">If you wish to insert repetitive data, such as date or months into either the whole column or row, follow these simple steps.<\/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-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;\"><span style=\"font-weight: 400;\">First, fill in the type of data you wanted for the column or row, for example, in the above image the data is the month.<\/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-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;\">Next, hover your cursor and hold the<\/span><span style=\"font-weight: 400;\"> fill handle\u200d <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\" \/>&#8211; located on the lower right corner of the cell, then pull down or double click on it to fill in by column or pull it sideways to fill in by rows, until the last cell of your data.<\/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 between row and column\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><span style=\"font-weight: 400;\">Another advanced tips is transpose. Transpose allows you to shift your data arrangement either in row or column view.\u00a0<\/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-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;\"><span style=\"font-weight: 400;\">First, you have to select and copy the data you want to transpose.<\/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-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;\"><span style=\"font-weight: 400;\">Next, click on any blank cells that you intend to paste that data and go to\u00a0<strong>Home,\u00a0<\/strong>and select the arrow down button below the\u00a0<strong>P<\/strong><strong>aste<\/strong> option.<\/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-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>A number of option will pops up when you click on that button. Hover your cursor to the bottom of the pop up and click on\u00a0<strong>Paste 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>Once you click on\u00a0<strong>Paste Special<\/strong>, another pop up will appear. Select transpose and click\u00a0<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>After you click\u00a0<strong>OK,\u00a0<\/strong>your data will appear in the opposite arrangement from the data you&#8217;ve selected before.<\/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. Wrap sentences to fit perfectly in cells\n<\/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><span style=\"font-weight: 400;\">Wrap tool fits a long sentence perfectly in one cell. Simply press <strong>Alt + Enter<\/strong> button, or go to <\/span><b>Home\u2192Wrap Text<\/b><span style=\"font-weight: 400;\"> and click the Wrap Text button<\/span><span style=\"font-weight: 400;\">.<\/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-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><span style=\"font-weight: 400;\">Flash fill is a wonderful trick you can use which saves a lot of time when handling piles of data because it assigns the right data according to your data on the side columns.<\/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-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;\"><span style=\"font-weight: 400;\">Firstly, fill in the first cell with the appropriate data.<\/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-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><span style=\"font-weight: 400;\">Next, select the next cell and press <strong>Ctrl + E.<\/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-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>Once you have hit <strong>CTRL + E<\/strong>, Microsoft Excel will automatically fill up the remaining blank cell with the appropriate data based on the data from the cell before it. For example, in this image, the data is month based on the date given.<\/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>Important Notes!<\/strong><\/p><p>Flash fill only works on data in column cells.<\/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>To access clipboard in Excel, got to the Home tab and click on the button next to the word Clipboard. Your clipboard will appear on the left side of your spreadsheet.<\/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>What Do You Use Clipboards For?<\/strong><\/p><p>When you copy anything on Microsoft Excel, the data or value that you&#8217;ve copied will be saved in the clipboard, make it easy for you to access your data there without having to scroll to find the same data. Clipboard also enables you to copy multiple data. When you want to paste it, just pick the data from your 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. Converting a number to a money value\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;\">Need to convert numbers into money value? You can use this advanced tips to do that. Simply select the data that you want to convert, then head towards the number section under Home tab, and press <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\" \/> button under the <strong>Number<\/strong> tab.<\/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>Pro Tips:<\/strong><\/p><p>This method allows you to convert your data into almost every currency in the world.<\/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. Sorting data<\/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><span style=\"font-weight: 400;\">Another interesting advanced tips that you might consider using is the sort tool. The sort tool allows us to sort raw data into organized data, either in ascending or descending order.\u00a0<\/span><\/p><ul><li><span style=\"font-weight: 400;\">Firstly, select the data that you need to arrange.<\/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-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><span style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Go to the Data tab, head to the sort and filter section and c<\/span><\/span>lick <span> button for <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\" \/>ascending order.<\/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-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>As for sorting the data in descending order, you must click <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\" \/> button\u00a0 and the data will sort in descending order.<\/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>Be careful!<\/strong><\/p><p>When sorting data, some data from another cells tend to change because the data is connected to each other, and a checkbox will appear just like the one above.<\/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. Replace multiple same words altogether.\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>When handling big data that tend to change, such as a group of persons age, it must be frustating to select and change, one by one. If you opt for an easier method, you&#8217;ve come to the right place. It&#8217;s simple to change multiple words or data alltogether, actually.<\/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>Firstly, <span style=\"font-weight: 400;\">go to <\/span><b>Home Tab \u279c Editing \u279c Find &amp; Replace \u279c Replace.<\/b><\/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. Delete multiple error cells.\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><span style=\"font-weight: 400;\">Deleting multiple errors when the spreadsheet is already finished can be done by following the steps given.<\/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-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;\"><span style=\"font-weight: 400;\">Firstly, go to <\/span><b>Home Tab \u279c Editing \u279c Find &amp; Replace \u279c Go To Special.<\/b><\/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;\"><span style=\"font-weight: 400;\">Select <\/span><b>Formula \u279c Errors<\/b><span style=\"font-weight: 400;\"> and click ok.<\/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-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. Use Macro to automate task for data of the same format<\/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><span style=\"font-weight: 400;\">Macro is one of the advanced tips known to help user when handling a set of data, for example, financial data, which is sent to you every week. Macro helps shorten your task, while ease your daily workload too. By the way, a simple macro is no big deal, actually. You can start your very own simple macro by following the steps listed below.<\/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-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;\"><span style=\"font-weight: 400;\">Set up a <\/span><b>Developer <\/b><span style=\"font-weight: 400;\">ribbon. Go to <\/span><b>File \u279c Options \u279c Customize Ribbons<\/b><span style=\"font-weight: 400;\"> and on the right side of the popup, select Developer.<\/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-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;\"><span style=\"font-weight: 400;\">Next, go to the <\/span><b>Developer <\/b><span style=\"font-weight: 400;\">ribbon and click on Record Macro. A popup will appear which requires you to fill in the macro name. Press ok and start creating your procedure.<\/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-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;\"><span style=\"font-weight: 400;\">Once you have finished creating your procedure, and ready to save it as a macro, click <\/span><b>Stop Recording<\/b><span style=\"font-weight: 400;\">.<\/span><\/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;\"><span style=\"font-weight: 400;\">When you want to use that macro, simply click on <\/span><b>Macro <\/b><span style=\"font-weight: 400;\">which then a popup will appear. Select Run<\/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-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>Bonus Tips!<\/strong><\/p><p><span style=\"font-weight: 400;\">You can also start recording for macro by clicking the button situated on the bottom left corner of the software, next to the word <strong>Ready<\/strong>.<\/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-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. Setting Rows or Columns As Spreadsheet Guidelines\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><span style=\"font-weight: 400;\">Sometimes, you might need a guideline to fill in your data, usually using the spreadsheet header, when you scroll down. You can set up a guideline by using this tip.<\/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-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;\">Select the header that you want to use as your guidelines, either row or column.<\/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;\">Next, go to <\/span><b>View \u279c Freeze Panes<\/b><span style=\"font-weight: 400;\"> and select Freeze Panes.<\/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. Using Format Painter\n<\/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><span style=\"font-weight: 400;\">Format Painter is useful when you need to copy the same format of a recent table to a new table.<\/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-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>To start, first you have to select a complete table to be set as a format for your new table.<\/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>Go to\u00a0<strong>Home\u00a0<\/strong>and click the \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\" \/> button next to the\u00a0<strong>Paste\u00a0<\/strong>option.<\/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>When you have selected format painter, your cursor will become something like this <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\" \/> . While your cursor is in this form, select the range of data that you want to set the format into.<\/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>After you&#8217;ve selected the range of data, all that&#8217;s left is to wait for Excel to transform it and once it&#8217;s done, your data will be viewed in the same format as the table you&#8217;ve selected before.<\/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. Impliment Cell Message Into Cells<\/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>When collaborating with others on a certain project, sometimes you want another user to avoid make changes to the cells you&#8217;ve made. To do this, you might want to put a cell message which will then pop up when someone click on the cell and display the message written on it.<\/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=\"522\" height=\"174\" src=\"https:\/\/www.mu.my\/files\/uploads\/Screenshot_1-4.png\" class=\"attachment-large size-large wp-image-63102\" alt=\"\" srcset=\"https:\/\/www.mu.my\/files\/uploads\/Screenshot_1-4.png 522w, https:\/\/www.mu.my\/files\/uploads\/Screenshot_1-4-300x100.png 300w\" sizes=\"(max-width: 522px) 100vw, 522px\" \/>\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>Select the cell or range of cells that you want to display the message.<\/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;\">Head towards the ribbon, go to <\/span><b>Data \u279c Data Tools <\/b><span style=\"font-weight: 400;\">and click the <\/span><b>Data Validation <\/b><span style=\"font-weight: 400;\">icon on the bottom right next to Text To Column.<\/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>Put in your message thread into the Input message box and once you have done, click 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=\"532\" height=\"194\" src=\"https:\/\/www.mu.my\/files\/uploads\/Screenshot_2-4.png\" class=\"attachment-large size-large wp-image-63100\" alt=\"\" srcset=\"https:\/\/www.mu.my\/files\/uploads\/Screenshot_2-4.png 532w, https:\/\/www.mu.my\/files\/uploads\/Screenshot_2-4-300x109.png 300w\" sizes=\"(max-width: 532px) 100vw, 532px\" \/>\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>When the message had been set in place, your message will be displayed like this.<\/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;\">Well, that&#8217;s all this section can offer for now. Thank you for taking your time visiting and revising this section. Want to know more? Head on to our main website at <\/span><a href=\"http:\/\/www.mu.my\/en\/\" target=\"_blank\" rel=\"noopener\"><span style=\"font-weight: 400;\">http:\/\/www.mu.my\/en\/<\/span><\/a><span style=\"font-weight: 400;\">, and register for our course training to know more about Microsoft Excel Tips. We also provided bonus formulas and functions for those who attend this course training.<\/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\">Other Post You Might've Interested<\/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-14129 post type-post status-publish format-standard has-post-thumbnail hentry category-news tag-excel tag-office\">\n\t\t\t\t<a class=\"elementor-post__thumbnail__link\" href=\"https:\/\/www.mu.my\/en\/news\/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-24361\" 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\/en\/news\/microsoft-excel-shortcuts-know\/\" >\n\t\t\t\tMicrosoft Excel Shortcuts That You Should Know\t\t\t<\/a>\n\t\t<\/h3>\n\t\t\t\t<div class=\"elementor-post__meta-data\">\n\t\t\t\t\t<span class=\"elementor-post-date\">\n\t\t\tJuly 31, 2017\t\t<\/span>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-post__excerpt\">\n\t\t\t<p>How many shortcuts do you know for Microsoft Excel? Learn these useful Excel shortcuts to save your time working on spreadsheets. Learn more at 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\/en\/news\/microsoft-excel-shortcuts-know\/\" aria-label=\"Read more about Microsoft Excel Shortcuts That You Should Know\" 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-13219 post type-post status-publish format-standard has-post-thumbnail hentry category-news tag-excel tag-office\">\n\t\t\t\t<a class=\"elementor-post__thumbnail__link\" href=\"https:\/\/www.mu.my\/en\/news\/what-is-a-pivottable\/\" 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\/greenpivottables-300x200.png\" class=\"attachment-medium size-medium wp-image-22756\" alt=\"\" srcset=\"https:\/\/www.mu.my\/files\/uploads\/greenpivottables-300x200.png 300w, https:\/\/www.mu.my\/files\/uploads\/greenpivottables-450x300.png 450w, https:\/\/www.mu.my\/files\/uploads\/greenpivottables.png 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\/en\/news\/what-is-a-pivottable\/\" >\n\t\t\t\tWhat is a PivotTable?\t\t\t<\/a>\n\t\t<\/h3>\n\t\t\t\t<div class=\"elementor-post__meta-data\">\n\t\t\t\t\t<span class=\"elementor-post-date\">\n\t\t\tJune 9, 2017\t\t<\/span>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-post__excerpt\">\n\t\t\t<p>PivotTable is one of the most powerful features in Excel. It will save you a lot of time to summarize your large, detailed data set<\/p>\n\t\t<\/div>\n\t\t\n\t\t<a class=\"elementor-post__read-more\" href=\"https:\/\/www.mu.my\/en\/news\/what-is-a-pivottable\/\" aria-label=\"Read more about What is a 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>Why You Should Consider Using These Advanced Tips? Some of us might have been familiar with Microsoft Excel. While others knew some basic functions or formulas. Regardless of which side you\u2019re in, there are still many tips and tricks when using the software that we might not know, let alone be aware of their purpose. &#8230; <a title=\"What is a PivotTable?\" class=\"read-more\" href=\"https:\/\/www.mu.my\/en\/news\/what-is-a-pivottable\/\" aria-label=\"Read more about What is a PivotTable?\">Read more<\/a><\/p>\n","protected":false},"author":11,"featured_media":62442,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[69],"tags":[153],"class_list":["post-58260","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-tutorials","tag-excel"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v24.1 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Advanced Tips in Microsoft Excel - MU DOT MY PLT<\/title>\n<meta name=\"description\" content=\"In this tutorial, I will list down some of the useful advanced tips when using Microsoft Excel that you can try and implement in your daily work.\" \/>\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\/en\/tutorials\/top-10-advanced-tips-in-microsoft-excel-en\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Advanced Tips in Microsoft Excel - MU DOT MY PLT\" \/>\n<meta property=\"og:description\" content=\"In this tutorial, I will list down some of the useful advanced tips when using Microsoft Excel that you can try and implement in your daily work.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.mu.my\/en\/tutorials\/top-10-advanced-tips-in-microsoft-excel-en\/\" \/>\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-21T00:33:16+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2020-03-17T07:29:23+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=\"9 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.mu.my\/en\/tutorials\/top-10-advanced-tips-in-microsoft-excel-en\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.mu.my\/en\/tutorials\/top-10-advanced-tips-in-microsoft-excel-en\/\"},\"author\":{\"name\":\"Reece Yong\",\"@id\":\"https:\/\/www.mu.my\/en\/#\/schema\/person\/c8301539619fa2f7c1a6bfda5fea023c\"},\"headline\":\"Advanced Tips in Microsoft Excel\",\"datePublished\":\"2020-02-21T00:33:16+00:00\",\"dateModified\":\"2020-03-17T07:29:23+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.mu.my\/en\/tutorials\/top-10-advanced-tips-in-microsoft-excel-en\/\"},\"wordCount\":1770,\"publisher\":{\"@id\":\"https:\/\/www.mu.my\/en\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.mu.my\/en\/tutorials\/top-10-advanced-tips-in-microsoft-excel-en\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.mu.my\/files\/uploads\/excel-training-2-768x425-1.png\",\"keywords\":[\"Excel\"],\"articleSection\":[\"Tutorials\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.mu.my\/en\/tutorials\/top-10-advanced-tips-in-microsoft-excel-en\/\",\"url\":\"https:\/\/www.mu.my\/en\/tutorials\/top-10-advanced-tips-in-microsoft-excel-en\/\",\"name\":\"Advanced Tips in Microsoft Excel - MU DOT MY PLT\",\"isPartOf\":{\"@id\":\"https:\/\/www.mu.my\/en\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.mu.my\/en\/tutorials\/top-10-advanced-tips-in-microsoft-excel-en\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.mu.my\/en\/tutorials\/top-10-advanced-tips-in-microsoft-excel-en\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.mu.my\/files\/uploads\/excel-training-2-768x425-1.png\",\"datePublished\":\"2020-02-21T00:33:16+00:00\",\"dateModified\":\"2020-03-17T07:29:23+00:00\",\"description\":\"In this tutorial, I will list down some of the useful advanced tips when using Microsoft Excel that you can try and implement in your daily work.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.mu.my\/en\/tutorials\/top-10-advanced-tips-in-microsoft-excel-en\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.mu.my\/en\/tutorials\/top-10-advanced-tips-in-microsoft-excel-en\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.mu.my\/en\/tutorials\/top-10-advanced-tips-in-microsoft-excel-en\/#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\/en\/tutorials\/top-10-advanced-tips-in-microsoft-excel-en\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.mu.my\/en\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Advanced Tips in Microsoft Excel\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.mu.my\/en\/#website\",\"url\":\"https:\/\/www.mu.my\/en\/\",\"name\":\"MU DOT MY PLT - ICT Training & Development Malaysia\",\"description\":\"extracting knowledge\",\"publisher\":{\"@id\":\"https:\/\/www.mu.my\/en\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.mu.my\/en\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.mu.my\/en\/#organization\",\"name\":\"MU DOT MY PLT\",\"url\":\"https:\/\/www.mu.my\/en\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.mu.my\/en\/#\/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\/en\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/facebook.com\/mudotmy\",\"https:\/\/x.com\/mudotmy\",\"https:\/\/instagram.com\/mudotmyplt\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.mu.my\/en\/#\/schema\/person\/c8301539619fa2f7c1a6bfda5fea023c\",\"name\":\"Reece Yong\",\"url\":\"https:\/\/www.mu.my\/en\/author\/reece-yong\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Advanced Tips in Microsoft Excel - MU DOT MY PLT","description":"In this tutorial, I will list down some of the useful advanced tips when using Microsoft Excel that you can try and implement in your daily work.","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\/en\/tutorials\/top-10-advanced-tips-in-microsoft-excel-en\/","og_locale":"en_US","og_type":"article","og_title":"Advanced Tips in Microsoft Excel - MU DOT MY PLT","og_description":"In this tutorial, I will list down some of the useful advanced tips when using Microsoft Excel that you can try and implement in your daily work.","og_url":"https:\/\/www.mu.my\/en\/tutorials\/top-10-advanced-tips-in-microsoft-excel-en\/","og_site_name":"MU DOT MY PLT - ICT Training & Development Malaysia","article_publisher":"https:\/\/facebook.com\/mudotmy","article_published_time":"2020-02-21T00:33:16+00:00","article_modified_time":"2020-03-17T07:29:23+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":"9 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.mu.my\/en\/tutorials\/top-10-advanced-tips-in-microsoft-excel-en\/#article","isPartOf":{"@id":"https:\/\/www.mu.my\/en\/tutorials\/top-10-advanced-tips-in-microsoft-excel-en\/"},"author":{"name":"Reece Yong","@id":"https:\/\/www.mu.my\/en\/#\/schema\/person\/c8301539619fa2f7c1a6bfda5fea023c"},"headline":"Advanced Tips in Microsoft Excel","datePublished":"2020-02-21T00:33:16+00:00","dateModified":"2020-03-17T07:29:23+00:00","mainEntityOfPage":{"@id":"https:\/\/www.mu.my\/en\/tutorials\/top-10-advanced-tips-in-microsoft-excel-en\/"},"wordCount":1770,"publisher":{"@id":"https:\/\/www.mu.my\/en\/#organization"},"image":{"@id":"https:\/\/www.mu.my\/en\/tutorials\/top-10-advanced-tips-in-microsoft-excel-en\/#primaryimage"},"thumbnailUrl":"https:\/\/www.mu.my\/files\/uploads\/excel-training-2-768x425-1.png","keywords":["Excel"],"articleSection":["Tutorials"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.mu.my\/en\/tutorials\/top-10-advanced-tips-in-microsoft-excel-en\/","url":"https:\/\/www.mu.my\/en\/tutorials\/top-10-advanced-tips-in-microsoft-excel-en\/","name":"Advanced Tips in Microsoft Excel - MU DOT MY PLT","isPartOf":{"@id":"https:\/\/www.mu.my\/en\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.mu.my\/en\/tutorials\/top-10-advanced-tips-in-microsoft-excel-en\/#primaryimage"},"image":{"@id":"https:\/\/www.mu.my\/en\/tutorials\/top-10-advanced-tips-in-microsoft-excel-en\/#primaryimage"},"thumbnailUrl":"https:\/\/www.mu.my\/files\/uploads\/excel-training-2-768x425-1.png","datePublished":"2020-02-21T00:33:16+00:00","dateModified":"2020-03-17T07:29:23+00:00","description":"In this tutorial, I will list down some of the useful advanced tips when using Microsoft Excel that you can try and implement in your daily work.","breadcrumb":{"@id":"https:\/\/www.mu.my\/en\/tutorials\/top-10-advanced-tips-in-microsoft-excel-en\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.mu.my\/en\/tutorials\/top-10-advanced-tips-in-microsoft-excel-en\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.mu.my\/en\/tutorials\/top-10-advanced-tips-in-microsoft-excel-en\/#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\/en\/tutorials\/top-10-advanced-tips-in-microsoft-excel-en\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.mu.my\/en\/"},{"@type":"ListItem","position":2,"name":"Advanced Tips in Microsoft Excel"}]},{"@type":"WebSite","@id":"https:\/\/www.mu.my\/en\/#website","url":"https:\/\/www.mu.my\/en\/","name":"MU DOT MY PLT - ICT Training & Development Malaysia","description":"extracting knowledge","publisher":{"@id":"https:\/\/www.mu.my\/en\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.mu.my\/en\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.mu.my\/en\/#organization","name":"MU DOT MY PLT","url":"https:\/\/www.mu.my\/en\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.mu.my\/en\/#\/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\/en\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/facebook.com\/mudotmy","https:\/\/x.com\/mudotmy","https:\/\/instagram.com\/mudotmyplt"]},{"@type":"Person","@id":"https:\/\/www.mu.my\/en\/#\/schema\/person\/c8301539619fa2f7c1a6bfda5fea023c","name":"Reece Yong","url":"https:\/\/www.mu.my\/en\/author\/reece-yong\/"}]}},"_links":{"self":[{"href":"https:\/\/www.mu.my\/en\/wp-json\/wp\/v2\/posts\/58260","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.mu.my\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.mu.my\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.mu.my\/en\/wp-json\/wp\/v2\/users\/11"}],"replies":[{"embeddable":true,"href":"https:\/\/www.mu.my\/en\/wp-json\/wp\/v2\/comments?post=58260"}],"version-history":[{"count":47,"href":"https:\/\/www.mu.my\/en\/wp-json\/wp\/v2\/posts\/58260\/revisions"}],"predecessor-version":[{"id":63108,"href":"https:\/\/www.mu.my\/en\/wp-json\/wp\/v2\/posts\/58260\/revisions\/63108"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.mu.my\/en\/wp-json\/wp\/v2\/media\/62442"}],"wp:attachment":[{"href":"https:\/\/www.mu.my\/en\/wp-json\/wp\/v2\/media?parent=58260"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.mu.my\/en\/wp-json\/wp\/v2\/categories?post=58260"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.mu.my\/en\/wp-json\/wp\/v2\/tags?post=58260"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}