{"id":49057,"date":"2024-10-29T09:08:46","date_gmt":"2024-10-29T02:08:46","guid":{"rendered":"https:\/\/jobsgo.vn\/blog\/?p=49057"},"modified":"2024-10-31T08:51:51","modified_gmt":"2024-10-31T01:51:51","slug":"cac-ham-trong-excel","status":"publish","type":"post","link":"https:\/\/jobsgo.vn\/blog\/cac-ham-trong-excel\/","title":{"rendered":"C\u00e1c H\u00e0m Trong Excel C\u01a1 B\u1ea3n, Th\u01b0\u1eddng \u0110\u01b0\u1ee3c S\u1eed D\u1ee5ng Nh\u1ea5t 2025"},"content":{"rendered":"\n<div class=\"kk-star-ratings\n     kksr-valign-top     kksr-align-left    \"\n    data-payload=\"{&quot;align&quot;:&quot;left&quot;,&quot;id&quot;:&quot;49057&quot;,&quot;slug&quot;:&quot;default&quot;,&quot;valign&quot;:&quot;top&quot;,&quot;reference&quot;:&quot;auto&quot;,&quot;count&quot;:&quot;0&quot;,&quot;readonly&quot;:&quot;&quot;,&quot;score&quot;:&quot;4.5&quot;,&quot;best&quot;:&quot;5&quot;,&quot;gap&quot;:&quot;5&quot;,&quot;greet&quot;:&quot;\\u0110\\u00e1nh gi\\u00e1 post&quot;,&quot;legend&quot;:&quot;4.5\\\/5 - (0 votes)&quot;,&quot;size&quot;:&quot;22&quot;,&quot;width&quot;:&quot;119&quot;,&quot;_legend&quot;:&quot;{score}\\\/{best} - ({count} {votes})&quot;}\">\n    \n<div class=\"kksr-stars\">\n    \n<div class=\"kksr-stars-inactive\">\n            <div class=\"kksr-star\" data-star=\"1\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 22px; height: 22px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"2\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 22px; height: 22px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"3\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 22px; height: 22px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"4\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 22px; height: 22px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"5\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 22px; height: 22px;\"><\/div>\n        <\/div>\n    <\/div>\n    \n<div class=\"kksr-stars-active\" style=\"width: 119px;\">\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 22px; height: 22px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 22px; height: 22px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 22px; height: 22px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 22px; height: 22px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 22px; height: 22px;\"><\/div>\n        <\/div>\n    <\/div>\n<\/div>\n    \n<div class=\"kksr-legend\">\n            <span class=\"kksr-muted\">\u0110\u00e1nh gi\u00e1 post<\/span>\n    <\/div>\n<\/div>\n<p><em>Excel l\u00e0 m\u1ed9t c\u00f4ng c\u1ee5 r\u1ea5t \u0111\u01b0\u1ee3c \u01b0a chu\u1ed9ng hi\u1ec7n nay v\u00ec s\u1ef1 h\u1eefu \u00edch c\u1ee7a n\u00f3 v\u1edbi ng\u01b0\u1eddi d\u00f9ng. Vi\u1ec7c th\u00e0nh th\u1ea1o Excel s\u1ebd l\u00e0 ti\u1ec1n \u0111\u1ec1 gi\u00fap b\u1ea1n g\u1eb7t h\u00e1i \u0111\u01b0\u1ee3c nhi\u1ec1u th\u00e0nh c\u00f4ng trong c\u00f4ng vi\u1ec7c. Trong b\u00e0i vi\u1ebft n\u00e0y, JobsGO s\u1ebd gi\u1edbi thi\u1ec7u cho b\u1ea1n<\/em> <strong><em>c\u00e1c h\u00e0m trong excel<\/em><\/strong><em> \u0111\u1ec3 gi\u00fap c\u00f3 th\u1ec3 nhu\u1ea7n nhuy\u1ec5n v\u00e0 l\u00e0m ch\u1ee7 \u0111\u01b0\u1ee3c ph\u1ea7n m\u1ec1m n\u00e0y nh\u00e9!<\/em><\/p>\n<div id=\"toc_container\" class=\"toc_light_blue no_bullets\"><p class=\"toc_title\">M\u1ee5c l\u1ee5c<\/p><ul class=\"toc_list\"><li><a href=\"#1_Cac_Ham_Tinh_Toan\">1. C\u00e1c H\u00e0m T\u00ednh To\u00e1n<\/a><ul><li><a href=\"#11_Ham_SUM\">1.1 H\u00e0m SUM<\/a><\/li><li><a href=\"#12_Ham_MINMAX\">1.2 H\u00e0m MIN\/MAX<\/a><\/li><li><a href=\"#13_Ham_COUNT_COUNTA\">1.3 H\u00e0m COUNT\/ COUNTA<\/a><\/li><li><a href=\"#14_Ham_AVERAGE\">1.4 H\u00e0m AVERAGE<\/a><\/li><li><a href=\"#15_Ham_PRODUCT\">1.5 H\u00e0m PRODUCT<\/a><\/li><li><a href=\"#16_Ham_ODDEVEN\">1.6 H\u00e0m ODD\/EVEN<\/a><\/li><\/ul><\/li><li><a href=\"#2_Cac_Ham_Dieu_Kien\">2. C\u00e1c H\u00e0m \u0110i\u1ec1u Ki\u1ec7n<\/a><ul><li><a href=\"#21_Ham_COUNTIF\">2.1 H\u00e0m COUNTIF<\/a><\/li><li><a href=\"#22_Ham_IF\">2.2 H\u00e0m IF<\/a><\/li><li><a href=\"#23_Ham_SUMIF\">2.3 H\u00e0m SUMIF<\/a><\/li><\/ul><\/li><li><a href=\"#3_Cac_Ham_Dung_Trong_Van_Ban\">3. C\u00e1c H\u00e0m D\u00f9ng Trong V\u0103n B\u1ea3n<\/a><ul><li><a href=\"#31_Ham_LEFTRIGHTMID\">3.1 H\u00e0m LEFT\/RIGHT\/MID<\/a><\/li><li><a href=\"#32_Ham_LEN\">3.2 H\u00e0m LEN<\/a><\/li><li><a href=\"#33_Ham_CONCAT\">3.3 H\u00e0m CONCAT<\/a><\/li><\/ul><\/li><li><a href=\"#4_Cac_Ham_Ngay_Thang\">4. C\u00e1c H\u00e0m Ng\u00e0y, Th\u00e1ng<\/a><ul><li><a href=\"#41_Ham_NOW\">4.1 H\u00e0m NOW<\/a><\/li><li><a href=\"#42_Ham_DATE\">4.2 H\u00e0m DATE<\/a><\/li><\/ul><\/li><li><a href=\"#5_Cac_Ham_Tra_Cuu_Du_Lieu\">5. C\u00e1c H\u00e0m Tra C\u1ee9u D\u1eef Li\u1ec7u<\/a><ul><li><a href=\"#51_Ham_VLOOKUP\">5.1 H\u00e0m VLOOKUP<\/a><\/li><li><a href=\"#52_Ham_INDEX\">5.2 H\u00e0m INDEX<\/a><\/li><li><a href=\"#53_Ham_MATCH\">5.3 H\u00e0m MATCH<\/a><\/li><li><a href=\"#54_Ham_HLOOKUP\">5.4. H\u00e0m HLOOKUP<\/a><\/li><\/ul><\/li><li><a href=\"#6_Loi_Ich_Khi_Su_Dung_Cac_Ham_Trong_Excel_La_Gi\">6. L\u1ee3i \u00cdch Khi S\u1eed D\u1ee5ng C\u00e1c H\u00e0m Trong Excel L\u00e0 G\u00ec?<\/a><ul><li><a href=\"#61_Toi_Uu_Hoa_Quy_Trinh_Lam_Viec\">6.1 T\u1ed1i \u01afu H\u00f3a Quy Tr\u00ecnh L\u00e0m Vi\u1ec7c<\/a><\/li><li><a href=\"#62_Cai_Thien_Do_Chinh_Xac_Va_Chat_Luong_Thong_Tin\">6.2 C\u1ea3i Thi\u1ec7n \u0110\u1ed9 Ch\u00ednh X\u00e1c V\u00e0 Ch\u1ea5t L\u01b0\u1ee3ng Th\u00f4ng Tin<\/a><\/li><li><a href=\"#63_Cai_Thien_Kha_Nang_Phan_Tich_Va_Bao_Cao_Thong_Tin\">6.3 C\u1ea3i Thi\u1ec7n Kh\u1ea3 N\u0103ng Ph\u00e2n T\u00edch V\u00e0 B\u00e1o C\u00e1o Th\u00f4ng Tin<\/a><\/li><\/ul><\/li><li><a href=\"#7_Luu_Y_Khi_Thuc_Hien_Cac_Ham_Trong_Excel\">7. L\u01b0u \u00dd Khi Th\u1ef1c Hi\u1ec7n C\u00e1c H\u00e0m Trong Excel<\/a><\/li><\/ul><\/div>\n<h2><span id=\"1_Cac_Ham_Tinh_Toan\"><strong>1. C\u00e1c H\u00e0m T\u00ednh To\u00e1n<\/strong><\/span><\/h2>\n<figure id=\"attachment_84321\" aria-describedby=\"caption-attachment-84321\" style=\"width: 800px\" class=\"wp-caption alignnone\"><img loading=\"lazy\" class=\"wp-image-84321 size-full\" src=\"https:\/\/media-blog.jobsgo.vn\/blog\/wp-content\/uploads\/2024\/02\/cac-ham-trong-excel.jpg\" alt=\"c\u00e1c h\u00e0m trong excel\" width=\"800\" height=\"550\" srcset=\"https:\/\/media-blog.jobsgo.vn\/blog\/wp-content\/uploads\/2024\/02\/cac-ham-trong-excel.jpg 800w, https:\/\/media-blog.jobsgo.vn\/blog\/wp-content\/uploads\/2024\/02\/cac-ham-trong-excel-300x206.jpg 300w, https:\/\/media-blog.jobsgo.vn\/blog\/wp-content\/uploads\/2024\/02\/cac-ham-trong-excel-150x103.jpg 150w, https:\/\/media-blog.jobsgo.vn\/blog\/wp-content\/uploads\/2024\/02\/cac-ham-trong-excel-768x528.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/><figcaption id=\"caption-attachment-84321\" class=\"wp-caption-text\"><center><em>C\u00e1c h\u00e0m trong excel c\u01a1 b\u1ea3n<\/em><\/center><\/figcaption><\/figure>\n<p><strong>C\u00e1c h\u00e0m trong Excel<\/strong> ph\u1ee5c v\u1ee5 cho m\u1ee5c \u0111\u00edch t\u00ednh to\u00e1n s\u1ebd \u0111\u01b0\u1ee3c ph\u00e2n chia th\u00e0nh:<\/p>\n<h3><span id=\"11_Ham_SUM\"><strong>1.1 H\u00e0m SUM<\/strong><\/span><\/h3>\n<blockquote id=\"c\u00e1c_h\u00e0m_c\u01a1_b\u1ea3n_trong_excel\" cite=\"https:\/\/jobsgo.vn\/blog\/cac-ham-trong-excel\/#tong_quan_ve_cac_cong_thuc_trong_excel\"><p>SUM l\u00e0 h\u00e0m t\u00ednh v\u00f4 c\u00f9ng quen thu\u1ed9c trong Microsoft Excel hi\u1ec7n nay. N\u00f3 \u0111\u01b0\u1ee3c d\u00f9ng \u0111\u1ec3 t\u00ednh t\u1ed5ng gi\u00e1 tr\u1ecb c\u00e1c \u00f4 m\u00e0 b\u1ea1n mu\u1ed1n t\u00ednh.<\/p><\/blockquote>\n<p>C\u00fa ph\u00e1p h\u00e0m SUM v\u00f4 c\u00f9ng \u0111\u01a1n gi\u1ea3n, c\u1ee5 th\u1ec3:<\/p>\n<table>\n<tbody>\n<tr>\n<td>=SUM(A,B,C\u2026)<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>Trong \u0111\u00f3:<\/p>\n<p>A,B,C l\u00e0 \u0111\u1ecba ch\u1ec9 c\u00e1c \u00f4 b\u1ea1n mu\u1ed1n t\u00ednh t\u1ed5ng.<\/p>\n<p><strong>V\u00ed d\u1ee5: <\/strong>N\u1ebfu mu\u1ed1n t\u00ednh t\u1ed5ng c\u1ee7a c\u00e1c s\u1ed1 \u0111\u00e3 cho trong b\u1ea3ng, ta c\u00f3: =SUM(20,40,60) v\u00e0 nh\u1eadn \u0111\u01b0\u1ee3c k\u1ebft qu\u1ea3 l\u00e0 120.<\/p>\n<figure id=\"attachment_84343\" aria-describedby=\"caption-attachment-84343\" style=\"width: 800px\" class=\"wp-caption alignnone\"><img loading=\"lazy\" class=\"wp-image-84343 size-full\" src=\"https:\/\/media-blog.jobsgo.vn\/blog\/wp-content\/uploads\/2024\/02\/tong-quan-ve-cac-cong-thuc-trong-excel.jpg\" alt=\"t\u1ed5ng quan v\u1ec1 c\u00e1c c\u00f4ng th\u1ee9c trong excel\" width=\"800\" height=\"550\" srcset=\"https:\/\/media-blog.jobsgo.vn\/blog\/wp-content\/uploads\/2024\/02\/tong-quan-ve-cac-cong-thuc-trong-excel.jpg 800w, https:\/\/media-blog.jobsgo.vn\/blog\/wp-content\/uploads\/2024\/02\/tong-quan-ve-cac-cong-thuc-trong-excel-300x206.jpg 300w, https:\/\/media-blog.jobsgo.vn\/blog\/wp-content\/uploads\/2024\/02\/tong-quan-ve-cac-cong-thuc-trong-excel-150x103.jpg 150w, https:\/\/media-blog.jobsgo.vn\/blog\/wp-content\/uploads\/2024\/02\/tong-quan-ve-cac-cong-thuc-trong-excel-768x528.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/><figcaption id=\"caption-attachment-84343\" class=\"wp-caption-text\"><center><em>H\u00e0m SUM<\/em><\/center><\/figcaption><\/figure>\n<p><strong>Xem th\u00eam:<\/strong> <a href=\"https:\/\/jobsgo.vn\/blog\/ham-subtotal-trong-excel\/\" target=\"_blank\" rel=\"noopener\"><strong>H\u00e0m Subtotal &#8211; C\u00f4ng th\u1ee9c v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng trong Excel d\u1ec5 hi\u1ec3u<\/strong><\/a><\/p>\n<h3><span id=\"12_Ham_MINMAX\"><strong>1.2 H\u00e0m MIN\/MAX<\/strong><\/span><\/h3>\n<p>H\u00e0m MIN\/ MAX l\u00e0 h\u00e0m \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 t\u00ednh gi\u00e1 tr\u1ecb nh\u1ecf nh\u1ea5t\/ gi\u00e1 tr\u1ecb l\u1edbn nh\u1ea5t c\u1ee7a v\u00f9ng d\u1eef li\u1ec7u \u0111\u01b0\u1ee3c ch\u1ecdn.<\/p>\n<p>C\u00fa ph\u00e1p:<\/p>\n<table>\n<tbody>\n<tr>\n<td>=MIN(X1:X2)<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<table>\n<tbody>\n<tr>\n<td>=MAX(X1:X2)<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>Trong \u0111\u00f3:<\/p>\n<p>X1, X2 l\u1ea7n l\u01b0\u1ee3t l\u00e0 \u0111\u1ecba ch\u1ec9 c\u1ee7a \u00f4 \u0111\u1ea7u v\u00e0 \u00f4 cu\u1ed1i c\u1ee7a d\u00e3y mu\u1ed1n t\u00ecm Min, Max.<\/p>\n<p><strong>V\u00ed d\u1ee5 h\u00e0m MIN:<\/strong> \u0110\u1ec3 t\u00ecm gi\u00e1 tr\u1ecb nh\u1ecf nh\u1ea5t c\u1ee7a v\u00f9ng d\u1eef li\u1ec7u trong b\u1ea3ng b\u00ean d\u01b0\u1edbi, ta \u00e1p d\u1ee5ng c\u00f4ng th\u1ee9c =MIN(A2:C5), k\u1ebft qu\u1ea3 nh\u1eadn \u0111\u01b0\u1ee3c s\u1ebd l\u00e0 25.<\/p>\n<p><strong>V\u00ed d\u1ee5 h\u00e0m MAX:<\/strong> \u0110\u1ec3 t\u00ecm gi\u00e1 tr\u1ecb l\u1edbn nh\u1ea5t c\u1ee7a v\u00f9ng d\u1eef li\u1ec7u trong b\u1ea3ng b\u00ean d\u01b0\u1edbi, ta \u00e1p d\u1ee5ng c\u00f4ng th\u1ee9c =MIN(A2:C5), k\u1ebft qu\u1ea3 nh\u1eadn \u0111\u01b0\u1ee3c s\u1ebd l\u00e0 89.<\/p>\n<p>&nbsp;<\/p>\n<figure id=\"attachment_84336\" aria-describedby=\"caption-attachment-84336\" style=\"width: 730px\" class=\"wp-caption alignnone\"><img loading=\"lazy\" class=\"wp-image-84336 size-full\" src=\"https:\/\/media-blog.jobsgo.vn\/blog\/wp-content\/uploads\/2024\/02\/ham-min-trong-excel.jpg\" alt=\"h\u00e0m min trong excel\" width=\"730\" height=\"332\" srcset=\"https:\/\/media-blog.jobsgo.vn\/blog\/wp-content\/uploads\/2024\/02\/ham-min-trong-excel.jpg 730w, https:\/\/media-blog.jobsgo.vn\/blog\/wp-content\/uploads\/2024\/02\/ham-min-trong-excel-300x136.jpg 300w, https:\/\/media-blog.jobsgo.vn\/blog\/wp-content\/uploads\/2024\/02\/ham-min-trong-excel-150x68.jpg 150w\" sizes=\"(max-width: 730px) 100vw, 730px\" \/><figcaption id=\"caption-attachment-84336\" class=\"wp-caption-text\"><center><em>H\u00e0m Min<\/em><\/center><\/figcaption><\/figure>\n<figure id=\"attachment_84326\" aria-describedby=\"caption-attachment-84326\" style=\"width: 730px\" class=\"wp-caption alignnone\"><img loading=\"lazy\" class=\"wp-image-84326 size-full\" src=\"https:\/\/media-blog.jobsgo.vn\/blog\/wp-content\/uploads\/2024\/02\/chi-tiet-ve-ham-max-trong-excel-kem-vi-du-minh-hoa.jpg\" alt=\"chi ti\u1ebft v\u1ec1 h\u00e0m max trong excel k\u00e8m v\u00ed d\u1ee5 minh h\u1ecda\" width=\"730\" height=\"332\" srcset=\"https:\/\/media-blog.jobsgo.vn\/blog\/wp-content\/uploads\/2024\/02\/chi-tiet-ve-ham-max-trong-excel-kem-vi-du-minh-hoa.jpg 730w, https:\/\/media-blog.jobsgo.vn\/blog\/wp-content\/uploads\/2024\/02\/chi-tiet-ve-ham-max-trong-excel-kem-vi-du-minh-hoa-300x136.jpg 300w, https:\/\/media-blog.jobsgo.vn\/blog\/wp-content\/uploads\/2024\/02\/chi-tiet-ve-ham-max-trong-excel-kem-vi-du-minh-hoa-150x68.jpg 150w\" sizes=\"(max-width: 730px) 100vw, 730px\" \/><figcaption id=\"caption-attachment-84326\" class=\"wp-caption-text\"><center><em>H\u00e0m Max<\/em><\/center><\/figcaption><\/figure>\n<h3><span id=\"13_Ham_COUNT_COUNTA\"><strong>1.3 H\u00e0m COUNT\/ COUNTA<\/strong><\/span><\/h3>\n<p>COUNT l\u00e0 h\u00e0m \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng khi mu\u1ed1n \u0111\u1ebfm s\u1ed1 l\u01b0\u1ee3ng nh\u1eefng \u00f4 trong v\u00f9ng d\u1eef li\u1ec7u c\u00f3 ch\u1ee9a s\u1ed1. C\u00fa ph\u00e1p c\u1ee7a h\u00e0m n\u00e0y l\u00e0:<\/p>\n<table>\n<tbody>\n<tr>\n<td>=COUNT(Value1,&#8230;)<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>Trong \u0111\u00f3: Value1 l\u00e0 ph\u1ea1m vi d\u1eef li\u1ec7u m\u00e0 b\u1ea1n mu\u1ed1n \u0111\u1ebfm.<\/p>\n<p><strong>V\u00ed d\u1ee5:<\/strong> \u0110\u1ec3 \u0111\u1ebfm s\u1ed1 l\u01b0\u1ee3ng c\u00e1c s\u1ed1 trong v\u00f9ng d\u1eef li\u1ec7u \u0111\u00e3 ch\u1ecdn, b\u1ea1n \u00e1p d\u1ee5ng c\u00f4ng th\u1ee9c =COUNT(A2:C5). K\u1ebft qu\u1ea3 \u0111\u1ea1t \u0111\u01b0\u1ee3c l\u00e0 t\u1ed5ng s\u1ed1 l\u01b0\u1ee3ng \u00f4 c\u00f3 ch\u1ee9a s\u1ed1.<\/p>\n<p>Kh\u00e1c v\u1edbi COUNT, h\u00e0m COUNTA \u0111\u01b0\u1ee3c d\u00f9ng \u0111\u1ec3 \u0111\u1ebfm nh\u1eefng \u00f4 kh\u00f4ng tr\u1ed1ng (t\u1ee9c l\u00e0 nh\u1eefng \u00f4 \u0111\u00e3 ch\u1ee9a d\u1eef li\u1ec7u) trong m\u1ed9t ph\u1ea1m vi nh\u1ea5t \u0111\u1ecbnh. C\u00fa ph\u00e1p c\u1ee7a h\u00e0m COUNTA c\u0169ng kh\u00e1 t\u01b0\u01a1ng \u0111\u1ed3ng v\u1edbi h\u00e0m COUNT:<\/p>\n<table>\n<tbody>\n<tr>\n<td>=COUNTA(Value1,&#8230;)<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>Tuy nhi\u00ean, v\u1edbi h\u00e0m COUNT A: v\u00f9ng d\u1eef li\u1ec7u s\u1ebd b\u1ecb gi\u1edbi h\u1ea1n, t\u1ed1i \u0111a l\u00e0 255 \u00f4 (v\u1edbi Excel t\u1eeb 2007 v\u1ec1 sau) v\u00e0 t\u1ed1i \u0111a 30 (v\u1edbi Excel t\u1eeb 2003 v\u1ec1 tr\u01b0\u1edbc).<\/p>\n<p><strong>V\u00ed d\u1ee5:<\/strong> \u0110\u1ec3 \u0111\u1ebfm s\u1ed1 l\u01b0\u1ee3ng c\u00e1c \u00f4 c\u00f3 ch\u1ee9a d\u1eef li\u1ec7u trong v\u00f9ng \u0111\u01b0\u1ee3c ch\u1ecdn, b\u1ea1n \u00e1p d\u1ee5ng c\u00f4ng th\u1ee9c =COUNT(A2:C5). K\u1ebft qu\u1ea3 \u0111\u1ea1t \u0111\u01b0\u1ee3c l\u00e0 s\u1ed1 l\u01b0\u1ee3ng \u00f4 c\u00f3 ch\u1ee9a k\u00ed t\u1ef1 ho\u1eb7c s\u1ed1.<\/p>\n<p>&nbsp;<\/p>\n<figure id=\"attachment_84344\" aria-describedby=\"caption-attachment-84344\" style=\"width: 730px\" class=\"wp-caption alignnone\"><img loading=\"lazy\" class=\"wp-image-84344 size-full\" src=\"https:\/\/media-blog.jobsgo.vn\/blog\/wp-content\/uploads\/2024\/02\/huong-dan-cach-su-dung-ham-count-tu-a-z.jpg\" alt=\"h\u01b0\u1edbng d\u1eabn c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m count t\u1eeb a-z\" width=\"730\" height=\"332\" srcset=\"https:\/\/media-blog.jobsgo.vn\/blog\/wp-content\/uploads\/2024\/02\/huong-dan-cach-su-dung-ham-count-tu-a-z.jpg 730w, https:\/\/media-blog.jobsgo.vn\/blog\/wp-content\/uploads\/2024\/02\/huong-dan-cach-su-dung-ham-count-tu-a-z-300x136.jpg 300w, https:\/\/media-blog.jobsgo.vn\/blog\/wp-content\/uploads\/2024\/02\/huong-dan-cach-su-dung-ham-count-tu-a-z-150x68.jpg 150w\" sizes=\"(max-width: 730px) 100vw, 730px\" \/><figcaption id=\"caption-attachment-84344\" class=\"wp-caption-text\"><center><em>\u0110\u1ebfm gi\u00e1 tr\u1ecb l\u00e0 s\u1ed1 trong v\u00f9ng d\u1eef li\u1ec7u<\/em><\/center><\/figcaption><\/figure>\n<figure id=\"attachment_84324\" aria-describedby=\"caption-attachment-84324\" style=\"width: 730px\" class=\"wp-caption alignnone\"><img loading=\"lazy\" class=\"wp-image-84324 size-full\" src=\"https:\/\/media-blog.jobsgo.vn\/blog\/wp-content\/uploads\/2024\/02\/cach-su-dung-ham-count-trong-excel-co-vi-du-chi-tiet.jpg\" alt=\"c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m count trong excel c\u00f3 v\u00ed d\u1ee5 chi ti\u1ebft\" width=\"730\" height=\"332\" srcset=\"https:\/\/media-blog.jobsgo.vn\/blog\/wp-content\/uploads\/2024\/02\/cach-su-dung-ham-count-trong-excel-co-vi-du-chi-tiet.jpg 730w, https:\/\/media-blog.jobsgo.vn\/blog\/wp-content\/uploads\/2024\/02\/cach-su-dung-ham-count-trong-excel-co-vi-du-chi-tiet-300x136.jpg 300w, https:\/\/media-blog.jobsgo.vn\/blog\/wp-content\/uploads\/2024\/02\/cach-su-dung-ham-count-trong-excel-co-vi-du-chi-tiet-150x68.jpg 150w\" sizes=\"(max-width: 730px) 100vw, 730px\" \/><figcaption id=\"caption-attachment-84324\" class=\"wp-caption-text\"><center><em>H\u00e0m COUNTA<\/em><\/center><\/figcaption><\/figure>\n<h3><span id=\"14_Ham_AVERAGE\"><strong>1.4 H\u00e0m AVERAGE<\/strong><\/span><\/h3>\n<p>Khi mu\u1ed1n t\u00ednh gi\u00e1 tr\u1ecb trung b\u00ecnh c\u1ee7a m\u1ed9t d\u00e3y s\u1ed1, ng\u01b0\u1eddi ta s\u1ebd s\u1eed d\u1ee5ng h\u00e0m AVERAGE.<\/p>\n<p>C\u00fa ph\u00e1p c\u1ee7a h\u00e0m n\u00e0y v\u00f4 c\u00f9ng \u0111\u01a1n gi\u1ea3n:<\/p>\n<table>\n<tbody>\n<tr>\n<td>=AVERAGE(number1,number2,\u2026)<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>Trong \u0111\u00f3:<\/p>\n<ul>\n<li aria-level=\"1\">number1 (B\u1eaft bu\u1ed9c): Tham chi\u00ea\u0301u \u00f4 ho\u1eb7c ph\u1ea1m vi v\u00f9ng d\u1eef li\u00eau mu\u1ed1n t\u00ednh trung b\u00ecnh.<\/li>\n<li aria-level=\"1\">number2,&#8230; (T\u00f9y ch\u1ecdn): Tham chi\u1ebfu \u00f4 ho\u1eb7c ph\u1ea1m vi b\u1ed5 sung m\u00e0 b\u1ea1n mu\u1ed1n t\u00ednh trung b\u00ecnh. Number 2 \u0111\u01b0\u1ee3c gi\u1edbi h\u1ea1n t\u1ed1i \u0111a 255 \u00f4.<\/li>\n<\/ul>\n<p><strong>V\u00ed d\u1ee5:<\/strong> \u0110\u1ec3 t\u00ednh l\u01b0\u01a1ng trung b\u00ecnh theo d\u1eef li\u1ec7u trong b\u1ea3ng b\u00ean d\u01b0\u1edbi, ta c\u00f3 c\u00f4ng th\u1ee9c =AVERAGE(C3:C8) v\u00e0 nh\u1eadn \u0111\u01b0\u1ee3c k\u1ebft qu\u1ea3 l\u00e0 gi\u00e1 tr\u1ecb trung b\u00ecnh c\u1ee7a 6 th\u00e1ng l\u01b0\u01a1ng.<\/p>\n<figure id=\"attachment_84327\" aria-describedby=\"caption-attachment-84327\" style=\"width: 730px\" class=\"wp-caption alignnone\"><img loading=\"lazy\" class=\"wp-image-84327 size-full\" src=\"https:\/\/media-blog.jobsgo.vn\/blog\/wp-content\/uploads\/2024\/02\/ham-average.jpg\" alt=\"h\u00e0m average\" width=\"730\" height=\"332\" srcset=\"https:\/\/media-blog.jobsgo.vn\/blog\/wp-content\/uploads\/2024\/02\/ham-average.jpg 730w, https:\/\/media-blog.jobsgo.vn\/blog\/wp-content\/uploads\/2024\/02\/ham-average-300x136.jpg 300w, https:\/\/media-blog.jobsgo.vn\/blog\/wp-content\/uploads\/2024\/02\/ham-average-150x68.jpg 150w\" sizes=\"(max-width: 730px) 100vw, 730px\" \/><figcaption id=\"caption-attachment-84327\" class=\"wp-caption-text\"><center><em>H\u00e0m AVERAGE<\/em><\/center><\/figcaption><\/figure>\n<p><strong>Xem th\u00eam:<\/strong> <a href=\"https:\/\/jobsgo.vn\/blog\/cach-su-dung-ham-tru-trong-excel\/\" target=\"_blank\" rel=\"noopener\"><strong>C\u00e1ch d\u00f9ng h\u00e0m tr\u1eeb trong Excel<\/strong><\/a><strong> \u0111\u01a1n gi\u1ea3n, nhanh nh\u1ea5t<\/strong><\/p>\n<h3><span id=\"15_Ham_PRODUCT\"><strong>1.5 H\u00e0m PRODUCT<\/strong><\/span><\/h3>\n<p>H\u00e0m PRODUCT l\u00e0 h\u00e0m t\u00ednh t\u00edch c\u1ee7a t\u1ea5t c\u1ea3 c\u00e1c \u0111\u1ed1i s\u1ed1 \u0111\u00e3 \u0111\u01b0\u1ee3c ch\u1ecdn.<\/p>\n<p>C\u00fa ph\u00e1p:<\/p>\n<table>\n<tbody>\n<tr>\n<td>=PRODUCT(number1, number2,\u2026)<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>Trong \u0111\u00f3:<\/p>\n<ul>\n<li aria-level=\"1\">number1 (B\u1eaft bu\u1ed9c): S\u1ed1 th\u1ee9 nh\u1ea5t, tham chi\u00ea\u0301u \u00f4, ho\u1eb7c ph\u1ea1m vi m\u00e0 b\u1ea1n mu\u1ed1n t\u00ednh trung b\u00ecnh.<\/li>\n<li aria-level=\"1\">number2,&#8230; (T\u00f9y ch\u1ecdn): C\u00e1c s\u1ed1, tham chi\u1ebfu \u00f4 ho\u1eb7c ph\u1ea1m vi b\u1ed5 sung m\u00e0 b\u1ea1n mu\u1ed1n t\u00ednh trung b\u00ecnh, t\u1ed1i \u0111a l\u00e0 255. [\/info]<\/li>\n<\/ul>\n<p><strong>V\u00ed d\u1ee5: <\/strong>\u0110\u1ec3 t\u00ednh t\u00edch c\u1ee7a c\u00e1c s\u1ed1 \u0111\u01b0\u1ee3c ch\u1ecdn trong b\u1ea3ng b\u00ean d\u01b0\u1edbi, b\u1ea1n s\u1eed d\u1ee5ng h\u00e0m =PRODUCT(D2:D8)<\/p>\n<figure id=\"attachment_84339\" aria-describedby=\"caption-attachment-84339\" style=\"width: 800px\" class=\"wp-caption alignnone\"><img loading=\"lazy\" class=\"wp-image-84339 size-full\" src=\"https:\/\/media-blog.jobsgo.vn\/blog\/wp-content\/uploads\/2024\/02\/ham-product-trong-excel.jpg\" alt=\"h\u00e0m product trong excel\" width=\"800\" height=\"550\" srcset=\"https:\/\/media-blog.jobsgo.vn\/blog\/wp-content\/uploads\/2024\/02\/ham-product-trong-excel.jpg 800w, https:\/\/media-blog.jobsgo.vn\/blog\/wp-content\/uploads\/2024\/02\/ham-product-trong-excel-300x206.jpg 300w, https:\/\/media-blog.jobsgo.vn\/blog\/wp-content\/uploads\/2024\/02\/ham-product-trong-excel-150x103.jpg 150w, https:\/\/media-blog.jobsgo.vn\/blog\/wp-content\/uploads\/2024\/02\/ham-product-trong-excel-768x528.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/><figcaption id=\"caption-attachment-84339\" class=\"wp-caption-text\"><center><em>H\u00e0m PRODUCT<\/em><\/center><\/figcaption><\/figure>\n<h3><span id=\"16_Ham_ODDEVEN\"><strong>1.6 H\u00e0m ODD\/EVEN<\/strong><\/span><\/h3>\n<p>H\u00e0m ODD l\u00e0 h\u00e0m l\u00e0m tr\u00f2n s\u1ed1 \u0111\u01b0\u1ee3c tr\u1ea3 v\u1ec1 \u0111\u1ebfn s\u1ed1 nguy\u00ean l\u1ebb g\u1ea7n nh\u1ea5t.<\/p>\n<p>C\u00fa ph\u00e1p:<\/p>\n<table>\n<tbody>\n<tr>\n<td>=ODD(Number)<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>V\u1edbi Number: L\u00e0 gi\u00e1 tr\u1ecb c\u1ea7n l\u00e0m tr\u00f2n<\/p>\n<p><strong>V\u00ed d\u1ee5: <\/strong>L\u00e0m tr\u00f2n s\u1ed1 4.6 \u0111\u1ebfn s\u1ed1 nguy\u00ean l\u1ebb g\u1ea7n nh\u1ea5t nh\u1eadn \u0111\u01b0\u1ee3c k\u1ebft qu\u1ea3 l\u00e0 5.<\/p>\n<figure id=\"attachment_84338\" aria-describedby=\"caption-attachment-84338\" style=\"width: 730px\" class=\"wp-caption alignnone\"><img loading=\"lazy\" class=\"wp-image-84338 size-full\" src=\"https:\/\/media-blog.jobsgo.vn\/blog\/wp-content\/uploads\/2024\/02\/ham-odd.jpg\" alt=\"h\u00e0m odd\" width=\"730\" height=\"332\" srcset=\"https:\/\/media-blog.jobsgo.vn\/blog\/wp-content\/uploads\/2024\/02\/ham-odd.jpg 730w, https:\/\/media-blog.jobsgo.vn\/blog\/wp-content\/uploads\/2024\/02\/ham-odd-300x136.jpg 300w, https:\/\/media-blog.jobsgo.vn\/blog\/wp-content\/uploads\/2024\/02\/ham-odd-150x68.jpg 150w\" sizes=\"(max-width: 730px) 100vw, 730px\" \/><figcaption id=\"caption-attachment-84338\" class=\"wp-caption-text\"><center><em>H\u00e0m ODD<\/em><\/center><\/figcaption><\/figure>\n<p>H\u00e0m EVEN l\u00e0 h\u00e0m tr\u1ea3 v\u1ec1 s\u1ed1 \u0111\u01b0\u1ee3c l\u00e0m tr\u00f2n l\u00ean s\u1ed1 nguy\u00ean ch\u1eb5n g\u1ea7n nh\u1ea5t.<\/p>\n<p>C\u00fa ph\u00e1p:<\/p>\n<table>\n<tbody>\n<tr>\n<td>=EVEN(Number)<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>V\u1edbi \u201cNumber\u201d: L\u00e0 gi\u00e1 tr\u1ecb c\u1ea7n l\u00e0m tr\u00f2n<\/p>\n<p><strong>V\u00ed d\u1ee5: <\/strong>L\u00e0m tr\u00f2n 53.4 \u0111\u1ebfn s\u1ed1 nguy\u00ean ch\u1eb5n g\u1ea7n nh\u1ea5t nh\u1eadn \u0111\u01b0\u1ee3c k\u1ebft qu\u1ea3 l\u00e0 54.<\/p>\n<figure id=\"attachment_84329\" aria-describedby=\"caption-attachment-84329\" style=\"width: 730px\" class=\"wp-caption alignnone\"><img loading=\"lazy\" class=\"wp-image-84329 size-full\" src=\"https:\/\/media-blog.jobsgo.vn\/blog\/wp-content\/uploads\/2024\/02\/ham-even.jpg\" alt=\"h\u00e0m even\" width=\"730\" height=\"332\" srcset=\"https:\/\/media-blog.jobsgo.vn\/blog\/wp-content\/uploads\/2024\/02\/ham-even.jpg 730w, https:\/\/media-blog.jobsgo.vn\/blog\/wp-content\/uploads\/2024\/02\/ham-even-300x136.jpg 300w, https:\/\/media-blog.jobsgo.vn\/blog\/wp-content\/uploads\/2024\/02\/ham-even-150x68.jpg 150w\" sizes=\"(max-width: 730px) 100vw, 730px\" \/><figcaption id=\"caption-attachment-84329\" class=\"wp-caption-text\"><center><em>H\u00e0m EVEN<\/em><\/center><\/figcaption><\/figure>\n<p>H\u00e0m t\u00ednh to\u00e1n bao g\u1ed3m <strong>c\u00e1c c\u00f4ng th\u1ee9c c\u01a1 b\u1ea3n trong Excel<\/strong>. Ti\u1ebfp \u0111\u1ebfn, h\u00e3y c\u00f9ng JobsGO \u0111i s\u00e2u kh\u00e1m ph\u00e1 nh\u1eefng h\u00e0m ph\u1ee9c t\u1ea1p h\u01a1n nh\u00e9!<\/p>\n<h2><span id=\"2_Cac_Ham_Dieu_Kien\"><strong>2. C\u00e1c H\u00e0m \u0110i\u1ec1u Ki\u1ec7n<\/strong><\/span><\/h2>\n<p>Nh\u1eafc \u0111\u1ebfn h\u00e0m \u0111i\u1ec1u ki\u1ec7n, kh\u00f4ng th\u1ec3 kh\u00f4ng k\u1ec3 t\u1edbi c\u00e1c h\u00e0m \u0111\u1eb7c tr\u01b0ng sau:<\/p>\n<h3><span id=\"21_Ham_COUNTIF\"><strong>2.1 H\u00e0m COUNTIF<\/strong><\/span><\/h3>\n<p>N\u1ebfu mu\u1ed1n \u0111\u1ebfm s\u1ed1 \u00f4 trong v\u00f9ng d\u1eef li\u1ec7u th\u1ecfa m\u00e3n \u0111i\u1ec1u ki\u1ec7n n\u00e0o \u0111\u00f3, b\u1ea1n c\u1ea7n d\u00f9ng h\u00e0m COUNTIF.<\/p>\n<p>C\u00fa ph\u00e1p c\u1ee7a h\u00e0m COUNTIF l\u00e0:<\/p>\n<table>\n<tbody>\n<tr>\n<td>=COUNTIF(range,criteria)<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>Trong \u0111\u00f3:<\/p>\n<ul>\n<li aria-level=\"1\">range: V\u00f9ng d\u1eef li\u1ec7u mu\u1ed1n \u0111\u1ebfm \u00f4.<\/li>\n<li aria-level=\"1\">criteria: \u0110i\u1ec1u ki\u1ec7n \u00e1p d\u1ee5ng cho nh\u1eefng \u00f4 mu\u1ed1n \u0111\u1ebfm.<\/li>\n<\/ul>\n<p><strong>V\u00ed d\u1ee5: <\/strong>V\u1edbi b\u1ea3ng th\u1ed1ng k\u00ea c\u00e1c m\u1eb7t h\u00e0ng v\u00e0 s\u1ed1 l\u01b0\u1ee3ng t\u1ed3n nh\u01b0 h\u00ecnh d\u01b0\u1edbi<\/p>\n<p>\u0110\u1ec3 th\u1ed1ng k\u00ea s\u1ed1 l\u01b0\u1ee3ng m\u1eb7t h\u00e0ng c\u00f2n t\u1ed3n tr\u00ean 150 s\u1ea3n ph\u1ea9m, b\u1ea1n h\u00e3y nh\u1eadp c\u00f4ng th\u1ee9c: =COUNTIF(C2:C11,&#8221;&gt;150&#8243;)<\/p>\n<p>K\u1ebft qu\u1ea3 nh\u1eadn \u0111\u01b0\u1ee3c l\u00e0 c\u00f3 8 m\u1eb7t h\u00e0ng c\u00f2n t\u1ed3n tr\u00ean 150 s\u1ea3n ph\u1ea9m.<\/p>\n<figure id=\"attachment_84328\" aria-describedby=\"caption-attachment-84328\" style=\"width: 730px\" class=\"wp-caption alignnone\"><img loading=\"lazy\" class=\"wp-image-84328 size-full\" src=\"https:\/\/media-blog.jobsgo.vn\/blog\/wp-content\/uploads\/2024\/02\/ham-countif.jpg\" alt=\"h\u00e0m countif\" width=\"730\" height=\"262\" srcset=\"https:\/\/media-blog.jobsgo.vn\/blog\/wp-content\/uploads\/2024\/02\/ham-countif.jpg 730w, https:\/\/media-blog.jobsgo.vn\/blog\/wp-content\/uploads\/2024\/02\/ham-countif-300x108.jpg 300w, https:\/\/media-blog.jobsgo.vn\/blog\/wp-content\/uploads\/2024\/02\/ham-countif-150x54.jpg 150w\" sizes=\"(max-width: 730px) 100vw, 730px\" \/><figcaption id=\"caption-attachment-84328\" class=\"wp-caption-text\"><center><em>H\u00e0m COUNTIF<\/em><\/center><\/figcaption><\/figure>\n<h3><span id=\"22_Ham_IF\"><strong>2.2 H\u00e0m IF<\/strong><\/span><\/h3>\n<p>N\u1ebfu b\u1ea1n mu\u1ed1n x\u00e1c \u0111\u1ecbnh d\u1eef li\u1ec7u c\u00f3 th\u1ecfa m\u00e3n \u0111i\u1ec1u ki\u1ec7n \u0111\u1eb7t ra hay kh\u00f4ng, h\u00e0m IF l\u00e0 h\u00e0m gi\u00fap b\u1ea1n th\u1ef1c hi\u1ec7n \u0111i\u1ec1u \u0111\u00f3.<\/p>\n<p>C\u00fa ph\u00e1p:<\/p>\n<table>\n<tbody>\n<tr>\n<td>=IF(Logical_test;Value_if_true;Value_if_false)<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>Trong \u0111\u00f3:<\/p>\n<ul>\n<li aria-level=\"1\">Logical_test: \u0110i\u1ec1u ki\u1ec7n b\u1ea1n mu\u1ed1n \u0111\u1ed1i chi\u1ebfu.<\/li>\n<li aria-level=\"1\">Value_if_true: Gi\u00e1 tr\u1ecb tr\u1ea3 v\u1ec1 n\u1ebfu th\u1ecfa \u0111i\u1ec1u ki\u1ec7n<\/li>\n<li aria-level=\"1\">Value_if_false: Gi\u00e1 tr\u1ecb tr\u1ea3 v\u1ec1 n\u1ebfu kh\u00f4ng th\u1ecfa \u0111i\u1ec1u ki\u1ec7n.<\/li>\n<\/ul>\n<p><strong>V\u00ed d\u1ee5:<\/strong> V\u1edbi d\u1eef li\u1ec7u \u0111\u01b0\u1ee3c cho trong b\u1ea3ng b\u00ean d\u01b0\u1edbi, \u0111\u1ec3 \u0111\u00e1nh gi\u00e1 \u201c\u0110\u1ea1t\u201d v\u1edbi h\u1ecdc sinh t\u1eeb 7 \u0111i\u1ec3m tr\u1edf l\u00ean v\u00e0 \u201cKh\u00f4ng \u0111\u1ea1t\u201d v\u1edbi h\u1ecdc sinh d\u01b0\u1edbi \u0111i\u1ec3m 7, ta c\u00f3 c\u00f4ng th\u1ee9c: =IF(C2&gt;=7,&#8221;\u0110\u1ea1t&#8221;,&#8221;Kh\u00f4ng \u0110\u1ea1t&#8221;), v\u00e0 \u0111\u01b0\u1ee3c k\u1ebft qu\u1ea3 nh\u01b0 h\u00ecnh b\u00ean d\u01b0\u1edbi.<\/p>\n<figure id=\"attachment_84331\" aria-describedby=\"caption-attachment-84331\" style=\"width: 730px\" class=\"wp-caption alignnone\"><img loading=\"lazy\" class=\"wp-image-84331 size-full\" src=\"https:\/\/media-blog.jobsgo.vn\/blog\/wp-content\/uploads\/2024\/02\/ham-if.jpg\" alt=\"h\u00e0m if\" width=\"730\" height=\"332\" srcset=\"https:\/\/media-blog.jobsgo.vn\/blog\/wp-content\/uploads\/2024\/02\/ham-if.jpg 730w, https:\/\/media-blog.jobsgo.vn\/blog\/wp-content\/uploads\/2024\/02\/ham-if-300x136.jpg 300w, https:\/\/media-blog.jobsgo.vn\/blog\/wp-content\/uploads\/2024\/02\/ham-if-150x68.jpg 150w\" sizes=\"(max-width: 730px) 100vw, 730px\" \/><figcaption id=\"caption-attachment-84331\" class=\"wp-caption-text\"><center><em>H\u00e0m IF<\/em><\/center><\/figcaption><\/figure>\n<p><strong>Xem th\u00eam: 10+<\/strong> <a href=\"https:\/\/jobsgo.vn\/blog\/cong-thuc-excel\/\" target=\"_blank\" rel=\"noopener\"><strong>c\u00f4ng th\u1ee9c Excel<\/strong><\/a><strong> th\u00f4ng d\u1ee5ng<\/strong><\/p>\n<h3><span id=\"23_Ham_SUMIF\"><strong>2.3 H\u00e0m SUMIF<\/strong><\/span><\/h3>\n<p>N\u1ebfu h\u00e0m SUM \u0111\u01b0\u1ee3c d\u00f9ng \u0111\u1ec3 t\u00ednh t\u1ed5ng m\u1ed9t v\u00f9ng d\u1eef li\u1ec7u th\u00ec SUMIF s\u1ebd \u0111\u1eb7c bi\u1ec7t h\u01a1n. N\u00f3 s\u1ebd th\u1ef1c hi\u1ec7n t\u00ednh t\u1ed5ng m\u1ed9t v\u00f9ng d\u1eef li\u1ec7u \u0111\u00e1p \u1ee9ng \u0111i\u1ec1u ki\u1ec7n nh\u1ea5t \u0111\u1ecbnh.<\/p>\n<p>C\u00f4ng th\u1ee9c c\u1ee7a h\u00e0m n\u00e0y l\u00e0:<\/p>\n<table>\n<tbody>\n<tr>\n<td>=SUMIF(range,criteria,[sum_range])<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>Trong \u0111\u00f3:<\/p>\n<ul>\n<li aria-level=\"1\">range: Ph\u1ea1m vi \u00f4 mu\u1ed1n \u00e1p d\u1ee5ng \u0111i\u1ec1u ki\u1ec7n.<\/li>\n<li aria-level=\"1\">criteria: \u0110i\u1ec1u ki\u1ec7n mu\u1ed1n \u00e1p d\u1ee5ng \u0111\u1ec3 t\u00ednh t\u1ed5ng. \u0110i\u1ec1u ki\u1ec7n c\u00f3 th\u1ec3 \u1edf d\u1ea1ng s\u1ed1, tham chi\u1ebfu \u00f4, v\u0103n b\u1ea3n\u2026<\/li>\n<li aria-level=\"1\">sum_range: \u0110\u00e2y l\u00e0 d\u00e3y \u00f4 th\u1ef1c t\u1ebf m\u00e0 b\u1ea1n mu\u1ed1n s\u1eed d\u1ee5ng \u0111\u1ec3 t\u00ednh t\u1ed5ng c\u00e1c s\u1ed1 trong d\u00e3y \u0111\u00f3. N\u1ebfu b\u1ea1n b\u1ecf qua sum_range, Excel s\u1ebd t\u1ef1 \u0111\u1ed9ng t\u00ednh t\u1ed5ng c\u00e1c s\u1ed1 trong range.<\/li>\n<\/ul>\n<p><strong>V\u00ed d\u1ee5:<\/strong> \u0110\u1ec3 t\u00ednh t\u1ed5ng s\u1ed1 m\u00e0u cam \u1edf c\u1ed9t A c\u00f3 s\u1ed1 l\u01b0\u1ee3ng xu\u1ea5t hi\u1ec7n trong c\u1ed9t B \u1edf b\u1ea3ng \u0111\u00e3 cho b\u00ean d\u01b0\u1edbi, b\u1ea1n \u00e1p d\u1ee5ng c\u00f4ng th\u1ee9c =SUMIF(A1:A8,&#8221;cam&#8221;,B1:B8)<\/p>\n<figure id=\"attachment_84323\" aria-describedby=\"caption-attachment-84323\" style=\"width: 730px\" class=\"wp-caption alignnone\"><img loading=\"lazy\" class=\"wp-image-84323 size-full\" src=\"https:\/\/media-blog.jobsgo.vn\/blog\/wp-content\/uploads\/2024\/02\/cach-dung-ham-sumif-trong-excel.jpg\" alt=\"c\u00e1ch d\u00f9ng h\u00e0m sumif trong excel\" width=\"730\" height=\"332\" srcset=\"https:\/\/media-blog.jobsgo.vn\/blog\/wp-content\/uploads\/2024\/02\/cach-dung-ham-sumif-trong-excel.jpg 730w, https:\/\/media-blog.jobsgo.vn\/blog\/wp-content\/uploads\/2024\/02\/cach-dung-ham-sumif-trong-excel-300x136.jpg 300w, https:\/\/media-blog.jobsgo.vn\/blog\/wp-content\/uploads\/2024\/02\/cach-dung-ham-sumif-trong-excel-150x68.jpg 150w\" sizes=\"(max-width: 730px) 100vw, 730px\" \/><figcaption id=\"caption-attachment-84323\" class=\"wp-caption-text\"><center><em>H\u00e0m SUMIF<\/em><\/center><\/figcaption><\/figure>\n<h2><span id=\"3_Cac_Ham_Dung_Trong_Van_Ban\"><strong>3. C\u00e1c H\u00e0m D\u00f9ng Trong V\u0103n B\u1ea3n<\/strong><\/span><\/h2>\n<p><strong>C\u00e1c h\u00e0m trong Excel<\/strong> \u00e1p d\u1ee5ng cho v\u0103n b\u1ea3n bao g\u1ed3m:<\/p>\n<h3><span id=\"31_Ham_LEFTRIGHTMID\"><strong>3.1 H\u00e0m LEFT\/RIGHT\/MID<\/strong><\/span><\/h3>\n<p>H\u00e0m LEFT \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng khi mu\u1ed1n tr\u00edch xu\u1ea5t chu\u1ed7i k\u00fd t\u1ef1 \u1edf b\u00ean tr\u00e1i c\u1ee7a v\u0103n b\u1ea3n \u0111\u01b0\u1ee3c ch\u1ecdn.<\/p>\n<p>C\u00fa ph\u00e1p:<\/p>\n<table>\n<tbody>\n<tr>\n<td>=LEFT(text,[num_chars])<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>Trong \u0111\u00f3:<\/p>\n<ul>\n<li aria-level=\"1\">text: Chu\u1ed7i v\u0103n b\u1ea3n ch\u1ee9a k\u00fd t\u1ef1 mu\u1ed1n c\u1eaft.<\/li>\n<li aria-level=\"1\">num_chars: S\u1ed1 l\u01b0\u1ee3ng k\u00fd t\u1ef1 b\u1ea1n mu\u1ed1n c\u1eaft.<\/li>\n<\/ul>\n<p><strong>V\u00ed d\u1ee5:<\/strong> Trong b\u1ea3ng d\u01b0\u1edbi \u0111\u00e2y, \u0111\u1ec3 t\u00ecm 3 k\u00fd t\u1ef1 \u0111\u1ea7u ti\u00ean t\u1ea1i \u00f4 B2, b\u1ea1n nh\u1eadp c\u00f4ng th\u1ee9c =LEFT(B3,3)<\/p>\n<figure id=\"attachment_84333\" aria-describedby=\"caption-attachment-84333\" style=\"width: 730px\" class=\"wp-caption alignnone\"><img loading=\"lazy\" class=\"wp-image-84333 size-full\" src=\"https:\/\/media-blog.jobsgo.vn\/blog\/wp-content\/uploads\/2024\/02\/ham-left-trong-excel.jpg\" alt=\"h\u00e0m left trong excel\" width=\"730\" height=\"332\" srcset=\"https:\/\/media-blog.jobsgo.vn\/blog\/wp-content\/uploads\/2024\/02\/ham-left-trong-excel.jpg 730w, https:\/\/media-blog.jobsgo.vn\/blog\/wp-content\/uploads\/2024\/02\/ham-left-trong-excel-300x136.jpg 300w, https:\/\/media-blog.jobsgo.vn\/blog\/wp-content\/uploads\/2024\/02\/ham-left-trong-excel-150x68.jpg 150w\" sizes=\"(max-width: 730px) 100vw, 730px\" \/><figcaption id=\"caption-attachment-84333\" class=\"wp-caption-text\"><center><em>H\u00e0m LEFT<\/em><\/center><\/figcaption><\/figure>\n<p>T\u01b0\u01a1ng t\u1ef1 nh\u01b0 h\u00e0m LEFT, h\u00e0m RIGHT c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng \u0111\u1ec3 t\u00e1ch chu\u1ed7i k\u00fd t\u1ef1 t\u00ednh t\u1eeb b\u00ean ph\u1ea3i c\u1ee7a d\u1eef li\u1ec7u \u0111\u01b0\u1ee3c ch\u1ecdn.<\/p>\n<p>C\u00fa ph\u00e1p:<\/p>\n<table>\n<tbody>\n<tr>\n<td>=RIGHT(text,[num_chars])<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p><strong>V\u00ed d\u1ee5:<\/strong> \u0110\u1ec3 t\u00ecm 7 k\u00fd t\u1ef1 cu\u1ed1i t\u1ea1i \u00f4 B2, b\u1ea1n \u00e1p d\u1ee5ng c\u00f4ng th\u1ee9c =RIGHT(B3,7), nh\u1ea5n Enter v\u00e0 \u0111\u01b0\u1ee3c k\u1ebft qu\u1ea3 nh\u01b0 h\u00ecnh.<\/p>\n<figure id=\"attachment_84340\" aria-describedby=\"caption-attachment-84340\" style=\"width: 730px\" class=\"wp-caption alignnone\"><img loading=\"lazy\" class=\"wp-image-84340 size-full\" src=\"https:\/\/media-blog.jobsgo.vn\/blog\/wp-content\/uploads\/2024\/02\/ham-right-trong-excel.jpg\" alt=\"h\u00e0m right trong excel\" width=\"730\" height=\"332\" srcset=\"https:\/\/media-blog.jobsgo.vn\/blog\/wp-content\/uploads\/2024\/02\/ham-right-trong-excel.jpg 730w, https:\/\/media-blog.jobsgo.vn\/blog\/wp-content\/uploads\/2024\/02\/ham-right-trong-excel-300x136.jpg 300w, https:\/\/media-blog.jobsgo.vn\/blog\/wp-content\/uploads\/2024\/02\/ham-right-trong-excel-150x68.jpg 150w\" sizes=\"(max-width: 730px) 100vw, 730px\" \/><figcaption id=\"caption-attachment-84340\" class=\"wp-caption-text\"><center><em>H\u00e0m RIGHT<\/em><\/center><\/figcaption><\/figure>\n<p>H\u00e0m MID cho ph\u00e9p b\u1ea1n ch\u1ecdn ra m\u1ed9t s\u1ed1 l\u01b0\u1ee3ng k\u00fd t\u1ef1 mong mu\u1ed1n t\u1eeb m\u1ed9t chu\u1ed7i v\u0103n b\u1ea3n n\u00e0o \u0111\u00f3.<\/p>\n<p>C\u00fa ph\u00e1p c\u1ee7a h\u00e0m MID l\u00e0:<\/p>\n<table>\n<tbody>\n<tr>\n<td>=MID(text, start_num, num_chars)<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>Trong \u0111\u00f3:<\/p>\n<ul>\n<li aria-level=\"1\">text: Chu\u00f4\u0303i v\u0103n ba\u0309n b\u1ea1n mu\u1ed1n tr\u00edch xu\u1ea5t k\u00fd t\u1ef1.<\/li>\n<li aria-level=\"1\">start_num: V\u1ecb tr\u00ed c\u1ee7a k\u00fd t\u1ef1 \u0111\u1ea7u ti\u00ean trong chu\u1ed7i k\u00fd t\u1ef1 b\u1ea1n mu\u1ed1n c\u1eaft.<\/li>\n<li aria-level=\"1\">num_chars: S\u1ed1 k\u00fd t\u1ef1 b\u1ea1n mu\u1ed1n c\u1eaft.<\/li>\n<\/ul>\n<p><strong>V\u00ed d\u1ee5: <\/strong>\u0110\u1ec3 t\u00ecm 7 k\u00fd t\u1ef1 t\u1ea1i \u00f4 B2 b\u1eaft \u0111\u1ea7u t\u1eeb v\u1ecb tr\u00ed th\u1ee9 3, b\u1ea1n \u00e1p d\u1ee5ng c\u00f4ng th\u1ee9c =LEFT(B3,3,7), nh\u1ea5n Enter v\u00e0 \u0111\u01b0\u1ee3c k\u1ebft qu\u1ea3 &#8220;\u1ea1m V\u0103n &#8221;<\/p>\n<figure id=\"attachment_84325\" aria-describedby=\"caption-attachment-84325\" style=\"width: 730px\" class=\"wp-caption alignnone\"><img loading=\"lazy\" class=\"wp-image-84325 size-full\" src=\"https:\/\/media-blog.jobsgo.vn\/blog\/wp-content\/uploads\/2024\/02\/cach-su-dung-ham-mid-trong-excel-de-cat-chuoi.jpg\" alt=\"c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m mid trong excel \u0111\u1ec3 c\u1eaft chu\u1ed7i\" width=\"730\" height=\"332\" srcset=\"https:\/\/media-blog.jobsgo.vn\/blog\/wp-content\/uploads\/2024\/02\/cach-su-dung-ham-mid-trong-excel-de-cat-chuoi.jpg 730w, https:\/\/media-blog.jobsgo.vn\/blog\/wp-content\/uploads\/2024\/02\/cach-su-dung-ham-mid-trong-excel-de-cat-chuoi-300x136.jpg 300w, https:\/\/media-blog.jobsgo.vn\/blog\/wp-content\/uploads\/2024\/02\/cach-su-dung-ham-mid-trong-excel-de-cat-chuoi-150x68.jpg 150w\" sizes=\"(max-width: 730px) 100vw, 730px\" \/><figcaption id=\"caption-attachment-84325\" class=\"wp-caption-text\"><center><em>H\u00e0m MID<\/em><\/center><\/figcaption><\/figure>\n<h3><span id=\"32_Ham_LEN\"><strong>3.2 H\u00e0m LEN<\/strong><\/span><\/h3>\n<p>H\u00e0m LEN \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng khi mu\u1ed1n \u0111\u1ebfm s\u1ed1 k\u00fd t\u1ef1 trong m\u1ed9t ph\u1ea1m vi n\u00e0o \u0111\u00f3. S\u1ed1 k\u00fd t\u1ef1 n\u00e0y \u0111\u01b0\u1ee3c t\u00ednh bao g\u1ed3m c\u1ea3 kho\u1ea3ng tr\u1eafng.<\/p>\n<p>C\u00fa ph\u00e1p \u00e1p d\u1ee5ng h\u00e0m LEN l\u00e0:<\/p>\n<table>\n<tbody>\n<tr>\n<td>=LEN(chu\u1ed7i k\u00fd t\u1ef1)<\/p>\n<p>ho\u1eb7c =LEN(\u00f4 ch\u1ee9a chu\u1ed7i k\u00fd t\u1ef1)<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p><strong>V\u00ed d\u1ee5:<\/strong> \u0110\u1ec3 \u0111\u1ebfm s\u1ed1 k\u00fd t\u1ef1 c\u1ee7a \u201c\u0110i\u1ec7n m\u00e1y XANH\u201d, b\u1ea1n \u00e1p d\u1ee5ng c\u00f4ng th\u1ee9c =LEN(A1)<\/p>\n<figure id=\"attachment_84334\" aria-describedby=\"caption-attachment-84334\" style=\"width: 730px\" class=\"wp-caption alignnone\"><img loading=\"lazy\" class=\"wp-image-84334 size-full\" src=\"https:\/\/media-blog.jobsgo.vn\/blog\/wp-content\/uploads\/2024\/02\/ham-len.jpg\" alt=\"h\u00e0m len\" width=\"730\" height=\"332\" srcset=\"https:\/\/media-blog.jobsgo.vn\/blog\/wp-content\/uploads\/2024\/02\/ham-len.jpg 730w, https:\/\/media-blog.jobsgo.vn\/blog\/wp-content\/uploads\/2024\/02\/ham-len-300x136.jpg 300w, https:\/\/media-blog.jobsgo.vn\/blog\/wp-content\/uploads\/2024\/02\/ham-len-150x68.jpg 150w\" sizes=\"(max-width: 730px) 100vw, 730px\" \/><figcaption id=\"caption-attachment-84334\" class=\"wp-caption-text\"><center><em>H\u00e0m LEN<\/em><\/center><\/figcaption><\/figure>\n<h3><span id=\"33_Ham_CONCAT\"><strong>3.3 H\u00e0m CONCAT<\/strong><\/span><\/h3>\n<p>Khi mu\u1ed1n n\u1ed1i n\u1ed9i dung c\u1ee7a c\u00e1c \u00f4 l\u1ea1i v\u1edbi nhau, b\u1ea1n n\u00ean s\u1eed d\u1ee5ng h\u00e0m CONCAT.<\/p>\n<p>C\u00fa ph\u00e1p c\u1ee7a h\u00e0m CONCAT l\u00e0:<\/p>\n<table>\n<tbody>\n<tr>\n<td>=CONCAT(Text1;Text2\u2026)<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>Trong \u0111\u00f3: Text1, Text2 l\u00e0 n\u1ed9i dung c\u1ee7a c\u00e1c \u00f4 v\u0103n b\u1ea3n c\u1ea7n n\u1ed1i.<\/p>\n<p><strong>V\u00ed d\u1ee5:<\/strong> =CONCAT(&#8220;\u0110i\u1ec7n&#8221;,&#8221; &#8220;,&#8221;m\u00e1y&#8221;,&#8221; &#8220;,&#8221;XANH&#8221;,&#8221; &#8220;,&#8221;Xin&#8221;,&#8221; &#8220;,&#8221;C\u00e1m&#8221;,&#8221; &#8220;,&#8221;\u01a1n.&#8221;) s\u1ebd tr\u1ea3 v\u1ec1 &#8220;\u0110i\u1ec7n m\u00e1y XANH Xin C\u00e1m \u01a1n.&#8221;<\/p>\n<p><strong>Xem th\u00eam:<\/strong> <a href=\"https:\/\/jobsgo.vn\/blog\/cach-su-dung-excel-de-quan-ly-du-an\/\" target=\"_blank\" rel=\"noopener\"><strong>To\u00e0n t\u1eadp c\u00e1ch s\u1eed d\u1ee5ng Excel \u0111\u1ec3 qu\u1ea3n l\u00fd d\u1ef1 \u00e1n<\/strong><\/a><\/p>\n<h2><span id=\"4_Cac_Ham_Ngay_Thang\"><strong>4. C\u00e1c H\u00e0m Ng\u00e0y, Th\u00e1ng<\/strong><\/span><\/h2>\n<p>H\u00e0m ng\u00e0y, th\u00e1ng bao g\u1ed3m 2 h\u00e0m n\u1ed5i b\u1eadt l\u00e0:<\/p>\n<h3><span id=\"41_Ham_NOW\"><strong>4.1 H\u00e0m NOW<\/strong><\/span><\/h3>\n<p>H\u00e0m NOW l\u00e0 h\u00e0m \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng v\u1edbi m\u1ee5c \u0111\u00edch hi\u1ec3n th\u1ecb th\u1eddi gian th\u1ef1c t\u1ebf tr\u00ean h\u1ec7 th\u1ed1ng. N\u00f3 c\u0169ng \u0111\u01b0\u1ee3c d\u00f9ng trong tr\u01b0\u1eddng h\u1ee3p t\u00ednh to\u00e1n gi\u00e1 tr\u1ecb d\u1ef1a tr\u00ean ng\u00e0y v\u00e0 th\u1eddi gian hi\u1ec7n t\u1ea1i.<\/p>\n<p>C\u00fa ph\u00e1p h\u00e0m NOW nh\u01b0 sau:<\/p>\n<table>\n<tbody>\n<tr>\n<td>=NOW()<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p><strong>V\u00ed d\u1ee5:<\/strong> =NOW() : Tr\u1ea3 v\u1ec1 ng\u00e0y v\u00e0 th\u1eddi gian hi\u1ec7n t\u1ea1i tr\u00ean h\u1ec7 th\u1ed1ng c\u1ee7a b\u1ea1n.<\/p>\n<p>=NOW()+7: Tr\u1ea3 v\u1ec1 ng\u00e0y v\u00e0 th\u1eddi gian 7 ng\u00e0y trong t\u01b0\u01a1ng lai<\/p>\n<figure id=\"attachment_84337\" aria-describedby=\"caption-attachment-84337\" style=\"width: 730px\" class=\"wp-caption alignnone\"><img loading=\"lazy\" class=\"wp-image-84337 size-full\" src=\"https:\/\/media-blog.jobsgo.vn\/blog\/wp-content\/uploads\/2024\/02\/ham-now.jpg\" alt=\"h\u00e0m now\" width=\"730\" height=\"332\" srcset=\"https:\/\/media-blog.jobsgo.vn\/blog\/wp-content\/uploads\/2024\/02\/ham-now.jpg 730w, https:\/\/media-blog.jobsgo.vn\/blog\/wp-content\/uploads\/2024\/02\/ham-now-300x136.jpg 300w, https:\/\/media-blog.jobsgo.vn\/blog\/wp-content\/uploads\/2024\/02\/ham-now-150x68.jpg 150w\" sizes=\"(max-width: 730px) 100vw, 730px\" \/><figcaption id=\"caption-attachment-84337\" class=\"wp-caption-text\"><center><em>H\u00e0m NOW<\/em><\/center><\/figcaption><\/figure>\n<h3><span id=\"42_Ham_DATE\"><strong>4.2 H\u00e0m DATE<\/strong><\/span><\/h3>\n<p>S\u1eed d\u1ee5ng h\u00e0m DATE trong Excel s\u1ebd tr\u1ea3 cho b\u1ea1n k\u1ebft qu\u1ea3 v\u1ec1 th\u1eddi gian c\u1ee5 th\u1ec3 theo l\u1ecbch \u0111\u01b0\u1ee3c c\u00e0i \u0111\u1eb7t tr\u00ean m\u00e1y t\u00ednh c\u1ee7a b\u1ea1n.<\/p>\n<p>C\u00fa ph\u00e1p:<\/p>\n<table>\n<tbody>\n<tr>\n<td>=DATE(Year,Month,Day)<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p><strong>V\u00ed d\u1ee5:<\/strong> =DATE(2023,01,18) tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 ng\u00e0y 18 th\u00e1ng 1 n\u0103m 2023<\/p>\n<figure id=\"attachment_84322\" aria-describedby=\"caption-attachment-84322\" style=\"width: 800px\" class=\"wp-caption alignnone\"><img loading=\"lazy\" class=\"wp-image-84322 size-full\" src=\"https:\/\/media-blog.jobsgo.vn\/blog\/wp-content\/uploads\/2024\/02\/cach-dung-ham-date-trong-excel.jpg\" alt=\"c\u00e1ch d\u00f9ng h\u00e0m date trong excel\" width=\"800\" height=\"550\" srcset=\"https:\/\/media-blog.jobsgo.vn\/blog\/wp-content\/uploads\/2024\/02\/cach-dung-ham-date-trong-excel.jpg 800w, https:\/\/media-blog.jobsgo.vn\/blog\/wp-content\/uploads\/2024\/02\/cach-dung-ham-date-trong-excel-300x206.jpg 300w, https:\/\/media-blog.jobsgo.vn\/blog\/wp-content\/uploads\/2024\/02\/cach-dung-ham-date-trong-excel-150x103.jpg 150w, https:\/\/media-blog.jobsgo.vn\/blog\/wp-content\/uploads\/2024\/02\/cach-dung-ham-date-trong-excel-768x528.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/><figcaption id=\"caption-attachment-84322\" class=\"wp-caption-text\"><center><em>H\u00e0m DATE<\/em><\/center><\/figcaption><\/figure>\n<h2><span id=\"5_Cac_Ham_Tra_Cuu_Du_Lieu\"><strong>5. C\u00e1c H\u00e0m Tra C\u1ee9u D\u1eef Li\u1ec7u<\/strong><\/span><\/h2>\n<p>Ngo\u00e0i ra, c\u00f2n c\u00f3 m\u1ed9t s\u1ed1 h\u00e0m \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng trong tra c\u1ee9u d\u1eef li\u1ec7u, c\u1ee5 th\u1ec3 l\u00e0:<\/p>\n<h3><span id=\"51_Ham_VLOOKUP\"><strong>5.1 H\u00e0m VLOOKUP<\/strong><\/span><\/h3>\n<p>H\u00e0m VLOOKUP l\u00e0 h\u00e0m cho ph\u00e9p b\u1ea1n c\u00f3 th\u1ec3 d\u00f2 t\u00ecm d\u1eef li\u1ec7u trong m\u1ed9t b\u1ea3ng, m\u1ed9t ph\u1ea1m vi theo h\u00e0ng d\u1ecdc. K\u1ebft qu\u1ea3 b\u1ea1n nh\u1eadn \u0111\u01b0\u1ee3c s\u1ebd l\u00e0 d\u1eef li\u1ec7u theo h\u00e0ng ngang.<\/p>\n<p>C\u00fa ph\u00e1p:<\/p>\n<table>\n<tbody>\n<tr>\n<td>=VLOOKUP(Lookup_value, Table_array, Col_index_ num, Range_lookup)<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>Trong \u0111\u00f3:<\/p>\n<ul>\n<li aria-level=\"1\">Lookup_value: \u0110\u00e2y l\u00e0 gi\u00e1 tr\u1ecb m\u00e0 b\u1ea1n mu\u1ed1n tra c\u1ee9u. B\u1ea1n c\u00f3 th\u1ec3 \u0111i\u1ec1n gi\u00e1 tr\u1ecb c\u1ee5 th\u1ec3 ho\u1eb7c \u0111\u1ecba ch\u1ec9 c\u1ee7a m\u1ed9t \u00f4 tr\u00ean b\u1ea3ng t\u00ednh.<\/li>\n<li aria-level=\"1\">Table_array: Gi\u1edbi h\u1ea1n c\u1ee7a b\u1ea3ng c\u1ea7n d\u00f2 t\u00ecm.<\/li>\n<li aria-level=\"1\">Col_index_num: S\u1ed1 th\u1ee9 t\u1ef1 t\u00ednh t\u1eeb tr\u00e1i qua ph\u1ea3i c\u1ee7a c\u1ed9t c\u1ea7n d\u00f2 t\u00ecm.<\/li>\n<li aria-level=\"1\">Range_lookup: x\u00e1c \u0111\u1ecbnh c\u00e1ch th\u1ee9c t\u00ecm ki\u1ebfm l\u00e0 ch\u00ednh x\u00e1c hay t\u01b0\u01a1ng \u0111\u1ed1i. N\u1ebfu b\u1ea1n b\u1ecf qua Range_lookup, Excel s\u1ebd t\u1ef1 \u0111\u1ed9ng m\u1eb7c \u0111\u1ecbnh l\u00e0 d\u00f2 t\u00ecm t\u01b0\u01a1ng \u0111\u1ed1i.<\/li>\n<\/ul>\n<ul>\n<li aria-level=\"1\">N\u1ebfu Range_lookup = 1 (TRUE): d\u00f2 t\u00ecm t\u01b0\u01a1ng \u0111\u1ed1i.<\/li>\n<li aria-level=\"1\">N\u1ebfu Range_lookup = 0 (FALSE): d\u00f2 t\u00ecm ch\u00ednh x\u00e1c.<\/li>\n<\/ul>\n<p><strong>V\u00ed d\u1ee5:<\/strong> \u0110\u1ec3 x\u00e1c \u0111\u1ecbnh m\u1ee9c ph\u1ee5 c\u1ea5p cho nh\u00e2n vi\u00ean v\u1edbi d\u1eef li\u1ec7u \u0111\u01b0\u1ee3c cho trong b\u1ea3ng d\u01b0\u1edbi, t\u1ea1i \u00f4 E4, b\u1ea1n \u0111i\u1ec1n c\u00f4ng th\u1ee9c: =VLOOKUP(D4,$H$3:$I$8,2,0)<\/p>\n<p>Gi\u1ea3i th\u00edch c\u00f4ng th\u1ee9c:<\/p>\n<ul>\n<li aria-level=\"1\">D\u1ea5u $ \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 c\u1ed1 \u0111\u1ecbnh c\u00e1c d\u00f2ng, c\u00e1c c\u1ed9t c\u1ee7a b\u1ea3ng 2 khi b\u1ea1n copy c\u00f4ng th\u1ee9c sang c\u00e1c \u00f4 kh\u00e1c.<\/li>\n<li aria-level=\"1\">2 l\u00e0 s\u1ed1 th\u1ee9 t\u1ef1 c\u1ee7a c\u1ed9t d\u1eef li\u1ec7u.<\/li>\n<li aria-level=\"1\">Range_lookup = 0 (FALSE) \u0111\u1ec3 d\u00f2 t\u00ecm ch\u00ednh x\u00e1c.<\/li>\n<\/ul>\n<figure id=\"attachment_84341\" aria-describedby=\"caption-attachment-84341\" style=\"width: 730px\" class=\"wp-caption alignnone\"><img loading=\"lazy\" class=\"wp-image-84341 size-full\" src=\"https:\/\/media-blog.jobsgo.vn\/blog\/wp-content\/uploads\/2024\/02\/ham-vlookup.jpg\" alt=\"h\u00e0m vlookup\" width=\"730\" height=\"332\" srcset=\"https:\/\/media-blog.jobsgo.vn\/blog\/wp-content\/uploads\/2024\/02\/ham-vlookup.jpg 730w, https:\/\/media-blog.jobsgo.vn\/blog\/wp-content\/uploads\/2024\/02\/ham-vlookup-300x136.jpg 300w, https:\/\/media-blog.jobsgo.vn\/blog\/wp-content\/uploads\/2024\/02\/ham-vlookup-150x68.jpg 150w\" sizes=\"(max-width: 730px) 100vw, 730px\" \/><figcaption id=\"caption-attachment-84341\" class=\"wp-caption-text\"><center><em>H\u00e0m VLOOKUP<\/em><\/center><\/figcaption><\/figure>\n<h3><span id=\"52_Ham_INDEX\"><strong>5.2 H\u00e0m INDEX<\/strong><\/span><\/h3>\n<p>Khi s\u1eed d\u1ee5ng h\u00e0m INDEX, b\u1ea1n s\u1ebd nh\u1eadn \u0111\u01b0\u1ee3c k\u1ebft qu\u1ea3 l\u00e0 m\u1ed9t gi\u00e1 tr\u1ecb ho\u1eb7c \u0111\u1ecba ch\u1ec9 \u00f4 c\u00f3 ch\u1ee9a d\u1eef li\u1ec7u c\u1ea7n tra c\u1ee9u.<\/p>\n<p>C\u00fa ph\u00e1p:<\/p>\n<table>\n<tbody>\n<tr>\n<td>=INDEX(array, row_num, column_num)<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>V\u1edbi:<\/p>\n<ul>\n<li aria-level=\"1\">array: Array ch\u00ednh l\u00e0 ph\u1ea1m vi c\u1ee7a \u00f4 ho\u1eb7c h\u1eb1ng s\u1ed1 m\u1ea3ng b\u1ea1n mu\u1ed1n tra c\u1ee9u.<\/li>\n<li aria-level=\"1\">row_num: Th\u1ee9 t\u1ef1 c\u1ee7a h\u00e0ng trong ph\u1ea1m vi ch\u1ee9a gi\u00e1 tr\u1ecb mu\u1ed1n nh\u1eadn.<\/li>\n<li aria-level=\"1\">column_num: Th\u1ee9 t\u1ef1 c\u1ee7a c\u1ed9t trong ph\u1ea1m vi ch\u1ee9a gi\u00e1 tr\u1ecb mu\u1ed1n nh\u1eadn.<\/li>\n<\/ul>\n<p><strong>V\u00ed d\u1ee5:<\/strong> N\u1ebfu b\u1ea1n mu\u1ed1n t\u00ecm gi\u00e1 tr\u1ecb c\u1ee7a ph\u1ea7n t\u1eed \u1edf d\u00f2ng th\u1ee9 4, c\u1ed9t th\u1ee9 1 trong m\u1ea3ng (M\u1ea3ng g\u1ed3m 10 d\u00f2ng v\u00e0 4 c\u1ed9t (c\u00f3 \u0111\u1ecba ch\u1ec9 l\u00e0 B4:E13)), b\u1ea1n nh\u1eadp c\u00f4ng th\u1ee9c: =INDEX(B4:E13,4,1)<\/p>\n<p>Gi\u1ea3i th\u00edch c\u00f4ng th\u1ee9c:<\/p>\n<ul>\n<li aria-level=\"1\">B4:E13 l\u00e0 m\u1ea3ng ch\u1ee9a gi\u00e1 tr\u1ecb c\u1ea7n tr\u1ea3 v\u1ec1.<\/li>\n<li aria-level=\"1\">4 l\u00e0 s\u1ed1 th\u1ee9 t\u1ef1 c\u1ee7a h\u00e0ng trong m\u1ea3ng ch\u1ee9a gi\u00e1 tr\u1ecb c\u1ea7n tr\u1ea3 v\u1ec1.<\/li>\n<li aria-level=\"1\">1 l\u00e0 s\u1ed1 th\u1ee9 t\u1ef1 c\u1ee7a c\u1ed9t trong m\u1ea3ng ch\u1ee9a gi\u00e1 tr\u1ecb c\u1ea7n tr\u1ea3 v\u1ec1.<\/li>\n<li aria-level=\"1\">Sau khi nh\u1eadp xong, b\u1ea1n nh\u1ea5n Enter. K\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 s\u1ebd nh\u01b0 h\u00ecnh d\u01b0\u1edbi.<\/li>\n<\/ul>\n<figure id=\"attachment_84332\" aria-describedby=\"caption-attachment-84332\" style=\"width: 730px\" class=\"wp-caption alignnone\"><img loading=\"lazy\" class=\"wp-image-84332 size-full\" src=\"https:\/\/media-blog.jobsgo.vn\/blog\/wp-content\/uploads\/2024\/02\/ham-index.jpg\" alt=\"h\u00e0m index\" width=\"730\" height=\"332\" srcset=\"https:\/\/media-blog.jobsgo.vn\/blog\/wp-content\/uploads\/2024\/02\/ham-index.jpg 730w, https:\/\/media-blog.jobsgo.vn\/blog\/wp-content\/uploads\/2024\/02\/ham-index-300x136.jpg 300w, https:\/\/media-blog.jobsgo.vn\/blog\/wp-content\/uploads\/2024\/02\/ham-index-150x68.jpg 150w\" sizes=\"(max-width: 730px) 100vw, 730px\" \/><figcaption id=\"caption-attachment-84332\" class=\"wp-caption-text\"><center><em>H\u00e0m INDEX<\/em><\/center><\/figcaption><\/figure>\n<h3><span id=\"53_Ham_MATCH\"><strong>5.3 H\u00e0m MATCH<\/strong><\/span><\/h3>\n<p>H\u00e0m MATCH cho ph\u00e9p ng\u01b0\u1eddi d\u00f9ng c\u00f3 th\u1ec3 t\u00ecm ki\u1ebfm v\u00e0 x\u00e1c \u0111\u1ecbnh v\u1ecb tr\u00ed t\u01b0\u01a1ng \u0111\u1ed1i c\u1ee7a gi\u00e1 tr\u1ecb mong mu\u1ed1n trong ph\u1ea1m vi n\u00e0o \u0111\u00f3.<\/p>\n<p>C\u00fa ph\u00e1p c\u1ee7a h\u00e0m l\u00e0:<\/p>\n<table>\n<tbody>\n<tr>\n<td>=Match(Lookup_value, Lookup_array, Match_type)<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>Trong \u0111\u00f3:<\/p>\n<ul>\n<li aria-level=\"1\">Lookup_value: Gi\u00e1 tr\u1ecb m\u00e0 b\u1ea1n mu\u1ed1n tra c\u1ee9u.<\/li>\n<li aria-level=\"1\">Lookup_array: Ph\u1ea1m vi ch\u1ee9a gi\u00e1 tr\u1ecb mu\u1ed1n tra c\u1ee9u.<\/li>\n<li aria-level=\"1\">Match_type:<\/li>\n<\/ul>\n<ul>\n<li aria-level=\"1\">Ki\u1ec3u kh\u1edbp l\u00e0 0: Tr\u1ea3 v\u1ec1 v\u1ecb tr\u00ed t\u01b0\u01a1ng \u0111\u1ed1i c\u1ee7a gi\u00e1 tr\u1ecb trong tr\u01b0\u1eddng h\u1ee3p v\u00f9ng d\u1eef li\u1ec7u ch\u01b0a \u0111\u01b0\u1ee3c s\u1eafp x\u1ebfp.<\/li>\n<li aria-level=\"1\">Ki\u1ec3u kh\u1edbp l\u00e0 1: Tr\u1ea3 v\u1ec1 v\u1ecb tr\u00ed c\u1ee7a gi\u00e1 tr\u1ecb l\u1edbn nh\u1ea5t. Tuy nhi\u00ean, gi\u00e1 tr\u1ecb n\u00e0y nh\u1ecf h\u01a1n ho\u1eb7c b\u1eb1ng gi\u00e1 tr\u1ecb mu\u1ed1n tra c\u1ee9u. (Gi\u1ea3 s\u1eed d\u1eef li\u1ec7u \u0111\u01b0\u1ee3c s\u1eafp x\u1ebfp theo th\u1ee9 t\u1ef1 t\u0103ng d\u1ea7n).<\/li>\n<li aria-level=\"1\">Ki\u1ec3u kh\u1edbp l\u00e0 -1: Tr\u1ea3 v\u1ec1 v\u1ecb tr\u00ed c\u1ee7a gi\u00e1 tr\u1ecb nh\u1ecf nh\u1ea5t. Tuy nhi\u00ean, gi\u00e1 tr\u1ecb n\u00e0y l\u1edbn h\u01a1n ho\u1eb7c b\u1eb1ng gi\u00e1 tr\u1ecb mu\u1ed1n tra c\u1ee9u. (Gi\u1ea3 s\u1eed d\u1eef li\u1ec7u \u0111\u01b0\u1ee3c s\u1eafp x\u1ebfp theo th\u1ee9 t\u1ef1 gi\u1ea3m d\u1ea7n).<\/li>\n<\/ul>\n<p><strong>V\u00ed d\u1ee5: <\/strong>\u0110\u1ec3 t\u00ecm v\u1ecb tr\u00ed c\u1ee7a h\u1ecdc sinh L\u00e2m Thi\u00ean Trang trong nh\u1eefng h\u1ed3 s\u01a1 \u1ee9ng tuy\u1ec3n, t\u1ea1i \u00f4 G3 ta th\u1ef1c hi\u1ec7n c\u00f4ng th\u1ee9c: =MATCH(G1,A2:A9,0)<\/p>\n<figure id=\"attachment_84347\" aria-describedby=\"caption-attachment-84347\" style=\"width: 730px\" class=\"wp-caption alignnone\"><img loading=\"lazy\" class=\"wp-image-84347 size-full\" src=\"https:\/\/media-blog.jobsgo.vn\/blog\/wp-content\/uploads\/2024\/02\/ham-match-trong-excel-la-gi-1.jpg\" alt=\"h\u00e0m match trong excel l\u00e0 g\u00ec\" width=\"730\" height=\"282\" srcset=\"https:\/\/media-blog.jobsgo.vn\/blog\/wp-content\/uploads\/2024\/02\/ham-match-trong-excel-la-gi-1.jpg 730w, https:\/\/media-blog.jobsgo.vn\/blog\/wp-content\/uploads\/2024\/02\/ham-match-trong-excel-la-gi-1-300x116.jpg 300w, https:\/\/media-blog.jobsgo.vn\/blog\/wp-content\/uploads\/2024\/02\/ham-match-trong-excel-la-gi-1-150x58.jpg 150w\" sizes=\"(max-width: 730px) 100vw, 730px\" \/><figcaption id=\"caption-attachment-84347\" class=\"wp-caption-text\"><center><em>Ham-MATCH<\/em><\/center><\/figcaption><\/figure>\n<p><strong>Xem th\u00eam:<\/strong> <a href=\"https:\/\/jobsgo.vn\/blog\/cach-sua-loi-value-trong-excel\/\" target=\"_blank\" rel=\"noopener\"><strong>C\u00e1ch s\u1eefa l\u1ed7i value trong Excel<\/strong><\/a><\/p>\n<h3><span id=\"54_Ham_HLOOKUP\"><strong>5.4. H\u00e0m HLOOKUP<\/strong><\/span><\/h3>\n<p>H\u00e0m HLOOKUP l\u00e0 h\u00e0m t\u00ecm ki\u1ebfm m\u1ed9t gi\u00e1 tr\u1ecb tr\u00ean d\u00f2ng \u0111\u1ea7u ti\u00ean c\u1ee7a b\u1ea3ng tham chi\u1ebfu v\u00e0 cho k\u1ebft qu\u1ea3 t\u01b0\u01a1ng \u1ee9ng trong d\u00f2ng ch\u1ec9 \u0111\u1ecbnh.<\/p>\n<p>C\u00fa ph\u00e1p:<\/p>\n<table>\n<tbody>\n<tr>\n<td>=HLOOKUP(Lookup_value,Table_ array,Row_index_Num,Range_lookup)<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>Trong \u0111\u00f3:<\/p>\n<ul>\n<li aria-level=\"1\">Lookup_value: gi\u00e1 tr\u1ecb \u0111\u1ed1i chi\u1ebfu v\u1edbi d\u00f2ng \u0111\u1ea7u ti\u00ean c\u1ee7a b\u1ea3ng tham chi\u1ebfu \u0111\u1ec3 l\u1ea5y \u0111\u01b0\u1ee3c gi\u00e1 tr\u1ecb c\u1ea7n t\u00ecm.<\/li>\n<li aria-level=\"1\">Table_array: l\u00e0 \u0111\u1ecba ch\u1ec9 tuy\u1ec7t \u0111\u1ed1i c\u1ee7a b\u1ea3ng tham chi\u1ebfu (kh\u00f4ng t\u00ednh c\u1ed9t ti\u00eau \u0111\u1ec1)c<\/li>\n<li aria-level=\"1\">Row_index_Num: S\u1ed1 th\u1ee9 t\u1ef1 d\u00f2ng ch\u1ee9a gi\u00e1 tr\u1ecb c\u1ea7n l\u1ea5y.<\/li>\n<li aria-level=\"1\">Range_lookup: C\u00e1ch t\u00ecm ki\u1ebfm tr\u00ean b\u1ea3ng tham chi\u1ebfu.<\/li>\n<\/ul>\n<ul>\n<li aria-level=\"1\">&#8220;+ 0&#8221;: D\u00f2ng \u0111\u1ea7u ti\u00ean c\u1ee7a b\u1ea3ng tham chi\u1ebfu ch\u01b0a s\u1eafp x\u1ebfp.<\/li>\n<li aria-level=\"1\">&#8220;+ 1&#8221;: d\u00f2ng \u0111\u1ea7u ti\u00ean c\u1ee7a b\u1ea3ng tham chi\u1ebfu \u0111\u00e3 s\u1eafp x\u1ebfp theo chi\u1ec1u t\u0103ng d\u1ea7n (ng\u1ea7m \u0111\u1ecbnh).<\/li>\n<\/ul>\n<p><strong>V\u00ed d\u1ee5<\/strong>: V\u1edbi \u0111i\u1ec3m s\u1ed1 \u0111\u00e3 c\u00f3, ta c\u1ea7n x\u1ebfp lo\u1ea1i h\u1ecdc sinh trong B\u1ea3ng 1 d\u1ef1a v\u00e0o d\u1eef li\u1ec7u \u1edf B\u1ea3ng 2. T\u1ea1i D4 ta c\u00f3: =HLOOKUP(C4,$B$11:$F$12,2,1). H\u00e0m HLOOKUP s\u1ebd ti\u1ebfn h\u00e0nh d\u00f2 t\u00ecm \u0111i\u1ec3m s\u1ed1 \u1edf \u00f4 C4 trong B\u1ea3ng 2 t\u1eeb tr\u00e1i qua ph\u1ea3i. Khi t\u00ecm th\u1ea5y gi\u00e1 tr\u1ecb g\u1ea7n b\u1eb1ng, n\u00f3 s\u1ebd tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 x\u1ebfp lo\u1ea1i t\u01b0\u01a1ng \u1ee9ng n\u1eb1m \u1edf h\u00e0ng 2.<\/p>\n<figure id=\"attachment_84348\" aria-describedby=\"caption-attachment-84348\" style=\"width: 730px\" class=\"wp-caption alignnone\"><img loading=\"lazy\" class=\"wp-image-84348 size-full\" src=\"https:\/\/media-blog.jobsgo.vn\/blog\/wp-content\/uploads\/2024\/02\/ham-hlookup-trong-excel-1.jpg\" alt=\"h\u00e0m hlookup trong excel\" width=\"730\" height=\"332\" srcset=\"https:\/\/media-blog.jobsgo.vn\/blog\/wp-content\/uploads\/2024\/02\/ham-hlookup-trong-excel-1.jpg 730w, https:\/\/media-blog.jobsgo.vn\/blog\/wp-content\/uploads\/2024\/02\/ham-hlookup-trong-excel-1-300x136.jpg 300w, https:\/\/media-blog.jobsgo.vn\/blog\/wp-content\/uploads\/2024\/02\/ham-hlookup-trong-excel-1-150x68.jpg 150w\" sizes=\"(max-width: 730px) 100vw, 730px\" \/><figcaption id=\"caption-attachment-84348\" class=\"wp-caption-text\"><center><em>H\u00e0m HLOOKUP<\/em><\/center><\/figcaption><\/figure>\n<h2><span id=\"6_Loi_Ich_Khi_Su_Dung_Cac_Ham_Trong_Excel_La_Gi\"><strong>6. L\u1ee3i \u00cdch Khi S\u1eed D\u1ee5ng C\u00e1c H\u00e0m Trong Excel L\u00e0 G\u00ec?<\/strong><\/span><\/h2>\n<p>Excel cung c\u1ea5p c\u00e1c h\u00e0m t\u00ednh to\u00e1n linh ho\u1ea1t, gi\u00fap b\u1ea1n th\u1ef1c hi\u1ec7n c\u00e1c thao t\u00e1c ph\u1ee9c t\u1ea1p tr\u00ean d\u1eef li\u1ec7u d\u1ec5 d\u00e0ng h\u01a1n bao gi\u1edd h\u1ebft.<\/p>\n<h3><span id=\"61_Toi_Uu_Hoa_Quy_Trinh_Lam_Viec\"><strong>6.1 T\u1ed1i \u01afu H\u00f3a Quy Tr\u00ecnh L\u00e0m Vi\u1ec7c<\/strong><\/span><\/h3>\n<p>Vi\u1ec7c s\u1eed d\u1ee5ng c\u00e1c h\u00e0m trong Excel gi\u00fap t\u1ed1i \u01b0u h\u00f3a quy tr\u00ecnh l\u00e0m vi\u1ec7c v\u00e0 gi\u1ea3m thi\u1ec3u th\u1eddi gian d\u00e0nh cho c\u00e1c t\u00e1c v\u1ee5 l\u1eb7p \u0111i l\u1eb7p l\u1ea1i. Thay v\u00ec ph\u1ea3i nh\u1eadp c\u00f4ng th\u1ee9c m\u1ed9t c\u00e1ch th\u1ee7 c\u00f4ng cho t\u1eebng \u00f4 ho\u1eb7c t\u1eebng b\u1ea3ng d\u1eef li\u1ec7u, b\u1ea1n c\u00f3 th\u1ec3 ch\u1ecdn m\u1ed9t h\u00e0m th\u00edch h\u1ee3p t\u1eeb danh s\u00e1ch c\u00f3 s\u1eb5n. Sau khi nh\u1eadp c\u00e1c tham s\u1ed1 c\u1ea7n thi\u1ebft, Excel s\u1ebd t\u1ef1 \u0111\u1ed9ng th\u1ef1c hi\u1ec7n ph\u00e9p t\u00ednh, \u0111\u01b0a ra k\u1ebft qu\u1ea3 ngay l\u1eadp t\u1ee9c.<\/p>\n<p>\u0110i\u1ec1u n\u00e0y kh\u00f4ng ch\u1ec9 gi\u00fap b\u1ea1n ti\u1ebft ki\u1ec7m th\u1eddi gian m\u00e0 c\u00f2n gi\u1ea3m thi\u1ec3u kh\u1ea3 n\u0103ng x\u1ea3y ra sai s\u00f3t do thao t\u00e1c th\u1ee7 c\u00f4ng. H\u01a1n n\u1eefa, v\u1edbi vi\u1ec7c s\u1eed d\u1ee5ng h\u00e0m, b\u1ea1n d\u1ec5 d\u00e0ng \u00e1p d\u1ee5ng c\u00e1c thay \u0111\u1ed5i cho nhi\u1ec1u \u00f4 d\u1eef li\u1ec7u b\u1eb1ng c\u00e1ch \u0111i\u1ec1u ch\u1ec9nh tham s\u1ed1 \u0111\u1ea7u v\u00e0o, m\u00e0 kh\u00f4ng c\u1ea7n ph\u1ea3i ch\u1ec9nh s\u1eeda t\u1eebng c\u00f4ng th\u1ee9c ri\u00eang l\u1ebb.<\/p>\n<h3><span id=\"62_Cai_Thien_Do_Chinh_Xac_Va_Chat_Luong_Thong_Tin\"><strong>6.2 C\u1ea3i Thi\u1ec7n \u0110\u1ed9 Ch\u00ednh X\u00e1c V\u00e0 Ch\u1ea5t L\u01b0\u1ee3ng Th\u00f4ng Tin<\/strong><\/span><\/h3>\n<p>Khi b\u1ea1n s\u1eed d\u1ee5ng h\u00e0m, \u0111\u1ed9 ch\u00ednh x\u00e1c c\u1ee7a k\u1ebft qu\u1ea3 t\u00ednh to\u00e1n s\u1ebd cao h\u01a1n r\u1ea5t nhi\u1ec1u so v\u1edbi vi\u1ec7c th\u1ef1c hi\u1ec7n t\u00ednh to\u00e1n b\u1eb1ng tay. C\u00e1c h\u00e0m \u0111\u01b0\u1ee3c l\u1eadp tr\u00ecnh s\u1eb5n trong Excel \u0111\u00e3 \u0111\u01b0\u1ee3c ki\u1ec3m tra k\u1ef9 l\u01b0\u1ee1ng \u0111\u1ec3 \u0111\u1ea3m b\u1ea3o t\u00ednh ch\u00ednh x\u00e1c. B\u1ea1n c\u00f3 th\u1ec3 d\u1ec5 d\u00e0ng ki\u1ec3m tra l\u1ea1i c\u00e1c c\u00f4ng th\u1ee9c v\u00e0 k\u1ebft qu\u1ea3 \u0111\u1ec3 ph\u00e1t hi\u1ec7n, s\u1eeda l\u1ed7i khi c\u1ea7n thi\u1ebft, \u0111i\u1ec1u \u0111\u00f3 g\u00f3p ph\u1ea7n n\u00e2ng cao \u0111\u1ed9 tin c\u1eady c\u1ee7a d\u1eef li\u1ec7u m\u00e0 b\u1ea1n \u0111ang l\u00e0m vi\u1ec7c.<\/p>\n<p>C\u00e1c h\u00e0m trong Excel c\u0169ng gi\u00fap b\u1ea1n d\u1ec5 d\u00e0ng h\u01a1n trong vi\u1ec7c qu\u1ea3n l\u00fd v\u00e0 x\u1eed l\u00fd d\u1eef li\u1ec7u l\u1edbn. N\u1ebfu ph\u00e1t hi\u1ec7n sai s\u00f3t trong d\u1eef li\u1ec7u, b\u1ea1n c\u00f3 th\u1ec3 nhanh ch\u00f3ng x\u00e1c \u0111\u1ecbnh, \u0111i\u1ec1u ch\u1ec9nh m\u00e0 kh\u00f4ng ph\u1ea3i lo l\u1eafng v\u1ec1 vi\u1ec7c li\u1ec7u c\u00e1c k\u1ebft qu\u1ea3 t\u00ednh to\u00e1n c\u00f3 b\u1ecb \u1ea3nh h\u01b0\u1edfng hay kh\u00f4ng.<\/p>\n<h3><span id=\"63_Cai_Thien_Kha_Nang_Phan_Tich_Va_Bao_Cao_Thong_Tin\"><strong>6.3 C\u1ea3i Thi\u1ec7n Kh\u1ea3 N\u0103ng Ph\u00e2n T\u00edch V\u00e0 B\u00e1o C\u00e1o Th\u00f4ng Tin<\/strong><\/span><\/h3>\n<p>S\u1eed d\u1ee5ng c\u00e1c h\u00e0m trong Excel cho ph\u00e9p b\u1ea1n th\u1ef1c hi\u1ec7n c\u00e1c ph\u00e2n t\u00edch d\u1eef li\u1ec7u m\u1ed9t c\u00e1ch s\u00e2u s\u1eafc, hi\u1ec7u qu\u1ea3 h\u01a1n. C\u00e1c h\u00e0m nh\u01b0 VLOOKUP, HLOOKUP, INDEX\/MATCH gi\u00fap b\u1ea1n t\u00ecm ki\u1ebfm v\u00e0 l\u1ea5y d\u1eef li\u1ec7u t\u1eeb c\u00e1c b\u1ea3ng kh\u00e1c nhau m\u00e0 kh\u00f4ng c\u1ea7n ph\u1ea3i cu\u1ed9n qua t\u1eebng \u00f4.<\/p>\n<p>B\u1ea1n c\u0169ng c\u00f3 th\u1ec3 t\u1ea1o ra c\u00e1c b\u00e1o c\u00e1o tr\u1ef1c quan b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng c\u00e1c h\u00e0m \u0111\u1ec3 t\u1ef1 \u0111\u1ed9ng h\u00f3a vi\u1ec7c t\u00ednh to\u00e1n v\u00e0 c\u1eadp nh\u1eadt d\u1eef li\u1ec7u. Vi\u1ec7c n\u00e0y r\u1ea5t h\u1eefu \u00edch trong qu\u00e1 tr\u00ecnh t\u1ea1o ra c\u00e1c b\u1ea3ng \u0111i\u1ec1u khi\u1ec3n (dashboard) ho\u1eb7c bi\u1ec3u \u0111\u1ed3 m\u00e0 b\u1ea1n c\u00f3 th\u1ec3 chia s\u1ebb v\u1edbi \u0111\u1ed3ng nghi\u1ec7p hay c\u1ea5p tr\u00ean. Nh\u1edd v\u00e0o t\u00ednh n\u0103ng \u0111\u00f3, c\u00e1c th\u00f4ng tin quan tr\u1ecdng \u0111\u01b0\u1ee3c tr\u00ecnh b\u00e0y m\u1ed9t c\u00e1ch tr\u1ef1c quan, d\u1ec5 hi\u1ec3u h\u01a1n, gi\u00fap b\u1ea1n \u0111\u01b0a ra c\u00e1c quy\u1ebft \u0111\u1ecbnh d\u1ef1a tr\u00ean th\u00f4ng tin ch\u00ednh x\u00e1c, k\u1ecbp th\u1eddi.<\/p>\n<p>H\u01a1n n\u1eefa, kh\u1ea3 n\u0103ng s\u1eed d\u1ee5ng c\u00e1c h\u00e0m c\u0169ng gi\u00fap b\u1ea1n l\u1ecdc v\u00e0 ph\u00e2n lo\u1ea1i d\u1eef li\u1ec7u theo nhi\u1ec1u ti\u00eau ch\u00ed kh\u00e1c nhau, nhanh ch\u00f3ng t\u00ecm ra c\u00e1c xu h\u01b0\u1edbng c\u0169ng nh\u01b0 m\u1eabu trong d\u1eef li\u1ec7u m\u00e0 c\u00f3 th\u1ec3 b\u1ea1n \u0111\u00e3 b\u1ecf l\u1ee1 khi x\u1eed l\u00fd th\u1ee7 c\u00f4ng.<\/p>\n<h2><span id=\"7_Luu_Y_Khi_Thuc_Hien_Cac_Ham_Trong_Excel\"><strong>7. L\u01b0u \u00dd Khi Th\u1ef1c Hi\u1ec7n C\u00e1c H\u00e0m Trong Excel<\/strong><\/span><\/h2>\n<p>\u0110\u1ec3 \u0111\u1ea3m b\u1ea3o c\u00f4ng th\u1ee9c trong Excel \u0111\u01b0\u1ee3c t\u00ednh ch\u00ednh x\u00e1c v\u00e0 tr\u00e1nh c\u00e1c sai s\u00f3t kh\u00f4ng mong mu\u1ed1n, c\u00f3 m\u1ed9t s\u1ed1 l\u01b0u \u00fd quan tr\u1ecdng b\u1ea1n c\u1ea7n ghi nh\u1edb khi s\u1eed d\u1ee5ng c\u00e1c h\u00e0m.<\/p>\n<ul>\n<li aria-level=\"1\">Khi t\u1ea1o c\u00e1c h\u00e0m trong Excel, b\u1ea1n ph\u1ea3i lu\u00f4n b\u1eaft \u0111\u1ea7u b\u1eb1ng d\u1ea5u \u201c=\u201d \u0111\u1ec3 Excel nh\u1eadn di\u1ec7n \u0111\u00f3 l\u00e0 c\u00f4ng th\u1ee9c. D\u00f9 t\u00ean h\u00e0m b\u1ea1n nh\u1eadp c\u00f3 vi\u1ebft hoa hay vi\u1ebft th\u01b0\u1eddng, Excel v\u1eabn hi\u1ec3u v\u00e0 th\u1ef1c thi \u0111\u00fang l\u1ec7nh.<\/li>\n<li aria-level=\"1\">Trong qu\u00e1 tr\u00ecnh nh\u1eadp c\u00f4ng th\u1ee9c, c\u00e1c \u0111\u1ed1i s\u1ed1 c\u1ea7n \u0111\u01b0\u1ee3c \u0111\u1eb7t trong ngo\u1eb7c \u0111\u01a1n v\u00e0 ph\u00e2n t\u00e1ch b\u1eb1ng d\u1ea5u ph\u1ea9y. \u0110\u1ed1i s\u1ed1 c\u00f3 th\u1ec3 l\u00e0 c\u00e1c lo\u1ea1i d\u1eef li\u1ec7u kh\u00e1c nhau nh\u01b0 s\u1ed1, v\u0103n b\u1ea3n, \u0111\u1ecba ch\u1ec9 \u00f4, ph\u1ea1m vi ho\u1eb7c th\u1eadm ch\u00ed l\u00e0 c\u00e1c h\u00e0m kh\u00e1c. B\u1ea1n c\u1ea7n \u0111\u1ea3m b\u1ea3o c\u00e1c \u0111\u1ed1i s\u1ed1 \u0111\u01b0\u1ee3c s\u1eafp x\u1ebfp \u0111\u00fang c\u00fa ph\u00e1p \u0111\u1ec3 h\u00e0m ho\u1ea1t \u0111\u1ed9ng ch\u00ednh x\u00e1c.<\/li>\n<li aria-level=\"1\">M\u1ed7i h\u00e0m c\u00f3 c\u00fa ph\u00e1p ri\u00eang v\u1edbi c\u00e1c \u0111\u1ed1i s\u1ed1 c\u1ee5 th\u1ec3, v\u00ec v\u1eady b\u1ea1n n\u00ean ch\u00fa \u00fd \u0111\u1ebfn s\u1ed1 l\u01b0\u1ee3ng v\u00e0 lo\u1ea1i \u0111\u1ed1i s\u1ed1 khi s\u1eed d\u1ee5ng h\u00e0m. B\u1ea1n c\u00f3 th\u1ec3 tham kh\u1ea3o ph\u1ea7n G\u1ee3i \u00fd h\u00e0m c\u1ee7a Excel, gi\u00fap hi\u1ec3n th\u1ecb c\u00fa ph\u00e1p, cung c\u1ea5p v\u00ed d\u1ee5, \u0111\u1ec3 tr\u00e1nh c\u00e1c l\u1ed7i c\u00fa ph\u00e1p trong qu\u00e1 tr\u00ecnh b\u1ea1n nh\u1eadp c\u00f4ng th\u1ee9c.<\/li>\n<li aria-level=\"1\">T\u00f9y theo nhu c\u1ea7u, b\u1ea1n c\u00f3 th\u1ec3 d\u00f9ng tham chi\u1ebfu t\u01b0\u01a1ng \u0111\u1ed1i ho\u1eb7c tham chi\u1ebfu tuy\u1ec7t \u0111\u1ed1i trong c\u00f4ng th\u1ee9c. N\u1ebfu c\u1ea7n c\u1ed1 \u0111\u1ecbnh gi\u00e1 tr\u1ecb c\u1ee7a \u00f4 ho\u1eb7c v\u00f9ng d\u1eef li\u1ec7u, b\u1ea1n h\u00e3y th\u00eam k\u00fd hi\u1ec7u \u0111\u00f4 la ($) tr\u01b0\u1edbc c\u1ed9t ho\u1eb7c h\u00e0ng \u0111\u1ec3 thi\u1ebft l\u1eadp tham chi\u1ebfu tuy\u1ec7t \u0111\u1ed1i. \u0110i\u1ec1u n\u00e0y \u0111\u1eb7c bi\u1ec7t h\u1eefu \u00edch khi b\u1ea1n sao ch\u00e9p c\u00f4ng th\u1ee9c qua nhi\u1ec1u \u00f4 nh\u01b0ng v\u1eabn mu\u1ed1n gi\u1eef nguy\u00ean m\u1ed9t ph\u1ea1m vi nh\u1ea5t \u0111\u1ecbnh.<\/li>\n<li aria-level=\"1\">Sau khi nh\u1eadp c\u00f4ng th\u1ee9c, b\u1ea1n n\u00ean ki\u1ec3m tra k\u1ebft qu\u1ea3 \u0111\u1ec3 \u0111\u1ea3m b\u1ea3o t\u00ednh ch\u00ednh x\u00e1c. N\u1ebfu ph\u00e1t sinh l\u1ed7i, ch\u1eb3ng h\u1ea1n nh\u01b0 #DIV\/0!, #VALUE!, #NAME?, #REF!, #NUM!, #N\/A, b\u1ea1n ki\u1ec3m tra l\u1ea1i c\u00fa ph\u00e1p v\u00e0 \u0111\u1ed1i s\u1ed1 \u0111\u1ec3 \u0111i\u1ec1u ch\u1ec9nh. Hi\u1ec3u r\u00f5 c\u00e1c lo\u1ea1i l\u1ed7i s\u1ebd gi\u00fap b\u1ea1n x\u1eed l\u00fd ch\u00fang nhanh ch\u00f3ng, hi\u1ec7u qu\u1ea3.<\/li>\n<li aria-level=\"1\">C\u00e1c h\u00e0m trong Excel r\u1ea5t phong ph\u00fa v\u00e0 \u0111a d\u1ea1ng, nh\u01b0ng c\u0169ng \u0111i k\u00e8m v\u1edbi \u0111\u1ed9 ph\u1ee9c t\u1ea1p nh\u1ea5t \u0111\u1ecbnh. \u0110\u1ec3 s\u1eed d\u1ee5ng h\u00e0m m\u1ed9t c\u00e1ch hi\u1ec7u qu\u1ea3, b\u1ea1n d\u00e0nh th\u1eddi gian luy\u1ec7n t\u1eadp, t\u00ecm hi\u1ec3u k\u1ef9 c\u00e1ch \u00e1p d\u1ee5ng c\u1ee7a t\u1eebng h\u00e0m trong c\u00e1c tr\u01b0\u1eddng h\u1ee3p c\u1ee5 th\u1ec3. Th\u1ef1c h\u00e0nh th\u01b0\u1eddng xuy\u00ean s\u1ebd gi\u00fap b\u1ea1n l\u00e0m ch\u1ee7 Excel nhanh ch\u00f3ng, th\u1ef1c hi\u1ec7n c\u00f4ng vi\u1ec7c m\u1ed9t c\u00e1ch th\u00f4ng minh h\u01a1n.<\/li>\n<\/ul>\n<p>Tr\u00ean \u0111\u00e2y l\u00e0 <a href=\"https:\/\/jobsgo.vn\/blog\/cac-ham-trong-excel\/\" target=\"_blank\" rel=\"noopener\"><strong>c\u00e1c h\u00e0m trong Excel<\/strong><\/a> \u0111\u1eb7c tr\u01b0ng, n\u1ed5i b\u1eadt m\u00e0 <strong><a href=\"https:\/\/jobsgo.vn\/\">JobsGO<\/a><\/strong> mu\u1ed1n chia s\u1ebb v\u1edbi b\u1ea1n. Ch\u1eafc h\u1eb3n r\u1eb1ng, v\u1edbi nh\u1eefng th\u00f4ng tin h\u1eefu \u00edch tr\u00ean, b\u1ea1n c\u00f3 th\u1ec3 d\u1ec5 d\u00e0ng l\u00e0m ch\u1ee7 Excel ch\u1ec9 trong v\u00f2ng 1 n\u1ed1t nh\u1ea1c.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u0110\u00e1nh gi\u00e1 post Excel l\u00e0 m\u1ed9t c\u00f4ng c\u1ee5 r\u1ea5t \u0111\u01b0\u1ee3c \u01b0a chu\u1ed9ng hi\u1ec7n nay v\u00ec s\u1ef1 h\u1eefu \u00edch c\u1ee7a n\u00f3 v\u1edbi ng\u01b0\u1eddi d\u00f9ng. Vi\u1ec7c th\u00e0nh th\u1ea1o Excel s\u1ebd l\u00e0 ti\u1ec1n \u0111\u1ec1 gi\u00fap b\u1ea1n g\u1eb7t h\u00e1i \u0111\u01b0\u1ee3c nhi\u1ec1u th\u00e0nh c\u00f4ng trong&#8230;<\/p>\n","protected":false},"author":43,"featured_media":84321,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_yoast_wpseo_focuskw":"c\u00e1c h\u00e0m trong excel","_yoast_wpseo_title":"C\u00e1c H\u00e0m Trong Excel Ph\u1ed5 Bi\u1ebfn Nh\u1ea5t {YEAR} %%sep%% %%sitename%%","_yoast_wpseo_metadesc":"C\u00e1c h\u00e0m excel th\u01b0\u1eddng \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng nhi\u1ec1u nh\u1ea5y 2024 l\u00e0 SUM(t\u00ednh t\u1ed5ng), PRODUCT (H\u00e0m nh\u00e2n), SUMIF (H\u00e0m \u0111i\u1ec1u ki\u1ec7n), H\u00e0m MIN\/MAX,...","_yoast_wpseo_focus_keyphrase":"","faq":"1. C\u00f4ng Vi\u1ec7c N\u00e0o C\u1ea7n Th\u00e0nh Th\u1ea1o C\u00e1c H\u00e0m Trong Excel?\r\n\r\nHi\u1ec7n nay, h\u1ea7u h\u1ebft c\u00e1c c\u00f4ng vi\u1ec7c v\u0103n ph\u00f2ng nh\u01b0 K\u1ebf to\u00e1n, Nh\u00e2n s\u1ef1, Marketing, Logistics\u2026 \u0111\u1ec1u c\u1ea7n l\u00e0m vi\u1ec7c tr\u00ean Excel. Ch\u00ednh v\u00ec th\u1ebf vi\u1ec7c th\u00e0nh th\u1ea1o c\u00e1c h\u00e0m c\u1ee7a Excel s\u1ebd h\u1ed7 tr\u1ee3 c\u00e1c b\u1ea1n x\u1eed l\u00fd v\u00e0 gi\u1ea3i quy\u1ebft c\u00f4ng vi\u1ec7c nhanh ch\u00f3ng, d\u1ec5 d\u00e0ng h\u01a1n.\r\n\r\n2. V\u1edbi C\u00e1c Phi\u00ean B\u1ea3n Excel Kh\u00e1c Nhau Th\u00ec Vi\u1ec7c \u00c1p D\u1ee5ng C\u00e1c H\u00e0m Trong Excel C\u00f3 Thay \u0110\u1ed5i Kh\u00f4ng?\r\n\r\nD\u00f9 b\u1ea1n s\u1eed d\u1ee5ng phi\u00ean b\u1ea3n Excel n\u00e0o th\u00ec c\u00f4ng th\u1ee9c \u00e1p d\u1ee5ng c\u00e1c h\u00e0m trong Excel v\u1eabn kh\u00f4ng c\u00f3 s\u1ef1 kh\u00e1c bi\u1ec7t. Do v\u1eady b\u1ea1n ho\u00e0n to\u00e0n c\u00f3 th\u1ec3 y\u00ean t\u00e2m s\u1eed d\u1ee5ng.\r\n","nganh_nghe_chuc_vu_lien_quan":["Nh\u00e2n Vi\u00ean V\u0103n Ph\u00f2ng"]},"categories":[1032],"tags":[3361],"yoast_head":"\n<title>C\u00e1c H\u00e0m Trong Excel Ph\u1ed5 Bi\u1ebfn Nh\u1ea5t 2025 - JobsGO Blog<\/title>\n<meta name=\"description\" content=\"C\u00e1c h\u00e0m excel th\u01b0\u1eddng \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng nhi\u1ec1u nh\u1ea5y 2024 l\u00e0 SUM(t\u00ednh t\u1ed5ng), PRODUCT (H\u00e0m nh\u00e2n), SUMIF (H\u00e0m \u0111i\u1ec1u ki\u1ec7n), H\u00e0m MIN\/MAX,...\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/jobsgo.vn\/blog\/cac-ham-trong-excel\/\" \/>\n<meta property=\"og:locale\" content=\"vi_VN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"C\u00e1c H\u00e0m Trong Excel Ph\u1ed5 Bi\u1ebfn Nh\u1ea5t 2025 - JobsGO Blog\" \/>\n<meta property=\"og:description\" content=\"C\u00e1c h\u00e0m excel th\u01b0\u1eddng \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng nhi\u1ec1u nh\u1ea5y 2024 l\u00e0 SUM(t\u00ednh t\u1ed5ng), PRODUCT (H\u00e0m nh\u00e2n), SUMIF (H\u00e0m \u0111i\u1ec1u ki\u1ec7n), H\u00e0m MIN\/MAX,...\" \/>\n<meta property=\"og:url\" content=\"https:\/\/jobsgo.vn\/blog\/cac-ham-trong-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"JobsGO Blog\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/JobsGOVN\/\" \/>\n<meta property=\"article:published_time\" content=\"2024-10-29T02:08:46+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-10-31T01:51:51+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/jobsgo.vn\/blog\/wp-content\/uploads\/2024\/02\/cac-ham-trong-excel.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"800\" \/>\n\t<meta property=\"og:image:height\" content=\"550\" \/>\n<meta name=\"twitter:card\" content=\"summary\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"21 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Organization\",\"@id\":\"https:\/\/jobsgo.vn\/blog\/#organization\",\"name\":\"JobsGO\",\"url\":\"https:\/\/jobsgo.vn\/blog\/\",\"sameAs\":[\"https:\/\/www.facebook.com\/JobsGOVN\/\",\"http:\/\/instagram.com\/jobsgo_vn\",\"https:\/\/www.linkedin.com\/company\/josbgo.vn\"],\"logo\":{\"@type\":\"ImageObject\",\"@id\":\"https:\/\/jobsgo.vn\/blog\/#logo\",\"inLanguage\":\"vi\",\"url\":\"https:\/\/jobsgo.vn\/blog\/wp-content\/uploads\/2018\/01\/jobsgo-logo.png\",\"contentUrl\":\"https:\/\/jobsgo.vn\/blog\/wp-content\/uploads\/2018\/01\/jobsgo-logo.png\",\"width\":149,\"height\":161,\"caption\":\"JobsGO\"},\"image\":{\"@id\":\"https:\/\/jobsgo.vn\/blog\/#logo\"}},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/jobsgo.vn\/blog\/#website\",\"url\":\"https:\/\/jobsgo.vn\/blog\/\",\"name\":\"JobsGO Blog\",\"description\":\"T\\u1ed5ng h\\u1ee3p c\\u00e1c b\\u00ed quy\\u1ebft t\\u00ecm vi\\u1ec7c v\\u00e0 ph\\u00e1t tri\\u1ec3n s\\u1ef1 nghi\\u1ec7p v\\u1edbi JobsGO\",\"publisher\":{\"@id\":\"https:\/\/jobsgo.vn\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":\"https:\/\/jobsgo.vn\/blog\/?s={search_term_string}\",\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"vi\"},{\"@type\":\"ImageObject\",\"@id\":\"https:\/\/jobsgo.vn\/blog\/cac-ham-trong-excel\/#primaryimage\",\"inLanguage\":\"vi\",\"url\":\"https:\/\/media-blog.jobsgo.vn\/blog\/wp-content\/uploads\/2024\/02\/cac-ham-trong-excel.jpg\",\"contentUrl\":\"https:\/\/media-blog.jobsgo.vn\/blog\/wp-content\/uploads\/2024\/02\/cac-ham-trong-excel.jpg\",\"width\":\"800\",\"height\":\"550\",\"caption\":\"C\\u00e1c h\\u00e0m trong excel c\\u01a1 b\\u1ea3n\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/jobsgo.vn\/blog\/cac-ham-trong-excel\/#webpage\",\"url\":\"https:\/\/jobsgo.vn\/blog\/cac-ham-trong-excel\/\",\"name\":\"C\\u00e1c H\\u00e0m Trong Excel Ph\\u1ed5 Bi\\u1ebfn Nh\\u1ea5t {YEAR} - JobsGO Blog\",\"isPartOf\":{\"@id\":\"https:\/\/jobsgo.vn\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/jobsgo.vn\/blog\/cac-ham-trong-excel\/#primaryimage\"},\"datePublished\":\"2024-10-29T02:08:46+00:00\",\"dateModified\":\"2024-10-31T01:51:51+00:00\",\"description\":\"C\\u00e1c h\\u00e0m excel th\\u01b0\\u1eddng \\u0111\\u01b0\\u1ee3c s\\u1eed d\\u1ee5ng nhi\\u1ec1u nh\\u1ea5y 2024 l\\u00e0 SUM(t\\u00ednh t\\u1ed5ng), PRODUCT (H\\u00e0m nh\\u00e2n), SUMIF (H\\u00e0m \\u0111i\\u1ec1u ki\\u1ec7n), H\\u00e0m MIN\/MAX,...\",\"breadcrumb\":{\"@id\":\"https:\/\/jobsgo.vn\/blog\/cac-ham-trong-excel\/#breadcrumb\"},\"inLanguage\":\"vi\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/jobsgo.vn\/blog\/cac-ham-trong-excel\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/jobsgo.vn\/blog\/cac-ham-trong-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"item\":{\"@type\":\"WebPage\",\"@id\":\"https:\/\/jobsgo.vn\/blog\/\",\"url\":\"https:\/\/jobsgo.vn\/blog\/\",\"name\":\"Trang ch\\u1ee7\"}},{\"@type\":\"ListItem\",\"position\":2,\"item\":{\"@id\":\"https:\/\/jobsgo.vn\/blog\/cac-ham-trong-excel\/#webpage\"}}]},{\"@type\":\"Article\",\"@id\":\"https:\/\/jobsgo.vn\/blog\/cac-ham-trong-excel\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/jobsgo.vn\/blog\/cac-ham-trong-excel\/#webpage\"},\"author\":{\"@id\":\"https:\/\/jobsgo.vn\/blog\/#\/schema\/person\/db38ed3436b7c93f5c5ebd7c9c648c68\"},\"headline\":\"C\\u00e1c H\\u00e0m Trong Excel C\\u01a1 B\\u1ea3n, Th\\u01b0\\u1eddng \\u0110\\u01b0\\u1ee3c S\\u1eed D\\u1ee5ng Nh\\u1ea5t 2025\",\"datePublished\":\"2024-10-29T02:08:46+00:00\",\"dateModified\":\"2024-10-31T01:51:51+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/jobsgo.vn\/blog\/cac-ham-trong-excel\/#webpage\"},\"wordCount\":5450,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/jobsgo.vn\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/jobsgo.vn\/blog\/cac-ham-trong-excel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/media-blog.jobsgo.vn\/blog\/wp-content\/uploads\/2024\/02\/cac-ham-trong-excel.jpg\",\"keywords\":[\"k\\u1ef9 n\\u0103ng c\\u00f4ng s\\u1edf\"],\"articleSection\":[\"K\\u1ef9 n\\u0103ng c\\u00f4ng s\\u1edf\"],\"inLanguage\":\"vi\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/jobsgo.vn\/blog\/cac-ham-trong-excel\/#respond\"]}]},{\"@type\":\"Person\",\"@id\":\"https:\/\/jobsgo.vn\/blog\/#\/schema\/person\/db38ed3436b7c93f5c5ebd7c9c648c68\",\"name\":\"H\\u1ed3ng Nguy\\u1ec5n\",\"image\":{\"@type\":\"ImageObject\",\"@id\":\"https:\/\/jobsgo.vn\/blog\/#personlogo\",\"inLanguage\":\"vi\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/83e1b4f3982c2a110f5f4dc9063f1f3f?s=96&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/83e1b4f3982c2a110f5f4dc9063f1f3f?s=96&r=g\",\"caption\":\"H\\u1ed3ng Nguy\\u1ec5n\"},\"sameAs\":[\"hong.nguyen@jobsgo.vn\"],\"url\":\"https:\/\/jobsgo.vn\/blog\/author\/hong-nguyen\/\"}]}<\/script>\n","featured_image_url":"https:\/\/media-blog.jobsgo.vn\/blog\/wp-content\/uploads\/2024\/02\/cac-ham-trong-excel-600x400.jpg","_links":{"self":[{"href":"https:\/\/jobsgo.vn\/blog\/wp-json\/wp\/v2\/posts\/49057"}],"collection":[{"href":"https:\/\/jobsgo.vn\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/jobsgo.vn\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/jobsgo.vn\/blog\/wp-json\/wp\/v2\/users\/43"}],"replies":[{"embeddable":true,"href":"https:\/\/jobsgo.vn\/blog\/wp-json\/wp\/v2\/comments?post=49057"}],"version-history":[{"count":12,"href":"https:\/\/jobsgo.vn\/blog\/wp-json\/wp\/v2\/posts\/49057\/revisions"}],"predecessor-version":[{"id":85023,"href":"https:\/\/jobsgo.vn\/blog\/wp-json\/wp\/v2\/posts\/49057\/revisions\/85023"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/jobsgo.vn\/blog\/wp-json\/wp\/v2\/media\/84321"}],"wp:attachment":[{"href":"https:\/\/jobsgo.vn\/blog\/wp-json\/wp\/v2\/media?parent=49057"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/jobsgo.vn\/blog\/wp-json\/wp\/v2\/categories?post=49057"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/jobsgo.vn\/blog\/wp-json\/wp\/v2\/tags?post=49057"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}