{"id":1001,"date":"2018-12-25T17:48:19","date_gmt":"2018-12-25T10:48:19","guid":{"rendered":"http:\/\/help.smecloud.misa.local\/?post_type=ht_kb&p=1001"},"modified":"2026-06-09T09:39:43","modified_gmt":"2026-06-09T02:39:43","slug":"html_10050000","status":"publish","type":"ht_kb","link":"\/accounting\/kb\/html_10050000\/","title":{"rendered":"L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 nh\u1eadp c\u00e1c Danh m\u1ee5c, S\u1ed1 d\u01b0, Ch\u1ee9ng t\u1eeb t\u1eeb file excel v\u00e0o ph\u1ea7n m\u1ec1m?"},"content":{"rendered":"
\n
<\/span><\/p>\n

1. T\u1ed5ng quan<\/h3>\n

<\/div>

\n

B\u00e0i vi\u1ebft n\u00e0y h\u01b0\u1edbng d\u1eabn c\u00e1ch\u00a0nh\u1eadp d\u1eef li\u1ec7u k\u1ebf to\u00e1n t\u1eeb t\u1ec7p Excel v\u00e0o ph\u1ea7n m\u1ec1m<\/strong>, g\u1ed3m c\u00e1c lo\u1ea1i d\u1eef li\u1ec7u: Danh m\u1ee5c, S\u1ed1 d\u01b0, Ch\u1ee9ng t\u1eeb. Thao t\u00e1c n\u00e0y gi\u00fap ti\u1ebft ki\u1ec7m th\u1eddi gian v\u00e0 gi\u1ea3m thi\u1ec3u thao t\u00e1c khi l\u00e0m vi\u1ec7c<\/p>\n

N\u1ed9i dung:<\/strong><\/p>\n

    \n
  • Nh\u1eadp danh m\u1ee5c t\u1eeb Excel<\/li>\n
  • Nh\u1eadp s\u1ed1 d\u01b0 t\u1eeb Excel<\/li>\n
  • Nh\u1eadp ch\u1ee9ng t\u1eeb t\u1eeb Excel<\/li>\n<\/ul>\n

    Ph\u1ea1m vi \u00e1p d\u1ee5ng:<\/strong> K\u1ebf to\u00e1n, Qu\u1ea3n tr\u1ecb h\u1ec7 th\u1ed1ng, Ng\u01b0\u1eddi d\u00f9ng nh\u1eadp li\u1ec7u<\/p>\n<\/div><\/div>\n

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

    2. C\u00e1c b\u01b0\u1edbc th\u1ef1c hi\u1ec7n<\/h3>\n

    <\/div>

    \n

    Cho ph\u00e9p nh\u1eadp d\u1eef li\u1ec7u k\u1ebf to\u00e1n t\u1eeb t\u1ec7p Excel v\u00e0o ph\u1ea7n m\u1ec1m. G\u1ed3m c\u00e1c lo\u1ea1i d\u1eef li\u1ec7u sau: Danh m\u1ee5c, S\u1ed1 d\u01b0, Ch\u1ee9ng t\u1eeb<\/strong><\/p>\n\n\n\n
    <\/div><\/div>\n
    <\/span><\/p>\n

    2.1. Nh\u1eadp danh m\u1ee5c t\u1eeb file Excel<\/h4>\n

    <\/div>

    \n

    B\u01b0\u1edbc 1:<\/strong> V\u00e0o bi\u1ec3u t\u01b0\u1ee3ng b\u00e1nh r\u0103ng \u2699<\/span> C\u00e1c ti\u1ec7n \u00edch v\u00e0 thi\u1ebft l\u1eadp\\T\u1ea5t c\u1ea3 danh m\u1ee5c<\/strong>, ch\u1ecdn danh m\u1ee5c c\u1ea7n th\u1ef1c hi\u1ec7n khai b\u00e1o.
    \n\"\"\"\"<\/p>\n

    B\u01b0\u1edbc 2:<\/strong> Ch\u1ecdn Nh\u1eadp t\u1eeb excel<\/strong><\/p>\n

    \"\"<\/p>\n

      \n
    • Ch\u01b0\u01a1ng tr\u00ecnh s\u1ebd hi\u1ec3n th\u1ecb giao di\u1ec7n<\/li>\n<\/ul>\n

      \"\"<\/p>\n

      B\u01b0\u1edbc 3: Ch\u1ecdn t\u1ec7p ngu\u1ed3n<\/strong><\/p>\n

        \n
      • Ch\u1ecdn file nh\u1eadp kh\u1ea9u s\u1eb5n c\u00f3 tr\u00ean m\u00e1y t\u00ednh ho\u1eb7c c\u00f3 th\u1ec3 t\u1ea3i file m\u1eabu<\/strong> v\u1ec1 \u0111\u1ec3 t\u1ea1o file d\u1eef li\u1ec7u nh\u1eadp kh\u1ea9u.<\/li>\n
      • Sheet nh\u1eadp kh\u1ea9u:<\/strong> Ch\u1ecdn sheet c\u00f3 ch\u1ee9a d\u1eef li\u1ec7u c\u1ea7n nh\u1eadp trong file excel<\/li>\n
      • D\u00f2ng ti\u00eau \u0111\u1ec1u:<\/strong> L\u1ef1a ch\u1ecdn d\u00f2ng ti\u00eau \u0111\u1ec1 c\u1ed9t d\u1eef li\u1ec7u trong file excel.<\/li>\n
      • C\u00f3 3 ph\u01b0\u01a1ng th\u1ee9c nh\u1eadp kh\u1ea9u th\u00f4ng tin: Th\u00eam m\u1edbi \/ C\u1eadp nh\u1eadt \/ Ghi \u0111\u00e8.
        \nNh\u1ea5n v\u00e0o So s\u00e1nh c\u00e1c ph\u01b0\u01a1ng th\u1ee9c<\/strong> \u0111\u1ec3 xem chi ti\u1ebft c\u00e1ch h\u1ec7 th\u1ed1ng x\u1eed l\u00fd c\u1ee7a t\u1eebng ph\u01b0\u01a1ng ph\u00e1p.
        \n\"\"
        \n\"\"<\/p>\n
          \n
        • Th\u00eam m\u1edbi:<\/strong>\n
            \n
          • D\u1eef li\u1ec7u VTHH, nh\u00e0 cung c\u1ea5p, kh\u00e1ch h\u00e0ng\u2026 c\u00f3 tr\u00ean t\u1ec7p excel m\u00e0 ch\u01b0a c\u00f3 tr\u00ean ph\u1ea7n m\u1ec1m th\u00ec s\u1ebd \u0111\u01b0\u1ee3c th\u00eam m\u1edbi v\u00e0o ph\u1ea7n m\u1ec1m.<\/li>\n
          • D\u1eef li\u1ec7u VTHH, nh\u00e0 cung c\u1ea5p, kh\u00e1ch h\u00e0ng\u2026 c\u00f3 tr\u00ean t\u1ec7p excel v\u00e0 c\u0169ng \u0111\u00e3 c\u00f3 tr\u00ean ph\u1ea7n m\u1ec1m th\u00ec v\u1eabn s\u1ebd gi\u1eef nguy\u00ean nh\u01b0 tr\u00ean ph\u1ea7n m\u1ec1m, kh\u00f4ng c\u1eadp nh\u1eadt l\u1ea1i<\/strong>.<\/li>\n<\/ul>\n<\/li>\n
          • C\u1eadp nh\u1eadt:<\/strong>\n
              \n
            • D\u1eef li\u1ec7u VTHH, nh\u00e0 cung c\u1ea5p, kh\u00e1ch h\u00e0ng\u2026 c\u00f3 tr\u00ean t\u1ec7p excel m\u00e0 ch\u01b0a c\u00f3 tr\u00ean ph\u1ea7n m\u1ec1m th\u00ec s\u1ebd \u0111\u01b0\u1ee3c th\u00eam m\u1edbi v\u00e0o ph\u1ea7n m\u1ec1m.<\/li>\n
            • D\u1eef li\u1ec7u VTHH, nh\u00e0 cung c\u1ea5p, kh\u00e1ch h\u00e0ng\u2026 c\u00f3 tr\u00ean t\u1ec7p excel v\u00e0 c\u0169ng \u0111\u00e3 c\u00f3 tr\u00ean ph\u1ea7n m\u1ec1m th\u00ec v\u1eabn s\u1ebd \u0111\u01b0\u1ee3c c\u1eadp nh\u1eadt l\u1ea1i<\/strong>.<\/li>\n<\/ul>\n<\/li>\n
            • Ghi \u0111\u00e8:<\/strong> To\u00e0n b\u1ed9 d\u1eef li\u1ec7u tr\u00ean ph\u1ea7n m\u1ec1m s\u1ebd b\u1ecb x\u00f3a \u0111i v\u00e0 thay th\u1ebf b\u1eb1ng d\u1eef li\u1ec7u tr\u00ean t\u1ec7p excel.<\/li>\n<\/ul>\n<\/li>\n
            • Sau khi \u0111\u00e3 l\u1ef1a ch\u1ecdn xong, nh\u1ea5n Ti\u1ebfp t\u1ee5c<\/strong> \u0111\u1ec3 chuy\u1ec3n qua b\u01b0\u1edbc 2.<\/li>\n<\/ul>\n

              B\u01b0\u1edbc 4: Gh\u00e9p d\u1eef li\u1ec7u<\/strong><\/p>\n

                \n
              • Tr\u01b0\u1eddng h\u1ee3p l\u1ea5y t\u1eeb file m\u1eabu th\u00ec ch\u01b0\u01a1ng tr\u00ecnh s\u1ebd t\u1ef1 \u0111\u1ed9ng gh\u00e9p c\u00e1c c\u1ed9t tr\u00ean file d\u1eef li\u1ec7u v\u00e0 c\u00e1c c\u1ed9t th\u00f4ng tin tr\u00ean ch\u01b0\u01a1ng tr\u00ecnh
                \n\"\"<\/li>\n
              • Tr\u01b0\u1eddng h\u1ee3p l\u00e0 file t\u1ef1 t\u1ea1o kh\u00f4ng theo m\u1eabu ch\u01b0\u01a1ng tr\u00ecnh Anh\/Ch\u1ecb t\u1eeb th\u1ef1c hi\u1ec7n gh\u00e9p th\u1ee7 c\u00f4ng t\u1eebng c\u1ed9t tr\u00ean ph\u1ea7n m\u1ec1m t\u01b0\u01a1ng \u1ee9ng v\u1edbi c\u1ed9t n\u00e0o tr\u00ean excel.
                \n\"\"<\/li>\n<\/ul>\n

                L\u01b0u \u00fd<\/strong>:<\/em><\/p>\n

                  \n
                • T\u1ea1i d\u00f2ng\u00a0c\u00f3 t\u00edch ch\u1ecdn<\/strong>\u00a0\u201cTh\u00f4ng tin b\u1eaft bu\u1ed9c\u201d <\/strong>\u00a0th\u00ec ph\u1ea3i \u0111\u1ea3m b\u1ea3o c\u1ed9t tr\u00ean t\u1ec7p excel ph\u1ea3i nh\u1eadp \u0111\u1ea7y \u0111\u1ee7 th\u00f4ng tin, kh\u00f4ng \u0111\u01b0\u1ee3c b\u1ecf tr\u1ed1ng gi\u00e1 tr\u1ecb.<\/em><\/li>\n
                • N\u1ebfu\u00a0kh\u00f4ng t\u00edch ch\u1ecdn<\/strong> \u201cTh\u00f4ng tin b\u1eaft bu\u1ed9c<\/strong>\u201d<\/strong>, ch\u01b0\u01a1ng tr\u00ecnh s\u1ebd l\u1ea5y th\u00f4ng tin ng\u1ea7m \u0111\u1ecbnh ho\u1eb7c \u0111\u1ec3 tr\u1ed1ng t\u00f9y theo quy t\u1eafc ri\u00eang c\u1ee7a t\u1eebng lo\u1ea1i danh m\u1ee5c, ch\u1ee9ng t\u1eeb.<\/em><\/li>\n
                • Tr\u01b0\u1eddng h\u1ee3p mu\u1ed1n th\u00eam ho\u1eb7c b\u1edbt c\u00e1c c\u1ed9t th\u00f4ng tin mu\u1ed1n gh\u00e9p th\u00ec c\u00f3 th\u1ec3 t\u00edch \u1ea8n\/hi\u1ec7n th\u00f4ng tin
                  \n\"\"
                  \n<\/strong><\/em><\/li>\n<\/ul>\n

                  B\u01b0\u1edbc 5: Ki\u1ec3m tra d\u1eef li\u1ec7u<\/strong><\/p>\n

                    \n
                  • Ch\u01b0\u01a1ng tr\u00ecnh s\u1ebd ki\u1ec3m tra to\u00e0n b\u1ed9 d\u1eef li\u1ec7u trong c\u00e1c c\u1ed9t v\u1edbi d\u1eef li\u1ec7u \u0111\u00e3 t\u1ed3n t\u1ea1i tr\u00ean ch\u01b0\u01a1ng tr\u00ecnh v\u00e0 hi\u1ec3n th\u1ecb th\u00f4ng b\u00e1o.
                    \n\"\"<\/li>\n
                  • Khi \u0111\u00f3 c\u00f3 th\u1ec3 l\u1ef1a ch\u1ecdn:\n