{"id":8905,"date":"2024-12-29T06:06:19","date_gmt":"2024-12-29T06:06:19","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/29\/huong-dan-cach-tinh-cong-theo-ky-hieu-kep-trong-bang-cham-cong-excel\/"},"modified":"2024-12-29T06:06:19","modified_gmt":"2024-12-29T06:06:19","slug":"huong-dan-cach-tinh-cong-theo-ky-hieu-kep-trong-bang-cham-cong-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/29\/huong-dan-cach-tinh-cong-theo-ky-hieu-kep-trong-bang-cham-cong-excel\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn c\u00e1ch t\u00ednh c\u00f4ng theo k\u00fd hi\u1ec7u k\u00e9p trong b\u1ea3ng ch\u1ea5m c\u00f4ng Excel"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p>Trong b\u00e0i vi\u1ebft\u00a0<a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-cach-lap-bang-cham-cong-theo-ca-va-lam-them-gio-tren-excel-hay-nhat.html\">H\u01b0\u1edbng d\u1eabn c\u00e1ch l\u1eadp b\u1ea3ng ch\u1ea5m c\u00f4ng theo ca v\u00e0 l\u00e0m th\u00eam gi\u1edd tr\u00ean Excel<\/a> ch\u00fang ta\u00a0\u0111\u00e3 bi\u1ebft c\u00e1ch t\u1ea1o b\u1ea3ng ch\u1ea5m c\u00f4ng\u00a0trong nh\u1eefng \u0111\u01a1n v\u1ecb l\u00e0m vi\u1ec7c\u00a03 ca v\u1edbi l\u00e0m th\u00eam theo t\u1eebng ca. Nh\u01b0ng kh\u00f4ng ph\u1ea3i tr\u01b0\u1eddng h\u1ee3p n\u00e0o ch\u00fang ta c\u0169ng ch\u1ec9 ch\u1ea5m c\u00f4ng theo 1 k\u00fd hi\u1ec7u\u00a0\u0111\u01a1n (ch\u1ec9 1 k\u00fd hi\u1ec7u th\u1ec3 hi\u1ec7n 1 lo\u1ea1i c\u00f4ng). C\u00f3 nh\u1eefng l\u00fac ch\u00fang ta c\u1ea7n t\u1edbi k\u00fd hi\u1ec7u k\u00e9p, trong\u00a0\u0111\u00f3 k\u1ebft h\u1ee3p\u00a0nhi\u1ec1u k\u00fd hi\u1ec7u\u00a0\u0111\u01a1n\u00a0\u0111\u1ec3 th\u1ec3 hi\u1ec7n nhi\u1ec1u lo\u1ea1i c\u00f4ng trong c\u00f9ng 1 ca. Trong b\u00e0i vi\u1ebft n\u00e0y ch\u00fang ta c\u00f9ng t\u00ecm hi\u1ec3u c\u00e1ch\u00a0t\u00ednh c\u00f4ng theo k\u00fd k\u00e9p trong b\u1ea3ng ch\u1ea5m c\u00f4ng Excel.<\/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-6770e6da2d6ce\" 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-tinh-cong-theo-ky-hieu-kep-trong-bang-cham-cong-excel.html#Cham_cong_bang_ky_hieu_kep_cong_kep\" title=\"Ch\u1ea5m c\u00f4ng b\u1eb1ng k\u00fd hi\u1ec7u k\u00e9p (c\u00f4ng k\u00e9p)\">Ch\u1ea5m c\u00f4ng b\u1eb1ng k\u00fd hi\u1ec7u k\u00e9p (c\u00f4ng k\u00e9p)<\/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-tinh-cong-theo-ky-hieu-kep-trong-bang-cham-cong-excel.html#Cong_thuc_tinh_cong_theo_ky_hieu_kep\" title=\"C\u00f4ng th\u1ee9c t\u00ednh c\u00f4ng theo k\u00fd hi\u1ec7u k\u00e9p\">C\u00f4ng th\u1ee9c t\u00ednh c\u00f4ng theo k\u00fd hi\u1ec7u k\u00e9p<\/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-3\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-cach-tinh-cong-theo-ky-hieu-kep-trong-bang-cham-cong-excel.html#Cong_thuc_tinh_lam_du_ca_bang_ham_COUNTIF\" title=\"C\u00f4ng th\u1ee9c t\u00ednh l\u00e0m\u00a0\u0111\u1ee7 ca b\u1eb1ng h\u00e0m COUNTIF\">C\u00f4ng th\u1ee9c t\u00ednh l\u00e0m\u00a0\u0111\u1ee7 ca b\u1eb1ng h\u00e0m COUNTIF<\/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-tinh-cong-theo-ky-hieu-kep-trong-bang-cham-cong-excel.html#Cong_thuc_tinh_lam_nua_ca_bang_ham_SUMPRODUCT\" title=\"C\u00f4ng th\u1ee9c t\u00ednh l\u00e0m\u00a0n\u1eeda\u00a0ca b\u1eb1ng h\u00e0m\u00a0SUMPRODUCT\">C\u00f4ng th\u1ee9c t\u00ednh l\u00e0m\u00a0n\u1eeda\u00a0ca b\u1eb1ng h\u00e0m\u00a0SUMPRODUCT<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2><span class=\"ez-toc-section\" id=\"Cham_cong_bang_ky_hieu_kep_cong_kep\"><\/span>Ch\u1ea5m c\u00f4ng b\u1eb1ng k\u00fd hi\u1ec7u k\u00e9p (c\u00f4ng k\u00e9p)<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>N\u1ebfu trong 1 ca l\u00e0m vi\u1ec7c, ng\u01b0\u1eddi lao\u00a0\u0111\u1ed9ng ngh\u1ec9 n\u1eeda ca v\u00e0 l\u00e0m n\u1eeda ca th\u00ec ch\u00fang ta ch\u1ea5m c\u00f4ng th\u1ebf n\u00e0o?<\/p>\n<p>N\u1ebfu trong 1 ca l\u00e0m vi\u1ec7c, ng\u01b0\u1eddi lao\u00a0\u0111\u1ed9ng\u00a0\u0111\u01b0\u1ee3c\u00a0\u0111\u00e0o t\u1ea1o chuy\u00ean m\u00f4n nghi\u1ec7p v\u1ee5 n\u1eeda ca, c\u00f2n l\u1ea1i n\u1eeda ca s\u1ebd quay tr\u1edf l\u1ea1i l\u00e0m vi\u1ec7c, v\u1eady ch\u1ea5m c\u00f4ng th\u1ebf n\u00e0o?<\/p>\n<p>Tr\u00ean\u00a0\u0111\u00e2y l\u00e0 2 v\u00ed d\u1ee5 ti\u00eau bi\u1ec3u cho tr\u01b0\u1eddng h\u1ee3p 1 ca l\u00e0m vi\u1ec7c c\u00f3 t\u1edbi 2 lo\u1ea1i c\u00f4ng kh\u00e1c nhau. Trong nh\u1eefng tr\u01b0\u1eddng h\u1ee3p n\u00e0y ch\u00fang ta th\u01b0\u1eddng s\u1eed d\u1ee5ng ch\u1ea5m c\u00f4ng b\u1eb1ng k\u00fd hi\u1ec7u k\u00e9p.<\/p>\n<p>V\u00ed d\u1ee5 nh\u01b0 sau:<\/p>\n<p>K\u00fd hi\u1ec7u ch\u1ea5m c\u00f4ng:<\/p>\n<ul>\n<li>HC : L\u00e0m\u00a0\u0111\u1ee7 1 ca<\/li>\n<li>HC\/P: L\u00e0m n\u1eeda ca, c\u00f2n n\u1eeda ca l\u00e0 ngh\u1ec9 ph\u00e9p<\/li>\n<li>HC\/K: L\u00e0m n\u1eeda ca, c\u00f2n n\u1eeda ca l\u00e0 ngh\u1ec9 c\u00f3 ph\u00e9p<\/li>\n<li>HC\/H: L\u00e0m n\u1eeda ca, c\u00f2n n\u1eeda ca l\u00e0\u00a0\u0111i h\u1ecdc<\/li>\n<\/ul>\n<p>Tr\u00ean b\u1ea3ng ch\u1ea5m c\u00f4ng ta c\u00f3 nh\u01b0 sau:<\/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-835.gif\" title=\"ex101_92019-nho-835\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-large wp-image-26537\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/cham-cong-ky-hieu-kep-1024x523-1.png\" width=\"1024\" height=\"523\" title=\"cham-cong-ky-hieu-kep-1024x523-1\"><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Cong_thuc_tinh_cong_theo_ky_hieu_kep\"><\/span>C\u00f4ng th\u1ee9c t\u00ednh c\u00f4ng theo k\u00fd hi\u1ec7u k\u00e9p<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><strong>X\u00e9t c\u00e1c ti\u00eau ch\u00ed x\u00e1c\u00a0\u0111\u1ecbnh c\u00f4ng l\u00e0m vi\u1ec7c:<\/strong><\/p>\n<p>V\u1edbi c\u00f4ng l\u00e0m vi\u1ec7c l\u00e0 HC, ta th\u1ea5y c\u00f3 2 c\u00e1ch t\u00ednh:<\/p>\n<ul>\n<li>\u00d4 ch\u1ec9 c\u00f3\u00a0\u0111\u00fang k\u00fd hi\u1ec7u l\u00e0 HC (kh\u00f4ng c\u00f3 k\u00fd hi\u1ec7u n\u00e0o kh\u00e1c) th\u00ec\u00a0\u0111\u01b0\u1ee3c t\u00ednh\u00a0\u0111\u1ee7 1 c\u00f4ng<\/li>\n<li>\u00d4 c\u00f3 k\u00fd hi\u1ec7u k\u00e9p g\u1ed3m k\u00fd t\u1ef1 HC v\u1edbi k\u00fd t\u1ef1 kh\u00e1c s\u1ebd\u00a0\u0111\u01b0\u1ee3c t\u00ednh l\u00e0 n\u1eeda c\u00f4ng<\/li>\n<\/ul>\n<p>Nh\u01b0 v\u1eady ch\u00fang ta ph\u1ea3i t\u00e1ch ri\u00eang 2 lo\u1ea1i c\u00f4ng n\u00e0y\u00a0\u0111\u1ec3 t\u00ednh, sau\u00a0\u0111\u00f3 c\u1ed9ng l\u1ea1i\u00a0\u0111\u1ec3 ra t\u1ed5ng s\u1ed1\u00a0c\u00f4ng l\u00e0m vi\u1ec7c trong ca.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Cong_thuc_tinh_lam_du_ca_bang_ham_COUNTIF\"><\/span>C\u00f4ng th\u1ee9c t\u00ednh l\u00e0m\u00a0\u0111\u1ee7 ca b\u1eb1ng h\u00e0m COUNTIF<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\u0110\u1ec3 t\u00ednh ri\u00eang nh\u1eefng\u00a0\u00f4 ch\u1ec9 c\u00f3 k\u00fd t\u1ef1 HC, ch\u00fang ta c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng h\u00e0m\u00a0\u0111\u1ebfm theo\u00a0\u0111i\u1ec1u ki\u1ec7n nh\u01b0 sau:<\/p>\n<ul>\n<li>V\u00f9ng c\u1ea7n\u00a0\u0111\u1ebfm: t\u1eeb c\u1ed9t D t\u1edbi c\u1ed9t AH tr\u00ean c\u00f9ng d\u00f2ng ch\u1ea5m c\u00f4ng c\u1ee7a t\u1eebng ng\u01b0\u1eddi, t\u1eebng ca<\/li>\n<li>\u0110i\u1ec1u ki\u1ec7n\u00a0\u0111\u1ebfm: k\u00fd t\u1ef1 HC (trong\u00a0\u00f4 B23)<\/li>\n<\/ul>\n<p>Ta c\u00f3 c\u00f4ng th\u1ee9c t\u00ednh c\u00f4ng cho NV001, ca 1 nh\u01b0 sau:<\/p>\n<p style=\"padding-left: 30px\">=COUNTIF($D5:$AH5,$B$23)<\/p>\n<p>Trong\u00a0\u0111\u00f3:<\/p>\n<ul>\n<li>D5:AH5 c\u00f3 th\u1ec3 c\u1ed1\u00a0\u0111\u1ecbnh c\u00e1c c\u1ed9t D, AH (ho\u1eb7c kh\u00f4ng c\u1ea7n c\u1ed1\u00a0\u0111\u1ecbnh c\u0169ng kh\u00f4ng sao)<\/li>\n<li>B23: ph\u1ea3i c\u1ed1\u00a0\u0111\u1ecbnh\u00a0\u00f4 B23\u00a0\u0111\u1ec3 tr\u00e1nh tham chi\u1ebfu t\u1edbi v\u1ecb tr\u00ed k\u00fd t\u1ef1 ch\u1ea5m c\u00f4ng HC trong\u00a0\u00f4 B23 b\u1ecb thay\u00a0\u0111\u1ed5i khi sao ch\u00e9p c\u00f4ng th\u1ee9c<\/li>\n<\/ul>\n<p>K\u1ebft qu\u1ea3 ch\u1ea5m c\u00f4ng b\u1eb1ng h\u00e0m COUNTIF ta c\u00f3:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-large wp-image-26540\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/ket-qua-ham-countif-1024x453-1.png\" width=\"1024\" height=\"453\" title=\"ket-qua-ham-countif-1024x453-1\"><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Cong_thuc_tinh_lam_nua_ca_bang_ham_SUMPRODUCT\"><\/span>C\u00f4ng th\u1ee9c t\u00ednh l\u00e0m\u00a0n\u1eeda\u00a0ca b\u1eb1ng h\u00e0m\u00a0SUMPRODUCT<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\u0110\u1ec3 t\u00ednh c\u00f4ng l\u00e0m n\u1eeda ca, ch\u00fang ta s\u1ebd ph\u1ea3i t\u00ednh d\u1ef1a v\u00e0o k\u00fd hi\u1ec7u k\u00e9p. Nguy\u00ean t\u1eafc t\u00ednh nh\u01b0 sau:<\/p>\n<ul>\n<li>Ch\u1ec9 x\u00e9t nh\u1eefng\u00a0\u00f4 c\u00f3 ch\u1ea5m c\u00f4ng k\u00fd hi\u1ec7u k\u00e9p l\u00e0\u00a0\u00f4 c\u00f3 s\u1ed1\u00a0k\u00fd t\u1ef1 &gt;2<\/li>\n<li>X\u00e9t ph\u1ea7n b\u00ean tr\u00e1i, trong kho\u1ea3ng 2 k\u00fd t\u1ef1\u00a0\u0111\u1ea7u, ph\u1ea3i l\u00e0 k\u00fd t\u1ef1 HC<\/li>\n<\/ul>\n<p>\u0110\u1ec3\u00a0\u0111\u00e1p\u00a0\u1ee9ng c\u1ea3 2 y\u00eau c\u1ea7u tr\u00ean, ch\u00fang ta c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng <a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-cach-dung-ham-sumproduct-de-dem-theo-nhieu-dieu-kien.html\">h\u00e0m SUMPRODUCT\u00a0\u0111\u1ec3 \u0111\u1ebfm theo nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n<\/a>\u00a0nh\u01b0 sau:<\/p>\n<p style=\"padding-left: 30px\">=SUMPRODUCT((LEFT($D5:$AH5,2)=$B$23)*(LEN($D5:$AH5)&gt;2)*1)<\/p>\n<p>Trong\u00a0\u0111\u00f3:<\/p>\n<ul>\n<li>LEFT($D5:$AH5,2)=$B$23 l\u00e0 x\u00e9t ph\u1ea7n b\u00ean tr\u00e1i, 2 k\u00fd t\u1ef1\u00a0\u0111\u1ea7u trong v\u00f9ng ch\u1ea5m c\u00f4ng c\u00f3 b\u1eb1ng k\u00fd t\u1ef1 HC t\u1ea1i\u00a0\u00f4 B23 hay kh\u00f4ng<\/li>\n<li>LEN($D5:$AH5)&gt;2 l\u00e0 x\u00e9t ch\u1ec9 nh\u1eefng\u00a0\u00f4 c\u00f3 tr\u00ean 2 k\u00fd t\u1ef1 (t\u1eeb 3 k\u00fd t\u1ef1 tr\u1edf l\u00ean)<\/li>\n<\/ul>\n<p style=\"padding-left: 30px\">Tham kh\u1ea3o:<\/p>\n<p style=\"padding-left: 60px\"><a href=\"http:\/\/blog.ezworkapp.com\/ham-left-right-va-cach-su-dung-ham-left-right-trong-excel.html\">H\u00e0m LEFT, RIGHT v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m LEFT, RIGHT trong Excel<\/a><\/p>\n<p style=\"padding-left: 60px\"><a href=\"http:\/\/blog.ezworkapp.com\/ham-len-ham-dem-so-ky-tu-trong-chuoi.html\">H\u00e0m LEN, h\u00e0m \u0111\u1ebfm s\u1ed1 k\u00fd t\u1ef1 trong chu\u1ed7i<\/a><\/p>\n<p>V\u00ec nh\u1eefng k\u1ebft qu\u1ea3 thu\u00a0\u0111\u01b0\u1ee3c c\u1ee7a h\u00e0m SUMPRODUCT n\u00e0y ch\u1ec9 t\u01b0\u01a1ng\u00a0\u0111\u01b0\u01a1ng v\u1edbi 0,5 c\u00f4ng b\u00ecnh th\u01b0\u1eddng. Do\u00a0\u0111\u00f3 ch\u00fang ta c\u00f3 th\u1ec3 nh\u00e2n v\u1edbi 0,5\u00a0\u0111\u1ec3 t\u00ednh g\u1ed9p v\u00e0o t\u1ed5ng s\u1ed1\u00a0c\u00f4ng<\/p>\n<p>\u00a0<\/p>\n<p>T\u1ed5ng s\u1ed1 c\u00f4ng =\u00a0\u0110\u1ee7 c\u00f4ng + N\u1eeda c\u00f4ng \/ 2<\/p>\n<p style=\"padding-left: 30px\">AK5 = AI5 +\u00a0\u1ea05\/2<\/p>\n<p>K\u1ebft qu\u1ea3 ho\u00e0n ch\u1ec9nh b\u1ea3ng ch\u1ea5m c\u00f4ng nh\u01b0 sau:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-large wp-image-26545\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/ket-qua-cham-cong-ky-hieu-kep-cong-hc-2-1024x470-1.png\" width=\"1024\" height=\"470\" title=\"ket-qua-cham-cong-ky-hieu-kep-cong-hc-2-1024x470-1\"><\/p>\n<p>V\u1edbi nh\u1eefng lo\u1ea1i c\u00f4ng kh\u00e1c, c\u00e1c b\u1ea1n c\u00f3 th\u1ec3 l\u00e0m t\u01b0\u01a1ng t\u1ef1.<\/p>\n<p>C\u00e1c b\u1ea1n c\u00f3 th\u1ec3 t\u1ea3i file m\u1eabu trong b\u00e0i vi\u1ebft n\u00e0y t\u1ea1i\u00a0\u0111\u1ecba ch\u1ec9:\u00a0<a href=\"http:\/\/bit.ly\/2HzdobY\">http:\/\/bit.ly\/2HzdobY<\/a><\/p>\n<p>Ch\u00fac c\u00e1c b\u1ea1n\u00a0\u1ee9ng d\u1ee5ng t\u1ed1t ki\u1ebfn th\u1ee9c n\u00e0y v\u00e0o trong c\u00f4ng vi\u1ec7c!<\/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-835.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":8906,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-8905","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\/8905","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=8905"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/8905\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/8906"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=8905"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=8905"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=8905"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}