{"id":7626,"date":"2024-09-10T10:43:27","date_gmt":"2024-09-10T03:43:27","guid":{"rendered":"https:\/\/mb668s.com\/cam-nang-7mb66-xoc-dia\/?p=7626"},"modified":"2024-09-10T10:43:28","modified_gmt":"2024-09-10T03:43:28","slug":"cac-ham-trong-excel-thong-dung-danh-cho-nhan-vien-van-phong","status":"publish","type":"post","link":"https:\/\/mb668s.com\/cam-nang-7mb66-xoc-dia\/goc-ky-nang\/cac-ham-trong-excel-thong-dung-danh-cho-nhan-vien-van-phong","title":{"rendered":"C\u00e1c h\u00e0m trong Excel th\u00f4ng d\u1ee5ng d\u00e0nh cho nh\u00e2n vi\u00ean v\u0103n ph\u00f2ng"},"content":{"rendered":"\n

Excel l\u00e0 m\u1ed9t c\u00f4ng c\u1ee5 c\u1ef1c k\u1ef3 hi\u1ec7u qu\u1ea3 trong m\u00f4i tr\u01b0\u1eddng l\u00e0m vi\u1ec7c v\u0103n ph\u00f2ng v\u1edbi kh\u1ea3 n\u0103ng x\u1eed l\u00fd d\u1eef li\u1ec7u v\u00e0 ph\u00e2n t\u00edch th\u00f4ng tin m\u1ed9t c\u00e1ch nhanh ch\u00f3ng, ch\u00ednh x\u00e1c. D\u01b0\u1edbi \u0111\u00e2y l\u00e0 c\u00e1c h\u00e0m trong Excel<\/strong> m\u00e0 d\u00e2n v\u0103n ph\u00f2ng s\u1ebd \u00e1p d\u1ee5ng trong c\u00f4ng vi\u1ec7c h\u00e0ng ng\u00e0y.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

C\u00e1c h\u00e0m trong Excel th\u01b0\u1eddng s\u1eed d\u1ee5ng trong c\u00f4ng vi\u1ec7c v\u0103n ph\u00f2ng<\/h2>\n\n\n\n
\n

\u201cC\u00e1c h\u00e0m trong Excel \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 th\u1ef1c hi\u1ec7n c\u00e1c ph\u00e9p t\u00ednh ph\u1ee9c t\u1ea1p kh\u00f4ng th\u1ec3 th\u1ef1c hi\u1ec7n th\u1ee7 c\u00f4ng, c\u00f3 t\u00ean ph\u1ea3n \u00e1nh m\u1ee5c \u0111\u00edch s\u1eed d\u1ee5ng c\u1ee7a ch\u00fang.\u201d<\/strong><\/p>\n<\/blockquote>\n\n\n\n

H\u00e0m SUM<\/h3>\n\n\n\n

M\u1ed9t trong c\u00e1c h\u00e0m trong Excel g\u1ea7n g\u0169i nh\u1ea5t v\u1edbi d\u00e2n v\u0103n ph\u00f2ng ch\u1eafc ch\u1eafn l\u00e0 h\u00e0m SUM. H\u00e0m SUM \u0111\u01b0\u1ee3c d\u00f9ng \u0111\u1ec3 t\u00ednh t\u1ed5ng c\u1ee7a m\u1ed9t d\u00e3y s\u1ed1 ho\u1eb7c ph\u1ea1m vi \u00f4. \u0110\u00e2y l\u00e0 h\u00e0m c\u01a1 b\u1ea3n nh\u1ea5t trong Excel v\u00e0 c\u1ef1c k\u1ef3 h\u1eefu \u00edch trong vi\u1ec7c t\u1ed5ng h\u1ee3p d\u1eef li\u1ec7u t\u00e0i ch\u00ednh, b\u00e1o c\u00e1o doanh thu hay b\u1ea5t k\u1ef3 d\u1eef li\u1ec7u s\u1ed1 n\u00e0o kh\u00e1c. S\u1eed d\u1ee5ng h\u00e0m SUM gi\u00fap b\u1ea1n ti\u1ebft ki\u1ec7m th\u1eddi gian v\u00e0 gi\u1ea3m thi\u1ec3u l\u1ed7i t\u00ednh to\u00e1n khi ph\u1ea3i l\u00e0m vi\u1ec7c v\u1edbi nhi\u1ec1u d\u1eef li\u1ec7u.<\/p>\n\n\n\n

    \n
  • C\u00fa ph\u00e1p: =SUM(number1, [number2], …)<\/li>\n\n\n\n
  • Gi\u1ea3 s\u1eed b\u1ea1n c\u00f3 b\u1ea3ng doanh thu h\u00e0ng th\u00e1ng t\u1eeb \u00f4 A1 \u0111\u1ebfn A10. \u0110\u1ec3 t\u00ednh t\u1ed5ng doanh thu, b\u1ea1n s\u1eed d\u1ee5ng h\u00e0m: =SUM(A1:A10)<\/li>\n\n\n\n
  • H\u00e0m SUM s\u1ebd c\u1ed9ng t\u1ea5t c\u1ea3 c\u00e1c gi\u00e1 tr\u1ecb trong ph\u1ea1m vi t\u1eeb A1 \u0111\u1ebfn A10 v\u00e0 cung c\u1ea5p t\u1ed5ng doanh thu cho b\u1ea1n.<\/li>\n<\/ul>\n\n\n\n

    H\u00e0m AVERAGE<\/h3>\n\n\n\n

    H\u00e0m AVERAGE t\u00ednh gi\u00e1 tr\u1ecb trung b\u00ecnh c\u1ee7a m\u1ed9t d\u00e3y s\u1ed1 ho\u1eb7c ph\u1ea1m vi \u00f4 \u0111\u1ec3 ng\u01b0\u1eddi xem hi\u1ec3u r\u00f5 h\u01a1n v\u1ec1 d\u1eef li\u1ec7u, ch\u1eb3ng h\u1ea1n nh\u01b0 hi\u1ec7u su\u1ea5t l\u00e0m vi\u1ec7c, \u0111i\u1ec3m s\u1ed1 h\u1ecdc t\u1eadp hay doanh thu. \u0110\u00e2y l\u00e0 c\u00f4ng c\u1ee5 quan tr\u1ecdng trong vi\u1ec7c ph\u00e2n t\u00edch xu h\u01b0\u1edbng d\u1eef li\u1ec7u, \u0111\u00e1nh gi\u00e1 hi\u1ec7u su\u1ea5t, t\u1eeb \u0111\u00f3 \u0111\u01b0a ra c\u00e1c chi\u1ebfn l\u01b0\u1ee3c v\u00e0 k\u1ebf ho\u1ea1ch ho\u1ea1t \u0111\u1ed9ng d\u1ef1a tr\u00ean d\u1eef li\u1ec7u th\u1ef1c t\u1ebf.<\/p>\n\n\n\n

      \n
    • C\u00fa ph\u00e1p: =AVERAGE(number1, [number2], …)<\/li>\n\n\n\n
    • V\u00ed d\u1ee5: \u0110\u1ec3 t\u00ednh \u0111i\u1ec3m trung b\u00ecnh c\u1ee7a h\u1ecdc sinh t\u1eeb \u00f4 B1 \u0111\u1ebfn B10, b\u1ea1n s\u1ebd s\u1eed d\u1ee5ng h\u00e0m: =AVERAGE(B1:B10)<\/li>\n\n\n\n
    • H\u00e0m AVERAGE s\u1ebd t\u00ednh \u0111i\u1ec3m trung b\u00ecnh c\u1ee7a l\u1edbp, gi\u00fap b\u1ea1n \u0111\u00e1nh gi\u00e1 t\u1ed5ng quan v\u1ec1 th\u00e0nh t\u00edch h\u1ecdc t\u1eadp c\u1ee7a h\u1ecdc sinh.<\/li>\n<\/ul>\n\n\n\n

      H\u00e0m COUNT<\/h3>\n\n\n\n

      H\u00e0m COUNT \u0111\u1ebfm s\u1ed1 l\u01b0\u1ee3ng \u00f4 ch\u1ee9a d\u1eef li\u1ec7u s\u1ed1 trong m\u1ed9t ph\u1ea1m vi. C\u00f4ng c\u1ee5 n\u00e0y gi\u00fap b\u1ea1n ki\u1ec3m tra s\u1ed1 l\u01b0\u1ee3ng m\u1ee5c nh\u1eadp, ph\u00e1t hi\u1ec7n c\u00e1c \u00f4 b\u1ecb b\u1ecf tr\u1ed1ng ho\u1eb7c l\u1ed7i nh\u1eadp li\u1ec7u v\u00e0 h\u1ed7 tr\u1ee3 trong vi\u1ec7c t\u1ed5ng h\u1ee3p d\u1eef li\u1ec7u cho b\u00e1o c\u00e1o.<\/p>\n\n\n\n

        \n
      • C\u00fa ph\u00e1p: =COUNT(value1, [value2], …)<\/li>\n\n\n\n
      • V\u00ed d\u1ee5: \u0110\u1ec3 \u0111\u1ebfm s\u1ed1 ng\u00e0y c\u00f3 doanh thu t\u1eeb \u00f4 C1 \u0111\u1ebfn C30, b\u1ea1n s\u1eed d\u1ee5ng h\u00e0m: =COUNT(C1:C30)<\/li>\n\n\n\n
      • H\u00e0m COUNT s\u1ebd cung c\u1ea5p s\u1ed1 l\u01b0\u1ee3ng \u00f4 c\u00f3 ch\u1ee9a d\u1eef li\u1ec7u s\u1ed1, gi\u00fap b\u1ea1n theo d\u00f5i v\u00e0 ph\u00e2n t\u00edch d\u1eef li\u1ec7u b\u00e1n h\u00e0ng hi\u1ec7u qu\u1ea3.<\/li>\n<\/ul>\n\n\n\n

        H\u00e0m COUNTIF<\/h3>\n\n\n\n

        H\u00e0m COUNTIF d\u00f9ng \u0111\u1ec1 \u0111\u1ebfm s\u1ed1 \u00f4 ch\u1ee9a m\u1ed9t gi\u00e1 tr\u1ecb ho\u1eb7c ph\u1ea1m vi gi\u00e1 tr\u1ecb c\u1ee5 th\u1ec3. S\u1eed d\u1ee5ng COUNTIF d\u1ec5 h\u01a1n l\u00e0 t\u1ef1 \u0111\u1ebfm th\u1ee7 c\u00f4ng.<\/p>\n\n\n\n

          \n
        • C\u00fa ph\u00e1p:=COUNTIF(range,criteria)<\/li>\n\n\n\n
        • V\u1edbi range: V\u00f9ng d\u1eef li\u1ec7u c\u1ea7n \u0111\u1ebfm v\u00e0 criteria: \u0110i\u1ec1u ki\u1ec7n \u0111\u1ec3 \u0111\u1ebfm.<\/li>\n\n\n\n
        • V\u00ed d\u1ee5: \u0110\u1ec3 th\u1ed1ng k\u00ea xem c\u00f3 bao nhi\u00eau m\u1eb7t h\u00e0ng c\u00f2n t\u1ed3n tr\u00ean 100 s\u1ea3n ph\u1ea9m, nh\u1eadp c\u00f4ng th\u1ee9c: =COUNTIF(C2:C11,”>100″)<\/li>\n<\/ul>\n\n\n\n

          H\u00e0m CHOOSE<\/h3>\n\n\n\n

          H\u00e0m CHOOSE c\u1ee7a Excel tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb t\u1eeb danh s\u00e1ch b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng v\u1ecb tr\u00ed ho\u1eb7c ch\u1ec9 m\u1ee5c \u0111\u00e3 cho.<\/p>\n\n\n\n

            \n
          • C\u00fa ph\u00e1p:=CHOOSE(index_num, value1, value2, …)<\/li>\n\n\n\n
          • Trong \u0111\u00f3: index_num – Gi\u00e1 tr\u1ecb \u0111\u1ec3 l\u1ef1a ch\u1ecdn. M\u1ed9t s\u1ed1 t\u1eeb 1 \u0111\u1ebfn 254; value1 – Gi\u00e1 tr\u1ecb \u0111\u1ea7u ti\u00ean \u0111\u1ec3 l\u1ef1a ch\u1ecdn; value2 – [t\u00f9y ch\u1ecdn] Gi\u00e1 tr\u1ecb th\u1ee9 hai \u0111\u1ec3 l\u1ef1a ch\u1ecdn.<\/li>\n\n\n\n
          • V\u00ed d\u1ee5: =CHOOSE(2,”red”,”blue”,”green”) tr\u1ea3 v\u1ec1 “blue”, v\u00ec blue l\u00e0 gi\u00e1 tr\u1ecb th\u1ee9 2 \u0111\u01b0\u1ee3c li\u1ec7t k\u00ea sau s\u1ed1 ch\u1ec9 m\u1ee5c.<\/li>\n<\/ul>\n\n\n\n

            H\u00e0m IF<\/h3>\n\n\n\n

            H\u00e0m IF th\u1ef1c hi\u1ec7n c\u00e1c ph\u00e9p to\u00e1n \u0111i\u1ec1u ki\u1ec7n, cho ph\u00e9p b\u1ea1n 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\u00f3 \u0111\u00fang, m\u1ed9t gi\u00e1 tr\u1ecb kh\u00e1c n\u1ebfu \u0111i\u1ec1u ki\u1ec7n \u0111\u00f3 sai. H\u00e0m IF h\u1ed7 tr\u1ee3 ph\u00e2n lo\u1ea1i d\u1eef li\u1ec7u, \u0111\u01b0a ra c\u00e1c quy\u1ebft \u0111\u1ecbnh t\u1ef1 \u0111\u1ed9ng v\u00e0 t\u00f9y ch\u1ec9nh b\u00e1o c\u00e1o theo \u0111i\u1ec1u ki\u1ec7n. \u0110i\u1ec1u n\u00e0y gi\u00fap b\u1ea1n ti\u1ebft ki\u1ec7m th\u1eddi gian v\u00e0 t\u0103ng t\u00ednh ch\u00ednh x\u00e1c trong ph\u00e2n t\u00edch d\u1eef li\u1ec7u.<\/p>\n\n\n\n

              \n
            • C\u00fa ph\u00e1p: =IF(logical_test, value_if_true, value_if_false)<\/li>\n\n\n\n
            • V\u00ed d\u1ee5: \u0110\u1ec3 ki\u1ec3m tra \u0111i\u1ec3m s\u1ed1 trong \u00f4 D1 c\u00f3 \u0111\u1ea1t y\u00eau c\u1ea7u (tr\u00ean 60) hay kh\u00f4ng: =IF(D1 > 60, “\u0110\u1ea1t”, “Kh\u00f4ng \u0111\u1ea1t”)<\/li>\n\n\n\n
            • H\u00e0m IF s\u1ebd tr\u1ea3 v\u1ec1 “\u0110\u1ea1t” n\u1ebfu gi\u00e1 tr\u1ecb trong \u00f4 D1 l\u1edbn h\u01a1n 60 v\u00e0 “Kh\u00f4ng \u0111\u1ea1t” n\u1ebfu ng\u01b0\u1ee3c l\u1ea1i.<\/li>\n<\/ul>\n\n\n\n

              H\u00e0m VLOOKUP<\/h3>\n\n\n\n

              H\u00e0m VLOOKUP t\u00ecm ki\u1ebfm m\u1ed9t gi\u00e1 tr\u1ecb trong c\u1ed9t \u0111\u1ea7u ti\u00ean c\u1ee7a m\u1ed9t b\u1ea3ng v\u00e0 tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb t\u1eeb c\u00f9ng h\u00e0ng trong c\u1ed9t kh\u00e1c, gi\u00fap ti\u1ebft ki\u1ec7m th\u1eddi gian trong vi\u1ec7c tra c\u1ee9u d\u1eef li\u1ec7u v\u00e0 k\u1ebft h\u1ee3p th\u00f4ng tin t\u1eeb nhi\u1ec1u ngu\u1ed3n. H\u00e0m n\u00e0y \u0111\u1eb7c bi\u1ec7t h\u1eefu \u00edch khi b\u1ea1n l\u00e0m vi\u1ec7c v\u1edbi c\u00e1c b\u1ea3ng d\u1eef li\u1ec7u l\u1edbn v\u00e0 c\u1ea7n t\u00ecm ki\u1ebfm th\u00f4ng tin nhanh ch\u00f3ng.<\/p>\n\n\n\n

                \n
              • C\u00fa ph\u00e1p: =VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])<\/li>\n\n\n\n
              • V\u00ed d\u1ee5: \u0110\u1ec3 t\u00ecm gi\u00e1 c\u1ee7a “S\u1ea3n ph\u1ea9m X” trong b\u1ea3ng gi\u00e1 s\u1ea3n ph\u1ea9m t\u1eeb A1 \u0111\u1ebfn C10: =VLOOKUP(“S\u1ea3n ph\u1ea9m X”, A1:C10, 3, FALSE)<\/li>\n\n\n\n
              • H\u00e0m VLOOKUP s\u1ebd tr\u1ea3 v\u1ec1 gi\u00e1 c\u1ee7a s\u1ea3n ph\u1ea9m X t\u1eeb c\u1ed9t th\u1ee9 ba c\u1ee7a b\u1ea3ng, gi\u00fap b\u1ea1n tra c\u1ee9u gi\u00e1 nhanh ch\u00f3ng v\u00e0 ch\u00ednh x\u00e1c.<\/li>\n<\/ul>\n\n\n\n

                H\u00e0m HLOOKUP<\/h3>\n\n\n\n

                Trong s\u1ed1 c\u00e1c h\u00e0m trong Excel<\/strong>, h\u00e0m HLOOKUP t\u01b0\u01a1ng t\u1ef1 nh\u01b0 VLOOKUP nh\u01b0ng t\u00ecm ki\u1ebfm gi\u00e1 tr\u1ecb theo h\u00e0ng ngang thay v\u00ec c\u1ed9t d\u1ecdc, ph\u00f9 h\u1ee3p v\u1edbi c\u00e1c b\u1ea3ng b\u00e1o c\u00e1o ho\u1eb7c d\u1eef li\u1ec7u \u0111\u01b0\u1ee3c t\u1ed5 ch\u1ee9c theo h\u00e0ng.<\/p>\n\n\n\n

                  \n
                • C\u00fa ph\u00e1p: =HLOOKUP(lookup_value, table_array, row_index_num, [range_lookup])<\/li>\n\n\n\n
                • V\u00ed d\u1ee5: \u0110\u1ec3 t\u00ecm doanh thu c\u1ee7a “Th\u00e1ng 3” trong b\u1ea3ng b\u00e1o c\u00e1o t\u1eeb A1 \u0111\u1ebfn E5: =HLOOKUP(“Th\u00e1ng 3”, A1:E5, 2, FALSE)<\/li>\n\n\n\n
                • H\u00e0m HLOOKUP s\u1ebd tr\u1ea3 v\u1ec1 doanh thu c\u1ee7a th\u00e1ng 3 t\u1eeb h\u00e0ng th\u1ee9 hai c\u1ee7a b\u1ea3ng, gi\u00fap b\u1ea1n nhanh ch\u00f3ng tra c\u1ee9u th\u00f4ng tin.<\/li>\n<\/ul>\n\n\n\n

                  H\u00e0m INDEX<\/h3>\n\n\n\n

                  H\u00e0m INDEX tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb c\u1ee7a m\u1ed9t \u00f4 trong b\u1ea3ng d\u1ef1a tr\u00ean ch\u1ec9 s\u1ed1 h\u00e0ng v\u00e0 c\u1ed9t. \u0110\u00e2y l\u00e0 c\u00f4ng c\u1ee5 m\u1ea1nh m\u1ebd \u0111\u1ec3 truy xu\u1ea5t d\u1eef li\u1ec7u t\u1eeb b\u1ea3ng ho\u1eb7c ph\u1ea1m vi \u00f4, th\u01b0\u1eddng \u0111\u01b0\u1ee3c k\u1ebft h\u1ee3p v\u1edbi h\u00e0m MATCH \u0111\u1ec3 t\u1ea1o c\u00e1c ph\u00e9p tra c\u1ee9u n\u00e2ng cao.<\/p>\n\n\n\n

                    \n
                  • C\u00fa ph\u00e1p: =INDEX(array, row_num, [column_num])<\/li>\n\n\n\n
                  • V\u00ed d\u1ee5: \u0110\u1ec3 l\u1ea5y gi\u00e1 tr\u1ecb t\u1ea1i h\u00e0ng th\u1ee9 4, c\u1ed9t th\u1ee9 2 trong b\u1ea3ng t\u1eeb A1 \u0111\u1ebfn C10: =INDEX(A1:C10, 4, 2)<\/li>\n\n\n\n
                  • H\u00e0m INDEX s\u1ebd tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb c\u1ee7a \u00f4 t\u1ea1i v\u1ecb tr\u00ed c\u1ee5 th\u1ec3 trong b\u1ea3ng, gi\u00fap b\u1ea1n truy xu\u1ea5t d\u1eef li\u1ec7u ch\u00ednh x\u00e1c t\u1eeb b\u1ea3ng.<\/li>\n<\/ul>\n\n\n\n

                    H\u00e0m MATCH<\/h3>\n\n\n\n

                    H\u00e0m MATCH t\u00ecm ki\u1ebfm m\u1ed9t gi\u00e1 tr\u1ecb trong ph\u1ea1m vi v\u00e0 tr\u1ea3 v\u1ec1 v\u1ecb tr\u00ed c\u1ee7a gi\u00e1 tr\u1ecb \u0111\u00f3, gi\u00fap x\u00e1c \u0111\u1ecbnh v\u1ecb tr\u00ed c\u1ee7a gi\u00e1 tr\u1ecb trong danh s\u00e1ch, th\u01b0\u1eddng \u0111\u01b0\u1ee3c k\u1ebft h\u1ee3p v\u1edbi h\u00e0m INDEX \u0111\u1ec3 th\u1ef1c hi\u1ec7n tra c\u1ee9u n\u00e2ng cao v\u00e0 ph\u00e2n t\u00edch d\u1eef li\u1ec7u.<\/p>\n\n\n\n

                      \n
                    • C\u00fa ph\u00e1p: =MATCH(lookup_value, lookup_array, [match_type])<\/li>\n\n\n\n
                    • V\u00ed d\u1ee5: \u0110\u1ec3 t\u00ecm v\u1ecb tr\u00ed c\u1ee7a “S\u1ea3n ph\u1ea9m Y” trong c\u1ed9t t\u1eeb A1 \u0111\u1ebfn A10: =MATCH(“S\u1ea3n ph\u1ea9m Y”, A1:A10, 0)<\/li>\n\n\n\n
                    • H\u00e0m MATCH s\u1ebd tr\u1ea3 v\u1ec1 v\u1ecb tr\u00ed c\u1ee7a s\u1ea3n ph\u1ea9m Y trong danh s\u00e1ch, gi\u00fap b\u1ea1n nhanh ch\u00f3ng t\u00ecm ki\u1ebfm v\u00e0 ph\u00e2n t\u00edch d\u1eef li\u1ec7u.<\/li>\n<\/ul>\n\n\n\n

                      H\u00e0m CONCATENATE \/ CONCAT<\/h3>\n\n\n\n

                      H\u00e0m CONCATENATE ho\u1eb7c CONCAT n\u1ed1i c\u00e1c chu\u1ed7i v\u0103n b\u1ea3n t\u1eeb nhi\u1ec1u \u00f4 th\u00e0nh m\u1ed9t \u00f4 duy nh\u1ea5t. \u0110\u00e2y l\u00e0 c\u00f4ng c\u1ee5 h\u1eefu \u00edch \u0111\u1ec3 k\u1ebft h\u1ee3p th\u00f4ng tin t\u1eeb nhi\u1ec1u ngu\u1ed3n ho\u1eb7c t\u1ea1o c\u00e1c chu\u1ed7i v\u0103n b\u1ea3n ho\u00e0n ch\u1ec9nh.<\/p>\n\n\n\n

                        \n
                      • C\u00fa ph\u00e1p: =CONCATENATE(text1, [text2], …) ho\u1eb7c =CONCAT(text1, [text2], …)<\/li>\n\n\n\n
                      • V\u00ed d\u1ee5: \u0110\u1ec3 n\u1ed1i t\u00ean v\u00e0 h\u1ecd t\u1eeb \u00f4 A1 v\u00e0 B1: =CONCATENATE(A1, ” “, B1)<\/li>\n\n\n\n
                      • H\u00e0m CONCATENATE s\u1ebd k\u1ebft h\u1ee3p t\u00ean v\u00e0 h\u1ecd th\u00e0nh m\u1ed9t chu\u1ed7i v\u0103n b\u1ea3n duy nh\u1ea5t, thu\u1eadn ti\u1ec7n cho vi\u1ec7c tr\u00ecnh b\u00e0y th\u00f4ng tin.<\/li>\n<\/ul>\n\n\n\n

                        H\u00e0m LEFT, MID, RIGHT<\/h3>\n\n\n\n

                        C\u00e1c h\u00e0m LEFT, MID, RIGHT \u0111\u01b0\u1ee3c d\u00f9ng \u0111\u1ec3 tr\u00edch xu\u1ea5t m\u1ed9t ph\u1ea7n c\u1ee7a chu\u1ed7i v\u0103n b\u1ea3n. LEFT l\u1ea5y k\u00fd t\u1ef1 t\u1eeb \u0111\u1ea7u chu\u1ed7i, MID l\u1ea5y k\u00fd t\u1ef1 t\u1eeb gi\u1eefa chu\u1ed7i v\u00e0 RIGHT l\u1ea5y k\u00fd t\u1ef1 t\u1eeb cu\u1ed1i chu\u1ed7i. Nh\u1eefng h\u00e0m n\u00e0y gi\u00fap b\u1ea1n x\u1eed l\u00fd chu\u1ed7i v\u0103n b\u1ea3n hi\u1ec7u qu\u1ea3, \u0111\u1eb7c bi\u1ec7t l\u00e0 khi c\u1ea7n tr\u00edch xu\u1ea5t m\u00e3 s\u1ed1 s\u1ea3n ph\u1ea9m, th\u00f4ng s\u1ed1 c\u1ee7a \u0111\u1ecba ch\u1ec9 ho\u1eb7c c\u00e1c d\u1eef li\u1ec7u v\u0103n b\u1ea3n kh\u00e1c \u0111\u1ec3 ph\u00e2n t\u00edch v\u00e0 b\u00e1o c\u00e1o.<\/p>\n\n\n\n

                          \n
                        • C\u00fa ph\u00e1p: =LEFT(text, [num_chars]); =MID(text, start_num, num_chars) ho\u1eb7c =RIGHT(text, [num_chars])<\/li>\n\n\n\n
                        • V\u00ed d\u1ee5:<\/li>\n\n\n\n
                        • \u0110\u1ec3 l\u1ea5y 5 k\u00fd t\u1ef1 t\u1eeb \u0111\u1ea7u chu\u1ed7i trong \u00f4 A1: =LEFT(A1, 5)<\/li>\n\n\n\n
                        • \u0110\u1ec3 l\u1ea5y 4 k\u00fd t\u1ef1 t\u1eeb v\u1ecb tr\u00ed th\u1ee9 3 trong \u00f4 A1: =MID(A1, 3, 4)<\/li>\n\n\n\n
                        • \u0110\u1ec3 l\u1ea5y 3 k\u00fd t\u1ef1 t\u1eeb cu\u1ed1i chu\u1ed7i trong \u00f4 A1: =RIGHT(A1, 3)<\/li>\n<\/ul>\n\n\n\n

                          H\u00e0m SUMIF \/ SUMIFS<\/h3>\n\n\n\n

                          H\u00e0m SUMIF v\u00e0 SUMIFS t\u00ednh t\u1ed5ng c\u00e1c gi\u00e1 tr\u1ecb d\u1ef1a tr\u00ean m\u1ed9t ho\u1eb7c nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n c\u1ee5 th\u1ec3. SUMIF d\u00f9ng cho m\u1ed9t \u0111i\u1ec1u ki\u1ec7n, trong khi SUMIFS h\u1ed7 tr\u1ee3 nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n, r\u1ea5t h\u1eefu \u00edch trong vi\u1ec7c ph\u00e2n t\u00edch d\u1eef li\u1ec7u c\u00f3 \u0111i\u1ec1u ki\u1ec7n, v\u00ed d\u1ee5 nh\u01b0 t\u1ed5ng doanh thu theo khu v\u1ef1c, s\u1ea3n ph\u1ea9m ho\u1eb7c th\u1eddi gian.<\/p>\n\n\n\n

                            \n
                          • C\u00fa ph\u00e1p: =SUMIF(range, criteria, [sum_range]) ho\u1eb7c =SUMIFS(sum_range, criteria_range1, criteria1, [criteria_range2, criteria2], …)<\/li>\n\n\n\n
                          • V\u00ed d\u1ee5:<\/li>\n\n\n\n
                          • \u0110\u1ec3 t\u00ednh t\u1ed5ng doanh thu cho s\u1ea3n ph\u1ea9m “S\u1ea3n ph\u1ea9m X” trong ph\u1ea1m vi \u00f4 A1 v\u00e0 doanh thu t\u01b0\u01a1ng \u1ee9ng trong B1:B10: =SUMIF(A1:A10, “S\u1ea3n ph\u1ea9m X”, B1:B10)<\/li>\n\n\n\n
                          • \u0110\u1ec3 t\u00ednh t\u1ed5ng doanh thu cho “S\u1ea3n ph\u1ea9m X” trong n\u0103m 2024, v\u1edbi \u0111i\u1ec1u ki\u1ec7n n\u0103m \u0111\u01b0\u1ee3c l\u01b0u trong c\u1ed9t C: =SUMIFS(B1:B10, A1:A10, “S\u1ea3n ph\u1ea9m X”, C1:C10, “2024”)<\/li>\n<\/ul>\n\n\n\n

                            H\u00e0m TEXT<\/h3>\n\n\n\n

                            H\u00e0m TEXT chuy\u1ec3n \u0111\u1ed5i gi\u00e1 tr\u1ecb s\u1ed1 ho\u1eb7c ng\u00e0y th\u00e1ng th\u00e0nh chu\u1ed7i v\u0103n b\u1ea3n v\u1edbi \u0111\u1ecbnh d\u1ea1ng c\u1ee5 th\u1ec3, gi\u00fap b\u1ea1n \u0111\u1ecbnh d\u1ea1ng d\u1eef li\u1ec7u s\u1ed1 ho\u1eb7c ng\u00e0y th\u00e1ng theo y\u00eau c\u1ea7u.<\/p>\n\n\n\n

                              \n
                            • C\u00fa ph\u00e1p: =TEXT(value, format_text)<\/li>\n\n\n\n
                            • V\u00ed d\u1ee5: \u0110\u1ec3 \u0111\u1ecbnh d\u1ea1ng s\u1ed1 ti\u1ec1n trong \u00f4 A1 theo h\u00ecnh th\u1ee9c ti\u1ec1n t\u1ec7: =TEXT(A1, “$#,##0.00”)<\/li>\n\n\n\n
                            • H\u00e0m TEXT s\u1ebd chuy\u1ec3n \u0111\u1ed5i s\u1ed1 th\u00e0nh chu\u1ed7i v\u0103n b\u1ea3n v\u1edbi \u0111\u1ecbnh d\u1ea1ng ti\u1ec1n t\u1ec7, gi\u00fap b\u1ea1n tr\u00ecnh b\u00e0y th\u00f4ng tin t\u00e0i ch\u00ednh m\u1ed9t c\u00e1ch r\u00f5 r\u00e0ng v\u00e0 chuy\u00ean nghi\u1ec7p.<\/li>\n<\/ul>\n\n\n\n

                              H\u00e0m NOW<\/h3>\n\n\n\n

                              H\u00e0m NOW h\u1eefu \u00edch trong nh\u1eefng tr\u01b0\u1eddng h\u1ee3p c\u1ea7n th\u00eam ng\u00e0y v\u00e0o b\u1ea3ng t\u00ednh Excel hi\u1ec7n t\u1ea1i ho\u1eb7c t\u00ednh gi\u00e1 tr\u1ecb d\u1ef1a tr\u00ean ng\u00e0y v\u00e0 gi\u1edd hi\u1ec7n t\u1ea1i v\u00e0 c\u1eadp nh\u1eadt th\u00f4ng tin \u0111\u00f3 m\u1ed7i l\u1ea7n s\u1eed d\u1ee5ng b\u1ea3ng t\u00ednh.<\/p>\n\n\n\n

                                \n
                              • C\u00fa ph\u00e1p:=NOW()<\/li>\n\n\n\n
                              • V\u00ed d\u1ee5: =NOW() : \u0111\u1ebfn ng\u00e0y v\u00e0 th\u1eddi gian hi\u1ec7n t\u1ea1i tr\u00ean h\u1ec7 th\u1ed1ng c\u1ee7a b\u1ea1n.<\/li>\n<\/ul>\n\n\n\n

                                               =NOW()+7: \u0111\u1ebfn ng\u00e0y v\u00e0 th\u1eddi gian 7 ng\u00e0y trong t\u01b0\u01a1ng lai<\/p>\n\n\n\n

                                Hi\u1ec3u v\u00e0 s\u1eed d\u1ee5ng \u0111\u00fang c\u00e1c h\u00e0m trong Excel<\/strong> l\u00e0 m\u1ed9t k\u1ef9 n\u0103ng thi\u1ebft y\u1ebfu cho d\u00e2n v\u0103n ph\u00f2ng, gi\u00fap b\u1ea1n th\u1ef1c hi\u1ec7n c\u00e1c ph\u00e9p to\u00e1n c\u0169ng nh\u01b0 ph\u00e2n t\u00edch d\u1eef li\u1ec7u, ti\u1ebft ki\u1ec7m th\u1eddi gian v\u00e0 c\u1ea3i thi\u1ec7n kh\u1ea3 n\u0103ng l\u00e0m vi\u1ec7c v\u1edbi b\u1ea3ng t\u00ednh. Hy v\u1ecdng b\u00e0i vi\u1ebft h\u00f4m nay \u0111\u00e3 gi\u00fap b\u1ea1n n\u1eafm v\u1eefng c\u00e1c h\u00e0m c\u01a1 b\u1ea3n trong Excel v\u00e0 c\u00f3 th\u1ec3 \u00e1p d\u1ee5ng ch\u00fang v\u00e0o c\u00f4ng vi\u1ec7c m\u1ed9t c\u00e1ch hi\u1ec7u qu\u1ea3.<\/p>\n\n\n\n

                                Trang \u0110o\u00e0n<\/strong><\/p>\n","protected":false},"excerpt":{"rendered":"

                                Excel l\u00e0 m\u1ed9t c\u00f4ng c\u1ee5 c\u1ef1c k\u1ef3 hi\u1ec7u qu\u1ea3 trong m\u00f4i tr\u01b0\u1eddng l\u00e0m vi\u1ec7c v\u0103n ph\u00f2ng v\u1edbi kh\u1ea3 n\u0103ng x\u1eed l\u00fd d\u1eef li\u1ec7u v\u00e0 ph\u00e2n …<\/p>\n","protected":false},"author":58,"featured_media":7629,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[15],"tags":[],"class_list":["post-7626","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-goc-ky-nang"],"_links":{"self":[{"href":"https:\/\/mb668s.com\/cam-nang-7mb66-xoc-dia\/wp-json\/wp\/v2\/posts\/7626","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/mb668s.com\/cam-nang-7mb66-xoc-dia\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/mb668s.com\/cam-nang-7mb66-xoc-dia\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/mb668s.com\/cam-nang-7mb66-xoc-dia\/wp-json\/wp\/v2\/users\/58"}],"replies":[{"embeddable":true,"href":"https:\/\/mb668s.com\/cam-nang-7mb66-xoc-dia\/wp-json\/wp\/v2\/comments?post=7626"}],"version-history":[{"count":1,"href":"https:\/\/mb668s.com\/cam-nang-7mb66-xoc-dia\/wp-json\/wp\/v2\/posts\/7626\/revisions"}],"predecessor-version":[{"id":7630,"href":"https:\/\/mb668s.com\/cam-nang-7mb66-xoc-dia\/wp-json\/wp\/v2\/posts\/7626\/revisions\/7630"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/mb668s.com\/cam-nang-7mb66-xoc-dia\/wp-json\/wp\/v2\/media\/7629"}],"wp:attachment":[{"href":"https:\/\/mb668s.com\/cam-nang-7mb66-xoc-dia\/wp-json\/wp\/v2\/media?parent=7626"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/mb668s.com\/cam-nang-7mb66-xoc-dia\/wp-json\/wp\/v2\/categories?post=7626"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/mb668s.com\/cam-nang-7mb66-xoc-dia\/wp-json\/wp\/v2\/tags?post=7626"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}