{"id":35228,"date":"2022-04-12T15:06:36","date_gmt":"2022-04-12T08:06:36","guid":{"rendered":"https:\/\/divineshop.vn\/tin-tuc\/?p=35228"},"modified":"2022-05-09T11:19:29","modified_gmt":"2022-05-09T04:19:29","slug":"mach-ban-cach-loc-trung-excel-cuc-don-gian-ma-ai-cung-thuc-hien-duoc","status":"publish","type":"post","link":"https:\/\/divineshop.vn\/tin-tuc\/mach-ban-cach-loc-trung-excel-cuc-don-gian-ma-ai-cung-thuc-hien-duoc\/","title":{"rendered":"M\u00e1ch b\u1ea1n c\u00e1ch l\u1ecdc tr\u00f9ng Excel c\u1ef1c \u0111\u01a1n gi\u1ea3n m\u00e0 ai c\u0169ng th\u1ef1c hi\u1ec7n \u0111\u01b0\u1ee3c"},"content":{"rendered":"<div class=\"content-inner\">\n<p><strong>\u0110\u1eebng b\u1ecf qua b\u00e0i vi\u1ebft n\u00e0y n\u1ebfu nh\u01b0 b\u1ea1n kh\u00f4ng bi\u1ebft c\u00e1ch l\u1ecdc d\u1eef li\u1ec7u tr\u00f9ng trong Excel nh\u00e9.<\/strong><\/p>\n<p>\u0110\u00f4i l\u00fac, khi so\u1ea1n th\u1ea3o d\u1eef li\u1ec7u v\u00e0 b\u00e1o c\u00e1o nhi\u1ec1u ng\u01b0\u1eddi d\u00f9ng c\u1ea3m th\u1ea5y m\u1ec7t m\u1ecfi v\u00e0 r\u1eafc r\u1ed1i b\u1edfi xu\u1ea5t hi\u1ec7n nhi\u1ec1u th\u00f4ng tin tr\u00f9ng l\u1eb7p. \u0110\u1eb7c bi\u1ec7t l\u00e0 nh\u1eefng b\u1ea3ng d\u1eef li\u1ec7u ch\u1ee9a nhi\u1ec1u th\u00f4ng tin r\u1ea5t m\u1ea5t th\u1eddi gian \u0111\u1ec3 t\u00ecm ki\u1ebfm nh\u1eefng d\u1eef li\u1ec7u b\u1ecb tr\u00f9ng l\u1eb7p. Ch\u00ednh v\u00ec th\u1ebf, trong b\u00e0i vi\u1ebft d\u01b0\u1edbi \u0111\u00e2y, Divine Shop s\u1ebd chia s\u1ebb cho b\u1ea1n c\u00e1ch l\u1ecdc tr\u00f9ng Excel nhanh ch\u00f3ng v\u00e0 \u0111\u01a1n gi\u1ea3n.<\/p>\n<p><img loading=\"lazy\" class=\"aligncenter size-full wp-image-543900\" src=\"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/mach-ban-cach-loc-trung-excel-cuc-don-gian-ma-ai-cung-thuc-hien-duoc_6239a5db061b4.png\" alt=\"L\u1ecdc tr\u00f9ng Excel\" width=\"1280\" height=\"720\" \/><\/p>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_17 counter-hierarchy counter-decimal ez-toc-grey\">\n<h2><span class=\"ez-toc-section\" id=\"Huong_dan_cach_loc_trung_Excel_chi_tiet_nhat\"><\/span><span id=\"Huong_dan_cach_loc_trung_Excel_chi_tiet_nhat\" class=\"ez-toc-section\"><\/span><strong><span style=\"font-size: 18pt;\">H\u01b0\u1edbng d\u1eabn c\u00e1ch l\u1ecdc tr\u00f9ng Excel chi ti\u1ebft nh\u1ea5t<\/span><\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<h3><span class=\"ez-toc-section\" id=\"Cach_loc_du_lieu_trung_trong_Excel_bang_Remove_Duplicate\"><\/span><span id=\"Cach_loc_du_lieu_trung_trong_Excel_bang_Remove_Duplicate\" class=\"ez-toc-section\"><\/span><strong><span style=\"font-size: 14pt;\">C\u00e1ch l\u1ecdc d\u1eef li\u1ec7u tr\u00f9ng trong Excel b\u1eb1ng Remove Duplicate<\/span><\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\u0110\u1ec3 th\u1ef1c hi\u1ec7n c\u00e1ch l\u1ecdc d\u1eef li\u1ec7u trong Excel, ch\u00fang t\u00f4i \u0111\u00e3 \u0111\u01b0a ra m\u1ed9t v\u00ed d\u1ee5 nh\u01b0 h\u00ecnh d\u01b0\u1edbi \u0111\u00e2y. B\u1ea1n s\u1ebd th\u1ea5y v\u00f9ng d\u1eef li\u1ec7u tr\u00f9ng l\u1eb7p trong b\u1ea3ng t\u00ednh \u0111\u01b0\u1ee3c ch\u00fang t\u00f4i khoanh \u0111\u1ecf.<\/p>\n<p><img loading=\"lazy\" class=\"aligncenter wp-image-543857 size-full\" src=\"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/mach-ban-cach-loc-trung-excel-cuc-don-gian-ma-ai-cung-thuc-hien-duoc_6239a5ded378c.jpeg\" alt=\"C\u00e1ch l\u1ecdc d\u1eef li\u1ec7u tr\u00f9ng trong Excel b\u1eb1ng Remove Duplicate b\u01b0\u1edbc 1\" width=\"1033\" height=\"577\" \/><\/p>\n<p>Ti\u1ebfn h\u00e0nh thao t\u00e1c l\u1ecdc tr\u00f9ng Excel theo c\u00e1c b\u01b0\u1edbc sau:<\/p>\n<p><strong>B\u01b0\u1edbc 1:<\/strong> Tr\u00ean b\u1ea3ng t\u00ednh \u0111ang tr\u00f9ng d\u1eef li\u1ec7u, b\u1ea1n<strong> ti\u1ebfn h\u00e0nh b\u00f4i \u0111en v\u1ecb tr\u00ed d\u1eef li\u1ec7u<\/strong> mu\u1ed1n l\u1ecdc tr\u00f9ng.<\/p>\n<p><img loading=\"lazy\" class=\"aligncenter wp-image-543856 size-full\" src=\"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/mach-ban-cach-loc-trung-excel-cuc-don-gian-ma-ai-cung-thuc-hien-duoc_6239a5df997c7.jpeg\" alt=\"C\u00e1ch l\u1ecdc d\u1eef li\u1ec7u tr\u00f9ng trong Excel b\u1eb1ng Remove Duplicate b\u01b0\u1edbc 2\" width=\"1032\" height=\"575\" \/><\/p>\n<p><strong>B\u01b0\u1edbc 2:<\/strong> Tr\u00ean thanh c\u00f4ng c\u1ee5, ch\u1ecdn Data &gt; Ch\u1ecdn t\u00ednh n\u0103ng <strong>Remove Duplicates.\u00a0<\/strong><\/p>\n<p><img loading=\"lazy\" class=\"aligncenter wp-image-543858 size-full\" src=\"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/mach-ban-cach-loc-trung-excel-cuc-don-gian-ma-ai-cung-thuc-hien-duoc_6239a5e0786d7.jpeg\" alt=\"C\u00e1ch l\u1ecdc d\u1eef li\u1ec7u tr\u00f9ng trong Excel b\u1eb1ng Remove Duplicate b\u01b0\u1edbc 3\" width=\"1232\" height=\"622\" \/><\/p>\n<p><strong>B\u01b0\u1edbc 3:<\/strong> L\u00fac n\u00e0y, h\u1ed9p tho\u1ea1i Remove Duplicates hi\u1ec3n th\u1ecb, <strong>\u0111\u00e1nh d\u1ea5u t\u00edch v\u00e0o c\u1ed9t d\u1eef li\u1ec7u m\u00e0 b\u1ea1n mu\u1ed1n l\u1ecdc d\u1eef li\u1ec7u<\/strong>. N\u1ebfu nh\u01b0 b\u1ea1n mu\u1ed1n<strong> l\u1ecdc d\u1eef li\u1ec7u cho t\u1ea5t c\u1ea3 c\u00e1c c\u1ed9t th\u00ec b\u1ea5m ch\u1ecdn Select All<\/strong> &gt; <strong>Nh\u1ea5n OK<\/strong> \u0111\u1ec3 l\u01b0u thay \u0111\u1ed5i.<\/p>\n<p><img loading=\"lazy\" class=\"aligncenter wp-image-543859 size-full\" src=\"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/mach-ban-cach-loc-trung-excel-cuc-don-gian-ma-ai-cung-thuc-hien-duoc_6239a5e22862e.jpeg\" alt=\"C\u00e1ch l\u1ecdc d\u1eef li\u1ec7u tr\u00f9ng trong Excel b\u1eb1ng Remove Duplicate b\u01b0\u1edbc 4\" width=\"1229\" height=\"623\" \/><\/p>\n<p><strong>B\u01b0\u1edbc 4:<\/strong> Ngay l\u1eadp t\u1ee9c, h\u1ec7 th\u1ed1ng s\u1ebd tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 l\u1ecdc tr\u00f9ng ch\u00ednh x\u00e1c tr\u00ean b\u1ea3ng t\u00ednh m\u00e0 b\u1ea1n \u0111\u00e3 b\u00f4i \u0111en ban \u0111\u1ea7u.<\/p>\n<p><img loading=\"lazy\" class=\"aligncenter wp-image-543860 size-full\" src=\"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/mach-ban-cach-loc-trung-excel-cuc-don-gian-ma-ai-cung-thuc-hien-duoc_6239a5e3c018c.jpeg\" alt=\"C\u00e1ch l\u1ecdc d\u1eef li\u1ec7u tr\u00f9ng trong Excel b\u1eb1ng Remove Duplicate b\u01b0\u1edbc 5\" width=\"1230\" height=\"602\" \/><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Su_dung_Conditional_Formatting_de_tim_du_lieu_trung_trong_Excel_va_loc_gia_tri_trung_trong_Excel\"><\/span><span id=\"Su_dung_Conditional_Formatting_de_tim_du_lieu_trung_trong_Excel_va_loc_gia_tri_trung_trong_Excel\" class=\"ez-toc-section\"><\/span><strong><span style=\"font-size: 14pt;\">S\u1eed d\u1ee5ng Conditional Formatting \u0111\u1ec3 t\u00ecm d\u1eef li\u1ec7u tr\u00f9ng trong Excel v\u00e0 l\u1ecdc gi\u00e1 tr\u1ecb tr\u00f9ng trong Excel\u00a0<\/span><\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><strong>B\u01b0\u1edbc 1:<\/strong> T\u00f4 \u0111en v\u00f9ng d\u1eef li\u1ec7u b\u1ea1n mu\u1ed1n t\u00ecm ki\u1ebfm d\u1eef li\u1ec7u b\u1ecb tr\u00f9ng trong b\u1ea3ng t\u00ednh Excel.<\/p>\n<p><img loading=\"lazy\" class=\"aligncenter wp-image-543856 size-full\" src=\"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/mach-ban-cach-loc-trung-excel-cuc-don-gian-ma-ai-cung-thuc-hien-duoc_6239a5df997c7.jpeg\" alt=\"S\u1eed d\u1ee5ng Conditional Formatting \u0111\u1ec3 t\u00ecm d\u1eef li\u1ec7u tr\u00f9ng trong Excel v\u00e0 l\u1ecdc gi\u00e1 tr\u1ecb tr\u00f9ng trong Excel\u00a0 b\u01b0\u1edbc 1\" width=\"1032\" height=\"575\" \/><\/p>\n<p><strong>B\u01b0\u1edbc 2: Ch\u1ecdn Home<\/strong> tr\u00ean thanh menu &gt; Sau \u0111\u00f3, b\u1ea1n b\u1ea5m ti\u1ebfp v\u00e0o c\u00e1c m\u1ee5c l\u1ea7n l\u01b0\u1ee3t l\u00e0 <strong>Conditional Formatting <\/strong>&gt;<strong> Highlight Cells Rules <\/strong>&gt;<strong> Duplicate Value.<\/strong><\/p>\n<p><img loading=\"lazy\" class=\"aligncenter wp-image-543861 size-full\" src=\"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/mach-ban-cach-loc-trung-excel-cuc-don-gian-ma-ai-cung-thuc-hien-duoc_6239a5e5281e6.jpeg\" alt=\"S\u1eed d\u1ee5ng Conditional Formatting \u0111\u1ec3 t\u00ecm d\u1eef li\u1ec7u tr\u00f9ng trong Excel v\u00e0 l\u1ecdc gi\u00e1 tr\u1ecb tr\u00f9ng trong Excel\u00a0 b\u01b0\u1edbc 2\" width=\"1229\" height=\"619\" \/><\/p>\n<p><strong>B\u01b0\u1edbc 3:<\/strong> H\u1ed9p tho\u1ea1i New Formatting Rule xu\u1ea5t hi\u1ec7n v\u1edbi m\u1ed9t s\u1ed1 t\u00f9y ch\u1ecdn gi\u00fap b\u1ea1n t\u00ecm ki\u1ebfm d\u1eef li\u1ec7u tr\u00f9ng l\u1eb7p nh\u01b0 sau:<\/p>\n<p><strong>L\u1ef1a ch\u1ecdn ph\u01b0\u01a1ng th\u1ee9c l\u1ecdc tr\u00f9ng Excel:\u00a0<\/strong><\/p>\n<ul>\n<li><strong>Duplicate:<\/strong> H\u1ec7 th\u1ed1ng s\u1ebd t\u1ef1 \u0111\u1ed9ng l\u1ecdc gi\u00e1 tr\u1ecb tr\u00f9ng Excel trong khu v\u1ef1c \u0111\u01b0\u1ee3c t\u00f4 \u0111\u1ecf.<\/li>\n<li><strong>Unique:<\/strong> L\u1ecdc nh\u1eefng gi\u00e1 tr\u1ecb duy nh\u1ea5t c\u00f3 trong b\u1ea3ng d\u1eef li\u1ec7u.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" class=\"aligncenter wp-image-543862 size-full\" src=\"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/mach-ban-cach-loc-trung-excel-cuc-don-gian-ma-ai-cung-thuc-hien-duoc_6239a5e666078.jpeg\" alt=\"S\u1eed d\u1ee5ng Conditional Formatting \u0111\u1ec3 t\u00ecm d\u1eef li\u1ec7u tr\u00f9ng trong Excel v\u00e0 l\u1ecdc gi\u00e1 tr\u1ecb tr\u00f9ng trong Excel\u00a0 b\u01b0\u1edbc 3\" width=\"1233\" height=\"625\" \/><\/p>\n<p>L\u1ef1a ch\u1ecdn <strong>ki\u1ec3u \u0111\u00e1nh d\u1ea5u v\u00e0 t\u00f4 m\u00e0u<\/strong> m\u00e0 b\u1ea1n y\u00eau th\u00edch \u0111\u1ec3 l\u1ecdc tr\u00f9ng d\u1eef li\u1ec7u trong Excel:<\/p>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\"><strong>Light red fill with dark red text: <\/strong>D\u00f9ng m\u00e0u \u0111\u1ecf v\u1edbi ch\u1eef m\u00e0u \u0111\u1ecf \u0111\u1eadm.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\"><strong>Yellow fill with dark yellow text:<\/strong> S\u1eed d\u1ee5ng n\u1ec1n m\u00e0u v\u00e0ng v\u1edbi ch\u1eef m\u00e0u v\u00e0ng \u0111\u1eadm.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\"><strong>Green fill with dark green text:<\/strong> S\u1eed d\u1ee5ng n\u1ec1n m\u00e0u xanh v\u00e0 ch\u1eef hi\u1ec3n th\u1ecb m\u00e0u xanh \u0111en.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\"><strong>Light red fill:<\/strong> N\u1ec1n \u0111\u01b0\u1ee3c t\u00f4 \u0111\u1ecf v\u00e0 m\u00e0u ch\u1eef \u0111\u01b0\u1ee3c gi\u1eef nguy\u00ean. <\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\"><strong>Red text: <\/strong>Ch\u1eef \u0111\u01b0\u1ee3c \u0111\u1ed5i sang m\u00e0u \u0111\u1ecf nh\u01b0ng m\u00e0u n\u1ec1n \u0111\u01b0\u1ee3c gi\u1eef nguy\u00ean kh\u00f4ng \u0111\u1ed5i. <\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\"><strong>Red border:<\/strong> C\u00e1c gi\u00e1 tr\u1ecb tr\u00f9ng nhau s\u1ebd \u0111\u01b0\u1ee3c t\u1ef1 \u0111\u1ed9ng t\u00f4 khung vi\u1ec1n m\u00e0u \u0111\u1ecf.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\"><strong>Custom format:<\/strong> T\u1ef1 \u0111\u1ed9ng t\u00f9y ch\u1ec9nh m\u00e0u s\u1eafc ch\u1eef\u00a0 v\u00e0 m\u00e0u n\u1ec1n theo s\u1edf th\u00edch c\u1ee7a m\u00ecnh.<\/span><\/li>\n<\/ul>\n<p><img loading=\"lazy\" class=\"aligncenter wp-image-543861 size-full\" src=\"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/mach-ban-cach-loc-trung-excel-cuc-don-gian-ma-ai-cung-thuc-hien-duoc_6239a5e5281e6.jpeg\" alt=\"S\u1eed d\u1ee5ng Conditional Formatting \u0111\u1ec3 t\u00ecm d\u1eef li\u1ec7u tr\u00f9ng trong Excel v\u00e0 l\u1ecdc gi\u00e1 tr\u1ecb tr\u00f9ng trong Excel\u00a0 b\u01b0\u1edbc 3.1\" width=\"1229\" height=\"619\" \/><\/p>\n<p>L\u1ef1a ch\u1ecdn m\u1ed9t trong c\u00e1c t\u00f9y ch\u1ecdn sau v\u00e0 nh\u1eadn \u0111\u01b0\u1ee3c k\u1ebft qu\u1ea3 nh\u01b0 sau:<\/p>\n<p><img loading=\"lazy\" class=\"aligncenter wp-image-543864 size-full\" src=\"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/mach-ban-cach-loc-trung-excel-cuc-don-gian-ma-ai-cung-thuc-hien-duoc_6239a5e791d5c.jpeg\" alt=\"S\u1eed d\u1ee5ng Conditional Formatting \u0111\u1ec3 t\u00ecm d\u1eef li\u1ec7u tr\u00f9ng trong Excel v\u00e0 l\u1ecdc gi\u00e1 tr\u1ecb tr\u00f9ng trong Excel\u00a0 b\u01b0\u1edbc 4\" width=\"1232\" height=\"622\" \/><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Cach_loc_danh_sach_trung_trong_Excel_bang_Advanced_Filter\"><\/span><span id=\"Cach_loc_danh_sach_trung_trong_Excel_bang_Advanced_Filter\" class=\"ez-toc-section\"><\/span><strong><span style=\"font-size: 14pt;\">C\u00e1ch l\u1ecdc danh s\u00e1ch tr\u00f9ng trong Excel b\u1eb1ng Advanced Filter<\/span><\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><strong>B\u01b0\u1edbc 1:<\/strong> Tr\u01b0\u1edbc ti\u00ean, b\u1ea1n ti\u1ebfn h\u00e0nh <strong>ch\u1ecdn khu v\u1ef1c \u00f4 ho\u1eb7c c\u1ed9t mu\u1ed1n l\u1ecdc tr\u00f9ng Excel.<\/strong><\/p>\n<p><img loading=\"lazy\" class=\"aligncenter wp-image-543872 size-full\" src=\"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/mach-ban-cach-loc-trung-excel-cuc-don-gian-ma-ai-cung-thuc-hien-duoc_6239a5e87ef9b.jpeg\" alt=\"C\u00e1ch l\u1ecdc danh s\u00e1ch tr\u00f9ng trong Excel b\u1eb1ng Advanced Filter b\u01b0\u1edbc 1\" width=\"1030\" height=\"619\" \/><\/p>\n<p><strong>B\u01b0\u1edbc 2:<\/strong> <strong>\u1ea4n ch\u1ecdn tab Data<\/strong> tr\u00ean thanh c\u00f4ng c\u1ee5 &gt; Trong ph\u1ea7n Sort &amp; Filter,<strong> nh\u1ea5n ch\u1ecdn m\u1ee5c Advanced.<\/strong><\/p>\n<p><img loading=\"lazy\" class=\"aligncenter wp-image-543877 size-full\" src=\"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/mach-ban-cach-loc-trung-excel-cuc-don-gian-ma-ai-cung-thuc-hien-duoc_6239a5e9c21a2.jpeg\" alt=\"C\u00e1ch l\u1ecdc danh s\u00e1ch tr\u00f9ng trong Excel b\u1eb1ng Advanced Filter b\u01b0\u1edbc 2\" width=\"1030\" height=\"619\" \/><\/p>\n<p><strong>B\u01b0\u1edbc 3:<\/strong> Ti\u1ebfp theo, h\u1ed9p tho\u1ea1i <strong>Advanced Filter<\/strong> xu\u1ea5t hi\u1ec7n, b\u1ea1n b\u1ea5m ch\u1ecdn m\u1ee5c<strong> Copy to another location.<\/strong><\/p>\n<p><img loading=\"lazy\" class=\"aligncenter wp-image-543873 size-full\" src=\"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/mach-ban-cach-loc-trung-excel-cuc-don-gian-ma-ai-cung-thuc-hien-duoc_6239a5eb73bb8.jpeg\" alt=\"C\u00e1ch l\u1ecdc danh s\u00e1ch tr\u00f9ng trong Excel b\u1eb1ng Advanced Filter b\u01b0\u1edbc 3\" width=\"1036\" height=\"624\" \/><\/p>\n<p>K\u1ebf ti\u1ebfp, \u1edf m\u1ee5c <strong>Copy to<\/strong>, b\u1ea1n <strong>ti\u1ebfn h\u00e0nh l\u1ef1a ch\u1ecdn \u00f4 tham chi\u1ebfu \u1edf b\u00ean ph\u1ea3i b\u1ea3ng d\u1eef li\u1ec7u<\/strong> v\u00e0 <strong>ch\u1ecdn v\u1ecb tr\u00ed l\u1ecdc d\u1eef li\u1ec7u.<\/strong><\/p>\n<p><img loading=\"lazy\" class=\"aligncenter wp-image-543874 size-full\" src=\"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/mach-ban-cach-loc-trung-excel-cuc-don-gian-ma-ai-cung-thuc-hien-duoc_6239a5ecd9564.jpeg\" alt=\"C\u00e1ch l\u1ecdc danh s\u00e1ch tr\u00f9ng trong Excel b\u1eb1ng Advanced Filter b\u01b0\u1edbc 4\" width=\"1032\" height=\"623\" \/><\/p>\n<p>\u0110\u00e1nh d\u1ea5u t\u00edch v\u00e0o m\u1ee5c <strong>Unique records only<\/strong> &gt;<strong> Nh\u1ea5p OK<\/strong> \u0111\u1ec3 ho\u00e0n t\u1ea5t.<\/p>\n<p><img loading=\"lazy\" class=\"aligncenter wp-image-543875 size-full\" src=\"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/mach-ban-cach-loc-trung-excel-cuc-don-gian-ma-ai-cung-thuc-hien-duoc_6239a5eec0a60.jpeg\" alt=\"C\u00e1ch l\u1ecdc danh s\u00e1ch tr\u00f9ng trong Excel b\u1eb1ng Advanced Filter b\u01b0\u1edbc 5\" width=\"1035\" height=\"623\" \/><\/p>\n<p><strong>B\u01b0\u1edbc 4:<\/strong> \u1ede v\u00f9ng m\u00e0 b\u1ea1n \u0111\u00e3 ch\u1ecdn \u1edf m\u1ee5c <strong>Copy<\/strong> <strong>to<\/strong> s\u1ebd xu\u1ea5t hi\u1ec7n d\u1eef li\u1ec7u \u0111\u00e3 \u0111\u01b0\u1ee3c l\u1ecdc xong.<\/p>\n<p><img loading=\"lazy\" class=\"aligncenter wp-image-543876 size-full\" src=\"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/mach-ban-cach-loc-trung-excel-cuc-don-gian-ma-ai-cung-thuc-hien-duoc_6239a5eff3f8b.jpeg\" alt=\"C\u00e1ch l\u1ecdc danh s\u00e1ch tr\u00f9ng trong Excel b\u1eb1ng Advanced Filter b\u01b0\u1edbc 6\" width=\"1034\" height=\"623\" \/><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Cach_loc_ten_trung_trong_Excel_bang_Pivot_Table\"><\/span><span id=\"Cach_loc_ten_trung_trong_Excel_bang_Pivot_Table\" class=\"ez-toc-section\"><\/span><strong><span style=\"font-size: 14pt;\">C\u00e1ch l\u1ecdc t\u00ean tr\u00f9ng trong Excel b\u1eb1ng Pivot Table<\/span><\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Vi\u1ec7c s\u1eed d\u1ee5ng Pivot Table \u0111\u1ec3 l\u1ecdc tr\u00f9ng Excel r\u1ea5t t\u1ed1t, khi th\u1ef1c hi\u1ec7n c\u00e1ch n\u00e0y c\u00e1c b\u1ea1n kh\u00f4ng c\u1ea7n ph\u1ea3i x\u00f3a c\u00e1c gi\u00e1 tr\u1ecb tr\u00f9ng ra kh\u1ecfi d\u1eef li\u1ec7u c\u1ee7a m\u00ecnh m\u00e0 n\u00f3 s\u1ebd l\u1ecdc nh\u1eefng gi\u00e1 tr\u1ecb duy nh\u1ea5t c\u00f3 trong b\u1ea3ng d\u1eef li\u1ec7u. Th\u1ef1c hi\u1ec7n nh\u01b0 sau:<\/p>\n<p><strong>B\u01b0\u1edbc 1:<\/strong> \u0110\u1ea7u ti\u00ean, h\u00e3y ti\u1ebfn h\u00e0nh t\u1ea1o Pivot Table \u1edf d\u1eef li\u1ec7u c\u1ee7a b\u1ea1n b\u1eb1ng c\u00e1ch<strong> nh\u1ea5n ch\u1ecdn v\u00e0o m\u1ed9t \u00f4 b\u1ea5t k\u1ef3 trong b\u1ea3ng d\u1eef li\u1ec7u hay to\u00e0n b\u1ed9 v\u00f9ng d\u1eef li\u1ec7u<\/strong> &gt; Ti\u1ebfp theo, b\u1ea1n<strong> \u1ea5n Insert<\/strong> &gt; Ch\u1ecdn ti\u1ebfp <strong>Pivot Table<\/strong> &gt; <strong>B\u1ea5m OK<\/strong> \u0111\u1ec3 ho\u00e0n t\u1ea5t thay \u0111\u1ed5i.<\/p>\n<p><img loading=\"lazy\" class=\"aligncenter wp-image-543879 size-full\" src=\"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/mach-ban-cach-loc-trung-excel-cuc-don-gian-ma-ai-cung-thuc-hien-duoc_6239a5f15a424.jpeg\" alt=\"C\u00e1ch l\u1ecdc t\u00ean tr\u00f9ng trong Excel b\u1eb1ng Pivot Table b\u01b0\u1edbc 1\" width=\"1033\" height=\"623\" \/><\/p>\n<p><strong>B\u01b0\u1edbc 2:<\/strong> Khi b\u1ea3ng Pivot Table m\u1edbi xu\u1ea5t hi\u1ec7n, b\u1ea1n <strong>ti\u1ebfn h\u00e0nh \u0111\u00e1nh d\u1ea5u v\u00e0o d\u1eef li\u1ec7u \u0111\u1ec3 v\u00f9ng d\u1eef li\u1ec7u \u0111\u01b0\u1ee3c th\u00eam \u0111\u1ea7y \u0111\u1ee7 v\u00e0o khu v\u1ef1c Row trong b\u1ea3ng.<\/strong><\/p>\n<p><img loading=\"lazy\" class=\"aligncenter wp-image-543880 size-full\" src=\"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/mach-ban-cach-loc-trung-excel-cuc-don-gian-ma-ai-cung-thuc-hien-duoc_6239a5f335ff2.jpeg\" alt=\"C\u00e1ch l\u1ecdc t\u00ean tr\u00f9ng trong Excel b\u1eb1ng Pivot Table b\u01b0\u1edbc 2\" width=\"1077\" height=\"622\" \/><\/p>\n<p><strong>B\u01b0\u1edbc 3:<\/strong> Sau \u0111\u00f3, b\u1ea1n<strong> b\u1ea5m v\u00e0o tab Design<\/strong> &gt; <strong>Ch\u1ecdn t\u00f9y ch\u1ecdn Report Layout<\/strong> \u0111\u1ec3 Pivot Table c\u00f3 d\u1ea1ng b\u1ea3ng &gt; L\u00fac n\u00e0y, b\u1ea1n h\u00e3y <strong>ch\u1ecdn l\u1ea7n l\u01b0\u1ee3t 2 t\u00f9y ch\u1ecdn Show in Tabular Form<\/strong> v\u00e0<strong> Repeat All Item Labels.<\/strong><\/p>\n<p><img loading=\"lazy\" class=\"aligncenter wp-image-543881 size-full\" src=\"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/mach-ban-cach-loc-trung-excel-cuc-don-gian-ma-ai-cung-thuc-hien-duoc_6239a5f540cdb.jpeg\" alt=\"C\u00e1ch l\u1ecdc t\u00ean tr\u00f9ng trong Excel b\u1eb1ng Pivot Table b\u01b0\u1edbc 3\" width=\"1076\" height=\"623\" \/><\/p>\n<p><strong>B\u01b0\u1edbc 4:<\/strong> Gi\u1edd b\u1ea1n ti\u1ebfp t\u1ee5c<strong> th\u1ef1c hi\u1ec7n vi\u1ec7c x\u00f3a b\u1ecf nh\u1eefng subtotals<\/strong> <strong>kh\u1ecfi Pivot Table<\/strong> b\u1eb1ng c\u00e1ch<strong> nh\u1ea5p v\u00e0o tab Design<\/strong> &gt; <strong>B\u1ea5m ti\u1ebfp v\u00e0o Subtotals<\/strong> &gt; Click ch\u1ecdn m\u1ee5c <strong>Do Not Show Subtotals.<\/strong><\/p>\n<p><img loading=\"lazy\" class=\"aligncenter wp-image-543884 size-full\" src=\"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/mach-ban-cach-loc-trung-excel-cuc-don-gian-ma-ai-cung-thuc-hien-duoc_6239a5f72ebbe.jpeg\" alt=\"C\u00e1ch l\u1ecdc t\u00ean tr\u00f9ng trong Excel b\u1eb1ng Pivot Table b\u01b0\u1edbc 4\" width=\"1076\" height=\"623\" \/><\/p>\n<p><strong>B\u01b0\u1edbc 5:<\/strong> Nh\u01b0 v\u1eady, b\u1ea1n \u0111\u00e3<strong> ho\u00e0n t\u1ea5t vi\u1ec7c l\u1ecdc tr\u00f9ng t\u00ean b\u1eb1ng Pivot Table<\/strong>, nh\u1eefng th\u00f4ng tin tr\u00ean Pivot Table gi\u1ed1ng nh\u01b0 m\u1ed9t b\u1ea3ng d\u1eef li\u1ec7u th\u00f4ng th\u01b0\u1eddng.<\/p>\n<p><img loading=\"lazy\" class=\"aligncenter wp-image-543885 size-full\" src=\"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/mach-ban-cach-loc-trung-excel-cuc-don-gian-ma-ai-cung-thuc-hien-duoc_6239a5f832704.jpeg\" alt=\"C\u00e1ch l\u1ecdc t\u00ean tr\u00f9ng trong Excel b\u1eb1ng Pivot Table b\u01b0\u1edbc 5\" width=\"1077\" height=\"618\" \/><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Check_trung_trong_Excel_bang_Power_Query\"><\/span><span id=\"Check_trung_trong_Excel_bang_Power_Query\" class=\"ez-toc-section\"><\/span><strong><span style=\"font-size: 14pt;\">Check tr\u00f9ng trong Excel b\u1eb1ng Power Query<\/span><\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>T\u00ednh n\u0103ng Power Query s\u1ebd gi\u00fap gi\u1ea3i quy\u1ebft m\u1ecdi v\u1ea5n \u0111\u1ec1 li\u00ean quan \u0111\u1ebfn vi\u1ec7c chuy\u1ec3n \u0111\u1ed5i d\u1eef li\u1ec7u. Ch\u00ednh v\u00ec th\u1ebf, s\u1eed d\u1ee5ng t\u00ednh n\u0103ng n\u00e0y gi\u00fap b\u1ea1n check tr\u00f9ng trong Excel v\u00e0 x\u00f3a c\u00e1c gi\u00e1 tr\u1ecb tr\u00f9ng nhanh ch\u00f3ng. Th\u1ef1c hi\u1ec7n nh\u01b0 sau:<\/p>\n<p><strong>B\u01b0\u1edbc 1:<\/strong> <strong>Ch\u1ecdn v\u1ecb tr\u00ed b\u1ea3ng d\u1eef li\u1ec7<\/strong>u m\u00e0 b\u1ea1n <strong>mu\u1ed1n ki\u1ec3m tra v\u00e0 lo\u1ea1i b\u1ecf gi\u00e1 tr\u1ecb tr\u00f9ng l\u1eb7p<\/strong> &gt; Tr\u00ean thanh c\u00f4ng c\u1ee5, b\u1ea1n<strong> ch\u1ecdn Data<\/strong> &gt; Ch\u1ecdn ti\u1ebfp v\u00e0o<strong> From Table.<\/strong><\/p>\n<p><img loading=\"lazy\" class=\"aligncenter wp-image-543893 size-full\" src=\"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/mach-ban-cach-loc-trung-excel-cuc-don-gian-ma-ai-cung-thuc-hien-duoc_6239a5fa45065.jpeg\" alt=\"Check tr\u00f9ng trong Excel b\u1eb1ng Power Query b\u01b0\u1edbc 1\" width=\"1079\" height=\"624\" \/><\/p>\n<p><span style=\"font-weight: 400;\"><strong>B\u01b0\u1edbc 2:<\/strong> Th\u1ef1c hi\u1ec7n lo\u1ea1i b\u1ecf tr\u00f9ng l\u1eb7p trong c\u1ed9t b\u1eb1ng c\u00e1ch nh\u1ea5n v\u00e0o<strong> tab Home<\/strong> &gt; Ch\u1ecdn ti\u1ebfp v\u00e0o m\u1ee5c <\/span><span style=\"font-weight: 400;\"><strong> Remove Duplicates<\/strong> \u0111\u1ec3 xo\u00e1 c\u00e1c gi\u00e1 tr\u1ecb tr\u00f9ng l\u1eb7p.\u00a0<\/span><\/p>\n<p><img loading=\"lazy\" class=\"aligncenter wp-image-543891 size-full\" src=\"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/mach-ban-cach-loc-trung-excel-cuc-don-gian-ma-ai-cung-thuc-hien-duoc_6239a5fd14a24.jpeg\" alt=\"Check tr\u00f9ng trong Excel b\u1eb1ng Power Query b\u01b0\u1edbc 2\" width=\"1177\" height=\"732\" \/><\/p>\n<p><strong>B\u01b0\u1edbc 3:<\/strong> Sau khi th\u1ef1c hi\u1ec7n, b\u1ea1n <strong>nh\u1eadn \u0111\u01b0\u1ee3c k\u1ebft qu\u1ea3 sau khi x\u00f3a gi\u00e1 tr\u1ecb tr\u00f9ng l\u1eb7p.\u00a0<\/strong><\/p>\n<p><img loading=\"lazy\" class=\"aligncenter wp-image-543894 size-full\" src=\"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/mach-ban-cach-loc-trung-excel-cuc-don-gian-ma-ai-cung-thuc-hien-duoc_6239a5fed4da6.jpeg\" alt=\"Check tr\u00f9ng trong Excel b\u1eb1ng Power Query b\u01b0\u1edbc 3\" width=\"1022\" height=\"690\" \/><\/p>\n<p><strong>B\u01b0\u1edbc 4:<\/strong> \u0110\u1ec3 xu\u1ea5t file, b\u1ea1n <strong>nh\u1ea5n v\u00e0o ch\u1ecdn File<\/strong> &gt; Ch\u1ecdn t\u00f9y ch\u1ecdn<strong> Close &amp; Load<\/strong> &gt; <strong>Nh\u1ea5p ti\u1ebfp Close &amp; Load<\/strong> \u0111\u1ec3 d\u1eef li\u1ec7u \u0111\u01b0\u1ee3c xu\u1ea5t.<\/p>\n<p><img loading=\"lazy\" class=\"aligncenter wp-image-543895 size-full\" src=\"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/mach-ban-cach-loc-trung-excel-cuc-don-gian-ma-ai-cung-thuc-hien-duoc_6239a6004899e.jpeg\" alt=\"Check tr\u00f9ng trong Excel b\u1eb1ng Power Query b\u01b0\u1edbc 4\" width=\"1360\" height=\"725\" \/><\/p>\n<p><strong>B\u01b0\u1edbc 5:<\/strong> D\u1eef li\u1ec7u sau khi \u0111\u01b0\u1ee3c xu\u1ea5t nh\u01b0 sau:<\/p>\n<p><img loading=\"lazy\" class=\"aligncenter wp-image-543897 size-full\" src=\"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/mach-ban-cach-loc-trung-excel-cuc-don-gian-ma-ai-cung-thuc-hien-duoc_6239a602c8250.jpeg\" alt=\"Check tr\u00f9ng trong Excel b\u1eb1ng Power Query b\u01b0\u1edbc 5\" width=\"1078\" height=\"625\" \/><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Tam_ket\"><\/span><span id=\"Tam_ket\" class=\"ez-toc-section\"><\/span><span style=\"font-size: 18pt;\"><strong>T\u1ea1m k\u1ebft<\/strong><\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Tr\u00ean \u0111\u00e2y, Divine Shop \u0111\u00e3 h\u01b0\u1edbng d\u1eabn xong cho b\u1ea1n c\u00e1ch l\u1ecdc tr\u00f9ng Excel nhanh ch\u00f3ng v\u00e0 chi ti\u1ebft nh\u1ea5t. Hy v\u1ecdng b\u00e0i vi\u1ebft ng\u1eafn m\u00e0 ch\u00fang t\u00f4i chia s\u1ebb s\u1ebd gi\u00fap b\u1ea1n d\u1ec5 d\u00e0ng l\u1ecdc tr\u00f9ng d\u1eef li\u1ec7u trong Excel nhanh nh\u1ea5t. Ch\u00fac b\u1ea1n th\u00e0nh c\u00f4ng.<\/p>\n<p>\u00a0<\/p>\n<\/div>\n<\/div>\n\n\n<hr class=\"wp-block-separator\"\/>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/divineshop.vn\/search?q=h%E1%BB%8Dc+t%E1%BA%ADp\" target=\"_blank\" rel=\"noopener\"><img loading=\"lazy\" width=\"728\" height=\"240\" src=\"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2025\/12\/Hoc-tap.png\" alt=\"\" class=\"wp-image-285219\" srcset=\"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2025\/12\/Hoc-tap.png 728w, https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2025\/12\/Hoc-tap-300x99.png 300w, https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2025\/12\/Hoc-tap-150x49.png 150w, https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2025\/12\/Hoc-tap-696x229.png 696w\" sizes=\"(max-width: 728px) 100vw, 728px\" \/><\/a><\/figure>\n\n\n\n<!--nextpage-->\n\n\n\n<div class=\"wp-container-69e531ec2ef04 wp-block-group\"><div class=\"wp-block-group__inner-container\"><\/div><\/div>\n","protected":false},"excerpt":{"rendered":"<p>\u0110\u1eebng b\u1ecf qua b\u00e0i vi\u1ebft n\u00e0y n\u1ebfu nh\u01b0 b\u1ea1n kh\u00f4ng bi\u1ebft c\u00e1ch l\u1ecdc d\u1eef li\u1ec7u tr\u00f9ng trong Excel nh\u00e9.<\/p>\n<p>\u0110\u00f4i l\u00fac, khi so\u1ea1n th\u1ea3o d\u1eef li\u1ec7u v\u00e0 b\u00e1o c\u00e1o nhi\u1ec1u ng\u01b0\u1eddi d\u00f9ng c\u1ea3m th\u1ea5y m\u1ec7t m\u1ecfi v\u00e0 r\u1eafc r\u1ed1i b\u1edfi xu\u1ea5t hi\u1ec7n nhi\u1ec1u th\u00f4ng tin tr\u00f9ng l\u1eb7p. \u0110\u1eb7c bi\u1ec7t l\u00e0 nh\u1eefng b\u1ea3ng d\u1eef li\u1ec7u ch\u1ee9a nhi\u1ec1u th\u00f4ng tin r\u1ea5t m\u1ea5t th\u1eddi gian \u0111\u1ec3 t\u00ecm ki\u1ebfm nh\u1eefng d\u1eef li\u1ec7u b\u1ecb tr\u00f9ng l\u1eb7p. Ch\u00ednh v\u00ec th\u1ebf, trong b\u00e0i vi\u1ebft d\u01b0\u1edbi \u0111\u00e2y, Divine Shop s\u1ebd chia s\u1ebb cho b\u1ea1n c\u00e1ch l\u1ecdc tr\u00f9ng Excel nhanh ch\u00f3ng v\u00e0 \u0111\u01a1n gi\u1ea3n.<\/p>\n","protected":false},"author":12,"featured_media":35229,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"inline_featured_image":false},"categories":[148],"tags":[38,238],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v18.1 (Yoast SEO v18.2) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<meta name=\"description\" content=\"\u0110\u1eebng b\u1ecf qua b\u00e0i vi\u1ebft n\u00e0y n\u1ebfu nh\u01b0 b\u1ea1n kh\u00f4ng bi\u1ebft c\u00e1ch l\u1ecdc d\u1eef li\u1ec7u tr\u00f9ng trong Excel nh\u00e9. \u0110\u00f4i l\u00fac, khi so\u1ea1n th\u1ea3o d\u1eef li\u1ec7u v\u00e0 b\u00e1o c\u00e1o nhi\u1ec1u ng\u01b0\u1eddi d\u00f9ng c\u1ea3m th\u1ea5y m\u1ec7t m\u1ecfi v\u00e0 r\u1eafc r\u1ed1i b\u1edfi xu\u1ea5t hi\u1ec7n nhi\u1ec1u th\u00f4ng tin tr\u00f9ng l\u1eb7p. \u0110\u1eb7c bi\u1ec7t l\u00e0 nh\u1eefng b\u1ea3ng d\u1eef li\u1ec7u ch\u1ee9a nhi\u1ec1u th\u00f4ng tin r\u1ea5t m\u1ea5t th\u1eddi gian \u0111\u1ec3 t\u00ecm ki\u1ebfm nh\u1eefng d\u1eef li\u1ec7u b\u1ecb tr\u00f9ng l\u1eb7p. Ch\u00ednh v\u00ec th\u1ebf, trong b\u00e0i vi\u1ebft d\u01b0\u1edbi \u0111\u00e2y, Divine Shop s\u1ebd chia s\u1ebb cho b\u1ea1n c\u00e1ch l\u1ecdc tr\u00f9ng Excel nhanh ch\u00f3ng v\u00e0 \u0111\u01a1n gi\u1ea3n.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/divineshop.vn\/tin-tuc\/mach-ban-cach-loc-trung-excel-cuc-don-gian-ma-ai-cung-thuc-hien-duoc\/\" \/>\n<meta property=\"og:locale\" content=\"vi_VN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"M\u00e1ch b\u1ea1n c\u00e1ch l\u1ecdc tr\u00f9ng Excel c\u1ef1c \u0111\u01a1n gi\u1ea3n m\u00e0 ai c\u0169ng th\u1ef1c hi\u1ec7n \u0111\u01b0\u1ee3c\" \/>\n<meta property=\"og:description\" content=\"\u0110\u1eebng b\u1ecf qua b\u00e0i vi\u1ebft n\u00e0y n\u1ebfu nh\u01b0 b\u1ea1n kh\u00f4ng bi\u1ebft c\u00e1ch l\u1ecdc d\u1eef li\u1ec7u tr\u00f9ng trong Excel nh\u00e9. \u0110\u00f4i l\u00fac, khi so\u1ea1n th\u1ea3o d\u1eef li\u1ec7u v\u00e0 b\u00e1o c\u00e1o nhi\u1ec1u ng\u01b0\u1eddi d\u00f9ng c\u1ea3m th\u1ea5y m\u1ec7t m\u1ecfi v\u00e0 r\u1eafc r\u1ed1i b\u1edfi xu\u1ea5t hi\u1ec7n nhi\u1ec1u th\u00f4ng tin tr\u00f9ng l\u1eb7p. \u0110\u1eb7c bi\u1ec7t l\u00e0 nh\u1eefng b\u1ea3ng d\u1eef li\u1ec7u ch\u1ee9a nhi\u1ec1u th\u00f4ng tin r\u1ea5t m\u1ea5t th\u1eddi gian \u0111\u1ec3 t\u00ecm ki\u1ebfm nh\u1eefng d\u1eef li\u1ec7u b\u1ecb tr\u00f9ng l\u1eb7p. Ch\u00ednh v\u00ec th\u1ebf, trong b\u00e0i vi\u1ebft d\u01b0\u1edbi \u0111\u00e2y, Divine Shop s\u1ebd chia s\u1ebb cho b\u1ea1n c\u00e1ch l\u1ecdc tr\u00f9ng Excel nhanh ch\u00f3ng v\u00e0 \u0111\u01a1n gi\u1ea3n.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/divineshop.vn\/tin-tuc\/mach-ban-cach-loc-trung-excel-cuc-don-gian-ma-ai-cung-thuc-hien-duoc\/\" \/>\n<meta property=\"og:site_name\" content=\"Divine News\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/divineshop.vn\" \/>\n<meta property=\"article:published_time\" content=\"2022-04-12T08:06:36+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-05-09T04:19:29+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/mach-ban-cach-loc-trung-excel-cuc-don-gian-ma-ai-cung-thuc-hien-duoc_6239a5d978758.jpeg\" \/>\n\t<meta property=\"og:image:width\" content=\"1000\" \/>\n\t<meta property=\"og:image:height\" content=\"563\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"CTV\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"12 ph\u00fat\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Organization\",\"@id\":\"https:\/\/divineshop.vn\/tin-tuc\/#organization\",\"name\":\"Divine News\",\"url\":\"https:\/\/divineshop.vn\/tin-tuc\/\",\"sameAs\":[\"https:\/\/www.facebook.com\/divineshop.vn\",\"https:\/\/www.instagram.com\/divineshop.game\/\",\"https:\/\/www.youtube.com\/DivineTVN\"],\"logo\":{\"@type\":\"ImageObject\",\"@id\":\"https:\/\/divineshop.vn\/tin-tuc\/#logo\",\"inLanguage\":\"vi\",\"url\":\"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/Avatar.jpg\",\"contentUrl\":\"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/Avatar.jpg\",\"width\":960,\"height\":960,\"caption\":\"Divine News\"},\"image\":{\"@id\":\"https:\/\/divineshop.vn\/tin-tuc\/#logo\"}},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/divineshop.vn\/tin-tuc\/#website\",\"url\":\"https:\/\/divineshop.vn\/tin-tuc\/\",\"name\":\"Divine News\",\"description\":\"Tin hay m\u1ed7i ng\u00e0y\",\"publisher\":{\"@id\":\"https:\/\/divineshop.vn\/tin-tuc\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/divineshop.vn\/tin-tuc\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"vi\"},{\"@type\":\"ImageObject\",\"@id\":\"https:\/\/divineshop.vn\/tin-tuc\/mach-ban-cach-loc-trung-excel-cuc-don-gian-ma-ai-cung-thuc-hien-duoc\/#primaryimage\",\"inLanguage\":\"vi\",\"url\":\"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/mach-ban-cach-loc-trung-excel-cuc-don-gian-ma-ai-cung-thuc-hien-duoc_6239a5d978758.jpeg\",\"contentUrl\":\"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/mach-ban-cach-loc-trung-excel-cuc-don-gian-ma-ai-cung-thuc-hien-duoc_6239a5d978758.jpeg\",\"width\":1000,\"height\":563},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/divineshop.vn\/tin-tuc\/mach-ban-cach-loc-trung-excel-cuc-don-gian-ma-ai-cung-thuc-hien-duoc\/#webpage\",\"url\":\"https:\/\/divineshop.vn\/tin-tuc\/mach-ban-cach-loc-trung-excel-cuc-don-gian-ma-ai-cung-thuc-hien-duoc\/\",\"name\":\"M\u00e1ch b\u1ea1n c\u00e1ch l\u1ecdc tr\u00f9ng Excel c\u1ef1c \u0111\u01a1n gi\u1ea3n m\u00e0 ai c\u0169ng th\u1ef1c hi\u1ec7n \u0111\u01b0\u1ee3c - Divine News\",\"isPartOf\":{\"@id\":\"https:\/\/divineshop.vn\/tin-tuc\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/divineshop.vn\/tin-tuc\/mach-ban-cach-loc-trung-excel-cuc-don-gian-ma-ai-cung-thuc-hien-duoc\/#primaryimage\"},\"datePublished\":\"2022-04-12T08:06:36+00:00\",\"dateModified\":\"2022-05-09T04:19:29+00:00\",\"description\":\"\u0110\u1eebng b\u1ecf qua b\u00e0i vi\u1ebft n\u00e0y n\u1ebfu nh\u01b0 b\u1ea1n kh\u00f4ng bi\u1ebft c\u00e1ch l\u1ecdc d\u1eef li\u1ec7u tr\u00f9ng trong Excel nh\u00e9. \u0110\u00f4i l\u00fac, khi so\u1ea1n th\u1ea3o d\u1eef li\u1ec7u v\u00e0 b\u00e1o c\u00e1o nhi\u1ec1u ng\u01b0\u1eddi d\u00f9ng c\u1ea3m th\u1ea5y m\u1ec7t m\u1ecfi v\u00e0 r\u1eafc r\u1ed1i b\u1edfi xu\u1ea5t hi\u1ec7n nhi\u1ec1u th\u00f4ng tin tr\u00f9ng l\u1eb7p. \u0110\u1eb7c bi\u1ec7t l\u00e0 nh\u1eefng b\u1ea3ng d\u1eef li\u1ec7u ch\u1ee9a nhi\u1ec1u th\u00f4ng tin r\u1ea5t m\u1ea5t th\u1eddi gian \u0111\u1ec3 t\u00ecm ki\u1ebfm nh\u1eefng d\u1eef li\u1ec7u b\u1ecb tr\u00f9ng l\u1eb7p. Ch\u00ednh v\u00ec th\u1ebf, trong b\u00e0i vi\u1ebft d\u01b0\u1edbi \u0111\u00e2y, Divine Shop s\u1ebd chia s\u1ebb cho b\u1ea1n c\u00e1ch l\u1ecdc tr\u00f9ng Excel nhanh ch\u00f3ng v\u00e0 \u0111\u01a1n gi\u1ea3n.\",\"breadcrumb\":{\"@id\":\"https:\/\/divineshop.vn\/tin-tuc\/mach-ban-cach-loc-trung-excel-cuc-don-gian-ma-ai-cung-thuc-hien-duoc\/#breadcrumb\"},\"inLanguage\":\"vi\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/divineshop.vn\/tin-tuc\/mach-ban-cach-loc-trung-excel-cuc-don-gian-ma-ai-cung-thuc-hien-duoc\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/divineshop.vn\/tin-tuc\/mach-ban-cach-loc-trung-excel-cuc-don-gian-ma-ai-cung-thuc-hien-duoc\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/divineshop.vn\/tin-tuc\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"M\u00e1ch b\u1ea1n c\u00e1ch l\u1ecdc tr\u00f9ng Excel c\u1ef1c \u0111\u01a1n gi\u1ea3n m\u00e0 ai c\u0169ng th\u1ef1c hi\u1ec7n \u0111\u01b0\u1ee3c\"}]},{\"@type\":\"Article\",\"@id\":\"https:\/\/divineshop.vn\/tin-tuc\/mach-ban-cach-loc-trung-excel-cuc-don-gian-ma-ai-cung-thuc-hien-duoc\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/divineshop.vn\/tin-tuc\/mach-ban-cach-loc-trung-excel-cuc-don-gian-ma-ai-cung-thuc-hien-duoc\/#webpage\"},\"author\":{\"@id\":\"https:\/\/divineshop.vn\/tin-tuc\/#\/schema\/person\/ab675a5edaf3a6c9f037d16aa192413a\"},\"headline\":\"M\u00e1ch b\u1ea1n c\u00e1ch l\u1ecdc tr\u00f9ng Excel c\u1ef1c \u0111\u01a1n gi\u1ea3n m\u00e0 ai c\u0169ng th\u1ef1c hi\u1ec7n \u0111\u01b0\u1ee3c\",\"datePublished\":\"2022-04-12T08:06:36+00:00\",\"dateModified\":\"2022-05-09T04:19:29+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/divineshop.vn\/tin-tuc\/mach-ban-cach-loc-trung-excel-cuc-don-gian-ma-ai-cung-thuc-hien-duoc\/#webpage\"},\"wordCount\":1695,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/divineshop.vn\/tin-tuc\/#organization\"},\"image\":{\"@id\":\"https:\/\/divineshop.vn\/tin-tuc\/mach-ban-cach-loc-trung-excel-cuc-don-gian-ma-ai-cung-thuc-hien-duoc\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/mach-ban-cach-loc-trung-excel-cuc-don-gian-ma-ai-cung-thuc-hien-duoc_6239a5d978758.jpeg\",\"keywords\":[\"divineshop\",\"Microsoft Excel\"],\"articleSection\":[\"M\u1eb8O HAY\"],\"inLanguage\":\"vi\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/divineshop.vn\/tin-tuc\/mach-ban-cach-loc-trung-excel-cuc-don-gian-ma-ai-cung-thuc-hien-duoc\/#respond\"]}],\"copyrightYear\":\"2022\",\"copyrightHolder\":{\"@id\":\"https:\/\/divineshop.vn\/tin-tuc\/#organization\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/divineshop.vn\/tin-tuc\/#\/schema\/person\/ab675a5edaf3a6c9f037d16aa192413a\",\"name\":\"CTV\",\"image\":{\"@type\":\"ImageObject\",\"@id\":\"https:\/\/divineshop.vn\/tin-tuc\/#personlogo\",\"inLanguage\":\"vi\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/99e99dbd029810d7d24fba0cc828c79b?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/99e99dbd029810d7d24fba0cc828c79b?s=96&d=mm&r=g\",\"caption\":\"CTV\"}}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"description":"\u0110\u1eebng b\u1ecf qua b\u00e0i vi\u1ebft n\u00e0y n\u1ebfu nh\u01b0 b\u1ea1n kh\u00f4ng bi\u1ebft c\u00e1ch l\u1ecdc d\u1eef li\u1ec7u tr\u00f9ng trong Excel nh\u00e9. \u0110\u00f4i l\u00fac, khi so\u1ea1n th\u1ea3o d\u1eef li\u1ec7u v\u00e0 b\u00e1o c\u00e1o nhi\u1ec1u ng\u01b0\u1eddi d\u00f9ng c\u1ea3m th\u1ea5y m\u1ec7t m\u1ecfi v\u00e0 r\u1eafc r\u1ed1i b\u1edfi xu\u1ea5t hi\u1ec7n nhi\u1ec1u th\u00f4ng tin tr\u00f9ng l\u1eb7p. \u0110\u1eb7c bi\u1ec7t l\u00e0 nh\u1eefng b\u1ea3ng d\u1eef li\u1ec7u ch\u1ee9a nhi\u1ec1u th\u00f4ng tin r\u1ea5t m\u1ea5t th\u1eddi gian \u0111\u1ec3 t\u00ecm ki\u1ebfm nh\u1eefng d\u1eef li\u1ec7u b\u1ecb tr\u00f9ng l\u1eb7p. Ch\u00ednh v\u00ec th\u1ebf, trong b\u00e0i vi\u1ebft d\u01b0\u1edbi \u0111\u00e2y, Divine Shop s\u1ebd chia s\u1ebb cho b\u1ea1n c\u00e1ch l\u1ecdc tr\u00f9ng Excel nhanh ch\u00f3ng v\u00e0 \u0111\u01a1n gi\u1ea3n.","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:\/\/divineshop.vn\/tin-tuc\/mach-ban-cach-loc-trung-excel-cuc-don-gian-ma-ai-cung-thuc-hien-duoc\/","og_locale":"vi_VN","og_type":"article","og_title":"M\u00e1ch b\u1ea1n c\u00e1ch l\u1ecdc tr\u00f9ng Excel c\u1ef1c \u0111\u01a1n gi\u1ea3n m\u00e0 ai c\u0169ng th\u1ef1c hi\u1ec7n \u0111\u01b0\u1ee3c","og_description":"\u0110\u1eebng b\u1ecf qua b\u00e0i vi\u1ebft n\u00e0y n\u1ebfu nh\u01b0 b\u1ea1n kh\u00f4ng bi\u1ebft c\u00e1ch l\u1ecdc d\u1eef li\u1ec7u tr\u00f9ng trong Excel nh\u00e9. \u0110\u00f4i l\u00fac, khi so\u1ea1n th\u1ea3o d\u1eef li\u1ec7u v\u00e0 b\u00e1o c\u00e1o nhi\u1ec1u ng\u01b0\u1eddi d\u00f9ng c\u1ea3m th\u1ea5y m\u1ec7t m\u1ecfi v\u00e0 r\u1eafc r\u1ed1i b\u1edfi xu\u1ea5t hi\u1ec7n nhi\u1ec1u th\u00f4ng tin tr\u00f9ng l\u1eb7p. \u0110\u1eb7c bi\u1ec7t l\u00e0 nh\u1eefng b\u1ea3ng d\u1eef li\u1ec7u ch\u1ee9a nhi\u1ec1u th\u00f4ng tin r\u1ea5t m\u1ea5t th\u1eddi gian \u0111\u1ec3 t\u00ecm ki\u1ebfm nh\u1eefng d\u1eef li\u1ec7u b\u1ecb tr\u00f9ng l\u1eb7p. Ch\u00ednh v\u00ec th\u1ebf, trong b\u00e0i vi\u1ebft d\u01b0\u1edbi \u0111\u00e2y, Divine Shop s\u1ebd chia s\u1ebb cho b\u1ea1n c\u00e1ch l\u1ecdc tr\u00f9ng Excel nhanh ch\u00f3ng v\u00e0 \u0111\u01a1n gi\u1ea3n.","og_url":"https:\/\/divineshop.vn\/tin-tuc\/mach-ban-cach-loc-trung-excel-cuc-don-gian-ma-ai-cung-thuc-hien-duoc\/","og_site_name":"Divine News","article_publisher":"https:\/\/www.facebook.com\/divineshop.vn","article_published_time":"2022-04-12T08:06:36+00:00","article_modified_time":"2022-05-09T04:19:29+00:00","og_image":[{"width":1000,"height":563,"url":"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/mach-ban-cach-loc-trung-excel-cuc-don-gian-ma-ai-cung-thuc-hien-duoc_6239a5d978758.jpeg","type":"image\/jpeg"}],"twitter_card":"summary_large_image","twitter_misc":{"Written by":"CTV","Est. reading time":"12 ph\u00fat"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Organization","@id":"https:\/\/divineshop.vn\/tin-tuc\/#organization","name":"Divine News","url":"https:\/\/divineshop.vn\/tin-tuc\/","sameAs":["https:\/\/www.facebook.com\/divineshop.vn","https:\/\/www.instagram.com\/divineshop.game\/","https:\/\/www.youtube.com\/DivineTVN"],"logo":{"@type":"ImageObject","@id":"https:\/\/divineshop.vn\/tin-tuc\/#logo","inLanguage":"vi","url":"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/Avatar.jpg","contentUrl":"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/Avatar.jpg","width":960,"height":960,"caption":"Divine News"},"image":{"@id":"https:\/\/divineshop.vn\/tin-tuc\/#logo"}},{"@type":"WebSite","@id":"https:\/\/divineshop.vn\/tin-tuc\/#website","url":"https:\/\/divineshop.vn\/tin-tuc\/","name":"Divine News","description":"Tin hay m\u1ed7i ng\u00e0y","publisher":{"@id":"https:\/\/divineshop.vn\/tin-tuc\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/divineshop.vn\/tin-tuc\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"vi"},{"@type":"ImageObject","@id":"https:\/\/divineshop.vn\/tin-tuc\/mach-ban-cach-loc-trung-excel-cuc-don-gian-ma-ai-cung-thuc-hien-duoc\/#primaryimage","inLanguage":"vi","url":"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/mach-ban-cach-loc-trung-excel-cuc-don-gian-ma-ai-cung-thuc-hien-duoc_6239a5d978758.jpeg","contentUrl":"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/mach-ban-cach-loc-trung-excel-cuc-don-gian-ma-ai-cung-thuc-hien-duoc_6239a5d978758.jpeg","width":1000,"height":563},{"@type":"WebPage","@id":"https:\/\/divineshop.vn\/tin-tuc\/mach-ban-cach-loc-trung-excel-cuc-don-gian-ma-ai-cung-thuc-hien-duoc\/#webpage","url":"https:\/\/divineshop.vn\/tin-tuc\/mach-ban-cach-loc-trung-excel-cuc-don-gian-ma-ai-cung-thuc-hien-duoc\/","name":"M\u00e1ch b\u1ea1n c\u00e1ch l\u1ecdc tr\u00f9ng Excel c\u1ef1c \u0111\u01a1n gi\u1ea3n m\u00e0 ai c\u0169ng th\u1ef1c hi\u1ec7n \u0111\u01b0\u1ee3c - Divine News","isPartOf":{"@id":"https:\/\/divineshop.vn\/tin-tuc\/#website"},"primaryImageOfPage":{"@id":"https:\/\/divineshop.vn\/tin-tuc\/mach-ban-cach-loc-trung-excel-cuc-don-gian-ma-ai-cung-thuc-hien-duoc\/#primaryimage"},"datePublished":"2022-04-12T08:06:36+00:00","dateModified":"2022-05-09T04:19:29+00:00","description":"\u0110\u1eebng b\u1ecf qua b\u00e0i vi\u1ebft n\u00e0y n\u1ebfu nh\u01b0 b\u1ea1n kh\u00f4ng bi\u1ebft c\u00e1ch l\u1ecdc d\u1eef li\u1ec7u tr\u00f9ng trong Excel nh\u00e9. \u0110\u00f4i l\u00fac, khi so\u1ea1n th\u1ea3o d\u1eef li\u1ec7u v\u00e0 b\u00e1o c\u00e1o nhi\u1ec1u ng\u01b0\u1eddi d\u00f9ng c\u1ea3m th\u1ea5y m\u1ec7t m\u1ecfi v\u00e0 r\u1eafc r\u1ed1i b\u1edfi xu\u1ea5t hi\u1ec7n nhi\u1ec1u th\u00f4ng tin tr\u00f9ng l\u1eb7p. \u0110\u1eb7c bi\u1ec7t l\u00e0 nh\u1eefng b\u1ea3ng d\u1eef li\u1ec7u ch\u1ee9a nhi\u1ec1u th\u00f4ng tin r\u1ea5t m\u1ea5t th\u1eddi gian \u0111\u1ec3 t\u00ecm ki\u1ebfm nh\u1eefng d\u1eef li\u1ec7u b\u1ecb tr\u00f9ng l\u1eb7p. Ch\u00ednh v\u00ec th\u1ebf, trong b\u00e0i vi\u1ebft d\u01b0\u1edbi \u0111\u00e2y, Divine Shop s\u1ebd chia s\u1ebb cho b\u1ea1n c\u00e1ch l\u1ecdc tr\u00f9ng Excel nhanh ch\u00f3ng v\u00e0 \u0111\u01a1n gi\u1ea3n.","breadcrumb":{"@id":"https:\/\/divineshop.vn\/tin-tuc\/mach-ban-cach-loc-trung-excel-cuc-don-gian-ma-ai-cung-thuc-hien-duoc\/#breadcrumb"},"inLanguage":"vi","potentialAction":[{"@type":"ReadAction","target":["https:\/\/divineshop.vn\/tin-tuc\/mach-ban-cach-loc-trung-excel-cuc-don-gian-ma-ai-cung-thuc-hien-duoc\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/divineshop.vn\/tin-tuc\/mach-ban-cach-loc-trung-excel-cuc-don-gian-ma-ai-cung-thuc-hien-duoc\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/divineshop.vn\/tin-tuc\/"},{"@type":"ListItem","position":2,"name":"M\u00e1ch b\u1ea1n c\u00e1ch l\u1ecdc tr\u00f9ng Excel c\u1ef1c \u0111\u01a1n gi\u1ea3n m\u00e0 ai c\u0169ng th\u1ef1c hi\u1ec7n \u0111\u01b0\u1ee3c"}]},{"@type":"Article","@id":"https:\/\/divineshop.vn\/tin-tuc\/mach-ban-cach-loc-trung-excel-cuc-don-gian-ma-ai-cung-thuc-hien-duoc\/#article","isPartOf":{"@id":"https:\/\/divineshop.vn\/tin-tuc\/mach-ban-cach-loc-trung-excel-cuc-don-gian-ma-ai-cung-thuc-hien-duoc\/#webpage"},"author":{"@id":"https:\/\/divineshop.vn\/tin-tuc\/#\/schema\/person\/ab675a5edaf3a6c9f037d16aa192413a"},"headline":"M\u00e1ch b\u1ea1n c\u00e1ch l\u1ecdc tr\u00f9ng Excel c\u1ef1c \u0111\u01a1n gi\u1ea3n m\u00e0 ai c\u0169ng th\u1ef1c hi\u1ec7n \u0111\u01b0\u1ee3c","datePublished":"2022-04-12T08:06:36+00:00","dateModified":"2022-05-09T04:19:29+00:00","mainEntityOfPage":{"@id":"https:\/\/divineshop.vn\/tin-tuc\/mach-ban-cach-loc-trung-excel-cuc-don-gian-ma-ai-cung-thuc-hien-duoc\/#webpage"},"wordCount":1695,"commentCount":0,"publisher":{"@id":"https:\/\/divineshop.vn\/tin-tuc\/#organization"},"image":{"@id":"https:\/\/divineshop.vn\/tin-tuc\/mach-ban-cach-loc-trung-excel-cuc-don-gian-ma-ai-cung-thuc-hien-duoc\/#primaryimage"},"thumbnailUrl":"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/mach-ban-cach-loc-trung-excel-cuc-don-gian-ma-ai-cung-thuc-hien-duoc_6239a5d978758.jpeg","keywords":["divineshop","Microsoft Excel"],"articleSection":["M\u1eb8O HAY"],"inLanguage":"vi","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/divineshop.vn\/tin-tuc\/mach-ban-cach-loc-trung-excel-cuc-don-gian-ma-ai-cung-thuc-hien-duoc\/#respond"]}],"copyrightYear":"2022","copyrightHolder":{"@id":"https:\/\/divineshop.vn\/tin-tuc\/#organization"}},{"@type":"Person","@id":"https:\/\/divineshop.vn\/tin-tuc\/#\/schema\/person\/ab675a5edaf3a6c9f037d16aa192413a","name":"CTV","image":{"@type":"ImageObject","@id":"https:\/\/divineshop.vn\/tin-tuc\/#personlogo","inLanguage":"vi","url":"https:\/\/secure.gravatar.com\/avatar\/99e99dbd029810d7d24fba0cc828c79b?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/99e99dbd029810d7d24fba0cc828c79b?s=96&d=mm&r=g","caption":"CTV"}}]}},"_links":{"self":[{"href":"https:\/\/divineshop.vn\/tin-tuc\/wp-json\/wp\/v2\/posts\/35228"}],"collection":[{"href":"https:\/\/divineshop.vn\/tin-tuc\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/divineshop.vn\/tin-tuc\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/divineshop.vn\/tin-tuc\/wp-json\/wp\/v2\/users\/12"}],"replies":[{"embeddable":true,"href":"https:\/\/divineshop.vn\/tin-tuc\/wp-json\/wp\/v2\/comments?post=35228"}],"version-history":[{"count":3,"href":"https:\/\/divineshop.vn\/tin-tuc\/wp-json\/wp\/v2\/posts\/35228\/revisions"}],"predecessor-version":[{"id":84035,"href":"https:\/\/divineshop.vn\/tin-tuc\/wp-json\/wp\/v2\/posts\/35228\/revisions\/84035"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/divineshop.vn\/tin-tuc\/wp-json\/wp\/v2\/media\/35229"}],"wp:attachment":[{"href":"https:\/\/divineshop.vn\/tin-tuc\/wp-json\/wp\/v2\/media?parent=35228"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/divineshop.vn\/tin-tuc\/wp-json\/wp\/v2\/categories?post=35228"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/divineshop.vn\/tin-tuc\/wp-json\/wp\/v2\/tags?post=35228"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}