{"id":9451,"date":"2025-01-02T06:43:50","date_gmt":"2025-01-02T06:43:50","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/02\/huong-dan-cach-lap-mau-bien-ban-doi-chieu-cong-no-tu-dong-tren-excel\/"},"modified":"2025-01-02T06:43:50","modified_gmt":"2025-01-02T06:43:50","slug":"huong-dan-cach-lap-mau-bien-ban-doi-chieu-cong-no-tu-dong-tren-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/02\/huong-dan-cach-lap-mau-bien-ban-doi-chieu-cong-no-tu-dong-tren-excel\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn c\u00e1ch l\u1eadp m\u1eabu bi\u00ean b\u1ea3n \u0111\u1ed1i chi\u1ebfu c\u00f4ng n\u1ee3 t\u1ef1 \u0111\u1ed9ng tr\u00ean Excel"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p>L\u1eadp bi\u00ean b\u1ea3n\u00a0\u0111\u1ed1i chi\u1ebfu c\u00f4ng n\u1ee3 l\u00e0 m\u1ed9t trong nh\u1eefng c\u00f4ng vi\u1ec7c\u00a0quan tr\u1ecdng c\u1ee7a k\u1ebf to\u00e1n. Ngo\u00e0i vi\u1ec7c ch\u1ed1t s\u1ed1 ti\u1ec1n c\u00f4ng n\u1ee3\u00a0\u0111\u1ec3 th\u1ef1c hi\u1ec7n vi\u1ec7c thu n\u1ee3, thanh to\u00e1n n\u1ee3, n\u00f3 c\u00f2n c\u00f3 t\u00e1c d\u1ee5ng ch\u1ed1t s\u1ed1 li\u1ec7u k\u1ebf to\u00e1n cu\u1ed1i n\u0103m, cu\u1ed1i qu\u00fd\u2026 gi\u00fap ban gi\u00e1m\u00a0\u0111\u1ed1c v\u00e0 b\u1ed9 ph\u1eadn k\u1ebf to\u00e1n qu\u1ea3n l\u00fd c\u00f4ng vi\u1ec7c m\u1ed9t c\u00e1ch hi\u1ec7u qu\u1ea3. Nh\u01b0ng b\u1ea1n c\u00f3 th\u1ec3 s\u1ebd m\u1ea5t nhi\u1ec1u th\u1eddi gian khi ph\u1ea3i\u00a0\u0111\u1ed1i chi\u1ebfu c\u00f4ng n\u1ee3 cho nhi\u1ec1u c\u00f4ng ty. H\u00e3y t\u00ecm hi\u1ec3u c\u00e1ch\u00a0l\u1eadp m\u1eabu bi\u00ean b\u1ea3n \u0111\u1ed1i chi\u1ebfu c\u00f4ng n\u1ee3 tr\u00ean Excel\u00a0\u0111\u1ec3 l\u00e0m vi\u1ec7c n\u00e0y\u00a0\u0111\u01a1n gi\u1ea3n h\u01a1n 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-677635a5bf3cb\" 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-lap-mau-bien-ban-doi-chieu-cong-no-tu-dong-tren-excel.html#Nguyen_tac_cua_bien_ban_doi_chieu_cong_no\" title=\"Nguy\u00ean t\u1eafc c\u1ee7a bi\u00ean b\u1ea3n\u00a0\u0111\u1ed1i chi\u1ebfu c\u00f4ng n\u1ee3\">Nguy\u00ean t\u1eafc c\u1ee7a bi\u00ean b\u1ea3n\u00a0\u0111\u1ed1i chi\u1ebfu c\u00f4ng n\u1ee3<\/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-lap-mau-bien-ban-doi-chieu-cong-no-tu-dong-tren-excel.html#Nhung_noi_dung_can_co_trong_file_Excel_quan_ly_cong_no\" title=\"Nh\u1eefng n\u1ed9i dung c\u1ea7n c\u00f3 trong file\u00a0Excel qu\u1ea3n l\u00fd c\u00f4ng n\u1ee3\">Nh\u1eefng n\u1ed9i dung c\u1ea7n c\u00f3 trong file\u00a0Excel qu\u1ea3n l\u00fd c\u00f4ng n\u1ee3<\/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-cach-lap-mau-bien-ban-doi-chieu-cong-no-tu-dong-tren-excel.html#Mau_bien_ban_doi_chieu_cong_no_tu_dong_tren_Excel\" title=\"M\u1eabu bi\u00ean b\u1ea3n\u00a0\u0111\u1ed1i chi\u1ebfu c\u00f4ng n\u1ee3 t\u1ef1 \u0111\u1ed9ng tr\u00ean\u00a0Excel\">M\u1eabu bi\u00ean b\u1ea3n\u00a0\u0111\u1ed1i chi\u1ebfu c\u00f4ng n\u1ee3 t\u1ef1 \u0111\u1ed9ng tr\u00ean\u00a0Excel<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2><span class=\"ez-toc-section\" id=\"Nguyen_tac_cua_bien_ban_doi_chieu_cong_no\"><\/span>Nguy\u00ean t\u1eafc c\u1ee7a bi\u00ean b\u1ea3n\u00a0\u0111\u1ed1i chi\u1ebfu c\u00f4ng n\u1ee3<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Bi\u00ean b\u1ea3n n\u00e0y g\u1ed3m 3 ph\u1ea7n ch\u00ednh:<\/p>\n<ul>\n<li>B\u00ean g\u1eedi b\u1ea3n\u00a0\u0111\u1ed1i chi\u1ebfu (th\u01b0\u1eddng l\u00e0 b\u00ean thu n\u1ee3)<\/li>\n<li>B\u00ean nh\u1eadn b\u1ea3n\u00a0\u0111\u1ed1i chi\u1ebfu (th\u01b0\u1eddng l\u00e0 b\u00ean ph\u1ea3i tr\u1ea3 n\u1ee3)<\/li>\n<li>C\u00e1c th\u00f4ng tin li\u00ean quan: Th\u1eddi gian\u00a0\u0111\u1ed1i chi\u1ebfu, l\u1ecbch s\u1eed th\u00f4ng tin ph\u00e1t sinh v\u00e0 thanh to\u00e1n n\u1ee3, s\u1ed1 n\u1ee3 c\u00f2n l\u1ea1i c\u1ea7n thanh to\u00e1n\u2026<\/li>\n<\/ul>\n<p>V\u00ec v\u1eady\u00a0bi\u00ean b\u1ea3n\u00a0\u0111\u1ed1i chi\u1ebfu c\u00f4ng n\u1ee3 th\u01b0\u1eddng l\u1eadp ra\u00a0\u0111\u1ec3 thu h\u1ed3i n\u1ee3, ch\u1ed1t s\u1ed1 n\u1ee3 ph\u1ea3i thu.<\/p>\n<p>K\u1ebf to\u00e1n s\u1ebd nh\u1eadn c\u00e1c bi\u00ean b\u1ea3n\u00a0\u0111\u1ed1i chi\u1ebfu c\u00f4ng n\u1ee3 c\u1ee7a c\u00e1c\u00a0\u0111\u1ed1i t\u00e1c\u00a0\u0111\u1ec3 ch\u1ed1t s\u1ed1\u00a0n\u1ee3 ph\u1ea3i tr\u1ea3. Vi\u1ec7c n\u00e0y kh\u00f4ng c\u1ea7n l\u1eadp bi\u00ean b\u1ea3n n\u1eefa m\u00e0 ch\u1ec9 c\u1ea7n\u00a0\u0111\u1ed1i chi\u1ebfu s\u1ed1 n\u1ee3 m\u00e0 2 b\u00ean\u00a0\u0111ang theo d\u00f5i.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Nhung_noi_dung_can_co_trong_file_Excel_quan_ly_cong_no\"><\/span>Nh\u1eefng n\u1ed9i dung c\u1ea7n c\u00f3 trong file\u00a0Excel qu\u1ea3n l\u00fd c\u00f4ng n\u1ee3<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Nh\u01b0 nguy\u00ean t\u1eafc tr\u00ean, ch\u00fang ta th\u1ea5y:<\/p>\n<ul>\n<li>B\u00ean nh\u1eadn b\u1ea3n\u00a0\u0111\u1ed1i chi\u1ebfu: Ch\u00fang ta c\u1ea7n c\u00f3 1 danh s\u00e1ch\u00a0h\u1ee3p\u00a0\u0111\u1ed3ng c\u1ee7a t\u1eebng kh\u00e1ch. M\u1ed7i h\u1ee3p\u00a0\u0111\u1ed3ng s\u1ebd l\u00e0 1\u00a0\u0111\u1ed1i t\u01b0\u1ee3ng theo d\u00f5i c\u00f4ng n\u1ee3. M\u1ed9t kh\u00e1ch h\u00e0ng c\u00f3 th\u1ec3 c\u00f3 nhi\u1ec1u h\u1ee3p\u00a0\u0111\u1ed3ng kh\u00e1c nhau, c\u1ea7n theo d\u00f5i ri\u00eang. T\u1ed5ng c\u1ee7a c\u00e1c h\u1ee3p\u00a0\u0111\u1ed3ng\u00a0\u0111\u00f3 s\u1ebd l\u00e0 c\u00f4ng n\u1ee3 c\u1ea7n ch\u1ed1t (c\u00f3\u00a0\u00e1p d\u1ee5ng nguy\u00ean t\u1eafc b\u00f9 tr\u1eeb)<\/li>\n<li>Th\u00f4ng tin thanh to\u00e1n: Kh\u00f4ng ph\u1ea3i h\u1ee3p\u00a0\u0111\u1ed3ng n\u00e0o c\u0169ng\u00a0\u0111\u01b0\u1ee3c thanh to\u00e1n ngay ho\u1eb7c ch\u1ec9 thanh to\u00e1n duy nh\u1ea5t 1 l\u1ea7n. Do\u00a0\u0111\u00f3 c\u00e1c th\u00f4ng tin v\u1ec1 thanh to\u00e1n c\u1ee7a m\u1ed7i h\u1ee3p\u00a0\u0111\u1ed3ng c\u0169ng c\u1ea7n\u00a0\u0111\u01b0\u1ee3c theo d\u00f5i chi ti\u1ebft.<\/li>\n<li>M\u1eabu bi\u00ean b\u1ea3n\u00a0\u0111\u1ed1i chi\u1ebfu:\u00a0\u0110\u00e2y s\u1ebd l\u00e0 n\u01a1i t\u1ed5ng h\u1ee3p c\u00e1c th\u00f4ng tin c\u1ee7a\u00a0\u0111\u1ed1i t\u01b0\u1ee3ng c\u00f3 li\u00ean quan.<\/li>\n<\/ul>\n<p>Nh\u01b0 v\u1eady c\u1ea7n c\u00f3 t\u1ed1i thi\u1ec3u l\u00e0 3 sheet trong 1 file\u00a0excel.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Mau_bien_ban_doi_chieu_cong_no_tu_dong_tren_Excel\"><\/span>M\u1eabu bi\u00ean b\u1ea3n\u00a0\u0111\u1ed1i chi\u1ebfu c\u00f4ng n\u1ee3 t\u1ef1 \u0111\u1ed9ng tr\u00ean\u00a0Excel<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-24418\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/bien-ban-doi-chieu-cong-no.png\" width=\"800\" height=\"562\" title=\"bien-ban-doi-chieu-cong-no\"><\/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-55.gif\" title=\"ex101_92019-nho-55\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p>C\u00e1ch x\u00e2y d\u1ef1ng c\u00f4ng th\u1ee9c l\u1ea5y d\u1eef li\u1ec7u cho m\u1eabu Bi\u00ean b\u1ea3n\u00a0\u0111\u1ed1i chi\u1ebfu c\u00f4ng n\u1ee3 tr\u00ean\u00a0Excel:<\/p>\n<p>Khi ch\u1ecdn t\u00ean Kh\u00e1ch h\u00e0ng t\u1ea1i\u00a0\u00f4 H1 ta c\u00f3:<\/p>\n<p>1. L\u1ea5y th\u00f4ng tin c\u1ee7a b\u00ean mua h\u00e0ng c\u0103n c\u1ee9 theo kh\u00e1ch h\u00e0ng\u00a0\u0111\u01b0\u1ee3c ch\u1ecdn b\u1eb1ng h\u00e0m Index + Match<\/p>\n<p style=\"padding-left: 30px\">T\u00ean ng\u01b0\u1eddi \u0111\u1ea1i di\u1ec7n th\u1ee9 1 =INDEX(KhachHang!$D$3:$D$32,MATCH(BB_CN!$H$1,KhachHang!$A$3:$A$32,0))<\/p>\n<p style=\"padding-left: 30px\">Ch\u1ee9c v\u1ee5 ng\u01b0\u1eddi\u00a0\u0111\u1ea1i di\u1ec7n th\u1ee9 1\u00a0=INDEX(KhachHang!$E$3:$E$32,MATCH(BB_CN!$H$1,KhachHang!$A$3:$A$32,0))<\/p>\n<p>2. Trong b\u1ea3ng th\u00f4ng tin kh\u00e1ch h\u00e0ng, t\u00ednh m\u1ed9t s\u1ed1 ch\u1ec9 ti\u00eau:<\/p>\n<ul>\n<li>S\u1ed1\u00a0<strong>\u0110\u00e3 thanh to\u00e1n<\/strong>\u00a0\u0111\u01b0\u1ee3c t\u00ednh b\u1eb1ng h\u00e0m SUMIFS<\/li>\n<\/ul>\n<p style=\"padding-left: 60px\">=SUMIFS(ThanhToan!$C$3:$C$25,ThanhToan!$B$3:$B$25,I3,ThanhToan!$A$3:$A$25,\u201d&lt;=\u201d&amp;BB_CN!$H$2)<\/p>\n<ul>\n<li>S\u1ed1 <strong>C\u00f2n n\u1ee3<\/strong>\u00a0\u0111\u01b0\u1ee3c t\u00ednh b\u1eb1ng c\u00e1ch l\u1ea5y s\u1ed1 ti\u1ec1n H\u0110 \u2013 S\u1ed1\u00a0\u0111\u00e3 thanh to\u00e1n<\/li>\n<\/ul>\n<p style=\"padding-left: 60px\">=K3-L3<\/p>\n<ul>\n<li>S\u1ed1 th\u1ee9 t\u1ef1\u00a0\u0111\u1ec3 x\u00e1c\u00a0\u0111\u1ecbnh s\u1ed1 h\u1ee3p\u00a0\u0111\u1ed3ng ph\u00e1t sinh c\u1ee7a kh\u00e1ch h\u00e0ng:<\/li>\n<\/ul>\n<p style=\"padding-left: 60px\">=COUNTIF($A$3:A3,A3)<\/p>\n<p><strong>3. X\u00e1c\u00a0\u0111\u1ecbnh s\u1ed1 h\u1ee3p\u00a0\u0111\u1ed3ng<\/strong><\/p>\n<p>S\u1eed d\u1ee5ng tham chi\u1ebfu theo nhi\u1ec1u\u00a0\u0111i\u1ec1u ki\u1ec7n: k\u1ebft h\u1ee3p\u00a0\u0111i\u1ec1u ki\u1ec7n T\u00ean kh\u00e1ch h\u00e0ng v\u00e0 S\u1ed1 th\u1ee9 t\u1ef1 (STT)\u00a0\u0111\u1ec3 x\u00e1c\u00a0\u0111\u1ecbnh c\u00e1c h\u1ee3p\u00a0\u0111\u1ed3ng c\u00f3 li\u00ean quan c\u1ee7a kh\u00e1ch h\u00e0ng\u00a0\u0111\u00f3 b\u1eb1ng c\u00f4ng th\u1ee9c:<\/p>\n<p style=\"padding-left: 30px\">=INDEX(KhachHang!$I$3:$I$32,MATCH(BB_CN!$H$1&amp;G18:G22,KhachHang!$A$3:$A$32&amp;KhachHang!$H$3:$H$32,0))<\/p>\n<p style=\"padding-left: 30px\">K\u1ebft th\u00fac c\u00f4ng th\u1ee9c nh\u1ea5n ph\u00edm Ctrl + Shift + Enter<\/p>\n<p style=\"padding-left: 30px\">\u0110\u1ec3 tr\u00e1nh l\u1ed7i #N\/A c\u00f3 th\u1ec3 xu\u1ea5t hi\u1ec7n khi kh\u00f4ng t\u00ecm th\u1ea5y k\u1ebft qu\u1ea3\u00a0\u1edf c\u00e1c STT l\u1edbn, ch\u00fang ta c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng th\u00eam h\u00e0m b\u1eaby l\u1ed7i\u00a0<a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-cach-nhan-biet-loai-loi-va-cach-bay-loi-trong-excel.html\">IFERROR<\/a><\/p>\n<p><strong>4. C\u00e1c th\u00f4ng tin c\u00f2n l\u1ea1i c\u1ee7a h\u1ee3p\u00a0\u0111\u1ed3ng<\/strong><\/p>\n<p>C\u00e1c th\u00f4ng tin c\u00f2n l\u1ea1i s\u1eed d\u1ee5ng h\u00e0m Vlookup\u00a0\u0111\u1ec3 x\u00e1c\u00a0\u0111\u1ecbnh d\u1ef1a theo s\u1ed1 h\u1ee3p\u00a0\u0111\u1ed3ng\u00a0\u0111\u00e3 c\u00f3\u00a0\u1edf b\u01b0\u1edbc 3<\/p>\n<ul>\n<li>Ng\u00e0y k\u00fd =IF($A18=\u201d\u201d,\u201d\u201d,VLOOKUP($A18,KhachHang!$I$3:$M$32,2,0))<\/li>\n<li>S\u1ed1 ti\u1ec1n =IF($A18=\u201d\u201d,\u201d\u201d,VLOOKUP($A18,KhachHang!$I$3:$M$32,3,0))<\/li>\n<li>\u0110\u00e3 thanh to\u00e1n =IF($A18=\u201d\u201d,\u201d\u201d,VLOOKUP($A18,KhachHang!$I$3:$M$32,4,0))<\/li>\n<li>C\u00f2n n\u1ee3 =IF($A18=\u201d\u201d,\u201d\u201d,VLOOKUP($A18,KhachHang!$I$3:$M$32,5,0))<\/li>\n<\/ul>\n<p>Trong c\u00f4ng th\u1ee9c tr\u00ean, k\u1ebft h\u1ee3p th\u00eam b\u1eaby l\u1ed7i kh\u00f4ng c\u00f3 s\u1ed1 h\u1ee3p\u00a0\u0111\u1ed3ng (tr\u01b0\u1eddng h\u1ee3p \u00f4 s\u1ed1 h\u1ee3p\u00a0\u0111\u1ed3ng l\u00e0\u00a0\u00f4 tr\u1ed1ng) s\u1ebd tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb r\u1ed7ng tr\u01b0\u1edbc, sau\u00a0\u0111\u00f3 m\u1edbi d\u00f9ng h\u00e0m VLOOKUP<\/p>\n<p><strong>5.\u00a0\u0110\u1ecdc s\u1ed1 ti\u1ec1n b\u1eb1ng ch\u1eef<\/strong>: Tham kh\u1ea3o t\u1ea1i b\u00e0i vi\u1ebft:\u00a0<a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-cach-su-dung-cong-thuc-viet-so-tien-bang-chu-trong-ke-toan.html\">H\u01b0\u1edbng d\u1eabn c\u00e1ch s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c vi\u1ebft s\u1ed1 ti\u1ec1n b\u1eb1ng ch\u1eef trong k\u1ebf to\u00e1n<\/a><\/p>\n<p>Nh\u01b0 v\u1eady ch\u1ec9 v\u1edbi m\u1ed9t s\u1ed1 h\u00e0m\u00a0Excel c\u01a1 b\u1ea3n, ch\u00fang ta\u00a0\u0111\u00e3 c\u00f3 th\u1ec3 t\u1ea1o ra m\u1eabu bi\u00ean b\u1ea3n\u00a0\u0111\u1ed1i chi\u1ebfu c\u00f4ng n\u1ee3 t\u1ef1\u00a0\u0111\u1ed9ng thay\u00a0\u0111\u1ed5i th\u00f4ng tin d\u1ef1a theo t\u00ean kh\u00e1ch h\u00e0ng\u00a0\u0111\u01b0\u1ee3c ch\u1ecdn r\u1ed3i.<\/p>\n<p>C\u00e1c b\u1ea1n c\u00f3 th\u1ec3 t\u1ea3i file m\u1eabu t\u1ea1i\u00a0\u0111\u1ecba ch\u1ec9:\u00a0<a href=\"http:\/\/bit.ly\/2Qt0l1d\">http:\/\/bit.ly\/2Qt0l1d<\/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-55.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":9452,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-9451","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\/9451","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=9451"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/9451\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/9452"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=9451"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=9451"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=9451"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}