{"id":5282,"date":"2025-11-24T19:34:18","date_gmt":"2025-11-24T12:34:18","guid":{"rendered":"https:\/\/autofillform.com\/blog\/7-cach-danh-so-thu-tu-tu-dong-trong-excel-cuc-don-gian\/"},"modified":"2025-11-24T19:34:18","modified_gmt":"2025-11-24T12:34:18","slug":"7-cach-danh-so-thu-tu-tu-dong-trong-excel-cuc-don-gian","status":"publish","type":"post","link":"https:\/\/autofillform.com\/blog\/7-cach-danh-so-thu-tu-tu-dong-trong-excel-cuc-don-gian\/","title":{"rendered":"7 C\u00e1ch \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 t\u1ef1 \u0111\u1ed9ng trong Excel c\u1ef1c \u0111\u01a1n gi\u1ea3n"},"content":{"rendered":"
\n

Thay v\u00ec \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 th\u1ee7 c\u00f4ng cho t\u1eebng d\u00f2ng d\u1eef li\u1ec7u, b\u1ea1n ho\u00e0n to\u00e0n c\u00f3 th\u1ec3 \u0111\u1ec3 Excel t\u1ef1 \u0111\u1ed9ng t\u1ea1o d\u00e3y s\u1ed1 ch\u1ec9 v\u1edbi v\u00e0i thao t\u00e1c \u0111\u01a1n gi\u1ea3n. Vi\u1ec7c t\u1eadn d\u1ee5ng c\u00e1c c\u00f4ng c\u1ee5 v\u00e0 h\u00e0m c\u00f3 s\u1eb5n gi\u00fap b\u1ea3ng t\u00ednh g\u1ecdn g\u00e0ng h\u01a1n, ti\u1ebft ki\u1ec7m th\u1eddi gian v\u00e0 h\u1ea1n ch\u1ebf sai s\u00f3t khi x\u1eed l\u00fd nhi\u1ec1u d\u00f2ng d\u1eef li\u1ec7u. B\u00e0i vi\u1ebft d\u01b0\u1edbi \u0111\u00e2y t\u1ed5ng h\u1ee3p nh\u1eefng c\u00e1ch \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 t\u1ef1 \u0111\u1ed9ng hi\u1ec7u qu\u1ea3 nh\u1ea5t m\u00e0 b\u1ea1n c\u00f3 th\u1ec3 \u00e1p d\u1ee5ng ngay.<\/p>\n

\"C\u00e1chT\u1ed5ng h\u1ee3p c\u00e1c c\u00e1ch \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 trong Excel<\/em><\/p>\n

\n

1. C\u00e1ch \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 trong Excel b\u1eb1ng c\u00e1ch k\u00e9o chu\u1ed9t<\/h2>\n<\/div>\n

B\u01b0\u1edbc 1:<\/strong> Nh\u1eadp hai s\u1ed1 li\u00ean ti\u1ebfp v\u00e0o hai \u00f4 li\u1ec1n k\u1ec1 trong v\u00f9ng b\u1ea1n mu\u1ed1n t\u1ea1o s\u1ed1 th\u1ee9 t\u1ef1 t\u1ef1 \u0111\u1ed9ng.<\/p>\n

V\u00ed d\u1ee5: <\/strong>\u0110\u1ec3 t\u1ea1o c\u1ed9t STT, b\u1ea1n nh\u1eadp 1 v\u00e0o \u00f4 A2 v\u00e0 2 v\u00e0o \u00f4 A3. Hai s\u1ed1 n\u00e0y gi\u00fap Excel nh\u1eadn bi\u1ebft quy lu\u1eadt t\u0103ng d\u1ea7n.<\/p>\n

\"\u0110\u00e1nhNh\u1eadp hai s\u1ed1 \u0111\u1ea7u ti\u00ean \u0111\u1ec3 t\u1ea1o d\u00e3y s\u1ed1 t\u1ef1 \u0111\u1ed9ng<\/em><\/p>\n

B\u01b0\u1edbc 2:<\/strong> Ch\u1ecdn c\u1ea3 hai \u00f4 A2 v\u00e0 A3, r\u1ed3i \u0111\u01b0a chu\u1ed9t \u0111\u1ebfn g\u00f3c d\u01b0\u1edbi b\u00ean ph\u1ea3i c\u1ee7a \u00f4 A3 cho \u0111\u1ebfn khi hi\u1ec7n d\u1ea5u c\u1ed9ng. Nh\u1ea5n gi\u1eef v\u00e0 k\u00e9o xu\u1ed1ng to\u00e0n b\u1ed9 ph\u1ea1m vi c\u1ea7n \u0111\u00e1nh s\u1ed1.<\/p>\n

\"K\u00e9oK\u00e9o ch\u1ed1t \u0111i\u1ec1n \u0111\u1ec3 m\u1edf r\u1ed9ng s\u1ed1 th\u1ee9 t\u1ef1 trong c\u1ed9t<\/em><\/p>\n

\n

2. C\u00e1ch s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c \u0111\u1ec3 \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 trong Excel<\/h2>\n<\/div>\n

B\u01b0\u1edbc 1:<\/strong> Nh\u1eadp s\u1ed1 th\u1ee9 t\u1ef1 b\u1eaft \u0111\u1ea7u v\u00e0o \u00f4 \u0111\u1ea7u ti\u00ean c\u1ee7a h\u00e0ng ho\u1eb7c c\u1ed9t c\u1ea7n t\u1ea1o d\u00e3y. \u1ede \u00f4 k\u1ebf ti\u1ebfp, nh\u1eadp c\u00f4ng th\u1ee9c: = “\u00f4 ch\u1ee9a s\u1ed1 b\u1eaft \u0111\u1ea7u” + x<\/p>\n

Trong \u0111\u00f3 x l\u00e0 kho\u1ea3ng t\u0103ng gi\u1eefa hai s\u1ed1 li\u00ean ti\u1ebfp.<\/p>\n

V\u00ed d\u1ee5:<\/strong> N\u1ebfu b\u1eaft \u0111\u1ea7u t\u1eeb 1 v\u00e0 mu\u1ed1n t\u1ea1o d\u00e3y 1, 2, 3\u2026, b\u1ea1n \u0111\u1eb7t x = 1. N\u1ebfu mu\u1ed1n d\u00e3y 1, 3, 5\u2026, h\u00e3y \u0111\u1eb7t x = 2.<\/p>\n

\"Nh\u1eadp\u200b\u200bNh\u1eadp c\u00f4ng th\u1ee9c A2+1 \u0111\u1ec3 t\u1ea1o s\u1ed1 k\u1ebf ti\u1ebfp<\/em><\/p>\n

B\u01b0\u1edbc 2:<\/strong> Sau khi nh\u1eadp c\u00f4ng th\u1ee9c v\u00e0 nh\u1ea5n Enter, h\u00e3y \u0111\u01b0a chu\u1ed9t \u0111\u1ebfn g\u00f3c d\u01b0\u1edbi b\u00ean ph\u1ea3i c\u1ee7a \u00f4 ch\u1ee9a c\u00f4ng th\u1ee9c \u0111\u1ec3 xu\u1ea5t hi\u1ec7n d\u1ea5u c\u1ed9ng. Gi\u1eef v\u00e0 k\u00e9o xu\u1ed1ng (ho\u1eb7c k\u00e9o sang ph\u1ea3i) \u0111\u1ebfn h\u1ebft v\u00f9ng c\u1ea7n \u0111\u00e1nh s\u1ed1.<\/p>\n

\"K\u00e9oK\u00e9o c\u00f4ng th\u1ee9c xu\u1ed1ng \u0111\u1ec3 ho\u00e0n th\u00e0nh d\u00e3y s\u1ed1<\/em><\/p>\n

Xem th\u00eam: <\/strong>H\u01b0\u1edbng d\u1eabn c\u00e1ch t\u1ef1 \u0111i\u1ec1u ch\u1ec9nh \u0111\u1ed9 r\u1ed9ng \u00f4 trong Excel d\u1ec5 hi\u1ec3u<\/div>\n
\n

3. C\u00e1ch \u00e1p d\u1ee5ng h\u00e0m SEQUENCE \u0111\u1ec3 \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1<\/h2>\n<\/div>\n

B\u01b0\u1edbc 1:<\/strong> Ch\u1ecdn \u00f4 \u0111\u1ea7u ti\u00ean trong v\u00f9ng m\u00e0 b\u1ea1n mu\u1ed1n t\u1ea1o d\u00e3y s\u1ed1 th\u1ee9 t\u1ef1.<\/p>\n

B\u01b0\u1edbc 2: <\/strong>Nh\u1eadp c\u00f4ng th\u1ee9c: =SEQUENCE(s\u1ed1_h\u00e0ng_c\u1ea7n_t\u1ea1o)<\/p>\n

B\u01b0\u1edbc 3:<\/strong> Nh\u1ea5n Enter <\/strong>\u0111\u1ec3 Excel t\u1ef1 \u0111\u1ed9ng t\u1ea1o d\u00e3y s\u1ed1 theo s\u1ed1 l\u01b0\u1ee3ng h\u00e0ng b\u1ea1n \u0111\u00e3 ch\u1ec9 \u0111\u1ecbnh.<\/p>\n

\"S\u1eedT\u1ea1o d\u00e3y s\u1ed1 nhanh b\u1eb1ng h\u00e0m SEQUENCE<\/em><\/p>\n

\n

4. S\u1eed d\u1ee5ng Auto fill \u0111\u1ec3 \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1<\/h2>\n<\/div>\n

B\u01b0\u1edbc 1: <\/strong>Nh\u1eadp s\u1ed1 b\u1eaft \u0111\u1ea7u v\u00e0o \u00f4 \u0111\u1ea7u ti\u00ean, sau \u0111\u00f3 v\u00e0o th\u1ebb Home \u2192 Ch\u1ecdn Fill \u2192 Series.<\/p>\n

(V\u1edbi Excel phi\u00ean b\u1ea3n c\u0169 tr\u01b0\u1edbc 2016, thao t\u00e1c n\u1eb1m trong Editing \u2192 Fill \u2192 Series.)<\/p>\n

\"V\u00e0oM\u1edf c\u00f4ng c\u1ee5 Series t\u1eeb th\u1ebb Home<\/em><\/p>\n

Khi h\u1ed9p tho\u1ea1i Series m\u1edf ra, thi\u1ebft l\u1eadp c\u00e1c th\u00f4ng tin sau:<\/p>\n

    \n
  • Series in:<\/strong> X\u00e1c \u0111\u1ecbnh d\u00e3y s\u1ed1 ch\u1ea1y theo h\u00e0ng (Rows) ho\u1eb7c c\u1ed9t (Columns).<\/li>\n
  • Type:<\/strong> L\u1ef1a ch\u1ecdn ki\u1ec3u t\u1ea1o d\u00e3y ph\u00f9 h\u1ee3p:<\/li>\n
  • Linear:<\/strong> T\u0103ng \u0111\u1ec1u theo b\u01b0\u1edbc nh\u1ea3y.<\/li>\n
  • Growth:<\/strong> T\u1ea1o d\u00e3y theo c\u1ea5p s\u1ed1 nh\u00e2n.<\/li>\n
  • Date:<\/strong> T\u1ea1o d\u00e3y theo ng\u00e0y th\u00e1ng (hi\u1ec3n th\u1ecb th\u00eam m\u1ee5c Date Unit).<\/li>\n
  • AutoFill:<\/strong> Excel t\u1ef1 nh\u1eadn di\u1ec7n quy lu\u1eadt.<\/li>\n
  • Step value:<\/strong> Nh\u1eadp kho\u1ea3ng t\u0103ng gi\u1eefa hai gi\u00e1 tr\u1ecb.<\/li>\n
  • Stop value:<\/strong> Ghi gi\u00e1 tr\u1ecb cu\u1ed1i c\u00f9ng c\u1ee7a d\u00e3y.<\/li>\n<\/ul>\n

    B\u01b0\u1edbc 2: <\/strong>Nh\u1ea5n OK \u0111\u1ec3 Excel t\u1ea1o d\u00e3y s\u1ed1 theo c\u1ea5u h\u00ecnh b\u1ea1n \u0111\u00e3 thi\u1ebft l\u1eadp.<\/p>\n

    \"T\u1ef1Excel t\u1ef1 \u0111i\u1ec1n d\u00e3y s\u1ed1 sau khi thi\u1ebft l\u1eadp Series<\/em><\/p>\n

    \n

    5. S\u1eed d\u1ee5ng h\u00e0m SUBTOTAL l\u1ed3ng v\u1edbi IF<\/h2>\n<\/div>\n

    C\u00fa ph\u00e1p s\u1eed d\u1ee5ng:<\/strong>=IF(logical_test, value_if_true, value_if_false, SUBTOTAL(function_num, ref1,…))<\/strong><\/p>\n

    Gi\u1ea3i th\u00edch:<\/strong><\/p>\n

      \n
    • logical_test:<\/strong> \u0110i\u1ec1u ki\u1ec7n ki\u1ec3m tra trong h\u00e0m IF.<\/li>\n
    • value_if_true:<\/strong> Gi\u00e1 tr\u1ecb tr\u1ea3 v\u1ec1 khi \u0111i\u1ec1u ki\u1ec7n \u0111\u00fang.<\/li>\n
    • value_if_false:<\/strong> Gi\u00e1 tr\u1ecb tr\u1ea3 v\u1ec1 khi \u0111i\u1ec1u ki\u1ec7n sai.<\/li>\n
    • function_num:<\/strong> M\u00e3 l\u1ec7nh t\u01b0\u01a1ng \u1ee9ng v\u1edbi lo\u1ea1i ph\u00e9p t\u00ednh trong SUBTOTAL (v\u00ed d\u1ee5: s\u1ed1 3 \u0111\u1ea1i di\u1ec7n cho COUNTA – \u0111\u1ebfm c\u00e1c \u00f4 kh\u00f4ng tr\u1ed1ng).<\/li>\n
    • ref1,…:<\/strong> V\u00f9ng d\u1eef li\u1ec7u c\u1ea7n t\u00ednh.<\/li>\n<\/ul>\n

      V\u00ed d\u1ee5:<\/strong> Gi\u1ea3 s\u1eed b\u1ea1n c\u00f3 m\u1ed9t b\u1ea3ng danh s\u00e1ch trong \u0111\u00f3 c\u00f3 nh\u1eefng h\u00e0ng \u0111\u1ec3 tr\u1ed1ng. B\u1ea1n c\u1ea7n \u0111\u00e1nh l\u1ea1i s\u1ed1 th\u1ee9 t\u1ef1 cho c\u00e1c m\u1eb7t h\u00e0ng c\u00f3 d\u1eef li\u1ec7u, b\u1ecf qua nh\u1eefng d\u00f2ng r\u1ed7ng.<\/p>\n

      B\u01b0\u1edbc 1:<\/strong> T\u1ea1i \u00f4 c\u1ea7n \u0111\u00e1nh s\u1ed1, nh\u1eadp c\u00f4ng th\u1ee9c: =IF(B2=””,””,SUBTOTAL(3,$B$2:B2))<\/strong><\/p>\n

      Gi\u1ea3i th\u00edch c\u00e1ch ho\u1ea1t \u0111\u1ed9ng<\/strong><\/p>\n

      SUBTOTAL(3, $B$2:B2):<\/strong><\/p>\n

        \n
      • S\u1ed1 3 bi\u1ec3u th\u1ecb ch\u1ee9c n\u0103ng COUNTA \u2013 d\u00f9ng \u0111\u1ec3 \u0111\u1ebfm s\u1ed1 \u00f4 c\u00f3 n\u1ed9i dung.<\/li>\n
      • V\u00f9ng $B$2:B2 l\u00e0 ph\u1ea1m vi \u0111\u1ebfm; \u00f4 B2 \u0111\u01b0\u1ee3c c\u1ed1 \u0111\u1ecbnh \u0111\u1ec3 \u0111\u1ea3m b\u1ea3o c\u00f4ng th\u1ee9c ho\u1ea1t \u0111\u1ed9ng ch\u00ednh x\u00e1c khi sao ch\u00e9p xu\u1ed1ng.<\/li>\n<\/ul>\n

        IF(B2=””,””, … ):<\/strong><\/p>\n

          \n
        • N\u1ebfu \u00f4 B2 tr\u1ed1ng \u2192 Tr\u1ea3 v\u1ec1 r\u1ed7ng, kh\u00f4ng hi\u1ec3n th\u1ecb s\u1ed1 th\u1ee9 t\u1ef1.<\/li>\n
        • N\u1ebfu \u00f4 B2 c\u00f3 d\u1eef li\u1ec7u \u2192 Th\u1ef1c hi\u1ec7n SUBTOTAL \u0111\u1ec3 t\u1ea1o s\u1ed1 th\u1ee9 t\u1ef1 theo s\u1ed1 l\u01b0\u1ee3ng d\u00f2ng c\u00f3 d\u1eef li\u1ec7u t\u00ednh t\u1eeb B2 tr\u1edf \u0111i.<\/li>\n<\/ul>\n

          \"T\u1ea1oT\u1ea1o s\u1ed1 th\u1ee9 t\u1ef1 c\u00f3 \u0111i\u1ec1u ki\u1ec7n b\u1eb1ng h\u00e0m IF v\u00e0 SUBTOTAL<\/em><\/p>\n

          B\u01b0\u1edbc 2:<\/strong> Nh\u1ea5n Enter \u0111\u1ec3 th\u1ef1c hi\u1ec7n c\u00fa ph\u00e1p. Sau \u0111\u00f3, \u0111\u01b0a chu\u1ed9t v\u00e0o g\u00f3c d\u01b0\u1edbi b\u00ean ph\u1ea3i \u00f4 v\u1eeba nh\u1eadp c\u00f4ng th\u1ee9c, khi xu\u1ea5t hi\u1ec7n d\u1ea5u c\u1ed9ng, k\u00e9o xu\u1ed1ng h\u1ebft ph\u1ea1m vi c\u1ea7n t\u1ea1o s\u1ed1 th\u1ee9 t\u1ef1. Excel s\u1ebd t\u1ef1 \u0111i\u1ec1n s\u1ed1 cho c\u00e1c d\u00f2ng c\u00f3 d\u1eef li\u1ec7u v\u00e0 b\u1ecf qua d\u00f2ng tr\u1ed1ng.<\/p>\n

          \n

          6. \u0110\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 s\u1eed d\u1ee5ng h\u00e0m ROW()-1<\/h2>\n<\/div>\n

          B\u01b0\u1edbc 1:<\/strong> Nh\u1eadp c\u00f4ng th\u1ee9c =ROW()-x<\/strong> v\u00e0o \u00f4 b\u1eaft \u0111\u1ea7u, trong \u0111\u00f3 x l\u00e0 s\u1ed1 c\u1ea7n tr\u1eeb \u0111\u1ec3 t\u1ea1o s\u1ed1 th\u1ee9 t\u1ef1 \u0111\u00fang.<\/p>\n

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

            \n
          • \u1ede h\u00e0ng 2 mu\u1ed1n b\u1eaft \u0111\u1ea7u t\u1eeb 1 \u2192 =ROW()-1<\/strong><\/li>\n
          • \u1ede h\u00e0ng 3 mu\u1ed1n b\u1eaft \u0111\u1ea7u t\u1eeb 1 \u2192 =ROW()-2<\/strong><\/li>\n<\/ul>\n

            \"Nh\u1eadpNh\u1eadp c\u00f4ng th\u1ee9c ROW()-1 \u0111\u1ec3 \u0111\u00e1nh s\u1ed1 theo h\u00e0ng<\/p>\n

            B\u01b0\u1edbc 2:<\/strong> \u0110\u01b0a chu\u1ed9t v\u00e0o g\u00f3c d\u01b0\u1edbi b\u00ean ph\u1ea3i \u00f4 v\u1eeba nh\u1eadp c\u00f4ng th\u1ee9c v\u00e0 k\u00e9o xu\u1ed1ng to\u00e0n b\u1ed9 v\u00f9ng c\u1ea7n \u0111\u00e1nh s\u1ed1.<\/p>\n

            \"K\u00e9oK\u00e9o c\u00f4ng th\u1ee9c ROW()-1 \u0111\u1ec3 t\u1ea1o d\u00e3y s\u1ed1 ho\u00e0n ch\u1ec9nh<\/em><\/p>\n

            \n

            7. Nh\u1eefng l\u01b0u \u00fd quan tr\u1ecdng khi \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 trong Excel<\/h2>\n<\/div>\n

            \u0110\u1ec3 thao t\u00e1c \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 ch\u00ednh x\u00e1c v\u00e0 thu\u1eadn ti\u1ec7n h\u01a1n, d\u01b0\u1edbi \u0111\u00e2y l\u00e0 m\u1ed9t s\u1ed1 l\u01b0u \u00fd quan tr\u1ecdng m\u00e0 b\u1ea1n n\u00ean n\u1eafm tr\u01b0\u1edbc khi th\u1ef1c hi\u1ec7n:<\/p>\n

              \n
            • Khi l\u00e0m vi\u1ec7c v\u1edbi b\u1ea3ng d\u1eef li\u1ec7u l\u1edbn (v\u00e0i tr\u0103m \u0111\u1ebfn h\u00e0ng ngh\u00ecn d\u00f2ng), vi\u1ec7c k\u00e9o chu\u1ed9t \u0111\u1ec3 t\u1ea1o s\u1ed1 th\u1ee9 t\u1ef1 b\u1eb1ng AutoFill c\u00f3 th\u1ec3 m\u1ea5t th\u1eddi gian v\u00e0 d\u00e3y s\u1ed1 s\u1ebd kh\u00f4ng t\u1ef1 c\u1eadp nh\u1eadt n\u1ebfu b\u1ea1n x\u00f3a ho\u1eb7c ch\u00e8n th\u00eam d\u00f2ng.<\/li>\n
            • C\u00e1c h\u00e0m t\u1ea1o s\u1ed1 th\u1ee9 t\u1ef1 t\u1ef1 \u0111\u1ed9ng (nh\u01b0 SEQUENCE) gi\u00fap thao t\u00e1c nhanh h\u01a1n, nh\u01b0ng ch\u1ec9 c\u00f3 m\u1eb7t tr\u00ean Excel 365 v\u00e0 Excel 2021. N\u1ebfu b\u1ea1n d\u00f9ng phi\u00ean b\u1ea3n c\u0169, h\u00e0m n\u00e0y s\u1ebd kh\u00f4ng ho\u1ea1t \u0111\u1ed9ng.<\/li>\n
            • V\u1edbi nh\u1eefng ph\u01b0\u01a1ng ph\u00e1p d\u00f9ng c\u00f4ng th\u1ee9c, b\u1ea1n n\u00ean c\u1ed1 \u0111\u1ecbnh \u00f4 tham chi\u1ebfu ho\u1eb7c ki\u1ec3m tra k\u1ef9 v\u00f9ng d\u1eef li\u1ec7u \u0111\u1ec3 tr\u00e1nh sai s\u1ed1 khi sao ch\u00e9p xu\u1ed1ng c\u00e1c d\u00f2ng ti\u1ebfp theo.<\/li>\n
            • D\u00f9 \u00e1p d\u1ee5ng c\u00e1ch n\u00e0o, t\u1ea1o s\u1ed1 th\u1ee9 t\u1ef1 b\u1eb1ng c\u00f4ng c\u1ee5 ho\u1eb7c h\u00e0m c\u1ee7a Excel v\u1eabn hi\u1ec7u qu\u1ea3 h\u01a1n nhi\u1ec1u so v\u1edbi vi\u1ec7c nh\u1eadp th\u1ee7 c\u00f4ng t\u1eebng gi\u00e1 tr\u1ecb.<\/li>\n<\/ul>\n

              Vi\u1ec7c \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 trong Excel tr\u1edf n\u00ean \u0111\u01a1n gi\u1ea3n h\u01a1n r\u1ea5t nhi\u1ec1u khi b\u1ea1n bi\u1ebft c\u00e1ch t\u1eadn d\u1ee5ng c\u00e1c c\u00f4ng c\u1ee5 v\u00e0 h\u00e0m c\u00f3 s\u1eb5n. T\u00f9y v\u00e0o phi\u00ean b\u1ea3n Excel \u0111ang d\u00f9ng v\u00e0 \u0111\u1ed9 ph\u1ee9c t\u1ea1p c\u1ee7a b\u1ea3ng d\u1eef li\u1ec7u, b\u1ea1n c\u00f3 th\u1ec3 ch\u1ecdn ph\u01b0\u01a1ng ph\u00e1p ph\u00f9 h\u1ee3p nh\u1ea5t cho nhu c\u1ea7u c\u1ee7a m\u00ecnh. H\u00e3y \u00e1p d\u1ee5ng linh ho\u1ea1t \u0111\u1ec3 t\u0103ng t\u1ed1c \u0111\u1ed9 x\u1eed l\u00fd v\u00e0 gi\u1eef cho b\u1ea3ng t\u00ednh lu\u00f4n g\u1ecdn g\u00e0ng, d\u1ec5 theo d\u00f5i.<\/p>\n

              \u0110\u1eebng qu\u00ean theo d\u00f5i chuy\u00ean m\u1ee5c Kinh nghi\u1ec7m c\u1ee7a Si\u00eau Th\u1ecb \u0110i\u1ec7n M\u00e1y – N\u1ed9i Th\u1ea5t Ch\u1ee3 L\u1edbn \u0111\u1ec3 c\u1eadp nh\u1eadt th\u00eam nhi\u1ec1u h\u01b0\u1edbng d\u1eabn hay m\u1ed7i ng\u00e0y.<\/p>\n

              N\u1ebfu b\u1ea1n th\u01b0\u1eddng xuy\u00ean l\u00e0m vi\u1ec7c v\u1edbi Excel, m\u1ed9t chi\u1ebfc m\u00e1y t\u00ednh b\u1ea3ng c\u1ea5u h\u00ecnh m\u1ea1nh s\u1ebd gi\u00fap thao t\u00e1c nhanh v\u00e0 ti\u1ec7n l\u1ee3i h\u01a1n khi di chuy\u1ec3n. Tham kh\u1ea3o c\u00e1c m\u1eabu tablet m\u1edbi t\u1ea1i Si\u00eau Th\u1ecb \u0110i\u1ec7n M\u00e1y – N\u1ed9i Th\u1ea5t Ch\u1ee3 L\u1edbn \u0111\u1ec3 ch\u1ecdn thi\u1ebft b\u1ecb ph\u00f9 h\u1ee3p cho c\u00f4ng vi\u1ec7c v\u00e0 h\u1ecdc t\u1eadp.<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"

              Thay v\u00ec \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 th\u1ee7 c\u00f4ng cho t\u1eebng d\u00f2ng d\u1eef li\u1ec7u, b\u1ea1n ho\u00e0n to\u00e0n c\u00f3 th\u1ec3 \u0111\u1ec3 Excel t\u1ef1 \u0111\u1ed9ng t\u1ea1o d\u00e3y s\u1ed1 ch\u1ec9 v\u1edbi v\u00e0i thao t\u00e1c \u0111\u01a1n gi\u1ea3n. Vi\u1ec7c t\u1eadn d\u1ee5ng c\u00e1c c\u00f4ng c\u1ee5 v\u00e0 h\u00e0m c\u00f3 s\u1eb5n gi\u00fap b\u1ea3ng t\u00ednh g\u1ecdn g\u00e0ng h\u01a1n, ti\u1ebft ki\u1ec7m th\u1eddi gian v\u00e0 h\u1ea1n ch\u1ebf […]<\/p>\n","protected":false},"author":1,"featured_media":5283,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[8],"tags":[],"class_list":["post-5282","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-thu-thuat"],"jetpack_featured_media_url":"https:\/\/autofillform.com\/blog\/wp-content\/uploads\/2025\/11\/19453.jpg","_links":{"self":[{"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/posts\/5282","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/comments?post=5282"}],"version-history":[{"count":0,"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/posts\/5282\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/media\/5283"}],"wp:attachment":[{"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/media?parent=5282"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/categories?post=5282"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/tags?post=5282"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}