{"id":26908,"date":"2020-07-23T16:14:07","date_gmt":"2020-07-23T09:14:07","guid":{"rendered":"https:\/\/fff.com.vn\/?p=26908"},"modified":"2020-08-07T14:47:14","modified_gmt":"2020-08-07T07:47:14","slug":"10-meo-su-dung-excel-ho-tro-cac-chien-dich-seo-va-ppc","status":"publish","type":"post","link":"https:\/\/fff.com.vn\/10-meo-su-dung-excel-ho-tro-cac-chien-dich-seo-va-ppc\/","title":{"rendered":"10 M\u1eb9o S\u1eed D\u1ee5ng Excel H\u1ed7 Tr\u1ee3 C\u00e1c Chi\u1ebfn D\u1ecbch SEO V\u00e0 PPC"},"content":{"rendered":"<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_17 counter-flat ez-toc-white\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\">M\u1ee5c l\u1ee5c<\/p>\n<span class=\"ez-toc-title-toggle\"><\/span><\/div>\n<nav><ul class=\"ez-toc-list ez-toc-list-level-1\"><li class=\"ez-toc-page-1\"><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/fff.com.vn\/10-meo-su-dung-excel-ho-tro-cac-chien-dich-seo-va-ppc\/#1_Tim_kiem_Thay_the\" title=\"1. T\u00ecm ki\u1ebfm\/ Thay th\u1ebf \">1. T\u00ecm ki\u1ebfm\/ Thay th\u1ebf <\/a><\/li><li class=\"ez-toc-page-1\"><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/fff.com.vn\/10-meo-su-dung-excel-ho-tro-cac-chien-dich-seo-va-ppc\/#2_Viet_hoa\" title=\"2. Vi\u1ebft hoa\">2. Vi\u1ebft hoa<\/a><\/li><li class=\"ez-toc-page-1\"><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/fff.com.vn\/10-meo-su-dung-excel-ho-tro-cac-chien-dich-seo-va-ppc\/#3_Xoa_khoang_trong_du\" title=\"3. X\u00f3a kho\u1ea3ng tr\u1ed1ng d\u01b0\">3. X\u00f3a kho\u1ea3ng tr\u1ed1ng d\u01b0<\/a><\/li><li class=\"ez-toc-page-1\"><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/fff.com.vn\/10-meo-su-dung-excel-ho-tro-cac-chien-dich-seo-va-ppc\/#4_Gop_cac_gia_tri_vao_mot_o\" title=\"4. G\u1ed9p c\u00e1c gi\u00e1 tr\u1ecb v\u00e0o m\u1ed9t \u00f4\">4. G\u1ed9p c\u00e1c gi\u00e1 tr\u1ecb v\u00e0o m\u1ed9t \u00f4<\/a><\/li><li class=\"ez-toc-page-1\"><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/fff.com.vn\/10-meo-su-dung-excel-ho-tro-cac-chien-dich-seo-va-ppc\/#5_Kieu_Ket_Hop\" title=\"5. Ki\u1ec3u K\u1ebft H\u1ee3p\">5. Ki\u1ec3u K\u1ebft H\u1ee3p<\/a><\/li><li class=\"ez-toc-page-1\"><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/fff.com.vn\/10-meo-su-dung-excel-ho-tro-cac-chien-dich-seo-va-ppc\/#6_Tong\" title=\"6. T\u1ed5ng\">6. T\u1ed5ng<\/a><\/li><li class=\"ez-toc-page-1\"><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/fff.com.vn\/10-meo-su-dung-excel-ho-tro-cac-chien-dich-seo-va-ppc\/#7_Cuon_len_va_xuong\" title=\"7. Cu\u1ed9n l\u00ean v\u00e0 xu\u1ed1ng\">7. Cu\u1ed9n l\u00ean v\u00e0 xu\u1ed1ng<\/a><\/li><li class=\"ez-toc-page-1\"><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/fff.com.vn\/10-meo-su-dung-excel-ho-tro-cac-chien-dich-seo-va-ppc\/#8_Dinh_dang_phan_tram\" title=\"8. \u0110\u1ecbnh d\u1ea1ng ph\u1ea7n tr\u0103m\">8. \u0110\u1ecbnh d\u1ea1ng ph\u1ea7n tr\u0103m<\/a><\/li><li class=\"ez-toc-page-1\"><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/fff.com.vn\/10-meo-su-dung-excel-ho-tro-cac-chien-dich-seo-va-ppc\/#9_Dinh_dang_tien_te\" title=\"9. \u0110\u1ecbnh d\u1ea1ng ti\u1ec1n t\u1ec7\">9. \u0110\u1ecbnh d\u1ea1ng ti\u1ec1n t\u1ec7<\/a><\/li><li class=\"ez-toc-page-1\"><a class=\"ez-toc-link ez-toc-heading-10\" href=\"https:\/\/fff.com.vn\/10-meo-su-dung-excel-ho-tro-cac-chien-dich-seo-va-ppc\/#10_Ap_dung_1_cong_thuc_cho_nhieu_o\" title=\"10. \u00c1p d\u1ee5ng 1 c\u00f4ng th\u1ee9c cho nhi\u1ec1u \u00f4\">10. \u00c1p d\u1ee5ng 1 c\u00f4ng th\u1ee9c cho nhi\u1ec1u \u00f4<\/a><\/li><\/ul><\/nav><\/div>\n\n<p>Microsoft Excel t\u1eeb l\u00e2u \u0111\u00e3 \u0111\u01b0\u1ee3c bi\u1ebft l\u00e0 m\u1ed9t ph\u1ea7n m\u1ec1m d\u00e0nh cho s\u1ed5 s\u00e1ch v\u00e0 t\u00ednh to\u00e1n. Tuy nhi\u00ean, \u0111\u1ed1i v\u1edbi c\u00e1c nh\u00e0 qu\u1ea3ng c\u00e1o, n\u00f3 c\u00f2n r\u1ea5t h\u1eefu d\u1ee5ng khi d\u00f9ng \u0111\u1ec3 theo d\u00f5i ph\u00e2n t\u00edch v\u00e0 ho\u1ea1t \u0111\u1ed9ng c\u1ee7a chi\u1ebfn d\u1ecbch marketing. Nh\u1edd v\u00e0o t\u00ednh linh ho\u1ea1t v\u00e0 kh\u1ea3 n\u0103ng x\u1eed l\u00fd d\u1eef li\u1ec7u c\u1ef1c t\u1ed1t. Nh\u01b0ng c\u00f3 th\u1ec3 b\u1ea1n v\u1eabn ch\u01b0a bi\u1ebft h\u1ebft \u0111\u01b0\u1ee3c nh\u1eefng \u01b0u \u0111i\u1ec3m v\u01b0\u1ee3t tr\u1ed9i c\u1ee7a Excel trong vi\u1ec7c thay th\u1ebf nh\u1eefng c\u00f4ng vi\u1ec7c th\u1ee7 c\u00f4ng m\u00e0 b\u1ea1n ph\u1ea3i t\u1ed1n h\u00e0ng ng\u00e0y, h\u00e0ng gi\u1edd \u0111\u1ec3 ho\u00e0n th\u00e0nh. H\u00f4m nay, FFF s\u1ebd b\u1eadt m\u00ed cho b\u1ea1n<strong> 10 m\u1eb9o s\u1eed d\u1ee5ng Excel h\u1ed7 tr\u1ee3 c\u00e1c chi\u1ebfn d\u1ecbch SEO v\u00e0 PPC<\/strong> nh\u00e9.<\/p>\n\n\n\n<h2><span class=\"ez-toc-section\" id=\"1_Tim_kiem_Thay_the\"><\/span>1. T\u00ecm ki\u1ebfm\/ Thay th\u1ebf <span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>C\u00e1c t\u00ednh n\u0103ng T\u00ecm ki\u1ebfm v\u00e0 Thay th\u1ebf c\u01a1 b\u1ea3n c\u1ee7a Microsoft ho\u1ea1t \u0111\u1ed9ng s\u1ebd t\u1ed1n nhi\u1ec1u th\u1eddi gian h\u01a1n b\u1ea1n mu\u1ed1n. C\u00f4ng th\u1ee9c SUBSTITUTE s\u1ebd l\u00e0 m\u1ed9t trong c\u00e1c m\u1eb9o Excel gi\u00fap b\u1ea1n kh\u1eafc ph\u1ee5c \u0111i\u1ec1u \u0111\u00f3 m\u1ed9t c\u00e1ch nhanh ch\u00f3ng . B\u1eb1ng c\u00e1ch nh\u1eadp c\u00e1c c\u00f4ng th\u1ee9c \u0111\u01a1n gi\u1ea3n, b\u1ea1n c\u00f3 th\u1ec3 t\u0103ng t\u1ed1c th\u1eddi gian \u0111\u1ec3 Excel c\u00f3 th\u1ec3 t\u00ecm v\u00e0 thay th\u1ebf c\u00e1c gi\u00e1 tr\u1ecb \u0111\u01b0\u1ee3c ch\u1ecdn. B\u1ea1n c\u00f3 th\u1ec3 l\u00e0m nh\u01b0 v\u1eady c\u00f9ng l\u00fac v\u1edbi nhi\u1ec1u gi\u00e1 tr\u1ecb kh\u00e1c nhau v\u00e0 ch\u1ec9 \u0111\u1ecbnh c\u00e2u l\u1ec7nh cho ch\u00fang. C\u00f4ng th\u1ee9c l\u00e0:<\/p>\n\n\n\n<p><strong>= SUBSTITUTE(A1,\u201doriginalvalue\u201d,\u201dreplacementvalue\u201d)(originalvalue: gi\u00e1 tr\u1ecb g\u1ed1c, replacementvalue: gi\u00e1 tr\u1ecb thay th\u1ebf cho gi\u00e1 tr\u1ecb g\u1ed1c).<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" width=\"901\" height=\"662\" src=\"https:\/\/fff.com.vn\/wp-content\/uploads\/2020\/07\/10-meo-su-dung-Excel-ho-tro-cac-chien-dich-SEO-va-PPC-1.png\" alt=\"\" class=\"wp-image-26916\" srcset=\"https:\/\/fff.com.vn\/wp-content\/uploads\/2020\/07\/10-meo-su-dung-Excel-ho-tro-cac-chien-dich-SEO-va-PPC-1.png 901w, https:\/\/fff.com.vn\/wp-content\/uploads\/2020\/07\/10-meo-su-dung-Excel-ho-tro-cac-chien-dich-SEO-va-PPC-1-480x353.png 480w\" sizes=\"(min-width: 0px) and (max-width: 480px) 480px, (min-width: 481px) 901px, 100vw\" \/><\/figure>\n\n\n\n<h2><span class=\"ez-toc-section\" id=\"2_Viet_hoa\"><\/span>2. Vi\u1ebft hoa<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Khi l\u00e0m vi\u1ec7c v\u1edbi Excel, b\u1ea1n \u0111\u00e3 t\u1eebng g\u1eb7p tr\u01b0\u1eddng h\u1ee3p nh\u1eadp r\u1ea5t nhi\u1ec1u th\u00f4ng tin h\u1ecd v\u00e0 t\u00ean. Vi\u1ec7c nh\u1eadp h\u1ecd v\u00e0 t\u00ean b\u1ea1n ph\u1ea3i nh\u1eadp theo chu\u1ea9n, \u0111\u00f3 l\u00e0 ph\u1ea3i vi\u1ebft hoa 1 ch\u1eef c\u00e1i \u0111\u1ea7u. Tuy nhi\u00ean, n\u1ebfu b\u1ea1n g\u00f5 l\u1ea7n l\u01b0\u1ee3t th\u00ec s\u1ebd l\u00e0m cho c\u00f4ng vi\u1ec7c c\u1ee7a b\u1ea1n b\u1ecb ch\u1eadm tr\u1ec5. V\u1edbi h\u00e0m PROPER trong Excel \u0111\u1ec3 vi\u1ebft hoa ch\u1eef c\u00e1i \u0111\u1ea7u, v\u1eeba ti\u1ec7n d\u1ee5ng v\u1eeba kh\u00f4ng t\u1ed1n th\u1eddi gian.<\/p>\n\n\n\n<p><strong>C\u00f4ng th\u1ee9c l\u00e0: =PROPER(A1)<\/strong><\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-full\"><img loading=\"lazy\" width=\"631\" height=\"277\" src=\"https:\/\/fff.com.vn\/wp-content\/uploads\/2020\/07\/10-meo-su-dung-Excel-ho-tro-cac-chien-dich-SEO-va-PPC-2.png\" alt=\"\" class=\"wp-image-26915\" srcset=\"https:\/\/fff.com.vn\/wp-content\/uploads\/2020\/07\/10-meo-su-dung-Excel-ho-tro-cac-chien-dich-SEO-va-PPC-2.png 631w, https:\/\/fff.com.vn\/wp-content\/uploads\/2020\/07\/10-meo-su-dung-Excel-ho-tro-cac-chien-dich-SEO-va-PPC-2-480x211.png 480w\" sizes=\"(min-width: 0px) and (max-width: 480px) 480px, (min-width: 481px) 631px, 100vw\" \/><\/figure><\/div>\n\n\n\n<h2><span class=\"ez-toc-section\" id=\"3_Xoa_khoang_trong_du\"><\/span>3. X\u00f3a kho\u1ea3ng tr\u1ed1ng d\u01b0<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Trong qu\u00e1 tr\u00ecnh \u0111\u00e1nh v\u0103n b\u1ea3n, kh\u00f4ng th\u1ec3 tr\u00e1nh kh\u1ecfi vi\u1ec7c d\u01b0 th\u1eeba kho\u1ea3ng tr\u1ed1ng, b\u1ea1n kh\u00f4ng th\u1ec3 n\u00e0o r\u00e0 so\u00e1t h\u1ebft l\u1ea1i v\u00e0 s\u1eeda v\u00ec n\u00f3 r\u1ea5t t\u1ed1n th\u1eddi gian. M\u1eb9o Excel ti\u1ebfp theo ch\u00ednh l\u00e0 c\u00f4ng th\u1ee9c TRIM s\u1ebd gi\u00fap b\u1ea1n l\u00e0m \u0111i\u1ec1u \u0111\u00f3 ch\u1ec9 trong v\u00e0i thao t\u00e1c \u0111\u01a1n gi\u1ea3n. TRIM s\u1ebd x\u00f3a kho\u1ea3ng tr\u1eafng th\u1eeba kh\u1ecfi v\u0103n b\u1ea3n. Do \u0111\u00f3, n\u00f3 s\u1ebd ch\u1ec9 \u0111\u1ec3 l\u1ea1i c\u00e1c kho\u1ea3ng tr\u1ed1ng duy nh\u1ea5t gi\u1eefa c\u00e1c t\u1eeb v\u00e0 kh\u00f4ng c\u00f3 k\u00fd t\u1ef1 kho\u1ea3ng tr\u1eafng \u1edf \u0111\u1ea7u ho\u1eb7c cu\u1ed1i v\u0103n b\u1ea3n. N\u00f3 r\u1ea5t h\u1eefu \u00edch khi d\u1ecdn d\u1eb9p v\u0103n b\u1ea3n t\u1eeb c\u00e1c \u1ee9ng d\u1ee5ng ho\u1eb7c m\u00f4i tr\u01b0\u1eddng kh\u00e1c.<\/p>\n\n\n\n<p><strong>C\u00f4ng th\u1ee9c: =TRIM(A1)<\/strong><\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-full\"><img loading=\"lazy\" width=\"1008\" height=\"505\" src=\"https:\/\/fff.com.vn\/wp-content\/uploads\/2020\/07\/10-meo-su-dung-Excel-ho-tro-cac-chien-dich-SEO-va-PPC-3.png\" alt=\"\" class=\"wp-image-26914\" srcset=\"https:\/\/fff.com.vn\/wp-content\/uploads\/2020\/07\/10-meo-su-dung-Excel-ho-tro-cac-chien-dich-SEO-va-PPC-3.png 1008w, https:\/\/fff.com.vn\/wp-content\/uploads\/2020\/07\/10-meo-su-dung-Excel-ho-tro-cac-chien-dich-SEO-va-PPC-3-980x491.png 980w, https:\/\/fff.com.vn\/wp-content\/uploads\/2020\/07\/10-meo-su-dung-Excel-ho-tro-cac-chien-dich-SEO-va-PPC-3-480x240.png 480w\" sizes=\"(min-width: 0px) and (max-width: 480px) 480px, (min-width: 481px) and (max-width: 980px) 980px, (min-width: 981px) 1008px, 100vw\" \/><\/figure><\/div>\n\n\n\n<h2><span class=\"ez-toc-section\" id=\"4_Gop_cac_gia_tri_vao_mot_o\"><\/span>4. G\u1ed9p c\u00e1c gi\u00e1 tr\u1ecb v\u00e0o m\u1ed9t \u00f4<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Trong b\u1ea3ng t\u00ednh Excel c\u1ee7a b\u1ea1n, d\u1eef li\u1ec7u kh\u00f4ng ph\u1ea3i l\u00fac n\u00e0o c\u0169ng \u0111\u01b0\u1ee3c c\u1ea5u tr\u00fac theo nhu c\u1ea7u c\u1ee7a b\u1ea1n. Th\u01b0\u1eddng th\u00ec b\u1ea1n c\u00f3 th\u1ec3 mu\u1ed1n chia n\u1ed9i dung c\u1ee7a m\u1ed9t \u00f4 th\u00e0nh nhi\u1ec1u \u00f4, ho\u1eb7c l\u00e0m ng\u01b0\u1ee3c l\u1ea1i \u2013 k\u1ebft h\u1ee3p d\u1eef li\u1ec7u t\u1eeb hai c\u1ed9t tr\u1edf l\u00ean v\u00e0o m\u1ed9t c\u1ed9t \u0111\u01a1n. V\u00ed d\u1ee5 ph\u1ed5 bi\u1ebfn v\u1ec1 vi\u1ec7c ph\u1ea3i gh\u00e9p n\u1ed1i trong Excel l\u00e0 nh\u1eadp t\u00ean v\u00e0 \u0111\u1ecba ch\u1ec9, k\u1ebft h\u1ee3p v\u0103n b\u1ea3n v\u1edbi gi\u00e1 tr\u1ecb \u0111\u01b0\u1ee3c \u0111\u1ecbnh h\u01b0\u1edbng b\u1eb1ng c\u00f4ng th\u1ee9c, hi\u1ec3n th\u1ecb ng\u00e0y v\u00e0 gi\u1edd v\u1edbi \u0111\u1ecbnh d\u1ea1ng mong mu\u1ed1n, \u0111\u1ec3 \u0111\u1eb7t t\u00ean. M\u1eb9o trong Excel, khi c\u1ea7n n\u1ed1i c\u00e1c k\u00fd t\u1ef1 \u1edf c\u00e1c c\u1ed9t d\u1eef li\u1ec7u trong 1 b\u1ea3ng, ch\u00fang ta s\u1ebd s\u1eed d\u1ee5ng h\u00e0m ConcateNate. H\u00e0m s\u1ebd gi\u00fap ng\u01b0\u1eddi d\u00f9ng li\u00ean k\u1ebft t\u1eebng k\u00fd t\u1ef1 \u1edf t\u1eebng c\u1ed9t v\u00e0 t\u1ea1o th\u00e0nh 1 chu\u1ed7i k\u00fd t\u1ef1 ho\u00e0n ch\u1ec9nh, theo nhu c\u1ea7u c\u1ee7a ng\u01b0\u1eddi d\u00f9ng<\/p>\n\n\n\n<p><strong>C\u00f4ng th\u1ee9c: =A1&amp;\u201dtext\u201d&amp;B1<\/strong><\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-full\"><img loading=\"lazy\" width=\"478\" height=\"213\" src=\"https:\/\/fff.com.vn\/wp-content\/uploads\/2020\/07\/10-meo-su-dung-Excel-ho-tro-cac-chien-dich-SEO-va-PPC-4.png\" alt=\"\" class=\"wp-image-26913\" srcset=\"https:\/\/fff.com.vn\/wp-content\/uploads\/2020\/07\/10-meo-su-dung-Excel-ho-tro-cac-chien-dich-SEO-va-PPC-4.png 478w, https:\/\/fff.com.vn\/wp-content\/uploads\/2020\/07\/10-meo-su-dung-Excel-ho-tro-cac-chien-dich-SEO-va-PPC-4-476x212.png 476w\" sizes=\"(max-width: 478px) 100vw, 478px\" \/><\/figure><\/div>\n\n\n\n<h2><span class=\"ez-toc-section\" id=\"5_Kieu_Ket_Hop\"><\/span>5. Ki\u1ec3u K\u1ebft H\u1ee3p<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>\u0110\u00f4i l\u00fac, ch\u00fang ta c\u00f3 nhi\u1ec1u v\u1ea5n \u0111\u1ec1, gi\u00e1 tr\u1ecb kh\u00e1c nhau c\u1ea7n gi\u1ea3i quy\u1ebft c\u00f9ng m\u1ed9t l\u00fac. Khi \u0111\u00f3, ch\u00fang ta c\u00f3 th\u1ec3 k\u1ebft h\u1ee3p nhi\u1ec1u c\u00f4ng th\u1ee9c l\u1ea1i v\u1edbi nhau \u0111\u1ec3 gi\u1ea3i quy\u1ebft \u0111\u01b0\u1ee3c c\u00f9ng l\u00fac nhi\u1ec1u v\u1ea5n \u0111\u1ec1. Ch\u00fang ta c\u00f3 th\u1ec3 t\u1eadn d\u1ee5ng \u0111\u01b0\u1ee3c \u0111i\u1ec3m m\u1ea1nh c\u1ee7a c\u00e1c c\u00f4ng th\u1ee9c v\u00e0 k\u1ebft h\u1ee3p ch\u00fang l\u1ea1i nh\u01b0 TRIM, SUBSTITUTE v\u00e0 CONCATENATE.<\/p>\n\n\n\n<ul><li><strong>C\u00f4ng th\u1ee9c cho kh\u1edbp ch\u00ednh x\u00e1c: =\u201d[\u201c&amp;TRIM(A1)&amp;\u201d]\u201d<\/strong><\/li><li><strong>C\u00f4ng th\u1ee9c cho c\u1ee5m t\u1eeb ph\u00f9 h\u1ee3p: =\u201d\u201d\u201d&amp;TRIM(A1)&amp;\u201d\u201d\u201d<\/strong><\/li><li><strong>C\u00f4ng th\u1ee9c cho s\u1eeda \u0111\u1ed5i k\u1ebft h\u1ee3p r\u1ed9ng: =\u201d+\u201d&amp;SUBSTITUTE(TRIM(A1),\u201d\u201d,\u201d+)<\/strong><\/li><\/ul>\n\n\n\n<h2><span class=\"ez-toc-section\" id=\"6_Tong\"><\/span>6. T\u1ed5ng<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>C\u00f4ng th\u1ee9c SUM, \u0111\u00e2y l\u00e0 c\u00f4ng th\u1ee9c gi\u00fap ch\u00fang ta t\u00ednh t\u1ed5ng m\u1ed9t c\u00e1ch nhanh ch\u00f3ng m\u00e0 kh\u00f4ng c\u1ea7n ph\u1ea3i m\u1ea5t th\u1eddi gian \u0111\u1ec3 ng\u1ed3i c\u1ed9ng t\u1eebng \u00f4. Ch\u1ec9 c\u1ea7n m\u1ed9t v\u00e0i thao t\u00e1c \u0111\u01a1n gi\u1ea3n nh\u01b0 sau:<\/p>\n\n\n\n<ul><li><strong>B\u01b0\u1edbc 1: \u0111\u1eb7t con tr\u1ecf b\u00ean d\u01b0\u1edbi c\u1ed9t s\u1ed1 b\u1ea1n mu\u1ed1n t\u00ednh t\u1ed5ng(ho\u1eb7c \u1edf b\u00ean tr\u00e1i c\u1ee7a h\u00e0ng s\u1ed1 b\u1ea1n mu\u1ed1n t\u00ednh t\u1ed5ng).<\/strong><\/li><li><strong>B\u01b0\u1edbc 2: gi\u1eef n\u00fat Alt sau \u0111\u00f3 \u1ea5n k\u00fd hi\u1ec7u = trong khi gi\u1eef n\u00fat Alt.<\/strong><\/li><li><strong>B\u01b0\u1edbc 3: nh\u1ea5n Enter.<\/strong><\/li><\/ul>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-full\"><img loading=\"lazy\" width=\"307\" height=\"159\" src=\"https:\/\/fff.com.vn\/wp-content\/uploads\/2020\/07\/10-meo-su-dung-Excel-ho-tro-cac-chien-dich-SEO-va-PPC-6.jpg\" alt=\"\" class=\"wp-image-26911\"\/><\/figure><\/div>\n\n\n\n<h2><span class=\"ez-toc-section\" id=\"7_Cuon_len_va_xuong\"><\/span>7. Cu\u1ed9n l\u00ean v\u00e0 xu\u1ed1ng<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>B\u1ea3ng t\u00ednh c\u1ee7a b\u1ea1n th\u01b0\u1eddng t\u1edbi h\u00e0ng ng\u00e0n d\u00f2ng d\u00e0i. N\u1ebfu b\u1ea1n \u1edf d\u00f2ng 2034 v\u00e0 mu\u1ed1n quan s\u00e1t d\u1eef li\u1ec7u ho\u1eb7c g\u00ec \u0111\u00f3 \u1edf d\u00f2ng 8, b\u1ea1n c\u1ea7n c\u00e1ch d\u1ec5 h\u01a1n \u0111\u1ec3 chuy\u1ec3n t\u1edbi \u0111\u00f3. Ch\u1ee9c n\u0103ng t\u1eeb kh\u00f3a Quick Scroll l\u00e0 gi\u1ea3i ph\u00e1p h\u1eefu hi\u1ec7u gi\u00fap b\u1ea1n l\u00e0m \u0111i\u1ec1u \u0111\u00f3 nhanh h\u01a1n. N\u1ebfu b\u1ea1n ch\u1ecdn c\u00e1c \u00f4 t\u1eeb n\u01a1i b\u1eaft \u0111\u1ea7u v\u00e0 n\u01a1i k\u1ebft th\u00fac, b\u1ea1n c\u00f3 th\u1ec3 d\u00f9ng c\u00e1c t\u1ed5 h\u1ee3p gi\u1ed1ng nhau nh\u01b0ng ph\u1ea3i c\u0169ng c\u1ea7n ph\u1ea3i th\u00eam SHIFT . T\u1ed5 h\u1ee3p ph\u00edm t\u1eaft \u0111\u00f3 l\u00e0:<\/p>\n\n\n\n<ul><li><strong>\u0110\u1ec3 chuy\u1ec3n l\u00ean: CTRL+m\u0169i t\u00ean l\u00ean<\/strong><\/li><li><strong>\u0110\u1ec3 chuy\u1ec3n xu\u1ed1ng: CTRL+m\u0169i t\u00ean xu\u1ed1ng<\/strong><\/li><\/ul>\n\n\n\n<h2><span class=\"ez-toc-section\" id=\"8_Dinh_dang_phan_tram\"><\/span>8. \u0110\u1ecbnh d\u1ea1ng ph\u1ea7n tr\u0103m<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Khi nh\u1eadp d\u1eef li\u1ec7u, b\u1ea1n kh\u00f4ng mu\u1ed1n ph\u1ea3i tr\u1ea3i qua nhi\u1ec1u b\u01b0\u1edbc v\u00e0 h\u1ed9p tho\u1ea1i ch\u1ec9 \u0111\u1ec3 th\u00eam m\u1ed9t d\u1ea5u hi\u1ec7u % T\u1ed5 h\u1ee3p ph\u00edm t\u1eaft l\u00e0: <strong>CRTL SHIFT 5<\/strong> s\u1ebd gi\u00fap b\u1ea1n l\u00e0m \u0111i\u1ec1u \u0111\u00f3 m\u1ed9t c\u00e1ch nhanh ch\u00f3ng v\u00e0 d\u1ec5 d\u00e0ng.<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-full\"><img loading=\"lazy\" width=\"600\" height=\"450\" src=\"https:\/\/fff.com.vn\/wp-content\/uploads\/2020\/07\/10-meo-su-dung-Excel-ho-tro-cac-chien-dich-SEO-va-PPC-8.png\" alt=\"\" class=\"wp-image-26912\" srcset=\"https:\/\/fff.com.vn\/wp-content\/uploads\/2020\/07\/10-meo-su-dung-Excel-ho-tro-cac-chien-dich-SEO-va-PPC-8.png 600w, https:\/\/fff.com.vn\/wp-content\/uploads\/2020\/07\/10-meo-su-dung-Excel-ho-tro-cac-chien-dich-SEO-va-PPC-8-480x360.png 480w\" sizes=\"(min-width: 0px) and (max-width: 480px) 480px, (min-width: 481px) 600px, 100vw\" \/><\/figure><\/div>\n\n\n\n<h2><span class=\"ez-toc-section\" id=\"9_Dinh_dang_tien_te\"><\/span>9. \u0110\u1ecbnh d\u1ea1ng ti\u1ec1n t\u1ec7<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Tr\u01b0\u01a1ng t\u1ef1 nh\u01b0 \u0111\u1ecbnh d\u1ea1ng ph\u1ea7n tr\u0103m, n\u1ebfu b\u1ea1n mu\u1ed1n th\u1ec3 hi\u1ec7n s\u1ed1 d\u01b0\u1edbi d\u1ea1ng ti\u1ec1n t\u1ec7 b\u1ea1n ph\u1ea3i \u0111\u1ecbnh d\u1ea1ng c\u00e1c s\u1ed1 ki\u1ec3u ti\u1ec1n t\u1ec7. \u0110\u1ec3 th\u1ef1c hi\u1ec7n \u0111i\u1ec1u n\u00e0y ch\u1ec9 c\u1ea7n s\u1eed d\u1ee5ng t\u1ed5 h\u1ee3p ph\u00edm<strong> CTRL SHIFT 5<\/strong><\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-full\"><img loading=\"lazy\" width=\"900\" height=\"371\" src=\"https:\/\/fff.com.vn\/wp-content\/uploads\/2020\/07\/10-meo-su-dung-Excel-ho-tro-cac-chien-dich-SEO-va-PPC-9.png\" alt=\"\" class=\"wp-image-26917\" srcset=\"https:\/\/fff.com.vn\/wp-content\/uploads\/2020\/07\/10-meo-su-dung-Excel-ho-tro-cac-chien-dich-SEO-va-PPC-9.png 900w, https:\/\/fff.com.vn\/wp-content\/uploads\/2020\/07\/10-meo-su-dung-Excel-ho-tro-cac-chien-dich-SEO-va-PPC-9-480x198.png 480w\" sizes=\"(min-width: 0px) and (max-width: 480px) 480px, (min-width: 481px) 900px, 100vw\" \/><\/figure><\/div>\n\n\n\n<h2><span class=\"ez-toc-section\" id=\"10_Ap_dung_1_cong_thuc_cho_nhieu_o\"><\/span>10. \u00c1p d\u1ee5ng 1 c\u00f4ng th\u1ee9c cho nhi\u1ec1u \u00f4<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Trong r\u1ea5t nhi\u1ec1u tr\u01b0\u1eddng h\u1ee3p, b\u1ea1n mu\u1ed1n g\u00e1n c\u00f4ng th\u1ee9c gi\u1ed1ng nhau cho nhi\u1ec1u \u00f4 nh\u01b0ng b\u1ea1n kh\u00f4ng mu\u1ed1n t\u1ed1n nhi\u1ec1u th\u1eddi gian \u0111\u1ec3 nh\u1eadp th\u1ee7 c\u00f4ng. B\u1ea1n kh\u00f4ng c\u1ea7n ph\u1ea3i lo l\u1eafng v\u00ec \u0111\u00e3 c\u00f3 Ph\u00edm t\u1eaft L\u1eadp l\u1ea1i c\u00f4ng th\u1ee9c gi\u00fap b\u1ea1n l\u00e0m \u0111i\u1ec1u \u0111\u00f3 . B\u1ea1n ch\u1ec9 c\u1ea7n nh\u1eadp c\u00f4ng th\u1ee9c c\u1ee7a b\u1ea1n v\u00e0o \u00f4 \u0111\u1ea7u ti\u00ean c\u1ee7a m\u1ed9t c\u1ed9t v\u00e0 sau \u0111\u00f3 b\u1ea1n c\u00f3 th\u1ec3 sao ch\u00e9p n\u00f3 ra t\u1eeb \u00f4 \u0111\u00f3.<\/p>\n\n\n\n<p>\u0110\u1ec3 th\u1ef1c hi\u1ec7n, b\u1ea1n \u0111\u01b0a con tr\u1ecf \u1edf ph\u00eda d\u01b0\u1edbi b\u00ean ph\u1ea3i c\u1ee7a \u00f4 \u0111\u1ea7u ti\u00ean, \u0111\u1ee3i d\u1ea5u + xu\u1ea5t hi\u1ec7n . Nh\u1ea5p \u0111\u00fap \u0111\u1ec3 sao ch\u00e9p<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-full\"><img loading=\"lazy\" width=\"313\" height=\"161\" src=\"https:\/\/fff.com.vn\/wp-content\/uploads\/2020\/07\/10-meo-su-dung-Excel-ho-tro-cac-chien-dich-SEO-va-PPC-10.png\" alt=\"\" class=\"wp-image-26925\"\/><\/figure><\/div>\n\n\n\n<p>Tr\u00ean \u0111\u00e2y l\u00e0 <strong>10 m\u1eb9o s\u1eed d\u1ee5ng Excel h\u1ed7 tr\u1ee3 c\u00e1c chi\u1ebfn d\u1ecbch SEO v\u00e0 PPC<\/strong>. FFF hi v\u1ecdng r\u1eb1ng c\u00f3 th\u1ec3 cung c\u1ea5p cho b\u1ea1n nhi\u1ec1u ki\u1ebfn th\u1ee9c b\u1ed5 \u00edch v\u1ec1 Excel \u0111\u1ec3 gi\u00fap b\u1ea1n c\u00f3 th\u1ec3 ti\u1ebft ki\u1ec7m th\u1eddi gian v\u00e0 c\u1ea3i thi\u1ec7n ch\u1ea5t l\u01b0\u1ee3ng c\u00f4ng vi\u1ec7c h\u01a1n. \u0110\u1eebng qu\u00ean ti\u1ebfp t\u1ee5c theo d\u00f5i c\u00e1c m\u1eb9o hay v\u1ec1 marketing online <a href=\"https:\/\/fff.com.vn\/category\/huong-dan\/\">t\u1ea1i blog<\/a> c\u1ee7a FFF<\/p>\n\n\n\n<p>N\u1ebfu b\u1ea1n c\u1ea7n s\u1ef1 tr\u1ee3 gi\u00fap ho\u1eb7c c\u00f3 v\u1ea5n \u0111\u1ec1 c\u1ea7n trao \u0111\u1ed5i v\u1edbi chuy\u00ean gia c\u1ee7a 3F, h\u00e3y li\u00ean h\u1ec7 v\u1edbi ch\u00fang t\u00f4i qua s\u1ed1 hotline<strong> 0901 47 48 46<\/strong> ho\u1eb7c trang <a href=\"https:\/\/www.facebook.com\/fff.com.vn\/\">fanpage ch\u00ednh th\u1ee9c c\u1ee7a FFF.<\/a> Ngo\u00e0i ra, h\u00e3y tham gia <a href=\"https:\/\/www.facebook.com\/fff.com.vn\">C\u1ed9ng \u0111\u1ed3ng Google AdWords Vi\u1ec7t Nam<\/a> \u0111\u1ec3 nh\u1eadn th\u00eam th\u00f4ng tin hay t\u1eeb c\u00e1c th\u00e0nh vi\u00ean trong c\u1ed9ng \u0111\u1ed3ng nh\u00e9!<\/p>\n","protected":false},"excerpt":{"rendered":"<p>M\u1ee5c l\u1ee5c 1. T\u00ecm ki\u1ebfm\/ Thay th\u1ebf 2. Vi\u1ebft hoa3. X\u00f3a kho\u1ea3ng tr\u1ed1ng d\u01b04. G\u1ed9p c\u00e1c gi\u00e1 tr\u1ecb v\u00e0o m\u1ed9t \u00f45. Ki\u1ec3u K\u1ebft H\u1ee3p6. T\u1ed5ng7. Cu\u1ed9n l\u00ean v\u00e0 xu\u1ed1ng8. \u0110\u1ecbnh d\u1ea1ng ph\u1ea7n tr\u0103m9. \u0110\u1ecbnh d\u1ea1ng ti\u1ec1n t\u1ec710. \u00c1p d\u1ee5ng 1 c\u00f4ng th\u1ee9c cho nhi\u1ec1u \u00f4 Microsoft Excel t\u1eeb l\u00e2u \u0111\u00e3 \u0111\u01b0\u1ee3c bi\u1ebft l\u00e0 m\u1ed9t ph\u1ea7n [&hellip;]<\/p>\n","protected":false},"author":706,"featured_media":26932,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_et_pb_use_builder":"","_et_pb_old_content":"","_et_gb_content_width":""},"categories":[1190,1,1176],"tags":[1197,614],"_links":{"self":[{"href":"https:\/\/fff.com.vn\/wp-json\/wp\/v2\/posts\/26908"}],"collection":[{"href":"https:\/\/fff.com.vn\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/fff.com.vn\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/fff.com.vn\/wp-json\/wp\/v2\/users\/706"}],"replies":[{"embeddable":true,"href":"https:\/\/fff.com.vn\/wp-json\/wp\/v2\/comments?post=26908"}],"version-history":[{"count":0,"href":"https:\/\/fff.com.vn\/wp-json\/wp\/v2\/posts\/26908\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/fff.com.vn\/wp-json\/wp\/v2\/media\/26932"}],"wp:attachment":[{"href":"https:\/\/fff.com.vn\/wp-json\/wp\/v2\/media?parent=26908"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/fff.com.vn\/wp-json\/wp\/v2\/categories?post=26908"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/fff.com.vn\/wp-json\/wp\/v2\/tags?post=26908"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}