{"id":11970,"date":"2025-01-15T06:24:59","date_gmt":"2025-01-15T06:24:59","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/15\/cac-ham-cuc-ki-huu-dung-trong-excel-2016\/"},"modified":"2025-01-15T06:24:59","modified_gmt":"2025-01-15T06:24:59","slug":"cac-ham-cuc-ki-huu-dung-trong-excel-2016","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/15\/cac-ham-cuc-ki-huu-dung-trong-excel-2016\/","title":{"rendered":"C\u00e1c h\u00e0m c\u1ef1c k\u00ec h\u1eefu d\u1ee5ng trong Excel 2016"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p>Trong excel 2016, c\u00f3 6 h\u00e0m m\u1edbi v\u1edbi nh\u1eefng \u1ee9ng d\u1ee5ng tuy\u1ec7t v\u1eddi nh\u01b0 sau:<\/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-678754b8aa9a5\" 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-1\"><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/blog.hocexcel.online\/cac-ham-excel-cuc-ky-huu-dung-trong-excel-2016.html#Noi_chuoi_bang_ham_TEXTJOIN\" title=\"N\u1ed1i chu\u1ed7i b\u1eb1ng h\u00e0m TEXTJOIN\">N\u1ed1i chu\u1ed7i b\u1eb1ng h\u00e0m TEXTJOIN<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-1\"><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/blog.hocexcel.online\/cac-ham-excel-cuc-ky-huu-dung-trong-excel-2016.html#Su_dung_ham_CONCAT\" title=\"S\u1eed d\u1ee5ng h\u00e0m CONCAT\">S\u1eed d\u1ee5ng h\u00e0m CONCAT<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-1\"><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/blog.hocexcel.online\/cac-ham-excel-cuc-ky-huu-dung-trong-excel-2016.html#Ham_IFS\" title=\"H\u00e0m IFS\">H\u00e0m IFS<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-1\"><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/blog.hocexcel.online\/cac-ham-excel-cuc-ky-huu-dung-trong-excel-2016.html#Ham_SWITCH\" title=\"H\u00e0m SWITCH\">H\u00e0m SWITCH<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-1\"><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/blog.hocexcel.online\/cac-ham-excel-cuc-ky-huu-dung-trong-excel-2016.html#Ham_MINIFS_va_MAXIFS\" title=\"H\u00e0m MINIFS v\u00e0 MAXIFS\">H\u00e0m MINIFS v\u00e0 MAXIFS<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h1><span class=\"ez-toc-section\" id=\"Noi_chuoi_bang_ham_TEXTJOIN\"><\/span>N\u1ed1i chu\u1ed7i b\u1eb1ng h\u00e0m TEXTJOIN<span class=\"ez-toc-section-end\"><\/span><\/h1>\n<p><span class=\"text_exposed_show\">K\u1ebft h\u1ee3p text trong nhi\u1ec1u \u00f4 tr\u1ea3 v\u1ec1 1 \u00f4 v\u1edbi d\u1ea5u hi\u1ec7u ph\u00e2n c\u00e1ch.<br \/>\nV\u00ed d\u1ee5: A1: Qu\u1ef3nh, A2: vui v\u1ebb, A3: hay d\u1ed3 \u2013&gt; T\u1ea1i \u00f4 B1: Textjoin(\u201c:\u201d,true,A1:A3) = Qu\u1ef3nh:vui v\u1ebb:hay d\u1ed3<br \/>\nN\u1ed1i chu\u1ed7i v\u1edbi d\u1ea5u ph\u00e2n c\u00e1ch thay cho vi\u1ec7c c\u00f9ng d\u1ea5u \u201c&amp;\u201d ho\u1eb7c d\u00f9ng Justify trong Home th\u00ec ta c\u00f3 th\u1ec3 d\u00f9ng c\u00e1i n\u00e0y.<br \/>\n\u2022 \u1ee8ng d\u1ee5ng d\u01b0\u1edbi d\u1ea1ng \u0111\u01a1n gi\u1ea3n:<br \/>\n<a href=\"http:\/\/blog.ezworkapp.com\/ham-noi-chuoi-voi-dau-noi-tuy-chon-trong-excel.html\" target=\"_blank\" rel=\"nofollow noopener\">https:\/\/blog.hocexcel.online\/ham-noi-chuoi-voi-dau-noi-tuy-\u2026<\/a><br \/>\n\u2022 \u1ee8ng d\u1ee5ng n\u00e2ng cao (k\u1ebft h\u1ee3p Textjoin v\u1edbi c\u00f4ng th\u1ee9c m\u1ea3ng) ph\u00fat th\u1ee9 5 \u0111\u1ebfn 8 c\u1ee7a Video:<br \/>\n<iframe loading=\"lazy\" src=\"https:\/\/www.youtube.com\/embed\/NffNV2MTgSY\" width=\"560\" height=\"314\" allowfullscreen=\"allowfullscreen\"><\/iframe><br \/>\n<\/span><\/p>\n<p><span class=\"text_exposed_show\">\u2022 Ho\u1eb7c VBA formula thay th\u1ebf do Qu\u1ef3nh l\u00e0m:<\/span><\/p>\n<p>\u00a0<\/p>\n<iframe loading=\"lazy\" src=\"https:\/\/www.youtube.com\/embed\/XvwUgS5OGEY\" width=\"560\" height=\"314\" allowfullscreen=\"allowfullscreen\"><\/iframe>\n<p>\u00a0<\/p>\n<div class=\"text_exposed_show\">\n<h1><span class=\"ez-toc-section\" id=\"Su_dung_ham_CONCAT\"><\/span>S\u1eed d\u1ee5ng h\u00e0m CONCAT<span class=\"ez-toc-section-end\"><\/span><\/h1>\n<p>K\u1ebft h\u1ee3p text trong nhi\u1ec1u \u00f4 tr\u1ea3 v\u1ec1 1 \u00f4 kh\u00f4ng c\u00f3 d\u1ea5u hi\u1ec7u ph\u00e2n c\u00e1ch. H\u1ecd h\u00e0ng, anh em c\u1ee7a Textjoin().<br \/>\nH\u00e0m n\u00e0y ch\u01a1i v\u1edbi m\u1ea3ng d\u1eef li\u1ec7u m\u00e0 kh\u00f4ng c\u1ea7n g\u00f5 d\u1ea5u \u201c,\u201d hay \u201c;\u201d nh\u01b0 h\u00e0m concatenate \u1edf phi\u00ean b\u1ea3n th\u1ea5p h\u01a1n nh\u00e9.<\/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-339.gif\" title=\"ex101_92019-nho-339\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<h1><span class=\"ez-toc-section\" id=\"Ham_IFS\"><\/span>H\u00e0m IFS<span class=\"ez-toc-section-end\"><\/span><\/h1>\n<p>C\u00f4ng th\u1ee9c qu\u00e1 tuy\u1ec7t v\u1eddi \u00f4ng m\u1eb7t tr\u1eddi ti\u1ebft ki\u1ec7m th\u1eddi gian vi\u1ebft IF ch\u1eb1ng ch\u1ecbt. \u0110\u00fang l\u00e0 \u00f4ng Microsoft qu\u00e1 tuy\u1ec7t!!<br \/>\n=IFS(A1=1,1,A1=2,2,A1=3,3) thay v\u00ec c\u00e1ch d\u00e0i d\u00f2ng v\u00e0 kh\u00f3 hi\u1ec3u c\u0169 = IF(A1=1,1,IF(A1=2,2,IF(A1=3,3,\u201d\u201d)))<br \/>\n<a href=\"http:\/\/blog.ezworkapp.com\/su-dung-ham-ifs-thay-the-cho-ham-if-long-ghep-tinh-nang-moi-co-tren-excel-2016.html\" target=\"_blank\" rel=\"nofollow noopener\">https:\/\/blog.hocexcel.online\/su-dung-ham-ifs-thay-the-cho-h\u2026<\/a><\/p>\n<h1><span class=\"ez-toc-section\" id=\"Ham_SWITCH\"><\/span>H\u00e0m SWITCH<span class=\"ez-toc-section-end\"><\/span><\/h1>\n<p>C\u0169ng l\u1ea1i 1 c\u00f4ng th\u1ee9c tuy\u1ec7t v\u1eddi m\u00e0 h\u00e3y quy\u00ean If l\u1ed3ng If \u0111\u1ebfn n l\u1ea7n \u0111i. C\u00f4ng th\u1ee9c n\u00e0y t\u00ean switch ngh\u0129a l\u00e0 \u201cchuy\u1ec3n \u0111\u1ed5i\u201d<br \/>\n<a href=\"http:\/\/blog.ezworkapp.com\/ham-switch-thay-cho-long-trong-excel-2016.html\" target=\"_blank\" rel=\"nofollow noopener\">https:\/\/blog.hocexcel.online\/ham-switch-thay-cho-long-trong\u2026<\/a><\/p>\n<h1><span class=\"ez-toc-section\" id=\"Ham_MINIFS_va_MAXIFS\"><\/span>H\u00e0m MINIFS v\u00e0 MAXIFS<span class=\"ez-toc-section-end\"><\/span><\/h1>\n<p>T\u00ednh gi\u00e1 tr\u1ecb nh\u1ecf nh\u1ea5t v\u00e0 l\u1edbn nh\u1ea5t v\u1edbi \u0111i\u1ec1u ki\u1ec7n. N\u1ebfu trong phi\u00ean b\u1ea3n office th\u1ea5p h\u01a1n th\u00ec ph\u1ea3i d\u00f9ng c\u00f4ng th\u1ee9c m\u1ea3ng cho b\u00e0i to\u00e1n t\u01b0\u1edfng nh\u01b0 \u0111\u01a1n gi\u1ea3n n\u00e0y \u0111\u1ea5y<br \/>\n<iframe loading=\"lazy\" src=\"https:\/\/www.youtube.com\/embed\/gC-F3zY0Yh8\" width=\"560\" height=\"314\" allowfullscreen=\"allowfullscreen\"><\/iframe>\n<\/p>\n<\/div>\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-339.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":11971,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-11970","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\/11970","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=11970"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/11970\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/11971"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=11970"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=11970"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=11970"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}