{"id":9751,"date":"2025-01-02T19:48:26","date_gmt":"2025-01-02T19:48:26","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/02\/huong-dan-cach-viet-cong-thuc-chuyen-du-lieu-tu-chieu-doc-sang-chieu-ngang\/"},"modified":"2025-01-02T19:48:26","modified_gmt":"2025-01-02T19:48:26","slug":"huong-dan-cach-viet-cong-thuc-chuyen-du-lieu-tu-chieu-doc-sang-chieu-ngang","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/02\/huong-dan-cach-viet-cong-thuc-chuyen-du-lieu-tu-chieu-doc-sang-chieu-ngang\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn c\u00e1ch vi\u1ebft c\u00f4ng th\u1ee9c chuy\u1ec3n d\u1eef li\u1ec7u t\u1eeb chi\u1ec1u d\u1ecdc sang chi\u1ec1u ngang"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p>Chuy\u1ec3n d\u1eef li\u1ec7u\u00a0\u0111ang\u00a0\u0111\u01b0\u1ee3c t\u1ed5 ch\u1ee9c theo chi\u1ec1u d\u1ecdc sang chi\u1ec1u ngang (hay ng\u01b0\u1ee3c l\u1ea1i)\u00a0\u0111\u01b0\u1ee3c g\u1ecdi v\u1edbi thu\u1eadt ng\u1eef chung l\u00e0 \u201cTRANSPOSE\u201d. Tuy nhi\u00ean vi\u1ec7c transpose l\u1ea1i\u00a0\u0111\u01b0\u1ee3c th\u1ef1c hi\u1ec7n v\u1edbi kh\u00e1 nhi\u1ec1u thao t\u00e1c m\u1edbi ho\u00e0n th\u00e0nh\u00a0\u0111\u01b0\u1ee3c. V\u1eady b\u1ea1n c\u00f3 mu\u1ed1n bi\u1ebft c\u00e1ch vi\u1ebft c\u00f4ng th\u1ee9c\u00a0\u0111\u1ec3 chuy\u1ec3n d\u1eef li\u1ec7u t\u1eeb chi\u1ec1u d\u1ecdc sang chi\u1ec1u ngang kh\u00f4ng? H\u00e3y c\u00f9ng H\u1ecdc\u00a0Excel Online t\u00ecm hi\u1ec3u ngay n\u00e0o.<\/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-6776ed844961f\" 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-viet-cong-thuc-chuyen-du-lieu-tu-chieu-doc-sang-chieu-ngang.html#Cong_thuc_chuyen_du_lieu_tu_chieu_doc_sang_chieu_ngang\" title=\"C\u00f4ng th\u1ee9c chuy\u1ec3n d\u1eef li\u1ec7u t\u1eeb chi\u1ec1u d\u1ecdc sang chi\u1ec1u ngang\">C\u00f4ng th\u1ee9c chuy\u1ec3n d\u1eef li\u1ec7u t\u1eeb chi\u1ec1u d\u1ecdc sang chi\u1ec1u ngang<\/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-2\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-cach-viet-cong-thuc-chuyen-du-lieu-tu-chieu-doc-sang-chieu-ngang.html#Cac_ham_va_ky_thuat_can_su_dung\" title=\"C\u00e1c h\u00e0m v\u00e0 k\u1ef9 thu\u1eadt c\u1ea7n s\u1eed d\u1ee5ng\">C\u00e1c h\u00e0m v\u00e0 k\u1ef9 thu\u1eadt c\u1ea7n s\u1eed d\u1ee5ng<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-cach-viet-cong-thuc-chuyen-du-lieu-tu-chieu-doc-sang-chieu-ngang.html#Xac_dinh_trinh_tu_thuc_hien\" title=\"X\u00e1c\u00a0\u0111\u1ecbnh tr\u00ecnh t\u1ef1 th\u1ef1c hi\u1ec7n\">X\u00e1c\u00a0\u0111\u1ecbnh tr\u00ecnh t\u1ef1 th\u1ef1c hi\u1ec7n<\/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-viet-cong-thuc-chuyen-du-lieu-tu-chieu-doc-sang-chieu-ngang.html#Excel_365\" title=\"Excel 365\">Excel 365<\/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-viet-cong-thuc-chuyen-du-lieu-tu-chieu-doc-sang-chieu-ngang.html#Nang_cao\" title=\"N\u00e2ng cao\">N\u00e2ng cao<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2><span class=\"ez-toc-section\" id=\"Cong_thuc_chuyen_du_lieu_tu_chieu_doc_sang_chieu_ngang\"><\/span>C\u00f4ng th\u1ee9c chuy\u1ec3n d\u1eef li\u1ec7u t\u1eeb chi\u1ec1u d\u1ecdc sang chi\u1ec1u ngang<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>V\u00ed d\u1ee5 ch\u00fang ta c\u00f3 b\u1ea3ng d\u1eef li\u1ec7u nh\u01b0 sau:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-23570\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/ket-qua-transpose-data-formulas.png\" width=\"1236\" height=\"213\" title=\"ket-qua-transpose-data-formulas\"><\/p>\n<p>T\u1eeb b\u1ea3ng d\u1eef li\u1ec7u\u00a0\u0111\u01b0\u1ee3c t\u1ed5 ch\u1ee9c theo chi\u1ec1u d\u1ecdc A1:C8, ch\u00fang ta mu\u1ed1n chuy\u1ec3n sang chi\u1ec1u ngang nh\u01b0 b\u1ea3ng E1:L3. C\u00f4ng th\u1ee9c n\u00e0o gi\u00fap l\u00e0m\u00a0\u0111\u01b0\u1ee3c vi\u1ec7c n\u00e0y?<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Cac_ham_va_ky_thuat_can_su_dung\"><\/span>C\u00e1c h\u00e0m v\u00e0 k\u1ef9 thu\u1eadt c\u1ea7n s\u1eed d\u1ee5ng<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>C\u00f3 nhi\u1ec1u c\u00e1ch\u00a0\u0111\u1ec3 l\u00e0m vi\u1ec7c n\u00e0y, nh\u01b0ng trong b\u00e0i n\u00e0y ch\u00fang ta s\u1ebd d\u00f9ng nh\u1eefng h\u00e0m kh\u00e1 c\u01a1 b\u1ea3n nh\u01b0 sau:<\/p>\n<ul>\n<li><a href=\"http:\/\/blog.ezworkapp.com\/cach-su-dung-ham-indirect-trong-excel-cong-thuc-va-vi-du-minh-hoa.html\">H\u00e0m Indirect<\/a>: l\u1ea5y gi\u00e1 tr\u1ecb trong 1\u00a0\u00f4 d\u1ef1a v\u00e0o tham chi\u1ebfu t\u1edbi\u00a0\u00f4\u00a0\u0111\u00f3<\/li>\n<li><a href=\"http:\/\/blog.ezworkapp.com\/cach-lay-dia-chi-cua-o-tinh-trong-excel.html\">H\u00e0m Address<\/a>: l\u1ea5y\u00a0\u0111\u1ecba ch\u1ec9 c\u1ee7a 1\u00a0\u00f4 d\u1ef1a v\u00e0o s\u1ed1 d\u00f2ng, s\u1ed1 c\u1ed9t<\/li>\n<li>H\u00e0m Row: x\u00e1c\u00a0\u0111\u1ecbnh s\u1ed1 d\u00f2ng<\/li>\n<li>H\u00e0m Column: x\u00e1c\u00a0\u0111\u1ecbnh s\u1ed1 c\u1ed9t<\/li>\n<\/ul>\n<p>K\u1ef9 thu\u1eadt c\u1ea7n s\u1eed d\u1ee5ng ch\u1ee7 y\u1ebfu l\u00e0 FillRight, hay c\u00f2n g\u1ecdi l\u00e0 sao ch\u00e9p c\u00f4ng th\u1ee9c v\u1ec1 ph\u00eda b\u00ean ph\u1ea3i (ph\u00edm t\u1eaft l\u00e0 Ctrl + D)<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Xac_dinh_trinh_tu_thuc_hien\"><\/span>X\u00e1c\u00a0\u0111\u1ecbnh tr\u00ecnh t\u1ef1 th\u1ef1c hi\u1ec7n<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>H\u00e3y l\u1ea5y v\u00ed d\u1ee5\u00a0\u0111\u1ea7u ti\u00ean l\u00e0 chuy\u1ec3n n\u1ed9i dung c\u1ed9t H\u1ecd t\u00ean sang chi\u1ec1u ngang. V\u1ecb tr\u00ed\u00a0\u0111\u1eb7t c\u00f4ng th\u1ee9c l\u00e0\u00a0\u00f4 F1, v\u1ecb tr\u00ed tham chi\u1ebfu b\u1eaft\u00a0\u0111\u1ea7u v\u1edbi\u00a0\u00f4 A2.<\/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\/2025\/01\/ex101_92019-nho-86.gif\" title=\"ex101_92019-nho-86\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p>Khi\u00a0\u0111\u00e3 c\u00f3 c\u00f4ng th\u1ee9c t\u1ea1i\u00a0\u00f4 F1, ch\u00fang ta fillright c\u00f4ng th\u1ee9c\u00a0\u0111\u00f3 sang ph\u00eda tay ph\u1ea3i. V\u1edbi m\u1ed7i\u00a0\u00f4 ti\u1ebfp theo tr\u00ean c\u00f9ng d\u00f2ng 1 s\u1ebd l\u1ea5y t\u01b0\u01a1ng\u00a0\u1ee9ng gi\u00e1 tr\u1ecb c\u1ee7a t\u1ea1i\u00a0\u00f4 ti\u1ebfp theo tr\u00ean d\u00f2ng A. Hi\u1ec3u ng\u1eafn g\u1ecdn l\u00e0 \u201c<strong>C\u00f4ng th\u1ee9c fillright t\u1ea1i d\u00f2ng 1 th\u00ec k\u1ebft qu\u1ea3 s\u1ebd filldown t\u1ea1i c\u1ed9t A<\/strong>\u201c.<\/p>\n<p><strong>B\u01b0\u1edbc 1: L\u1ea5y k\u1ebft qu\u1ea3 t\u1ea1i\u00a0\u00f4 A2 v\u1edbi h\u00e0m Indirect+Address<\/strong><\/p>\n<p>N\u1ebfu t\u1ea1i\u00a0\u00f4 F1 ch\u00fang ta nh\u1eadp c\u00f4ng th\u1ee9c =INDIRECT(ADDRESS(2,1)) th\u00ec k\u1ebft qu\u1ea3 thu\u00a0\u0111\u01b0\u1ee3c ch\u00ednh l\u00e0 gi\u00e1 tr\u1ecb t\u1ea1i\u00a0\u00f4 A2<\/p>\n<p>Tuy nhi\u00ean\u00a0\u1edf\u00a0\u0111\u00e2y ch\u00fang ta c\u1ea7n sao ch\u00e9p c\u00f4ng th\u1ee9c t\u1ea1i F1 sang b\u00ean ph\u1ea3i. Khi sao ch\u00e9p th\u00ec l\u1ea1i y\u00eau c\u1ea7u: Ch\u1ec9 thay\u00a0\u0111\u1ed5i v\u1ec1 gi\u00e1 tr\u1ecb D\u00f2ng trong h\u00e0m ADDRESS, c\u00f2n c\u1ed9t th\u00ec kh\u00f4ng.<\/p>\n<p>\u0110\u1ec3 thay\u00a0\u0111\u1ed5i gi\u00e1 tr\u1ecb d\u00f2ng (t\u1ea1i F1 tham chi\u1ebfu d\u00f2ng 2, G1 tham chi\u1ebfu d\u00f2ng 3\u2026) th\u00ec ch\u00fang ta s\u1ebd b\u1eaft \u0111\u1ea7u t\u1eeb d\u00f2ng 2,\u00a0khi fillright t\u1edbi m\u1ed7i 1\u00a0\u00f4 s\u1ebd c\u1ed9ng th\u00eam 1\u00a0\u0111\u01a1n v\u1ecb v\u00e0o s\u1ed1 d\u00f2ng.<\/p>\n<p>C\u1ee5 th\u1ec3:<br \/>\nF1: tham chi\u1ebfu t\u1edbi \u00f4 A2 =ADDRESS(2<strong>+0<\/strong>,1)<\/p>\n<p>G1: tham chi\u1ebfu t\u1edbi \u00f4 A3 =ADDRESS(2<strong>+1<\/strong>,1)<\/p>\n<p>H1:\u00a0tham chi\u1ebfu t\u1edbi\u00a0\u00f4 A4 =ADDRESS(2<strong>+2<\/strong>,1)<\/p>\n<p>\u2026<\/p>\n<p>Nh\u01b0 v\u1eady\u00a0\u0111\u1ec3 c\u00f3 th\u1ec3 x\u00e1c\u00a0\u0111\u1ecbnh\u00a0c\u00e1c s\u1ed1 0, 1, 2\u2026\u00a0\u0111\u01b0\u1ee3c c\u1ed9ng th\u00eam khi fillright ch\u00fang ta l\u00e0m nh\u01b0 sau:<\/p>\n<p>0 = s\u1ed1 c\u1ed9t c\u1ee7a c\u1ed9t F \u2013 s\u1ed1 c\u1ed9t c\u1ee7a c\u1ed9t F = COLUMN(F1)-COLUMN($F$1)<\/p>\n<p>1\u00a0= s\u1ed1 c\u1ed9t c\u1ee7a c\u1ed9t\u00a0G \u2013 s\u1ed1 c\u1ed9t c\u1ee7a c\u1ed9t F\u00a0= COLUMN(G1)-COLUMN($F$1)<\/p>\n<p>2\u00a0= s\u1ed1 c\u1ed9t c\u1ee7a c\u1ed9t\u00a0H \u2013 s\u1ed1 c\u1ed9t c\u1ee7a c\u1ed9t F\u00a0= COLUMN(H1)-COLUMN($F$1)<\/p>\n<p>\u2026<\/p>\n<p>Gh\u00e9p l\u1ea1i v\u00e0o c\u00f4ng th\u1ee9c t\u1ea1i\u00a0\u00f4 F1 ta c\u00f3:<\/p>\n<p style=\"padding-left: 30px\">=INDIRECT(ADDRESS(2+COLUMN(F1)-COLUMN($F$1),1))<\/p>\n<p>H\u00e3y xem k\u1ebft qu\u1ea3 n\u00e0o:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-23598\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/dung-ham-indirect-address-transpose-ho-ten.png\" width=\"1236\" height=\"256\" title=\"dung-ham-indirect-address-transpose-ho-ten\"><\/p>\n<p>T\u01b0\u01a1ng t\u1ef1 nh\u01b0 v\u1eady, mu\u1ed1n tham chi\u1ebfu c\u00e1c n\u1ed9i dung v\u1ec1 B\u1ed9 ph\u1eadn, N\u0103m sinh th\u00ec ch\u00fang ta ch\u1ec9 c\u1ea7n thay\u00a0\u0111\u1ed5i v\u1ecb tr\u00ed c\u1ed9t c\u1ea7n tham chi\u1ebfu.<\/p>\n<ul>\n<li>F2=INDIRECT(ADDRESS(2+COLUMN(F1)-COLUMN($F$1),<strong>2<\/strong>))\u00a0 \u00a0tham chi\u1ebfu c\u1ed9t s\u1ed1 2 l\u00e0 c\u1ed9t B<\/li>\n<li>F3=INDIRECT(ADDRESS(2+COLUMN(F1)-COLUMN($F$1),<strong>3<\/strong>))\u00a0 \u00a0tham chi\u1ebfu c\u1ed9t s\u1ed1\u00a03 l\u00e0 c\u1ed9t\u00a0C<\/li>\n<\/ul>\n<p>Nh\u01b0 v\u1eady ch\u1ec9 c\u1ea7n l\u00e0m t\u1ed1t 1 c\u00f4ng th\u1ee9c, ch\u00fang ta d\u1ec5 d\u00e0ng t\u00f9y bi\u1ebfn sang c\u00e1c tham chi\u1ebfu kh\u00e1c. B\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m INDIRECT k\u1ebft h\u1ee3p h\u00e0m ADDRESS, ch\u00fang ta\u00a0\u0111\u00e3 c\u00f3 th\u1ec3 chuy\u1ec3n b\u1ea5t k\u1ef3\u00a0ki\u1ec3u s\u1eafp x\u1ebfp d\u1eef li\u1ec7u t\u1eeb chi\u1ec1u d\u1ecdc sang chi\u1ec1u ngang\u00a0\u0111\u01b0\u1ee3c r\u1ed3i.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Excel_365\"><\/span>Excel 365<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>N\u1ebfu b\u1ea1n s\u1eed d\u1ee5ng Office 365 ho\u1eb7c Excel 365, th\u00ec c\u00f4ng vi\u1ec7c c\u1ee7a b\u1ea1n s\u1ebd \u0111\u01a1n gi\u1ea3n \u0111i r\u1ea5t nhi\u1ec1u b\u1edfi v\u00ec trong phi\u00ean b\u1ea3n Excel n\u00e0y, <a href=\"http:\/\/blog.ezworkapp.com\/ham-mang-dong-trong-excel-dynamic-array-formulas-phan-1-ham-co-kha-nang-mo-rong-vung-du-lieu.html\" target=\"_blank\" rel=\"noopener noreferrer\">h\u00e0m m\u1ea3ng \u0111\u1ed9ng<\/a> \u0111\u01b0\u1ee3c h\u1ed7 tr\u1ee3, c\u00f3 ngh\u0129a l\u00e0, c\u00f4ng th\u1ee9c b\u1ea1n nh\u1eadp v\u00e0o 1 \u00f4 s\u1ebd c\u00f3 kh\u1ea3 n\u0103ng \u0111i\u1ec1n k\u1ebft qu\u1ea3 sang nhi\u1ec1u \u00f4 l\u00e2n c\u1eadn kh\u00e1c nh\u01b0 trong h\u00ecnh d\u01b0\u1edbi \u0111\u00e2y<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2018\/11\/ham-transpose-trong-excel-365.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-23638\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/ham-transpose-trong-excel-365.png\" alt=\"ham-transpose-trong-excel-365\" width=\"850\" height=\"293\" title=\"ham-transpose-trong-excel-365\"><\/a><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Nang_cao\"><\/span>N\u00e2ng cao<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>B\u1ea1n s\u1ebd thay\u00a0\u0111\u1ed5i c\u00f4ng th\u1ee9c n\u00e0y nh\u01b0 th\u1ebf n\u00e0o\u00a0\u0111\u1ec3 chuy\u1ec3n d\u1eef li\u1ec7u t\u1eeb chi\u1ec1u ngang sang chi\u1ec1u d\u1ecdc?<\/p>\n<p>H\u00e3y th\u1eed l\u00e0m xem sao v\u00e0 comment k\u1ebft qu\u1ea3 nh\u00e9. G\u1ee3i\u00a0\u00fd l\u00e0 thao t\u00e1c s\u1eed d\u1ee5ng l\u00e0 FillDown, do\u00a0\u0111\u00f3 m\u1ed7i khi filldown th\u00ec tham chi\u1ebfu s\u1ebd t\u0103ng th\u00eam 1 c\u1ed9t.<\/p>\n<p>Ngo\u00e0i ra c\u00e1c b\u1ea1n c\u00f3 th\u1ec3 tham kh\u1ea3o th\u00eam m\u1ed9t s\u1ed1 b\u00e0i vi\u1ebft c\u00f9ng ch\u1ee7\u00a0\u0111\u1ec1:<\/p>\n<p style=\"padding-left: 30px\"><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-cac-ky-thuat-sao-chep-cong-thuc-theo-y-muon-trong-excel.html\">H\u01b0\u1edbng d\u1eabn c\u00e1c k\u1ef9 thu\u1eadt sao ch\u00e9p c\u00f4ng th\u1ee9c theo \u00fd mu\u1ed1n trong Excel<\/a><\/p>\n<p style=\"padding-left: 30px\"><a href=\"http:\/\/blog.ezworkapp.com\/lam-nao-de-chuyen-du-lieu-trong-excel-chuyen-doi-hang-sang-cot-va-nguoc-lai.html\">L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 chuy\u1ec3n d\u1eef li\u1ec7u trong Excel, chuy\u1ec3n \u0111\u1ed5i h\u00e0ng sang c\u1ed9t v\u00e0 ng\u01b0\u1ee3c l\u1ea1i<\/a><\/p>\n<p style=\"padding-left: 30px\"><a href=\"http:\/\/blog.ezworkapp.com\/cach-su-dung-ham-indirect-trong-excel-cong-thuc-va-vi-du-minh-hoa.html\">C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m INDIRECT trong Excel, c\u00f4ng th\u1ee9c v\u00e0 v\u00ed d\u1ee5 minh ho\u1ea1<\/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\/2025\/01\/ex101_92019-nho-86.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":9752,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-9751","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\/9751","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=9751"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/9751\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/9752"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=9751"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=9751"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=9751"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}