{"id":1095,"date":"2024-12-02T04:08:45","date_gmt":"2024-12-02T04:08:45","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/02\/cac-o-tham-chieu-tuong-doi-va-tuyet-doi-trong-dinh-dang-co-dieu-kien-cua-excel\/"},"modified":"2024-12-02T04:08:45","modified_gmt":"2024-12-02T04:08:45","slug":"cac-o-tham-chieu-tuong-doi-va-tuyet-doi-trong-dinh-dang-co-dieu-kien-cua-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/02\/cac-o-tham-chieu-tuong-doi-va-tuyet-doi-trong-dinh-dang-co-dieu-kien-cua-excel\/","title":{"rendered":"C\u00e1c \u00f4 tham chi\u1ebfu t\u01b0\u01a1ng \u0111\u1ed1i v\u00e0 tuy\u1ec7t \u0111\u1ed1i trong \u0111\u1ecbnh d\u1ea1ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n c\u1ee7a Excel"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p>Trong b\u00e0i vi\u1ebft n\u00e0y, H\u1ecdc Excel Online s\u1ebd h\u01b0\u1edbng d\u1eabn c\u00e1ch t\u1ea1o ra m\u1ed9t c\u00f4ng th\u1ee9c \u0111\u1ea1i di\u1ec7n cho b\u1ea3ng t\u00ednh.\u00a0<span lang=\"vi\">\u0110i\u1ec1u n\u00e0y ch\u1eafc ch\u1eafn s\u1ebd gi\u00fap b\u1ea1n ti\u1ebft ki\u1ec7m r\u1ea5t nhi\u1ec1u th\u1eddi gian.<\/span><\/p>\n<p><strong>\u00d4 tham chi\u1ebfu t\u01b0\u01a1ng \u0111\u1ed1i v\u00e0 \u00f4 tham chi\u1ebfu tuy\u1ec7t \u0111\u1ed1i ho\u1ea1t \u0111\u1ed9ng nh\u01b0 th\u1ebf n\u00e0o trong c\u00e1c quy t\u1eafc \u0111\u1ecbnh d\u1ea1ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n.<\/strong><\/p>\n<p>Trong t\u1ea5t c\u1ea3 c\u00e1c c\u00f4ng th\u1ee9c Excel, bao g\u1ed3m c\u00e1c quy t\u1eafc \u0111\u1ecbnh d\u1ea1ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n, \u00f4 tham chi\u1ebfu \u00f4 c\u00f3 th\u1ec3 l\u00e0:<\/p>\n<ul>\n<li><strong>\u00d4 tham chi\u1ebfu tuy\u1ec7t \u0111\u1ed1i<\/strong> (c\u00f3 d\u1ea5u $, v\u00ed d\u1ee5: $ A $ 1) lu\u00f4n lu\u00f4n gi\u1eef nguy\u00ean kh\u00f4ng \u0111\u1ed5i, cho d\u00f9 ch\u00fang \u0111\u01b0\u1ee3c sao ch\u00e9p \u1edf \u0111\u00e2u.<\/li>\n<li><strong>\u00d4 tham chi\u1ebfu t\u01b0\u01a1ng \u0111\u1ed1i<\/strong> (kh\u00f4ng c\u00f3 d\u1ea5u $, v\u00ed d\u1ee5 A1) thay \u0111\u1ed5i d\u1ef1a tr\u00ean v\u1ecb tr\u00ed t\u01b0\u01a1ng \u0111\u1ed1i c\u1ee7a h\u00e0ng v\u00e0 c\u1ed9t, khi \u0111\u01b0\u1ee3c sao ch\u00e9p qua nhi\u1ec1u \u00f4.<\/li>\n<li><strong>\u00d4 tham chi\u1ebfu h\u1ed7n h\u1ee3p<\/strong> (c\u1ed9t tuy\u1ec7t \u0111\u1ed1i v\u00e0 h\u00e0ng t\u01b0\u01a1ng \u0111\u1ed1i (v\u00ed d\u1ee5 $ A1), ho\u1eb7c c\u1ed9t t\u01b0\u01a1ng \u0111\u1ed1i v\u00e0 h\u00e0ng tuy\u1ec7t \u0111\u1ed1i (v\u00ed d\u1ee5 nh\u01b0 A $ 1). Trong c\u00e1c quy t\u1eafc \u0111\u1ecbnh d\u1ea1ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n c\u1ee7a Excel, c\u00e1c \u00f4 tham chi\u1ebfu h\u1ed7n h\u1ee3p \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng th\u01b0\u1eddng xuy\u00ean nh\u1ea5t, \u0111\u1ec3 ch\u1eef c\u00e1i h\u00e0ng ho\u1eb7c c\u1ed9t v\u1eabn ph\u00f9 h\u1ee3p khi \u00e1p d\u1ee5ng cho t\u1ea5t c\u1ea3 c\u00e1c \u00f4 trong v\u00f9ng d\u1eef li\u1ec7u.<\/li>\n<\/ul>\n<p>Trong c\u00e1c quy t\u1eafc \u0111\u1ecbnh d\u1ea1ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n, \u00f4 s\u1ebd \u0111\u01b0\u1ee3c tham chi\u1ebfu \u00a0t\u1eeb \u00f4 ph\u00eda tr\u00ean c\u00f9ng b\u00ean tr\u00e1i trong v\u00f9ng \u00e1p d\u1ee5ng. V\u00ec v\u1eady, khi c\u1ea7n m\u1ed9t quy t\u1eafc m\u1edbi, b\u1ea1n c\u00f3 th\u1ec3 vi\u1ebft m\u1ed9t c\u00f4ng th\u1ee9c cho \u00f4 tr\u00ean c\u00f9ng b\u00ean tr\u00e1i, v\u00e0 Excel s\u1ebd \u201csao ch\u00e9p\u201d c\u00f4ng th\u1ee9c c\u1ee7a b\u1ea1n t\u1edbi t\u1ea5t c\u1ea3 c\u00e1c \u00f4 kh\u00e1c trong ph\u1ea1m vi \u0111\u00e3 ch\u1ecdn.<\/p>\n<p>B\u00e2y gi\u1edd, h\u00e3y \u0111\u1ec3 t\u00f4i ch\u1ec9 cho b\u1ea1n m\u1ed9t v\u00e0i v\u00ed d\u1ee5 v\u1ec1 vi\u1ec7c d\u00f9ng c\u00f4ng th\u1ee9c gi\u1ed1ng h\u1ec7t nhau nh\u01b0ng t\u1ea1o ra k\u1ebft qu\u1ea3 kh\u00e1c nhau t\u00f9y thu\u1ed9c v\u00e0o \u00f4 tham chi\u1ebfu \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng.<\/p>\n<p><strong>V\u00ed d\u1ee5 1. H\u00e0ng tuy\u1ec7t \u0111\u1ed1i v\u00e0 h\u00e0ng t\u01b0\u01a1ng \u0111\u1ed1i<\/strong><\/p>\n<p>Lo\u1ea1i n\u00e0y l\u00e0 \u0111i\u1ec3n h\u00ecnh nh\u1ea5t cho c\u00e1c quy t\u1eafc \u0111\u1ecbnh d\u1ea1ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n trong Excel.<\/p>\n<p>H\u00e3y t\u1ea1o ra m\u1ed9t quy t\u1eafc \u0111\u01a1n gi\u1ea3n \u0111\u1ec3 so s\u00e1nh c\u00e1c gi\u00e1 tr\u1ecb trong c\u00e1c c\u1ed9t A v\u1edbi B, v\u00e0 \u0111\u00e1nh d\u1ea5u m\u00e0u gi\u00e1 tr\u1ecb trong c\u1ed9t A n\u1ebfu n\u00f3 l\u1edbn h\u01a1n gi\u00e1 tr\u1ecb trong c\u1ed9t B n\u1ebfu ch\u00fang c\u00f9ng m\u1ed9t h\u00e0ng.<\/p>\n<div class=\"code-block code-block-2\" style=\"margin: 8px 0;clear: both\">\n<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/vba101-tu-dong-hoa-excel-voi-lap-trinh-vba-cho-nguoi-moi-bat-dau\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/vba101_92019-nho-23.gif\" title=\"vba101_92019-nho-23\"><br \/>\n<\/a>\n<\/div>\n<\/div>\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-76.gif\" title=\"ex101_92019-nho-76\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p>B\u1ea1n h\u00e3y \u0111\u1ecdc l\u1ea1i <a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-dinh-dang-co-dieu-kien-icon-sets-data-bars-va-color-scales.html\" target=\"_blank\" rel=\"noopener noreferrer\"><strong>C\u00e1ch \u0111\u1ecbnh d\u1ea1ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n b\u1eb1ng c\u00f4ng th\u1ee9c trong Excel<\/strong><\/a>, trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y c\u00f4ng th\u1ee9c l\u00e0<\/p>\n<p><strong>= $A1&gt; $B1<\/strong><\/p>\n<p>B\u1edfi v\u00ec b\u1ea1n lu\u00f4n so s\u00e1nh c\u00e1c gi\u00e1 tr\u1ecb trong c\u00e1c c\u1ed9t A v\u00e0 B, b\u1ea1n \u201cs\u1eeda\u201d c\u00e1c c\u1ed9t n\u00e0y b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng tham chi\u1ebfu c\u1ed9t tuy\u1ec7t \u0111\u1ed1i, ch\u00fa \u00fd d\u1ea5u $ tr\u01b0\u1edbc c\u00e1c k\u00fd t\u1ef1 c\u1ed9t trong c\u00f4ng th\u1ee9c tr\u00ean. V\u00e0, v\u00ec b\u1ea1n \u0111ang so s\u00e1nh c\u00e1c gi\u00e1 tr\u1ecb trong m\u1ed7i h\u00e0ng ri\u00eang l\u1ebb, b\u1ea1n s\u1eed d\u1ee5ng tham chi\u1ebfu h\u00e0ng t\u01b0\u01a1ng \u0111\u1ed1i, kh\u00f4ng c\u00f3 $.<\/p>\n<p><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/absolute-column-relative-row.png\" alt=\"Absolute column and relative row cell references in conditional formatting rules\" title=\"absolute-column-relative-row\"><\/p>\n<p><strong><span lang=\"vi\">V\u00ed d\u1ee5 2. C\u1ed9t t\u01b0\u01a1ng \u0111\u1ed1i v\u00e0 h\u00e0ng tuy\u1ec7t \u0111\u1ed1i <\/span><\/strong><\/p>\n<p><span lang=\"vi\">Lo\u1ea1i tham chi\u1ebfu \u00f4 n\u00e0y \u0111\u1ed1i l\u1eadp v\u1edbi ki\u1ec3u tr\u01b0\u1edbc. Trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y, s\u1ed1 h\u00e0ng lu\u00f4n lu\u00f4n l\u00e0 h\u1eb1ng s\u1ed1 trong khi c\u1ed9t thay \u0111\u1ed5i. B\u1ea1n s\u1eed d\u1ee5ng lo\u1ea1i tham chi\u1ebfu n\u00e0y khi b\u1ea1n mu\u1ed1n ki\u1ec3m tra gi\u00e1 tr\u1ecb trong m\u1ed9t h\u00e0ng nh\u1ea5t \u0111\u1ecbnh v\u1edbi m\u1ed9t gi\u00e1 tr\u1ecb nh\u1ea5t \u0111\u1ecbnh ho\u1eb7c v\u1edbi c\u00e1c gi\u00e1 tr\u1ecb trong m\u1ed9t h\u00e0ng kh\u00e1c. <\/span><\/p>\n<p><span lang=\"vi\">V\u00ed d\u1ee5: c\u00f4ng th\u1ee9c d\u01b0\u1edbi \u0111\u00e2y so s\u00e1nh c\u00e1c gi\u00e1 tr\u1ecb trong h\u00e0ng 1 v\u1edbi h\u00e0ng 2 v\u00e0 \u0111\u00e1nh d\u1ea5u m\u00e0u gi\u00e1 tr\u1ecb trong h\u00e0ng 1 n\u1ebfu n\u00f3 l\u1edbn h\u01a1n gi\u00e1 tr\u1ecb trong h\u00e0ng 2 trong c\u00f9ng m\u1ed9t c\u1ed9t: <\/span><\/p>\n<p><span lang=\"vi\">= A$1&gt; A$2<\/span><\/p>\n<p><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/relative-column-absolute-row.png\" alt=\"Relative column and absolute row cell references in Excel conditional formatting\" title=\"relative-column-absolute-row\"><\/p>\n<p><span lang=\"vi\">B\u1edfi v\u00ec b\u1ea1n mu\u1ed1n c\u1ed1 \u0111\u1ecbnh s\u1ed1 h\u00e0ng, b\u1ea1n s\u1eed d\u1ee5ng tham chi\u1ebfu d\u00f2ng tuy\u1ec7t \u0111\u1ed1i, v\u1edbi d\u1ea5u $. V\u00e0 v\u00ec b\u1ea1n mu\u1ed1n so s\u00e1nh c\u00e1c gi\u00e1 tr\u1ecb trong m\u1ed7i c\u1ed9t ri\u00eang l\u1ebb, b\u1ea1n t\u1ea1o c\u00f4ng th\u1ee9c cho c\u1ed9t ngo\u00e0i c\u00f9ng b\u00ean tr\u00e1i (A) v\u00e0 s\u1eed d\u1ee5ng tham chi\u1ebfu c\u1ed9t t\u01b0\u01a1ng \u0111\u1ed1i, kh\u00f4ng c\u00f3 d\u1ea5u $.<\/span><\/p>\n<blockquote>\n<p>Xem th\u00eam: <a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\">B\u00ed K\u00edp tr\u1edf th\u00e0nh chuy\u00ean gia Excel trong 7 ng\u00e0y cho d\u00e2n v\u0103n ph\u00f2ng<\/a><\/p>\n<\/blockquote>\n<p><strong><span lang=\"vi\">V\u00ed d\u1ee5 3. C\u1ed9t tuy\u1ec7t \u0111\u1ed1i v\u00e0 h\u00e0ng tuy\u1ec7t \u0111\u1ed1i <\/span><\/strong><\/p>\n<p><span lang=\"vi\">B\u1ea1n s\u1eed d\u1ee5ng tham chi\u1ebfu h\u00e0ng v\u00e0 c\u1ed9t tuy\u1ec7t \u0111\u1ed1i n\u1ebfu b\u1ea1n mu\u1ed1n so s\u00e1nh t\u1ea5t c\u1ea3 c\u00e1c gi\u00e1 tr\u1ecb trong ph\u1ea1m vi \u0111\u00e3 ch\u1ecdn v\u1edbi c\u00e1c gi\u00e1 tr\u1ecb kh\u00e1c. <\/span><\/p>\n<p><span lang=\"vi\">V\u00ed d\u1ee5: h\u00e3y t\u1ea1o quy t\u1eafc \u0111\u00e1nh d\u1ea5u m\u00e0u t\u1ea5t c\u1ea3 gi\u00e1 tr\u1ecb trong c\u1ed9t A l\u1edbn h\u01a1n gi\u00e1 tr\u1ecb trong \u00f4 B1. C\u00f4ng th\u1ee9c nh\u01b0 sau: <\/span><\/p>\n<p><span lang=\"vi\"><strong>= $A1&gt; $B$1<\/strong> <\/span><\/p>\n<p><span lang=\"vi\">H\u00e3y ch\u00fa \u00fd \u0111\u1ebfn vi\u1ec7c s\u1eed d\u1ee5ng c\u00e1c tham chi\u1ebfu sau: <\/span><\/p>\n<ul>\n<li><span lang=\"vi\">$A1 \u2013 b\u1ea1n s\u1eed d\u1ee5ng <strong>c\u1ed9t tuy\u1ec7t \u0111\u1ed1i v\u00e0 d\u00f2ng t\u01b0\u01a1ng \u0111\u1ed1i<\/strong> v\u00ec mu\u1ed1n so s\u00e1nh t\u1ea5t c\u1ea3 c\u00e1c \u00f4 c\u1ee7a c\u1ed9t A v\u1edbi gi\u00e1 tr\u1ecb trong \u00f4 B1. <\/span><\/li>\n<li><span lang=\"vi\">$B$ 1 \u2013 b\u1ea1n s\u1eed d\u1ee5ng<strong> c\u1ed9t tuy\u1ec7t \u0111\u1ed1i &amp; d\u00f2ng tuy\u1ec7t \u0111\u1ed1i<\/strong> v\u00ec \u00f4 B1 ch\u1ee9a gi\u00e1 tr\u1ecb b\u1ea1n mu\u1ed1n so s\u00e1nh v\u1edbi t\u1ea5t c\u1ea3 c\u00e1c gi\u00e1 tr\u1ecb kh\u00e1c v\u1edbi v\u00e0 b\u1ea1n mu\u1ed1n tham chi\u1ebfu \u00f4 n\u00e0y l\u00e0 h\u1eb1ng s\u1ed1.<\/span><\/li>\n<\/ul>\n<p><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/absolute-column-absolute-row.png\" alt=\"Absolute column and absolute row cell references in Excel conditional formatting\" title=\"absolute-column-absolute-row\"><\/p>\n<p><strong>V\u00ed d\u1ee5 4. C\u1ed9t t\u01b0\u01a1ng \u0111\u1ed1i v\u00e0 h\u00e0ng t\u01b0\u01a1ng \u0111\u1ed1i <\/strong><\/p>\n<p>Lo\u1ea1i tham chi\u1ebfu n\u00e0y \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng trong c\u00e1c quy t\u1eafc \u0111\u1ecbnh d\u1ea1ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n c\u1ee7a Excel \u00edt nh\u1ea5t. B\u1ea1n s\u1eed d\u1ee5ng tham chi\u1ebfu c\u00e1c <strong>c\u1ed9t t\u01b0\u01a1ng \u0111\u1ed1i v\u00e0 h\u00e0ng t\u01b0\u01a1ng \u0111\u1ed1i<\/strong> khi b\u1ea1n mu\u1ed1n ki\u1ec3m tra t\u1ea5t c\u1ea3 c\u00e1c \u00f4 trong ph\u1ea1m vi \u0111\u00e3 ch\u1ecdn so v\u1edbi m\u1ed9t gi\u00e1 tr\u1ecb nh\u1ea5t \u0111\u1ecbnh.<\/p>\n<p>Gi\u1ea3 s\u1eed, b\u1ea1n mu\u1ed1n \u0111\u00e1nh d\u1ea5u m\u00e0u c\u00e1c \u00f4 trong c\u00e1c c\u1ed9t A v\u00e0 B l\u1edbn h\u01a1n m\u1ed9t gi\u00e1 tr\u1ecb trong \u00f4 B1. B\u1ea1n ch\u1ec9 c\u1ea7n sao ch\u00e9p c\u00f4ng th\u1ee9c t\u1eeb v\u00ed d\u1ee5 tr\u01b0\u1edbc v\u00e0 thay th\u1ebf $A1 b\u1eb1ng A1 v\u00ec b\u1ea1n kh\u00f4ng mu\u1ed1n s\u1eeda h\u00e0ng ho\u1eb7c c\u1ed9t:<\/p>\n<p>= A1&gt; $B$1<\/p>\n<p>H\u00e3y nh\u1edb r\u1eb1ng, b\u1ea1n vi\u1ebft c\u00f4ng th\u1ee9c cho \u00f4 ph\u00eda tr\u00ean b\u00ean tr\u00e1i cu\u1ea3 v\u00f9ng d\u1eef li\u1ec7u, tr\u01b0\u1eddng h\u1ee3p n\u00e0y l\u00e0 A1. Khi b\u1ea1n t\u1ea1o m\u1ed9t quy t\u1eafc v\u1edbi c\u00f4ng th\u1ee9c tr\u00ean v\u00e0 \u00e1p d\u1ee5ng n\u00f3 cho m\u1ed9t s\u1ed1 ph\u1ea1m vi, gi\u1ea3 s\u1eed l\u00e0 A1: B10, k\u1ebft qu\u1ea3 s\u1ebd gi\u1ed1ng nh\u01b0 sau:<\/p>\n<p><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/relative-column-relative-row.png\" alt=\"Relative column and relative row in Excel conditional formatting rules\" title=\"relative-column-relative-row\"><\/p>\n<p><strong>M\u1eb9o<\/strong>. \u0110\u1ec3 nhanh ch\u00f3ng chuy\u1ec3n \u0111\u1ed5i gi\u1eefa tham chi\u1ebfu tuy\u1ec7t \u0111\u1ed1i v\u00e0 t\u01b0\u01a1ng \u0111\u1ed1i, h\u00e3y ch\u1ecdn ch\u1ecdn \u00f4 tham chi\u1ebfu t\u1ea1i thanh c\u00f4ng th\u1ee9c v\u00e0 nh\u1ea5n ph\u00edm <strong>F4<\/strong>. Tham chi\u1ebfu s\u1ebd t\u1ef1 xoay gi\u1eefa b\u1ed1n ki\u1ec3u t\u01b0\u01a1ng \u0111\u1ed1i v\u00e0 tuy\u1ec7t \u0111\u1ed1i, nh\u01b0 sau: A1&gt; $ A $ 1&gt; A $ 1&gt; $ A1, v\u00e0 sau \u0111\u00f3 tr\u1edf l\u1ea1i tham chi\u1ebfu t\u01b0\u01a1ng \u0111\u1ed1i A1.<\/p>\n<p><em><strong>Ngu\u1ed3n:<\/strong> Ablebits, d\u1ecbch v\u00e0 bi\u00ean t\u1eadp b\u1edfi Hocexcel Online.<\/em><\/p>\n<blockquote>\n<p>\u0110\u1eebng b\u1ecf qua: B\u1ed3 t\u00e0i li\u1ec7u\u00a0<a href=\"http:\/\/blog.ezworkapp.com\/tag\/hoc-excel-2016\">h\u01b0\u1edbng d\u1eabn h\u1ecdc excel 2016\u00a0<\/a><\/p>\n<\/blockquote>\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\/vba101-tu-dong-hoa-excel-voi-lap-trinh-vba-cho-nguoi-moi-bat-dau\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/vba101_92019-nho-23.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":1096,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-1095","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\/1095","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=1095"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/1095\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/1096"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=1095"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=1095"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=1095"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}