{"id":2129,"date":"2022-11-06T03:18:31","date_gmt":"2022-11-06T03:18:31","guid":{"rendered":"https:\/\/vieclamketoan.vn\/blog\/?p=2129"},"modified":"2022-11-25T14:22:46","modified_gmt":"2022-11-25T14:22:46","slug":"cac-ham-excel-thong-dung-trong-ke-toan","status":"publish","type":"post","link":"https:\/\/vieclamketoan.vn\/blog\/cac-ham-excel-thong-dung-trong-ke-toan\/","title":{"rendered":"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"},"content":{"rendered":"\n<p>Excel l\u00e0 m\u1ed9t trong nh\u1eefng c\u00f4ng c\u1ee5 m\u00e0 k\u1ebf to\u00e1n vi\u00ean n\u00e0o c\u0169ng ph\u1ea3i th\u00e0nh th\u1ea1o. H\u00e3y c\u00f9ng <a href=\"https:\/\/vieclamketoan.vn\/\" target=\"_blank\" rel=\"noreferrer noopener\"><strong>Vieclamketoan<\/strong><\/a> t\u00ecm hi\u1ec3u <strong><a href=\"https:\/\/vieclamketoan.vn\/blog\/cac-ham-excel-thong-dung-trong-ke-toan\/\" target=\"_blank\" rel=\"noreferrer noopener\">c\u00e1c h\u00e0m Excel th\u00f4ng d\u1ee5ng trong k\u1ebf to\u00e1n<\/a><\/strong> ngay trong b\u00e0i vi\u1ebft h\u00f4m nay 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-69cfeafd46c15\" ><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-69cfeafd46c15\"  type=\"checkbox\" id=\"item-69cfeafd46c15\"><\/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\/cac-ham-excel-thong-dung-trong-ke-toan\/#Loi_ich_cua_Excel_trong_ke_toan\" title=\"L\u1ee3i \u00edch c\u1ee7a Excel trong k\u1ebf to\u00e1n\">L\u1ee3i \u00edch c\u1ee7a Excel trong k\u1ebf to\u00e1n<\/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\/cac-ham-excel-thong-dung-trong-ke-toan\/#Tong_hop_cac_ham_Excel_thong_dung_trong_ke_toan\" title=\"T\u1ed5ng h\u1ee3p c\u00e1c h\u00e0m Excel th\u00f4ng d\u1ee5ng trong k\u1ebf to\u00e1n\">T\u1ed5ng h\u1ee3p c\u00e1c h\u00e0m Excel th\u00f4ng d\u1ee5ng trong k\u1ebf to\u00e1n<\/a><ul class='ez-toc-list-level-3'><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/vieclamketoan.vn\/blog\/cac-ham-excel-thong-dung-trong-ke-toan\/#Ham_SUMIF\" title=\"H\u00e0m SUMIF\">H\u00e0m SUMIF<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/vieclamketoan.vn\/blog\/cac-ham-excel-thong-dung-trong-ke-toan\/#Ham_VLOOKUP\" title=\"H\u00e0m VLOOKUP\">H\u00e0m VLOOKUP<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/vieclamketoan.vn\/blog\/cac-ham-excel-thong-dung-trong-ke-toan\/#Ham_IF\" title=\"H\u00e0m IF\">H\u00e0m IF<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/vieclamketoan.vn\/blog\/cac-ham-excel-thong-dung-trong-ke-toan\/#Ham_MAXMIN\" title=\"H\u00e0m MAX\/MIN\">H\u00e0m MAX\/MIN<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/vieclamketoan.vn\/blog\/cac-ham-excel-thong-dung-trong-ke-toan\/#Ham_COUNTIF\" title=\"H\u00e0m COUNTIF\">H\u00e0m COUNTIF<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/vieclamketoan.vn\/blog\/cac-ham-excel-thong-dung-trong-ke-toan\/#Ham_SUBTOTAL\" title=\"H\u00e0m SUBTOTAL\">H\u00e0m SUBTOTAL<\/a><\/li><\/ul><\/li><\/ul><\/nav><\/div>\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Loi_ich_cua_Excel_trong_ke_toan\"><\/span><strong>L\u1ee3i \u00edch c\u1ee7a Excel trong k\u1ebf to\u00e1n<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Excel l\u00e0 m\u1ed9t trong nh\u1eefng ph\u1ea7n m\u1ec1m cung c\u1ea5p nh\u1eefng t\u00ednh n\u0103ng t\u00ednh to\u00e1n, t\u1ed5 ch\u1ee9c, \u0111\u00e1nh gi\u00e1 d\u1eef li\u1ec7u cho ng\u01b0\u1eddi d\u00f9ng. \u0110\u1eb7c bi\u1ec7t, \u0111\u00e2y l\u00e0 ph\u1ea7n m\u1ec1m &#8211; c\u00f4ng c\u1ee5 r\u1ea5t quan tr\u1ecdng v\u1edbi ng\u00e0nh k\u1ebf to\u00e1n. M\u1ed9t s\u1ed1 l\u1ee3i \u00edch ph\u1ed5 bi\u1ebfn c\u1ee7a Excel c\u00f3 th\u1ec3 k\u1ec3 \u0111\u1ebfn nh\u01b0:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Gi\u00fap l\u01b0u gi\u1eef th\u00f4ng tin an to\u00e0n cho n\u1ed9i b\u1ed9 doanh nghi\u1ec7p. \u0110\u1eb7c bi\u1ec7t l\u00e0 nh\u1eefng th\u00f4ng tin li\u00ean quan \u0111\u1ebfn t\u00e0i ch\u00ednh, s\u1ed1 li\u1ec7u c\u1ee7a doanh nghi\u1ec7p.<\/li>\n\n\n\n<li>D\u1ec5 d\u00e0ng \u0111\u1ec3 t\u00ednh to\u00e1n v\u1edbi nh\u1eefng h\u00e0m c\u00f4ng th\u1ee9c nhanh g\u1ecdi. \u0110i\u1ec1u h\u01b0\u1edbng h\u1ec7 th\u1ed1ng nhanh h\u01a1n cho c\u00e1c s\u1ed1 li\u1ec7u ph\u1ee9c t\u1ea1p ho\u1eb7c nhi\u1ec1u s\u1ed1 li\u1ec7u.<\/li>\n\n\n\n<li>C\u00f3 th\u1ec3 s\u1eed d\u1ee5ng Excel tr\u00ean nhi\u1ec1u ch\u01b0\u01a1ng tr\u00ecnh, ph\u1ea7n m\u1ec1m k\u1ebf to\u00e1n kh\u00e1c nhau, gi\u1ea3m thi\u1ec3u th\u1eddi gian nh\u1eadp c\u00e1c th\u00f4ng tin.<\/li>\n\n\n\n<li>Cho ph\u00e9p s\u1eafp x\u1ebfp quy tr\u00ecnh l\u00e0m vi\u1ec7c \u0111\u01b0\u1ee3c t\u1ed1t v\u00e0 linh \u0111\u1ed9ng h\u01a1n.<\/li>\n\n\n\n<li>Gi\u00fap t\u1ed1i \u01b0u h\u00f3a c\u00f4ng vi\u1ec7c c\u1ee7a k\u1ebf to\u00e1n, t\u1ed5 ch\u1ee9c d\u1eef li\u1ec7u khoa h\u1ecdc h\u01a1n, \u0111\u1ea1t \u0111\u01b0\u1ee3c hi\u1ec7u su\u1ea5t cao h\u01a1n so v\u1edbi th\u00f4ng th\u01b0\u1eddng.<\/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<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\/cac-ham-excel-thong-dung-trong-ke-toan-topcv-1.jpg\" alt=\"Excel l\u00e0 m\u1ed9t c\u00f4ng c\u1ee5 mang l\u1ea1i nhi\u1ec1u l\u1ee3i \u00edch cho nh\u00e2n vi\u00ean k\u1ebf to\u00e1n\" class=\"wp-image-2452\" srcset=\"https:\/\/vieclamketoan.vn\/blog\/wp-content\/uploads\/2022\/11\/cac-ham-excel-thong-dung-trong-ke-toan-topcv-1.jpg 800w, https:\/\/vieclamketoan.vn\/blog\/wp-content\/uploads\/2022\/11\/cac-ham-excel-thong-dung-trong-ke-toan-topcv-1-640x400.jpg 640w, https:\/\/vieclamketoan.vn\/blog\/wp-content\/uploads\/2022\/11\/cac-ham-excel-thong-dung-trong-ke-toan-topcv-1-768x480.jpg 768w\" sizes=\"auto, (max-width: 800px) 100vw, 800px\" \/><figcaption class=\"wp-element-caption\"><em>Excel l\u00e0 m\u1ed9t c\u00f4ng c\u1ee5 mang l\u1ea1i nhi\u1ec1u l\u1ee3i \u00edch cho nh\u00e2n vi\u00ean k\u1ebf to\u00e1n<\/em><\/figcaption><\/figure><\/div>\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Tong_hop_cac_ham_Excel_thong_dung_trong_ke_toan\"><\/span><strong>T\u1ed5ng h\u1ee3p c\u00e1c h\u00e0m Excel th\u00f4ng d\u1ee5ng trong k\u1ebf to\u00e1n<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>C\u00f3 r\u1ea5t nhi\u1ec1u h\u00e0m Excel \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng trong k\u1ebf to\u00e1n. Tuy v\u1eady, b\u1ea1n c\u00f3 th\u1ec3 tham kh\u1ea3o ngay c\u00e1c h\u00e0m Excel th\u00f4ng d\u1ee5ng trong k\u1ebf to\u00e1n \u0111\u01b0\u1ee3c t\u1ed5ng h\u1ee3p ngay sau \u0111\u00e2y:<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Ham_SUMIF\"><\/span><strong>H\u00e0m SUMIF<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>SUMIF l\u00e0 c\u00e1c h\u00e0m \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 t\u00ednh t\u1ed5ng cho nh\u1eefng gi\u00e1 tr\u1ecb th\u1ecfa m\u00e3n \u0111i\u1ec1u ki\u1ec7n n\u00e0o \u0111\u00f3. Trong \u0111\u00f3, h\u00e0m SUMIF c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng cho nh\u1eefng vi\u1ec7c t\u00ednh t\u1ed5ng theo ng\u00e0y, s\u1ed1 li\u1ec7u, v\u0103n b\u1ea3n,&#8230; t\u00f9y thu\u1ed9c v\u00e0o \u0111i\u1ec1u ki\u1ec7n \u0111\u01b0\u1ee3c cung c\u1ea5p.<\/p>\n\n\n\n<p>C\u00fa ph\u00e1p: <strong>=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: l\u00e0 ph\u1ea1m vi \u00f4 t\u00ednh mu\u1ed1n \u0111\u00e1nh gi\u00e1.<\/li>\n\n\n\n<li>Criteria: Ti\u00eau ch\u00ed b\u1eaft bu\u1ed9c d\u01b0\u1edbi d\u1ea1ng s\u1ed1, tham chi\u1ebfu \u00f4, bi\u1ec3u th\u1ee9c, v\u0103n b\u1ea3n ho\u1eb7c h\u00e0m x\u00e1c \u0111\u1ecbnh \u0111\u1ed1i v\u1edbi nh\u1eefng \u00f4 \u0111\u01b0\u1ee3c c\u1ed9ng.<\/li>\n\n\n\n<li>Sum_range: L\u00e0 tham s\u1ed1 t\u00f9y ch\u1ecdn, ch\u1ec9 c\u00e1c \u00f4 c\u1ea7n t\u00ednh t\u1ed5ng.&nbsp;<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Ham_VLOOKUP\"><\/span><strong>H\u00e0m VLOOKUP<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>VLOOKUP l\u00e0 m\u1ed9t trong c\u00e1c h\u00e0m <strong><a href=\"https:\/\/vieclamketoan.vn\/blog\/excel-ke-toan\/\" target=\"_blank\" rel=\"noreferrer noopener\">Excel k\u1ebf to\u00e1n<\/a><\/strong> th\u00f4ng d\u1ee5ng m\u00e0 b\u1ea1n n\u00ean t\u00ecm hi\u1ec3u. H\u00e0m n\u00e0y s\u1ebd gi\u00fap b\u1ea1n c\u00f3 th\u1ec3 d\u00f2 t\u00ecm d\u1eef li\u1ec7u trong b\u1ea3ng t\u00ednh, trong 1 ph\u1ea1m vi theo h\u00e0ng d\u1ecdc. Sau \u0111\u00f3 s\u1ebd tr\u1ea3 v\u1ec1 d\u1eef li\u1ec7u cho h\u00e0ng ngang t\u01b0\u01a1ng \u1ee9ng.<\/p>\n\n\n\n<p>C\u00fa ph\u00e1p:<strong> =VLOOKUP(Lookup_value, Table_array, Col_index_ num, Range_lookup)<\/strong><\/p>\n\n\n\n<p>Trong \u0111\u00f3:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Lookup_value: Gi\u00e1 tr\u1ecb b\u1ea1n mu\u1ed1n d\u00f2 t\u00ecm. B\u1ea1n c\u00f3 th\u1ec3 \u0111i\u1ec1n tr\u1ef1c ti\u1ebfp ho\u1eb7c tham chi\u1ebfu trong \u00f4 t\u00ednh.<\/li>\n\n\n\n<li>Table_array: B\u1ea3ng gi\u1edbi h\u1ea1n d\u00f2 t\u00ecm.<\/li>\n\n\n\n<li>Col_index_ num: S\u1ed1 th\u1ee9 t\u1ef1 c\u1ee7a c\u1ed9t m\u00e0 b\u1ea1n s\u1ebd l\u1ea5y d\u1eef li\u1ec7u \u1edf b\u1ea3ng c\u1ea7n d\u00f2 t\u00ecm.<\/li>\n\n\n\n<li>Range_lookup: T\u00ecm ki\u1ebfm ch\u00ednh x\u00e1c\/t\u00ecm ki\u1ebfm t\u01b0\u01a1ng \u0111\u1ed1i trong b\u1ea3ng gi\u1edbi h\u1ea1n. N\u1ebfu gi\u00e1 tr\u1ecb n\u00e0y = 1 (True) s\u1ebd l\u00e0 d\u00f2 t\u00ecm t\u01b0\u01a1ng \u0111\u1ed1i, n\u1ebfu gi\u00e1 tr\u1ecb n\u00e0y = 0 (False) d\u00f2 t\u00ecm ch\u00ednh x\u00e1c.<\/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\/cac-ham-excel-thong-dung-trong-ke-toan-topcv-2.jpg\" alt=\"H\u00e0m VLOOKUP gi\u00fap b\u1ea1n t\u00ecm ki\u1ebfm \u0111\u01b0\u1ee3c d\u1eef li\u1ec7u trong b\u1ea3ng t\u00ednh Excel\" class=\"wp-image-2453\" srcset=\"https:\/\/vieclamketoan.vn\/blog\/wp-content\/uploads\/2022\/11\/cac-ham-excel-thong-dung-trong-ke-toan-topcv-2.jpg 800w, https:\/\/vieclamketoan.vn\/blog\/wp-content\/uploads\/2022\/11\/cac-ham-excel-thong-dung-trong-ke-toan-topcv-2-640x400.jpg 640w, https:\/\/vieclamketoan.vn\/blog\/wp-content\/uploads\/2022\/11\/cac-ham-excel-thong-dung-trong-ke-toan-topcv-2-768x480.jpg 768w\" sizes=\"auto, (max-width: 800px) 100vw, 800px\" \/><figcaption class=\"wp-element-caption\"><em>H\u00e0m VLOOKUP gi\u00fap b\u1ea1n t\u00ecm ki\u1ebfm \u0111\u01b0\u1ee3c d\u1eef li\u1ec7u trong b\u1ea3ng t\u00ednh Excel<\/em><\/figcaption><\/figure><\/div>\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Ham_IF\"><\/span><strong>H\u00e0m IF<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>IF c\u0169ng l\u00e0 c\u00e1c h\u00e0m Excel th\u00f4ng d\u1ee5ng trong k\u1ebf to\u00e1n ph\u1ed5 bi\u1ebfn hi\u1ec7n nay. H\u00e0m n\u00e0y s\u1ebd cho ph\u00e9p b\u1ea1n c\u00f3 th\u1ec3 so s\u00e1nh logic gi\u00e1 tr\u1ecb n\u00e0y v\u1edbi gi\u00e1 tr\u1ecb kh\u00e1c m\u00e0 b\u1ea1n mong mu\u1ed1n.&nbsp;<\/p>\n\n\n\n<p>C\u1ea5u tr\u00fac:<strong> =IF(Logical_test;Value_if_true;Value_if_false)<\/strong><\/p>\n\n\n\n<p>Trong \u0111\u00f3:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Logical_test: \u0110i\u1ec1u ki\u1ec7n so s\u00e1nh.<\/li>\n\n\n\n<li>Value_if_true: Gi\u00e1 tr\u1ecb tr\u1ea3 v\u1ec1 n\u1ebfu th\u1ecfa m\u00e3n \u0111i\u1ec1u ki\u1ec7n so s\u00e1nh.<\/li>\n\n\n\n<li>Value_if_false: Gi\u00e1 tr\u1ecb tr\u1ea3 v\u1ec1 khi kh\u00f4ng th\u1ecfa m\u00e3n \u0111i\u1ec1u ki\u1ec7n.<\/li>\n\n\n\n<li>N\u1ebfu b\u1ecf tr\u1ed1ng Value_if_true v\u00e0 Value_if_false, khi th\u1ecfa m\u00e3n \u0111i\u1ec1u ki\u1ec7n s\u1ebd c\u00f3 gi\u00e1 tr\u1ecb tr\u1ea3 v\u1ec1 l\u00e0 0, kh\u00f4ng th\u1ecfa m\u00e3n s\u1ebd tr\u1ea3 v\u1ec1 False.<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Ham_MAXMIN\"><\/span><strong>H\u00e0m MAX\/MIN<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>H\u00e0m MIN, MAX \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng khi k\u1ebf to\u00e1n vi\u00ean mu\u1ed1n t\u00ednh nh\u1eefng gi\u00e1 tr\u1ecb l\u1edbn nh\u1ea5t, nh\u1ecf nh\u1ea5t trong b\u1ea3ng Excel. C\u00fa ph\u00e1p c\u1ee7a 2 h\u00e0m nh\u01b0 sau:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>=MAX(number1, number2,&#8230;)<\/strong>: Trong \u0111\u00f3 number1, number2 l\u00e0 nh\u1eefng gi\u00e1 tr\u1ecb m\u00e0 b\u1ea1n c\u1ea7n so s\u00e1nh.<\/li>\n\n\n\n<li><strong>=MIN(number1, number2,&#8230;)<\/strong>: Trong \u0111\u00f3 number1, number2 l\u00e0 nh\u1eefng gi\u00e1 tr\u1ecb m\u00e0 b\u1ea1n c\u1ea7n so s\u00e1nh.<\/li>\n\n\n\n<li>N\u1ebfu tham s\u1ed1 \u0111\u01b0\u1ee3c cung c\u1ea5p kh\u00f4ng ph\u1ea3i gi\u00e1 tr\u1ecb s\u1ed1 s\u1ebd tr\u1ea3 v\u1ec1 l\u1ed7i #Value, n\u1ebfu c\u00e1c \u0111\u1ed1i s\u1ed1 kh\u00f4ng ch\u1ee9a s\u1ed1 s\u1ebd tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb 0. H\u00e0m MIN\/MAX s\u1ebd b\u1ecf qua nh\u1eefng \u00f4 tr\u1ed1ng kh\u00f4ng c\u00f3 ch\u1ee9a gi\u00e1 tr\u1ecb.<\/li>\n<\/ul>\n\n\n\n<p><strong>T\u00ecm hi\u1ec3u th\u00eam: <a href=\"https:\/\/vieclamketoan.vn\/blog\/ham-excel-nang-cao\/\" target=\"_blank\" rel=\"noreferrer noopener\">5 nh\u00f3m h\u00e0m excel n\u00e2ng cao trong k\u1ebf to\u00e1n b\u1ea1n c\u1ea7n bi\u1ebft<\/a><\/strong><\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Ham_COUNTIF\"><\/span><strong>H\u00e0m COUNTIF<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>COUNTIF l\u00e0 h\u00e0m \u0111\u1ebfm c\u00f3 \u0111i\u1ec1u ki\u1ec7n v\u00e0 c\u0169ng l\u00e0 m\u1ed9t trong c\u00e1c h\u00e0m Excel th\u00f4ng d\u1ee5ng trong k\u1ebf to\u00e1n hi\u1ec7n nay. B\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng h\u00e0m&nbsp; COUNTIF \u0111\u1ec3 \u0111\u1ebfm \u00f4 tr\u00f9ng l\u1eb7p, \u0111\u1ebfm d\u1eef li\u1ec7u,&#8230;<\/p>\n\n\n\n<p>C\u00fa ph\u00e1p: <strong>=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 c\u1ea7n \u0111\u1ebfm d\u1eef li\u1ec7u.<\/li>\n\n\n\n<li>Criteria: \u0110i\u1ec1u ki\u1ec7n m\u00e0 b\u1ea1n s\u1eed d\u1ee5ng \u0111\u1ec3 \u0111\u1ebfm d\u1eef li\u1ec7u, kh\u00f4ng ph\u00e2n bi\u1ec7t ch\u1eef th\u01b0\u1eddng, ch\u1eef hoa.<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Ham_SUBTOTAL\"><\/span><strong>H\u00e0m SUBTOTAL<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>SUBTOTAL l\u00e0 h\u00e0m s\u1eed d\u1ee5ng \u0111\u1ec3 t\u00ednh t\u1ed5ng, \u0111\u1ebfm nh\u1eefng \u00f4 kh\u00f4ng tr\u1ed1ng \u1edf 1 v\u00f9ng d\u1eef li\u1ec7u n\u00e0o \u0111\u00f3, \u0111\u00e1nh s\u1ed1 t\u1ef1 \u0111\u1ed9ng,&#8230; Hi\u1ec7n t\u1ea1i, SUBTOTAL \u0111\u01b0\u1ee3c c\u00e1c k\u1ebf to\u00e1n vi\u00ean s\u1eed d\u1ee5ng kh\u00e1 ph\u1ed5 bi\u1ebfn v\u00e0 gi\u00fap \u00edch cho c\u00f4ng vi\u1ec7c c\u1ee7a v\u1ecb tr\u00ed n\u00e0y.<\/p>\n\n\n\n<p>C\u00fa ph\u00e1p:<strong> =SUBTOTAL(function_num, ref1, ref2,\u2026)<\/strong><\/p>\n\n\n\n<p>Trong \u0111\u00f3:&nbsp;<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Function_num: N\u1ebfu gi\u00e1 tr\u1ecb n\u00e0y t\u1eeb 1 &#8211; 11 th\u00ec h\u00e0m SUBTOTAL s\u1ebd th\u1ef1c hi\u1ec7n t\u00ednh to\u00e1n, bao g\u1ed3m c\u1ea3 nh\u1eefng gi\u00e1 tr\u1ecb b\u1ecb \u1ea9n trong v\u00f9ng d\u1eef li\u1ec7u c\u00f3 ch\u1ee9a nh\u1eefng gi\u00e1 tr\u1ecb \u1ea9n \u0111\u00f3. N\u1ebfu gi\u00e1 tr\u1ecb n\u00e0y t\u1eeb 101 &#8211; 111 th\u00ec h\u00e0m SUBTOTAL s\u1ebd b\u1ecf qua v\u00e0 kh\u00f4ng t\u00ednh c\u00e1c gi\u00e1 tr\u1ecb \u1ea9n.<\/li>\n\n\n\n<li>Ref1, ref2: V\u00f9ng \u00f4 \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 t\u00ednh t\u1ed5ng ph\u1ee5.<\/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\/cac-ham-excel-thong-dung-trong-ke-toan-topcv-3.jpg\" alt=\"Khi c\u1ea7n t\u00ednh t\u1ed5ng \u1edf 1 v\u00f9ng d\u1eef li\u1ec7u n\u00e0o \u0111\u00f3, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng SUBTOTAL\" class=\"wp-image-2455\" srcset=\"https:\/\/vieclamketoan.vn\/blog\/wp-content\/uploads\/2022\/11\/cac-ham-excel-thong-dung-trong-ke-toan-topcv-3.jpg 800w, https:\/\/vieclamketoan.vn\/blog\/wp-content\/uploads\/2022\/11\/cac-ham-excel-thong-dung-trong-ke-toan-topcv-3-640x400.jpg 640w, https:\/\/vieclamketoan.vn\/blog\/wp-content\/uploads\/2022\/11\/cac-ham-excel-thong-dung-trong-ke-toan-topcv-3-768x480.jpg 768w\" sizes=\"auto, (max-width: 800px) 100vw, 800px\" \/><figcaption class=\"wp-element-caption\"><em>Khi c\u1ea7n t\u00ednh t\u1ed5ng \u1edf 1 v\u00f9ng d\u1eef li\u1ec7u n\u00e0o \u0111\u00f3, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng SUBTOTAL<\/em><\/figcaption><\/figure><\/div>\n\n\n<p>Hy v\u1ecdng v\u1edbi nh\u1eefng <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> h\u00f4m nay, b\u1ea1n s\u1ebd hi\u1ec3u v\u00e0 s\u1eed d\u1ee5ng \u0111\u01b0\u1ee3c <strong>c\u00e1c h\u00e0m Excel th\u00f4ng d\u1ee5ng trong k\u1ebf to\u00e1n<\/strong>. \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-kho-lam-gi\/\" target=\"_blank\" rel=\"noreferrer noopener\">Nhi\u1ec7m v\u1ee5 k\u1ebf to\u00e1n kho l\u00e0 g\u00ec? C\u00f4ng vi\u1ec7c c\u1ee7a k\u1ebf to\u00e1n kho c\u00f3 v\u1ea5t v\u1ea3 kh\u00f4ng?<\/a><\/strong><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Excel l\u00e0 m\u1ed9t trong nh\u1eefng c\u00f4ng c\u1ee5 m\u00e0 k\u1ebf to\u00e1n vi\u00ean n\u00e0o c\u0169ng ph\u1ea3i th\u00e0nh th\u1ea1o. H\u00e3y c\u00f9ng Vieclamketoan t\u00ecm hi\u1ec3u c\u00e1c h\u00e0m Excel th\u00f4ng d\u1ee5ng trong k\u1ebf to\u00e1n ngay trong b\u00e0i vi\u1ebft h\u00f4m nay nh\u00e9. L\u1ee3i \u00edch c\u1ee7a Excel trong k\u1ebf to\u00e1n Excel l\u00e0 m\u1ed9t trong nh\u1eefng ph\u1ea7n m\u1ec1m cung c\u1ea5p nh\u1eefng t\u00ednh n\u0103ng [&hellip;]<\/p>\n","protected":false},"author":6,"featured_media":2451,"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":[723,720,725,721,722,724,644],"class_list":["post-2129","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-chia-se-kinh-nghiem","tag-cac-ham-excel-thong-dung","tag-cac-ham-excel-thong-dung-trong-ke-toan","tag-cac-ham-excel-trong-ke-toan-kho","tag-cac-ham-thong-dung-trong-excel-ke-toan","tag-excel-ke-toan","tag-excel-van-phong","tag-ke-toan"],"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 c\u00e1c h\u00e0m Excel th\u00f4ng d\u1ee5ng trong k\u1ebf to\u00e1n newbie c\u1ea7n n\u1eafm r\u00f5<\/title>\n<meta name=\"description\" content=\"Excel l\u00e0 c\u00f4ng c\u1ee5 m\u00e0 k\u1ebf to\u00e1n vi\u00ean n\u00e0o c\u0169ng ph\u1ea3i th\u00e0nh th\u1ea1o. H\u00e3y c\u00f9ng t\u00ecm hi\u1ec3u c\u00e1c h\u00e0m Excel th\u00f4ng d\u1ee5ng trong k\u1ebf to\u00e1n ngay 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\/cac-ham-excel-thong-dung-trong-ke-toan\/\" \/>\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 c\u00e1c h\u00e0m Excel th\u00f4ng d\u1ee5ng trong k\u1ebf to\u00e1n newbie c\u1ea7n n\u1eafm r\u00f5\" \/>\n<meta property=\"og:description\" content=\"Excel l\u00e0 c\u00f4ng c\u1ee5 m\u00e0 k\u1ebf to\u00e1n vi\u00ean n\u00e0o c\u0169ng ph\u1ea3i th\u00e0nh th\u1ea1o. H\u00e3y c\u00f9ng t\u00ecm hi\u1ec3u c\u00e1c h\u00e0m Excel th\u00f4ng d\u1ee5ng trong k\u1ebf to\u00e1n ngay nh\u00e9.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/vieclamketoan.vn\/blog\/cac-ham-excel-thong-dung-trong-ke-toan\/\" \/>\n<meta property=\"og:site_name\" content=\"vieclamketoan\" \/>\n<meta property=\"article:published_time\" content=\"2022-11-06T03:18:31+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-11-25T14:22:46+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/vieclamketoan.vn\/blog\/wp-content\/uploads\/2022\/11\/cac-ham-excel-thong-dung-trong-ke-toan-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\/cac-ham-excel-thong-dung-trong-ke-toan\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/vieclamketoan.vn\/blog\/cac-ham-excel-thong-dung-trong-ke-toan\/\"},\"author\":{\"name\":\"Ng\u1ecdc \u00c1nh\",\"@id\":\"https:\/\/vieclamketoan.vn\/blog\/#\/schema\/person\/31432a9a17bcae995820bfdcb4f5936b\"},\"headline\":\"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\",\"datePublished\":\"2022-11-06T03:18:31+00:00\",\"dateModified\":\"2022-11-25T14:22:46+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/vieclamketoan.vn\/blog\/cac-ham-excel-thong-dung-trong-ke-toan\/\"},\"wordCount\":1594,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/vieclamketoan.vn\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/vieclamketoan.vn\/blog\/cac-ham-excel-thong-dung-trong-ke-toan\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/vieclamketoan.vn\/blog\/wp-content\/uploads\/2022\/11\/cac-ham-excel-thong-dung-trong-ke-toan-topcv.jpg\",\"keywords\":[\"C\u00e1c h\u00e0m Excel th\u00f4ng d\u1ee5ng\",\"c\u00e1c h\u00e0m Excel th\u00f4ng d\u1ee5ng trong k\u1ebf to\u00e1n\",\"C\u00e1c h\u00e0m excel trong k\u1ebf to\u00e1n kho\",\"c\u00e1c h\u00e0m th\u00f4ng d\u1ee5ng trong excel k\u1ebf to\u00e1n\",\"excel k\u1ebf to\u00e1n\",\"excel v\u0103n ph\u00f2ng\",\"k\u1ebf to\u00e1n\"],\"articleSection\":[\"Chia s\u1ebb kinh nghi\u1ec7m\"],\"inLanguage\":\"vi\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/vieclamketoan.vn\/blog\/cac-ham-excel-thong-dung-trong-ke-toan\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/vieclamketoan.vn\/blog\/cac-ham-excel-thong-dung-trong-ke-toan\/\",\"url\":\"https:\/\/vieclamketoan.vn\/blog\/cac-ham-excel-thong-dung-trong-ke-toan\/\",\"name\":\"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\",\"isPartOf\":{\"@id\":\"https:\/\/vieclamketoan.vn\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/vieclamketoan.vn\/blog\/cac-ham-excel-thong-dung-trong-ke-toan\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/vieclamketoan.vn\/blog\/cac-ham-excel-thong-dung-trong-ke-toan\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/vieclamketoan.vn\/blog\/wp-content\/uploads\/2022\/11\/cac-ham-excel-thong-dung-trong-ke-toan-topcv.jpg\",\"datePublished\":\"2022-11-06T03:18:31+00:00\",\"dateModified\":\"2022-11-25T14:22:46+00:00\",\"description\":\"Excel l\u00e0 c\u00f4ng c\u1ee5 m\u00e0 k\u1ebf to\u00e1n vi\u00ean n\u00e0o c\u0169ng ph\u1ea3i th\u00e0nh th\u1ea1o. H\u00e3y c\u00f9ng t\u00ecm hi\u1ec3u c\u00e1c h\u00e0m Excel th\u00f4ng d\u1ee5ng trong k\u1ebf to\u00e1n ngay nh\u00e9.\",\"breadcrumb\":{\"@id\":\"https:\/\/vieclamketoan.vn\/blog\/cac-ham-excel-thong-dung-trong-ke-toan\/#breadcrumb\"},\"inLanguage\":\"vi\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/vieclamketoan.vn\/blog\/cac-ham-excel-thong-dung-trong-ke-toan\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\/\/vieclamketoan.vn\/blog\/cac-ham-excel-thong-dung-trong-ke-toan\/#primaryimage\",\"url\":\"https:\/\/vieclamketoan.vn\/blog\/wp-content\/uploads\/2022\/11\/cac-ham-excel-thong-dung-trong-ke-toan-topcv.jpg\",\"contentUrl\":\"https:\/\/vieclamketoan.vn\/blog\/wp-content\/uploads\/2022\/11\/cac-ham-excel-thong-dung-trong-ke-toan-topcv.jpg\",\"width\":800,\"height\":500,\"caption\":\"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\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/vieclamketoan.vn\/blog\/cac-ham-excel-thong-dung-trong-ke-toan\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Trang ch\u1ee7\",\"item\":\"https:\/\/vieclamketoan.vn\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"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\"}]},{\"@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 c\u00e1c h\u00e0m Excel th\u00f4ng d\u1ee5ng trong k\u1ebf to\u00e1n newbie c\u1ea7n n\u1eafm r\u00f5","description":"Excel l\u00e0 c\u00f4ng c\u1ee5 m\u00e0 k\u1ebf to\u00e1n vi\u00ean n\u00e0o c\u0169ng ph\u1ea3i th\u00e0nh th\u1ea1o. H\u00e3y c\u00f9ng t\u00ecm hi\u1ec3u c\u00e1c h\u00e0m Excel th\u00f4ng d\u1ee5ng trong k\u1ebf to\u00e1n ngay 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\/cac-ham-excel-thong-dung-trong-ke-toan\/","og_locale":"vi_VN","og_type":"article","og_title":"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","og_description":"Excel l\u00e0 c\u00f4ng c\u1ee5 m\u00e0 k\u1ebf to\u00e1n vi\u00ean n\u00e0o c\u0169ng ph\u1ea3i th\u00e0nh th\u1ea1o. H\u00e3y c\u00f9ng t\u00ecm hi\u1ec3u c\u00e1c h\u00e0m Excel th\u00f4ng d\u1ee5ng trong k\u1ebf to\u00e1n ngay nh\u00e9.","og_url":"https:\/\/vieclamketoan.vn\/blog\/cac-ham-excel-thong-dung-trong-ke-toan\/","og_site_name":"vieclamketoan","article_published_time":"2022-11-06T03:18:31+00:00","article_modified_time":"2022-11-25T14:22:46+00:00","og_image":[{"width":800,"height":500,"url":"https:\/\/vieclamketoan.vn\/blog\/wp-content\/uploads\/2022\/11\/cac-ham-excel-thong-dung-trong-ke-toan-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\/cac-ham-excel-thong-dung-trong-ke-toan\/#article","isPartOf":{"@id":"https:\/\/vieclamketoan.vn\/blog\/cac-ham-excel-thong-dung-trong-ke-toan\/"},"author":{"name":"Ng\u1ecdc \u00c1nh","@id":"https:\/\/vieclamketoan.vn\/blog\/#\/schema\/person\/31432a9a17bcae995820bfdcb4f5936b"},"headline":"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","datePublished":"2022-11-06T03:18:31+00:00","dateModified":"2022-11-25T14:22:46+00:00","mainEntityOfPage":{"@id":"https:\/\/vieclamketoan.vn\/blog\/cac-ham-excel-thong-dung-trong-ke-toan\/"},"wordCount":1594,"commentCount":0,"publisher":{"@id":"https:\/\/vieclamketoan.vn\/blog\/#organization"},"image":{"@id":"https:\/\/vieclamketoan.vn\/blog\/cac-ham-excel-thong-dung-trong-ke-toan\/#primaryimage"},"thumbnailUrl":"https:\/\/vieclamketoan.vn\/blog\/wp-content\/uploads\/2022\/11\/cac-ham-excel-thong-dung-trong-ke-toan-topcv.jpg","keywords":["C\u00e1c h\u00e0m Excel th\u00f4ng d\u1ee5ng","c\u00e1c h\u00e0m Excel th\u00f4ng d\u1ee5ng trong k\u1ebf to\u00e1n","C\u00e1c h\u00e0m excel trong k\u1ebf to\u00e1n kho","c\u00e1c h\u00e0m th\u00f4ng d\u1ee5ng trong excel k\u1ebf to\u00e1n","excel k\u1ebf to\u00e1n","excel v\u0103n ph\u00f2ng","k\u1ebf to\u00e1n"],"articleSection":["Chia s\u1ebb kinh nghi\u1ec7m"],"inLanguage":"vi","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/vieclamketoan.vn\/blog\/cac-ham-excel-thong-dung-trong-ke-toan\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/vieclamketoan.vn\/blog\/cac-ham-excel-thong-dung-trong-ke-toan\/","url":"https:\/\/vieclamketoan.vn\/blog\/cac-ham-excel-thong-dung-trong-ke-toan\/","name":"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","isPartOf":{"@id":"https:\/\/vieclamketoan.vn\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/vieclamketoan.vn\/blog\/cac-ham-excel-thong-dung-trong-ke-toan\/#primaryimage"},"image":{"@id":"https:\/\/vieclamketoan.vn\/blog\/cac-ham-excel-thong-dung-trong-ke-toan\/#primaryimage"},"thumbnailUrl":"https:\/\/vieclamketoan.vn\/blog\/wp-content\/uploads\/2022\/11\/cac-ham-excel-thong-dung-trong-ke-toan-topcv.jpg","datePublished":"2022-11-06T03:18:31+00:00","dateModified":"2022-11-25T14:22:46+00:00","description":"Excel l\u00e0 c\u00f4ng c\u1ee5 m\u00e0 k\u1ebf to\u00e1n vi\u00ean n\u00e0o c\u0169ng ph\u1ea3i th\u00e0nh th\u1ea1o. H\u00e3y c\u00f9ng t\u00ecm hi\u1ec3u c\u00e1c h\u00e0m Excel th\u00f4ng d\u1ee5ng trong k\u1ebf to\u00e1n ngay nh\u00e9.","breadcrumb":{"@id":"https:\/\/vieclamketoan.vn\/blog\/cac-ham-excel-thong-dung-trong-ke-toan\/#breadcrumb"},"inLanguage":"vi","potentialAction":[{"@type":"ReadAction","target":["https:\/\/vieclamketoan.vn\/blog\/cac-ham-excel-thong-dung-trong-ke-toan\/"]}]},{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/vieclamketoan.vn\/blog\/cac-ham-excel-thong-dung-trong-ke-toan\/#primaryimage","url":"https:\/\/vieclamketoan.vn\/blog\/wp-content\/uploads\/2022\/11\/cac-ham-excel-thong-dung-trong-ke-toan-topcv.jpg","contentUrl":"https:\/\/vieclamketoan.vn\/blog\/wp-content\/uploads\/2022\/11\/cac-ham-excel-thong-dung-trong-ke-toan-topcv.jpg","width":800,"height":500,"caption":"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"},{"@type":"BreadcrumbList","@id":"https:\/\/vieclamketoan.vn\/blog\/cac-ham-excel-thong-dung-trong-ke-toan\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Trang ch\u1ee7","item":"https:\/\/vieclamketoan.vn\/blog\/"},{"@type":"ListItem","position":2,"name":"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"}]},{"@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\/2129","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=2129"}],"version-history":[{"count":7,"href":"https:\/\/vieclamketoan.vn\/blog\/wp-json\/wp\/v2\/posts\/2129\/revisions"}],"predecessor-version":[{"id":2456,"href":"https:\/\/vieclamketoan.vn\/blog\/wp-json\/wp\/v2\/posts\/2129\/revisions\/2456"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/vieclamketoan.vn\/blog\/wp-json\/wp\/v2\/media\/2451"}],"wp:attachment":[{"href":"https:\/\/vieclamketoan.vn\/blog\/wp-json\/wp\/v2\/media?parent=2129"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/vieclamketoan.vn\/blog\/wp-json\/wp\/v2\/categories?post=2129"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/vieclamketoan.vn\/blog\/wp-json\/wp\/v2\/tags?post=2129"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}