{"id":7710,"date":"2024-09-25T08:21:44","date_gmt":"2024-09-25T01:21:44","guid":{"rendered":"https:\/\/mb668s.com\/cam-nang-7mb66-xoc-dia\/?p=7710"},"modified":"2024-09-25T08:25:56","modified_gmt":"2024-09-25T01:25:56","slug":"cach-danh-so-thu-tu-trong-excel-nhanh-chong-chinh-xac","status":"publish","type":"post","link":"https:\/\/mb668s.com\/cam-nang-7mb66-xoc-dia\/goc-ky-nang\/cach-danh-so-thu-tu-trong-excel-nhanh-chong-chinh-xac","title":{"rendered":"7 c\u00e1ch \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 trong Excel nhanh ch\u00f3ng, ch\u00ednh x\u00e1c"},"content":{"rendered":"\n

M\u1ed9t trong nh\u1eefng thao t\u00e1c c\u01a1 b\u1ea3n nh\u1ea5t trong Excel l\u00e0 \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1, gi\u00fap d\u1eef li\u1ec7u tr\u1edf n\u00ean r\u00f5 r\u00e0ng v\u00e0 d\u1ec5 theo d\u00f5i h\u01a1n, \u0111\u1ed3ng th\u1eddi h\u1ec7 th\u1ed1ng h\u00f3a d\u1eef li\u1ec7u trong qu\u00e1 tr\u00ecnh ph\u00e2n t\u00edch. N\u1ebfu b\u1ea1n \u0111ang t\u00ecm hi\u1ec3u c\u00e1ch \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 trong Excel<\/strong> b\u1eb1ng nhi\u1ec1u ph\u01b0\u01a1ng ph\u00e1p kh\u00e1c nhau, t\u1eeb nh\u1eefng c\u00e1ch th\u1ee7 c\u00f4ng, \u0111\u01a1n gi\u1ea3n nh\u1ea5t cho \u0111\u1ebfn c\u00e1c ph\u01b0\u01a1ng ph\u00e1p n\u00e2ng cao c\u1ea7n s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c th\u00ec \u0111\u00e2y l\u00e0 b\u00e0i vi\u1ebft d\u00e0nh cho b\u1ea1n.<\/p>\n\n\n\n

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

\u201cC\u00e1c h\u01b0\u1edbng d\u1eabn sau s\u1ebd gi\u00fap b\u1ea1n bi\u1ebft c\u00e1ch \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 trong Excel ch\u1ec9 trong nh\u00e1y m\u1eaft\u201d.<\/strong><\/p>\n<\/blockquote>\n\n\n\n

C\u00e1ch \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 trong Excel b\u1eb1ng ph\u01b0\u01a1ng ph\u00e1p th\u1ee7 c\u00f4ng<\/h2>\n\n\n\n

\u0110\u00e2y l\u00e0 c\u00e1ch l\u00e0m \u0111\u01a1n gi\u1ea3n nh\u1ea5t v\u00e0 b\u1ea5t c\u1ee9 ai \u0111\u1ec1u c\u00f3 th\u1ec3 th\u1ef1c hi\u1ec7n \u0111\u01b0\u1ee3c. Ph\u01b0\u01a1ng ph\u00e1p n\u00e0y th\u01b0\u1eddng \u0111\u01b0\u1ee3c \u00e1p d\u1ee5ng khi ch\u1ec9 c\u1ea7n \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 cho m\u1ed9t t\u1eadp d\u1eef li\u1ec7u nh\u1ecf. C\u00e1c b\u01b0\u1edbc th\u1ef1c hi\u1ec7n nh\u01b0 sau:<\/p>\n\n\n\n

    \n
  • Nh\u1eadp s\u1ed1 \u0111\u1ea7u ti\u00ean v\u00e0o \u00f4 \u0111\u1ea7u ti\u00ean c\u1ee7a c\u1ed9t s\u1ed1 th\u1ee9 t\u1ef1 (v\u00ed d\u1ee5: nh\u1eadp s\u1ed1 1 v\u00e0o \u00f4 A2).<\/li>\n\n\n\n
  • Nh\u1eadp s\u1ed1 th\u1ee9 hai v\u00e0o \u00f4 k\u1ebf ti\u1ebfp (v\u00ed d\u1ee5 nh\u1eadp s\u1ed1 2 v\u00e0o \u00f4 A3).<\/li>\n\n\n\n
  • Ch\u1ecdn hai \u00f4 v\u1eeba nh\u1eadp s\u1ed1 (A2 v\u00e0 A3).<\/li>\n\n\n\n
  • \u0110\u1eb7t con tr\u1ecf chu\u1ed9t v\u00e0o g\u00f3c d\u01b0\u1edbi b\u00ean ph\u1ea3i c\u1ee7a v\u00f9ng ch\u1ecdn cho \u0111\u1ebfn khi con tr\u1ecf bi\u1ebfn th\u00e0nh d\u1ea5u c\u1ed9ng nh\u1ecf (c\u00f2n g\u1ecdi l\u00e0 “fill handle”).<\/li>\n\n\n\n
  • K\u00e9o th\u1ea3 chu\u1ed9t xu\u1ed1ng cho \u0111\u1ebfn khi \u0111\u1ea1t \u0111\u01b0\u1ee3c s\u1ed1 l\u01b0\u1ee3ng c\u1ea7n thi\u1ebft, Excel s\u1ebd t\u1ef1 \u0111\u1ed9ng \u0111i\u1ec1n c\u00e1c s\u1ed1 ti\u1ebfp theo theo th\u1ee9 t\u1ef1.<\/li>\n<\/ul>\n\n\n\n

    S\u1eed d\u1ee5ng ch\u1ee9c n\u0103ng t\u1ef1 \u0111\u1ed9ng \u0111i\u1ec1n (AutoFill)<\/h2>\n\n\n\n

    Excel c\u00f3 m\u1ed9t t\u00ednh n\u0103ng h\u1eefu \u00edch g\u1ecdi l\u00e0 AutoFill, cho ph\u00e9p b\u1ea1n \u0111i\u1ec1n d\u1eef li\u1ec7u theo chu\u1ed7i m\u1ed9t c\u00e1ch t\u1ef1 \u0111\u1ed9ng m\u00e0 kh\u00f4ng c\u1ea7n ph\u1ea3i nh\u1eadp tay t\u1eebng gi\u00e1 tr\u1ecb.<\/p>\n\n\n\n

    C\u00e1c b\u01b0\u1edbc th\u1ef1c hi\u1ec7n:<\/p>\n\n\n\n

      \n
    • Nh\u1eadp s\u1ed1 1 v\u00e0o \u00f4 \u0111\u1ea7u ti\u00ean c\u1ee7a c\u1ed9t s\u1ed1 th\u1ee9 t\u1ef1 (v\u00ed d\u1ee5 \u00f4 A2).<\/li>\n\n\n\n
    • Ch\u1ecdn \u00f4 A2, sau \u0111\u00f3 \u0111\u1eb7t con tr\u1ecf v\u00e0o g\u00f3c d\u01b0\u1edbi b\u00ean ph\u1ea3i c\u1ee7a \u00f4 (fill handle) cho \u0111\u1ebfn khi con tr\u1ecf bi\u1ebfn th\u00e0nh d\u1ea5u c\u1ed9ng nh\u1ecf.<\/li>\n\n\n\n
    • K\u00e9o th\u1ea3 chu\u1ed9t \u0111\u1ebfn \u00f4 cu\u1ed1i c\u00f9ng c\u1ee7a v\u00f9ng d\u1eef li\u1ec7u b\u1ea1n mu\u1ed1n \u0111\u00e1nh s\u1ed1.<\/li>\n\n\n\n
    • Sau khi k\u00e9o th\u1ea3, Excel s\u1ebd t\u1ef1 \u0111\u1ed9ng \u0111i\u1ec1n to\u00e0n b\u1ed9 c\u00e1c \u00f4 \u0111\u00e3 ch\u1ecdn b\u1eb1ng gi\u00e1 tr\u1ecb 1. \u0110\u1ec3 chuy\u1ec3n ch\u00fang th\u00e0nh c\u00e1c s\u1ed1 th\u1ee9 t\u1ef1 li\u00ean ti\u1ebfp, b\u1ea1n c\u1ea7n nh\u1ea5n v\u00e0o bi\u1ec3u t\u01b0\u1ee3ng AutoFill v\u00e0 ch\u1ecdn Fill Series (\u0111i\u1ec1n theo chu\u1ed7i).<\/li>\n<\/ul>\n\n\n\n

      Hai ph\u01b0\u01a1ng ph\u00e1p k\u1ec3 tr\u00ean tuy \u0111\u01a1n gi\u1ea3n, d\u1ec5 th\u1ef1c hi\u1ec7n nh\u01b0ng kh\u00f4ng qu\u00e1 hi\u1ec7u qu\u1ea3 khi b\u1ea1n ph\u1ea3i l\u00e0m vi\u1ec7c v\u1edbi nh\u1eefng t\u1eadp d\u1eef li\u1ec7u l\u1edbn. Khi \u0111\u00f3, b\u1ea1n c\u00f3 th\u1ec3 c\u00e2n nh\u1eafc s\u1eed d\u1ee5ng c\u00e1c ph\u01b0\u01a1ng ph\u00e1p d\u01b0\u1edbi \u0111\u00e2y.<\/p>\n\n\n\n

      C\u00e1ch \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 trong Excel b\u1eb1ng c\u00f4ng th\u1ee9c ROW<\/h2>\n\n\n\n

      N\u1ebfu b\u1ea1n c\u1ea7n h\u00e0m \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 trong Excel th\u00ec c\u00f3 th\u1ec3 th\u1ef1c hi\u1ec7n c\u00e1c b\u01b0\u1edbc sau:<\/p>\n\n\n\n

        \n
      • Trong \u00f4 \u0111\u1ea7u ti\u00ean (v\u00ed d\u1ee5 \u00f4 A2), b\u1ea1n nh\u1eadp c\u00f4ng th\u1ee9c: =ROW() – 1<\/li>\n\n\n\n
      • ROW() l\u00e0 h\u00e0m tr\u1ea3 v\u1ec1 s\u1ed1 h\u00e0ng c\u1ee7a \u00f4 hi\u1ec7n t\u1ea1i. V\u00ed d\u1ee5, n\u1ebfu \u00f4 \u0111ang \u1edf h\u00e0ng th\u1ee9 2, ROW() s\u1ebd tr\u1ea3 v\u1ec1 2.<\/li>\n\n\n\n
      • V\u00ec mu\u1ed1n \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 b\u1eaft \u0111\u1ea7u t\u1eeb 1, b\u1ea1n c\u1ea7n tr\u1eeb 1 \u0111\u1ec3 kh\u1edbp v\u1edbi s\u1ed1 h\u00e0ng \u0111\u1ea7u ti\u00ean.<\/li>\n\n\n\n
      • Khi b\u1ea1n \u0111\u00e3 nh\u1eadp c\u00f4ng th\u1ee9c v\u00e0o \u00f4 A2, h\u00e3y sao ch\u00e9p c\u00f4ng th\u1ee9c xu\u1ed1ng c\u00e1c \u00f4 c\u00f2n l\u1ea1i trong c\u1ed9t, Excel s\u1ebd t\u1ef1 \u0111\u1ed9ng \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 cho b\u1ea1n.<\/li>\n<\/ul>\n\n\n\n

        L\u01b0u \u00fd khi s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c ROW:<\/p>\n\n\n\n

          \n
        • H\u00e0m ROW() tr\u1ea3 v\u1ec1 s\u1ed1 h\u00e0ng tuy\u1ec7t \u0111\u1ed1i, v\u00ec v\u1eady n\u1ebfu b\u1ea1n x\u00f3a ho\u1eb7c th\u00eam c\u00e1c h\u00e0ng m\u1edbi ph\u00eda tr\u00ean, s\u1ed1 th\u1ee9 t\u1ef1 s\u1ebd thay \u0111\u1ed5i. N\u1ebfu b\u1ea1n mu\u1ed1n gi\u1eef nguy\u00ean s\u1ed1 th\u1ee9 t\u1ef1 b\u1ea5t k\u1ec3 c\u00f3 thay \u0111\u1ed5i g\u00ec, h\u00e3y sao ch\u00e9p v\u00e0 d\u00e1n gi\u00e1 tr\u1ecb (Paste Values) thay v\u00ec d\u00e1n c\u00f4ng th\u1ee9c.<\/li>\n<\/ul>\n\n\n\n

          \u0110\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 b\u1eb1ng h\u00e0m SEQUENCE<\/h2>\n\n\n\n

          Excel phi\u00ean b\u1ea3n 365 ho\u1eb7c Excel 2021 cung c\u1ea5p m\u1ed9t h\u00e0m s\u1ed1 th\u1ee9 t\u1ef1 trong Excel r\u1ea5t h\u1eefu \u00edch c\u00f3 t\u00ean l\u00e0 SEQUENCE, gi\u00fap b\u1ea1n t\u1ea1o m\u1ed9t chu\u1ed7i s\u1ed1 th\u1ee9 t\u1ef1 nhanh ch\u00f3ng.<\/p>\n\n\n\n

          C\u00e1c b\u01b0\u1edbc th\u1ef1c hi\u1ec7n:<\/p>\n\n\n\n

            \n
          • Ch\u1ecdn \u00f4 b\u1eaft \u0111\u1ea7u c\u1ee7a c\u1ed9t s\u1ed1 th\u1ee9 t\u1ef1 (v\u00ed d\u1ee5 \u00f4 A2).<\/li>\n\n\n\n
          • Nh\u1eadp c\u00f4ng th\u1ee9c: =SEQUENCE(S\u1ed1_h\u00e0ng)<\/li>\n\n\n\n
          • Trong \u0111\u00f3, S\u1ed1_h\u00e0ng l\u00e0 s\u1ed1 h\u00e0ng b\u1ea1n mu\u1ed1n \u0111\u00e1nh s\u1ed1. V\u00ed d\u1ee5, n\u1ebfu b\u1ea1n mu\u1ed1n \u0111\u00e1nh s\u1ed1 t\u1eeb \u00f4 A2 \u0111\u1ebfn A101, b\u1ea1n nh\u1eadp: =SEQUENCE(100)<\/li>\n\n\n\n
          • Ngay l\u1eadp t\u1ee9c, Excel s\u1ebd t\u1ef1 \u0111\u1ed9ng \u0111i\u1ec1n s\u1ed1 th\u1ee9 t\u1ef1 t\u1eeb 1 \u0111\u1ebfn 100 v\u00e0o c\u00e1c \u00f4 t\u01b0\u01a1ng \u1ee9ng.<\/li>\n<\/ul>\n\n\n\n

            \u01afu \u0111i\u1ec3m c\u1ee7a h\u00e0m SEQUENCE:<\/p>\n\n\n\n

              \n
            • SEQUENCE l\u00e0 m\u1ed9t h\u00e0m \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 trong Excel r\u1ea5t linh ho\u1ea1t, b\u1ea1n c\u00f3 th\u1ec3 \u0111i\u1ec1u ch\u1ec9nh kh\u00f4ng ch\u1ec9 s\u1ed1 h\u00e0ng m\u00e0 c\u00f2n s\u1ed1 c\u1ed9t, gi\u00e1 tr\u1ecb b\u1eaft \u0111\u1ea7u v\u00e0 \u0111\u1ed9 d\u00e0i c\u1ee7a chu\u1ed7i.<\/li>\n\n\n\n
            • V\u00ed d\u1ee5, n\u1ebfu b\u1ea1n mu\u1ed1n \u0111\u00e1nh s\u1ed1 b\u1eaft \u0111\u1ea7u t\u1eeb 5 v\u00e0 t\u0103ng d\u1ea7n th\u00eam 2 \u0111\u01a1n v\u1ecb m\u1ed7i l\u1ea7n, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c: =SEQUENCE(100, 1, 5, 2)<\/li>\n<\/ul>\n\n\n\n

              C\u00e1ch \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 trong Excel v\u1edbi d\u1eef li\u1ec7u c\u00f3 \u0111i\u1ec1u ki\u1ec7n<\/h2>\n\n\n\n

              Trong tr\u01b0\u1eddng h\u1ee3p b\u1ea1n ch\u1ec9 mu\u1ed1n \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 cho nh\u1eefng d\u00f2ng c\u00f3 d\u1eef li\u1ec7u (kh\u00f4ng \u0111\u00e1nh s\u1ed1 c\u00e1c d\u00f2ng tr\u1ed1ng), b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c k\u1ebft h\u1ee3p IF v\u00e0 COUNTA.<\/p>\n\n\n\n

              C\u00e1c b\u01b0\u1edbc th\u1ef1c hi\u1ec7n:<\/p>\n\n\n\n

                \n
              • Gi\u1ea3 s\u1eed b\u1ea1n c\u00f3 danh s\u00e1ch d\u1eef li\u1ec7u b\u1eaft \u0111\u1ea7u t\u1eeb \u00f4 B2, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c sau \u0111\u1ec3 \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 ch\u1ec9 cho c\u00e1c \u00f4 c\u00f3 d\u1eef li\u1ec7u: =IF(B2<>””,COUNTA($B$2:B2),””)<\/li>\n\n\n\n
              • C\u00f4ng th\u1ee9c n\u00e0y s\u1ebd \u0111\u1ebfm s\u1ed1 \u00f4 kh\u00f4ng tr\u1ed1ng trong c\u1ed9t B v\u00e0 \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 t\u01b0\u01a1ng \u1ee9ng cho m\u1ed7i \u00f4 ch\u1ee9a d\u1eef li\u1ec7u.<\/li>\n\n\n\n
              • Sao ch\u00e9p c\u00f4ng th\u1ee9c n\u00e0y xu\u1ed1ng c\u00e1c \u00f4 c\u00f2n l\u1ea1i trong c\u1ed9t s\u1ed1 th\u1ee9 t\u1ef1.<\/li>\n<\/ul>\n\n\n\n

                C\u00f4ng th\u1ee9c n\u00e0y s\u1ebd b\u1ecf qua c\u00e1c \u00f4 tr\u1ed1ng, ch\u1ec9 \u0111\u00e1nh s\u1ed1 cho nh\u1eefng \u00f4 c\u00f3 d\u1eef li\u1ec7u, gi\u00fap b\u1ea1n d\u1ec5 d\u00e0ng qu\u1ea3n l\u00fd c\u00e1c danh s\u00e1ch d\u1eef li\u1ec7u kh\u00f4ng \u0111\u1ed3ng \u0111\u1ec1u.<\/p>\n\n\n\n

                \u0110\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 t\u1ef1 \u0111\u1ed9ng c\u1eadp nh\u1eadt v\u1edbi thay \u0111\u1ed5i d\u1eef li\u1ec7u<\/h2>\n\n\n\n

                N\u1ebfu b\u1ea1n mu\u1ed1n s\u1ed1 th\u1ee9 t\u1ef1 t\u1ef1 \u0111\u1ed9ng c\u1eadp nh\u1eadt m\u1ed7i khi th\u00eam ho\u1eb7c x\u00f3a d\u1eef li\u1ec7u, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c SUBTOTAL k\u1ebft h\u1ee3p v\u1edbi IF.<\/p>\n\n\n\n

                  \n
                • Gi\u1ea3 s\u1eed d\u1eef li\u1ec7u c\u1ee7a b\u1ea1n b\u1eaft \u0111\u1ea7u t\u1eeb \u00f4 B2. B\u1ea1n c\u00f3 th\u1ec3 nh\u1eadp c\u00f4ng th\u1ee9c sau v\u00e0o \u00f4 A2 \u0111\u1ec3 \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 t\u1ef1 \u0111\u1ed9ng: =IF(B2<>””,SUBTOTAL(3, $B$2:B2), “”)<\/li>\n\n\n\n
                • Sao ch\u00e9p c\u00f4ng th\u1ee9c xu\u1ed1ng c\u00e1c \u00f4 c\u00f2n l\u1ea1i trong c\u1ed9t A.<\/li>\n\n\n\n
                • H\u00e0m SUBTOTAL(3, range) s\u1ebd \u0111\u1ebfm c\u00e1c \u00f4 kh\u00f4ng tr\u1ed1ng trong v\u00f9ng range, gi\u00fap b\u1ea1n t\u1ea1o ra s\u1ed1 th\u1ee9 t\u1ef1 t\u1ef1 \u0111\u1ed9ng c\u1eadp nh\u1eadt khi d\u1eef li\u1ec7u thay \u0111\u1ed5i.<\/li>\n<\/ul>\n\n\n\n

                  \u0110\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 trong Pivot Table<\/h2>\n\n\n\n

                  Trong tr\u01b0\u1eddng h\u1ee3p b\u1ea1n c\u1ea7n \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 trong Pivot Table, qu\u00e1 tr\u00ecnh s\u1ebd kh\u00e1c m\u1ed9t ch\u00fat do Pivot Table kh\u00f4ng h\u1ed7 tr\u1ee3 vi\u1ec7c th\u00eam c\u1ed9t t\u1eeb b\u00ean ngo\u00e0i v\u00e0o b\u1ea3ng t\u1ed5ng h\u1ee3p. \u0110\u1ec3 \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 trong Pivot Table, b\u1ea1n c\u1ea7n th\u1ef1c hi\u1ec7n m\u1ed9t trong hai ph\u01b0\u01a1ng ph\u00e1p sau:<\/p>\n\n\n\n

                    \n
                  • Th\u00eam m\u1ed9t c\u1ed9t s\u1ed1 th\u1ee9 t\u1ef1 v\u00e0o d\u1eef li\u1ec7u g\u1ed1c tr\u01b0\u1edbc khi t\u1ea1o Pivot Table.<\/li>\n\n\n\n
                  • S\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c ngo\u00e0i b\u1ea3ng Pivot \u0111\u1ec3 t\u1ea1o s\u1ed1 th\u1ee9 t\u1ef1 cho d\u1eef li\u1ec7u \u0111\u00e3 t\u1ed5ng h\u1ee3p.<\/li>\n<\/ul>\n\n\n\n

                    \u0110\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 trong Excel l\u00e0 m\u1ed9t thao t\u00e1c quan tr\u1ecdng gi\u00fap b\u1ea1n qu\u1ea3n l\u00fd d\u1eef li\u1ec7u m\u1ed9t c\u00e1ch r\u00f5 r\u00e0ng v\u00e0 c\u00f3 h\u1ec7 th\u1ed1ng. T\u00f9y v\u00e0o quy m\u00f4 v\u00e0 y\u00eau c\u1ea7u c\u1ee7a t\u1eebng t\u1eadp d\u1eef li\u1ec7u, b\u1ea1n c\u00f3 th\u1ec3 l\u1ef1a ch\u1ecdn c\u00e1ch \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 trong Excel<\/strong> t\u1eeb th\u1ee7 c\u00f4ng \u0111\u1ebfn s\u1eed d\u1ee5ng c\u00e1c c\u00f4ng th\u1ee9c ph\u1ee9c t\u1ea1p h\u01a1n. Hy v\u1ecdng b\u00e0i vi\u1ebft n\u00e0y \u0111\u00e3 cung c\u1ea5p cho b\u1ea1n nh\u1eefng ki\u1ebfn th\u1ee9c c\u1ea7n thi\u1ebft \u0111\u1ec3 th\u1ef1c hi\u1ec7n \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 m\u1ed9t c\u00e1ch d\u1ec5 d\u00e0ng, ch\u00ednh x\u00e1c, t\u1eeb \u0111\u00f3 gi\u00fap b\u1ea1n l\u00e0m vi\u1ec7c v\u1edbi Excel hi\u1ec7u qu\u1ea3 v\u00e0 khoa h\u1ecdc h\u01a1n.<\/p>\n\n\n\n

                    Trang \u0110o\u00e0n<\/strong><\/p>\n\n\n\n

                    <\/p>\n","protected":false},"excerpt":{"rendered":"

                    M\u1ed9t trong nh\u1eefng thao t\u00e1c c\u01a1 b\u1ea3n nh\u1ea5t trong Excel l\u00e0 \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1, gi\u00fap d\u1eef li\u1ec7u tr\u1edf n\u00ean r\u00f5 r\u00e0ng v\u00e0 d\u1ec5 theo …<\/p>\n","protected":false},"author":58,"featured_media":7711,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[15],"tags":[],"class_list":["post-7710","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\/7710","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=7710"}],"version-history":[{"count":1,"href":"https:\/\/mb668s.com\/cam-nang-7mb66-xoc-dia\/wp-json\/wp\/v2\/posts\/7710\/revisions"}],"predecessor-version":[{"id":7712,"href":"https:\/\/mb668s.com\/cam-nang-7mb66-xoc-dia\/wp-json\/wp\/v2\/posts\/7710\/revisions\/7712"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/mb668s.com\/cam-nang-7mb66-xoc-dia\/wp-json\/wp\/v2\/media\/7711"}],"wp:attachment":[{"href":"https:\/\/mb668s.com\/cam-nang-7mb66-xoc-dia\/wp-json\/wp\/v2\/media?parent=7710"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/mb668s.com\/cam-nang-7mb66-xoc-dia\/wp-json\/wp\/v2\/categories?post=7710"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/mb668s.com\/cam-nang-7mb66-xoc-dia\/wp-json\/wp\/v2\/tags?post=7710"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}