{"id":320241,"date":"2024-02-29T19:53:17","date_gmt":"2024-02-29T12:53:17","guid":{"rendered":"https:\/\/hoanghamobile.com\/tin-tuc\/?p=320241"},"modified":"2024-02-29T19:53:17","modified_gmt":"2024-02-29T12:53:17","slug":"ham-viet-hoa-chu-cai-dau","status":"publish","type":"post","link":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-viet-hoa-chu-cai-dau\/","title":{"rendered":"H\u00e0m vi\u1ebft hoa ch\u1eef c\u00e1i \u0111\u1ea7u trong Excel \u0111\u01a1n gi\u1ea3n nh\u1ea5t"},"content":{"rendered":"<p><span style=\"font-weight: 400;\">\u0110\u1ec3 t\u1ea1o n\u00ean m\u1ed9t b\u1ea3ng t\u00ednh Excel chuy\u00ean nghi\u1ec7p v\u00e0 \u0111\u1eb9p m\u1eaft, ngo\u00e0i vi\u1ec7c s\u1eed d\u1ee5ng c\u00e1c h\u00e0m t\u00ednh to\u00e1n ph\u00f9 h\u1ee3p \u0111\u1ec3 cho ra k\u1ebft qu\u1ea3 s\u1ed1 li\u1ec7u ch\u00ednh x\u00e1c nh\u1ea5t, b\u1ea1n c\u00f2n ph\u1ea3i \u0111\u1ea7u t\u01b0 v\u00e0 ch\u1ec9n chu c\u1ea3 v\u1ec1 m\u1eb7t h\u00ecnh th\u1ee9c. Trong b\u00e0i vi\u1ebft d\u01b0\u1edbi \u0111\u00e2y, Ho\u00e0ng H\u00e0 Mobile s\u1ebd h\u01b0\u1edbng d\u1eabn b\u1ea1n c\u00e1ch s\u1eed d\u1ee5ng c\u00e1c h\u00e0m vi\u1ebft hoa ch\u1eef c\u00e1i \u0111\u1ea7u \u0111\u1ec3 b\u1ea3ng t\u00ednh trong g\u1ecdn \u0111\u1eb9p v\u00e0 d\u1ec5 nh\u00ecn h\u01a1n.\u00a0<\/span><\/p>\n<h2><span style=\"font-weight: 400;\">V\u00ec sao c\u1ea7n vi\u1ebft hoa ch\u1eef c\u00e1i \u0111\u1ea7u trong Excel?<\/span><\/h2>\n<p><span style=\"font-weight: 400;\">Khi \u0111\u1ecbnh d\u1ea1ng ki\u1ec3u ch\u1eef trong b\u1ea3ng t\u00ednh kh\u00f4ng \u0111\u01b0\u1ee3c \u0111\u1ed3ng nh\u1ea5t, ng\u01b0\u1eddi \u0111\u1ecdc s\u1ebd c\u00f3 c\u1ea3m gi\u00e1c kh\u00f3 ch\u1ecbu v\u00e0 kh\u00f4ng mu\u1ed1n ti\u1ebfp t\u1ee5c theo d\u00f5i n\u1ed9i dung b\u00ean trong. Kh\u00f4ng ch\u1ec9 th\u1ebf, chi ti\u1ebft n\u00e0y c\u00f2n th\u1ec3 hi\u1ec7n s\u1ef1 k\u00e9m chuy\u00ean nghi\u1ec7p c\u1ee7a ng\u01b0\u1eddi t\u1ea1o. V\u1eady n\u00ean, b\u1ea1n c\u1ea7n ch\u1ec9n chu trong t\u1eebng kh\u00e2u nh\u1ecf, k\u1ec3 c\u1ea3 vi\u1ec7c vi\u1ebft hoa ch\u1eef c\u00e1i \u0111\u1ea7u trong t\u00ean ri\u00eang.<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/02\/ham-viet-hoa-chu-cai-dau-1.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/02\/ham-viet-hoa-chu-cai-dau-1-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/02\/ham-viet-hoa-chu-cai-dau-1-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img fetchpriority=\"high\" decoding=\"async\" class=\"aligncenter size-full wp-image-320243 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/02\/ham-viet-hoa-chu-cai-dau-1.jpg\" alt=\"ham-viet-hoa-chu-cai-dau-1\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/02\/ham-viet-hoa-chu-cai-dau-1.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/02\/ham-viet-hoa-chu-cai-dau-1-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/02\/ham-viet-hoa-chu-cai-dau-1-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p><span style=\"font-weight: 400;\">Ngo\u00e0i ra, s\u1eed d\u1ee5ng h\u00e0m vi\u1ebft hoa ch\u1eef c\u00e1i \u0111\u1ea7u trong Excel c\u00f2n mang l\u1ea1i nhi\u1ec1u l\u1ee3i \u00edch kh\u00e1c nhau nh\u01b0:<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">T\u1ea1o c\u1ea3m gi\u00e1c chuy\u00ean nghi\u1ec7p: T\u00ean ri\u00eang ho\u1eb7c ch\u1eef c\u00e1i \u0111\u1ea7u trong \u0111o\u1ea1n v\u0103n \u0111\u01b0\u1ee3c vi\u1ebft hoa kh\u00f4ng ch\u1ec9 \u0111\u00e1p \u1ee9ng quy chu\u1ea9n tr\u00ecnh b\u00e0y chung, m\u00e0 c\u00f2n cho th\u1ea5y s\u1ef1 chuy\u00ean nghi\u1ec7p v\u00e0 ch\u1ec9n chu c\u1ee7a ng\u01b0\u1eddi t\u1ea1o.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">D\u1eef li\u1ec7u \u0111\u1ed3ng nh\u1ea5t v\u00e0 \u0111\u1eb9p m\u1eaft: Khi nh\u1eadp li\u1ec7u, b\u1ea1n c\u00f3 th\u1ec3 copy n\u1ed9i dung t\u1eeb c\u00e1c ngu\u1ed3n kh\u00e1c nhau v\u00e0 d\u00e1n v\u00e0o b\u1ea3ng t\u00ednh. \u0110i\u1ec1u n\u00e0y c\u00f3 th\u1ec3 g\u00e2y ra t\u00ecnh tr\u1ea1ng kh\u00f4ng \u0111\u1ed3ng nh\u1ea5t. L\u00fac n\u00e0y, h\u00e3y s\u1eed d\u1ee5ng c\u00e1c h\u00e0m vi\u1ebft hoa \u0111\u1ec3 b\u1ea3ng t\u00ednh tr\u1edf n\u00ean g\u1ecdn \u0111\u1eb9p v\u00e0 t\u1ea1o s\u1ef1 thu\u1eadn ti\u1ec7n trong qu\u00e1 tr\u00ecnh qu\u1ea3n l\u00fd d\u1eef li\u1ec7u.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">D\u1ec5 \u0111\u1ecdc, kh\u00f4ng g\u00e2y nh\u1ea7m l\u1eabn: C\u00e1c thu\u1eadt ng\u1eef, t\u00ean ri\u00eang ho\u1eb7c \u0111\u1ecba danh c\u1ea7n \u0111\u01b0\u1ee3c vi\u1ebft hoa &#8211; \u0111\u00e2y kh\u00f4ng ch\u1ec9 l\u00e0 quy t\u1eafc tr\u00ecnh b\u00e0y chung m\u00e0 c\u00f2n l\u00e0 d\u1ea5u hi\u1ec7u quan tr\u1ecdng \u0111\u1ec3 ng\u01b0\u1eddi \u0111\u1ecdc c\u00f3 th\u1ec3 nh\u1eadn bi\u1ebft \u00fd ngh\u0129a v\u00e0 tr\u00e1nh nh\u1ea7m l\u1eabn trong nhi\u1ec1u tr\u01b0\u1eddng h\u1ee3p kh\u00e1c nhau.\u00a0<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">L\u1ecdc, s\u1eafp x\u1ebfp v\u00e0 qu\u1ea3n l\u00fd d\u1ec5 d\u00e0ng: Qu\u00e1 tr\u00ecnh l\u1ecdc, s\u1eafp x\u1ebfp v\u00e0 qu\u1ea3n l\u00fd d\u1eef li\u1ec7u c\u0169ng tr\u1edf n\u00ean nhanh ch\u00f3ng, hi\u1ec7u qu\u1ea3 h\u01a1n khi t\u1ea5t c\u1ea3 d\u1eef li\u1ec7u \u0111\u1ec1u \u0111\u01b0\u1ee3c \u0111\u1ecbnh d\u1ea1ng ch\u00ednh x\u00e1c v\u00e0 \u0111\u1ed3ng nh\u1ea5t.<\/span><\/li>\n<\/ul>\n<h2><span style=\"font-weight: 400;\">3 h\u00e0m vi\u1ebft hoa ch\u1eef c\u00e1i \u0111\u1ea7u trong Excel \u0111\u01a1n gi\u1ea3n nh\u1ea5t<\/span><\/h2>\n<p><span style=\"font-weight: 400;\">D\u01b0\u1edbi \u0111\u00e2y l\u00e0 3 h\u00e0m cho ph\u00e9p ng\u01b0\u1eddi d\u00f9ng vi\u1ebft hoa ch\u1eef c\u00e1i \u0111\u1ea7u m\u00e0 b\u1ea1n c\u00f3 th\u1ec3 tham kh\u1ea3o v\u00e0 \u00e1p d\u1ee5ng:\u00a0<\/span><\/p>\n<h3><span style=\"font-weight: 400;\">C\u00e1ch 1: H\u00e0m vi\u1ebft hoa ch\u1eef c\u00e1i \u0111\u1ea7u PROPER<\/span><\/h3>\n<p><span style=\"font-weight: 400;\">Trong Excel, h\u00e0m PROPER \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 chuy\u1ec3n \u0111\u1ed5i t\u1ef1 \u0111\u1ed9ng c\u00e1c k\u00fd t\u1ef1 ch\u1eef c\u00e1i \u0111\u1ea7u ti\u00ean trong m\u1ed7i t\u1eeb c\u1ee7a v\u0103n b\u1ea3n th\u00e0nh k\u00fd t\u1ef1 ch\u1eef in hoa. B\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m PROPER, b\u1ea3ng t\u00ednh c\u1ee7a b\u1ea1n s\u1ebd tr\u1edf n\u00ean chuy\u00ean nghi\u1ec7p v\u00e0 d\u1ec5 \u0111\u1ecdc h\u01a1n.\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400;\">C\u00fa ph\u00e1p c\u1ee7a h\u00e0m vi\u1ebft hoa PROPER l\u00e0:\u00a0<\/span><\/p>\n<p><strong>=PROPER(text)<\/strong><\/p>\n<p><span style=\"font-weight: 400;\">Trong \u0111\u00f3, text l\u00e0 \u0111\u1ed1i s\u1ed1 ch\u1ee9a chu\u1ed7i k\u00fd t\u1ef1, v\u0103n b\u1ea3n m\u00e0 b\u1ea1n mu\u1ed1n chuy\u1ec3n \u0111\u1ed5i. B\u1ea1n c\u00f3 th\u1ec3 tr\u1ef1c ti\u1ebfp g\u00f5 chu\u1ed7i v\u0103n b\u1ea3n text v\u00e0o trong c\u00f4ng th\u1ee9c, ho\u1eb7c tham chi\u1ebfu h\u00e0m \u0111\u1ebfn \u00f4 d\u1eef li\u1ec7u c\u1ea7n chuy\u1ec3n \u0111\u1ed5i.\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Ch\u1eb3ng h\u1ea1n nh\u01b0 b\u1ea1n c\u00f3 m\u1ed9t danh s\u00e1ch nh\u01b0 b\u1ea3ng d\u01b0\u1edbi v\u00e0 b\u1ea1n c\u1ea7n chuy\u1ec3n \u0111\u1ed5i sang d\u1ea1ng t\u00ean ri\u00eang v\u1edbi ch\u1eef c\u00e1i hoa \u0111\u1ea7u ti\u00ean. D\u01b0\u1edbi \u0111\u00e2y l\u00e0 c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m PROPER th\u1ef1c hi\u1ec7n y\u00eau c\u1ea7u tr\u00ean:\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400;\">B\u01b0\u1edbc 1: \u0110\u1ea7u ti\u00ean, t\u1ea1i \u00f4 C3, b\u1ea1n \u0111i\u1ec1n c\u00f4ng th\u1ee9c =PROPER(B3) r\u1ed3i nh\u1ea5n Enter \u0111\u1ec3 ra k\u1ebft qu\u1ea3.<\/span><\/p>\n<figure id=\"attachment_320244\" aria-describedby=\"caption-attachment-320244\" style=\"width: 800px\" class=\"wp-caption aligncenter\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/02\/ham-viet-hoa-chu-cai-dau-2.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/02\/ham-viet-hoa-chu-cai-dau-2-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/02\/ham-viet-hoa-chu-cai-dau-2-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img decoding=\"async\" class=\"wp-image-320244 size-full webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/02\/ham-viet-hoa-chu-cai-dau-2.jpg\" alt=\"ham-viet-hoa-chu-cai-dau-2\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/02\/ham-viet-hoa-chu-cai-dau-2.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/02\/ham-viet-hoa-chu-cai-dau-2-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/02\/ham-viet-hoa-chu-cai-dau-2-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><figcaption id=\"caption-attachment-320244\" class=\"wp-caption-text\">V\u00ed d\u1ee5 c\u00e1ch d\u00f9ng h\u00e0m vi\u1ebft hoa ch\u1eef c\u00e1i \u0111\u1ea7u<\/figcaption><\/figure>\n<p><span style=\"font-weight: 400;\">B\u01b0\u1edbc 2: N\u1ebfu mu\u1ed1n chuy\u1ec3n \u0111\u1ed5i cho to\u00e0n b\u1ed9 chu\u1ed7i k\u00fd t\u1ef1 trong b\u1ea3ng, b\u1ea1n b\u1ea5m gi\u1eef chu\u1ed9t v\u00e0 k\u00e9o ph\u1ee7 v\u00f9ng d\u1eef li\u1ec7u ch\u1ee9a t\u00ean kh\u00e1ch h\u00e0ng r\u1ed3i th\u1ea3 chu\u1ed9t l\u00e0 ho\u00e0n t\u1ea5t.<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/02\/ham-viet-hoa-chu-cai-dau-3.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/02\/ham-viet-hoa-chu-cai-dau-3-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/02\/ham-viet-hoa-chu-cai-dau-3-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img decoding=\"async\" class=\"aligncenter size-full wp-image-320245 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/02\/ham-viet-hoa-chu-cai-dau-3.jpg\" alt=\"ham-viet-hoa-chu-cai-dau-3\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/02\/ham-viet-hoa-chu-cai-dau-3.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/02\/ham-viet-hoa-chu-cai-dau-3-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/02\/ham-viet-hoa-chu-cai-dau-3-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture> <picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/02\/ham-viet-hoa-chu-cai-dau-4.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/02\/ham-viet-hoa-chu-cai-dau-4-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/02\/ham-viet-hoa-chu-cai-dau-4-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-320246 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/02\/ham-viet-hoa-chu-cai-dau-4.jpg\" alt=\"ham-viet-hoa-chu-cai-dau-4\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/02\/ham-viet-hoa-chu-cai-dau-4.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/02\/ham-viet-hoa-chu-cai-dau-4-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/02\/ham-viet-hoa-chu-cai-dau-4-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p><span style=\"font-weight: 400;\">L\u01b0u \u00fd:\u00a0<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">H\u00e0m PROPER ch\u1ec9 \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 vi\u1ebft hoa ch\u1eef c\u00e1i \u0111\u1ea7u ti\u00ean trong m\u1ed7i t\u1eeb c\u1ee7a chu\u1ed7i v\u0103n b\u1ea3n v\u00e0 s\u1ebd kh\u00f4ng thay \u0111\u1ed5i c\u00e1c ch\u1eef c\u00e1i c\u00f2n l\u1ea1i trong chu\u1ed7i. Ch\u1eb3ng h\u1ea1n nh\u01b0 \u201cnguy\u1ec5n ng\u1ecdC anh\u201d s\u1ebd \u0111\u01b0\u1ee3c \u0111\u1ed5i th\u00e0nh \u201cNguy\u1ec5n Ng\u1ecdC Anh\u201d.\u00a0<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">H\u00e0m PROPER s\u1ebd t\u1ef1 \u0111\u1ed9ng b\u1ecf qua c\u00e1c k\u00fd t\u1ef1 \u0111\u1eb7c bi\u1ec7t, k\u00fd t\u1ef1 ch\u1eef s\u1ed1 v\u00e0 nh\u1eefng k\u00fd t\u1ef1 kh\u00f4ng ph\u1ea3i l\u00e0 ch\u1eef c\u00e1i.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Khi tham chi\u1ebfu v\u00f9ng d\u1eef li\u1ec7u c\u00f3 \u00f4 tr\u1ed1ng, h\u00e0m PROPER s\u1ebd tr\u1ea3 v\u1ec1 \u00f4 tr\u1ed1ng.<\/span><\/li>\n<\/ul>\n<h3><span style=\"font-weight: 400;\">C\u00e1ch 2: H\u00e0m vi\u1ebft hoa ch\u1eef c\u00e1i \u0111\u1ea7u UPPER, LOWER<\/span><\/h3>\n<p><span style=\"font-weight: 400;\">UPPER v\u00e0 LOWER c\u0169ng l\u00e0 2 h\u00e0m cho ph\u00e9p ng\u01b0\u1eddi d\u00f9ng \u0111\u1ed5i ki\u1ec3u ch\u1eef m\u1ed9t c\u00e1ch nhanh ch\u00f3ng v\u00e0 d\u1ec5 d\u00e0ng trong Excel. Tuy nhi\u00ean, c\u00e1ch d\u00f9ng c\u1ee7a hai h\u00e0m s\u1ebd c\u00f3 \u0111\u00f4i ch\u00fat kh\u00e1c bi\u1ec7t, trong khi h\u00e0m UPPER \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 in hoa t\u1ea5t c\u1ea3 c\u00e1c k\u00fd t\u1ef1 ch\u1eef c\u00e1i trong v\u0103n b\u1ea3n, th\u00ec h\u00e0m LOWER l\u1ea1i chuy\u1ec3n \u0111\u1ed5i t\u1ea5t c\u1ea3 th\u00e0nh k\u00fd t\u1ef1 ch\u1eef th\u01b0\u1eddng.\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400;\">D\u01b0\u1edbi \u0111\u00e2y l\u00e0 c\u00fa ph\u00e1p c\u1ee7a h\u00e0m UPPER v\u00e0 LOWER<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><strong>H\u00e0m UPPER: =UPPER(text)<\/strong><\/li>\n<li style=\"font-weight: 400;\"><strong>H\u00e0m LOWER: =LOWER(text)<\/strong><\/li>\n<\/ul>\n<p><span style=\"font-weight: 400;\">T\u01b0\u01a1ng t\u1ef1, Text l\u00e0 \u0111\u1ed1i s\u1ed1 ch\u1ee9a v\u0103n b\u1ea3n, chu\u1ed7i k\u00fd t\u1ef1 m\u00e0 ng\u01b0\u1eddi d\u00f9ng c\u1ea7n chuy\u1ec3n \u0111\u1ed5i \u0111\u1ecbnh d\u1ea1ng ki\u1ec3u ch\u1eef. T\u1ea1i \u0111\u00e2y, b\u1ea1n c\u00f3 th\u1ec3 tr\u1ef1c ti\u1ebfp \u0111i\u1ec1n chu\u1ed7i k\u00fd t\u1ef1 c\u1ea7n chuy\u1ec3n \u0111\u1ed5i v\u00e0o c\u00f4ng th\u1ee9c, ho\u1eb7c \u0111\u01b0a tr\u1ecf chu\u1ed9t \u0111\u1ebfn \u00f4 ch\u1ee9a d\u1eef li\u1ec7u t\u01b0\u01a1ng \u1ee9ng.\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400;\">V\u00ed d\u1ee5: B\u1ea1n c\u00f3 m\u1ed9t b\u1ea3ng d\u1eef li\u1ec7u nh\u01b0 b\u00ean d\u01b0\u1edbi v\u00e0 b\u1ea1n c\u1ea7n vi\u1ebft hoa t\u1ea5t c\u1ea3 k\u00fd t\u1ef1 ch\u1eef trong b\u1ea3ng ho\u1eb7c chuy\u1ec3n ch\u00fang th\u00e0nh k\u00fd t\u1ef1 th\u01b0\u1eddng. \u0110\u1ec3 l\u00e0m \u0111\u01b0\u1ee3c \u0111i\u1ec1u \u0111\u00f3, b\u1ea1n th\u1ef1c hi\u1ec7n theo h\u01b0\u1edbng d\u1eabn sau:\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400;\">B\u01b0\u1edbc 1: T\u1ea1i \u00f4 C3, b\u1ea1n \u0111i\u1ec1n c\u00f4ng th\u1ee9c v\u1edbi c\u00fa ph\u00e1p sau: =UPPER(B3), sau \u0111\u00f3 b\u1ea5m Enter \u0111\u1ec3 nh\u1eadn k\u1ebft qu\u1ea3.<\/span><\/p>\n<figure id=\"attachment_320247\" aria-describedby=\"caption-attachment-320247\" style=\"width: 800px\" class=\"wp-caption aligncenter\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/02\/ham-viet-hoa-chu-cai-dau-5.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/02\/ham-viet-hoa-chu-cai-dau-5-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/02\/ham-viet-hoa-chu-cai-dau-5-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-320247 size-full webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/02\/ham-viet-hoa-chu-cai-dau-5.jpg\" alt=\"ham-viet-hoa-chu-cai-dau-5\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/02\/ham-viet-hoa-chu-cai-dau-5.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/02\/ham-viet-hoa-chu-cai-dau-5-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/02\/ham-viet-hoa-chu-cai-dau-5-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><figcaption id=\"caption-attachment-320247\" class=\"wp-caption-text\">V\u00ed d\u1ee5 c\u00e1ch d\u00f9ng h\u00e0m vi\u1ebft hoa ch\u1eef c\u00e1i \u0111\u1ea7u Upper<\/figcaption><\/figure>\n<p><span style=\"font-weight: 400;\">B\u01b0\u1edbc 2: L\u00fac n\u00e0y, d\u1eef li\u1ec7u t\u1ea1i \u00f4 B3 s\u1ebd \u0111\u01b0\u1ee3c in hoa to\u00e0n b\u1ed9 v\u00e0 tr\u1ea3 k\u1ebft qu\u1ea3 t\u1ea1i \u00f4 C3. \u0110\u1ec3 th\u1ef1c hi\u1ec7n \u0111\u1ed3ng lo\u1ea1t cho c\u00e1c d\u1eef li\u1ec7u b\u00ean d\u01b0\u1edbi, b\u1ea1n k\u00e9o chu\u1ed9t xu\u1ed1ng v\u00f9ng c\u1ea7n chuy\u1ec3n \u0111\u1ed5i r\u1ed3i th\u1ea3 chu\u1ed9t l\u00e0 \u0111\u01b0\u1ee3c.\u00a0<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/02\/ham-viet-hoa-chu-cai-dau-6.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/02\/ham-viet-hoa-chu-cai-dau-6-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/02\/ham-viet-hoa-chu-cai-dau-6-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-320248 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/02\/ham-viet-hoa-chu-cai-dau-6.jpg\" alt=\"ham-viet-hoa-chu-cai-dau-6\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/02\/ham-viet-hoa-chu-cai-dau-6.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/02\/ham-viet-hoa-chu-cai-dau-6-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/02\/ham-viet-hoa-chu-cai-dau-6-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture> <picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/02\/ham-viet-hoa-chu-cai-dau-7.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/02\/ham-viet-hoa-chu-cai-dau-7-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/02\/ham-viet-hoa-chu-cai-dau-7-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-320249 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/02\/ham-viet-hoa-chu-cai-dau-7.jpg\" alt=\"ham-viet-hoa-chu-cai-dau-7\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/02\/ham-viet-hoa-chu-cai-dau-7.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/02\/ham-viet-hoa-chu-cai-dau-7-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/02\/ham-viet-hoa-chu-cai-dau-7-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p><span style=\"font-weight: 400;\">B\u01b0\u1edbc 3: Ng\u01b0\u1ee3c l\u1ea1i, n\u1ebfu b\u1ea1n mu\u1ed1n \u0111\u1ed5i \u0111\u1ecbnh d\u1ea1ng ch\u1eef hoa th\u00e0nh \u0111\u1ecbnh d\u1ea1ng ch\u1eef th\u01b0\u1eddng cho chu\u1ed7i k\u00fd t\u1ef1, h\u00e3y nh\u1eadp h\u00e0m LOWER v\u1edbi c\u00fa ph\u00e1p =LOWER(C3). Sau \u0111\u00f3 b\u1ea5m Enter v\u00e0 k\u00e9o th\u1ea3 chu\u1ed9t \u0111\u1ebfn h\u1ebft khu v\u1ef1c ch\u1ee9a d\u1eef li\u1ec7u.\u00a0<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/02\/ham-viet-hoa-chu-cai-dau-9.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/02\/ham-viet-hoa-chu-cai-dau-9-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/02\/ham-viet-hoa-chu-cai-dau-9-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-320251 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/02\/ham-viet-hoa-chu-cai-dau-9.jpg\" alt=\"ham-viet-hoa-chu-cai-dau-9\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/02\/ham-viet-hoa-chu-cai-dau-9.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/02\/ham-viet-hoa-chu-cai-dau-9-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/02\/ham-viet-hoa-chu-cai-dau-9-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/02\/ham-viet-hoa-chu-cai-dau-10.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/02\/ham-viet-hoa-chu-cai-dau-10-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/02\/ham-viet-hoa-chu-cai-dau-10-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-320252 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/02\/ham-viet-hoa-chu-cai-dau-10.jpg\" alt=\"ham-viet-hoa-chu-cai-dau-10\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/02\/ham-viet-hoa-chu-cai-dau-10.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/02\/ham-viet-hoa-chu-cai-dau-10-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/02\/ham-viet-hoa-chu-cai-dau-10-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<h3><span style=\"font-weight: 400;\">C\u00e1ch 3: H\u00e0m vi\u1ebft hoa ch\u1eef c\u00e1i \u0111\u1ea7u k\u1ebft h\u1ee3p CONCATENATE<\/span><\/h3>\n<p><span style=\"font-weight: 400;\">H\u00e0m CONCATENATE th\u1ef1c ch\u1ea5t l\u00e0 m\u1ed9t h\u00e0m gh\u00e9p n\u1ed1i, h\u00e0m n\u00e0y cho ph\u00e9p ng\u01b0\u1eddi d\u00f9ng k\u1ebft h\u1ee3p c\u00e1c chu\u1ed7i v\u0103n b\u1ea3n th\u00e0nh m\u1ed9t chu\u1ed7i duy nh\u1ea5t. Tuy nhi\u00ean, b\u1ea1n v\u1eabn c\u00f3 th\u1ec3 k\u1ebft h\u1ee3p h\u00e0m CONCATENATE v\u1edbi nh\u1eefng h\u00e0m kh\u00e1c l\u00e0 LEFT\/RIGHT v\u00e0 UPPER \u0111\u1ec3 \u0111\u1ec3 vi\u1ebft hoa k\u00fd t\u1ef1 \u0111\u1ea7u ti\u00ean trong chu\u1ed7i v\u0103n b\u1ea3n.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">C\u00fa ph\u00e1p c\u1ee5 th\u1ec3 s\u1ebd l\u00e0:\u00a0<\/span><\/p>\n<p><strong>=CONCATENATE(text1, text2, textn&#8230;)<\/strong><\/p>\n<p><span style=\"font-weight: 400;\">Trong \u0111\u00f3, text1, text2, textn l\u00e0 nh\u1eefng chu\u1ed7i v\u0103n b\u1ea3n m\u00e0 ng\u01b0\u1eddi d\u00f9ng mu\u1ed1n gh\u00e9p n\u1ed1i v\u00e0 k\u1ebft h\u1ee3p l\u1ea1i th\u00e0nh m\u1ed9t chu\u1ed7i duy nh\u1ea5t. T\u01b0\u01a1ng t\u1ef1, b\u1ea1n v\u1eabn c\u00f3 th\u1ec3 g\u00f5 ch\u00fang v\u00e0o c\u00f4ng th\u1ee9c, ho\u1eb7c tham chi\u1ebfu v\u00e0o nh\u1eefng \u00f4 ch\u1ee9a d\u1eef li\u1ec7u c\u1ea7n thi\u1ebft.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">V\u00ed d\u1ee5: B\u1ea1n c\u00f3 m\u1ed9t b\u1ea3ng d\u1eef li\u1ec7u nh\u01b0 b\u00ean d\u01b0\u1edbi, h\u00e3y s\u1eed d\u1ee5ng h\u00e0m CONCATENATE c\u00f9ng LEFT\/RIGHT, UPPER \u0111\u1ec3 gh\u00e9p n\u1ed1i v\u0103n b\u1ea3n v\u00e0 vi\u1ebft hoa ch\u1eef c\u00e1i \u0111\u1ea7u cho chu\u1ed7i:\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400;\">B\u01b0\u1edbc 1: \u0110\u1ea7u ti\u00ean, t\u1ea1i \u00f4 d\u1eef li\u1ec7u C4, b\u1ea1n \u0111i\u1ec1n c\u00fa ph\u00e1p sau:\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400;\">=CONCATENATE(UPPER(LEFT(B4;1));RIGHT(B4;LEN(B4)-1)).<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/02\/ham-viet-hoa-chu-cai-dau-11.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/02\/ham-viet-hoa-chu-cai-dau-11-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/02\/ham-viet-hoa-chu-cai-dau-11-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-320253 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/02\/ham-viet-hoa-chu-cai-dau-11.jpg\" alt=\"ham-viet-hoa-chu-cai-dau-11\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/02\/ham-viet-hoa-chu-cai-dau-11.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/02\/ham-viet-hoa-chu-cai-dau-11-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/02\/ham-viet-hoa-chu-cai-dau-11-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p><span style=\"font-weight: 400;\">B\u01b0\u1edbc 2: Sau \u0111\u00f3, b\u1ea1n b\u1ea5m Enter, k\u1ebft qu\u1ea3 s\u1ebd hi\u1ec3n th\u1ecb l\u00e0 \u201cH\u1ea1nh ph\u00fac m\u1ed7i ng\u00e0y\u201d. \u0110\u1ec3 th\u1ef1c hi\u1ec7n \u0111i\u1ec1u t\u01b0\u01a1ng t\u1ef1 cho c\u00e1c \u00f4 b\u00ean d\u01b0\u1edbi, b\u1ea1n ti\u1ebfp t\u1ee5c gi\u1eef v\u00e0 k\u00e9o th\u1ea3 chu\u1ed9t \u0111\u1ebfn h\u1ebft v\u00f9ng d\u1eef li\u1ec7u.<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/02\/ham-viet-hoa-chu-cai-dau-12.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/02\/ham-viet-hoa-chu-cai-dau-12-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/02\/ham-viet-hoa-chu-cai-dau-12-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-320254 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/02\/ham-viet-hoa-chu-cai-dau-12.jpg\" alt=\"ham-viet-hoa-chu-cai-dau-12\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/02\/ham-viet-hoa-chu-cai-dau-12.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/02\/ham-viet-hoa-chu-cai-dau-12-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/02\/ham-viet-hoa-chu-cai-dau-12-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<h2><span style=\"font-weight: 400;\">Th\u1ee7 thu\u1eadt Excel chuy\u00ean nghi\u1ec7p cho d\u00e2n v\u0103n ph\u00f2ng<\/span><\/h2>\n<p><span style=\"font-weight: 400;\">Ngo\u00e0i vi\u1ec7c \u00e1p d\u1ee5ng c\u00e1ch h\u00e0m vi\u1ebft hoa ch\u1eef c\u00e1i \u0111\u1ea7u tr\u00ean, b\u1ea1n c\u0169ng c\u00f3 th\u1ec3 tham kh\u1ea3o th\u00eam m\u1ed9t s\u1ed1 th\u1ee7 thu\u1eadt Excel chuy\u00ean nghi\u1ec7p d\u01b0\u1edbi \u0111\u00e2y \u0111\u1ec3 t\u1ed1i \u01b0u h\u00f3a qu\u00e1 tr\u00ecnh nh\u1eadp li\u1ec7u v\u00e0 tr\u00ecnh b\u00e0y b\u1ea3ng t\u00ednh:\u00a0<\/span><\/p>\n<h3><span style=\"font-weight: 400;\">T\u00ecm v\u00e0 lo\u1ea1i b\u1ecf c\u00e1c gi\u00e1 tr\u1ecb tr\u00f9ng l\u1eb7p<\/span><\/h3>\n<p><span style=\"font-weight: 400;\">\u0110\u00f4i khi b\u1ea1n s\u1ebd g\u1eb7p t\u00ecnh tr\u1ea1ng tr\u00f9ng l\u1eb7p d\u1eef li\u1ec7u khi x\u1eed l\u00fd c\u00e1c b\u1ea3ng t\u00ednh c\u00f3 s\u1eb5n ho\u1eb7c thu th\u1eadp t\u1eeb nhi\u1ec1u ngu\u1ed3n kh\u00e1c nhau. N\u1ebfu l\u00e0 m\u1ed9t b\u1ea3ng t\u00ednh ng\u1eafn \u0111\u01a1n gi\u1ea3n, b\u1ea1n c\u00f3 th\u1ec3 x\u00f3a th\u1ee7 c\u00f4ng c\u00e1c d\u00f2ng tr\u00f9ng l\u1eb7p. Tuy nhi\u00ean, c\u00e1ch n\u00e0y s\u1ebd kh\u00f4ng ph\u00f9 h\u1ee3p v\u1edbi nh\u1eefng b\u1ea3ng t\u00ednh ch\u1ee9a h\u00e0ng tr\u0103m, ng\u00e0n \u00f4 d\u1eef li\u1ec7u. Khi \u0111\u00f3, h\u00e3y tham kh\u1ea3o h\u01b0\u1edbng d\u1eabn d\u01b0\u1edbi \u0111\u00e2y \u0111\u1ec3 lo\u1ea1i b\u1ecf nhanh gi\u00e1 tr\u1ecb tr\u00f9ng l\u1eb7p:\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400;\">B\u01b0\u1edbc 1: \u0110\u1ea7u ti\u00ean, b\u1ea1n b\u00f4i \u0111en to\u00e0n b\u1ed9 v\u00f9ng d\u1eef li\u1ec7u b\u1eb1ng chu\u1ed9t ho\u1eb7c t\u1ed5 h\u1ee3p ph\u00edm t\u1eaft Ctrl + A.\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400;\">B\u01b0\u1edbc 2: Sau \u0111\u00f3, b\u1ea1n click chu\u1ed9t v\u00e0o m\u1ee5c Data r\u1ed3i b\u1ea5m ch\u1ecdn Remove Duplicates.<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/02\/ham-viet-hoa-chu-cai-dau-13.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/02\/ham-viet-hoa-chu-cai-dau-13-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/02\/ham-viet-hoa-chu-cai-dau-13-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-320255 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/02\/ham-viet-hoa-chu-cai-dau-13.jpg\" alt=\"ham-viet-hoa-chu-cai-dau-13\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/02\/ham-viet-hoa-chu-cai-dau-13.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/02\/ham-viet-hoa-chu-cai-dau-13-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/02\/ham-viet-hoa-chu-cai-dau-13-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p><span style=\"font-weight: 400;\">B\u01b0\u1edbc 3: Khi \u0111\u00f3, tr\u00ean m\u00e0n h\u00ecnh m\u00e1y t\u00ednh s\u1ebd hi\u1ec3n th\u1ecb m\u1ed9t c\u1eeda s\u1ed5 m\u1edbi, h\u00e3y click v\u00e0o Unselect All r\u1ed3i ch\u1ecdn ID, cu\u1ed1i c\u00f9ng b\u1ea5m OK l\u00e0 ho\u00e0n t\u1ea5t.\u00a0<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/02\/ham-viet-hoa-chu-cai-dau-14.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/02\/ham-viet-hoa-chu-cai-dau-14-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/02\/ham-viet-hoa-chu-cai-dau-14-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-320256 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/02\/ham-viet-hoa-chu-cai-dau-14.jpg\" alt=\"ham-viet-hoa-chu-cai-dau-14\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/02\/ham-viet-hoa-chu-cai-dau-14.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/02\/ham-viet-hoa-chu-cai-dau-14-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/02\/ham-viet-hoa-chu-cai-dau-14-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<h3><span style=\"font-weight: 400;\">K\u1ebb vi\u1ec1n t\u1ef1 \u0111\u1ed9ng khi th\u00eam d\u1eef li\u1ec7u m\u1edbi<\/span><\/h3>\n<p><span style=\"font-weight: 400;\">Ngo\u00e0i vi\u1ec7c s\u1eed d\u1ee5ng h\u00e0m vi\u1ebft hoa ch\u1eef c\u00e1i \u0111\u1ea7u, thi\u1ebft l\u1eadp ch\u1ebf \u0111\u1ed9 k\u1ebb vi\u1ec1n t\u1ef1 \u0111\u1ed9ng khi nh\u1eadp d\u1eef li\u1ec7u m\u1edbi c\u0169ng gi\u00fap b\u1ea3ng t\u00ednh tr\u00f4ng chuy\u00ean nghi\u1ec7p v\u00e0 \u0111\u1eb9p m\u1eaft h\u01a1n. C\u00e1c b\u01b0\u1edbc c\u1ee5 th\u1ec3 l\u00e0:<\/span><\/p>\n<p><span style=\"font-weight: 400;\">B\u01b0\u1edbc 1: T\u01b0\u01a1ng t\u1ef1, h\u00e3y b\u00f4i \u0111en v\u00f9ng d\u1eef li\u1ec7u, nh\u01b0ng c\u1ea7n l\u01b0u \u00fd l\u00e0 b\u1ea1n c\u1ea7n k\u00e9o xu\u1ed1ng \u0111\u1ebfn t\u1ea5t c\u1ea3 c\u00e1c d\u00f2ng ch\u01b0a \u0111\u01b0\u1ee3c nh\u1eadp li\u1ec7u b\u00ean d\u01b0\u1edbi.\u00a0<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/02\/ham-viet-hoa-chu-cai-dau-15.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/02\/ham-viet-hoa-chu-cai-dau-15-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/02\/ham-viet-hoa-chu-cai-dau-15-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-320257 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/02\/ham-viet-hoa-chu-cai-dau-15.jpg\" alt=\"ham-viet-hoa-chu-cai-dau-15\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/02\/ham-viet-hoa-chu-cai-dau-15.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/02\/ham-viet-hoa-chu-cai-dau-15-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/02\/ham-viet-hoa-chu-cai-dau-15-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p><span style=\"font-weight: 400;\">B\u01b0\u1edbc 2: Ti\u1ebfp theo, t\u1ea1i m\u1ee5c Conditional Formatting, b\u1ea1n ch\u1ecdn New Rule r\u1ed3i click v\u00e0o d\u00f2ng cu\u1ed1i c\u00f9ng c\u00f3 n\u1ed9i dung \u201cUse a formula\u2026\u201d.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">B\u01b0\u1edbc 3: \u1ede b\u01b0\u1edbc n\u00e0y, b\u1ea1n c\u1ea7n nh\u1eadp \u0111i\u1ec1u ki\u1ec7n v\u00e0o tr\u01b0\u1eddng \u201cFormat values where\u2026\u201d. H\u00e3y \u0111\u1eb7t tr\u1ecf chu\u1ed9t v\u00e0o \u0111\u00f3 r\u1ed3i ch\u1ecdn d\u00f2ng th\u1ee9 nh\u1ea5t c\u1ee7a b\u1ea3ng t\u00ednh, sau \u0111\u00f3 b\u1ea5m F4 2 l\u1ea7n \u0111\u1ec3 cho ra c\u00f4ng th\u1ee9c: =$A2&lt;&gt;&#8221;&#8221;.\u00a0<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/02\/ham-viet-hoa-chu-cai-dau-16.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/02\/ham-viet-hoa-chu-cai-dau-16-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/02\/ham-viet-hoa-chu-cai-dau-16-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-320258 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/02\/ham-viet-hoa-chu-cai-dau-16.jpg\" alt=\"ham-viet-hoa-chu-cai-dau-16\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/02\/ham-viet-hoa-chu-cai-dau-16.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/02\/ham-viet-hoa-chu-cai-dau-16-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/02\/ham-viet-hoa-chu-cai-dau-16-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p><span style=\"font-weight: 400;\">B\u01b0\u1edbc 4: B\u00e2y gi\u1edd, b\u1ea1n b\u1ea5m v\u00e0o tab Format, sau \u0111\u00f3 ch\u1ecdn Outline r\u1ed3i b\u1ea5m OK \u0111\u1ec3 ho\u00e0n t\u1ea5t.\u00a0<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/02\/ham-viet-hoa-chu-cai-dau-17.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/02\/ham-viet-hoa-chu-cai-dau-17-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/02\/ham-viet-hoa-chu-cai-dau-17-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-320259 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/02\/ham-viet-hoa-chu-cai-dau-17.jpg\" alt=\"ham-viet-hoa-chu-cai-dau-17\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/02\/ham-viet-hoa-chu-cai-dau-17.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/02\/ham-viet-hoa-chu-cai-dau-17-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/02\/ham-viet-hoa-chu-cai-dau-17-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<h3><span style=\"font-weight: 400;\">C\u1ed1 \u0111\u1ecbnh c\u00e1c h\u00e0ng, c\u1ed9t ti\u00eau \u0111\u1ec1<\/span><\/h3>\n<p><span style=\"font-weight: 400;\">Vi\u1ec7c c\u1ed1 \u0111\u1ecbnh c\u1ed9t v\u00e0 h\u00e0ng ti\u00eau \u0111\u1ec1 gi\u00fap ng\u01b0\u1eddi xem \u0111\u1ed1i chi\u1ebfu c\u00e1c d\u1eef li\u1ec7u theo h\u00e0ng, c\u1ed9t m\u1ed9t c\u00e1ch nhanh ch\u00f3ng v\u00e0 d\u1ec5 d\u00e0ng. \u0110i\u1ec1u n\u00e0y v\u00f4 c\u00f9ng c\u1ea7n thi\u1ebft v\u1edbi c\u00e1c b\u1ea3ng d\u1eef li\u1ec7u l\u1edbn ch\u1ee9a v\u00f4 s\u1ed1 c\u00e1c h\u00e0ng v\u00e0 c\u1ed9t. C\u00e1c b\u01b0\u1edbc c\u1ee5 th\u1ec3 s\u1ebd l\u00e0:<\/span><\/p>\n<p><span style=\"font-weight: 400;\">B\u01b0\u1edbc 1: \u0110\u1ea7u ti\u00ean, b\u1ea1n d\u00f9ng chu\u1ed9t \u0111\u1ec3 b\u00f4i \u0111en h\u00e0ng v\u00e0 c\u1ed9t ti\u00eau \u0111\u1ec1 c\u1ea7n \u0111\u01b0\u1ee3c c\u1ed1 \u0111\u1ecbnh.\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400;\">B\u01b0\u1edbc 2: Sau \u0111\u00f3, b\u1ea1n \u0111\u01b0a tr\u1ecf chu\u1ed9t \u0111\u1eb7t t\u1ea1i g\u00f3c ch\u00e9o r\u1ed3i click v\u00e0o View, ch\u1ecdn Freeze Panes v\u00e0 cu\u1ed1i c\u00f9ng l\u00e0 Unfreeze Panes. Sau thao t\u00e1c tr\u00ean, c\u00e1c h\u00e0ng v\u00e0 c\u1ed9t ti\u00eau \u0111\u1ec1 \u0111\u00e3 \u0111\u01b0\u1ee3c c\u1ed1 \u0111\u1ecbnh v\u00e0 n\u00f3 lu\u00f4n hi\u1ec3n th\u1ecb d\u00f9 b\u1ea1n k\u00e9o b\u1ea3ng \u0111i \u0111\u1ebfn \u0111\u00e2u.\u00a0<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/02\/ham-viet-hoa-chu-cai-dau-18.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/02\/ham-viet-hoa-chu-cai-dau-18-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/02\/ham-viet-hoa-chu-cai-dau-18-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-320260 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/02\/ham-viet-hoa-chu-cai-dau-18.jpg\" alt=\"ham-viet-hoa-chu-cai-dau-18\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/02\/ham-viet-hoa-chu-cai-dau-18.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/02\/ham-viet-hoa-chu-cai-dau-18-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/02\/ham-viet-hoa-chu-cai-dau-18-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<h3><span style=\"font-weight: 400;\">T\u1ea1o d\u00f2ng k\u1ebb ch\u1ea5m trong Excel<\/span><\/h3>\n<p><span style=\"font-weight: 400;\">Sau khi s\u1eed d\u1ee5ng h\u00e0m vi\u1ebft hoa ch\u1eef c\u00e1i \u0111\u1ea7u \u0111\u1ec3 thi\u1ebft l\u1eadp \u0111\u1ecbnh d\u1ea1ng \u0111\u1ed3ng nh\u1ea5t cho b\u1ea3ng t\u00ednh, b\u1ea1n c\u00f2n c\u00f3 th\u1ec3 khi\u1ebfn b\u1ea3ng d\u1eef li\u1ec7u tr\u00f4ng chuy\u00ean nghi\u1ec7p, \u0111\u1eb9p m\u1eaft h\u01a1n v\u1edbi c\u00e1c d\u00f2ng k\u1ebb ch\u1ea5m cho nh\u1eefng \u00f4 c\u1ea7n thi\u1ebft:\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400;\">B\u01b0\u1edbc 1: \u0110\u1ea7u ti\u00ean, b\u1ea1n d\u00f9ng chu\u1ed9t b\u00f4i \u0111en v\u00e0 ch\u1ecdn khu v\u1ef1c c\u1ea7n th\u00eam d\u1ea5u ch\u1ea5m.\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400;\">B\u01b0\u1edbc 2: B\u00e2y gi\u1edd, b\u1ea1n click chu\u1ed9t ph\u1ea3i v\u00e0o khu v\u1ef1c \u0111\u00e3 b\u00f4i r\u1ed3i ch\u1ecdn m\u1ee5c Format Cells. Ti\u1ebfp theo, t\u1ea1i Custom, h\u00e3y nh\u1eadp l\u1ec7nh @*. \u1edf \u00f4 Type r\u1ed3i b\u1ea5m OK\u00a0 \u0111\u1ec3 ho\u00e0n t\u1ea5t qu\u00e1 tr\u00ecnh n\u00e0y.\u00a0<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/02\/ham-viet-hoa-chu-cai-dau-19.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/02\/ham-viet-hoa-chu-cai-dau-19-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/02\/ham-viet-hoa-chu-cai-dau-19-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-320261 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/02\/ham-viet-hoa-chu-cai-dau-19.jpg\" alt=\"ham-viet-hoa-chu-cai-dau-19\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/02\/ham-viet-hoa-chu-cai-dau-19.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/02\/ham-viet-hoa-chu-cai-dau-19-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/02\/ham-viet-hoa-chu-cai-dau-19-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<h3><span style=\"font-weight: 400;\">\u0110\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 v\u1edbi AGGREGATE<\/span><\/h3>\n<p><span style=\"font-weight: 400;\">H\u00e0m AGGREGATE gi\u00fap ng\u01b0\u1eddi d\u00f9ng l\u1ecdc, s\u1eafp x\u1ebfp, x\u00f3a, th\u00eam v\u00e0 qu\u1ea3n l\u00fd d\u1eef li\u1ec7u m\u1ed9t c\u00e1ch nhanh ch\u00f3ng v\u00e0 thu\u1eadn ti\u1ec7n h\u01a1n. Khi s\u1eed d\u1ee5ng h\u00e0m n\u00e0y, b\u1ea1n c\u00f3 th\u1ec3 th\u00eam, b\u1edbt d\u1eef li\u1ec7u m\u00e0 kh\u00f4ng c\u1ea7n lo l\u1eafng s\u1ed1 th\u1ee9 t\u1ef1 b\u1ecb \u0111\u1ea3o l\u1ed9n lung tung.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">B\u01b0\u1edbc 1: T\u1ea1i \u00f4 \u0111\u1ea7u ti\u00ean c\u1ee7a c\u1ed9t c\u1ea7n \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1, b\u1ea1n nh\u1eadp c\u00f4ng th\u1ee9c v\u1edbi c\u00fa ph\u00e1p c\u1ee5 th\u1ec3 l\u00e0:\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400;\">=AGGREGATE(function_num; options; array; [k])<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Trong \u0111\u00f3:<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">function_num: \u0110\u00e2y l\u00e0 s\u1ed1 ch\u1ec9 \u0111\u1ecbnh ch\u1ee9c n\u0103ng b\u1ea1n mu\u1ed1n s\u1eed d\u1ee5ng. Trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y, ch\u00fang ta c\u1ea7n d\u00f9ng COUNTA n\u00ean function_num s\u1ebd l\u00e0 s\u1ed1 3.\u00a0<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">options: \u0110\u00e2y l\u00e0 s\u1ed1\/h\u1eb1ng s\u1ed1 ch\u1ec9 \u0111\u1ecbnh c\u00e1ch x\u1eed l\u00fd gi\u00e1 tr\u1ecb l\u1ed7i ho\u1eb7c gi\u00e1 tr\u1ecb \u1ea9n. \u1ede \u0111\u00e2y ch\u00fang ta s\u1ebd ch\u1ecdn s\u1ed1 3 \u0111\u1ec3 b\u1ecf \u0111i d\u00f2ng l\u1ed7i ho\u1eb7c \u1ea9n.\u00a0<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">array: \u0110\u00e2y l\u00e0 ph\u1ea1m vi d\u1eef li\u1ec7u m\u00e0 b\u1ea1n mu\u1ed1n \u00e1p d\u1ee5ng ch\u1ee9c n\u0103ng tr\u00ean. Trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y, b\u1ea1n ch\u1ecdn C3 r\u1ed3i nh\u1ea5n ph\u00edm F4 \u0111\u1ec3 c\u1ed1 \u0111\u1ecbnh n\u00f3.\u00a0<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">[k]: \u0110\u00e2y l\u00e0 m\u1ed9t tham s\u1ed1 t\u00f9y ch\u1ecdn \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng trong m\u1ed9t s\u1ed1 tr\u01b0\u1eddng h\u1ee3p. Tr\u01b0\u1eddng h\u1ee3p n\u00e0y c\u00f3 th\u1ec3 b\u1ecf qua k.\u00a0<\/span><\/li>\n<\/ul>\n<p><span style=\"font-weight: 400;\">Nh\u01b0 v\u1eady, ta c\u00f3 c\u00f4ng th\u1ee9c cu\u1ed1i c\u00f9ng l\u00e0 =AGGREGATE(3;3;$C$3:C3).<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/02\/ham-viet-hoa-chu-cai-dau-20.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/02\/ham-viet-hoa-chu-cai-dau-20-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/02\/ham-viet-hoa-chu-cai-dau-20-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-320262 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/02\/ham-viet-hoa-chu-cai-dau-20.jpg\" alt=\"ham-viet-hoa-chu-cai-dau-20\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/02\/ham-viet-hoa-chu-cai-dau-20.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/02\/ham-viet-hoa-chu-cai-dau-20-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/02\/ham-viet-hoa-chu-cai-dau-20-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p><span style=\"font-weight: 400;\">B\u01b0\u1edbc 2: Cu\u1ed1i c\u00f9ng, b\u1ea1n ch\u1ec9 c\u1ea7n k\u00e9o gi\u1eef v\u00e0 th\u1ea3 tr\u1ecf chu\u1ed9t \u0111\u1ebfn d\u00f2ng cu\u1ed1i c\u00f9ng m\u00e0 b\u1ea1n mu\u1ed1n \u0111\u1ebfm STT.<\/span><\/p>\n<h2>L\u1eddi k\u1ebft<\/h2>\n<p><span style=\"font-weight: 400;\">Nh\u01b0 v\u1eady, b\u00e0i vi\u1ebft tr\u00ean \u0111\u00e3 h\u01b0\u1edbng d\u1eabn b\u1ea1n c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m vi\u1ebft hoa ch\u1eef c\u00e1i \u0111\u1ea7u v\u00e0 m\u1ed9t s\u1ed1 th\u1ee7 thu\u1eadt trong Excel \u0111\u1ec3 c\u00f3 th\u1ec3 t\u1ea1o n\u00ean m\u1ed9t b\u1ea3ng t\u00ednh chuy\u00ean nghi\u1ec7p, \u0111\u1eb9p m\u1eaft nh\u1ea5t. N\u1ebfu n\u1ed9i dung tr\u00ean h\u1eefu \u00edch, \u0111\u1eebng qu\u00ean chia s\u1ebb \u0111\u1ec3 m\u1ecdi ng\u01b0\u1eddi c\u00f9ng tham kh\u1ea3o nh\u00e9!<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Xem th\u00eam:<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><strong><a href=\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-iferror\/\">H\u00e0m IFERROR trong Excel: C\u00e1ch s\u1eed d\u1ee5ng \u0111\u1ec3 b\u1eaft l\u1ed7i hi\u1ec7u qu\u1ea3<\/a><\/strong><\/li>\n<li style=\"font-weight: 400;\"><strong><a href=\"https:\/\/hoanghamobile.com\/tin-tuc\/cach-xuong-dong-trong-1-o-excel\/\">Top 5 c\u00e1ch xu\u1ed1ng d\u00f2ng trong 1 \u00f4 Excel \u0111\u01a1n gi\u1ea3n nh\u1ea5t<\/a><\/strong><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>\u0110\u1ec3 t\u1ea1o n\u00ean m\u1ed9t b\u1ea3ng t\u00ednh Excel chuy\u00ean nghi\u1ec7p v\u00e0 \u0111\u1eb9p m\u1eaft, ngo\u00e0i vi\u1ec7c s\u1eed d\u1ee5ng c\u00e1c h\u00e0m t\u00ednh to\u00e1n ph\u00f9 h\u1ee3p \u0111\u1ec3 cho ra k\u1ebft qu\u1ea3 s\u1ed1 li\u1ec7u ch\u00ednh x\u00e1c nh\u1ea5t, b\u1ea1n c\u00f2n ph\u1ea3i \u0111\u1ea7u t\u01b0 v\u00e0 ch\u1ec9n chu c\u1ea3 v\u1ec1 m\u1eb7t h\u00ecnh th\u1ee9c. Trong b\u00e0i vi\u1ebft d\u01b0\u1edbi \u0111\u00e2y, Ho\u00e0ng H\u00e0 Mobile s\u1ebd h\u01b0\u1edbng [&hellip;]<\/p>\n","protected":false},"author":97,"featured_media":320242,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[28955,16],"tags":[],"class_list":["post-320241","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel","category-thu-thuat"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v24.2 (Yoast SEO v24.2) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>H\u00e0m vi\u1ebft hoa ch\u1eef c\u00e1i \u0111\u1ea7u trong Excel \u0111\u01a1n gi\u1ea3n nh\u1ea5t<\/title>\n<meta name=\"description\" content=\"S\u1eed d\u1ee5ng h\u00e0m vi\u1ebft hoa ch\u1eef c\u00e1i \u0111\u1ea7u gi\u00fap b\u1ea3ng t\u00ednh tr\u00f4ng chuy\u00ean nghi\u1ec7p v\u00e0 d\u1ec5 theo d\u00f5i h\u01a1n. T\u00ecm hi\u1ec3u c\u00e1c h\u00e0m \u0111\u01b0\u1ee3c chia s\u1ebb trong b\u00e0i vi\u1ebft sau!\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-viet-hoa-chu-cai-dau\/\" \/>\n<meta property=\"og:locale\" content=\"vi_VN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"H\u00e0m vi\u1ebft hoa ch\u1eef c\u00e1i \u0111\u1ea7u trong Excel \u0111\u01a1n gi\u1ea3n nh\u1ea5t\" \/>\n<meta property=\"og:description\" content=\"S\u1eed d\u1ee5ng h\u00e0m vi\u1ebft hoa ch\u1eef c\u00e1i \u0111\u1ea7u gi\u00fap b\u1ea3ng t\u00ednh tr\u00f4ng chuy\u00ean nghi\u1ec7p v\u00e0 d\u1ec5 theo d\u00f5i h\u01a1n. T\u00ecm hi\u1ec3u c\u00e1c h\u00e0m \u0111\u01b0\u1ee3c chia s\u1ebb trong b\u00e0i vi\u1ebft sau!\" \/>\n<meta property=\"og:url\" content=\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-viet-hoa-chu-cai-dau\/\" \/>\n<meta property=\"og:site_name\" content=\"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/hoanghamobilecom\" \/>\n<meta property=\"article:published_time\" content=\"2024-02-29T12:53:17+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/02\/ham-viet-hoa-chu-cai-dau.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1200\" \/>\n\t<meta property=\"og:image:height\" content=\"628\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Nguy\u1ec5n Th\u1ecb M\u1ef9 Li\u00ean\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"\u0110\u01b0\u1ee3c vi\u1ebft b\u1edfi\" \/>\n\t<meta name=\"twitter:data1\" content=\"Nguy\u1ec5n Th\u1ecb M\u1ef9 Li\u00ean\" \/>\n\t<meta name=\"twitter:label2\" content=\"\u01af\u1edbc t\u00ednh th\u1eddi gian \u0111\u1ecdc\" \/>\n\t<meta name=\"twitter:data2\" content=\"16 ph\u00fat\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-viet-hoa-chu-cai-dau\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-viet-hoa-chu-cai-dau\/\"},\"author\":{\"name\":\"Nguy\u1ec5n Th\u1ecb M\u1ef9 Li\u00ean\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/person\/8bdc637e22d0dfe8143434576119c189\"},\"headline\":\"H\u00e0m vi\u1ebft hoa ch\u1eef c\u00e1i \u0111\u1ea7u trong Excel \u0111\u01a1n gi\u1ea3n nh\u1ea5t\",\"datePublished\":\"2024-02-29T12:53:17+00:00\",\"dateModified\":\"2024-02-29T12:53:17+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-viet-hoa-chu-cai-dau\/\"},\"wordCount\":3255,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#organization\"},\"image\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-viet-hoa-chu-cai-dau\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/02\/ham-viet-hoa-chu-cai-dau.jpg\",\"articleSection\":[\"Excel\",\"Th\u1ee7 thu\u1eadt\"],\"inLanguage\":\"vi\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-viet-hoa-chu-cai-dau\/#respond\"]}],\"copyrightYear\":\"2024\",\"copyrightHolder\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#organization\"}},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-viet-hoa-chu-cai-dau\/\",\"url\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-viet-hoa-chu-cai-dau\/\",\"name\":\"H\u00e0m vi\u1ebft hoa ch\u1eef c\u00e1i \u0111\u1ea7u trong Excel \u0111\u01a1n gi\u1ea3n nh\u1ea5t\",\"isPartOf\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-viet-hoa-chu-cai-dau\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-viet-hoa-chu-cai-dau\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/02\/ham-viet-hoa-chu-cai-dau.jpg\",\"datePublished\":\"2024-02-29T12:53:17+00:00\",\"dateModified\":\"2024-02-29T12:53:17+00:00\",\"description\":\"S\u1eed d\u1ee5ng h\u00e0m vi\u1ebft hoa ch\u1eef c\u00e1i \u0111\u1ea7u gi\u00fap b\u1ea3ng t\u00ednh tr\u00f4ng chuy\u00ean nghi\u1ec7p v\u00e0 d\u1ec5 theo d\u00f5i h\u01a1n. T\u00ecm hi\u1ec3u c\u00e1c h\u00e0m \u0111\u01b0\u1ee3c chia s\u1ebb trong b\u00e0i vi\u1ebft sau!\",\"breadcrumb\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-viet-hoa-chu-cai-dau\/#breadcrumb\"},\"inLanguage\":\"vi\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-viet-hoa-chu-cai-dau\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-viet-hoa-chu-cai-dau\/#primaryimage\",\"url\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/02\/ham-viet-hoa-chu-cai-dau.jpg\",\"contentUrl\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/02\/ham-viet-hoa-chu-cai-dau.jpg\",\"width\":1200,\"height\":628,\"caption\":\"ham-viet-hoa-chu-cai-dau\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-viet-hoa-chu-cai-dau\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Trang ch\u1ee7\",\"item\":\"https:\/\/hoanghamobile.com\/tin-tuc\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Th\u1ee7 thu\u1eadt\",\"item\":\"https:\/\/hoanghamobile.com\/tin-tuc\/category\/thu-thuat\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"H\u00e0m vi\u1ebft hoa ch\u1eef c\u00e1i \u0111\u1ea7u trong Excel \u0111\u01a1n gi\u1ea3n nh\u1ea5t\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#website\",\"url\":\"https:\/\/hoanghamobile.com\/tin-tuc\/\",\"name\":\"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/hoanghamobile.com\/tin-tuc\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"vi\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#organization\",\"name\":\"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile\",\"url\":\"https:\/\/hoanghamobile.com\/tin-tuc\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2021\/12\/logo-text.png\",\"contentUrl\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2021\/12\/logo-text.png\",\"width\":256,\"height\":37,\"caption\":\"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile\"},\"image\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/hoanghamobilecom\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/person\/8bdc637e22d0dfe8143434576119c189\",\"name\":\"Nguy\u1ec5n Th\u1ecb M\u1ef9 Li\u00ean\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/litespeed\/avatar\/0aca7f2e3b385bd50913641f6825d6f3.jpg?ver=1774865695\",\"contentUrl\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/litespeed\/avatar\/0aca7f2e3b385bd50913641f6825d6f3.jpg?ver=1774865695\",\"caption\":\"Nguy\u1ec5n Th\u1ecb M\u1ef9 Li\u00ean\"},\"url\":\"https:\/\/hoanghamobile.com\/tin-tuc\/author\/nguyen-thi-my-lien\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"H\u00e0m vi\u1ebft hoa ch\u1eef c\u00e1i \u0111\u1ea7u trong Excel \u0111\u01a1n gi\u1ea3n nh\u1ea5t","description":"S\u1eed d\u1ee5ng h\u00e0m vi\u1ebft hoa ch\u1eef c\u00e1i \u0111\u1ea7u gi\u00fap b\u1ea3ng t\u00ednh tr\u00f4ng chuy\u00ean nghi\u1ec7p v\u00e0 d\u1ec5 theo d\u00f5i h\u01a1n. T\u00ecm hi\u1ec3u c\u00e1c h\u00e0m \u0111\u01b0\u1ee3c chia s\u1ebb trong b\u00e0i vi\u1ebft sau!","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:\/\/hoanghamobile.com\/tin-tuc\/ham-viet-hoa-chu-cai-dau\/","og_locale":"vi_VN","og_type":"article","og_title":"H\u00e0m vi\u1ebft hoa ch\u1eef c\u00e1i \u0111\u1ea7u trong Excel \u0111\u01a1n gi\u1ea3n nh\u1ea5t","og_description":"S\u1eed d\u1ee5ng h\u00e0m vi\u1ebft hoa ch\u1eef c\u00e1i \u0111\u1ea7u gi\u00fap b\u1ea3ng t\u00ednh tr\u00f4ng chuy\u00ean nghi\u1ec7p v\u00e0 d\u1ec5 theo d\u00f5i h\u01a1n. T\u00ecm hi\u1ec3u c\u00e1c h\u00e0m \u0111\u01b0\u1ee3c chia s\u1ebb trong b\u00e0i vi\u1ebft sau!","og_url":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-viet-hoa-chu-cai-dau\/","og_site_name":"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile","article_publisher":"https:\/\/www.facebook.com\/hoanghamobilecom","article_published_time":"2024-02-29T12:53:17+00:00","og_image":[{"width":1200,"height":628,"url":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/02\/ham-viet-hoa-chu-cai-dau.jpg","type":"image\/jpeg"}],"author":"Nguy\u1ec5n Th\u1ecb M\u1ef9 Li\u00ean","twitter_card":"summary_large_image","twitter_misc":{"\u0110\u01b0\u1ee3c vi\u1ebft b\u1edfi":"Nguy\u1ec5n Th\u1ecb M\u1ef9 Li\u00ean","\u01af\u1edbc t\u00ednh th\u1eddi gian \u0111\u1ecdc":"16 ph\u00fat"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-viet-hoa-chu-cai-dau\/#article","isPartOf":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-viet-hoa-chu-cai-dau\/"},"author":{"name":"Nguy\u1ec5n Th\u1ecb M\u1ef9 Li\u00ean","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/person\/8bdc637e22d0dfe8143434576119c189"},"headline":"H\u00e0m vi\u1ebft hoa ch\u1eef c\u00e1i \u0111\u1ea7u trong Excel \u0111\u01a1n gi\u1ea3n nh\u1ea5t","datePublished":"2024-02-29T12:53:17+00:00","dateModified":"2024-02-29T12:53:17+00:00","mainEntityOfPage":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-viet-hoa-chu-cai-dau\/"},"wordCount":3255,"commentCount":0,"publisher":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#organization"},"image":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-viet-hoa-chu-cai-dau\/#primaryimage"},"thumbnailUrl":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/02\/ham-viet-hoa-chu-cai-dau.jpg","articleSection":["Excel","Th\u1ee7 thu\u1eadt"],"inLanguage":"vi","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/hoanghamobile.com\/tin-tuc\/ham-viet-hoa-chu-cai-dau\/#respond"]}],"copyrightYear":"2024","copyrightHolder":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#organization"}},{"@type":"WebPage","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-viet-hoa-chu-cai-dau\/","url":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-viet-hoa-chu-cai-dau\/","name":"H\u00e0m vi\u1ebft hoa ch\u1eef c\u00e1i \u0111\u1ea7u trong Excel \u0111\u01a1n gi\u1ea3n nh\u1ea5t","isPartOf":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#website"},"primaryImageOfPage":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-viet-hoa-chu-cai-dau\/#primaryimage"},"image":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-viet-hoa-chu-cai-dau\/#primaryimage"},"thumbnailUrl":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/02\/ham-viet-hoa-chu-cai-dau.jpg","datePublished":"2024-02-29T12:53:17+00:00","dateModified":"2024-02-29T12:53:17+00:00","description":"S\u1eed d\u1ee5ng h\u00e0m vi\u1ebft hoa ch\u1eef c\u00e1i \u0111\u1ea7u gi\u00fap b\u1ea3ng t\u00ednh tr\u00f4ng chuy\u00ean nghi\u1ec7p v\u00e0 d\u1ec5 theo d\u00f5i h\u01a1n. T\u00ecm hi\u1ec3u c\u00e1c h\u00e0m \u0111\u01b0\u1ee3c chia s\u1ebb trong b\u00e0i vi\u1ebft sau!","breadcrumb":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-viet-hoa-chu-cai-dau\/#breadcrumb"},"inLanguage":"vi","potentialAction":[{"@type":"ReadAction","target":["https:\/\/hoanghamobile.com\/tin-tuc\/ham-viet-hoa-chu-cai-dau\/"]}]},{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-viet-hoa-chu-cai-dau\/#primaryimage","url":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/02\/ham-viet-hoa-chu-cai-dau.jpg","contentUrl":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/02\/ham-viet-hoa-chu-cai-dau.jpg","width":1200,"height":628,"caption":"ham-viet-hoa-chu-cai-dau"},{"@type":"BreadcrumbList","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-viet-hoa-chu-cai-dau\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Trang ch\u1ee7","item":"https:\/\/hoanghamobile.com\/tin-tuc\/"},{"@type":"ListItem","position":2,"name":"Th\u1ee7 thu\u1eadt","item":"https:\/\/hoanghamobile.com\/tin-tuc\/category\/thu-thuat\/"},{"@type":"ListItem","position":3,"name":"H\u00e0m vi\u1ebft hoa ch\u1eef c\u00e1i \u0111\u1ea7u trong Excel \u0111\u01a1n gi\u1ea3n nh\u1ea5t"}]},{"@type":"WebSite","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#website","url":"https:\/\/hoanghamobile.com\/tin-tuc\/","name":"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile","description":"","publisher":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/hoanghamobile.com\/tin-tuc\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"vi"},{"@type":"Organization","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#organization","name":"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile","url":"https:\/\/hoanghamobile.com\/tin-tuc\/","logo":{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/logo\/image\/","url":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2021\/12\/logo-text.png","contentUrl":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2021\/12\/logo-text.png","width":256,"height":37,"caption":"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile"},"image":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/hoanghamobilecom"]},{"@type":"Person","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/person\/8bdc637e22d0dfe8143434576119c189","name":"Nguy\u1ec5n Th\u1ecb M\u1ef9 Li\u00ean","image":{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/person\/image\/","url":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/litespeed\/avatar\/0aca7f2e3b385bd50913641f6825d6f3.jpg?ver=1774865695","contentUrl":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/litespeed\/avatar\/0aca7f2e3b385bd50913641f6825d6f3.jpg?ver=1774865695","caption":"Nguy\u1ec5n Th\u1ecb M\u1ef9 Li\u00ean"},"url":"https:\/\/hoanghamobile.com\/tin-tuc\/author\/nguyen-thi-my-lien\/"}]}},"_links":{"self":[{"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/posts\/320241","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/users\/97"}],"replies":[{"embeddable":true,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/comments?post=320241"}],"version-history":[{"count":0,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/posts\/320241\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/media\/320242"}],"wp:attachment":[{"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/media?parent=320241"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/categories?post=320241"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/tags?post=320241"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}