{"id":19302,"date":"2023-12-05T13:20:43","date_gmt":"2023-12-05T13:20:43","guid":{"rendered":"https:\/\/masterskills.org\/blog\/bi-kip-bo-tui-cac-ham-trong-excel-va-huong-dan-chi-tiet-don-gian.html"},"modified":"2023-12-17T01:46:18","modified_gmt":"2023-12-17T01:46:18","slug":"bi-kip-bo-tui-cac-ham-trong-excel-va-huong-dan-chi-tiet-don-gian","status":"publish","type":"post","link":"https:\/\/masterskills.org\/blog\/bi-kip-bo-tui-cac-ham-trong-excel-va-huong-dan-chi-tiet-don-gian.html","title":{"rendered":"B\u00ed K\u00edp B\u1ecf T\u00fai C\u00e1c H\u00e0m Trong Excel V\u00e0 H\u01b0\u1edbng D\u1eabn Chi Ti\u1ebft \u0110\u01a1n Gi\u1ea3n"},"content":{"rendered":"
\n

Excel l\u00e0 m\u1ed9t ph\u1ea7n m\u1ec1m kh\u00f4ng th\u1ec3 thi\u1ebfu trong c\u00f4ng vi\u1ec7c c\u1ee7a d\u00e2n v\u0103n ph\u00f2ng. N\u00f3 gi\u00fap b\u1ea1n x\u1eed l\u00fd d\u1eef li\u1ec7u, t\u00ednh to\u00e1n, ph\u00e2n t\u00edch v\u00e0 b\u00e1o c\u00e1o m\u1ed9t c\u00e1ch hi\u1ec7u qu\u1ea3 v\u00e0 chuy\u00ean nghi\u1ec7p. Tuy nhi\u00ean, \u0111\u1ec3 s\u1eed d\u1ee5ng Excel th\u00e0nh th\u1ea1o, b\u1ea1n c\u1ea7n n\u1eafm v\u1eefng c\u00e1c h\u00e0m trong Excel v\u00e0 c\u00e1ch \u1ee9ng d\u1ee5ng ch\u00fang trong th\u1ef1c t\u1ebf. V\u00ec v\u1eady, <\/span>Masterskills<\/strong> xin gi\u1edbi thi\u1ec7u \u0111\u1ebfn b\u1ea1n s\u1ed5 tay c\u00f4ng th\u1ee9c v\u00e0 v\u00ed d\u1ee5 chi ti\u1ebft c\u00e1c h\u00e0m trong Excel cho d\u00e2n v\u0103n ph\u00f2ng.\u00a0<\/span><\/p>\n

L\u1ee3i \u00edch khi s\u1eed d\u1ee5ng c\u00e1c h\u00e0m trong Excel l\u00e0 g\u00ec?<\/strong><\/h2>\n

C\u00e1c h\u00e0m trong Excel l\u00e0 nh\u1eefng c\u00f4ng c\u1ee5 m\u1ea1nh m\u1ebd gi\u00fap b\u1ea1n th\u1ef1c hi\u1ec7n c\u00e1c thao t\u00e1c tr\u00ean d\u1eef li\u1ec7u m\u1ed9t c\u00e1ch nhanh ch\u00f3ng v\u00e0 ch\u00ednh x\u00e1c. Khi s\u1eed d\u1ee5ng c\u00e1c h\u00e0m trong Excel, b\u1ea1n c\u00f3 th\u1ec3:<\/span><\/p>\n

    \n<\/ul>\n

    \u200b<\/span><\/p>\n

    C\u00e1c h\u00e0m Excel l\u00e0 nh\u1eefng c\u00f4ng c\u1ee5 m\u1ea1nh m\u1ebd gi\u00fap b\u1ea1n th\u1ef1c hi\u1ec7n c\u00e1c thao t\u00e1c tr\u00ean d\u1eef li\u1ec7u m\u1ed9t c\u00e1ch nhanh ch\u00f3ng v\u00e0 ch\u00ednh x\u00e1c (Ngu\u1ed3n: Internet)<\/span><\/em><\/p>\n

    :\u00a0<\/span><\/p>\n

    H\u1ecdc kinh t\u1ebf ra l\u00e0m g\u00ec? C\u01a1 h\u1ed9i ph\u00e1t tri\u1ec3n v\u00e0 m\u1ee9c l\u01b0\u01a1ng ng\u00e0nh kinh t\u1ebf<\/span><\/p>\n

    H\u1ecdc logistic ra l\u00e0m g\u00ec? L\u01b0\u01a1ng v\u00e0 c\u01a1 h\u1ed9i vi\u1ec7c l\u00e0m ra sao<\/span><\/p>\n

    M\u1ed9t s\u1ed1 h\u00e0m s\u1eed d\u1ee5ng trong Excel ph\u1ed5 bi\u1ebfn v\u00e0 thao t\u00e1c c\u1ee5 th\u1ec3<\/strong><\/h2>\n

    C\u00f4ng th\u1ee9c c\u1ee7a c\u00e1c h\u00e0m t\u00ednh to\u00e1n trong Excel<\/strong><\/h3>\n

    Excel l\u00e0 m\u1ed9t ph\u1ea7n m\u1ec1m h\u1eefu \u00edch cho vi\u1ec7c x\u1eed l\u00fd d\u1eef li\u1ec7u s\u1ed1. Trong Excel, c\u00f3 nhi\u1ec1u h\u00e0m t\u00ednh to\u00e1n kh\u00e1c nhau \u0111\u1ec3 b\u1ea1n c\u00f3 th\u1ec3 th\u1ef1c hi\u1ec7n c\u00e1c ph\u00e9p t\u00ednh nhanh ch\u00f3ng v\u00e0 ch\u00ednh x\u00e1c.\u00a0<\/span><\/p>\n

    H\u00e0m SUM\u00a0<\/strong><\/h4>\n

    =SUM(number1, [number2], …)<\/em><\/strong><\/p>\n

    Trong \u0111\u00f3, <\/span>number1<\/span><\/em>, <\/span>number2<\/span><\/em>,… l\u00e0 c\u00e1c s\u1ed1 ho\u1eb7c c\u00e1c \u00f4 ch\u1ee9a s\u1ed1 m\u00e0 b\u1ea1n mu\u1ed1n t\u00ednh t\u1ed5ng. B\u1ea1n c\u00f3 th\u1ec3 nh\u1eadp nhi\u1ec1u s\u1ed1 ho\u1eb7c \u00f4 v\u00e0o c\u00f4ng th\u1ee9c, c\u00e1ch nhau b\u1edfi d\u1ea5u ph\u1ea9y.<\/span><\/p>\n

    V\u00ed d\u1ee5: =SUM(A1:A4) tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 l\u00e0 t\u1ed5ng c\u1ee7a c\u00e1c s\u1ed1 trong \u00f4 A1 \u0111\u1ebfn A4.<\/span><\/p>\n

    \n

    C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m SUM t\u00ednh t\u1ed5ng (Ngu\u1ed3n: Internet)<\/span><\/p>\n

    H\u00e0m Min\/Max\u00a0<\/strong><\/h4>\n

    H\u00e0m Min d\u00f9ng \u0111\u1ec3 t\u00ecm gi\u00e1 tr\u1ecb nh\u1ecf nh\u1ea5t trong m\u1ed9t d\u00e3y s\u1ed1. H\u00e0m Max d\u00f9ng \u0111\u1ec3 t\u00ecm gi\u00e1 tr\u1ecb l\u1edbn nh\u1ea5t trong m\u1ed9t d\u00e3y s\u1ed1.\u00a0<\/span><\/p>\n

    =MIN(number1, [number2], …)<\/em><\/strong><\/p>\n

    =MAX(number1, [number2], …)<\/em><\/strong><\/p>\n

    V\u00ed d\u1ee5:\u00a0<\/span><\/p>\n

    =MIN(1, 2, 3) tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 l\u00e0 1.<\/span><\/p>\n

    =MAX(A1:A5) tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 l\u00e0 gi\u00e1 tr\u1ecb l\u1edbn nh\u1ea5t trong c\u00e1c s\u1ed1 trong \u00f4 A1 \u0111\u1ebfn A5.<\/span><\/p>\n

    \n

    H\u00e0m MIN trong Excel (Ngu\u1ed3n: Internet)<\/span><\/p>\n

    H\u00e0m MOD\u00a0<\/strong><\/h4>\n

    H\u00e0m MOD d\u00f9ng \u0111\u1ec3 t\u00ednh ph\u1ea7n d\u01b0 c\u1ee7a ph\u00e9p chia hai s\u1ed1 nguy\u00ean.\u00a0<\/span><\/p>\n

    =MOD(number, divisor)<\/em><\/strong><\/p>\n

    Trong \u0111\u00f3, <\/span>number <\/span><\/em>l\u00e0 s\u1ed1 b\u1ecb chia, <\/span>divisor <\/span><\/em>l\u00e0 s\u1ed1 chia. C\u1ea3 hai s\u1ed1 ph\u1ea3i l\u00e0 s\u1ed1 nguy\u00ean.<\/span><\/p>\n

    V\u00ed d\u1ee5:<\/span><\/p>\n

    \u00a0=MOD(7, 3) tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 l\u00e0 1.<\/span><\/p>\n

    \n

    H\u00e0m MOD trong Excel (Ngu\u1ed3n: Internet)<\/span><\/p>\n

    H\u00e0m AVERAGE<\/strong><\/h4>\n

    H\u00e0m AVERAGE d\u00f9ng \u0111\u1ec3 t\u00ednh trung b\u00ecnh c\u1ed9ng c\u1ee7a m\u1ed9t d\u00e3y s\u1ed1.\u00a0<\/span><\/p>\n

    =AVERAGE(number1, [number2], …)<\/em><\/strong><\/p>\n

    V\u00ed d\u1ee5:\u00a0<\/span><\/p>\n

    =AVERAGE(1, 2, 3) tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 l\u00e0 2.<\/span><\/p>\n

    \n

    \n

    H\u00e0m COUNT<\/strong><\/h4>\n

    H\u00e0m COUNT d\u00f9ng \u0111\u1ec3 \u0111\u1ebfm s\u1ed1 l\u01b0\u1ee3ng c\u00e1c \u00f4 ch\u1ee9a s\u1ed1 trong m\u1ed9t d\u00e3y \u00f4.\u00a0<\/span><\/p>\n

    =COUNT(value1, [value2], …)<\/em><\/strong><\/p>\n

    Trong \u0111\u00f3, <\/span>value1<\/span><\/em>,<\/span> value2<\/span><\/em>,… l\u00e0 c\u00e1c gi\u00e1 tr\u1ecb ho\u1eb7c c\u00e1c \u00f4 m\u00e0 b\u1ea1n mu\u1ed1n \u0111\u1ebfm. B\u1ea1n c\u00f3 th\u1ec3 nh\u1eadp nhi\u1ec1u gi\u00e1 tr\u1ecb ho\u1eb7c \u00f4 v\u00e0o c\u00f4ng th\u1ee9c, c\u00e1ch nhau b\u1edfi d\u1ea5u ph\u1ea9y.<\/span><\/p>\n

    V\u00ed d\u1ee5:\u00a0<\/span><\/p>\n

    =COUNT(1, 2, 3) tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 l\u00e0 3.<\/span><\/p>\n

    \n

    H\u00e0m COUNT trong Excel (Ngu\u1ed3n: Internet)<\/span><\/p>\n

    :\u00a0<\/span><\/p>\n

    H\u1ecdc c\u00f4ng ngh\u1ec7 sinh h\u1ecdc ra l\u00e0m g\u00ec? C\u01a1 h\u1ed9i, m\u1ee9c l\u01b0\u01a1ng hi\u1ec7n nay<\/span><\/p>\n

    H\u1ecdc c\u00f4ng ngh\u1ec7 th\u00f4ng tin ra l\u00e0m g\u00ec? IT n\u00ean h\u1ecdc chuy\u00ean ng\u00e0nh n\u00e0o?<\/span><\/p>\n

    C\u00f4ng th\u1ee9c c\u1ee7a c\u00e1c h\u00e0m cho v\u0103n b\u1ea3n trong Excel<\/strong><\/h3>\n

    Excel c\u00f2n c\u00f3 nhi\u1ec1u t\u00ednh n\u0103ng \u0111a nhi\u1ec7m trong x\u1eed l\u00fd v\u0103n b\u1ea3n. B\u1ea1n c\u00f3 th\u1ec3 d\u00f9ng c\u00e1c h\u00e0m excel \u0111\u1ec3 lo\u1ea1i b\u1ecf c\u00e1c kho\u1ea3ng tr\u1eafng th\u1eeba, n\u1ed1i c\u00e1c chu\u1ed7i v\u0103n b\u1ea3n, chuy\u1ec3n \u0111\u1ed5i ch\u1eef hoa v\u00e0 ch\u1eef th\u01b0\u1eddng, thay th\u1ebf k\u00fd t\u1ef1 v\u00e0 \u0111\u1ebfm s\u1ed1 k\u00fd t\u1ef1 trong m\u1ed9t chu\u1ed7i, v.v.\u00a0<\/span><\/p>\n

    H\u00e0m TRIM<\/strong><\/h4>\n

    H\u00e0m TRIM c\u00f3 t\u00e1c d\u1ee5ng lo\u1ea1i b\u1ecf c\u00e1c kho\u1ea3ng tr\u1eafng th\u1eeba \u1edf \u0111\u1ea7u, cu\u1ed1i v\u00e0 gi\u1eefa m\u1ed9t chu\u1ed7i v\u0103n b\u1ea3n. \u0110i\u1ec1u n\u00e0y gi\u00fap cho d\u1eef li\u1ec7u v\u0103n b\u1ea3n \u0111\u01b0\u1ee3c s\u1ea1ch s\u1ebd v\u00e0 nh\u1ea5t qu\u00e1n.\u00a0<\/span><\/p>\n

    =TRIM(text)<\/em><\/strong><\/p>\n

    Trong \u0111\u00f3, <\/span>text <\/span><\/em>l\u00e0 chu\u1ed7i v\u0103n b\u1ea3n c\u1ea7n lo\u1ea1i b\u1ecf kho\u1ea3ng tr\u1eafng.<\/span><\/p>\n

    \n

    H\u00e0m TRIM trong Excel (Ngu\u1ed3n: Internet)<\/span><\/p>\n

    H\u00e0m CONCATENATE<\/strong><\/h4>\n

    H\u00e0m CONCATENATE c\u00f3 t\u00e1c d\u1ee5ng n\u1ed1i hai ho\u1eb7c nhi\u1ec1u chu\u1ed7i v\u0103n b\u1ea3n l\u1ea1i v\u1edbi nhau. \u0110i\u1ec1u n\u00e0y gi\u00fap cho b\u1ea1n c\u00f3 th\u1ec3 k\u1ebft h\u1ee3p c\u00e1c th\u00f4ng tin t\u1eeb c\u00e1c \u00f4 kh\u00e1c nhau th\u00e0nh m\u1ed9t \u00f4 duy nh\u1ea5t. C\u00f4ng th\u1ee9c c\u1ee7a h\u00e0m CONCATENATE l\u00e0:\u00a0<\/span><\/p>\n

    =CONCATENATE(text1, text2,…)<\/em><\/strong><\/p>\n

    Trong \u0111\u00f3, text1, text2,… l\u00e0 c\u00e1c chu\u1ed7i v\u0103n b\u1ea3n c\u1ea7n n\u1ed1i.<\/span><\/p>\n

    \n

    H\u00e0m CONCATENATE trong Excel (Ngu\u1ed3n: Internet)<\/span><\/p>\n

    C\u00e1c h\u00e0m chuy\u1ec3n \u0111\u1ed5i text (UPPER, LOWER, PROPER)<\/strong><\/h4>\n

    C\u00e1c h\u00e0m n\u00e0y c\u00f3 t\u00e1c d\u1ee5ng chuy\u1ec3n \u0111\u1ed5i ch\u1eef hoa v\u00e0 ch\u1eef th\u01b0\u1eddng trong m\u1ed9t chu\u1ed7i v\u0103n b\u1ea3n. \u0110i\u1ec1u n\u00e0y gi\u00fap cho b\u1ea1n c\u00f3 th\u1ec3 \u0111\u1ecbnh d\u1ea1ng v\u0103n b\u1ea3n theo \u00fd mu\u1ed1n.<\/span><\/p>\n

    =UPPER(text): <\/em><\/strong>chuy\u1ec3n \u0111\u1ed5i t\u1ea5t c\u1ea3 c\u00e1c k\u00fd t\u1ef1 trong text th\u00e0nh ch\u1eef hoa.<\/span><\/p>\n

    =LOWER(text): <\/em><\/strong>chuy\u1ec3n \u0111\u1ed5i t\u1ea5t c\u1ea3 c\u00e1c k\u00fd t\u1ef1 trong text th\u00e0nh ch\u1eef th\u01b0\u1eddng.<\/span><\/p>\n

    =PROPER(text):<\/em><\/strong> chuy\u1ec3n \u0111\u1ed5i k\u00fd t\u1ef1 \u0111\u1ea7u ti\u00ean c\u1ee7a m\u1ed7i t\u1eeb trong text th\u00e0nh ch\u1eef hoa, c\u00f2n l\u1ea1i l\u00e0 ch\u1eef th\u01b0\u1eddng.<\/span><\/p>\n

    \n

    H\u00e0m UPPER trong Excel (Ngu\u1ed3n: Internet)<\/span><\/p>\n

    H\u00e0m SUBSTITUTE<\/strong><\/h4>\n

    H\u00e0m SUBSTITUTE c\u00f3 t\u00e1c d\u1ee5ng thay th\u1ebf m\u1ed9t k\u00fd t\u1ef1 ho\u1eb7c m\u1ed9t chu\u1ed7i v\u0103n b\u1ea3n b\u1eb1ng m\u1ed9t k\u00fd t\u1ef1 ho\u1eb7c m\u1ed9t chu\u1ed7i v\u0103n b\u1ea3n kh\u00e1c trong m\u1ed9t chu\u1ed7i v\u0103n b\u1ea3n. \u0110i\u1ec1u n\u00e0y gi\u00fap cho b\u1ea1n c\u00f3 th\u1ec3 s\u1eeda l\u1ed7i ch\u00ednh t\u1ea3 ho\u1eb7c \u0111\u1ed3ng nh\u1ea5t c\u00e1ch vi\u1ebft trong v\u0103n b\u1ea3n.\u00a0<\/span><\/p>\n

    =SUBSTITUTE(text, old_text, new_text, [instance_num]).\u00a0<\/em><\/strong><\/p>\n

    Trong \u0111\u00f3:<\/span><\/p>\n

      \n<\/ul>\n

      \n

      H\u00e0m SUBSTITUTE trong Excel (Ngu\u1ed3n: Internet)<\/span><\/p>\n

      H\u00e0m \u0111\u1ebfm k\u00fd t\u1ef1 (LEFT, RIGHT, MID)<\/strong><\/p>\n

      C\u00e1c h\u00e0m n\u00e0y c\u00f3 t\u00e1c d\u1ee5ng tr\u00edch xu\u1ea5t m\u1ed9t s\u1ed1 k\u00fd t\u1ef1 t\u1eeb m\u1ed9t chu\u1ed7i v\u0103n b\u1ea3n theo v\u1ecb tr\u00ed c\u1ee7a ch\u00fang. \u0110i\u1ec1u n\u00e0y gi\u00fap cho b\u1ea1n c\u00f3 th\u1ec3 l\u1ea5y ra c\u00e1c th\u00f4ng tin c\u1ea7n thi\u1ebft t\u1eeb m\u1ed9t chu\u1ed7i v\u0103n b\u1ea3n d\u00e0i.\u00a0<\/span><\/p>\n

      =LEFT(text, [num_chars]): <\/em><\/strong>tr\u00edch xu\u1ea5t num_chars k\u00fd t\u1ef1 t\u1eeb b\u00ean tr\u00e1i c\u1ee7a text. N\u1ebfu kh\u00f4ng nh\u1eadp num_chars, h\u00e0m s\u1ebd tr\u00edch xu\u1ea5t m\u1ed9t k\u00fd t\u1ef1.<\/span><\/p>\n

      =RIGHT(text, [num_chars]): <\/em><\/strong>tr\u00edch xu\u1ea5t num_chars k\u00fd t\u1ef1 t\u1eeb b\u00ean ph\u1ea3i c\u1ee7a text. N\u1ebfu kh\u00f4ng nh\u1eadp num_chars, h\u00e0m s\u1ebd tr\u00edch xu\u1ea5t m\u1ed9t k\u00fd t\u1ef1.<\/span><\/p>\n

      =MID(text, start_num, num_chars):<\/em><\/strong> tr\u00edch xu\u1ea5t num_chars k\u00fd t\u1ef1 t\u1eeb v\u1ecb tr\u00ed start_num c\u1ee7a text.<\/span><\/p>\n

      \n

      H\u00e0m RIGHT trong Excel (Ngu\u1ed3n: Internet)<\/span><\/p>\n

      :\u00a0<\/span><\/p>\n

      H\u1ecdc ng\u00f4n ng\u1eef Anh ra l\u00e0m g\u00ec? M\u1ee9c l\u01b0\u01a1ng v\u00e0 c\u01a1 h\u1ed9i vi\u1ec7c l\u00e0m h\u1ea5p d\u1eabn<\/span><\/p>\n

      H\u1ecdc lu\u1eadt ra l\u00e0m g\u00ec? N\u00ean h\u1ecdc ng\u00e0nh lu\u1eadt kh\u00f4ng? M\u1ee9c l\u01b0\u01a1ng ra sao?<\/span><\/p>\n

      C\u00f4ng th\u1ee9c c\u00e1c h\u00e0m Logic trong Excel<\/strong><\/h3>\n

      H\u00e0m logic trong Excel l\u00e0 m\u1ed9t nh\u00f3m h\u00e0m \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 ki\u1ec3m tra c\u00e1c \u0111i\u1ec1u ki\u1ec7n v\u00e0 \u0111\u01b0a ra quy\u1ebft \u0111\u1ecbnh, \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 t\u1ef1 \u0111\u1ed9ng h\u00f3a c\u00e1c t\u00e1c v\u1ee5, l\u1ecdc d\u1eef li\u1ec7u v\u00e0 t\u1ea1o b\u00e1o c\u00e1o..\u00a0<\/span><\/p>\n

      H\u00e0m IF<\/strong><\/h4>\n

      H\u00e0m IF c\u00f3 t\u00e1c d\u1ee5ng ki\u1ec3m tra m\u1ed9t \u0111i\u1ec1u ki\u1ec7n n\u00e0o \u0111\u00f3 v\u00e0 tr\u1ea3 v\u1ec1 m\u1ed9t gi\u00e1 tr\u1ecb n\u1ebfu \u0111i\u1ec1u ki\u1ec7n \u0111\u00f3 \u0111\u00fang, v\u00e0 m\u1ed9t gi\u00e1 tr\u1ecb kh\u00e1c n\u1ebfu \u0111i\u1ec1u ki\u1ec7n \u0111\u00f3 sai.\u00a0<\/span><\/p>\n

      =IF(logical_test, value_if_true, value_if_false)<\/em><\/strong><\/p>\n

      Trong \u0111\u00f3:<\/span><\/p>\n

        \n<\/ul>\n

        \n

        H\u00e0m IF trong Excel (Ngu\u1ed3n: Internet)<\/span><\/p>\n

        H\u00e0m NOT<\/strong><\/h4>\n

        H\u00e0m NOT c\u00f3 t\u00e1c d\u1ee5ng \u0111\u1ea3o ng\u01b0\u1ee3c gi\u00e1 tr\u1ecb logic c\u1ee7a m\u1ed9t \u0111i\u1ec1u ki\u1ec7n n\u00e0o \u0111\u00f3. N\u1ebfu \u0111i\u1ec1u ki\u1ec7n \u0111\u00f3 \u0111\u00fang, h\u00e0m s\u1ebd tr\u1ea3 v\u1ec1 FALSE. N\u1ebfu \u0111i\u1ec1u ki\u1ec7n \u0111\u00f3 sai, h\u00e0m s\u1ebd tr\u1ea3 v\u1ec1 TRUE.\u00a0<\/span><\/p>\n

        =NOT(logical)<\/em><\/strong><\/p>\n

        Trong \u0111\u00f3, logical l\u00e0 \u0111i\u1ec1u ki\u1ec7n c\u1ea7n \u0111\u1ea3o ng\u01b0\u1ee3c.<\/span><\/p>\n

        \n

        \u1ee8ng d\u1ee5ng c\u00e1c h\u00e0m logic trong Excel (Ngu\u1ed3n: Internet)<\/span><\/p>\n

        C\u00f4ng th\u1ee9c h\u00e0m LOOKUP v\u00e0 c\u00e1c h\u00e0m kh\u00e1c trong Excel<\/strong><\/h3>\n

        N\u1ebfu b\u1ea1n mu\u1ed1n tra c\u1ee9u m\u1ed9t gi\u00e1 tr\u1ecb trong m\u1ed9t b\u1ea3ng d\u1eef li\u1ec7u, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng c\u00e1c h\u00e0m LOOKUP v\u00e0 c\u00e1c h\u00e0m li\u00ean quan trong Excel.\u00a0<\/span><\/p>\n

        H\u00e0m VLOOKUP<\/strong><\/h4>\n

        H\u00e0m VLOOKUP l\u00e0 m\u1ed9t trong nh\u1eefng h\u00e0m tra c\u1ee9u ph\u1ed5 bi\u1ebfn nh\u1ea5t trong Excel. H\u00e0m n\u00e0y cho ph\u00e9p b\u1ea1n t\u00ecm ki\u1ebfm m\u1ed9t gi\u00e1 tr\u1ecb trong c\u1ed9t \u0111\u1ea7u ti\u00ean c\u1ee7a m\u1ed9t b\u1ea3ng d\u1eef li\u1ec7u v\u00e0 tr\u1ea3 v\u1ec1 m\u1ed9t gi\u00e1 tr\u1ecb t\u1eeb c\u00f9ng h\u00e0ng c\u1ee7a c\u1ed9t kh\u00e1c.\u00a0<\/span><\/p>\n

        =VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])<\/em><\/strong><\/p>\n

        Trong \u0111\u00f3:<\/span><\/p>\n

          \n<\/ul>\n

          \n

          C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m VLOOKUP trong Excel (Ngu\u1ed3n: Internet)<\/span><\/p>\n

          H\u00e0m HLOOKUP<\/strong><\/h4>\n

          H\u00e0m HLOOKUP l\u00e0 h\u00e0m tra c\u1ee9u t\u01b0\u01a1ng t\u1ef1 nh\u01b0 h\u00e0m VLOOKUP, nh\u01b0ng n\u00f3 t\u00ecm ki\u1ebfm m\u1ed9t gi\u00e1 tr\u1ecb trong h\u00e0ng \u0111\u1ea7u ti\u00ean c\u1ee7a m\u1ed9t b\u1ea3ng d\u1eef li\u1ec7u v\u00e0 tr\u1ea3 v\u1ec1 m\u1ed9t gi\u00e1 tr\u1ecb t\u1eeb c\u00f9ng c\u1ed9t c\u1ee7a h\u00e0ng kh\u00e1c.\u00a0<\/span><\/p>\n

          =HLOOKUP(lookup_value, table_array, row_index_num, [range_lookup])<\/em><\/strong><\/p>\n

          Trong \u0111\u00f3:<\/span><\/p>\n

            \n<\/ul>\n

            \n

            C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m HLOOKUP trong Excel (Ngu\u1ed3n: Internet)<\/span><\/p>\n

            H\u00e0m HYPERLINK<\/strong><\/h4>\n

            H\u00e0m HYPERLINK cho ph\u00e9p b\u1ea1n t\u1ea1o m\u1ed9t li\u00ean k\u1ebft \u0111\u1ebfn m\u1ed9t t\u00e0i li\u1ec7u, m\u1ed9t t\u1ec7p, m\u1ed9t trang web ho\u1eb7c m\u1ed9t v\u1ecb tr\u00ed kh\u00e1c trong b\u1ea3ng t\u00ednh.\u00a0<\/span><\/p>\n

            =HYPERLINK(link_location, [friendly_name])<\/em><\/strong><\/p>\n

            Trong \u0111\u00f3:<\/span><\/p>\n

              \n<\/ul>\n

              V\u00ed d\u1ee5: B\u1ea1n mu\u1ed1n t\u1ea1o m\u1ed9t li\u00ean k\u1ebft \u0111\u1ebfn website Masterskills.vn v\u00e0 hi\u1ec3n th\u1ecb v\u0103n b\u1ea3n “Website tuy\u1ec3n d\u1ee5ng”. B\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c sau:<\/span><\/p>\n

              =HYPERLINK(“https:\/\/www.Masterskills.vn”,”Website tuy\u1ec3n d\u1ee5ng”)<\/span><\/p>\n

              K\u1ebft qu\u1ea3 s\u1ebd l\u00e0 m\u1ed9t \u00f4 c\u00f3 ch\u1ee9a v\u0103n b\u1ea3n “Website tuy\u1ec3n d\u1ee5ng” v\u00e0 khi b\u1ea1n nh\u1ea5p v\u00e0o \u00f4 \u0111\u00f3, b\u1ea1n s\u1ebd \u0111\u01b0\u1ee3c chuy\u1ec3n \u0111\u1ebfn website Masterskills.vn.<\/span><\/p>\n

              H\u00e0m INDEX<\/strong><\/h4>\n

              H\u00e0m INDEX cho ph\u00e9p b\u1ea1n tr\u00edch xu\u1ea5t m\u1ed9t gi\u00e1 tr\u1ecb t\u1eeb m\u1ed9t m\u1ea3ng ho\u1eb7c b\u1ea3ng t\u00ednh theo ch\u1ec9 s\u1ed1 h\u00e0ng v\u00e0 c\u1ed9t.<\/span><\/p>\n

              =INDEX(array, row_num, [column_num])<\/em><\/strong><\/p>\n

              Trong \u0111\u00f3:<\/span><\/p>\n

                \n<\/ul>\n

                V\u00ed d\u1ee5: =INDEX(B2:C10,4,2) s\u1ebd tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb \u1edf h\u00e0ng 4, c\u1ed9t 2 c\u1ee7a b\u1ea3ng B2:C10.<\/span><\/p>\n

                H\u00e0m INDIRECT\u00a0<\/strong><\/h4>\n

                H\u00e0m n\u00e0y cho ph\u00e9p b\u1ea1n tham chi\u1ebfu \u0111\u1ebfn m\u1ed9t \u00f4 ho\u1eb7c m\u1ed9t ph\u1ea1m vi \u00f4 b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng m\u1ed9t chu\u1ed7i v\u0103n b\u1ea3n.\u00a0<\/span><\/p>\n

                =INDIRECT (ref_text, [a1])<\/em><\/strong><\/p>\n

                Trong \u0111\u00f3:<\/span><\/p>\n

                  \n<\/ul>\n

                  V\u00ed d\u1ee5: =INDIRECT(“B”&A2) s\u1ebd tham chi\u1ebfu \u0111\u1ebfn \u00f4 B v\u1edbi s\u1ed1 h\u00e0ng b\u1eb1ng v\u1edbi gi\u00e1 tr\u1ecb c\u1ee7a A2.<\/span><\/p>\n

                  : <\/span>H\u1ecdc qu\u1ea3n tr\u1ecb kinh doanh ra l\u00e0m g\u00ec? C\u00f3 n\u00ean h\u1ecdc qu\u1ea3n tr\u1ecb kinh doanh?<\/span><\/p>\n

                  Nh\u1eefng \u0111i\u1ec1u c\u1ea7n l\u01b0u \u00fd khi th\u1ef1c hi\u1ec7n c\u00e1c h\u00e0m trong Excel<\/strong><\/h2>\n

                  Khi s\u1eed d\u1ee5ng c\u00e1c h\u00e0m trong Excel, b\u1ea1n c\u1ea7n l\u01b0u \u00fd nh\u1eefng \u0111i\u1ec1u sau:<\/span><\/p>\n

                    \n<\/ul>\n

                    Excel l\u00e0 m\u1ed9t c\u00f4ng c\u1ee5 c\u00f3 nhi\u1ec1u h\u00e0m \u0111a d\u1ea1ng nh\u01b0ng c\u0169ng kh\u00f4ng k\u00e9m ph\u1ea7n ph\u1ee9c t\u1ea1p. V\u00ec th\u1ebf, \u0111\u1ec3 c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng \u0111\u01b0\u1ee3c c\u00e1c h\u00e0m n\u00e0y th\u00e0nh th\u1ea1o, b\u1ea1n c\u1ea7n d\u00e0nh nhi\u1ec1u th\u1eddi gian t\u00ecm t\u00f2i, h\u1ecdc h\u1ecfi v\u00e0 th\u1ef1c h\u00e0nh th\u01b0\u1eddng xuy\u00ean. Hy v\u1ecdng b\u00e0i vi\u1ebft c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m Excel n\u00e0y t\u1eeb <\/span>Masterskills<\/span> \u0111\u00e3 mang l\u1ea1i cho b\u1ea1n nhi\u1ec1u th\u00f4ng tin h\u1eefu \u00edch \u0111\u1ec3 c\u00f3 th\u1ec3 l\u00e0m vi\u1ec7c v\u00e0 h\u1ecdc t\u1eadp c\u00f9ng c\u00e1c h\u00e0m Excel theo c\u00e1ch th\u00f4ng minh nh\u1ea5t.<\/span><\/p>\n<\/p><\/div>\n","protected":false},"excerpt":{"rendered":"

                    CareerBuilder<\/strong><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[431],"tags":[],"_links":{"self":[{"href":"https:\/\/masterskills.org\/blog\/wp-json\/wp\/v2\/posts\/19302"}],"collection":[{"href":"https:\/\/masterskills.org\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/masterskills.org\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/masterskills.org\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/masterskills.org\/blog\/wp-json\/wp\/v2\/comments?post=19302"}],"version-history":[{"count":0,"href":"https:\/\/masterskills.org\/blog\/wp-json\/wp\/v2\/posts\/19302\/revisions"}],"wp:attachment":[{"href":"https:\/\/masterskills.org\/blog\/wp-json\/wp\/v2\/media?parent=19302"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/masterskills.org\/blog\/wp-json\/wp\/v2\/categories?post=19302"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/masterskills.org\/blog\/wp-json\/wp\/v2\/tags?post=19302"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}