{"id":5923,"date":"2024-12-21T11:20:14","date_gmt":"2024-12-21T11:20:14","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/huong-dan-cach-tu-dong-sap-xep-du-lieu-bang-ham-sort\/"},"modified":"2024-12-21T11:20:14","modified_gmt":"2024-12-21T11:20:14","slug":"huong-dan-cach-tu-dong-sap-xep-du-lieu-bang-ham-sort","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/huong-dan-cach-tu-dong-sap-xep-du-lieu-bang-ham-sort\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn c\u00e1ch t\u1ef1 \u0111\u1ed9ng s\u1eafp x\u1ebfp d\u1eef li\u1ec7u b\u1eb1ng h\u00e0m SORT"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p>S\u1eafp x\u1ebfp d\u1eef li\u1ec7u trong\u00a0Excel l\u00e0 m\u1ed9t vi\u1ec7c t\u01b0\u1edfng nh\u01b0 r\u1ea5t\u00a0\u0111\u01a1n gi\u1ea3n, b\u1ea1n ch\u1ec9 c\u1ea7n ch\u1ecdn d\u1eef li\u1ec7u c\u1ea7n s\u1eafp x\u1ebfp r\u1ed3i b\u1ea5m 1 n\u00fat l\u1ec7nh Sort trong th\u1ebb Data l\u00e0 xong. Nh\u01b0ng th\u1ef1c t\u1ebf c\u00f3 ph\u1ea3i\u00a0\u0111\u01a1n gi\u1ea3n nh\u01b0 v\u1eady? H\u00e3y xem nh\u1eefng th\u1eafc m\u1eafc sau:<\/p>\n<ul>\n<li>D\u1eef li\u1ec7u kh\u00f4ng c\u00f3 s\u1eb5n m\u00e0 ph\u1ea3i d\u00f9ng h\u00e0m, d\u00f9ng\u00a0c\u00e1c thao t\u00e1c\u00a0l\u1ecdc ra n\u00ean m\u1ed7i khi mu\u1ed1n s\u1eafp x\u1ebfp d\u1eef li\u1ec7u\u00a0\u0111\u00f3 l\u1ea1i ph\u1ea3i b\u1ea5m l\u1ec7nh Sort, vi\u1ec7c n\u00e0y m\u1ea5t th\u1eddi gian<\/li>\n<li>T\u00f4i mu\u1ed1n t\u1ef1\u00a0\u0111\u1ed9ng s\u1eafp x\u1ebfp d\u1eef li\u1ec7u m\u00e0 kh\u00f4ng c\u1ea7n b\u1ea5m v\u00e0o l\u1ec7nh Sort.<\/li>\n<li>T\u00f4i mu\u1ed1n l\u00e0m vi\u1ec7c t\u1ef1\u00a0\u0111\u1ed9ng tr\u00ean\u00a0Excel nh\u01b0ng kh\u00f4ng mu\u1ed1n h\u1ecdc v\u1ec1 VBA<\/li>\n<\/ul>\n<p>V\u00e0 trong Micrsoft\u00a0Office 365 (phi\u00ean b\u1ea3n c\u00f3 b\u1ea3n quy\u1ec1n\u00a0\u0111\u1ea7y\u00a0\u0111\u1ee7) c\u00f3 m\u1ed9t h\u00e0m gi\u00fap l\u00e0m vi\u1ec7c n\u00e0y th\u1eadt d\u1ec5 d\u00e0ng:\u00a0\u0111\u00f3 l\u00e0 h\u00e0m SORT. H\u00e3y c\u00f9ng H\u1ecdc\u00a0Excel Online t\u00ecm hi\u1ec3u v\u1ec1 h\u00e0m n\u00e0y nh\u00e9:<\/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-6766a46e0fe3c\" 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\/huong-dan-cach-tu-dong-sap-xep-du-lieu-bang-ham-sort.html#Cau_truc_cua_ham_SORT_Sort_Function\" title=\"C\u1ea5u tr\u00fac c\u1ee7a h\u00e0m SORT (Sort Function)\">C\u1ea5u tr\u00fac c\u1ee7a h\u00e0m SORT (Sort Function)<\/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\/huong-dan-cach-tu-dong-sap-xep-du-lieu-bang-ham-sort.html#Cach_su_dung_ham_SORT\" title=\"C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m SORT\">C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m SORT<\/a>\n<ul class=\"ez-toc-list-level-3\">\n<li class=\"ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-cach-tu-dong-sap-xep-du-lieu-bang-ham-sort.html#Ham_Sort_ket_hop_voi_ham_Filter\" title=\"H\u00e0m Sort k\u1ebft h\u1ee3p v\u1edbi h\u00e0m Filter\">H\u00e0m Sort k\u1ebft h\u1ee3p v\u1edbi h\u00e0m Filter<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-cach-tu-dong-sap-xep-du-lieu-bang-ham-sort.html#Ham_Sort_ket_hop_voi_ham_UNIQUE\" title=\"H\u00e0m Sort k\u1ebft h\u1ee3p v\u1edbi h\u00e0m UNIQUE\">H\u00e0m Sort k\u1ebft h\u1ee3p v\u1edbi h\u00e0m UNIQUE<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-cach-tu-dong-sap-xep-du-lieu-bang-ham-sort.html#Sap_xep_theo_dieu_kien_trong_ham_Sort\" title=\"S\u1eafp x\u1ebfp theo\u00a0\u0111i\u1ec1u ki\u1ec7n trong h\u00e0m Sort\">S\u1eafp x\u1ebfp theo\u00a0\u0111i\u1ec1u ki\u1ec7n trong h\u00e0m Sort<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2><span class=\"ez-toc-section\" id=\"Cau_truc_cua_ham_SORT_Sort_Function\"><\/span>C\u1ea5u tr\u00fac c\u1ee7a h\u00e0m SORT (Sort Function)<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>H\u00e0m Sort c\u00f3 t\u00e1c d\u1ee5ng l\u1ecdc c\u00e1c d\u1eef li\u1ec7u theo m\u1ea3ng<\/p>\n<p>C\u1ea5u tr\u00fac c\u1ee7a h\u00e0m:<\/p>\n<p>=SORT(array,[sort_index],[sort_order],[by_col])<\/p>\n<p>Trong\u00a0\u0111\u00f3:<\/p>\n<ul>\n<li><strong>array<\/strong>: l\u00e0 m\u1ea3ng d\u1eef li\u1ec7u c\u1ea7n s\u1eafp x\u1ebfp (c\u00f3 th\u1ec3 g\u1ed3m nhi\u1ec1u d\u00f2ng, nhi\u1ec1u c\u1ed9t nh\u01b0ng ph\u1ea3i li\u00ean t\u1ee5c)<\/li>\n<li><strong>sort_index<\/strong>: ti\u00eau chu\u1ea9n s\u1eafp x\u1ebfp theo c\u1ed9t hay d\u00f2ng th\u1ee9 m\u1ea5y trong m\u1ea3ng d\u1eef li\u1ec7u (nh\u1eadp s\u1ed1 c\u1ee5 th\u1ec3, kh\u00f4ng b\u1eaft bu\u1ed9c). M\u1eb7c\u00a0\u0111\u1ecbnh l\u00e0 c\u1ed9t\/d\u00f2ng\u00a0\u0111\u1ea7u ti\u00ean<\/li>\n<li><strong>sort_order<\/strong>: th\u1ee9 t\u1ef1 s\u1eafp x\u1ebfp theo t\u0103ng d\u1ea7n hay gi\u1ea3m d\u1ea7n. Kh\u00f4ng b\u1eaft bu\u1ed9c, m\u1eb7c\u00a0\u0111\u1ecbnh l\u00e0 t\u0103ng d\u1ea7n.<\/li>\n<li><strong>by_col<\/strong>: s\u1eafp x\u1ebfp theo c\u1ed9t hay theo d\u00f2ng. Kh\u00f4ng b\u1eaft bu\u1ed9c, m\u1eb7c\u00a0\u0111\u1ecbnh l\u00e0 theo c\u1ed9t.<\/li>\n<\/ul>\n<p>Nh\u01b0 v\u1eady h\u00e0m SORT cho ph\u00e9p s\u1eafp x\u1ebfp d\u1eef li\u1ec7u theo c\u1ed9t ho\u1eb7c theo d\u00f2ng t\u00f9y theo ng\u01b0\u1eddi d\u00f9ng quy\u00a0\u0111\u1ecbnh.\u00a0\u0110i\u1ec1u n\u00e0y gi\u00fap h\u00e0m SORT r\u1ea5t linh ho\u1ea1t theo c\u00e1c y\u00eau c\u1ea7u s\u1eafp x\u1ebfp d\u1eef li\u1ec7u.<\/p>\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-528.gif\" title=\"ex101_92019-nho-528\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<h2><span class=\"ez-toc-section\" id=\"Cach_su_dung_ham_SORT\"><\/span>C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m SORT<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<h3><span class=\"ez-toc-section\" id=\"Ham_Sort_ket_hop_voi_ham_Filter\"><\/span>H\u00e0m Sort k\u1ebft h\u1ee3p v\u1edbi h\u00e0m Filter<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Array c\u00f3 th\u1ec3 l\u00e0 m\u1ed9t v\u00f9ng d\u1eef li\u1ec7u ho\u1eb7c k\u1ebft qu\u1ea3 c\u1ee7a 1 c\u00f4ng th\u1ee9c cho ra k\u1ebft qu\u1ea3 d\u1ea1ng m\u1ea3ng. Do\u00a0\u0111\u00f3 h\u00e0m SORT r\u1ea5t th\u00edch h\u1ee3p\u00a0\u0111\u1ec3 k\u1ebft h\u1ee3p v\u1edbi h\u00e0m FILTER: tr\u00edch l\u1ecdc d\u1eef li\u1ec7u\u00a0\u0111\u1ed3ng th\u1eddi s\u1eafp x\u1ebfp lu\u00f4n d\u1eef li\u1ec7u\u00a0\u0111\u00f3.<\/p>\n<p>V\u00ed d\u1ee5 nh\u01b0 sau:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-23223\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/su-dung-ham-sort-ket-hop-filter.png\" width=\"896\" height=\"406\" title=\"su-dung-ham-sort-ket-hop-filter\"><\/p>\n<p>Trong b\u00e0i\u00a0<em><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-cach-lap-bao-cao-chi-tiet-tu-dong-voi-ham-filter-trong-excel.html\">H\u01b0\u1edbng d\u1eabn c\u00e1ch l\u1eadp b\u00e1o c\u00e1o chi ti\u1ebft t\u1ef1 \u0111\u1ed9ng v\u1edbi h\u00e0m Filter trong Excel<\/a>\u00a0<\/em>ch\u00fang ta\u00a0\u0111\u00e3 t\u00ecm hi\u1ec3u c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m Filter\u00a0\u0111\u1ec3 l\u1eadp ra b\u00e1o c\u00e1o chi ti\u1ebft t\u1ef1\u00a0\u0111\u1ed9ng. Nh\u01b0ng\u00a0\u1edf v\u00ed d\u1ee5 tr\u00ean, ch\u00fang ta th\u1ea5y d\u1eef li\u1ec7u trong b\u1ea3ng k\u00ea b\u00e1n h\u00e0ng kh\u00f4ng\u00a0\u0111\u01b0\u1ee3c s\u1eafp x\u1ebfp theo tr\u1eadt t\u1ef1 n\u00e0o c\u1ea3. Khi\u00a0\u0111\u01b0a k\u1ebft qu\u1ea3 ra b\u00e1o c\u00e1o chi ti\u1ebft, ch\u00fang ta mu\u1ed1n d\u1eef li\u1ec7u c\u1ee7a b\u00e1o c\u00e1o s\u1ebd ph\u1ea3i <strong>t\u1ef1\u00a0\u0111\u1ed9ng s\u1eafp x\u1ebfp<\/strong> theo Ng\u00e0y b\u00e1n.<\/p>\n<p>Do\u00a0\u0111\u00f3 ch\u00fang ta s\u1ebd vi\u1ebft h\u00e0m SORT l\u1ed3ng b\u00ean ngo\u00e0i h\u00e0m FILTER, d\u00f9ng n\u1ed9i dung h\u00e0m Filter v\u00e0o v\u1ecb tr\u00ed tham s\u1ed1\u00a0array.<\/p>\n<p>K\u1ebft qu\u1ea3 thu\u00a0\u0111\u01b0\u1ee3c l\u00e0 d\u1eef li\u1ec7u v\u1eeba l\u1ecdc, v\u1eeba t\u1ef1\u00a0\u0111\u1ed9ng s\u1eafp x\u1ebfp trong b\u00e1o c\u00e1o chi ti\u1ebft. R\u1ea5t\u00a0\u0111\u01a1n gi\u1ea3n ph\u1ea3i kh\u00f4ng n\u00e0o?<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Ham_Sort_ket_hop_voi_ham_UNIQUE\"><\/span>H\u00e0m Sort k\u1ebft h\u1ee3p v\u1edbi h\u00e0m UNIQUE<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>X\u00e9t v\u00ed d\u1ee5 sau:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-23226\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/loc-danh-sach-khong-trung-co-sap-xep.png\" width=\"937\" height=\"363\" title=\"loc-danh-sach-khong-trung-co-sap-xep\"><\/p>\n<p>Khi mu\u1ed1n l\u1ecdc danh s\u00e1ch c\u00e1c m\u1eb7t h\u00e0ng kh\u00f4ng tr\u00f9ng, ch\u00fang ta c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng <a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-cach-su-dung-ham-unique-tu-dong-loc-danh-sach-khong-trung-trong-excel.html\">h\u00e0m UNIQUE<\/a>. Tuy nhi\u00ean c\u00f3 th\u00eam 1 y\u00eau c\u1ea7u l\u00e0 danh s\u00e1ch c\u00e1c m\u1eb7t h\u00e0ng\u00a0\u0111\u01b0\u1ee3c l\u1ecdc ra ph\u1ea3i t\u1ef1\u00a0\u0111\u1ed9ng s\u1eafp x\u1ebfp theo th\u1ee9 t\u1ef1 ch\u1eef c\u00e1i t\u1eeb A\u00a0\u0111\u1ebfn Z. Khi\u00a0\u0111\u00f3 ch\u00fang ta s\u1eed d\u1ee5ng h\u00e0m SORT b\u00ean ngo\u00e0i h\u00e0m UNIQUE.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Sap_xep_theo_dieu_kien_trong_ham_Sort\"><\/span>S\u1eafp x\u1ebfp theo\u00a0\u0111i\u1ec1u ki\u1ec7n trong h\u00e0m Sort<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>S\u1eafp x\u1ebfp d\u1eef li\u1ec7u theo\u00a0\u0111i\u1ec1u ki\u1ec7n nh\u1ea5t\u00a0\u0111\u1ecbnh, n\u00f3i c\u00e1ch kh\u00e1c ch\u00ednh l\u00e0 ph\u1ea3i s\u1eed d\u1ee5ng c\u00e1c tham s\u1ed1 c\u00f2n l\u1ea1i trong h\u00e0m SORT, kh\u00f4ng ph\u1ea3i ch\u1ec9 vi\u1ebft\u00a0\u0111\u01a1n gi\u1ea3n l\u00e0\u00a0ch\u1ec9 c\u00f3\u00a0array, c\u00f2n c\u00e1c gi\u00e1 tr\u1ecb c\u00f2n l\u1ea1i th\u00ec \u0111\u1ec3\u00a0m\u1eb7c\u00a0\u0111\u1ecbnh.<\/p>\n<p>Trong v\u00ed d\u1ee5 d\u00f9ng h\u00e0m SORT k\u1ebft h\u1ee3p v\u1edbi h\u00e0m FILTER, n\u1ebfu nh\u01b0 y\u00eau c\u1ea7u s\u1eafp x\u1ebfp l\u00e0 \u201cS\u1eafp x\u1ebfp k\u1ebft qu\u1ea3 b\u00e1o c\u00e1o chi ti\u1ebft theo <strong>s\u1ed1 l\u01b0\u1ee3ng<\/strong> <strong>Gi\u1ea3m d\u1ea7n<\/strong>\u201d th\u00ec ch\u00fang ta s\u1ebd x\u1eed l\u00fd nh\u01b0 th\u1ebf n\u00e0o?<\/p>\n<ul>\n<li>sort_index: theo c\u1ed9t S\u1ed1 l\u01b0\u1ee3ng, l\u00e0 c\u1ed9t th\u1ee9 3 t\u1eeb tr\u00e1i sang (nh\u1eadp s\u1ed1 3)<\/li>\n<li>sort_order: th\u1ee9 t\u1ef1 s\u1eafp x\u1ebfp l\u00e0 gi\u1ea3m d\u1ea7n (nh\u1eadp s\u1ed1 -1). N\u1ebfu th\u1ee9 t\u1ef1 t\u0103ng d\u1ea7n (m\u1eb7c\u00a0\u0111\u1ecbnh) th\u00ec l\u00e0 s\u1ed1 1.<\/li>\n<\/ul>\n<p>Khi\u00a0\u0111\u00f3 h\u00e0m sort\u00a0\u0111\u01b0\u1ee3c vi\u1ebft nh\u01b0 sau:<\/p>\n<p style=\"padding-left: 30px\">=SORT(FILTER(B3:D14,(B3:B14&gt;=G2)*(B3:B14&lt;=G3)*(A3:A14=G4),\u201d\u201d),3,-1)<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-23228\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/sap-xep-du-lieu-theo-cot-so-luong-giam-dan.png\" width=\"924\" height=\"405\" title=\"sap-xep-du-lieu-theo-cot-so-luong-giam-dan\"><\/p>\n<p>Hy v\u1ecdng qua b\u00e0i vi\u1ebft n\u00e0y, c\u00e1c b\u1ea1n\u00a0\u0111\u00e3 c\u00f3 th\u00eam nh\u1eefng ki\u1ebfn th\u1ee9c h\u1eefu\u00a0\u00edch\u00a0\u0111\u1ec3\u00a0\u00e1p d\u1ee5ng v\u00e0o c\u00f4ng vi\u1ec7c c\u1ee7a m\u00ecnh. C\u00f3 th\u1ec3 th\u1ea5y r\u1eb1ng Microsoft r\u1ea5t ch\u00fa\u00a0\u00fd ph\u00e1t tri\u1ec3n\u00a0Excel\u00a0\u0111\u1ec3 n\u00f3 ng\u00e0y c\u00e0ng th\u00e2n thi\u1ec7n, d\u1ec5 s\u1eed d\u1ee5ng v\u00e0\u00a0\u0111\u1ea1t hi\u1ec7u qu\u1ea3 cao h\u01a1n. V\u1edbi nh\u1eefng h\u00e0m m\u1edbi c\u1ee7a Microsoft\u00a0Office 365, ch\u00fang ta\u00a0\u0111\u00e3 c\u00f3 th\u1ec3 c\u1ea3m th\u1ea5y\u00a0Excel tuy\u1ec7t v\u1eddi h\u01a1n r\u1ea5t nhi\u1ec1u ph\u1ea3i kh\u00f4ng.<\/p>\n<p>Xem th\u00eam c\u00e1c b\u00e0i vi\u1ebft c\u00f9ng ch\u1ee7\u00a0\u0111\u1ec1 s\u1eafp x\u1ebfp d\u1eef li\u1ec7u trong\u00a0Excel:<\/p>\n<p style=\"padding-left: 30px\"><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-cach-tra-ve-thu-tu-ban-dau-truoc-khi-sap-xep-bang-sort-trong-excel.html\">H\u01b0\u1edbng d\u1eabn c\u00e1ch tr\u1ea3 v\u1ec1 th\u1ee9 t\u1ef1 ban \u0111\u1ea7u tr\u01b0\u1edbc khi s\u1eafp x\u1ebfp b\u1eb1ng sort trong Excel<\/a><\/p>\n<p style=\"padding-left: 30px\"><a href=\"http:\/\/blog.ezworkapp.com\/sap-xep-du-lieu-theo-nhieu-dieu-kien-trong-excel.html\">H\u01b0\u1edbng d\u1eabn c\u00e1ch s\u1eafp x\u1ebfp d\u1eef li\u1ec7u theo nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n trong Excel<\/a><\/p>\n<p style=\"padding-left: 30px\"><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-cach-sap-xep-va-loc-du-lieu-trong-googlesheet.html\">H\u01b0\u1edbng d\u1eabn c\u00e1ch s\u1eafp x\u1ebfp v\u00e0 l\u1ecdc d\u1eef li\u1ec7u trong GoogleSheet<\/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\/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-528.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":5924,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-5923","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-co-ban"],"_links":{"self":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/5923","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=5923"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/5923\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/5924"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=5923"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=5923"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=5923"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}