{"id":164467,"date":"2024-09-26T10:43:47","date_gmt":"2024-09-26T03:43:47","guid":{"rendered":"https:\/\/amis.misa.vn\/?p=164467"},"modified":"2024-09-26T10:43:47","modified_gmt":"2024-09-26T03:43:47","slug":"tong-hop-cac-ham-excel-ke-toan-thuong-dung","status":"publish","type":"post","link":"https:\/\/amis.misa.vn\/164467\/tong-hop-cac-ham-excel-ke-toan-thuong-dung\/","title":{"rendered":"T\u1ed5ng h\u1ee3p c\u00e1c h\u00e0m excel k\u1ebf to\u00e1n th\u01b0\u1eddng d\u00f9ng"},"content":{"rendered":"
Trong c\u00f4ng vi\u1ec7c k\u1ebf to\u00e1n h\u00e0ng ng\u00e0y, vi\u1ec7c s\u1eed d\u1ee5ng Excel kh\u00f4ng ch\u1ec9 gi\u00fap t\u1ef1 \u0111\u1ed9ng h\u00f3a v\u00e0 t\u1ed1i \u01b0u h\u00f3a c\u00e1c c\u00f4ng vi\u1ec7c t\u00ednh to\u00e1n m\u00e0 c\u00f2n mang l\u1ea1i t\u00ednh ch\u00ednh x\u00e1c v\u00e0 hi\u1ec7u qu\u1ea3 cao trong vi\u1ec7c qu\u1ea3n l\u00fd d\u1eef li\u1ec7u t\u00e0i ch\u00ednh. B\u00e0i vi\u1ebft n\u00e0y t\u1ed5ng h\u1ee3p v\u00e0 gi\u1ea3i th\u00edch chi ti\u1ebft v\u1ec1 c\u00e1c h\u00e0m Excel th\u01b0\u1eddng \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng trong k\u1ebf to\u00e1n, t\u1eeb c\u00e1c h\u00e0m c\u01a1 b\u1ea3n nh\u01b0 SUMIF v\u00e0 COUNTIF \u0111\u1ebfn c\u00e1c h\u00e0m ph\u1ee9c t\u1ea1p h\u01a1n nh\u01b0 INDEX\/MATCH. Vi\u1ec7c hi\u1ec3u r\u00f5 c\u00e1ch s\u1eed d\u1ee5ng nh\u1eefng h\u00e0m n\u00e0y s\u1ebd gi\u00fap ng\u01b0\u1eddi l\u00e0m k\u1ebf to\u00e1n t\u0103ng c\u01b0\u1eddng kh\u1ea3 n\u0103ng ph\u00e2n t\u00edch d\u1eef li\u1ec7u v\u00e0 chu\u1ea9n b\u1ecb b\u00e1o c\u00e1o m\u1ed9t c\u00e1ch hi\u1ec7u qu\u1ea3.<\/p>\n
H\u00e0m SUM d\u00f9ng \u0111\u1ec3 t\u00ednh t\u1ed5ng gi\u00e1 tr\u1ecb trong m\u1ed9t ph\u1ea1m vi c\u1ee5 th\u1ec3. R\u1ea5t h\u1eefu \u00edch trong vi\u1ec7c c\u1ed9ng d\u1ed3n doanh s\u1ed1 b\u00e1n h\u00e0ng, chi ph\u00ed, v.v.<\/p>\n
C\u00f4ng th\u1ee9c:<\/p>\n
=SUM(Number1,Number2,Number3)<\/strong><\/p>\n Trong \u0111\u00f3:<\/p>\n V\u00ed d\u1ee5 minh h\u1ecda:<\/em><\/span><\/p>\n T\u00ednh t\u1ed5ng c\u1ee7a c\u00e1c s\u1ed1 10,20,30, ta c\u00f3 c\u00f4ng th\u1ee9c sau<\/p>\n =SUM(10,20,30),<\/em><\/p>\n Nh\u01b0 v\u1eady, excel s\u1ebd \u0111\u01b0a ra k\u1ebft qu\u1ea3 l\u00e0 60.<\/p>\n <\/p>\n H\u00e0m t\u00ednh gi\u00e1 tr\u1ecb trung b\u00ecnh c\u1ee7a c\u00e1c s\u1ed1 trong m\u1ed9t ph\u1ea1m vi nh\u1ea5t \u0111\u1ecbnh. Th\u01b0\u1eddng \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 t\u00ednh trung b\u00ecnh thu nh\u1eadp ho\u1eb7c chi ph\u00ed.<\/p>\n C\u00f4ng th\u1ee9c:<\/p>\n =AVERAGE(number1,number2,\u2026)<\/strong><\/p>\n V\u1edbi:<\/p>\n V\u00ed d\u1ee5 minh h\u1ecda:<\/em> <\/span><\/p>\n T\u00ednh l\u01b0\u01a1ng trung b\u00ecnh c\u1ee7a 1 c\u00e1 nh\u00e2n theo c\u00e1c th\u00f4ng tin b\u00ean d\u01b0\u1edbi, ta c\u00f3 c\u00f4ng th\u1ee9c =AVERAGE(C14:C15) v\u00e0 nh\u1eadn \u0111\u01b0\u1ee3c k\u1ebft qu\u1ea3 l\u00e0 gi\u00e1 tr\u1ecb trung b\u00ecnh c\u1ee7a 12 th\u00e1ng l\u01b0\u01a1ng.<\/p>\n <\/p>\n H\u00e0m t\u00ecm ki\u1ebfm v\u00e0 tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb t\u1eeb m\u1ed9t b\u1ea3ng d\u1ef1a tr\u00ean gi\u00e1 tr\u1ecb kh\u00f3a theo chi\u1ec1u d\u1ecdc. \u0110\u00e2y l\u00e0 h\u00e0m r\u1ea5t h\u1eefu \u00edch trong vi\u1ec7c truy xu\u1ea5t th\u00f4ng tin chi ti\u1ebft v\u1ec1 kh\u00e1ch h\u00e0ng, s\u1ea3n ph\u1ea9m ho\u1eb7c nh\u00e2n vi\u00ean t\u1eeb b\u1ea3ng d\u1eef li\u1ec7u l\u1edbn.<\/p>\n C\u00f4ng th\u1ee9c h\u00e0m VLOOKUP:<\/p>\n =VLOOKUP(Lookup_value, Table_array, Col_index_ num, Range_lookup)<\/strong><\/p>\n Trong \u0111\u00f3:<\/p>\n V\u00ed d\u1ee5 minh h\u1ecda:<\/span><\/em><\/span><\/p>\n T\u00ecm t\u00ean c\u1ee7a kh\u00e1ch h\u00e0ng d\u1ef1a theo m\u00e3 kh\u00e1ch h\u00e0ng c\u00f9ng c\u00e1c th\u00f4ng tin b\u00ean d\u01b0\u1edbi, ta c\u00f3 c\u00f4ng th\u1ee9c =VLOOKUP(F13,E5:F9,2,0) , c\u1ee5 th\u1ec3 theo h\u00ecnh minh h\u1ecda d\u01b0\u1edbi \u0111\u00e2y:<\/span><\/p>\n <\/p>\n H\u00e0m IF trong Excel l\u00e0 m\u1ed9t h\u00e0m logic r\u1ea5t h\u1eefu \u00edch trong k\u1ebf to\u00e1n \u0111\u1ec3 ki\u1ec3m tra m\u1ed9t \u0111i\u1ec1u ki\u1ec7n v\u00e0 tr\u1ea3 v\u1ec1 m\u1ed9t gi\u00e1 tr\u1ecb n\u1ebfu \u0111i\u1ec1u ki\u1ec7n \u0111\u00fang, v\u00e0 m\u1ed9t gi\u00e1 tr\u1ecb kh\u00e1c n\u1ebfu \u0111i\u1ec1u ki\u1ec7n sai.<\/p>\n C\u00f4ng th\u1ee9c h\u00e0m IF:<\/p>\n =IF(Logical_test;Value_if_true;Value_if_false)<\/strong><\/p>\n Trong \u0111\u00f3:<\/p>\n V\u00ed d\u1ee5 minh h\u1ecda: <\/em><\/span><\/p>\n Gi\u1ea3 s\u1eed b\u1ea1n c\u00f3 m\u1ed9t b\u1ea3ng doanh s\u1ed1 b\u00e1n h\u00e0ng v\u00e0 b\u1ea1n mu\u1ed1n t\u00ednh to\u00e1n hoa h\u1ed3ng cho nh\u00e2n vi\u00ean d\u1ef1a tr\u00ean doanh s\u1ed1 c\u1ee7a h\u1ecd v\u1edbi c\u00e1c \u0111i\u1ec1u ki\u1ec7n nh\u01b0 sau:<\/p>\n Ta t\u00ednh \u0111\u01b0\u1ee3c hoa h\u1ed3ng c\u1ee7a nh\u00e2n vi\u00ean nh\u01b0 sau:<\/p>\n <\/p>\n H\u00e0m SUMIF trong Excel d\u00f9ng \u0111\u1ec3 t\u00ednh t\u1ed5ng c\u00e1c gi\u00e1 tr\u1ecb trong m\u1ed9t ph\u1ea1m vi d\u1eef li\u1ec7u d\u1ef1a tr\u00ean m\u1ed9t \u0111i\u1ec1u ki\u1ec7n nh\u1ea5t \u0111\u1ecbnh. Trong k\u1ebf to\u00e1n, h\u00e0m SUMIF c\u00f3 th\u1ec3 \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 t\u00ednh t\u1ed5ng c\u00e1c kho\u1ea3n chi ho\u1eb7c thu d\u1ef1a tr\u00ean nh\u1eefng ti\u00eau ch\u00ed nh\u1ea5t \u0111\u1ecbnh.<\/p>\n C\u00f4ng th\u1ee9c h\u00e0m SUMIF:<\/p>\n =SUMIF(range, criteria, [sum_range])<\/strong><\/p>\n Trong \u0111\u00f3:<\/p>\n V\u00ed d\u1ee5 minh h\u1ecda:<\/em><\/span><\/p>\n Gi\u1ea3 s\u1eed k\u1ebf to\u00e1n c\u1ea7n t\u00ednh t\u1ed5ng chi ph\u00ed cho d\u1ef1 \u00e1n “A” trong danh s\u00e1ch c\u00e1c giao d\u1ecbch. Ta c\u00f3 b\u1ea3ng d\u1eef li\u1ec7u v\u00e0 \u00e1p d\u1ee5ng h\u00e0m SUMIF nh\u01b0 sau:<\/p>\n \u00a0= SUMIF(A37:A41,\u201dD\u1ef1 \u00e1n A\u201d,B37:B41)<\/strong><\/em><\/p>\n Trong \u0111\u00f3:<\/p>\n <\/p>\n V\u1eady t\u1ed5ng chi ph\u00ed cho d\u1ef1 \u00e1n A \u0111\u01b0\u1ee3c t\u00ednh l\u00e0 30 tri\u1ec7u \u0111\u1ed3ng<\/span><\/p>\n H\u00e0m COUNTIF \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 \u0111\u1ebfm s\u1ed1 l\u1ea7n xu\u1ea5t hi\u1ec7n c\u1ee7a m\u1ed9t gi\u00e1 tr\u1ecb d\u1ef1a tr\u00ean m\u1ed9t \u0111i\u1ec1u ki\u1ec7n nh\u1ea5t \u0111\u1ecbnh trong m\u1ed9t ph\u1ea1m vi c\u1ee5 th\u1ec3. \u0110\u00e2y l\u00e0 m\u1ed9t c\u00f4ng c\u1ee5 r\u1ea5t h\u1eefu \u00edch trong vi\u1ec7c ph\u00e2n t\u00edch d\u1eef li\u1ec7u khi b\u1ea1n c\u1ea7n bi\u1ebft c\u00f3 bao nhi\u00eau m\u1ee5c th\u1ecfa m\u00e3n m\u1ed9t ti\u00eau ch\u00ed nh\u1ea5t \u0111\u1ecbnh.<\/p>\n C\u00f4ng th\u1ee9c c\u1ee7a h\u00e0m COUNTIF:<\/p>\n =COUNTIF(range, criteria)<\/strong><\/p>\n Trong \u0111\u00f3:<\/p>\n V\u00ed d\u1ee5 : Gi\u1ea3 s\u1eed b\u1ea1n c\u00f3 m\u1ed9t b\u1ea3ng li\u1ec7t k\u00ea c\u00e1c h\u00f3a \u0111\u01a1n v\u00e0 b\u1ea1n mu\u1ed1n bi\u1ebft c\u00f3 bao nhi\u00eau h\u00f3a \u0111\u01a1n v\u01b0\u1ee3t qu\u00e1 500 \u0111\u00f4 la, ta c\u00f3 b\u1ea3ng d\u1eef li\u1ec7u v\u00e0 s\u1eed d\u1ee5ng h\u00e0m CountIF nh\u01b0 sau:<\/p>\n = COUNTIF(N13:N17,\u201d>500\u201d)<\/strong><\/em><\/p>\n Trong \u0111\u00f3:<\/p>\n <\/p>\n V\u1eady k\u1ebft qu\u1ea3 s\u1ebd t\u1ed5ng h\u00f3a \u0111\u01a1n c\u00f3 s\u1ed1 ti\u1ec1n v\u01b0\u1ee3t qu\u00e1 500$ l\u00e0 2 h\u00f3a \u0111\u01a1n, v\u00ec ch\u1ec9 c\u00f3 hai h\u00f3a \u0111\u01a1n (002 v\u00e0 004)<\/p>\n Trong Excel, c\u00e1c h\u00e0m LEFT v\u00e0 RIGHT l\u00e0 nh\u1eefng c\u00f4ng c\u1ee5 h\u1eefu \u00edch \u0111\u1ec3 tr\u00edch xu\u1ea5t c\u00e1c k\u00fd t\u1ef1 t\u1eeb b\u00ean tr\u00e1i ho\u1eb7c b\u00ean ph\u1ea3i c\u1ee7a m\u1ed9t chu\u1ed7i v\u0103n b\u1ea3n. \u0110\u00e2y l\u00e0 hai trong s\u1ed1 c\u00e1c h\u00e0m thao t\u00e1c chu\u1ed7i c\u01a1 b\u1ea3n nh\u1ea5t v\u00e0 th\u01b0\u1eddng xuy\u00ean \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng trong vi\u1ec7c x\u1eed l\u00fd d\u1eef li\u1ec7u v\u0103n b\u1ea3n.<\/p>\n C\u00f4ng th\u1ee9c c\u1ee7a h\u00e0m LEFT:<\/p>\n =LEFT(text, [num_chars])<\/strong><\/p>\n Trong \u0111\u00f3:<\/p>\n V\u00ed d\u1ee5 v\u1ec1 h\u00e0m LEFT:<\/em><\/span><\/p>\n Gi\u1ea3 s\u1eed b\u1ea1n c\u00f3 chu\u1ed7i “Excel2024” v\u00e0 b\u1ea1n mu\u1ed1n tr\u00edch xu\u1ea5t t\u1eeb “Excel” t\u1eeb chu\u1ed7i n\u00e0y: =LEFT(“Excel2024”, 5)<\/strong><\/em>.<\/p>\n K\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 s\u1ebd l\u00e0 “Excel”<\/strong>.<\/p>\n C\u00f4ng th\u1ee9c c\u1ee7a h\u00e0m RIGHT:<\/p>\n =RIGHT(text, [num_chars])<\/strong><\/p>\n Trong \u0111\u00f3<\/p>\n V\u00ed d\u1ee5 v\u1ec1 h\u00e0m RIGHT:<\/span><\/em><\/p>\n Gi\u1ea3 s\u1eed b\u1ea1n c\u00f3 chu\u1ed7i “Excel2024” v\u00e0 b\u1ea1n mu\u1ed1n tr\u00edch xu\u1ea5t s\u1ed1 “2024” t\u1eeb chu\u1ed7i n\u00e0y: K\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 s\u1ebd l\u00e0 “2024<\/strong>“.<\/p>\n C\u1ea3 hai h\u00e0m n\u00e0y c\u00f3 th\u1ec3 \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 x\u1eed l\u00fd m\u00e3 s\u1ea3n ph\u1ea9m, m\u00e3 nh\u00e2n vi\u00ean, hay b\u1ea5t k\u1ef3 chu\u1ed7i d\u1eef li\u1ec7u \u0111\u1ecbnh d\u1ea1ng \u0111\u1eb7c bi\u1ec7t n\u00e0o trong k\u1ebf to\u00e1n. V\u00ed d\u1ee5, n\u1ebfu b\u1ea1n c\u00f3 m\u00e3 nh\u00e2n vi\u00ean d\u1ea1ng “EMP001”, “EMP002”,…, v\u00e0 ch\u1ec9 mu\u1ed1n tr\u00edch xu\u1ea5t ph\u1ea7n s\u1ed1, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng: =RIGHT(“EMP001”, 3)<\/strong><\/em><\/p>\n K\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 s\u1ebd l\u00e0 “001<\/strong>“.<\/p>\n <\/a><\/p>\n H\u00e0m INDEX v\u00e0 MATCH l\u00e0 m\u1ed9t c\u1eb7p h\u00e0m m\u1ea1nh m\u1ebd trong Excel, \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 truy xu\u1ea5t d\u1eef li\u1ec7u t\u1eeb m\u1ed9t b\u1ea3ng theo c\u00e1ch linh ho\u1ea1t. Khi k\u1ebft h\u1ee3p v\u1edbi nhau, ch\u00fang cho ph\u00e9p b\u1ea1n t\u00ecm ki\u1ebfm d\u1eef li\u1ec7u trong b\u1ea5t k\u1ef3 h\u01b0\u1edbng n\u00e0o, kh\u00f4ng ch\u1ec9 t\u1eeb tr\u00e1i sang ph\u1ea3i nh\u01b0 h\u00e0m VLOOKUP. \u0110i\u1ec1u n\u00e0y l\u00e0m cho ch\u00fang tr\u1edf n\u00ean r\u1ea5t h\u1eefu \u00edch trong vi\u1ec7c x\u1eed l\u00fd c\u00e1c b\u1ea3ng d\u1eef li\u1ec7u ph\u1ee9c t\u1ea1p.<\/p>\n =INDEX(array, row_num, [column_num])<\/strong><\/p>\n Trong \u0111\u00f3:<\/p>\n = MATCH(lookup_value, lookup_array, [match_type])<\/strong><\/p>\n Trong \u0111\u00f3:<\/p>\n V\u00ed d\u1ee5 minh h\u1ecda:<\/em><\/span><\/p>\n Gi\u1ea3 s\u1eed b\u1ea1n c\u00f3 b\u1ea3ng d\u1eef li\u1ec7u sau \u0111\u00e2y v\u00e0 b\u1ea1n mu\u1ed1n t\u00ecm s\u1ed1 \u0111i\u1ec7n tho\u1ea1i c\u1ee7a m\u1ed9t kh\u00e1ch h\u00e0ng c\u1ee5 th\u1ec3.<\/p>\n <\/p>\n Trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y, b\u1ea1n mu\u1ed1n l\u1ea5y s\u1ed1 \u0111i\u1ec7n tho\u1ea1i c\u1ee7a kh\u00e1ch h\u00e0ng \u201cNguy\u1ec5n V\u0103n D\u201d, s\u1eed d\u1ee5ng h\u00e0m Index v\u00e0 match nh\u01b0 sau:<\/p>\n C\u00fa ph\u00e1p h\u00e0m: =INDEX(G13:G17, MATCH(“Nguy\u1ec5n V\u0103n D”, F13:F17, 0))<\/em><\/strong><\/p>\n Trong \u0111\u00f3:<\/p>\n C\u00e1c h\u00e0m Excel m\u00e0 ch\u00fang ta \u0111\u00e3 th\u1ea3o lu\u1eadn trong b\u00e0i vi\u1ebft n\u00e0y l\u00e0 nh\u1eefng c\u00f4ng c\u1ee5 v\u00f4 c\u00f9ng quan tr\u1ecdng \u0111\u1ed1i v\u1edbi m\u1ecdi ng\u01b0\u1eddi l\u00e0m trong l\u0129nh v\u1ef1c k\u1ebf to\u00e1n. T\u1eeb vi\u1ec7c t\u1ed5ng h\u1ee3p d\u1eef li\u1ec7u, ph\u00e2n t\u00edch s\u1ed1 li\u1ec7u, cho \u0111\u1ebfn vi\u1ec7c chu\u1ea9n b\u1ecb v\u00e0 tr\u00ecnh b\u00e0y c\u00e1c b\u00e1o c\u00e1o t\u00e0i ch\u00ednh, vi\u1ec7c th\u00e0nh th\u1ea1o c\u00e1c h\u00e0m nh\u01b0 VLOOKUP, SUMIF, COUNTIF, INDEX\/MATCH s\u1ebd gi\u00fap c\u00f4ng vi\u1ec7c k\u1ebf to\u00e1n tr\u1edf n\u00ean nhanh ch\u00f3ng v\u00e0 ch\u00ednh x\u00e1c h\u01a1n. Hy v\u1ecdng, v\u1edbi nh\u1eefng ki\u1ebfn th\u1ee9c \u0111\u01b0\u1ee3c cung c\u1ea5p trong b\u00e0i vi\u1ebft n\u00e0y, ng\u01b0\u1eddi \u0111\u1ecdc c\u00f3 th\u1ec3 \u1ee9ng d\u1ee5ng th\u00e0nh th\u1ea1o c\u00e1c h\u00e0m Excel v\u00e0o c\u00f4ng vi\u1ec7c k\u1ebf to\u00e1n c\u1ee7a m\u00ecnh, t\u1eeb \u0111\u00f3 n\u00e2ng cao hi\u1ec7u qu\u1ea3 c\u00f4ng vi\u1ec7c v\u00e0 \u0111\u00f3ng g\u00f3p t\u00edch c\u1ef1c v\u00e0o s\u1ef1 th\u00e0nh c\u00f4ng chung c\u1ee7a doanh nghi\u1ec7p.<\/p>\n <\/a><\/p>\n MISA AMIS l\u00e0 n\u01a1i cung c\u1ea5p ki\u1ebfn th\u1ee9c h\u1eefu \u00edch v\u1ec1 k\u1ebf to\u00e1n v\u00e0 c\u00e1c nghi\u1ec7p v\u1ee5 li\u00ean quan, bao g\u1ed3m c\u1ea3 h\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng Excel cho c\u00f4ng vi\u1ec7c k\u1ebf to\u00e1n. \u0110\u1ed3ng th\u1eddi, MISA AMIS cung c\u1ea5p ph\u1ea7n m\u1ec1m k\u1ebf to\u00e1n online MISA AMIS<\/strong> <\/a>gi\u00fap doanh nghi\u1ec7p t\u1ed1i \u01b0u h\u00f3a qu\u00e1 tr\u00ecnh qu\u1ea3n l\u00fd t\u00e0i ch\u00ednh. M\u1ed9t s\u1ed1 t\u00ednh n\u0103ng n\u1ed5i b\u1eadt c\u1ee7a ph\u1ea7n m\u1ec1m MISA AMIS bao g\u1ed3m<\/p>\n Qu\u1ea3n l\u00fd thu\u1ebf<\/strong>: T\u1ef1 \u0111\u1ed9ng t\u00ednh to\u00e1n v\u00e0 l\u1eadp t\u1edd khai thu\u1ebf, gi\u00fap doanh nghi\u1ec7p th\u1ef1c hi\u1ec7n ngh\u0129a v\u1ee5 thu\u1ebf \u0111\u00fang h\u1ea1n v\u00e0 ch\u00ednh x\u00e1c.<\/p>\n<\/li>\n<\/ul>\n Ph\u1ea7n m\u1ec1m k\u1ebf to\u00e1n online MISA AMIS gi\u00fap k\u1ebf to\u00e1n d\u1ec5 d\u00e0ng qu\u1ea3n l\u00fd to\u00e0n b\u1ed9 c\u00f4ng vi\u1ec7c tr\u00ean m\u1ed9t n\u1ec1n t\u1ea3ng duy nh\u1ea5t.<\/p>\n <\/p>\n \u0110\u0103ng k\u00fd d\u00f9ng th\u1eed 15 ng\u00e0y mi\u1ec5n ph\u00ed ngay t\u1ea1i \u0111\u00e2y<\/strong><\/p>\n \n D\u00f9ng ngay mi\u1ec5n ph\u00ed\n <\/a><\/p><\/span><\/p>\n\n
2. H\u00e0m t\u00ednh gi\u00e1 tr\u1ecb trung b\u00ecnh AVERAGE<\/strong><\/h2>\n
\n
3. H\u00e0m t\u00ecm ki\u1ebfm VLOOKUP<\/strong><\/h2>\n
\n
\n
<\/a><\/h2>\n
4. H\u00e0m IF<\/strong><\/h2>\n
\n
\n
5. H\u00e0m t\u00ednh t\u1ed5ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n SUMIF<\/strong><\/h2>\n
\n
\n
6. H\u00e0m \u0111\u1ebfm c\u00f3 \u0111i\u1ec1u ki\u1ec7n COUNTIF<\/strong><\/h2>\n
\n
\n
7. H\u00e0m LEFT, RIGHT<\/strong><\/h2>\n
H\u00e0m LEFT<\/h3>\n
\n
H\u00e0m RIGHT<\/h3>\n
\n
\n=RIGHT(“Excel2024”, 4)<\/strong><\/em><\/p>\n\u1ee8ng d\u1ee5ng trong k\u1ebf to\u00e1n:<\/h3>\n
8. H\u00e0m INDEX \/ MATCH<\/strong><\/h2>\n
C\u00f4ng th\u1ee9c c\u1ee7a h\u00e0m INDEX:<\/h3>\n
\n
C\u00f4ng th\u1ee9c c\u1ee7a h\u00e0m MATCH:<\/h3>\n
\n
\n
\n