{"id":4438,"date":"2024-12-05T09:39:49","date_gmt":"2024-12-05T09:39:49","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/05\/huong-dan-cach-kiem-tra-hoa-don-co-so-lon-hon-nhung-su-dung-truoc-voi-ham-countifs\/"},"modified":"2024-12-05T09:39:49","modified_gmt":"2024-12-05T09:39:49","slug":"huong-dan-cach-kiem-tra-hoa-don-co-so-lon-hon-nhung-su-dung-truoc-voi-ham-countifs","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/05\/huong-dan-cach-kiem-tra-hoa-don-co-so-lon-hon-nhung-su-dung-truoc-voi-ham-countifs\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn c\u00e1ch ki\u1ec3m tra h\u00f3a \u0111\u01a1n c\u00f3 s\u1ed1 l\u1edbn h\u01a1n nh\u01b0ng s\u1eed d\u1ee5ng tr\u01b0\u1edbc v\u1edbi h\u00e0m COUNTIFS"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p>Khi qu\u1ea3n l\u00fd h\u00f3a\u00a0\u0111\u01a1n, c\u00f3 m\u1ed9t nguy\u00ean t\u1eafc l\u00e0 ph\u1ea3i s\u1eed d\u1ee5ng h\u00f3a\u00a0\u0111\u01a1n theo tu\u1ea7n t\u1ef1 S\u1ed1 nh\u1ecf d\u00f9ng tr\u01b0\u1edbc, kh\u00f4ng\u00a0\u0111\u01b0\u1ee3c nh\u1ea3y c\u00e1ch. Tuy nhi\u00ean trong th\u1ef1c t\u1ebf vi\u1ec7c n\u00e0y v\u1eabn c\u00f3 th\u1ec3 x\u1ea3y ra. V\u1eady l\u00e0m th\u1ebf n\u00e0o\u00a0\u0111\u1ec3 ch\u00fang ta c\u00f3 th\u1ec3 ki\u1ec3m tra\u00a0\u0111\u01b0\u1ee3c h\u00f3a\u00a0\u0111\u01a1n n\u00e0o c\u00f3 s\u1ed1 l\u1edbn h\u01a1n nh\u01b0ng l\u1ea1i s\u1eed d\u1ee5ng tr\u01b0\u1edbc? H\u00e3y c\u00f9ng <a href=\"http:\/\/blog.ezworkapp.com\/\"><strong>H\u1ecdc\u00a0Excel Online<\/strong><\/a> t\u00ecm hi\u1ec3u c\u00e1ch l\u00e0m 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-675174e48cc4a\" 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-kiem-tra-hoa-don-co-so-lon-hon-nhung-su-dung-truoc-voi-ham-countifs.html#Cach_kiem_tra_hoa_don_co_so_lon_hon_nhung_su_dung_truoc_voi_ham_COUNTIFS\" title=\"C\u00e1ch ki\u1ec3m tra h\u00f3a \u0111\u01a1n c\u00f3 s\u1ed1 l\u1edbn h\u01a1n nh\u01b0ng s\u1eed d\u1ee5ng tr\u01b0\u1edbc v\u1edbi h\u00e0m COUNTIFS\">C\u00e1ch ki\u1ec3m tra h\u00f3a \u0111\u01a1n c\u00f3 s\u1ed1 l\u1edbn h\u01a1n nh\u01b0ng s\u1eed d\u1ee5ng tr\u01b0\u1edbc v\u1edbi h\u00e0m COUNTIFS<\/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-kiem-tra-hoa-don-co-so-lon-hon-nhung-su-dung-truoc-voi-ham-countifs.html#Cach_lam_nhu_sau\" title=\"C\u00e1ch l\u00e0m nh\u01b0 sau:\">C\u00e1ch l\u00e0m nh\u01b0 sau:<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2><span class=\"ez-toc-section\" id=\"Cach_kiem_tra_hoa_don_co_so_lon_hon_nhung_su_dung_truoc_voi_ham_COUNTIFS\"><\/span>C\u00e1ch ki\u1ec3m tra h\u00f3a \u0111\u01a1n c\u00f3 s\u1ed1 l\u1edbn h\u01a1n nh\u01b0ng s\u1eed d\u1ee5ng tr\u01b0\u1edbc v\u1edbi h\u00e0m COUNTIFS<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Gi\u1ea3 s\u1eed ch\u00fang ta c\u00f3 danh s\u00e1ch c\u00e1c h\u00f3a\u00a0\u0111\u01a1n\u00a0\u0111\u00e3 s\u1eed d\u1ee5ng t\u1ea1i file sau: (link t\u1ea3i file:<a href=\"http:\/\/bit.ly\/2wQONsE\">\u00a0http:\/\/bit.ly\/2wQONsE<\/a>)<\/p>\n<p>Trong b\u1ea3ng ta c\u00f3 4 c\u1ed9t:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-27924\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/de-bai-kiem-tra-hoa-don.png\" width=\"581\" height=\"530\" title=\"de-bai-kiem-tra-hoa-don\"><\/p>\n<p style=\"padding-left: 30px\"><strong>C\u1ed9t S\u1ed1 quy\u1ec3n<\/strong>: L\u00e0 quy\u1ec3n h\u00f3a\u00a0\u0111\u01a1n.\u00a01 quy\u1ec3n s\u1ebd c\u00f3 nhi\u1ec1u t\u1edd\u00a0h\u00f3a\u00a0\u0111\u01a1n<\/p>\n<p style=\"padding-left: 30px\"><strong>S\u1ed1 h\u00f3a\u00a0\u0111\u01a1n<\/strong>: M\u1ed7i t\u1edd h\u00f3a\u00a0\u0111\u01a1n c\u00f3 1 s\u1ed1, g\u1ed3m ph\u1ea7n k\u00fd hi\u1ec7u (AB\/2016, AB\/2017\u2026) v\u00e0 ph\u1ea7n s\u1ed1 (sau d\u1ea5u g\u1ea1ch ngang)<\/p>\n<p style=\"padding-left: 30px\"><strong>Ng\u00e0y s\u1eed d\u1ee5ng<\/strong>: L\u00e0 ng\u00e0y t\u1edd h\u00f3a\u00a0\u0111\u01a1n\u00a0\u0111\u00f3\u00a0\u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng<\/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-360.gif\" title=\"ex101_92019-nho-360\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p>Y\u00eau c\u1ea7u: Ph\u00e1t hi\u1ec7n nh\u1eefng h\u00f3a\u00a0\u0111\u01a1n <strong>Trong c\u00f9ng 1 quy\u1ec3n<\/strong> c\u00f3 ph\u1ea7n S\u1ed1 (trong c\u1ed9t S\u1ed1\u00a0h\u00f3a\u00a0\u0111\u01a1n) l\u00e0 s\u1ed1 l\u1edbn\u00a0h\u01a1n nh\u01b0ng th\u1eddi gian s\u1eed d\u1ee5ng l\u1ea1i nh\u1ecf h\u01a1n (hay n\u00f3i c\u00e1ch kh\u00e1c h\u00f3a\u00a0\u0111\u01a1n trong c\u00f9ng 1 quy\u1ec3n c\u00f3 s\u1ed1 nh\u1ecf h\u01a1n nh\u01b0ng th\u1eddi gian s\u1eed d\u1ee5ng l\u1ea1i l\u1edbn h\u01a1n c\u00e1c s\u1ed1 tr\u01b0\u1edbc\u00a0\u0111\u00f3).<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Cach_lam_nhu_sau\"><\/span>C\u00e1ch l\u00e0m nh\u01b0 sau:<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><strong>B\u01b0\u1edbc 1: T\u00e1ch ph\u1ea7n s\u1ed1 h\u00f3a\u00a0\u0111\u01a1n kh\u1ecfi c\u1ed9t S\u1ed1\u00a0h\u00f3a\u00a0\u0111\u01a1n<\/strong><\/p>\n<p>\u0110\u1ec3 c\u00f3 th\u1ec3 so s\u00e1nh c\u00e1c gi\u00e1 tr\u1ecb s\u1ed1 h\u00f3a\u00a0\u0111\u01a1n, ch\u00fang ta ph\u1ea3i t\u00e1ch c\u00e1c gi\u00e1 tr\u1ecb s\u1ed1 h\u00f3a\u00a0\u0111\u01a1n ra ri\u00eang 1 c\u1ed9t. V\u00ec khi l\u1eabn c\u1ea3 ph\u1ea7n K\u00fd hi\u1ec7u v\u1edbi ph\u1ea7n s\u1ed1\u00a0th\u00ec\u00a0\u0111\u00e2y l\u00e0 gi\u00e1 tr\u1ecb Text, kh\u00f4ng so s\u00e1nh\u00a0\u0111\u01b0\u1ee3c.<\/p>\n<p>C\u00e1ch t\u00e1ch: S\u1eed d\u1ee5ng <a href=\"http:\/\/blog.ezworkapp.com\/ham-right-va-cac-ung-dung-tuyet-voi-cua-ham-right-trong-phan-xuat-ky-tu.html\">h\u00e0m RIGHT<\/a> k\u1ebft h\u1ee3p <a href=\"http:\/\/blog.ezworkapp.com\/su-dung-ham-value-va-cac-tuy-chon-khac-de-chuyen-doi-dinh-dang-cua-tu-text-sang-number.html\">h\u00e0m VALUE<\/a> nh\u01b0 sau:<\/p>\n<ol>\n<li>H\u00e0m RIGHT: T\u00e1ch ph\u1ea7n s\u1ed1 g\u1ed3m 7 k\u00fd t\u1ef1 ph\u00eda b\u00ean ph\u1ea3i trong m\u1ed7i\u00a0\u00f4\u00a0\u1edf c\u1ed9t C<\/li>\n<li>H\u00e0m VALUE: Chuy\u1ec3n k\u1ebft qu\u1ea3 h\u00e0m RIGHT v\u1ec1 d\u1ea1ng s\u1ed1<\/li>\n<\/ol>\n<p>T\u1ea1o c\u1ed9t E\u00a0\u0111\u1ec3 nh\u1eadn k\u1ebft qu\u1ea3 t\u00e1ch s\u1ed1<\/p>\n<p>T\u1ea1i\u00a0\u00f4 E2 vi\u1ebft c\u00f4ng th\u1ee9c:<\/p>\n<p style=\"padding-left: 30px\">=VALUE(RIGHT(C2,7))<\/p>\n<p>K\u00e9o c\u00f4ng th\u1ee9c t\u1eeb\u00a0\u00f4 E2 t\u1edbi h\u1ebft b\u1ea3ng, ta c\u00f3 k\u1ebft qu\u1ea3:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-27925\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/ket-qua-tach-so-hoa-don-bang-ham-value-right.png\" width=\"701\" height=\"338\" title=\"ket-qua-tach-so-hoa-don-bang-ham-value-right\"><\/p>\n<p><strong>B\u01b0\u1edbc 2: Ki\u1ec3m tra h\u00f3a\u00a0\u0111\u01a1n s\u1ed1 nh\u1ecf vi\u1ebft sau v\u1edbi h\u00e0m COUNTIFS<\/strong><\/p>\n<p style=\"padding-left: 30px\">Tham kh\u1ea3o: <strong>H\u01b0\u1edbng d\u1eabn c\u00e1ch <a href=\"http:\/\/blog.ezworkapp.com\/cach-dung-ham-countif-va-countifs-voi-nhieu-dieu-kien.html\">s\u1eed d\u1ee5ng h\u00e0m countif trong excel<\/a> m\u1ecdi phi\u00ean b\u1ea3n<\/strong><\/p>\n<p>T\u1ea1o c\u1ed9t F l\u00e0 c\u1ed9t s\u1ebd d\u00f9ng c\u00f4ng th\u1ee9c t\u00ednh ra k\u1ebft qu\u1ea3.<\/p>\n<p>Y\u00eau c\u1ea7u n\u00e0y g\u1ed3m 3\u00a0\u0111i\u1ec1u ki\u1ec7n \u0111\u1ed3ng th\u1eddi x\u1ea3y ra:<\/p>\n<ul>\n<li>S\u1ed1 quy\u1ec3n: Ph\u1ea3i c\u00f9ng 1 quy\u1ec3n<\/li>\n<li>S\u1ed1 h\u00f3a\u00a0\u0111\u01a1n: S\u1ed1 ki\u1ec3m tra ph\u1ea3i nh\u1ecf h\u01a1n c\u00e1c s\u1ed1 tr\u01b0\u1edbc\u00a0\u0111\u00f3<\/li>\n<li>Ng\u00e0y s\u1eed d\u1ee5ng: Ng\u00e0y ki\u1ec3m tra ph\u1ea3i l\u1edbn h\u01a1n c\u00e1c ng\u00e0y tr\u01b0\u1edbc\u00a0\u0111\u00f3<\/li>\n<\/ul>\n<p>Nh\u01b0 v\u1eady ta c\u00f3 <a href=\"http:\/\/blog.ezworkapp.com\/ham-countifs-dem-theo-nhieu-dieu-kien.html\"><strong>h\u00e0m COUNTIFS<\/strong><\/a> nh\u01b0 sau:<\/p>\n<p>F2 =COUNTIFS(<span style=\"color: #ff0000\">$B$2:B2,B2<\/span>, <span style=\"color: #0000ff\">$E$2:E2,\u201d&gt;\u201d&amp;E2<\/span>, <span style=\"color: #993366\">$D$2:D2,\u201d&lt;\u201c&amp;D2<\/span>)<\/p>\n<ul>\n<li>V\u00f9ng \u0111i\u1ec1u ki\u1ec7n 1: $B$2:B2 l\u00e0 c\u1ed9t S\u1ed1 quy\u1ec3n. V\u00f9ng n\u00e0y c\u1ed1\u00a0\u0111\u1ecbnh\u00a0\u0111i\u1ec3m\u00a0\u0111\u1ea7u,\u00a0\u0111i\u1ec3m cu\u1ed1i kh\u00f4ng c\u1ed1\u00a0\u0111\u1ecbnh\u00a0\u0111\u1ec3 m\u1edf r\u1ed9ng d\u1ea7n v\u00f9ng n\u00e0y ra<\/li>\n<li>\u0110i\u1ec1u ki\u1ec7n 1: B2 l\u00e0 s\u1ed1 quy\u1ec3n\u00a0t\u1ea1i\u00a0\u00f4 B2. Gi\u00e1 tr\u1ecb n\u00e0y kh\u00f4ng c\u1ed1\u00a0\u0111\u1ecbnh\u00a0\u0111\u1ec3 thay\u00a0\u0111\u1ed5i khi k\u00e9o xu\u1ed1ng d\u00f2ng kh\u00e1c<\/li>\n<li>V\u00f9ng \u0111i\u1ec1u ki\u1ec7n 2: $E$2:E2 l\u00e0 c\u1ed9t S\u1ed1 h\u00f3a \u0111\u01a1n. V\u00f9ng n\u00e0y c\u1ed1\u00a0\u0111\u1ecbnh\u00a0\u0111i\u1ec3m\u00a0\u0111\u1ea7u,\u00a0\u0111i\u1ec3m cu\u1ed1i kh\u00f4ng c\u1ed1\u00a0\u0111\u1ecbnh\u00a0\u0111\u1ec3 m\u1edf r\u1ed9ng d\u1ea7n v\u00f9ng n\u00e0y ra<\/li>\n<li>\u0110i\u1ec1u ki\u1ec7n 2: \u201c&gt;\u201d&amp;E2 l\u00e0 s\u1ed1 h\u00f3a \u0111\u01a1n l\u1edbn h\u01a1n so v\u1edbi s\u1ed1 t\u1ea1i d\u00f2ng \u0111ang ki\u1ec3m tra. Gi\u00e1 tr\u1ecb n\u00e0y kh\u00f4ng c\u1ed1\u00a0\u0111\u1ecbnh\u00a0\u0111\u1ec3 thay\u00a0\u0111\u1ed5i khi k\u00e9o xu\u1ed1ng d\u00f2ng kh\u00e1c<\/li>\n<li>V\u00f9ng \u0111i\u1ec1u ki\u1ec7n 3: $D$2:D2 l\u00e0 c\u1ed9t\u00a0Ng\u00e0y. V\u00f9ng n\u00e0y c\u1ed1\u00a0\u0111\u1ecbnh\u00a0\u0111i\u1ec3m\u00a0\u0111\u1ea7u,\u00a0\u0111i\u1ec3m cu\u1ed1i kh\u00f4ng c\u1ed1\u00a0\u0111\u1ecbnh\u00a0\u0111\u1ec3 m\u1edf r\u1ed9ng d\u1ea7n v\u00f9ng n\u00e0y ra<\/li>\n<li>\u0110i\u1ec1u ki\u1ec7n 3: \u201c&lt;\u201c&amp;D2 l\u00e0 ng\u00e0y nh\u1ecf h\u01a1n so v\u1edbi ng\u00e0y t\u1ea1i d\u00f2ng \u0111ang ki\u1ec3m tra. Gi\u00e1 tr\u1ecb n\u00e0y kh\u00f4ng c\u1ed1\u00a0\u0111\u1ecbnh\u00a0\u0111\u1ec3 thay\u00a0\u0111\u1ed5i khi k\u00e9o xu\u1ed1ng d\u00f2ng kh\u00e1c<\/li>\n<\/ul>\n<p>Nh\u01b0 v\u1eady k\u1ebft qu\u1ea3 thu\u00a0\u0111\u01b0\u1ee3c l\u00e0:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-27927\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/ket-qua-kiem-tra-voi-ham-countifs.png\" width=\"842\" height=\"338\" title=\"ket-qua-kiem-tra-voi-ham-countifs\"><\/p>\n<p>Khi l\u1ecdc theo quy\u1ec3n h\u00f3a\u00a0\u0111\u01a1n\u00a0\u0111\u1ec3 ki\u1ec3m tra, ch\u00fang ta th\u1ea5y:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-27928\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/check-quyen-hoa-don-de-kiem-tra.png\" width=\"836\" height=\"200\" title=\"check-quyen-hoa-don-de-kiem-tra\"><\/p>\n<p>V\u00ed d\u1ee5 v\u1edbi quy\u1ec3n s\u1ed1 920, ta c\u00f3 h\u00f3a\u00a0\u0111\u01a1n s\u1ed1 4597 c\u00f3 ng\u00e0y s\u1eed d\u1ee5ng l\u00e0 25\/01\/2018, trong khi\u00a0\u0111\u00f3 s\u1ed1 l\u1edbn h\u01a1n l\u00e0 4600 l\u1ea1i c\u00f3 ng\u00e0y s\u1eed d\u1ee5ng l\u00e0 22\/01\/2018. Nh\u01b0 v\u1eady quy\u1ec3n n\u00e0y c\u00f3 h\u00f3a\u00a0\u0111\u01a1n s\u1ed1 4597 l\u00e0 s\u1ed1 nh\u1ecf nh\u01b0ng l\u1ea1i vi\u1ebft sau, c\u1ee5 th\u1ec3 l\u00e0 sau 3 t\u1edd h\u00f3a\u00a0\u0111\u01a1n c\u00f3 s\u1ed1 l\u1edbn h\u01a1n\u00a0\u0111\u00e3 vi\u1ebft tr\u01b0\u1edbc.<\/p>\n<p>T\u01b0\u01a1ng t\u1ef1 v\u1edbi c\u00e1c quy\u1ec3n h\u00f3a\u00a0\u0111\u01a1n kh\u00e1c, c\u00e1c b\u1ea1n c\u00f3 th\u1ec3 l\u1ecdc v\u00e0 ki\u1ec3m tra.<\/p>\n<p>Nh\u01b0 v\u1eady ch\u00fang ta\u00a0\u0111\u00e3 c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng 1 c\u00e1ch vi\u1ebft c\u1ee7a h\u00e0m COUNTIFS\u00a0\u0111\u1ec3 gi\u1ea3i quy\u1ebft 1 y\u00eau c\u1ea7u c\u00f4ng vi\u1ec7c kh\u00e1 ph\u1ee9c t\u1ea1p. C\u00f4ng th\u1ee9c c\u0169ng kh\u00f4ng qu\u00e1 kh\u00f3 ph\u1ea3i kh\u00f4ng n\u00e0o. Ch\u00fac c\u00e1c b\u1ea1n\u00a0\u00e1p d\u1ee5ng th\u00e0nh c\u00f4ng!<\/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-360.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":4439,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-4438","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\/4438","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=4438"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/4438\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/4439"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=4438"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=4438"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=4438"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}