{"id":12137,"date":"2025-01-15T07:19:59","date_gmt":"2025-01-15T07:19:59","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/15\/bai-tap-huong-dan-su-dung-ket-hop-ham-if-voi-mot-so-ham-trong-excel\/"},"modified":"2025-01-15T07:19:59","modified_gmt":"2025-01-15T07:19:59","slug":"bai-tap-huong-dan-su-dung-ket-hop-ham-if-voi-mot-so-ham-trong-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/15\/bai-tap-huong-dan-su-dung-ket-hop-ham-if-voi-mot-so-ham-trong-excel\/","title":{"rendered":"B\u00e0i t\u1eadp h\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng k\u1ebft h\u1ee3p h\u00e0m IF v\u1edbi m\u1ed9t s\u1ed1 h\u00e0m trong Excel"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p style=\"text-align: justify\">Khi s\u1eed d\u1ee5ng excel trong h\u1ecdc t\u1eadp v\u00e0 c\u00f4ng vi\u1ec7c m\u00ecnh th\u1ea5y kh\u00f4ng \u00edt c\u00e1c b\u1ea1n s\u1eed d\u1ee5ng r\u1ea5t th\u00f4ng th\u1ea1o c\u00e1c h\u00e0m nh\u01b0ng khi ph\u1ea3i k\u1ebft h\u1ee3p c\u00e1c h\u00e0m l\u1ea1i g\u1eb7p kh\u00f3 kh\u0103n. H\u00f4m nay m\u00ecnh xin gi\u1edbi thi\u1ec7u v\u00ed d\u1ee5 v\u1ec1 c\u00e1ch k\u1ebft h\u1ee3p c\u00e1c h\u00e0m \u0111\u1ec3 ph\u1ee5c v\u1ee5 c\u00e1c b\u1ea1n h\u1ecdc t\u1eadp v\u00e0 l\u00e0m vi\u1ec7c m\u1ed9t c\u00e1ch \u0111\u01a1n gi\u1ea3n v\u00e0 d\u1ec5 d\u00e0ng h\u01a1n 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-6787619c17d65\" 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\/bai-tap-huong-dan-su-dung-ket-hop-ham-if-voi-mot-so-ham-trong-excel.html#Cach_long_ghep_cac_ham_IF_voi_nhau\" title=\"C\u00e1ch l\u1ed3ng gh\u00e9p c\u00e1c h\u00e0m\u00a0IF v\u1edbi nhau\">C\u00e1ch l\u1ed3ng gh\u00e9p c\u00e1c h\u00e0m\u00a0IF v\u1edbi nhau<\/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\/bai-tap-huong-dan-su-dung-ket-hop-ham-if-voi-mot-so-ham-trong-excel.html#Long_ghep_ham_AND_OR_trong_ham_IF\" title=\"L\u1ed3ng gh\u00e9p h\u00e0m AND,\u00a0OR trong h\u00e0m\u00a0IF\">L\u1ed3ng gh\u00e9p h\u00e0m AND,\u00a0OR trong h\u00e0m\u00a0IF<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Cach_long_ghep_cac_ham_IF_voi_nhau\"><\/span>C\u00e1ch l\u1ed3ng gh\u00e9p c\u00e1c h\u00e0m\u00a0IF v\u1edbi nhau<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">Ch\u00fang ta s\u1ebd d\u1ef1a v\u00e0o b\u1ea3ng \u0111i\u1ec3m d\u01b0\u1edbi \u0111\u00e2y\u00a0\u0111\u1ec3 t\u00ecm hi\u1ec3u 1 v\u00ed d\u1ee5 v\u1ec1 vi\u1ec7c l\u1ed3ng h\u00e0m\u00a0IF:<\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-24494\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/yeu-cau-xep-loai-bang-ham-if-02.png\" width=\"904\" height=\"229\" title=\"yeu-cau-xep-loai-bang-ham-if-02\"><\/p>\n<p style=\"text-align: justify\">C\u00e1ch x\u1ebfp lo\u1ea1i h\u1ecdc sinh:<\/p>\n<ul style=\"text-align: justify\">\n<li>N\u1ebfu \u0111i\u1ec3m\u00a0trung b\u00ecnh\u00a0tr\u00ean 8 th\u00ec x\u1ebfp lo\u1ea1i Gi\u1ecfi<\/li>\n<li>N\u1ebfu \u0111i\u1ec3m\u00a0trung b\u00ecnh t\u1eeb 6,5\u00a0\u0111\u1ebfn 8 th\u00ec x\u1ebfp lo\u1ea1i Kh\u00e1<\/li>\n<li>N\u1ebfu di\u1ec3m\u00a0trung b\u00ecnh t\u1eeb 5\u00a0\u0111\u1ebfn d\u01b0\u1edbi 6,5 th\u00ec x\u1ebfp lo\u1ea1i Trung b\u00ecnh<\/li>\n<li>C\u00f2n l\u1ea1i l\u00e0 Y\u1ebfu<\/li>\n<\/ul>\n<p style=\"text-align: justify\">\u1ede \u0111\u00e2y m\u00ecnh c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng k\u1ebft h\u1ee3p c\u00e1c h\u00e0m nh\u01b0 sau : m\u00ecnh th\u1ea5y \u0111\u1ec1 b\u00e0i c\u00f3 \u201cn\u1ebfu-th\u00ec\u201d ch\u1ecdn <a href=\"https:\/\/blog.hocexcel.online\/ham-if-va-cach-su-dung-ham-if-trong-excel.html\" target=\"_blank\" rel=\"noopener noreferrer\">h\u00e0m IF<\/a> v\u00e0 \u201cv\u00e0\u201d n\u00ean m\u00ecnh ch\u1ecdn h\u00e0m AND<\/p>\n<p style=\"text-align: justify\"><strong>C\u00fa ph\u00e1p: =IF(I3&gt;8,\u201dGi\u1ecfi\u201d,IF(AND(I3&gt;=6.5,I3&lt;=8),\u201dKh\u00e1\u201d,IF(AND(I3&gt;=5,I3&lt;6.5),\u201dTrung b\u00ecnh\u201d,\u201dY\u1ebfu\u201d)))<\/strong><\/p>\n<p style=\"text-align: justify\">Ngh\u0129a l\u00e0:<\/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\/2025\/01\/vba101_92019-nho-73.gif\" title=\"vba101_92019-nho-73\"><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\/2025\/01\/ex101_92019-nho-356.gif\" title=\"ex101_92019-nho-356\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<ul>\n<li style=\"text-align: justify\"><strong> IF(I3&gt;8;\u201dGi\u1ecfi\u201d<\/strong> : N\u1ebfu sinh vi\u00ean c\u00f3\u00a0\u00a0\u0111i\u1ec3m trung b\u00ecnh (I3 l\u00e0\u00a0\u0111\u1ecba ch\u1ec9\u00a0\u00f4 \u0111i\u1ec3m trung b\u00ecnh)\u00a0<strong>&gt;8<\/strong>\u00a0 th\u00ec \u0111\u01b0\u1ee3c x\u1ebfp lo\u1ea1i <strong>Gi\u1ecfi<\/strong>, c\u00f2n l\u1ea1i x\u00e9t tr\u01b0\u1eddng h\u1ee3p ti\u1ebfp theo n\u1ebfu kh\u00f4ng l\u1edbn h\u01a1n 8<\/li>\n<li style=\"text-align: justify\"><strong>IF(AND(I3&gt;=6.5,I3&lt;=8),\u201dKh\u00e1\u201d\u00a0<\/strong>: N\u1ebfu\u00a0 sinh vi\u00ean c\u00f3 \u0111i\u1ec3m trung b\u00ecnh <strong>&gt;=6.5 v\u00e0 ph\u1ea3i &lt;=8<\/strong> ( v\u00ec &gt;8 l\u00e0 x\u1ebfp lo\u1ea1i gi\u1ecfi r\u1ed3i m\u00e0) th\u00ec x\u1ebfp lo\u1ea1i <strong>Kh\u00e1<\/strong>, c\u00f2n l\u1ea1i x\u00e9t tr\u01b0\u1eddng h\u1ee3p nh\u1ecf h\u01a1n 6.5<\/li>\n<li><strong>IF(AND(I3&gt;=5,I3&lt;6.5),\u201dTrung b\u00ecnh\u201d,\u201dY\u1ebfu\u201d)))<\/strong>: N\u1ebfu sinh vi\u00ean c\u00f3\u00a0\u0111i\u1ec3m trung b\u00ecnh &gt;=5 v\u00e0 &lt;6.5 th\u00ec x\u1ebfp lo\u1ea1i <strong>Trung b\u00ecnh<\/strong> (v\u00ec &gt;=6.5 x\u1ebfp lo\u1ea1i kh\u00e1), c\u00f2n l\u1ea1i d\u01b0\u1edbi 5 s\u1ebd l\u00e0 lo\u1ea1i <strong>Y\u1ebfu<\/strong>.<\/li>\n<\/ul>\n<p style=\"text-align: justify\">M\u00ecnh thu \u0111\u01b0\u1ee3c k\u1ebft qu\u1ea3 nh\u01b0 sau:<\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-large wp-image-24495\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/yeu-cau-xep-loai-bang-ham-if-ket-qua-01-1024x240-1.png\" width=\"1024\" height=\"240\" title=\"yeu-cau-xep-loai-bang-ham-if-ket-qua-01-1024x240-1\"><\/p>\n<p style=\"text-align: justify\">Ho\u1eb7c c\u00f3 th\u1ec3 vi\u1ebft g\u1ecdn l\u1ea1i nh\u01b0 sau:<\/p>\n<blockquote>\n<p style=\"text-align: justify\">=IF(I3&gt;8,\u201dGi\u1ecfi\u201d,IF(I3&gt;=6.5,\u201dKh\u00e1\u201d,IF(I3&gt;=5,\u201dTrung b\u00ecnh\u201d,\u201dY\u1ebfu\u201d)))<\/p>\n<\/blockquote>\n<p style=\"text-align: justify\">B\u1edfi v\u00ec c\u00e1c s\u1ed1\u00a0\u0111i\u1ec3m trung b\u00ecnh\u00a0\u0111\u01b0\u1ee3c x\u00e9t 1 c\u00e1ch tu\u1ea7n t\u1ef1 theo th\u1ee9 t\u1ef1 gi\u1ea3m d\u1ea7n, v\u00ec v\u1eady ch\u00fang ta c\u00f3 th\u1ec3 gi\u1ea3m b\u1edbt c\u00e1c\u00a0\u0111i\u1ec1u ki\u1ec7n:<\/p>\n<ul>\n<li style=\"text-align: justify\">H\u00e0m\u00a0IF th\u1ee9 1 x\u00e9t I3&gt;8<\/li>\n<li style=\"text-align: justify\">H\u00e0m\u00a0IF th\u1ee9 2 x\u00e9t I3&gt;=6.5\u00a0\u0111i\u1ec1u n\u00e0y c\u0169ng\u00a0\u0111\u1ed3ng ngh\u0129a v\u1edbi I3&lt;=8 v\u00ec tr\u01b0\u1eddng h\u1ee3p &gt;8\u00a0\u0111\u00e3 x\u00e9t\u00a0\u1edf tr\u01b0\u1edbc\u00a0\u0111\u00f3<\/li>\n<li style=\"text-align: justify\">H\u00e0m\u00a0IF th\u1ee9 3 x\u00e9t I3&gt;=5\u00a0\u0111i\u1ec1u n\u00e0y c\u0169ng\u00a0\u0111\u1ed3ng ngh\u0129a v\u1edbi I3&lt;6.5 v\u00ec tr\u01b0\u1eddng h\u1ee3p &gt;=6.5\u00a0\u0111\u00e3 x\u00e9t\u00a0\u1edf tr\u01b0\u1edbc\u00a0\u0111\u00f3<\/li>\n<\/ul>\n<h2><span class=\"ez-toc-section\" id=\"Long_ghep_ham_AND_OR_trong_ham_IF\"><\/span>L\u1ed3ng gh\u00e9p h\u00e0m AND,\u00a0OR trong h\u00e0m\u00a0IF<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">V\u1eabn v\u1edbi v\u00ed d\u1ee5 v\u1eeba r\u1ed3i m\u00ecnh s\u1ebd\u00a0x\u00e9t h\u1ecdc b\u1ed5ng cho c\u00e1c sinh vi\u00ean nh\u01b0 sau:<\/p>\n<ul>\n<li style=\"text-align: justify\">Sinh vi\u00ean x\u1ebfp lo\u1ea1i Gi\u1ecfi <strong><em>v\u00e0<\/em><\/strong> \u0111i\u1ec3m c\u00e1c m\u00f4n kh\u00f4ng c\u00f3 m\u00f4n n\u00e0o d\u01b0\u1edbi 7 th\u00ec \u0111\u01b0\u1ee3c h\u1ecdc b\u1ed5ng: 240000.<\/li>\n<li style=\"text-align: justify\">Sinh vi\u00ean x\u1ebfp lo\u1ea1i Gi\u1ecfi <strong><em>ho\u1eb7c<\/em><\/strong> Kh\u00e1 v\u00e0 nh\u01b0ng c\u00f3 m\u00f4n \u0111i\u1ec3m d\u01b0\u1edbi 7\u00a0th\u00ec \u0111\u01b0\u1ee3c h\u1ecdc b\u1ed5ng: 180000.<\/li>\n<li style=\"text-align: justify\">Sinh vi\u00ean x\u1ebfp lo\u1ea1i Trung b\u00ecnh kh\u00f4ng \u0111\u01b0\u1ee3c h\u1ecdc b\u1ed5ng.<\/li>\n<li style=\"text-align: justify\">Sinh vi\u00ean x\u1ebfp lo\u1ea1i Y\u1ebfu ph\u1ea3i n\u1ed9p th\u00eam 180000 ti\u1ec1n h\u1ecdc l\u1ea1i.<\/li>\n<\/ul>\n<p style=\"text-align: justify\">Xem th\u00eam:\u00a0<a href=\"http:\/\/blog.ezworkapp.com\/34-%E2%97%8F-cach-su-dung-ham-trong-excel.html\">C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m if trong excel<\/a><\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-24496\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/yeu-cau-tinh-hoc-bong-ham-if.png\" width=\"1014\" height=\"230\" title=\"yeu-cau-tinh-hoc-bong-ham-if\"><\/p>\n<p style=\"text-align: justify\">\u1ede \u0111\u00e2y m\u00ecnh s\u1ebd s\u1eed d\u1ee5ng h\u00e0m IF v\u1edbi c\u00e1c h\u00e0m MIN,\u00a0AND, OR ( c\u00e1c b\u1ea1n \u0111\u1ec3 \u00fd \u0111\u1ea7u b\u00e0i m\u1ed9t ch\u00fat s\u1ebd d\u1ec5 d\u00e0ng ph\u00e1t hi\u1ec7n c\u00e1c d\u1ea5u hi\u1ec7u \u0111\u1ec3 bi\u1ebft m\u00ecnh c\u1ea7n s\u1eed d\u1ee5ng nh\u1eefng h\u00e0m n\u00e0o nh\u00e9)<\/p>\n<p style=\"text-align: justify\"><strong>H\u00e0m\u00a0IF th\u1ee9 1: X\u00e9t h\u1ecdc b\u1ed5ng lo\u1ea1i gi\u1ecfi<\/strong><\/p>\n<p style=\"text-align: justify;padding-left: 30px\"><b>IF(AND(J3=\u201dGi\u1ecfi\u201d,MIN(D3:G3)&gt;=7),240000, h\u00e0m\u00a0if th\u1ee9 2)\u00a0<\/b>:\u00a0N\u1ebfu sinh vi\u00ean x\u1ebfp lo\u1ea1i Gi\u1ecfi ( J3 l\u00e0 \u0111\u1ecba ch\u1ec9 \u00f4 x\u1ebfp lo\u1ea1i) v\u00e0 \u0111\u1ed3ng th\u1eddi \u0111i\u1ec3m c\u00e1c m\u00f4n &gt;=7 (gi\u00e1 tr\u1ecb nh\u1ecf nh\u1ea5t trong d\u00e3y D3:G3 &gt;=7) th\u00ec \u0111\u01b0\u1ee3c h\u1ecdc b\u1ed5ng 240000, c\u00f2n l\u1ea1i x\u00e9t c\u00e1c k\u1ebft qu\u1ea3 kh\u00e1c<\/p>\n<p style=\"text-align: justify\"><strong>H\u00e0m\u00a0IF th\u1ee9 2: x\u00e9t h\u1ecdc b\u1ed5ng lo\u1ea1i kh\u00e1<\/strong><\/p>\n<p style=\"text-align: justify;padding-left: 30px\"><strong>IF(OR(AND(J3=\u201dGi\u1ecfi\u201d,MIN(D3:G3)&lt;7),J3=\u201dKh\u00e1\u201d),180000, h\u00e0m if th\u1ee9 3)<\/strong>\u00a0: Tr\u01b0\u1eddng h\u1ee3p n\u00e0y ph\u1ea3i chia l\u00e0m 2 tr\u01b0\u1eddng h\u1ee3p:<\/p>\n<p style=\"padding-left: 60px\">\u2013 X\u1ebfp lo\u1ea1i gi\u1ecfi <strong>v\u00e0<\/strong> c\u00f3\u00a0\u0111i\u1ec3m nh\u1ecf h\u01a1n 7: kh\u00f4ng\u00a0\u0111\u01b0\u1ee3c lo\u1ea1i HB gi\u1ecfi m\u00e0 ch\u1ec9\u00a0\u0111\u01b0\u1ee3c HB lo\u1ea1i kh\u00e1<\/p>\n<p style=\"padding-left: 60px\">\u2013 X\u1ebfp lo\u1ea1i Kh\u00e1<\/p>\n<p style=\"padding-left: 60px\">=&gt; Do\u00a0\u0111\u00f3 ph\u1ea3i\u00a0\u0111\u1eb7t 2 tr\u01b0\u1eddng h\u1ee3p n\u00e0y trong h\u00e0m\u00a0OR. Tr\u01b0\u1eddng\u00a0h\u1ee3p Lo\u1ea1i gi\u1ecfi v\u00e0 c\u00f3\u00a0\u0111i\u1ec3m nh\u1ecf h\u01a1n 7 s\u1ebd\u00a0\u0111\u1eb7t trong h\u00e0m AND<\/p>\n<p style=\"text-align: justify\"><strong>H\u00e0m\u00a0IF th\u1ee9 3: x\u00e9t tr\u01b0\u1eddng h\u1ee3p c\u00f2n l\u1ea1i<\/strong><\/p>\n<p style=\"text-align: justify;padding-left: 30px\"><strong>IF(J3=\u201dTrung b\u00ecnh\u201d,0,-180000)<\/strong>\u00a0: Sinh vi\u00ean x\u1ebfp lo\u1ea1i Trung b\u00ecnh th\u00ec kh\u00f4ng \u0111\u01b0\u1ee3c h\u1ecdc b\u1ed5ng, Y\u1ebfu ph\u1ea3i n\u1ed9p 180000<\/p>\n<p style=\"text-align: justify\">Khi n\u1ed1i c\u00e1c h\u00e0m l\u1ea1i ta c\u00f3:<\/p>\n<blockquote>\n<p style=\"text-align: justify\">IF(AND(J3=\u201dGi\u1ecfi\u201d,MIN(D3:G3)&gt;=7),240000,IF(OR(AND(J3=\u201dGi\u1ecfi\u201d,MIN(D3:G3)&lt;7),J3=\u201dKh\u00e1\u201d),180000,IF(J3=\u201dTrung b\u00ecnh\u201d,0,-180000)))<\/p>\n<\/blockquote>\n<p style=\"text-align: justify\">K\u1ebft qu\u1ea3 nh\u01b0 sau:<\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-24497\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/ket-qua-tinh-hoc-bong.png\" width=\"1011\" height=\"229\" title=\"ket-qua-tinh-hoc-bong\"><\/p>\n<p style=\"text-align: justify\">C\u00e1c b\u1ea1n c\u00f3 thu \u0111\u01b0\u1ee3c k\u1ebft qu\u1ea3 nh\u01b0 m\u00ecnh kh\u00f4ng \u1ea1?<\/p>\n<p>\u0110\u1ec3 n\u00e2ng cao ki\u1ebfn th\u1ee9c Excel, b\u1ea1n h\u00e3y tham gia ngay kh\u00f3a h\u1ecdc\u00a0<a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\">EX101 \u2013 Excel t\u1eeb c\u01a1 b\u1ea3n t\u1edbi chuy\u00ean gia<\/a>\u00a0c\u1ee7a H\u1ecdc Excel Online.\u00a0Trong kh\u00f3a h\u1ecdc n\u00e0y b\u1ea1n s\u1ebd \u0111\u01b0\u1ee3c t\u00ecm hi\u1ec3u c\u00e1ch s\u1eed d\u1ee5ng c\u00e1c c\u00f4ng c\u1ee5: conditional formatting, data validation, pivot table\u2026 \u0111\u1ec3 \u1ee9ng d\u1ee5ng v\u00e0o trong c\u00f4ng vi\u1ec7c. Ngo\u00e0i ra b\u1ea1n c\u00f2n bi\u1ebft c\u00e1ch s\u1eed d\u1ee5ng c\u00e1c h\u00e0m trong excel, t\u1eeb c\u00e1c h\u00e0m c\u01a1 b\u1ea3n cho t\u1edbi c\u00e1c h\u00e0m n\u00e2ng cao, ph\u1ee9c t\u1ea1p. Hi\u1ec7n nay h\u1ec7 th\u1ed1ng \u0111ang c\u00f3 \u01b0u \u0111\u00e3i r\u1ea5t l\u1edbn cho b\u1ea1n khi \u0111\u0103ng k\u00fd tham gia kh\u00f3a h\u1ecdc. Chi ti\u1ebft xem t\u1ea1i: <a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\" target=\"_blank\" rel=\"noopener noreferrer\">HocExcel.Online<\/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\/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\/2025\/01\/vba101_92019-nho-73.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":12138,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-12137","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\/12137","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=12137"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/12137\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/12138"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=12137"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=12137"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=12137"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}