{"id":2123,"date":"2022-11-06T03:10:35","date_gmt":"2022-11-06T03:10:35","guid":{"rendered":"https:\/\/vieclamketoan.vn\/blog\/?p=2123"},"modified":"2022-12-01T02:57:24","modified_gmt":"2022-12-01T02:57:24","slug":"ham-excel-nang-cao","status":"publish","type":"post","link":"https:\/\/vieclamketoan.vn\/blog\/ham-excel-nang-cao\/","title":{"rendered":"T\u1ed5ng h\u1ee3p 5 nh\u00f3m h\u00e0m excel n\u00e2ng cao trong k\u1ebf to\u00e1n b\u1ea1n c\u1ea7n bi\u1ebft"},"content":{"rendered":"\n<p>M\u1ed9t k\u1ebf to\u00e1n vi\u00ean c\u1ea7n th\u00e0nh th\u1ea1o nhi\u1ec1u nh\u00f3m h\u00e0m Excel t\u1eeb c\u01a1 b\u1ea3n \u0111\u1ebfn n\u00e2ng cao. H\u00e3y c\u00f9ng <a href=\"https:\/\/vieclamketoan.vn\/\" target=\"_blank\" rel=\"noreferrer noopener\"><strong>Vieclamketoan<\/strong><\/a> t\u00ecm hi\u1ec3u ngay Top 5+ nh\u00f3m <strong><a href=\"https:\/\/vieclamketoan.vn\/blog\/ham-excel-nang-cao\/\" target=\"_blank\" rel=\"noreferrer noopener\">h\u00e0m Excel n\u00e2ng cao<\/a><\/strong> trong k\u1ebf to\u00e1n m\u00e0 b\u1ea1n n\u00ean bi\u1ebft ngay sau \u0111\u00e2y nh\u00e9.<\/p>\n\n\n\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_58 counter-hierarchy ez-toc-counter ez-toc-grey ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title \" >Table of Contents<\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"Toggle Table of Content\" role=\"button\"><label for=\"item-69d98939e4569\" ><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/label><input aria-label=\"Toggle\" aria-label=\"item-69d98939e4569\"  type=\"checkbox\" id=\"item-69d98939e4569\"><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/vieclamketoan.vn\/blog\/ham-excel-nang-cao\/#Ham_Excel_nang_cao_INDEXMATCH\" title=\"H\u00e0m Excel n\u00e2ng cao INDEX\/MATCH\">H\u00e0m Excel n\u00e2ng cao INDEX\/MATCH<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/vieclamketoan.vn\/blog\/ham-excel-nang-cao\/#Ham_Excel_nang_cao_IF_ket_hop_ANDORNOT\" title=\"H\u00e0m Excel n\u00e2ng cao IF k\u1ebft h\u1ee3p AND\/OR\/NOT\">H\u00e0m Excel n\u00e2ng cao IF k\u1ebft h\u1ee3p AND\/OR\/NOT<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/vieclamketoan.vn\/blog\/ham-excel-nang-cao\/#Ham_Excel_nang_cao_OFFSET_ket_hop_SUMAVERAGE\" title=\"H\u00e0m Excel n\u00e2ng cao OFFSET k\u1ebft h\u1ee3p SUM\/AVERAGE\">H\u00e0m Excel n\u00e2ng cao OFFSET k\u1ebft h\u1ee3p SUM\/AVERAGE<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/vieclamketoan.vn\/blog\/ham-excel-nang-cao\/#Ham_Excel_nang_cao_CHOOSE\" title=\"H\u00e0m Excel n\u00e2ng cao CHOOSE\">H\u00e0m Excel n\u00e2ng cao CHOOSE<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/vieclamketoan.vn\/blog\/ham-excel-nang-cao\/#Ham_Excel_nang_cao_SUMIFCOUNTIF\" title=\"H\u00e0m Excel n\u00e2ng cao SUMIF\/COUNTIF\">H\u00e0m Excel n\u00e2ng cao SUMIF\/COUNTIF<\/a><\/li><\/ul><\/nav><\/div>\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Ham_Excel_nang_cao_INDEXMATCH\"><\/span><strong>H\u00e0m Excel n\u00e2ng cao INDEX\/MATCH<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>INDEX\/MATCH l\u00e0 h\u00e0m Excel \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 thay th\u1ebf cho c\u00e1c c\u00f4ng th\u1ee9c VLOOKUP, HLOOKUP (m\u1ed9t s\u1ed1 h\u1ea1n ch\u1ebf, h\u1ea1n ch\u1ebf). \u0110\u00e2y l\u00e0 m\u1ed9t trong nh\u1eefng s\u1ef1 k\u1ebft h\u1ee3p m\u1ea1nh m\u1ebd gi\u00fap cho c\u00e1c ph\u00e2n t\u00edch t\u00e0i ch\u00ednh, m\u00f4 h\u00ecnh t\u00e0i ch\u00ednh c\u1ee7a b\u1ea1n c\u00f3 th\u1ec3 ph\u00e1t tri\u1ec3n cao h\u01a1n.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"800\" height=\"500\" src=\"https:\/\/vieclamketoan.vn\/blog\/wp-content\/uploads\/2022\/11\/ham-excel-nang-cao-topcv-1.jpg\" alt=\"INDEX\/MATCH l\u00e0 h\u00e0m Excel n\u00e2ng cao h\u01a1n c\u1ee7a VLOOKUP, HLOOKUP\" class=\"wp-image-2457\" srcset=\"https:\/\/vieclamketoan.vn\/blog\/wp-content\/uploads\/2022\/11\/ham-excel-nang-cao-topcv-1.jpg 800w, https:\/\/vieclamketoan.vn\/blog\/wp-content\/uploads\/2022\/11\/ham-excel-nang-cao-topcv-1-640x400.jpg 640w, https:\/\/vieclamketoan.vn\/blog\/wp-content\/uploads\/2022\/11\/ham-excel-nang-cao-topcv-1-768x480.jpg 768w\" sizes=\"auto, (max-width: 800px) 100vw, 800px\" \/><figcaption class=\"wp-element-caption\"><em>INDEX\/MATCH l\u00e0 h\u00e0m Excel n\u00e2ng cao h\u01a1n c\u1ee7a VLOOKUP, HLOOKUP<\/em><\/figcaption><\/figure><\/div>\n\n\n<p>Trong \u0111\u00f3, h\u00e0m INDEX s\u1ebd tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb c\u1ee7a \u00f4 trong b\u1ea3ng t\u00ednh v\u00e0 \u0111\u01b0\u1ee3c d\u1ef1a v\u00e0o s\u1ed1 c\u1ed9t, h\u00e0ng, h\u00e0m MATCH tr\u1ea3 v\u1ec1 v\u1ecb tr\u00ed c\u1ee7a \u00f4 trong 1 h\u00e0ng ho\u1eb7c c\u1ed9t. C\u00f4ng th\u1ee9c c\u1ee7a h\u00e0m INDEX\/MATCH nh\u01b0 sau:<\/p>\n\n\n\n<p><strong>C\u00f4ng th\u1ee9c INDEX: =INDEX(array;row_num;column_num).<\/strong><\/p>\n\n\n\n<p>Trong \u0111\u00f3:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Array: V\u00f9ng \u00f4\/1 h\u00e0ng s\u1ed1 m\u1ea3ng n\u00e0o \u0111\u00f3 \u0111\u01b0\u1ee3c ch\u1ecdn.<\/li>\n\n\n\n<li>Row_num: Ch\u1ecdn h\u00e0ng trong m\u1ea3ng, tr\u1ea3 v\u1ec1 1 gi\u00e1 tr\u1ecb n\u00e0o \u0111\u00f3.<\/li>\n\n\n\n<li>Column_num: Ch\u1ecdn c\u1ed9t trong m\u1ea3ng, tr\u1ea3 v\u1ec1 1 gi\u00e1 tr\u1ecb n\u00e0o \u0111\u00f3.<\/li>\n<\/ul>\n\n\n\n<p><strong>C\u00f4ng th\u1ee9c MATCH: =MATCH(lookup_value,lookup_array,match_type).<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Lookup_value: Gi\u00e1 tr\u1ecb t\u00ecm ki\u1ebfm trong m\u1ea3ng c\u1ee7a Lookup_array.<\/li>\n\n\n\n<li>Lookup_array: M\u1ea3ng, ph\u1ea1m vi t\u00ecm ki\u1ebfm.<\/li>\n\n\n\n<li>Match_type: Ki\u1ec3u t\u00ecm ki\u1ebfm.<\/li>\n<\/ul>\n\n\n\n<p><strong>T\u00ecm hi\u1ec3u th\u00eam: <a href=\"https:\/\/vieclamketoan.vn\/blog\/cac-ham-excel-thong-dung-trong-ke-toan\/\" target=\"_blank\" rel=\"noreferrer noopener\">T\u1ed5ng h\u1ee3p c\u00e1c h\u00e0m excel th\u00f4ng d\u1ee5ng trong k\u1ebf to\u00e1n newbie c\u1ea7n n\u1eafm r\u00f5<\/a><\/strong><\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Ham_Excel_nang_cao_IF_ket_hop_ANDORNOT\"><\/span><strong>H\u00e0m Excel n\u00e2ng cao IF k\u1ebft h\u1ee3p AND\/OR\/NOT<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>H\u00e0m IF l\u00e0 m\u1ed9t trong nh\u1eefng h\u00e0m Excel n\u00e2ng cao m\u00e0 k\u1ebf to\u00e1n vi\u00ean th\u01b0\u1eddng xuy\u00ean ph\u1ea3i s\u1eed d\u1ee5ng, nh\u1ea5t l\u00e0 nh\u1eefng nh\u00e2n vi\u00ean th\u1ef1c hi\u1ec7n <strong><a href=\"https:\/\/vieclamketoan.vn\/blog\/ke-toan-kho-lam-gi\/\" target=\"_blank\" rel=\"noreferrer noopener\">c\u00f4ng vi\u1ec7c k\u1ebf to\u00e1n kho<\/a><\/strong>. H\u00e0m n\u00e0y gi\u00fap b\u1ea1n c\u00f3 th\u1ec3 t\u1ea1o ra m\u1ed9t s\u1ef1 so s\u00e1nh logic gi\u1eefa c\u00e1c gi\u00e1 tr\u1ecb v\u1edbi nhau v\u00e0 tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 \u0111\u00fang (True) v\u00e0 sai (False). C\u00f4ng th\u1ee9c c\u1ee5 th\u1ec3 c\u1ee7a h\u00e0m IF k\u1ebft h\u1ee3p AND\/OR\/NOT nh\u01b0 sau:<\/p>\n\n\n\n<p><strong>IF + AND: =IF(AND(condition1, condition2,\u2026), value_if_true, value_if_false)<\/strong><\/p>\n\n\n\n<p>Trong \u0111\u00f3:&nbsp;<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Condition1, condition2: \u0110i\u1ec1u ki\u1ec7n 1, \u0111i\u1ec1u ki\u1ec7n 2,&#8230; c\u00e1c \u0111i\u1ec1u ki\u1ec7n \u0111\u1ec3 tr\u1ea3 k\u1ebft qu\u1ea3 \u0111\u00fang.<\/li>\n\n\n\n<li>Value_if_true: Gi\u00e1 tr\u1ecb tr\u1ea3 v\u1ec1 n\u1ebfu \u0111\u00fang.<\/li>\n\n\n\n<li>Value_if_false: Gi\u00e1 tr\u1ecb tr\u1ea3 v\u1ec1 n\u1ebfu sai.<\/li>\n<\/ul>\n\n\n\n<p><strong>IF + OR: =IF(OR(condition1, condition2,\u2026), value_if_true, value_if_false)<\/strong><\/p>\n\n\n\n<p>Trong \u0111\u00f3:&nbsp;<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Condition1, condition2: \u0110i\u1ec1u ki\u1ec7n 1, \u0111i\u1ec1u ki\u1ec7n 2,&#8230; c\u00e1c \u0111i\u1ec1u ki\u1ec7n \u0111\u1ec3 tr\u1ea3 k\u1ebft qu\u1ea3 \u0111\u00fang.<\/li>\n\n\n\n<li>Value_if_true: Gi\u00e1 tr\u1ecb tr\u1ea3 v\u1ec1 n\u1ebfu \u0111\u00fang.<\/li>\n\n\n\n<li>Value_if_false: Gi\u00e1 tr\u1ecb tr\u1ea3 v\u1ec1 n\u1ebfu sai.<\/li>\n<\/ul>\n\n\n\n<p><strong>IF + NOT: =IF(NOT(condition1, condition2,\u2026), value_if_true, value_if_false)<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Condition1, condition2: \u0110i\u1ec1u ki\u1ec7n 1, \u0111i\u1ec1u ki\u1ec7n 2,&#8230; c\u00e1c \u0111i\u1ec1u ki\u1ec7n \u0111\u1ec3 tr\u1ea3 k\u1ebft qu\u1ea3 \u0111\u00fang.<\/li>\n\n\n\n<li>Value_if_true: Gi\u00e1 tr\u1ecb tr\u1ea3 v\u1ec1 n\u1ebfu \u0111\u00fang.<\/li>\n\n\n\n<li>Value_if_false: Gi\u00e1 tr\u1ecb tr\u1ea3 v\u1ec1 n\u1ebfu sai.<\/li>\n<\/ul>\n\n\n\n<p><strong>T\u00ecm hi\u1ec3u th\u00eam: <a href=\"https:\/\/vieclamketoan.vn\/blog\/excel-ke-toan\/\" target=\"_blank\" rel=\"noreferrer noopener\">Excel k\u1ebf to\u00e1n l\u00e0 g\u00ec? Nh\u1eefng k\u1ef9 n\u0103ng c\u1ea7n thi\u1ebft trong k\u1ebf to\u00e1n excel<\/a><\/strong><\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"800\" height=\"500\" src=\"https:\/\/vieclamketoan.vn\/blog\/wp-content\/uploads\/2022\/11\/ham-excel-nang-cao-topcv-2.jpg\" alt=\"H\u00e0m IF c\u00f3 th\u1ec3 k\u1ebft h\u1ee3p v\u1edbi AND\/OR\/NOT t\u1ea1o th\u00e0nh c\u00e1c h\u00e0m n\u00e2ng cao h\u01a1n\" class=\"wp-image-2458\" srcset=\"https:\/\/vieclamketoan.vn\/blog\/wp-content\/uploads\/2022\/11\/ham-excel-nang-cao-topcv-2.jpg 800w, https:\/\/vieclamketoan.vn\/blog\/wp-content\/uploads\/2022\/11\/ham-excel-nang-cao-topcv-2-640x400.jpg 640w, https:\/\/vieclamketoan.vn\/blog\/wp-content\/uploads\/2022\/11\/ham-excel-nang-cao-topcv-2-768x480.jpg 768w\" sizes=\"auto, (max-width: 800px) 100vw, 800px\" \/><figcaption class=\"wp-element-caption\"><em>H\u00e0m IF c\u00f3 th\u1ec3 k\u1ebft h\u1ee3p v\u1edbi AND\/OR\/NOT t\u1ea1o th\u00e0nh c\u00e1c h\u00e0m n\u00e2ng cao h\u01a1n<\/em><\/figcaption><\/figure><\/div>\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Ham_Excel_nang_cao_OFFSET_ket_hop_SUMAVERAGE\"><\/span><strong>H\u00e0m Excel n\u00e2ng cao OFFSET k\u1ebft h\u1ee3p SUM\/AVERAGE<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>OFFSET l\u00e0 h\u00e0m Excel \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 tham chi\u1ebfu, t\u00ednh to\u00e1n d\u1eef li\u1ec7u c\u1ee7a 1 ph\u1ea1m vi r\u1ed9ng, ph\u1ea1m vi \u00f4 1 m\u1ed9t s\u1ed1 h\u00e0ng\/1 s\u1ed1 c\u1ed9t nh\u1ea5t \u0111\u1ecbnh. Trong Excel, h\u00e0m OFFSET th\u01b0\u1eddng \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng khi ng\u01b0\u1eddi d\u00f9ng c\u1ea7n t\u00ednh to\u00e1n d\u1eef li\u1ec7u c\u1ee7a 1 \u00f4, 1 d\u00e3y b\u1ea3ng t\u00ednh. C\u00f4ng th\u1ee9c OFFSET k\u1ebft h\u1ee3p c\u00f9ng SUM\/AVERAGE nh\u01b0 sau:<\/p>\n\n\n\n<p><strong>OFFSET + SUM: =SUM(OFFSET(reference,rows,cols,[height],[width]))<\/strong><\/p>\n\n\n\n<p>Trong \u0111\u00f3:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Reference: M\u1ed9t \u00f4, m\u1ed9t d\u1ea3i \u00f4 li\u1ec1n k\u1ec1 c\u1ea7n th\u1ef1c hi\u1ec7n h\u00e0m.<\/li>\n\n\n\n<li>Rows: S\u1ed1 h\u00e0ng di chuy\u1ec3n t\u1eeb \u0111i\u1ec3m \u0111\u01b0\u1ee3c ch\u1ecdn l\u00e0m g\u1ed1c, l\u00ean ho\u1eb7c xu\u1ed1ng. N\u1ebfu c\u00e1c h\u00e0ng l\u00e0 d\u01b0\u01a1ng, c\u00f4ng th\u1ee9c di chuy\u1ec3n d\u01b0\u1edbi v\u00f9ng tham chi\u1ebfu, n\u1ebfu c\u00e1c h\u00e0ng l\u00e0 \u00e2m, c\u00f4ng th\u1ee9c di chuy\u1ec3n tr\u00ean v\u00f9ng tham chi\u1ebfu.<\/li>\n\n\n\n<li>Cols: S\u1ed1 c\u1ed9t m\u00e0 b\u1ea1n mu\u1ed1n c\u00f4ng th\u1ee9c c\u1ee7a b\u1ea1n di chuy\u1ec3n. T\u01b0\u01a1ng t\u1ef1 nh\u01b0 rows, n\u1ebfu gi\u00e1 tr\u1ecb cols d\u01b0\u01a1ng s\u1ebd l\u00e0 b\u00ean ph\u1ea3i tham chi\u1ebfu, n\u1ebfu \u00e2m l\u00e0 b\u00ean tr\u00e1i tham chi\u1ebfu.<\/li>\n\n\n\n<li>Height: Chi\u1ec1u cao, t\u00ednh b\u1eb1ng s\u1ed1 h\u00e0ng mu\u1ed1n tham chi\u1ebfu tr\u1ea3 v\u1ec1.<\/li>\n\n\n\n<li>Width: Chi\u1ec1u r\u1ed9ng, t\u00ednh b\u1eb1ng s\u1ed1 c\u1ed9t mu\u1ed1n tham chi\u1ebfu tr\u1ea3 v\u1ec1.<\/li>\n<\/ul>\n\n\n\n<p><strong>OFFSET + AVERAGE: =AVERAGE(OFFSET(reference,rows,cols,[height],[width]))<\/strong>. C\u00e1c tham s\u1ed1 t\u01b0\u01a1ng t\u1ef1 v\u1edbi c\u00f4ng th\u1ee9c OFFSET + SUM.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Ham_Excel_nang_cao_CHOOSE\"><\/span><strong>H\u00e0m Excel n\u00e2ng cao CHOOSE<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>H\u00e0m Excel n\u00e2ng cao CHOOSE gi\u00fap ng\u01b0\u1eddi d\u00f9ng c\u00f3 th\u1ec3 t\u00ecm ki\u1ebfm \u0111\u01b0\u1ee3c gi\u00e1 trong m\u1ed9t chu\u1ed7i c\u00e1c gi\u00e1 tr\u1ecb s\u1eb5n c\u00f3 t\u1ea1i b\u1ea3ng t\u00ednh. C\u00f4ng th\u1ee9c h\u00e0m CHOOSE nh\u01b0 sau:<\/p>\n\n\n\n<p><strong>H\u00e0m CHOOSE: =CHOOSE(index_num, value1, value2\u2026)<\/strong><\/p>\n\n\n\n<p>Trong \u0111\u00f3:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Index_num: V\u1ecb tr\u00ed m\u00e0 gi\u00e1 tr\u1ecb c\u1ea7n t\u00ecm s\u1ebd tr\u1ea3 v\u1ec1. Gi\u1edbi h\u1ea1n c\u1ee7a Index_num s\u1ebd n\u1eb1m trong kho\u1ea3ng t\u1eeb 1 &#8211; 2. Gi\u00e1 tr\u1ecb n\u00e0y ph\u1ea3i l\u00e0 s\u1ed1 nguy\u00ean, k\u1ebft qu\u1ea3 c\u1ee7a m\u1ed9t c\u00f4ng th\u1ee9c l\u00e0 s\u1ed1 nguy\u00ean. N\u1ebfu kh\u00f4ng ph\u1ea3i s\u1ed1 nguy\u00ean, c\u00f4ng th\u1ee9c s\u1ebd hi\u1ec3n th\u1ecb gi\u00e1 tr\u1ecb l\u1ed7i #Value!.<\/li>\n\n\n\n<li>Value1, Value2,&#8230;: L\u00e0 gi\u00e1 tr\u1ecb tr\u1ea3 v\u1ec1 s\u1ed1 1, s\u1ed1 2,&#8230;<\/li>\n<\/ul>\n\n\n\n<p><strong>T\u00ecm hi\u1ec3u th\u00eam:&nbsp;<a href=\"https:\/\/vieclamketoan.vn\/blog\/phan-mem-ke-toan\/\" target=\"_blank\" rel=\"noreferrer noopener\">C\u00e1c ph\u1ea7n m\u1ec1m k\u1ebf to\u00e1n th\u00f4ng d\u1ee5ng hi\u1ec7n nay<\/a><\/strong><\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Ham_Excel_nang_cao_SUMIFCOUNTIF\"><\/span><strong>H\u00e0m Excel n\u00e2ng cao SUMIF\/COUNTIF<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>SUMIF\/COUNTIF \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 th\u1ef1c hi\u1ec7n t\u00ednh t\u1ed5ng ho\u1eb7c \u0111\u1ebfm s\u1ed1 l\u1ea7n l\u1eb7p l\u1ea1i c\u1ee7a m\u1ed9t gi\u00e1 tr\u1ecb n\u00e0o \u0111\u00f3 th\u1ecfa m\u00e3n c\u00e1c \u0111i\u1ec1u ki\u1ec7n \u0111\u01b0a ra tr\u01b0\u1edbc \u0111\u00f3. C\u00f4ng th\u1ee9c c\u1ee7a h\u00e0m SUMIF\/COUNTIF nh\u01b0 sau:<\/p>\n\n\n\n<p><strong>SUMIF: =SUMIF(range; criteria; sum_range)<\/strong><\/p>\n\n\n\n<p>Trong \u0111\u00f3:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Range: V\u00f9ng \u0111\u01b0\u1ee3c ch\u1ecdn c\u00f3 ch\u1ee9a \u00f4 \u0111i\u1ec1u ki\u1ec7n.<\/li>\n\n\n\n<li>Criteria: \u0110i\u1ec1u ki\u1ec7n \u0111\u1ec3 th\u1ef1c hi\u1ec7n h\u00e0m.<\/li>\n\n\n\n<li>Sum_range: V\u00f9ng d\u1eef li\u1ec7u b\u1ea1n c\u1ea7n t\u00ednh t\u1ed5ng.<\/li>\n<\/ul>\n\n\n\n<p><strong>SUMIFS: =SUMIFS(sum_range; criteria_range; criteria;\u2026)<\/strong><\/p>\n\n\n\n<p>Trong \u0111\u00f3:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Sum_range: C\u00e1c \u00f4 c\u1ea7n t\u00ednh t\u1ed5ng. Bao g\u1ed3m ph\u1ea1m vi, t\u00ean, s\u1ed1, tham chi\u1ebfu \u00f4 c\u00f3 ch\u1ee9a s\u1ed1.<\/li>\n\n\n\n<li>Criteria_range: Ph\u1ea1m vi c\u1ea7n \u0111\u01b0\u1ee3c \u0111\u00e1nh gi\u00e1 b\u1eb1ng c\u00e1c \u0111i\u1ec1u ki\u1ec7n IF.<\/li>\n\n\n\n<li>Criteria: \u0110i\u1ec1u ki\u1ec7n t\u00ednh t\u1ed5ng d\u01b0\u1edbi d\u1ea1ng s\u1ed1, bi\u1ec3u th\u1ee9c, \u00f4 tham chi\u1ebfu.<\/li>\n<\/ul>\n\n\n\n<p><strong>COUNTIF: =COUNTIF(range;criteria)<\/strong><\/p>\n\n\n\n<p>Trong \u0111\u00f3:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Range: V\u00f9ng d\u1eef li\u1ec7u m\u00e0 b\u1ea1n mu\u1ed1n \u0111\u1ebfm s\u1ed1 v\u00e0 l\u00e0 gi\u00e1 tr\u1ecb b\u1eaft bu\u1ed9c ph\u1ea3i c\u00f3. V\u00f9ng d\u1eef li\u1ec7u n\u00e0y c\u00f3 th\u1ec3 l\u00e0 ki\u1ec3u s\u1ed1, ng\u00e0y th\u00e1ng ho\u1eb7c ki\u1ec3u v\u0103n b\u1ea3n.<\/li>\n\n\n\n<li>Criteria: L\u00e0 v\u00f9ng \u0111i\u1ec1u ki\u1ec7n \u0111\u1ec3 th\u1ef1c hi\u1ec7n \u0111\u1ebfm d\u1eef li\u1ec7u trong v\u00f9ng \u0111\u01b0\u1ee3c ch\u1ecdn. C\u00f3 th\u1ec3 l\u00e0 ki\u1ec3u v\u0103n b\u1ea3n, s\u1ed1, bi\u1ec3u th\u1ee9c, tham chi\u1ebfu \u00f4,&#8230;<\/li>\n<\/ul>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"800\" height=\"500\" src=\"https:\/\/vieclamketoan.vn\/blog\/wp-content\/uploads\/2022\/11\/ham-excel-nang-cao-topcv-3.jpg\" alt=\"Nh\u1eefng h\u00e0m Excel n\u00e2ng cao gi\u00fap b\u1ea1n c\u00f3 th\u1ec3 t\u00ednh to\u00e1n khoa h\u1ecdc, d\u1ec5 d\u00e0ng h\u01a1n\" class=\"wp-image-2459\" srcset=\"https:\/\/vieclamketoan.vn\/blog\/wp-content\/uploads\/2022\/11\/ham-excel-nang-cao-topcv-3.jpg 800w, https:\/\/vieclamketoan.vn\/blog\/wp-content\/uploads\/2022\/11\/ham-excel-nang-cao-topcv-3-640x400.jpg 640w, https:\/\/vieclamketoan.vn\/blog\/wp-content\/uploads\/2022\/11\/ham-excel-nang-cao-topcv-3-768x480.jpg 768w\" sizes=\"auto, (max-width: 800px) 100vw, 800px\" \/><figcaption class=\"wp-element-caption\"><em>Nh\u1eefng h\u00e0m Excel n\u00e2ng cao gi\u00fap b\u1ea1n c\u00f3 th\u1ec3 t\u00ednh to\u00e1n khoa h\u1ecdc, d\u1ec5 d\u00e0ng h\u01a1n<\/em><\/figcaption><\/figure><\/div>\n\n\n<p>Hy v\u1ecdng v\u1edbi nh\u1eefng <strong>h\u00e0m Excel n\u00e2ng cao<\/strong> \u0111\u01b0\u1ee3c <strong><a href=\"https:\/\/vieclamketoan.vn\/blog\/chuyen-muc\/chia-se-kinh-nghiem\/\" target=\"_blank\" rel=\"noreferrer noopener\">chia s\u1ebb kinh nghi\u1ec7m<\/a><\/strong> trong b\u00e0i vi\u1ebft h\u00f4m nay, b\u1ea1n s\u1ebd ph\u00e1t tri\u1ec3n h\u01a1n trong c\u00f4ng vi\u1ec7c c\u1ee7a m\u00ecnh. \u0110\u1ec3&nbsp;<strong><a href=\"https:\/\/www.topcv.vn\/tim-viec-lam-ke-toan\" target=\"_blank\" rel=\"noreferrer noopener\">t\u00ecm vi\u1ec7c l\u00e0m k\u1ebf to\u00e1n<\/a><\/strong>&nbsp;uy t\u00edn, l\u01b0\u01a1ng cao, \u0111\u1eebng qu\u00ean truy c\u1eadp&nbsp;<a href=\"https:\/\/www.topcv.vn\/\" target=\"_blank\" rel=\"noreferrer noopener\"><strong>TopCV<\/strong><\/a>&nbsp;\u0111\u1ec3 ti\u1ebfp c\u1eadn nhi\u1ec1u h\u01a1n \u0111\u1ebfn nh\u1eefng vi\u1ec7c l\u00e0m ng\u00e0nh k\u1ebf to\u00e1n c\u0169ng nh\u01b0 c\u00f3 c\u01a1 h\u1ed9i l\u00e0m vi\u1ec7c t\u1ea1i nh\u1eefng doanh nghi\u1ec7p l\u1edbn nh\u00e9!<\/p>\n\n\n\n<p><strong>C\u00f3 th\u1ec3 b\u1ea1n quan t\u00e2m: <a href=\"https:\/\/vieclamketoan.vn\/blog\/ke-toan-truong-la-gi\/\" target=\"_blank\" rel=\"noreferrer noopener\">K\u1ebf to\u00e1n tr\u01b0\u1edfng l\u00e0 g\u00ec? M\u00f4 t\u1ea3 c\u00f4ng vi\u1ec7c k\u1ebf to\u00e1n tr\u01b0\u1edfng<\/a><\/strong><\/p>\n","protected":false},"excerpt":{"rendered":"<p>M\u1ed9t k\u1ebf to\u00e1n vi\u00ean c\u1ea7n th\u00e0nh th\u1ea1o nhi\u1ec1u nh\u00f3m h\u00e0m Excel t\u1eeb c\u01a1 b\u1ea3n \u0111\u1ebfn n\u00e2ng cao. H\u00e3y c\u00f9ng Vieclamketoan t\u00ecm hi\u1ec3u ngay Top 5+ nh\u00f3m h\u00e0m Excel n\u00e2ng cao trong k\u1ebf to\u00e1n m\u00e0 b\u1ea1n n\u00ean bi\u1ebft ngay sau \u0111\u00e2y nh\u00e9. H\u00e0m Excel n\u00e2ng cao INDEX\/MATCH INDEX\/MATCH l\u00e0 h\u00e0m Excel \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 thay [&hellip;]<\/p>\n","protected":false},"author":6,"featured_media":2124,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_mi_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"cybocfi_hide_featured_image":"","footnotes":""},"categories":[86],"tags":[727,729,731,728,730,726],"class_list":["post-2123","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-chia-se-kinh-nghiem","tag-cac-ham-excel-nang-cao","tag-cac-ham-excel-nang-cao-trong-ke-toan","tag-excel-nang-cao-cho-ke-toan","tag-excel-nang-cao-cho-nguoi-di-lam","tag-excel-nang-cao-gom-nhung-gi","tag-ham-excel-nang-cao"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v24.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>T\u1ed5ng h\u1ee3p 5 nh\u00f3m h\u00e0m excel n\u00e2ng cao trong k\u1ebf to\u00e1n b\u1ea1n c\u1ea7n bi\u1ebft<\/title>\n<meta name=\"description\" content=\"H\u00e3y c\u00f9ng Vieclamketoan t\u00ecm hi\u1ec3u Top 5+ nh\u00f3m h\u00e0m Excel n\u00e2ng cao m\u00e0 nh\u00e2n vi\u00ean k\u1ebf to\u00e1n n\u00ean bi\u1ebft v\u00e0 s\u1eed d\u1ee5ng th\u00e0nh th\u1ea1o ngay sau \u0111\u00e2y nh\u00e9.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/vieclamketoan.vn\/blog\/ham-excel-nang-cao\/\" \/>\n<meta property=\"og:locale\" content=\"vi_VN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"T\u1ed5ng h\u1ee3p 5 nh\u00f3m h\u00e0m excel n\u00e2ng cao trong k\u1ebf to\u00e1n b\u1ea1n c\u1ea7n bi\u1ebft\" \/>\n<meta property=\"og:description\" content=\"H\u00e3y c\u00f9ng Vieclamketoan t\u00ecm hi\u1ec3u Top 5+ nh\u00f3m h\u00e0m Excel n\u00e2ng cao m\u00e0 nh\u00e2n vi\u00ean k\u1ebf to\u00e1n n\u00ean bi\u1ebft v\u00e0 s\u1eed d\u1ee5ng th\u00e0nh th\u1ea1o ngay sau \u0111\u00e2y nh\u00e9.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/vieclamketoan.vn\/blog\/ham-excel-nang-cao\/\" \/>\n<meta property=\"og:site_name\" content=\"vieclamketoan\" \/>\n<meta property=\"article:published_time\" content=\"2022-11-06T03:10:35+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-12-01T02:57:24+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/vieclamketoan.vn\/blog\/wp-content\/uploads\/2022\/11\/ham-excel-nang-cao-topcv.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"800\" \/>\n\t<meta property=\"og:image:height\" content=\"500\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Ng\u1ecdc \u00c1nh\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"\u0110\u01b0\u1ee3c vi\u1ebft b\u1edfi\" \/>\n\t<meta name=\"twitter:data1\" content=\"Ng\u1ecdc \u00c1nh\" \/>\n\t<meta name=\"twitter:label2\" content=\"\u01af\u1edbc t\u00ednh th\u1eddi gian \u0111\u1ecdc\" \/>\n\t<meta name=\"twitter:data2\" content=\"6 ph\u00fat\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/vieclamketoan.vn\/blog\/ham-excel-nang-cao\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/vieclamketoan.vn\/blog\/ham-excel-nang-cao\/\"},\"author\":{\"name\":\"Ng\u1ecdc \u00c1nh\",\"@id\":\"https:\/\/vieclamketoan.vn\/blog\/#\/schema\/person\/31432a9a17bcae995820bfdcb4f5936b\"},\"headline\":\"T\u1ed5ng h\u1ee3p 5 nh\u00f3m h\u00e0m excel n\u00e2ng cao trong k\u1ebf to\u00e1n b\u1ea1n c\u1ea7n bi\u1ebft\",\"datePublished\":\"2022-11-06T03:10:35+00:00\",\"dateModified\":\"2022-12-01T02:57:24+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/vieclamketoan.vn\/blog\/ham-excel-nang-cao\/\"},\"wordCount\":1636,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/vieclamketoan.vn\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/vieclamketoan.vn\/blog\/ham-excel-nang-cao\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/vieclamketoan.vn\/blog\/wp-content\/uploads\/2022\/11\/ham-excel-nang-cao-topcv.jpg\",\"keywords\":[\"c\u00e1c h\u00e0m excel n\u00e2ng cao\",\"C\u00e1c h\u00e0m Excel n\u00e2ng cao trong k\u1ebf to\u00e1n\",\"Excel n\u00e2ng cao cho k\u1ebf to\u00e1n\",\"Excel n\u00e2ng cao cho ng\u01b0\u1eddi \u0111i l\u00e0m\",\"Excel n\u00e2ng cao g\u1ed3m nh\u1eefng g\u00ec\",\"h\u00e0m Excel n\u00e2ng cao\"],\"articleSection\":[\"Chia s\u1ebb kinh nghi\u1ec7m\"],\"inLanguage\":\"vi\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/vieclamketoan.vn\/blog\/ham-excel-nang-cao\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/vieclamketoan.vn\/blog\/ham-excel-nang-cao\/\",\"url\":\"https:\/\/vieclamketoan.vn\/blog\/ham-excel-nang-cao\/\",\"name\":\"T\u1ed5ng h\u1ee3p 5 nh\u00f3m h\u00e0m excel n\u00e2ng cao trong k\u1ebf to\u00e1n b\u1ea1n c\u1ea7n bi\u1ebft\",\"isPartOf\":{\"@id\":\"https:\/\/vieclamketoan.vn\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/vieclamketoan.vn\/blog\/ham-excel-nang-cao\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/vieclamketoan.vn\/blog\/ham-excel-nang-cao\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/vieclamketoan.vn\/blog\/wp-content\/uploads\/2022\/11\/ham-excel-nang-cao-topcv.jpg\",\"datePublished\":\"2022-11-06T03:10:35+00:00\",\"dateModified\":\"2022-12-01T02:57:24+00:00\",\"description\":\"H\u00e3y c\u00f9ng Vieclamketoan t\u00ecm hi\u1ec3u Top 5+ nh\u00f3m h\u00e0m Excel n\u00e2ng cao m\u00e0 nh\u00e2n vi\u00ean k\u1ebf to\u00e1n n\u00ean bi\u1ebft v\u00e0 s\u1eed d\u1ee5ng th\u00e0nh th\u1ea1o ngay sau \u0111\u00e2y nh\u00e9.\",\"breadcrumb\":{\"@id\":\"https:\/\/vieclamketoan.vn\/blog\/ham-excel-nang-cao\/#breadcrumb\"},\"inLanguage\":\"vi\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/vieclamketoan.vn\/blog\/ham-excel-nang-cao\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\/\/vieclamketoan.vn\/blog\/ham-excel-nang-cao\/#primaryimage\",\"url\":\"https:\/\/vieclamketoan.vn\/blog\/wp-content\/uploads\/2022\/11\/ham-excel-nang-cao-topcv.jpg\",\"contentUrl\":\"https:\/\/vieclamketoan.vn\/blog\/wp-content\/uploads\/2022\/11\/ham-excel-nang-cao-topcv.jpg\",\"width\":800,\"height\":500,\"caption\":\"T\u1ed5ng h\u1ee3p 5 nh\u00f3m h\u00e0m excel n\u00e2ng cao trong k\u1ebf to\u00e1n b\u1ea1n c\u1ea7n bi\u1ebft\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/vieclamketoan.vn\/blog\/ham-excel-nang-cao\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Trang ch\u1ee7\",\"item\":\"https:\/\/vieclamketoan.vn\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"T\u1ed5ng h\u1ee3p 5 nh\u00f3m h\u00e0m excel n\u00e2ng cao trong k\u1ebf to\u00e1n b\u1ea1n c\u1ea7n bi\u1ebft\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/vieclamketoan.vn\/blog\/#website\",\"url\":\"https:\/\/vieclamketoan.vn\/blog\/\",\"name\":\"Vieclamketoan\",\"description\":\"Chia s\u1ebb kinh nghi\u1ec7m l\u00e0m vi\u1ec7c v\u00e0 vi\u1ec7c l\u00e0m k\u1ebf to\u00e1n m\u1edbi nh\u1ea5t\",\"publisher\":{\"@id\":\"https:\/\/vieclamketoan.vn\/blog\/#organization\"},\"alternateName\":\"Vieclamketoan\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/vieclamketoan.vn\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"vi\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/vieclamketoan.vn\/blog\/#organization\",\"name\":\"Vi\u1ec7c l\u00e0m K\u1ebf to\u00e1n\",\"alternateName\":\"Vieclamketoan\",\"url\":\"https:\/\/vieclamketoan.vn\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\/\/vieclamketoan.vn\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/vieclamketoan.vn\/blog\/wp-content\/uploads\/2023\/05\/viec-lam-ke-toan-logo-1.png\",\"contentUrl\":\"https:\/\/vieclamketoan.vn\/blog\/wp-content\/uploads\/2023\/05\/viec-lam-ke-toan-logo-1.png\",\"width\":400,\"height\":400,\"caption\":\"Vi\u1ec7c l\u00e0m K\u1ebf to\u00e1n\"},\"image\":{\"@id\":\"https:\/\/vieclamketoan.vn\/blog\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/vieclamketoan.vn\/blog\/#\/schema\/person\/31432a9a17bcae995820bfdcb4f5936b\",\"name\":\"Ng\u1ecdc \u00c1nh\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\/\/vieclamketoan.vn\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/4c9ee0e07b049e57de923e869c752ef7?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/4c9ee0e07b049e57de923e869c752ef7?s=96&d=mm&r=g\",\"caption\":\"Ng\u1ecdc \u00c1nh\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"T\u1ed5ng h\u1ee3p 5 nh\u00f3m h\u00e0m excel n\u00e2ng cao trong k\u1ebf to\u00e1n b\u1ea1n c\u1ea7n bi\u1ebft","description":"H\u00e3y c\u00f9ng Vieclamketoan t\u00ecm hi\u1ec3u Top 5+ nh\u00f3m h\u00e0m Excel n\u00e2ng cao m\u00e0 nh\u00e2n vi\u00ean k\u1ebf to\u00e1n n\u00ean bi\u1ebft v\u00e0 s\u1eed d\u1ee5ng th\u00e0nh th\u1ea1o ngay sau \u0111\u00e2y nh\u00e9.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/vieclamketoan.vn\/blog\/ham-excel-nang-cao\/","og_locale":"vi_VN","og_type":"article","og_title":"T\u1ed5ng h\u1ee3p 5 nh\u00f3m h\u00e0m excel n\u00e2ng cao trong k\u1ebf to\u00e1n b\u1ea1n c\u1ea7n bi\u1ebft","og_description":"H\u00e3y c\u00f9ng Vieclamketoan t\u00ecm hi\u1ec3u Top 5+ nh\u00f3m h\u00e0m Excel n\u00e2ng cao m\u00e0 nh\u00e2n vi\u00ean k\u1ebf to\u00e1n n\u00ean bi\u1ebft v\u00e0 s\u1eed d\u1ee5ng th\u00e0nh th\u1ea1o ngay sau \u0111\u00e2y nh\u00e9.","og_url":"https:\/\/vieclamketoan.vn\/blog\/ham-excel-nang-cao\/","og_site_name":"vieclamketoan","article_published_time":"2022-11-06T03:10:35+00:00","article_modified_time":"2022-12-01T02:57:24+00:00","og_image":[{"width":800,"height":500,"url":"https:\/\/vieclamketoan.vn\/blog\/wp-content\/uploads\/2022\/11\/ham-excel-nang-cao-topcv.jpg","type":"image\/jpeg"}],"author":"Ng\u1ecdc \u00c1nh","twitter_card":"summary_large_image","twitter_misc":{"\u0110\u01b0\u1ee3c vi\u1ebft b\u1edfi":"Ng\u1ecdc \u00c1nh","\u01af\u1edbc t\u00ednh th\u1eddi gian \u0111\u1ecdc":"6 ph\u00fat"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/vieclamketoan.vn\/blog\/ham-excel-nang-cao\/#article","isPartOf":{"@id":"https:\/\/vieclamketoan.vn\/blog\/ham-excel-nang-cao\/"},"author":{"name":"Ng\u1ecdc \u00c1nh","@id":"https:\/\/vieclamketoan.vn\/blog\/#\/schema\/person\/31432a9a17bcae995820bfdcb4f5936b"},"headline":"T\u1ed5ng h\u1ee3p 5 nh\u00f3m h\u00e0m excel n\u00e2ng cao trong k\u1ebf to\u00e1n b\u1ea1n c\u1ea7n bi\u1ebft","datePublished":"2022-11-06T03:10:35+00:00","dateModified":"2022-12-01T02:57:24+00:00","mainEntityOfPage":{"@id":"https:\/\/vieclamketoan.vn\/blog\/ham-excel-nang-cao\/"},"wordCount":1636,"commentCount":0,"publisher":{"@id":"https:\/\/vieclamketoan.vn\/blog\/#organization"},"image":{"@id":"https:\/\/vieclamketoan.vn\/blog\/ham-excel-nang-cao\/#primaryimage"},"thumbnailUrl":"https:\/\/vieclamketoan.vn\/blog\/wp-content\/uploads\/2022\/11\/ham-excel-nang-cao-topcv.jpg","keywords":["c\u00e1c h\u00e0m excel n\u00e2ng cao","C\u00e1c h\u00e0m Excel n\u00e2ng cao trong k\u1ebf to\u00e1n","Excel n\u00e2ng cao cho k\u1ebf to\u00e1n","Excel n\u00e2ng cao cho ng\u01b0\u1eddi \u0111i l\u00e0m","Excel n\u00e2ng cao g\u1ed3m nh\u1eefng g\u00ec","h\u00e0m Excel n\u00e2ng cao"],"articleSection":["Chia s\u1ebb kinh nghi\u1ec7m"],"inLanguage":"vi","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/vieclamketoan.vn\/blog\/ham-excel-nang-cao\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/vieclamketoan.vn\/blog\/ham-excel-nang-cao\/","url":"https:\/\/vieclamketoan.vn\/blog\/ham-excel-nang-cao\/","name":"T\u1ed5ng h\u1ee3p 5 nh\u00f3m h\u00e0m excel n\u00e2ng cao trong k\u1ebf to\u00e1n b\u1ea1n c\u1ea7n bi\u1ebft","isPartOf":{"@id":"https:\/\/vieclamketoan.vn\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/vieclamketoan.vn\/blog\/ham-excel-nang-cao\/#primaryimage"},"image":{"@id":"https:\/\/vieclamketoan.vn\/blog\/ham-excel-nang-cao\/#primaryimage"},"thumbnailUrl":"https:\/\/vieclamketoan.vn\/blog\/wp-content\/uploads\/2022\/11\/ham-excel-nang-cao-topcv.jpg","datePublished":"2022-11-06T03:10:35+00:00","dateModified":"2022-12-01T02:57:24+00:00","description":"H\u00e3y c\u00f9ng Vieclamketoan t\u00ecm hi\u1ec3u Top 5+ nh\u00f3m h\u00e0m Excel n\u00e2ng cao m\u00e0 nh\u00e2n vi\u00ean k\u1ebf to\u00e1n n\u00ean bi\u1ebft v\u00e0 s\u1eed d\u1ee5ng th\u00e0nh th\u1ea1o ngay sau \u0111\u00e2y nh\u00e9.","breadcrumb":{"@id":"https:\/\/vieclamketoan.vn\/blog\/ham-excel-nang-cao\/#breadcrumb"},"inLanguage":"vi","potentialAction":[{"@type":"ReadAction","target":["https:\/\/vieclamketoan.vn\/blog\/ham-excel-nang-cao\/"]}]},{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/vieclamketoan.vn\/blog\/ham-excel-nang-cao\/#primaryimage","url":"https:\/\/vieclamketoan.vn\/blog\/wp-content\/uploads\/2022\/11\/ham-excel-nang-cao-topcv.jpg","contentUrl":"https:\/\/vieclamketoan.vn\/blog\/wp-content\/uploads\/2022\/11\/ham-excel-nang-cao-topcv.jpg","width":800,"height":500,"caption":"T\u1ed5ng h\u1ee3p 5 nh\u00f3m h\u00e0m excel n\u00e2ng cao trong k\u1ebf to\u00e1n b\u1ea1n c\u1ea7n bi\u1ebft"},{"@type":"BreadcrumbList","@id":"https:\/\/vieclamketoan.vn\/blog\/ham-excel-nang-cao\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Trang ch\u1ee7","item":"https:\/\/vieclamketoan.vn\/blog\/"},{"@type":"ListItem","position":2,"name":"T\u1ed5ng h\u1ee3p 5 nh\u00f3m h\u00e0m excel n\u00e2ng cao trong k\u1ebf to\u00e1n b\u1ea1n c\u1ea7n bi\u1ebft"}]},{"@type":"WebSite","@id":"https:\/\/vieclamketoan.vn\/blog\/#website","url":"https:\/\/vieclamketoan.vn\/blog\/","name":"Vieclamketoan","description":"Chia s\u1ebb kinh nghi\u1ec7m l\u00e0m vi\u1ec7c v\u00e0 vi\u1ec7c l\u00e0m k\u1ebf to\u00e1n m\u1edbi nh\u1ea5t","publisher":{"@id":"https:\/\/vieclamketoan.vn\/blog\/#organization"},"alternateName":"Vieclamketoan","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/vieclamketoan.vn\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"vi"},{"@type":"Organization","@id":"https:\/\/vieclamketoan.vn\/blog\/#organization","name":"Vi\u1ec7c l\u00e0m K\u1ebf to\u00e1n","alternateName":"Vieclamketoan","url":"https:\/\/vieclamketoan.vn\/blog\/","logo":{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/vieclamketoan.vn\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/vieclamketoan.vn\/blog\/wp-content\/uploads\/2023\/05\/viec-lam-ke-toan-logo-1.png","contentUrl":"https:\/\/vieclamketoan.vn\/blog\/wp-content\/uploads\/2023\/05\/viec-lam-ke-toan-logo-1.png","width":400,"height":400,"caption":"Vi\u1ec7c l\u00e0m K\u1ebf to\u00e1n"},"image":{"@id":"https:\/\/vieclamketoan.vn\/blog\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/vieclamketoan.vn\/blog\/#\/schema\/person\/31432a9a17bcae995820bfdcb4f5936b","name":"Ng\u1ecdc \u00c1nh","image":{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/vieclamketoan.vn\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/4c9ee0e07b049e57de923e869c752ef7?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/4c9ee0e07b049e57de923e869c752ef7?s=96&d=mm&r=g","caption":"Ng\u1ecdc \u00c1nh"}}]}},"_links":{"self":[{"href":"https:\/\/vieclamketoan.vn\/blog\/wp-json\/wp\/v2\/posts\/2123","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/vieclamketoan.vn\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/vieclamketoan.vn\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/vieclamketoan.vn\/blog\/wp-json\/wp\/v2\/users\/6"}],"replies":[{"embeddable":true,"href":"https:\/\/vieclamketoan.vn\/blog\/wp-json\/wp\/v2\/comments?post=2123"}],"version-history":[{"count":6,"href":"https:\/\/vieclamketoan.vn\/blog\/wp-json\/wp\/v2\/posts\/2123\/revisions"}],"predecessor-version":[{"id":2461,"href":"https:\/\/vieclamketoan.vn\/blog\/wp-json\/wp\/v2\/posts\/2123\/revisions\/2461"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/vieclamketoan.vn\/blog\/wp-json\/wp\/v2\/media\/2124"}],"wp:attachment":[{"href":"https:\/\/vieclamketoan.vn\/blog\/wp-json\/wp\/v2\/media?parent=2123"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/vieclamketoan.vn\/blog\/wp-json\/wp\/v2\/categories?post=2123"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/vieclamketoan.vn\/blog\/wp-json\/wp\/v2\/tags?post=2123"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}