{"id":66247,"date":"2023-11-07T11:51:19","date_gmt":"2023-11-07T04:51:19","guid":{"rendered":"https:\/\/phongvu.vn\/cong-nghe\/?p=66247"},"modified":"2023-11-08T12:13:34","modified_gmt":"2023-11-08T05:13:34","slug":"cach-danh-so-thu-tu-trong-excel","status":"publish","type":"post","link":"https:\/\/phongvu.vn\/cong-nghe\/cach-danh-so-thu-tu-trong-excel\/","title":{"rendered":"T\u1ed5ng h\u1ee3p 6 c\u00e1ch \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 trong Excel t\u1ef1 \u0111\u1ed9ng d\u1ec5 d\u00e0ng v\u00e0 ch\u00ednh x\u00e1c"},"content":{"rendered":"\n

\u0110\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 l\u00e0 thao t\u00e1c c\u01a1 b\u1ea3n \u0111\u1ed1i v\u1edbi b\u1ea5t k\u1ef3 ai s\u1eed d\u1ee5ng Excel \u0111\u1ec3 l\u1eadp b\u1ea3ng t\u00ednh. Thao t\u00e1c n\u00e0y s\u1ebd gi\u00fap b\u1ea1n t\u1eadn d\u1ee5ng t\u1ed1i \u01b0u c\u00e1c c\u00f4ng c\u1ee5 c\u1ee7a Excel, ti\u1ebft ki\u1ec7m th\u1eddi gian trong vi\u1ec7c x\u1eed l\u00fd v\u00e0 th\u1ed1ng k\u00ea s\u1ed1. B\u00e0i vi\u1ebft d\u01b0\u1edbi \u0111\u00e2y c\u1ee7a Phong V\u0169 s\u1ebd h\u01b0\u1edbng d\u1eabn cho b\u1ea1n c\u00e1c c\u00e1ch \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 trong excel<\/a><\/em> <\/strong>nhanh ch\u00f3ng v\u00e0 \u0111\u01a1n gi\u1ea3n.<\/p>\n\n\n\n

\"\"
T\u1ed5ng h\u1ee3p c\u00e1ch \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 trong Excel nhanh ch\u00f3ng<\/em><\/figcaption><\/figure>\n\n\n\n

1. \u0110\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 trong Excel nhanh ch\u00f3ng b\u1eb1ng c\u00e1ch k\u00e9o chu\u1ed9t<\/strong><\/h2>\n\n\n\n

Hi\u1ec7n nay c\u00f3 r\u1ea5t nhi\u1ec1u c\u00e1ch \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 trong Excel nhanh, tuy nhi\u00ean c\u00e1ch \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng ph\u1ed5 bi\u1ebfn nh\u1ea5t v\u00e0 \u0111\u01a1n gi\u1ea3n nh\u1ea5t l\u00e0 k\u00e9o chu\u1ed9t. C\u00e1ch n\u00e0y r\u1ea5t d\u1ec5 th\u1ef1c hi\u1ec7n, b\u1ea1n ch\u1ec9 c\u1ea7n thao t\u00e1c theo c\u00e1c b\u01b0\u1edbc sau:<\/p>\n\n\n\n

    \n
  • B\u01b0\u1edbc 1:<\/strong> M\u1edf file Excel c\u1ea7n \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1, nh\u1eadp l\u1ea7n l\u01b0\u1ee3t s\u1ed1 1 v\u00e0 2 v\u00e0o 2 \u00f4 \u0111\u1ea7u ti\u00ean r\u1ed3i <\/strong>b\u00f4i \u0111en 2 \u00f4 \u0111\u00f3.<\/li>\n\n\n\n
  • B\u01b0\u1edbc 2:<\/strong> Di chuy\u1ec3n chu\u1ed9t \u0111\u1ebfn g\u00f3c ph\u1ea3i d\u01b0\u1edbi c\u00f9ng c\u1ee7a ph\u1ea7n \u0111\u01b0\u1ee3c b\u00f4i \u0111en cho \u0111\u1ebfn khi th\u1ea5y bi\u1ec3u t\u01b0\u1ee3ng d\u1ea5u \u201c+\u201d nh\u1ecf.<\/li>\n<\/ul>\n\n\n\n
    \"\"
    B\u00f4i \u0111en \u00f4 \u0111\u00e3 \u0111\u00e1nh s\u1ed1 r\u1ed3i t\u00ecm bi\u1ec3u t\u01b0\u1ee3ng d\u1ea5u c\u1ed9ng<\/em><\/figcaption><\/figure>\n\n\n\n
      \n
    • B\u01b0\u1edbc 3:<\/strong> Nh\u1ea5n gi\u1eef d\u1ea5u \u201c+\u201d v\u00e0 <\/strong>k\u00e9o chu\u1ed9t \u0111\u1ebfn v\u1ecb tr\u00ed k\u1ebft th\u00fac \u0111\u00e1nh s\u1ed1.<\/li>\n<\/ul>\n\n\n\n
      \"\"
      Nh\u1ea5n gi\u1eef d\u1ea5u c\u1ed9ng \u0111\u1ebfn v\u1ecb tr\u00ed k\u1ebft th\u00fac \u0111\u00e1nh s\u1ed1<\/em><\/figcaption><\/figure>\n\n\n\n

      2. \u0110\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 t\u1ef1 nh\u1ea3y trong Excel \u0111\u01a1n gi\u1ea3n b\u1eb1ng c\u00f4ng th\u1ee9c<\/strong><\/h2>\n\n\n\n

      Ngo\u00e0i vi\u1ec7c s\u1eed d\u1ee5ng c\u00e1c h\u00e0m c\u00f3 s\u1eb5n, b\u1ea1n c\u00f3 th\u1ec3 \u0111\u00e1nh s\u1ed1 trong Excel b\u1eb1ng c\u00f4ng th\u1ee9c. \u0110\u1ec3 th\u1ef1c hi\u1ec7n c\u00e1ch \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 t\u1ef1 \u0111\u1ed9ng trong Excel<\/strong> n\u00e0y, b\u1ea1n c\u1ea7n l\u00e0m theo c\u00e1c b\u01b0\u1edbc d\u01b0\u1edbi \u0111\u00e2y:<\/p>\n\n\n\n

        \n
      • B\u01b0\u1edbc 1:<\/strong> M\u1edf file Excel c\u1ea7n th\u1ef1c hi\u1ec7n \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 sau \u0111\u00f3 nh\u1eadp s\u1ed1 th\u1ee9 t\u1ef1 cho \u00f4 \u0111\u1ea7u ti\u00ean.<\/li>\n\n\n\n
      • B\u01b0\u1edbc 2:<\/strong> Di chuy\u1ec3n \u0111\u1ebfn \u00f4 th\u1ee9 2, h\u00e3y nh\u1eadp v\u00e0o c\u00f4ng th\u1ee9c \u201c=v\u1ecb tr\u00ed c\u1ee7a \u00f4 ph\u00eda tr\u00ean+1\u201d. V\u00ed d\u1ee5, t\u1ea1i \u00f4 A2 b\u1ea1n \u0111i\u1ec1n 1 th\u00ec t\u1ea1i \u00f4 A3 h\u00e3y nh\u1eadp \u201c=A2+1\u201d.<\/li>\n<\/ul>\n\n\n\n
        \"\"
        Nh\u1eadp c\u00f4ng th\u1ee9c b\u1eaft \u0111\u1ea7u t\u1eeb \u00f4 th\u1ee9 hai<\/em><\/figcaption><\/figure>\n\n\n\n
          \n
        • B\u01b0\u1edbc 3:<\/strong> Di chuy\u1ec3n chu\u1ed9t \u0111\u1ebfn bi\u1ec3u t\u01b0\u1ee3ng d\u1ea5u \u201c+\u201d \u1edf g\u00f3c d\u01b0\u1edbi \u00f4 v\u1eeba nh\u1eadp. <\/strong>Nh\u1ea5n gi\u1eef d\u1ea5u \u201c+\u201d v\u00e0 k\u00e9o th\u1ea3 chu\u1ed9t \u0111\u1ebfn \u00f4 k\u1ebft th\u00fac \u0111\u00e1nh s\u1ed1. <\/li>\n<\/ul>\n\n\n\n
          \"\"
          Nh\u1ea5n v\u00e0 k\u00e9o bi\u1ec3u t\u01b0\u1ee3ng d\u1ea5u \u201c+\u201d \u0111\u1ec3 \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 t\u1ef1 \u0111\u1ed9ng trong excel<\/em><\/figcaption><\/figure>\n\n\n\n

          3. \u0110\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 nhanh trong Excel b\u1eb1ng h\u00e0m ROW()-1<\/strong><\/h2>\n\n\n\n

          ROW()-1 \u0111\u01b0\u1ee3c xem l\u00e0 h\u00e0m th\u00f4ng d\u1ee5ng nh\u1ea5t khi \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 trong Excel. C\u00e1ch \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 trong Excel b\u1eb1ng h\u00e0m<\/strong> n\u00e0y v\u00f4 c\u00f9ng \u0111\u01a1n gi\u1ea3n, b\u1ea1n ch\u1ec9 c\u1ea7n th\u1ef1c hi\u1ec7n theo 2 b\u01b0\u1edbc d\u01b0\u1edbi \u0111\u00e2y:<\/p>\n\n\n\n

            \n
          • B\u01b0\u1edbc 1:<\/strong> M\u1edf file Excel r\u1ed3i x\u00e1c \u0111\u1ecbnh ph\u1ea1m vi mu\u1ed1n \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1. T\u1ea1i \u00f4 \u0111\u1ea7u ti\u00ean, b\u1ea1n nh\u1eadp \u201c=ROW()-(s\u1ed1 th\u1ee9 t\u1ef1 c\u1ee7a \u00f4 c\u1ea7n \u0111i\u1ec1n -1)\u201d, h\u00e0m s\u1ebd tr\u1ea3 v\u1ec1 s\u1ed1 th\u1ee9 t\u1ef1 cho \u00f4 v\u1eeba nh\u1eadp.<\/li>\n<\/ul>\n\n\n\n
            \"\"
            Nh\u1eadp c\u00f4ng th\u1ee9c c\u1ee7a h\u00e0m ROW v\u00e0o \u00f4 \u0111\u1ea7u ti\u00ean<\/em><\/figcaption><\/figure>\n\n\n\n
              \n
            • B\u01b0\u1edbc 2<\/strong>: T\u1ea1i \u00f4 v\u1eeba nh\u1eadp h\u00e0m, b\u1ea1n di chuy\u1ec3n chu\u1ed9t \u0111\u1ebfn bi\u1ec3u t\u01b0\u1ee3ng \u201c+\u201d sau \u0111\u00f3 nh\u1ea5n gi\u1eef bi\u1ec3u t\u01b0\u1ee3ng \u0111\u1ebfn \u00f4 k\u1ebft th\u00fac \u0111\u00e1nh s\u1ed1.<\/li>\n<\/ul>\n\n\n\n
              \"\"
              Nh\u1ea5n v\u00e0 di chuy\u1ec3n bi\u1ec3u t\u01b0\u1ee3ng d\u1ea5u \u201c+\u201d \u0111\u1ebfn v\u1ecb tr\u00ed k\u1ebft th\u00fac \u0111\u00e1nh s\u1ed1<\/em><\/figcaption><\/figure>\n\n\n\n

              4. \u0110\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 t\u1ef1 \u0111\u1ed9ng trong Excel b\u1eb1ng h\u00e0m SEQUENCE<\/strong><\/h2>\n\n\n\n

              H\u00e0m SEQUENCE cung c\u1ea5p c\u00e1ch \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 nhanh trong Excel v\u00e0 v\u00f4 c\u00f9ng ti\u1ec7n l\u1ee3i. H\u00e0m n\u00e0y c\u00f2n \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng r\u1ed9ng r\u00e3i trong nhi\u1ec1u ng\u1eef c\u1ea3nh kh\u00e1c nhau t\u00f9y theo nhu c\u1ea7u ng\u01b0\u1eddi d\u00f9ng.<\/p>\n\n\n\n

                \n
              • B\u01b0\u1edbc 1:<\/strong> M\u1edf file Excel c\u1ea7n th\u1ef1c hi\u1ec7n \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1, ti\u1ebfp \u0111\u00f3 nh\u1eadp v\u00e0o \u00f4 \u0111\u1ea7u ti\u00ean trong b\u1ea3ng c\u00f4ng th\u1ee9c c\u1ee7a h\u00e0m nh\u01b0 sau: \u201c=SEQUENCE(s\u1ed1 h\u00e0ng c\u1ea7n \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1)\u201d.<\/li>\n<\/ul>\n\n\n\n
                \"\"
                S\u1eed d\u1ee5ng h\u00e0m SEQUENCE \u0111\u1ec3 \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 trong Excel<\/em><\/figcaption><\/figure>\n\n\n\n
                  \n
                • B\u01b0\u1edbc 2:<\/strong> Nh\u1ea5n Enter \u0111\u1ec3 th\u1ef1c thi h\u00e0m. V\u00ed d\u1ee5 nh\u1eadp h\u00e0m \u201c=SEQUENCE(7)\u201d sau \u0111\u00f3 b\u1ea5m Enter, b\u1ea3ng Excel s\u1ebd c\u00f3 7 h\u00e0ng \u0111\u01b0\u1ee3c \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1.<\/li>\n<\/ul>\n\n\n\n

                  5. \u0110\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 trong Excel b\u1eb1ng AUTO FILL<\/strong><\/h2>\n\n\n\n

                  N\u1ebfu tr\u00ean thanh Ribbon c\u1ee7a b\u1ea1n ch\u01b0a hi\u1ec7n ch\u1ee9c n\u0103ng Auto Fill, h\u00e3y th\u1ef1c hi\u1ec7n c\u00e1c b\u01b0\u1edbc sau:<\/p>\n\n\n\n

                    \n
                  • B\u01b0\u1edbc 1:<\/strong> v\u00e0o File -> Options.<\/li>\n<\/ul>\n\n\n\n
                    \"\"<\/figure>\n\n\n\n
                      \n
                    • B\u01b0\u1edbc 2:<\/strong> Ch\u1ecdn Customize Ribbon -> Ch\u1ecdn All commands -> Ch\u1ecdn Filter series or Pattern.<\/li>\n<\/ul>\n\n\n\n
                      \"\"<\/figure>\n\n\n\n
                        \n
                      • B\u01b0\u1edbc 3<\/strong>: T\u1ea1i b\u1ea3ng Main Tabs tr\u1ecf v\u00e0o c\u00e2y th\u01b0 m\u1ee5c Home -> Nh\u1ea5n chu\u1ed9t ph\u1ea3i -> Ch\u1ecdn Add new Group.<\/li>\n<\/ul>\n\n\n\n
                        \"\"<\/figure>\n\n\n\n
                          \n
                        • B\u01b0\u1edbc 4:<\/strong> Quay l\u1ea1i ch\u1ecdn Filter Series or Pattern > Nh\u1ea5n Add > Nh\u1ea5n OK.<\/li>\n<\/ul>\n\n\n\n
                          \"\"<\/figure>\n\n\n\n

                          Sau khi th\u1ef1c hi\u1ec7n c\u00e1c b\u01b0\u1edbc n\u00e0y ch\u1ee9c n\u0103ng Auto Fill s\u1ebd hi\u1ec7n l\u00ean tr\u00ean thanh c\u00f4ng c\u1ee5. \u0110\u00e2y \u0111\u01b0\u1ee3c xem l\u00e0 c\u00e1ch \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 \u0111\u1ebfn 1000 trong excel<\/strong> nhanh v\u00e0 d\u1ec5 d\u00e0ng nh\u1ea5t. B\u1ea1n c\u00f3 th\u1ec3 th\u1ef1c hi\u1ec7n \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 trong Excel v\u1edbi c\u00f4ng c\u1ee5 n\u00e0y v\u1edbi c\u00e1c b\u01b0\u1edbc sau:<\/p>\n\n\n\n

                            \n
                          • B\u01b0\u1edbc 1:<\/strong> M\u1edf file Excel c\u1ea7n \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1, nh\u1eadp s\u1ed1 v\u00e0o \u00f4 \u0111\u1ea7u ti\u00ean sau \u0111\u00f3 ch\u1ecdn Fill -> Series.<\/li>\n<\/ul>\n\n\n\n
                            \"\"<\/figure>\n\n\n\n

                            L\u00fac n\u00e0y b\u1ea3ng Series s\u1ebd hi\u1ec7n ra v\u1edbi 4 ki\u1ec3u \u0111\u00e1nh s\u1ed1:<\/p>\n\n\n\n

                              \n
                            1. Linear: \u0110\u00e1nh s\u1ed1 ki\u1ec3u t\u0103ng d\u1ea7n.<\/li>\n\n\n\n
                            2. Growth: \u0110\u00e1nh s\u1ed1 theo ki\u1ec3u l\u0169y ti\u1ebfn<\/li>\n\n\n\n
                            3. Date: \u0110\u00e1nh s\u1ed1 theo ki\u1ec3u th\u00e1ng.<\/li>\n\n\n\n
                            4. Auto Fill: \u0110\u00e1nh s\u1ed1 ki\u1ec3u t\u1ef1 \u0111\u1ed9ng \u0111i\u1ec1n.<\/li>\n<\/ol>\n\n\n\n

                              H\u00e3y ch\u1ecdn Rows n\u1ebfu b\u1ea1n mu\u1ed1n \u0111\u00e1nh s\u1ed1 theo h\u00e0ng ho\u1eb7c ch\u1ecdn Columns n\u1ebfu mu\u1ed1n \u0111\u00e1nh s\u1ed1 theo c\u1ed9t. B\u00e0i vi\u1ebft n\u00e0y h\u01b0\u1edbng d\u1eabn c\u00e1c b\u1ea1n c\u00e1ch \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 t\u0103ng d\u1ea7n, do \u0111\u00f3 ch\u1ecdn ki\u1ec3u Linear.<\/p>\n\n\n\n

                                \n
                              • B\u01b0\u1edbc 2<\/strong>: Sau khi ch\u1ecdn xong c\u00e1c m\u1ee5c ph\u00eda tr\u00ean, b\u1ea1n c\u1ea7n nh\u1eadp s\u1ed1 th\u1ee9 t\u1ef1 b\u1eaft \u0111\u1ea7u v\u00e0o Step value v\u00e0 s\u1ed1 th\u1ee9 t\u1ef1 cu\u1ed1i c\u00f9ng v\u00e0o Stop value r\u1ed3i nh\u1ea5n OK. <\/li>\n<\/ul>\n\n\n\n
                                \"\"<\/figure>\n\n\n\n
                                  \n
                                • B\u01b0\u1edbc 3<\/strong>: B\u1ea3ng Excel s\u1ebd hi\u1ec3n th\u1ecb d\u00e3y s\u1ed1 th\u1ee9 t\u1ef1 theo \u0111\u00fang y\u00eau c\u1ea7u b\u1ea1n nh\u1eadp.<\/li>\n<\/ul>\n\n\n\n
                                  \"\"<\/figure>\n\n\n\n

                                  6. \u0110\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 trong Excel nhanh b\u1eb1ng c\u00e1ch k\u1ebft h\u1ee3p h\u00e0m SUBTOTAL v\u00e0 h\u00e0m IF<\/strong><\/h2>\n\n\n\n

                                  S\u1eed d\u1ee5ng k\u1ebft h\u1ee3p h\u00e0m SUBTOTAL v\u00e0 h\u00e0m IF l\u00e0 c\u00e1ch \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 trong excel khi l\u1ecdc d\u1eef li\u1ec7u <\/strong>r\u1ea5t ph\u1ed5 bi\u1ebfn. V\u1edbi nh\u1eefng h\u00e0ng tr\u1ed1ng, h\u00e0ng kh\u00f4ng c\u00f3 d\u1eef li\u1ec7u s\u1ebd kh\u00f4ng \u0111\u01b0\u1ee3c \u0111\u00e1nh s\u1ed1.<\/p>\n\n\n\n

                                  D\u01b0\u1edbi \u0111\u00e2y l\u00e0 c\u00f4ng th\u1ee9c h\u00e0m SUBTOTAL l\u1ed3ng v\u1edbi h\u00e0m IF:<\/p>\n\n\n\n

                                  \u201c=IF(logical_test; [value_if_true]; [value_if_false]; SUBTOTAL(function_num; ref1;…))\u201d<\/strong><\/p>\n\n\n\n

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

                                    \n
                                  • Logical_test:<\/em><\/strong>  l\u00e0 \u0111i\u1ec1u ki\u1ec7n c\u1ee7a h\u00e0m IF.<\/li>\n\n\n\n
                                  • Value_if_true<\/em><\/strong>:<\/strong> Gi\u00e1 tr\u1ecb m\u00e0 h\u00e0m s\u1ebd tr\u1ea3 v\u1ec1 n\u1ebfu \u0111i\u1ec1u ki\u1ec7n \u0111\u00fang.<\/li>\n\n\n\n
                                  • Value_if_false<\/em><\/strong>: Gi\u00e1 tr\u1ecb m\u00e0 h\u00e0m s\u1ebd tr\u1ea3 v\u1ec1 n\u1ebfu \u0111i\u1ec1u ki\u1ec7n sai.<\/li>\n\n\n\n
                                  • Function_num<\/em><\/strong>:<\/strong> H\u00e0m con th\u01b0\u1eddng \u0111\u01b0\u1ee3c d\u00f9ng \u0111\u1ec3 t\u00ednh to\u00e1n, hi\u1ec3u theo gi\u00e1 tr\u1ecb s\u1ed1.<\/li>\n\n\n\n
                                  • Ref1:<\/em><\/strong> V\u00f9ng s\u1ed1 th\u1ee9 t\u1ef1 m\u00e0 b\u1ea1n c\u1ea7n \u0111\u00e1nh s\u1ed1.<\/li>\n<\/ul>\n\n\n\n

                                    V\u00ed d\u1ee5 b\u1ea1n c\u1ea7n \u0111i\u1ec1n s\u1ed1 th\u1ee9 t\u1ef1 cho b\u1ea3ng d\u1eef li\u1ec7u b\u00ean d\u01b0\u1edbi m\u1ed9t c\u00e1ch t\u1ef1 \u0111\u1ed9ng.<\/p>\n\n\n\n

                                    \"\"
                                    B\u1ea3ng d\u1eef li\u1ec7u c\u1ea7n \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 t\u1ef1 \u0111\u1ed9ng b\u1eb1ng h\u00e0m SUBTOTAL v\u00e0 h\u00e0m IF<\/em><\/figcaption><\/figure>\n\n\n\n

                                    B\u01b0\u1edbc 1: <\/strong>Nh\u1eadp c\u00f4ng th\u1ee9c sau v\u00e0o \u00f4 \u0111\u1ea7u ti\u00ean c\u1ea7n \u0111\u00e1nh s\u1ed1 c\u1ee7a b\u1ea3ng: “=IF(B2=””,””,SUBTOTAL(3,$B$2:B2))”.<\/strong><\/p>\n\n\n\n

                                    \"\"
                                    Nh\u1eadp c\u00f4ng th\u1ee9c k\u1ebft h\u1ee3p c\u1ee7a h\u00e0m SUBTOTAL v\u00e0 h\u00e0m IF<\/em><\/figcaption><\/figure>\n\n\n\n

                                    B\u01b0\u1edbc 2: <\/strong>Di chu\u1ed9t \u0111\u1ebfn g\u00f3c d\u01b0\u1edbi b\u00ean ph\u1ea3i \u00f4 \u0111\u1ea7u ti\u00ean s\u1ebd xu\u1ea5t hi\u1ec7n bi\u1ec3u t\u01b0\u1ee3ng d\u1ea5u \u201c+\u201d. L\u00fac n\u00e0y b\u1ea1n nh\u1ea5n v\u00e0o d\u1ea5u \u201c+\u201d v\u00e0 k\u00e9o chu\u1ed9t xu\u1ed1ng \u0111\u1ebfn \u00f4 m\u00e0 k\u1ebft th\u00fac \u0111\u00e1nh s\u1ed1 \u0111\u1ec3 nh\u1eadp s\u1ed1 th\u1ee9 t\u1ef1 cho ch\u00fang.<\/p>\n\n\n\n

                                    \"\"
                                    K\u00e9o chu\u1ed9t \u0111\u1ec3 nh\u1eadp c\u00f4ng th\u1ee9c t\u01b0\u01a1ng \u1ee9ng cho c\u00e1c \u00f4 c\u00f2n l\u1ea1i<\/em><\/figcaption><\/figure>\n\n\n\n

                                    Tr\u00ean \u0111\u00e2y l\u00e0 t\u1ed5ng h\u1ee3p c\u00e1c <\/em>c\u00e1ch \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 trong Excel<\/em><\/strong> \u0111\u01a1n gi\u1ea3n v\u00e0 nhanh ch\u00f3ng. Vi\u1ec7c \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 l\u00e0 r\u1ea5t quan tr\u1ecdng v\u00ec h\u1ea7u h\u1ebft vi\u1ec7c l\u00e0m s\u1eed d\u1ee5ng \u0111\u1ebfn Excel \u0111\u1ec1u c\u1ea7n ph\u1ea3i \u0111\u00e1nh s\u1ed1 \u0111\u1ec3 qu\u1ea3n l\u00fd. Hy v\u1ecdng b\u00e0i vi\u1ebft tr\u00ean c\u1ee7a Phong V\u0169<\/em><\/strong> s\u1ebd gi\u00fap \u00edch \u0111\u01b0\u1ee3c cho b\u1ea1n trong h\u1ecdc t\u1eadp v\u00e0 l\u00e0m vi\u1ec7c. <\/p>\n","protected":false},"excerpt":{"rendered":"

                                    \u0110\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 l\u00e0 thao t\u00e1c c\u01a1 b\u1ea3n \u0111\u1ed1i v\u1edbi b\u1ea5t k\u1ef3 ai s\u1eed d\u1ee5ng Excel \u0111\u1ec3 l\u1eadp b\u1ea3ng t\u00ednh. Thao t\u00e1c n\u00e0y s\u1ebd gi\u00fap b\u1ea1n t\u1eadn d\u1ee5ng t\u1ed1i \u01b0u c\u00e1c c\u00f4ng c\u1ee5 c\u1ee7a Excel, ti\u1ebft ki\u1ec7m th\u1eddi gian trong vi\u1ec7c x\u1eed l\u00fd v\u00e0 th\u1ed1ng k\u00ea s\u1ed1. B\u00e0i vi\u1ebft d\u01b0\u1edbi \u0111\u00e2y c\u1ee7a Phong V\u0169 […]<\/p>\n","protected":false},"author":2,"featured_media":82603,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"aside","meta":{"inline_featured_image":false},"categories":[1029,1743],"tags":[],"_links":{"self":[{"href":"https:\/\/phongvu.vn\/cong-nghe\/wp-json\/wp\/v2\/posts\/66247"}],"collection":[{"href":"https:\/\/phongvu.vn\/cong-nghe\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/phongvu.vn\/cong-nghe\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/phongvu.vn\/cong-nghe\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/phongvu.vn\/cong-nghe\/wp-json\/wp\/v2\/comments?post=66247"}],"version-history":[{"count":4,"href":"https:\/\/phongvu.vn\/cong-nghe\/wp-json\/wp\/v2\/posts\/66247\/revisions"}],"predecessor-version":[{"id":82624,"href":"https:\/\/phongvu.vn\/cong-nghe\/wp-json\/wp\/v2\/posts\/66247\/revisions\/82624"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/phongvu.vn\/cong-nghe\/wp-json\/wp\/v2\/media\/82603"}],"wp:attachment":[{"href":"https:\/\/phongvu.vn\/cong-nghe\/wp-json\/wp\/v2\/media?parent=66247"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/phongvu.vn\/cong-nghe\/wp-json\/wp\/v2\/categories?post=66247"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/phongvu.vn\/cong-nghe\/wp-json\/wp\/v2\/tags?post=66247"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}