{"id":1272,"date":"2024-12-02T04:36:17","date_gmt":"2024-12-02T04:36:17","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/02\/tong-hop-cac-phuong-phap-loai-bo-du-lieu-lap\/"},"modified":"2024-12-02T04:36:17","modified_gmt":"2024-12-02T04:36:17","slug":"tong-hop-cac-phuong-phap-loai-bo-du-lieu-lap","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/02\/tong-hop-cac-phuong-phap-loai-bo-du-lieu-lap\/","title":{"rendered":"T\u1ed5ng h\u1ee3p c\u00e1c ph\u01b0\u01a1ng ph\u00e1p lo\u1ea1i b\u1ecf d\u1eef li\u1ec7u l\u1eb7p"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p>B\u00e0i vi\u1ebft n\u00e0y, ch\u00fang t\u00f4i s\u1ebd h\u01b0\u1edbng d\u1eabn c\u00e1c b\u1ea1n l\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 lo\u1ea1i b\u1ecf d\u1eef li\u1ec7u tr\u00f9ng l\u1eb7p trong Excel 2007, Excel 2010, Excel 2013, Excel 2016 v\u00e0 Excel 2019 (<em>remove duplicate trong excel)<\/em>. C\u00f3 r\u1ea5t nhi\u1ec1u y\u1ebfu t\u1ed1 k\u1ef9 thu\u1eadt c\u00f3 th\u1ec3 <strong>lo\u1ea1i b\u1ecf \u0111\u01b0\u1ee3c d\u1eef li\u1ec7u l\u1eb7p trong 1 \u00f4 hay trong c\u1ea3 m\u1ed9t d\u00f2ng c\u1ee7a Excel.<\/strong><\/p>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_61 counter-hierarchy ez-toc-counter ez-toc-transparent ez-toc-container-direction\">\n<p class=\"ez-toc-title\">Xem nhanh<\/p>\n<p><label for=\"ez-toc-cssicon-toggle-item-674d39403163a\" class=\"ez-toc-cssicon-toggle-label\"><span class=\"\"><span class=\"eztoc-hide\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><\/span><\/span><\/label><\/p>\n<nav>\n<ul class=\"ez-toc-list ez-toc-list-level-1 \">\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/blog.hocexcel.online\/tong-hop-cac-phuong-phap-loai-bo-du-lieu-lap.html#Su_dung_chuc_nang_Remove_Duplicates_cua_Excel\" title=\"S\u1eed d\u1ee5ng ch\u1ee9c n\u0103ng Remove Duplicates c\u1ee7a Excel\">S\u1eed d\u1ee5ng ch\u1ee9c n\u0103ng Remove Duplicates c\u1ee7a Excel<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/blog.hocexcel.online\/tong-hop-cac-phuong-phap-loai-bo-du-lieu-lap.html#Loai_bo_du_lieu_lap_bang_cach_copy_du_lieu_duy_nhat_ra_vung_khac\" title=\"Lo\u1ea1i b\u1ecf d\u1eef li\u1ec7u l\u1eb7p b\u1eb1ng c\u00e1ch copy d\u1eef li\u1ec7u duy nh\u1ea5t ra v\u00f9ng kh\u00e1c\">Lo\u1ea1i b\u1ecf d\u1eef li\u1ec7u l\u1eb7p b\u1eb1ng c\u00e1ch copy d\u1eef li\u1ec7u duy nh\u1ea5t ra v\u00f9ng kh\u00e1c<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/blog.hocexcel.online\/tong-hop-cac-phuong-phap-loai-bo-du-lieu-lap.html#Su_dung_cong_thuc_va_ket_hop_voi_chuc_nang_loc_du_lieu\" title=\"S\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c v\u00e0 k\u1ebft h\u1ee3p v\u1edbi ch\u1ee9c n\u0103ng l\u1ecdc d\u1eef li\u1ec7u\">S\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c v\u00e0 k\u1ebft h\u1ee3p v\u1edbi ch\u1ee9c n\u0103ng l\u1ecdc d\u1eef li\u1ec7u<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2 id=\"s-dng-chc-nng-remove-duplicates-ca-excel\"><span class=\"ez-toc-section\" id=\"Su_dung_chuc_nang_Remove_Duplicates_cua_Excel\"><\/span>S\u1eed d\u1ee5ng ch\u1ee9c n\u0103ng Remove Duplicates c\u1ee7a Excel<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>N\u1ebfu b\u1ea1n \u0111ang s\u1eed d\u1ee5ng m\u1ed9t trong nh\u1eefng phi\u00ean b\u1ea3n g\u1ea7n \u0111\u00e2y c\u1ee7a Excel: Excel 2007, Excel 2010, Excel 2013 ho\u1eb7c Excel 2016 th\u00ec b\u1ea1n c\u00f3 th\u1ec3 d\u1ec5 d\u00e0ng lo\u1ea1i b\u1ecf d\u1eef li\u1ec7u b\u1ecb l\u1eb7p trong 1 \u00f4 (<em>remove duplicate excel<\/em>), 1 d\u00f2ng ho\u1eb7c lo\u1ea1i b\u1ecf d\u1eef li\u1ec7u l\u1eb7p tr\u00ean 1 d\u00f2ng d\u1ef1a tr\u00ean 1 v\u00e0i c\u1ed9t. C\u1ee5 th\u1ec3 ch\u00fang ta theo nh\u1eefng b\u01b0\u1edbc sau \u0111\u00e2y \u0111\u1ec3 th\u1ef1c hi\u1ec7n:<\/p>\n<ol>\n<li>Ch\u00fa \u00fd, c\u00f4ng c\u1ee5 <strong>Remove Duplicates<\/strong> trong Excel s\u1ebd xo\u00e1 nh\u1eefng d\u1eef li\u1ec7u l\u1eb7p l\u1ea1i, n\u00ean t\u1ed1t nh\u1ea5t h\u00e3y l\u00e0m 1 b\u1ea3n copy c\u1ee7a d\u1eef li\u1ec7u \u0111\u00f3 tr\u01b0\u1edbc khi th\u1ef1c hi\u1ec7n nh\u1eefng b\u01b0\u1edbc ti\u1ebfp theo.<\/li>\n<li>\u0110\u1ea7u ti\u00ean, ch\u1ecdn to\u00e0n b\u1ed9 v\u00f9ng d\u1eef li\u1ec7u mu\u1ed1n lo\u1ea1i b\u1ecf s\u1ef1 l\u1eb7p l\u1ea1i b\u1eb1ng c\u00e1ch \u0111\u1ec3 con tr\u1ecf chu\u1ed9t v\u00e0o b\u1ea5t c\u1ee9 \u00f4 n\u00e0o trong v\u00f9ng r\u1ed3i s\u1eed d\u1ee5ng ph\u00edm t\u1eaft<strong><code class=\"highlighter-rouge\">CTRL + A<\/code><\/strong>.<\/li>\n<li>Tr\u00ean thanh menu c\u1ee7a Excel, ch\u1ecdn th\u1ebb <strong>Data<\/strong> nh\u00f3m *Data Tools** r\u1ed3i b\u1ea5m n\u00fat <strong><strong>Remove Duplicates<\/strong><\/strong><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2016\/03\/2016-03-23-remove-duplicates-excel.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-32349\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/2016-03-23-remove-duplicates-excel.png\" width=\"593\" height=\"416\" title=\"2016-03-23-remove-duplicates-excel\"><\/a><\/li>\n<\/ol>\n<ol>\n<li>C\u1eeda s\u1ed5 <strong>Remove Duplicates<\/strong> xu\u1ea5t hi\u1ec7n, t\u1ea1i \u0111\u00e2y b\u1ea1n ch\u1ecdn c\u1ed9t c\u1ea7n lo\u1ea1i b\u1ecf d\u1eef li\u1ec7u tr\u00f9ng l\u1eb7p. N\u1ebfu b\u1ea3ng c\u1ee7a b\u1ea1n c\u00f3 ti\u00eau \u0111\u1ec1 th\u00ec tick d\u1ea5u ch\u1ecdn \u1edf m\u1ee5c <strong>My data has headers<\/strong><\/li>\n<li>Sau khi b\u1ea5m <strong>OK<\/strong> b\u1ea1n s\u1ebd nh\u1eadn \u0111\u01b0\u1ee3c th\u00f4ng b\u00e1o c\u00f3 bao nhi\u00eau d\u1eef li\u1ec7u l\u1eb7p v\u00e0 \u0111\u00e3 \u0111\u01b0\u1ee3c lo\u1ea1i b\u1ecf, c\u00f2n l\u1ea1i bao nhi\u00eau d\u00f2ng d\u1eef li\u1ec7u l\u00e0 duy nh\u1ea5t.<\/li>\n<\/ol>\n<h2 id=\"loi-b-d-liu-lp-bng-cch-copy-d-liu-duy-nht-ra-vng-khc\"><span class=\"ez-toc-section\" id=\"Loai_bo_du_lieu_lap_bang_cach_copy_du_lieu_duy_nhat_ra_vung_khac\"><\/span>Lo\u1ea1i b\u1ecf d\u1eef li\u1ec7u l\u1eb7p b\u1eb1ng c\u00e1ch copy d\u1eef li\u1ec7u duy nh\u1ea5t ra v\u00f9ng kh\u00e1c<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>C\u00f3 m\u1ed9t c\u00e1ch kh\u00e1c n\u1eefa \u0111\u1ec3 lo\u1ea1i b\u1ecf d\u1eef li\u1ec7u l\u1eb7p l\u00e0 copy d\u1eef li\u1ec7u kh\u00f4ng b\u1ecb tr\u00f9ng l\u1eb7p ra m\u1ed9t n\u01a1i kh\u00e1c. C\u00e1ch l\u00e0m nh\u01b0 sau:<\/p>\n<ol>\n<li>Ch\u1ecdn to\u00e0n b\u1ed9 b\u1ea3ng ho\u1eb7c v\u00f9ng c\u1ea7n th\u1ef1c hi\u1ec7n thao t\u00e1c copy<\/li>\n<li>Trong Excel, ch\u1ecdn th\u1ebb <strong>Data<\/strong>, trong nh\u00f3m <strong>Sort &amp; Filter<\/strong> ch\u1ecdn <strong>Advanced<\/strong><\/li>\n<li>Trong c\u1eeda s\u1ed5 Advanced Filter, h\u00e3y th\u1ef1c hi\u1ec7n c\u00e1c b\u01b0\u1edbc sau \u0111\u00e2y:<\/li>\n<\/ol>\n<ul>\n<li>Ch\u1ecdn \u00f4 <strong>Copy to another location<\/strong><\/li>\n<li>M\u1ee5c <strong>List Range<\/strong> l\u00e0 d\u1eef li\u1ec7u \u0111\u00e3 \u0111\u01b0\u1ee3c ch\u1ecdn \u1edf b\u01b0\u1edbc s\u1ed1 1<\/li>\n<li>M\u1ee5c <strong>Copy to<\/strong> ch\u1ecdn n\u01a1i s\u1ebd copy nh\u1eefng d\u1eef li\u1ec7u kh\u00f4ng c\u00f3 s\u1ef1 tr\u00f9ng l\u1eb7p<\/li>\n<li>\u0110\u00e1nh d\u1ea5u ch\u1ecdn \u1edf h\u1ed9p ki\u1ec3m <strong><strong>Unique records only<\/strong><\/strong><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2016\/03\/2016-03-23-copy-unique-values.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-32350\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/2016-03-23-copy-unique-values.png\" width=\"493\" height=\"321\" title=\"2016-03-23-copy-unique-values\"><\/a><\/li>\n<\/ul>\n<ol>\n<li>Cu\u1ed1i c\u00f9ng, click ch\u1ecdn <strong>OK<\/strong> v\u00e0 d\u1eef li\u1ec7u kh\u00f4ng tr\u00f9ng l\u1eb7p \u0111\u00e3 \u0111\u01b0\u1ee3c copy ra 1 n\u01a1i kh\u00e1c<\/li>\n<\/ol>\n<h2 id=\"s-dng-cng-thc-v-kt-hp-vi-chc-nng-lc-d-liu\"><span class=\"ez-toc-section\" id=\"Su_dung_cong_thuc_va_ket_hop_voi_chuc_nang_loc_du_lieu\"><\/span>S\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c v\u00e0 k\u1ebft h\u1ee3p v\u1edbi ch\u1ee9c n\u0103ng l\u1ecdc d\u1eef li\u1ec7u<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>M\u1ed9t c\u00e1ch n\u1eefa \u0111\u1ec3 c\u00f3 th\u1ec3 lo\u1ea1i b\u1ecf, t\u00e1ch d\u1eef li\u1ec7u l\u1eb7p l\u1ea1i ra kh\u1ecfi d\u1eef li\u1ec7u th\u00f4 \u0111\u00f3 l\u00e0 c\u00e1ch s\u1eed d\u1ee5ng c\u1ed9t ph\u1ee5, d\u00f9ng c\u00f4ng th\u1ee9c \u0111\u1ec3 bi\u1ebft \u0111\u01b0\u1ee3c d\u1eef li\u1ec7u n\u00e0o l\u1eb7p, d\u1eef li\u1ec7u n\u00e0o kh\u00f4ng l\u1eb7p nh\u01b0 trong h\u00ecnh sau:<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2016\/03\/2016-03-23-identify-duplicate-rows.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-32351\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/2016-03-23-identify-duplicate-rows.png\" width=\"592\" height=\"264\" title=\"2016-03-23-identify-duplicate-rows\"><\/a><\/p>\n<p>\u1ede \u0111\u00e2y, ch\u00fang ta s\u1ebd k\u1ebft h\u1ee3p c\u00f4ng th\u1ee9c COUNTIFS v\u1edbi c\u00e2u \u0111i\u1ec1u ki\u1ec7n IF \u0111\u1ec3 ki\u1ec3m tra d\u1eef li\u1ec7u l\u1eb7p hay kh\u00f4ng d\u1ef1a v\u00e0o 3 c\u1ed9t A, B v\u00e0 C trong d\u1eef li\u1ec7u, n\u1ebfu k\u1ebft qu\u1ea3 c\u1ee7a h\u00e0m COUNTIFS l\u1edbn h\u01a1n 1 t\u1ee9c l\u00e0 d\u1eef li\u1ec7u \u0111\u00e3 l\u1eb7p l\u1ea1i, ng\u01b0\u1ee3c l\u1ea1i, d\u1eef li\u1ec7u l\u00e0 duy nh\u1ea5t.<\/p>\n<p><strong>Ch\u00fa \u00fd<\/strong> \u1edf \u0111\u00e2y ch\u00fang ta ph\u00e2n bi\u1ec7t 2 tr\u01b0\u1eddng h\u1ee3p:<\/p>\n<div class=\"code-block code-block-2\" style=\"margin: 8px 0;clear: both\">\n<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/vba101-tu-dong-hoa-excel-voi-lap-trinh-vba-cho-nguoi-moi-bat-dau\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/vba101_92019-nho-32.gif\" title=\"vba101_92019-nho-32\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<div class=\"code-block code-block-1\" style=\"margin: 8px 0;clear: both\">\n<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/ex101_92019-nho-91.gif\" title=\"ex101_92019-nho-91\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<ol>\n<li>C\u00f4ng th\u1ee9c \u0111\u1ec3 ki\u1ec3m tra d\u1eef li\u1ec7u l\u1eb7p kh\u00f4ng bao g\u1ed3m l\u1ea7n \u0111\u1ea7u ti\u00ean d\u1eef li\u1ec7u xu\u1ea5t hi\u1ec7n:<code class=\"highlighter-rouge\">=IF(COUNTIFS($A$2:$A2, $A2, $B$2:$B2, $B2, $C$2:$C2, $C2)&gt;1, \"Duplicate row\", \"Unique\")<\/code><\/li>\n<li>C\u00f4ng th\u1ee9c \u0111\u1ec3 ki\u1ec3m tra d\u1eef li\u1ec7u l\u1eb7p c\u00f3 bao g\u1ed3m l\u1ea7n \u0111\u1ea7u ti\u00ean d\u1eef li\u1ec7u xu\u1ea5t hi\u1ec7n:<code class=\"highlighter-rouge\">=IF(COUNTIFS($A$2:$A$10, $A2, $B$2:$B$10, $B2, $C$2:$C$10, $C2)&gt;1, \"Duplicate row\", \"Unique\")<\/code><\/li>\n<\/ol>\n<p>Sau khi \u0111\u00e3 ho\u00e0n th\u00e0nh c\u1ed9t ph\u1ee5 \u0111\u1ec3 ph\u00e2n bi\u1ec7t \u0111\u01b0\u1ee3c d\u1eef li\u1ec7u duy nh\u1ea5t v\u00e0 d\u1eef li\u1ec7u l\u1eb7p. Vi\u1ec7c c\u00f2n l\u1ea1i ch\u00fang ta ph\u1ea3i l\u00e0m l\u00e0 s\u1eed d\u1ee5ng ch\u1ee9c n\u0103ng <strong>Filter<\/strong> quen thu\u1ed9c c\u1ee7a Excel \u0111\u1ec3 c\u00f3 th\u1ec3 lo\u1ea1i b\u1ecf \u0111\u01b0\u1ee3c d\u1eef li\u1ec7u b\u1ecb l\u1eb7p:<\/p>\n<ol>\n<li>Ch\u1ecdn to\u00e0n b\u1ed9 d\u1eef li\u1ec7u bao g\u1ed3m c\u1ea3 c\u1ed9t v\u1eeba t\u1ea1o<\/li>\n<li>Trong th\u1ebb <strong>Data<\/strong>, b\u1ea5m n\u00fat <strong>Filter<\/strong> h\u00ecnh c\u00e1i ph\u1ec5u.<\/li>\n<li>B\u1ea5m ch\u1ecdn m\u1ee5c <strong>Duplicate row<\/strong> r\u1ed3i b\u1ea5m <strong>OK<\/strong><\/li>\n<li>Sau \u0111\u00f3, ch\u00fang ta \u0111i xo\u00e1 nh\u1eefng d\u00f2ng d\u1eef li\u1ec7u b\u1ecb tr\u00f9ng b\u1eb1ng c\u00e1ch, ch\u1ecdn nh\u1eefng d\u00f2ng c\u00f2n l\u1ea1i sau qu\u00e1 tr\u00ecnh l\u1ecdc, nh\u1ea5n chu\u1ed9t ph\u1ea3i v\u00e0 b\u1ea5m <strong>Delete Row<\/strong> t\u1eeb menu chu\u1ed9t ph\u1ea3i.<br \/>\n<a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2016\/03\/2016-23-03-delete-duplicate-rows-excel.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-32352\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/2016-23-03-delete-duplicate-rows-excel.png\" width=\"361\" height=\"291\" title=\"2016-23-03-delete-duplicate-rows-excel\"><\/a><\/li>\n<\/ol>\n<p>M\u1ed9t c\u00e1ch t\u01b0\u01a1ng t\u1ef1, b\u1ea1n c\u0169ng c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng c\u00e1ch n\u00e0y \u0111\u1ec3 xo\u00e1 d\u1eef li\u1ec7u l\u1eb7p l\u1ea1i \u1edf m\u1ed9t l\u1ea7n c\u1ee5 th\u1ec3 n\u00e0o \u0111\u00f3, d\u00f9 d\u1eef li\u1ec7u \u0111\u00f3 c\u00f3 l\u1eb7p l\u1ea7n th\u1ee9 3, l\u1ea7n th\u1ee9 4, l\u1ea7n th\u1ee9 5 v.v.<\/p>\n<p>C\u00f2n r\u1ea5t nhi\u1ec1u ki\u1ebfn th\u1ee9c v\u1ec1 Excel c\u00f3 th\u1ec3 b\u1ea1n ch\u01b0a bi\u1ebft.\u00a0To\u00e0n b\u1ed9 nh\u1eefng ki\u1ebfn th\u1ee9c n\u00e0y c\u00e1c b\u1ea1n \u0111\u1ec1u c\u00f3 th\u1ec3 h\u1ecdc \u0111\u01b0\u1ee3c trong kh\u00f3a h\u1ecdc\u00a0<a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\">EX101 \u2013 Excel t\u1eeb c\u01a1 b\u1ea3n t\u1edbi chuy\u00ean gia<\/a>\u00a0c\u1ee7a H\u1ecdc Excel Online. \u0110\u00e2y l\u00e0 kh\u00f3a h\u1ecdc gi\u00fap b\u1ea1n h\u1ec7 th\u1ed1ng ki\u1ebfn th\u1ee9c m\u1ed9t c\u00e1ch \u0111\u1ea7y \u0111\u1ee7, chi ti\u1ebft. H\u01a1n n\u1eefa kh\u00f4ng h\u1ec1 c\u00f3 gi\u1edbi h\u1ea1n v\u1ec1 th\u1eddi gian h\u1ecdc t\u1eadp n\u00ean b\u1ea1n c\u00f3 th\u1ec3 tho\u1ea3i m\u00e1i h\u1ecdc b\u1ea5t c\u1ee9 l\u00fac n\u00e0o, d\u1ec5 d\u00e0ng tra c\u1ee9u l\u1ea1i ki\u1ebfn th\u1ee9c khi c\u1ea7n. Hi\u1ec7n nay h\u1ec7 th\u1ed1ng \u0111ang c\u00f3 \u01b0u \u0111\u00e3i r\u1ea5t l\u1edbn cho b\u1ea1n khi \u0111\u0103ng k\u00fd tham gia kh\u00f3a h\u1ecdc. Chi ti\u1ebft xem t\u1ea1i: <a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\" target=\"_blank\" rel=\"noopener noreferrer\">HocExcel.Online<\/a><\/p>\n<\/div>\n<div class=\"uk-panel uk-margin uk-width-xlarge\">\n<p>Click \u0111\u0103ng k\u00fd h\u1ecdc t\u1ea1i:<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/khoa-hoc\" target=\"_blank\" rel=\"noopener\">T\u1ea5t c\u1ea3 kho\u00e1 h\u1ecdc\u00a0<span>\ud83d\udcd6<\/span><\/a><\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-kich-hoat-khoa-hoc-tai-hoc-excel-online.html\" target=\"_blank\" rel=\"noopener\">H\u01b0\u1edbng d\u1eabn k\u00edch ho\u1ea1t<\/a><\/p>\n<p>HKD H\u1ecdc Excel Online<br \/>S\u1ed1 \u0110K: 17A80048102<\/p>\n<\/div>\n<div class=\"uk-panel uk-text-small uk-margin uk-margin-remove-bottom uk-text-center\">\n<p>\u00a9  document.currentScript.insertAdjacentHTML(&#8216;afterend&#8217;, &#8221; + new Intl.DateTimeFormat(document.documentElement.lang, {year: &#8216;numeric&#8217;}).format() + &#8221;);  H\u1ecdc Excel Online. All rights reserved.<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/vba101-tu-dong-hoa-excel-voi-lap-trinh-vba-cho-nguoi-moi-bat-dau\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/vba101_92019-nho-32.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":1273,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-1272","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-nang-cao"],"_links":{"self":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/1272","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/comments?post=1272"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/1272\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/1273"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=1272"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=1272"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=1272"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}