{"id":5718,"date":"2024-12-20T11:34:37","date_gmt":"2024-12-20T11:34:37","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/20\/huong-dan-3-cach-tham-chieu-nguoc-tu-phai-qua-trai-trong-excel\/"},"modified":"2024-12-20T11:34:37","modified_gmt":"2024-12-20T11:34:37","slug":"huong-dan-3-cach-tham-chieu-nguoc-tu-phai-qua-trai-trong-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/20\/huong-dan-3-cach-tham-chieu-nguoc-tu-phai-qua-trai-trong-excel\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn 3 c\u00e1ch tham chi\u1ebfu ng\u01b0\u1ee3c t\u1eeb ph\u1ea3i qua tr\u00e1i trong Excel"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p>Vlookup l\u00e0 m\u1ed9t h\u00e0m d\u00f2 t\u00ecm, tham chi\u1ebfu ph\u1ed5 bi\u1ebfn v\u00e0 th\u01b0\u1eddng xuy\u00ean\u00a0\u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng. Nh\u01b0ng h\u00e0m n\u00e0y c\u00f3 1 nh\u01b0\u1ee3c\u00a0\u0111i\u1ec3m l\u00e0 h\u01b0\u1edbng t\u00ecm ki\u1ebfm t\u1eeb tr\u00e1i qua ph\u1ea3i. V\u1eady trong tr\u01b0\u1eddng h\u1ee3p ph\u1ea3i tham chi\u1ebfu ng\u01b0\u1ee3c l\u1ea1i, t\u1ee9c l\u00e0 t\u1eeb ph\u1ea3i qua tr\u00e1i th\u00ec ch\u00fang ta l\u00e0m th\u1ebf n\u00e0o? H\u00e3y c\u00f9ng H\u1ecdc\u00a0Excel Online t\u00ecm hi\u1ec3u 3 c\u00e1ch tham chi\u1ebfu ng\u01b0\u1ee3c t\u1eeb ph\u1ea3i qua tr\u00e1i trong excel qua b\u00e0i vi\u1ebft 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-6765564d12072\" 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-3-cach-tham-chieu-nguoc-tu-phai-qua-trai-trong-excel.html#Tham_chieu_nguoc_la_gi\" title=\"Tham chi\u1ebfu ng\u01b0\u1ee3c l\u00e0 g\u00ec?\">Tham chi\u1ebfu ng\u01b0\u1ee3c l\u00e0 g\u00ec?<\/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-3-cach-tham-chieu-nguoc-tu-phai-qua-trai-trong-excel.html#Tham_chieu_nguoc_voi_ham_lookup\" title=\"Tham chi\u1ebfu ng\u01b0\u1ee3c v\u1edbi h\u00e0m lookup\">Tham chi\u1ebfu ng\u01b0\u1ee3c v\u1edbi h\u00e0m lookup<\/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\/huong-dan-3-cach-tham-chieu-nguoc-tu-phai-qua-trai-trong-excel.html#Tham_chieu_nguoc_voi_ham_VLOOKUP\" title=\"Tham chi\u1ebfu ng\u01b0\u1ee3c v\u1edbi h\u00e0m VLOOKUP\">Tham chi\u1ebfu ng\u01b0\u1ee3c v\u1edbi h\u00e0m VLOOKUP<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-3-cach-tham-chieu-nguoc-tu-phai-qua-trai-trong-excel.html#Tham_chieu_nguoc_voi_ham_INDEXMATCH\" title=\"Tham chi\u1ebfu ng\u01b0\u1ee3c v\u1edbi h\u00e0m INDEX+MATCH\">Tham chi\u1ebfu ng\u01b0\u1ee3c v\u1edbi h\u00e0m INDEX+MATCH<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2><span class=\"ez-toc-section\" id=\"Tham_chieu_nguoc_la_gi\"><\/span>Tham chi\u1ebfu ng\u01b0\u1ee3c l\u00e0 g\u00ec?<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Tham chi\u1ebfu \u201cxu\u00f4i\u201d l\u00e0 d\u1ea1ng tham chi\u1ebfu t\u1eeb ph\u1ea3i qua tr\u00e1i.\u00a0\u0110\u00e2y l\u00e0 d\u1ea1ng th\u00f4ng th\u01b0\u1eddng ch\u00fang ta g\u1eb7p ph\u1ea3i.<\/p>\n<p>V\u00ed d\u1ee5: Trong h\u00ecnh d\u01b0\u1edbi\u00a0\u0111\u00e2y, ch\u00fang ta mu\u1ed1n bi\u1ebft\u00a0\u0111\u1ecba ch\u1ec9 d\u1ef1a v\u00e0o Code\u00a0\u0111\u01b0\u1ee3c ch\u1ecdn t\u1ea1i\u00a0\u00f4 E1:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-23709\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/tham-chieu-xuoi-vlookup-thong-thuong.png\" width=\"641\" height=\"263\" title=\"tham-chieu-xuoi-vlookup-thong-thuong\"><\/p>\n<p>S\u1eed d\u1ee5ng h\u00e0m VLOOKUP ta c\u00f3: E3=VLOOKUP(E1,$A$2:$B$9,2,0)<\/p>\n<p>C\u1ed9t\u00a0<strong>\u0111\u1ecba ch\u1ec9<\/strong> n\u1eb1m\u00a0\u1edf ph\u00eda b\u00ean ph\u1ea3i c\u1ee7a c\u1ed9t <strong>Code<\/strong>. Do\u00a0\u0111\u00f3 s\u1eed d\u1ee5ng h\u00e0m vlookup r\u1ea5t d\u1ec5 d\u00e0ng.<\/p>\n<p>Tuy nhi\u00ean n\u1ebfu y\u00eau c\u1ea7u cho 1\u00a0\u0111\u1ecba ch\u1ec9, t\u00ecm code t\u01b0\u01a1ng\u00a0\u1ee9ng m\u00e0 v\u1eabn gi\u1eef nguy\u00ean c\u1ea5u tr\u00fac b\u1ea3ng A1:B9 th\u00ec sao?<\/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-501.gif\" title=\"ex101_92019-nho-501\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-23710\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/tham-chieu-nguoc-de-bai.png\" width=\"638\" height=\"263\" title=\"tham-chieu-nguoc-de-bai\"><\/p>\n<p>\u1ede\u00a0\u0111\u00e2y chi\u1ec1u tham chi\u1ebfu l\u1ea1i l\u00e0 t\u1eeb Ph\u1ea3i qua Tr\u00e1i.\u00a0\u0110i\u1ec1u n\u00e0y ng\u01b0\u1ee3c v\u1edbi c\u00e1ch tham chi\u1ebfu th\u00f4ng th\u01b0\u1eddng c\u1ee7a h\u00e0m vlookup, do\u00a0\u0111\u00f3 ch\u00fang ta hay hi\u1ec3u th\u00e0nh tham chi\u1ebfu ng\u01b0\u1ee3c.<\/p>\n<p>H\u00e3y xem ch\u00fang ta c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng nh\u1eefng c\u00e1ch n\u00e0o\u00a0\u0111\u1ec3 tham chi\u1ebfu ng\u01b0\u1ee3c nh\u00e9.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Tham_chieu_nguoc_voi_ham_lookup\"><\/span>Tham chi\u1ebfu ng\u01b0\u1ee3c v\u1edbi h\u00e0m lookup<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>\u0110\u00e2y l\u00e0 1 h\u00e0m tham chi\u1ebfu r\u1ea5t h\u1eefu hi\u1ec7u trong\u00a0excel nh\u01b0ng hay b\u1ecb b\u1ecf qu\u00ean. H\u00e0m Lookup cho ph\u00e9p ch\u00fang ta tham chi\u1ebfu m\u1ed9t c\u00e1ch\u00a0\u0111a d\u1ea1ng v\u00e0 hi\u1ec7u qu\u1ea3.<\/p>\n<p>C\u00e1ch l\u00e0m nh\u01b0 sau:<\/p>\n<ul>\n<li>X\u00e9t t\u1eebng gi\u00e1 tr\u1ecb trong v\u00f9ng B2:B9 v\u1edbi gi\u00e1 tr\u1ecb t\u1ea1i\u00a0\u00f4 E1. Trong ph\u00e9p so s\u00e1nh B2:B9=E1, ta c\u00f3 c\u00e1c k\u1ebft qu\u1ea3 TRUE\/FALSE.\u00a0\u0110em s\u1ed1 1 chia cho bi\u1ec3u th\u1ee9c tr\u00ean, ta c\u00f3 TRUE=1 v\u00e0 FALSE=#DIV\/0. Khi\u00a0\u0111\u00f3 c\u00e1c k\u1ebft qu\u1ea3 l\u1ed7i chia cho 0 s\u1ebd kh\u00f4ng\u00a0\u0111\u01b0\u1ee3c t\u00ednh, ch\u1ec9 c\u00f2n l\u1ea1i gi\u00e1 tr\u1ecb\u00a0\u0111\u00fang l\u00e0 1<\/li>\n<li>T\u00ecm ki\u1ebfm gi\u00e1 tr\u1ecb 1 (ho\u1eb7c s\u1ed1 b\u1ea5t k\u1ef3 l\u1edbn h\u01a1n 0) trong k\u1ebft qu\u1ea3 c\u1ee7a ph\u00e9p so s\u00e1nh\u00a01\/(B2:B9=E1)<\/li>\n<li>V\u1edbi k\u1ebft qu\u1ea3\u00a0\u0111\u00fang thu\u00a0\u0111\u01b0\u1ee3c, tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb t\u01b0\u01a1ng\u00a0\u1ee9ng\u00a0\u1edf v\u00f9ng A2:A9<\/li>\n<\/ul>\n<p>H\u00e0m\u00a0\u0111\u01b0\u1ee3c vi\u1ebft nh\u01b0 sau:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-23711\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/cach1-lookup-tham-chieu-phai-qua-trai.png\" width=\"1057\" height=\"269\" title=\"cach1-lookup-tham-chieu-phai-qua-trai\"><\/p>\n<p>H\u00e0m LOOKUP kh\u00f4ng quy\u00a0\u0111\u1ecbnh chi\u1ec1u tham chi\u1ebfu,\u00a0\u0111\u1ed3ng th\u1eddi c\u00f3 t\u1edbi 2 c\u00e1ch vi\u1ebft n\u00ean r\u1ea5t linh ho\u1ea1t trong vi\u1ec7c tham chi\u1ebfu.<\/p>\n<p><em><strong>Ch\u00fa \u00fd<\/strong>: Trong c\u00f4ng th\u1ee9c tr\u00ean, ch\u00fa\u00a0\u00fd vi\u1ec7c l\u1ea5y 1 chia cho bi\u1ec3u th\u1ee9c so s\u00e1nh. B\u1edfi v\u00ec h\u00e0m LOOKUP y\u00eau c\u1ea7u b\u1ea3ng d\u1eef li\u1ec7u ph\u1ea3i\u00a0\u0111\u01b0\u1ee3c s\u1eafp x\u1ebfp theo tr\u1eadt t\u1ef1. N\u00ean trong tr\u01b0\u1eddng h\u1ee3p ch\u00fang ta kh\u00f4ng mu\u1ed1n s\u1eafp x\u1ebfp m\u00e0 v\u1eabn tham chi\u1ebfu\u00a0\u0111\u01b0\u1ee3c, ch\u00fang ta s\u1ebd chuy\u1ec3n k\u1ebft qu\u1ea3 v\u1ec1 d\u1ea1ng Gi\u00e1 tr\u1ecb c\u1ea7n t\u00ecm l\u00e0 1 con s\u1ed1, c\u00e1c gi\u00e1 tr\u1ecb c\u00f2n l\u1ea1i l\u00e0 1 l\u1ed7i (v\u00ed d\u1ee5 l\u1ed7i chia cho 0). Khi\u00a0\u0111\u00f3 h\u00e0m s\u1ebd lu\u00f4n lu\u00f4n l\u1ea5y theo k\u1ebft qu\u1ea3 l\u00e0 gi\u00e1 tr\u1ecb c\u00f2n t\u1ed3n t\u1ea1i m\u00e0 kh\u00f4ng ph\u1ea3i l\u1ed7i.<\/em><\/p>\n<p>\u0110\u1ecdc th\u00eam v\u1ec1 h\u00e0m Lookup:<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/ham-lookup-va-cong-thuc-vi-du-trong-excel-2016-2013-2010-2007-2003.html\">H\u00e0m LOOKUP v\u00e0 c\u00f4ng th\u1ee9c v\u00ed d\u1ee5 trong Excel 2016 2013 2010 2007 2003<\/a><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Tham_chieu_nguoc_voi_ham_VLOOKUP\"><\/span>Tham chi\u1ebfu ng\u01b0\u1ee3c v\u1edbi h\u00e0m VLOOKUP<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Vlookup? V\u00e2ng, b\u1ea1n kh\u00f4ng nghe nh\u1ea7m\u00a0\u0111\u00e2u. Ch\u00fang ta c\u00f3 th\u1ec3 d\u00f9ng h\u00e0m VLOOKUP\u00a0\u0111\u1ec3 tham chi\u1ebfu t\u1eeb ph\u1ea3i qua tr\u00e1i.\u00a0\u0110\u1ec3 l\u00e0m\u00a0\u0111\u01b0\u1ee3c\u00a0\u0111i\u1ec1u n\u00e0y, ch\u00fang ta s\u1ebd k\u1ebft h\u1ee3p h\u00e0m VLOOKUP v\u1edbi h\u00e0m CHOOSE nh\u01b0 sau:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-23712\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/cach2-vlookup-tham-chieu-phai-qua-trai.png\" width=\"1169\" height=\"264\" title=\"cach2-vlookup-tham-chieu-phai-qua-trai\"><\/p>\n<p>B\u1ea3n ch\u1ea5t c\u1ee7a vi\u1ec7c l\u00e0m n\u00e0y kh\u00f4ng ph\u1ea3i thay\u00a0\u0111\u1ed5i nguy\u00ean l\u00fd ho\u1ea1t\u00a0\u0111\u1ed9ng c\u1ee7a h\u00e0m VLOOKUP, m\u00e0 s\u1eed d\u1ee5ng h\u00e0m CHOOSE\u00a0\u0111\u1ec3 \u201cXoay\u201d chi\u1ec1u c\u1ee7a b\u1ea3ng d\u1eef li\u1ec7u,\u00a0\u0111\u01b0a n\u00f3 v\u1ec1 d\u1ea1ng c\u1ed9t ch\u1ee9a gi\u00e1 tr\u1ecb t\u00ecm ki\u1ebfm n\u1eb1m\u00a0\u1edf v\u1ecb tr\u00ed\u00a0\u0111\u1ea7u ti\u00ean.<\/p>\n<p>Ta c\u00f3 tham s\u1ed1 Table\u00a0Array trong h\u00e0m VLOOKUP l\u00e0:<\/p>\n<p style=\"padding-left: 30px\">CHOOSE({1,2},$B$2:$B$9,$A$2:$A$9)<\/p>\n<p>Khi\u00a0\u0111\u00f3:<\/p>\n<ul>\n<li>C\u1ed9t th\u1ee9 1 l\u00e0 v\u00f9ng B2:B9<\/li>\n<li>C\u1ed9t th\u1ee9 2 l\u00e0 v\u00f9ng A2:A9<\/li>\n<\/ul>\n<p>Nh\u01b0 v\u1eady h\u00e0m Choose t\u1ea1o ra 1 b\u1ea3ng d\u1eef li\u1ec7u m\u1edbi g\u1ed3m 2 c\u1ed9t, trong\u00a0\u0111\u00f3 c\u1ed9t\u00a0\u0111\u1ea7u ti\u00ean l\u00e0 c\u1ed9t\u00a0\u0110\u1ecba ch\u1ec9, c\u1ed9t th\u1ee9 2 l\u00e0 c\u1ed9t Code.<\/p>\n<p>Ch\u00fang ta s\u1eed d\u1ee5ng h\u00e0m VLOOKUP\u00a0\u0111\u1ec3 tham chi\u1ebfu\u00a0\u0110\u1ecba ch\u1ec9, l\u1ea5y k\u1ebft qu\u1ea3 l\u00e0 Code t\u01b0\u01a1ng\u00a0\u1ee9ng.<\/p>\n<p>Xem th\u00eam:\u00a0<a href=\"http:\/\/blog.ezworkapp.com\/ham-choose-trong-excel.html\">H\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng h\u00e0m CHOOSE trong Excel<\/a><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Tham_chieu_nguoc_voi_ham_INDEXMATCH\"><\/span>Tham chi\u1ebfu ng\u01b0\u1ee3c v\u1edbi h\u00e0m INDEX+MATCH<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Index v\u00e0 Match l\u00e0 2 h\u00e0m tham chi\u1ebfu\u00a0\u0111\u01b0\u1ee3c k\u1ebft h\u1ee3p v\u1edbi nhau\u00a0\u0111\u1ec3 t\u1ea1o ra ph\u01b0\u01a1ng th\u1ee9c tham chi\u1ebfu d\u1ea1ng ma tr\u1eadn, l\u00e0 giao\u00a0\u0111i\u1ec3m gi\u1eefa d\u00f2ng v\u00e0 c\u1ed9t. Do\u00a0\u0111\u00f3 n\u00f3 kh\u00f4ng ph\u1ee5 thu\u1ed9c v\u00e0o ph\u01b0\u01a1ng, chi\u1ec1u tham chi\u1ebfu.<\/p>\n<p>H\u00e3y xem ch\u00fang ta\u00a0\u00e1p d\u1ee5ng Index Match trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y th\u1ebf n\u00e0o nh\u00e9:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-23713\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/cach3-index-match-tham-chieu-phai-qua-trai.png\" width=\"1167\" height=\"267\" title=\"cach3-index-match-tham-chieu-phai-qua-trai\"><\/p>\n<p>Trong h\u00e0m Match, ch\u00fang ta s\u1ebd d\u00f2 t\u00ecm v\u1ecb tr\u00ed c\u1ee7a gi\u00e1 tr\u1ecb trong\u00a0\u00f4 E1 trong v\u00f9ng B2:B9. K\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 l\u00e0 v\u1ecb tr\u00ed s\u1ed1 d\u00f2ng.<\/p>\n<p>K\u1ebft h\u1ee3p trong h\u00e0m Index, ch\u00fang ta c\u00f3 v\u00f9ng A2:A9 ch\u00ednh l\u00e0 c\u1ed9t c\u1ea7n t\u00ecm k\u1ebft qu\u1ea3.<\/p>\n<p>Giao\u00a0\u0111i\u1ec3m gi\u1eefa d\u00f2ng (t\u00ecm b\u1edfi h\u00e0m Match) v\u00e0 c\u1ed9t (quy\u00a0\u0111\u1ecbnh trong tham s\u1ed1\u00a0\u0111\u1ea7u ti\u00ean c\u1ee7a h\u00e0m index) ch\u00ednh l\u00e0 v\u1ecb tr\u00ed k\u1ebft qu\u1ea3 c\u1ea7n t\u00ecm.<\/p>\n<p>\u0110\u1ec3 hi\u1ec3u r\u00f5 h\u01a1n v\u1ec1 tham chi\u1ebfu b\u1edfi index match, c\u00e1c b\u1ea1n c\u00f3 th\u1ec3\u00a0\u0111\u1ecdc th\u00eam c\u00e1c b\u00e0i vi\u1ebft sau:<\/p>\n<p style=\"padding-left: 30px\"><a href=\"http:\/\/blog.ezworkapp.com\/vi-sao-dung-index-va-match-tot-hon-dung-vlookup-trong-excel.html\">V\u00ec sao d\u00f9ng INDEX v\u00e0 MATCH t\u1ed1t h\u01a1n d\u00f9ng VLOOKUP trong Excel<\/a><\/p>\n<p>Nh\u01b0 v\u1eady vi\u1ec7c tham chi\u1ebfu ng\u01b0\u1ee3c kh\u00f4ng kh\u00f3 nh\u01b0 ch\u00fang ta v\u1eabn ngh\u0129 ph\u1ea3i kh\u00f4ng n\u00e0o. B\u1ea1n c\u00f2n bi\u1ebft th\u00eam h\u00e0m n\u00e0o kh\u00e1c gi\u00fap tham chi\u1ebfu ng\u01b0\u1ee3c n\u1eefa kh\u00f4ng? H\u00e3y chia s\u1ebb c\u00f9ng v\u1edbi H\u1ecdc\u00a0Excel Online ngay nh\u00e9.<\/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-501.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":5719,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-5718","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\/5718","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=5718"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/5718\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/5719"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=5718"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=5718"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=5718"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}