{"id":4595,"date":"2025-11-13T12:00:57","date_gmt":"2025-11-13T05:00:57","guid":{"rendered":"https:\/\/autofillform.com\/blog\/11-cach-lam-giam-dung-luong-tang-toc-xu-ly-file-excel\/"},"modified":"2025-11-13T12:00:57","modified_gmt":"2025-11-13T05:00:57","slug":"11-cach-lam-giam-dung-luong-tang-toc-xu-ly-file-excel","status":"publish","type":"post","link":"https:\/\/autofillform.com\/blog\/11-cach-lam-giam-dung-luong-tang-toc-xu-ly-file-excel\/","title":{"rendered":"11 C\u00e1ch l\u00e0m gi\u1ea3m dung l\u01b0\u1ee3ng, t\u0103ng t\u1ed1c x\u1eed l\u00fd file Excel"},"content":{"rendered":"
\n

File Excel qu\u00e1 n\u1eb7ng d\u1ec5 khi\u1ebfn thao t\u00e1c ch\u1eadm, m\u1edf file l\u00e2u v\u00e0 kh\u00f3 chia s\u1ebb. B\u00e0i vi\u1ebft n\u00e0y h\u01b0\u1edbng d\u1eabn b\u1ea1n c\u00e1c c\u00e1ch t\u1ed1i \u01b0u dung l\u01b0\u1ee3ng nh\u01b0 x\u00f3a \u0111\u1ecbnh d\u1ea1ng th\u1eeba, lo\u1ea1i b\u1ecf li\u00ean k\u1ebft, n\u00e9n h\u00ecnh \u1ea3nh v\u00e0 tinh ch\u1ec9nh PivotTable \u0111\u1ec3 b\u1ea3ng t\u00ednh ch\u1ea1y nh\u1eb9 v\u00e0 m\u01b0\u1ee3t h\u01a1n.<\/p>\n

\"C\u00e1chH\u01b0\u1edbng d\u1eabn c\u00e1ch l\u00e0m gi\u1ea3m dung l\u01b0\u1ee3ng, t\u0103ng t\u1ed1c x\u1eed l\u00fd file Excel<\/em><\/p>\n

\n

1. Nguy\u00ean nh\u00e2n d\u1eabn \u0111\u1ebfn file Excel b\u1ecb n\u1eb7ng, x\u1eed l\u00fd ch\u1eadm<\/h2>\n<\/div>\n

File Excel d\u1ec5 b\u1ecb ch\u1eadm khi dung l\u01b0\u1ee3ng ph\u00ecnh ra v\u01b0\u1ee3t m\u1ee9c c\u1ea7n thi\u1ebft. M\u1ed9t s\u1ed1 t\u00e1c v\u1ee5 quen thu\u1ed9c trong qu\u00e1 tr\u00ecnh s\u1eed d\u1ee5ng v\u00f4 t\u00ecnh l\u00e0m b\u1ea3ng t\u00ednh n\u1eb7ng h\u01a1n v\u00e0 khi\u1ebfn Excel ph\u1ea3i t\u1ed1n th\u1eddi gian \u0111\u1ecdc, ghi d\u1eef li\u1ec7u.<\/p>\n

    \n
  • \u1ea2nh minh h\u1ecda k\u00edch th\u01b0\u1edbc l\u1edbn ho\u1eb7c nhi\u1ec1u \u0111\u1ed1i t\u01b0\u1ee3ng \u0111\u1ed3 h\u1ecda \u0111\u01b0\u1ee3c th\u00eam v\u00e0o khi\u1ebfn file t\u0103ng dung l\u01b0\u1ee3ng \u0111\u00e1ng k\u1ec3, l\u00e0m thao t\u00e1c cu\u1ed9n, l\u01b0u v\u00e0 m\u1edf file ch\u1eadm h\u01a1n.<\/li>\n
  • Vi\u1ec7c d\u00f9ng qu\u00e1 nhi\u1ec1u m\u00e0u n\u1ec1n, \u0111\u01b0\u1eddng vi\u1ec1n, ki\u1ec3u b\u1ea3ng, g\u1ed9p \u00f4 ho\u1eb7c t\u00f4 m\u00e0u c\u00f3 \u0111i\u1ec1u ki\u1ec7n khi\u1ebfn Excel ph\u1ea3i qu\u1ea3n l\u00fd m\u1ed9t l\u01b0\u1ee3ng l\u1edbn th\u00f4ng tin \u0111\u1ecbnh d\u1ea1ng, k\u00e9o theo gi\u1ea3m hi\u1ec7u su\u1ea5t.<\/li>\n
  • Nhi\u1ec1u file c\u00f3 v\u00f9ng d\u1eef li\u1ec7u k\u00e9o d\u00e0i \u0111\u1ebfn h\u00e0ng cu\u1ed1i c\u00f9ng ho\u1eb7c c\u1ed9t cu\u1ed1i c\u00f9ng v\u00ec ng\u01b0\u1eddi d\u00f9ng t\u1eebng thao t\u00e1c \u0111\u1ecbnh d\u1ea1ng tr\u00ean nh\u1eefng \u00f4 kh\u00f4ng d\u00f9ng \u0111\u1ebfn. Excel v\u1eabn xem \u0111\u00e2y l\u00e0 khu v\u1ef1c \u0111ang \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng, khi\u1ebfn file n\u1eb7ng b\u1ea5t th\u01b0\u1eddng.<\/li>\n
  • \u0110\u1ecbnh d\u1ea1ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n t\u1ea1o ch\u1ed3ng ch\u00e9o l\u00ean nhau, ho\u1eb7c copy t\u1eeb sheet n\u00e0y sang sheet kh\u00e1c, d\u1eabn \u0111\u1ebfn qu\u00e1 t\u1ea3i v\u00e0 file ph\u1ea3n h\u1ed3i ch\u1eadm.<\/li>\n
  • Excel ph\u1ea3i ki\u1ec3m tra v\u00e0 \u0111\u1ed3ng b\u1ed9 c\u00e1c file ngu\u1ed3n m\u1ed7i khi m\u1edf b\u1ea3ng t\u00ednh. Khi li\u00ean k\u1ebft b\u1ecb h\u1ecfng ho\u1eb7c c\u00f3 qu\u00e1 nhi\u1ec1u ngu\u1ed3n d\u1eef li\u1ec7u, t\u1ed1c \u0111\u1ed9 x\u1eed l\u00fd gi\u1ea3m r\u00f5 r\u1ec7t.<\/li>\n
  • C\u00e1c ph\u1ea1m vi \u0111\u01b0\u1ee3c \u0111\u1eb7t t\u00ean t\u1eeb tr\u01b0\u1edbc nh\u01b0ng kh\u00f4ng c\u00f2n s\u1eed d\u1ee5ng v\u1eabn \u0111\u01b0\u1ee3c l\u01b0u trong file, khi\u1ebfn Excel ph\u1ea3i qu\u1ea3n l\u00fd th\u00eam d\u1eef li\u1ec7u th\u1eeba.<\/li>\n
  • B\u1ea3ng Pivot l\u1ea5y d\u1eef li\u1ec7u t\u1eeb ngu\u1ed3n l\u1edbn ho\u1eb7c c\u00f3 nhi\u1ec1u b\u1ea3n tr\u00edch l\u1ecdc s\u1ebd t\u1ea1o ra t\u1ec7p b\u1ed9 nh\u1edb \u0111\u1ec7m (cache) n\u1eb7ng, l\u00e0m gi\u1ea3m t\u1ed1c \u0111\u1ed9 m\u1edf v\u00e0 l\u01b0u file.<\/li>\n
  • L\u01b0u file \u1edf \u0111\u1ecbnh d\u1ea1ng c\u0169 (.xls) ho\u1eb7c kh\u00f4ng d\u00f9ng d\u1ea1ng nh\u1ecb ph\u00e2n (.xlsb) khi\u1ebfn dung l\u01b0\u1ee3ng t\u0103ng v\u00e0 th\u1eddi gian x\u1eed l\u00fd l\u00e2u h\u01a1n.<\/li>\n<\/ul>\n
    Xem th\u00eam: <\/strong>H\u01b0\u1edbng d\u1eabn c\u00e1ch g\u1ea1ch ngang ch\u1eef trong Excel c\u1ef1c nhanh ch\u00f3ng<\/div>\n
    \n

    2. C\u00e1ch l\u00e0m gi\u1ea3m dung l\u01b0\u1ee3ng v\u00e0 t\u0103ng t\u1ed1c x\u1eed l\u00fd file Excel<\/h2>\n<\/div>\n
    \n

    2.1. L\u01b0u b\u1ea3ng t\u00ednh d\u01b0\u1edbi \u0111\u1ecbnh d\u1ea1ng t\u1ec7p nh\u1ecb ph\u00e2n<\/h3>\n<\/div>\n

    B\u01b0\u1edbc 1:<\/strong> M\u1edf b\u1ea3ng t\u00ednh b\u1ea1n mu\u1ed1n thao t\u00e1c tr\u00ean Excel.<\/p>\n

    B\u01b0\u1edbc 2:<\/strong> Khi file \u0111\u00e3 \u0111\u01b0\u1ee3c m\u1edf, v\u00e0o m\u1ee5c File<\/strong> \u1edf g\u00f3c tr\u00e1i m\u00e0n h\u00ecnh.<\/p>\n

    \"Ch\u1ecdnCh\u1ecdn m\u1ee5c File trong Excel<\/em><\/p>\n

    B\u01b0\u1edbc 3:<\/strong> Ch\u1ecdn Save As<\/strong> \u0111\u1ec3 l\u01b0u th\u00e0nh m\u1ed9t phi\u00ean b\u1ea3n m\u1edbi.<\/p>\n

    \"Ch\u1ecdnCh\u1ecdn Save As trong Excel \u0111\u1ec3 t\u1ea1o b\u1ea3n l\u01b0u m\u1edbi<\/em><\/p>\n

    B\u01b0\u1edbc 4:<\/strong> Nh\u1eadp t\u00ean mong mu\u1ed1n cho file trong \u00f4 \u0111\u1eb7t t\u00ean.<\/p>\n

    B\u01b0\u1edbc 5:<\/strong> T\u1ea1i ph\u1ea7n File Format<\/em> (ho\u1eb7c Save as type<\/em>), nh\u1ea5p v\u00e0o danh s\u00e1ch th\u1ea3 xu\u1ed1ng \u0111\u1ec3 ch\u1ecdn \u0111\u1ecbnh d\u1ea1ng.<\/p>\n

    B\u01b0\u1edbc 6: <\/strong>Ch\u1ecdn Excel Binary Workbook (.xlsb)<\/strong>. \u0110\u00e2y l\u00e0 \u0111\u1ecbnh d\u1ea1ng gi\u00fap gi\u1ea3m dung l\u01b0\u1ee3ng \u0111\u00e1ng k\u1ec3 so v\u1edbi file .xlsx ho\u1eb7c .xls.<\/p>\n

    \"Ch\u1ecdnCh\u1ecdn \u0111\u1ecbnh d\u1ea1ng Excel Binary Workbook \u0111\u1ec3 gi\u1ea3m dung l\u01b0\u1ee3ng file<\/em><\/p>\n

    B\u01b0\u1edbc 7:<\/strong> Nh\u1ea5n Save<\/em> \u0111\u1ec3 ho\u00e0n t\u1ea5t. File m\u1edbi s\u1ebd \u0111\u01b0\u1ee3c l\u01b0u v\u1edbi k\u00edch th\u01b0\u1edbc nh\u1ecf h\u01a1n v\u00e0 th\u01b0\u1eddng m\u1edf nhanh h\u01a1n.<\/p>\n

    \"Nh\u1ea5nNh\u1ea5n Save \u0111\u1ec3 ho\u00e0n t\u1ea5t l\u01b0u file d\u01b0\u1edbi d\u1ea1ng .xlsb<\/em><\/p>\n

    \n

    2.2. Lo\u1ea1i b\u1ecf \u0111\u1ecbnh d\u1ea1ng \u1edf c\u00e1c h\u00e0ng v\u00e0 c\u1ed9t tr\u1ed1ng<\/h3>\n<\/div>\n

    B\u01b0\u1edbc 1: M\u1edf file Excel c\u1ea7n x\u1eed l\u00fd<\/h4>\n

    Kh\u1edfi \u0111\u1ed9ng Excel, v\u00e0o m\u1ee5c File \u2192 Open<\/strong> v\u00e0 ch\u1ecdn b\u1ea3ng t\u00ednh b\u1ea1n mu\u1ed1n thao t\u00e1c.<\/p>\n

    B\u01b0\u1edbc 2: Ch\u1ecdn to\u00e0n b\u1ed9 c\u00e1c h\u00e0ng tr\u1ed1ng b\u00ean d\u01b0\u1edbi d\u1eef li\u1ec7u<\/h4>\n
      \n
    • T\u00ecm h\u00e0ng tr\u1ed1ng \u0111\u1ea7u ti\u00ean<\/strong> ngay d\u01b0\u1edbi v\u00f9ng d\u1eef li\u1ec7u.<\/li>\n
    • Nh\u1ea5p v\u00e0o s\u1ed1 th\u1ee9 t\u1ef1 c\u1ee7a h\u00e0ng \u0111\u00f3<\/strong> (kh\u00f4ng nh\u1ea5p v\u00e0o \u00f4).<\/li>\n
    • Nh\u1ea5n Ctrl + Shift + \u2193<\/strong> (Windows) ho\u1eb7c Command + Shift + \u2193<\/strong> (Mac) \u0111\u1ec3 b\u00f4i ch\u1ecdn t\u1ea5t c\u1ea3 c\u00e1c h\u00e0ng tr\u1ed1ng ph\u00eda d\u01b0\u1edbi.<\/li>\n<\/ul>\n

      \"Ch\u1ecdnCh\u1ecdn to\u00e0n b\u1ed9 h\u00e0ng tr\u1ed1ng b\u00ean d\u01b0\u1edbi d\u1eef li\u1ec7u<\/em><\/p>\n

      B\u01b0\u1edbc 3: X\u00f3a \u0111\u1ecbnh d\u1ea1ng tr\u00ean c\u00e1c h\u00e0ng tr\u1ed1ng<\/h4>\n
        \n
      • V\u00e0o th\u1ebb Home <\/strong>(Windows) ho\u1eb7c Edit <\/strong>(Mac).<\/li>\n
      • Nh\u1ea5n Clear<\/strong>.<\/li>\n
      • Ch\u1ecdn Clear All<\/strong> \u0111\u1ec3 x\u00f3a ho\u00e0n to\u00e0n \u0111\u1ecbnh d\u1ea1ng c\u00f2n s\u00f3t l\u1ea1i tr\u00ean c\u00e1c h\u00e0ng kh\u00f4ng s\u1eed d\u1ee5ng.<\/li>\n<\/ul>\n

        \"X\u00f3aX\u00f3a \u0111\u1ecbnh d\u1ea1ng th\u1eeba \u1edf h\u00e0ng tr\u1ed1ng b\u1eb1ng Clear All<\/em><\/p>\n

        B\u01b0\u1edbc 4: Ch\u1ecdn to\u00e0n b\u1ed9 c\u00e1c c\u1ed9t tr\u1ed1ng b\u00ean ph\u1ea3i d\u1eef li\u1ec7u<\/h4>\n
          \n
        • T\u00ecm c\u1ed9t tr\u1ed1ng \u0111\u1ea7u ti\u00ean<\/strong> b\u00ean ph\u1ea3i v\u00f9ng d\u1eef li\u1ec7u.<\/li>\n
        • Nh\u1ea5p v\u00e0o ch\u1eef c\u00e1i t\u00ean c\u1ed9t<\/strong> (A, B, C\u2026).<\/li>\n
        • Nh\u1ea5n Ctrl + Shift + \u2192<\/strong> (Windows) ho\u1eb7c Command + Shift + \u2192<\/strong> (Mac) \u0111\u1ec3 ch\u1ecdn to\u00e0n b\u1ed9 c\u1ed9t tr\u1ed1ng.<\/li>\n<\/ul>\n

          \"Ch\u1ecdnCh\u1ecdn to\u00e0n b\u1ed9 c\u1ed9t tr\u1ed1ng b\u00ean ph\u1ea3i d\u1eef li\u1ec7u<\/em><\/p>\n

          B\u01b0\u1edbc 5: X\u00f3a \u0111\u1ecbnh d\u1ea1ng tr\u00ean c\u00e1c c\u1ed9t tr\u1ed1ng<\/h4>\n
            \n
          • V\u00e0o th\u1ebb Home\/Edit<\/strong>.<\/li>\n
          • Nh\u1ea5n Clear<\/strong>.<\/li>\n
          • Ch\u1ecdn Clear All<\/strong> \u0111\u1ec3 lo\u1ea1i b\u1ecf to\u00e0n b\u1ed9 \u0111\u1ecbnh d\u1ea1ng \u1edf nh\u1eefng c\u1ed9t kh\u00f4ng d\u00f9ng \u0111\u1ebfn.<\/li>\n<\/ul>\n

            \"X\u00f3aX\u00f3a \u0111\u1ecbnh d\u1ea1ng th\u1eeba \u1edf c\u00e1c c\u1ed9t tr\u1ed1ng b\u1eb1ng Clear All<\/em><\/p>\n

            Sau khi thao t\u00e1c, t\u1ea5t c\u1ea3 \u0111\u1ecbnh d\u1ea1ng th\u1eeba \u1edf h\u00e0ng v\u00e0 c\u1ed9t tr\u1ed1ng \u0111\u00e3 \u0111\u01b0\u1ee3c lo\u1ea1i b\u1ecf, gi\u00fap file nh\u1eb9 h\u01a1n v\u00e0 Excel x\u1eed l\u00fd nhanh h\u01a1n.<\/p>\n

            \n

            2.3. X\u00f3a \u0111\u1ecbnh d\u1ea1ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n<\/h3>\n<\/div>\n

            B\u01b0\u1edbc 1: M\u1edf file v\u00e0 v\u00e0o th\u1ebb Home<\/h4>\n

            Kh\u1edfi \u0111\u1ed9ng Excel, m\u1edf b\u1ea3ng t\u00ednh c\u1ea7n x\u1eed l\u00fd, sau \u0111\u00f3 chuy\u1ec3n sang th\u1ebb Home tr\u00ean thanh menu.<\/p>\n

            B\u01b0\u1edbc 2: Truy c\u1eadp Conditional Formatting<\/h4>\n

            Trong nh\u00f3m Styles, ch\u1ecdn Conditional Formatting \u0111\u1ec3 m\u1edf c\u00e1c t\u00f9y ch\u1ecdn li\u00ean quan \u0111\u1ebfn \u0111\u1ecbnh d\u1ea1ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n.<\/p>\n

            B\u01b0\u1edbc 3: X\u00f3a to\u00e0n b\u1ed9 quy t\u1eafc \u0111\u1ecbnh d\u1ea1ng<\/h4>\n

            Ch\u1ecdn Clear Rules \u2192 Clear Rules from Entire Sheet \u0111\u1ec3 lo\u1ea1i b\u1ecf t\u1ea5t c\u1ea3 quy t\u1eafc \u0111\u1ecbnh d\u1ea1ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n tr\u00ean sheet.<\/p>\n

            \"C\u00e1cM\u1edf Conditional Formatting v\u00e0 x\u00f3a to\u00e0n b\u1ed9 quy t\u1eafc \u0111\u1ecbnh d\u1ea1ng trong Excel<\/em><\/p>\n

            Thao t\u00e1c n\u00e0y s\u1ebd lo\u1ea1i b\u1ecf t\u1ea5t c\u1ea3 \u0111\u1ecbnh d\u1ea1ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n tr\u00ean to\u00e0n b\u1ed9 trang t\u00ednh, gi\u00fap Excel ch\u1ea1y nh\u1eb9 v\u00e0 \u1ed5n \u0111\u1ecbnh h\u01a1n.<\/p>\n

            \n

            2.4. G\u1ee1 \u0111\u1ecbnh d\u1ea1ng kh\u1ecfi \u00f4 tr\u1ed1ng tr\u00ean m\u00e1y Mac<\/h3>\n<\/div>\n

            B\u01b0\u1edbc 1: M\u1edf file Excel v\u00e0 truy c\u1eadp m\u1ee5c Edit<\/h4>\n

            Kh\u1edfi \u0111\u1ed9ng Excel, m\u1edf b\u1ea3ng t\u00ednh c\u1ea7n x\u1eed l\u00fd b\u1eb1ng c\u00e1ch v\u00e0o File \u2192 Open. Khi file \u0111\u00e3 m\u1edf, ch\u1ecdn Edit tr\u00ean thanh menu \u0111\u1ec3 b\u1eaft \u0111\u1ea7u thao t\u00e1c.<\/p>\n

            \"TruyTruy c\u1eadp menu Edit trong Excel tr\u00ean Mac<\/em><\/p>\n

            B\u01b0\u1edbc 2: T\u00ecm v\u00e0 ch\u1ecdn to\u00e0n b\u1ed9 \u00f4 tr\u1ed1ng<\/h4>\n

            Trong menu Edit, ch\u1ecdn Find \u2192 Go To.<\/p>\n

            \"M\u1edfM\u1edf m\u1ee5c Find v\u00e0 ch\u1ecdn Go To trong menu Edit<\/em><\/p>\n

            \u1ede c\u1eeda s\u1ed5 m\u1edbi xu\u1ea5t hi\u1ec7n, nh\u1ea5p v\u00e0o Special, sau \u0111\u00f3 ch\u1ecdn Blanks r\u1ed3i nh\u1ea5n OK.<\/p>\n

            \"Ch\u1ecdnCh\u1ecdn Blanks trong Go To Special v\u00e0 nh\u1ea5n OK<\/em><\/p>\n

            Ngay l\u1eadp t\u1ee9c, t\u1ea5t c\u1ea3 \u00f4 tr\u1ed1ng trong v\u00f9ng d\u1eef li\u1ec7u s\u1ebd \u0111\u01b0\u1ee3c b\u00f4i s\u00e1ng.<\/p>\n

            B\u01b0\u1edbc 3: X\u00f3a \u0111\u1ecbnh d\u1ea1ng c\u1ee7a c\u00e1c \u00f4 tr\u1ed1ng<\/h4>\n

            Quay l\u1ea1i menu Edit, ch\u1ecdn Clear, r\u1ed3i nh\u1ea5n Format \u0111\u1ec3 xo\u00e1 to\u00e0n b\u1ed9 \u0111\u1ecbnh d\u1ea1ng \u0111ang \u00e1p d\u1ee5ng cho nh\u1eefng \u00f4 tr\u1ed1ng n\u00e0y.<\/p>\n

            \"X\u00f3aX\u00f3a \u0111\u1ecbnh d\u1ea1ng c\u00e1c \u00f4 tr\u1ed1ng<\/em><\/p>\n

            \n

            2.5. N\u00e9n h\u00ecnh \u1ea3nh \u0111\u01b0\u1ee3c ch\u00e8n trong b\u1ea3ng t\u00ednh<\/h3>\n<\/div>\n

            B\u01b0\u1edbc 1: M\u1edf b\u1ea3ng t\u00ednh ch\u1ee9a h\u00ecnh c\u1ea7n gi\u1ea3m dung l\u01b0\u1ee3ng<\/h4>\n

            Kh\u1edfi ch\u1ea1y Excel v\u00e0 m\u1edf file c\u00f3 c\u00e1c \u1ea3nh b\u1ea1n mu\u1ed1n t\u1ed1i \u01b0u.<\/p>\n

            B\u01b0\u1edbc 2: Ch\u1ecdn c\u00f4ng c\u1ee5 n\u00e9n \u1ea3nh<\/h4>\n

            Nh\u1ea5p v\u00e0o b\u1ea5t k\u1ef3 h\u00ecnh n\u00e0o trong trang t\u00ednh, sau \u0111\u00f3 chuy\u1ec3n sang th\u1ebb Format<\/strong> (ho\u1eb7c Picture Format). Ti\u1ebfp t\u1ee5c ch\u1ecdn Compress Pictures<\/strong>.<\/p>\n

            B\u01b0\u1edbc 3: Thi\u1ebft l\u1eadp ch\u1ebf \u0111\u1ed9 n\u00e9n v\u00e0 \u00e1p d\u1ee5ng<\/h4>\n

            B\u1ecf d\u1ea5u ch\u1ecdn \u1edf m\u1ee5c Apply only to this picture<\/strong> \u0111\u1ec3 n\u00e9n to\u00e0n b\u1ed9 h\u00ecnh trong file.<\/p>\n

            Trong ph\u1ea7n \u0111\u1ed9 ph\u00e2n gi\u1ea3i, ch\u1ecdn Email (96 ppi): minimize document size for sharing<\/strong>, r\u1ed3i nh\u1ea5n OK \u0111\u1ec3 ho\u00e0n t\u1ea5t.<\/p>\n

            \"C\u00e1cS\u1eed d\u1ee5ng Format v\u00e0 Compress Pictures \u0111\u1ec3 n\u00e9n h\u00ecnh trong Excel<\/em><\/p>\n

            \n

            2.6. Lo\u1ea1i b\u1ecf c\u00e1c li\u00ean k\u1ebft d\u1eef li\u1ec7u (Data Links)<\/h3>\n<\/div>\n

            C\u00e1c data link<\/strong> trong Excel l\u00e0 nh\u1eefng li\u00ean k\u1ebft d\u1eabn \u0111\u1ebfn t\u1ec7p b\u00ean ngo\u00e0i, gi\u00fap c\u1eadp nh\u1eadt ho\u1eb7c tham chi\u1ebfu d\u1eef li\u1ec7u t\u1eeb ngu\u1ed3n kh\u00e1c. Tuy nhi\u00ean, n\u1ebfu b\u1ea3ng t\u00ednh ch\u1ee9a qu\u00e1 nhi\u1ec1u li\u00ean k\u1ebft d\u1ea1ng n\u00e0y, dung l\u01b0\u1ee3ng file s\u1ebd t\u0103ng v\u00e0 Excel c\u00f3 th\u1ec3 x\u1eed l\u00fd ch\u1eadm h\u01a1n. B\u1ea1n n\u00ean lo\u1ea1i b\u1ecf nh\u1eefng li\u00ean k\u1ebft kh\u00f4ng c\u00f2n s\u1eed d\u1ee5ng theo h\u01b0\u1edbng d\u1eabn sau:<\/p>\n

            B\u01b0\u1edbc 1:<\/strong> M\u1edf b\u1ea3ng t\u00ednh c\u1ea7n x\u1eed l\u00fd, v\u00e0o th\u1ebb Data, ch\u1ecdn Edit Links, sau \u0111\u00f3 ch\u1ecdn li\u00ean k\u1ebft b\u1ea1n mu\u1ed1n lo\u1ea1i b\u1ecf v\u00e0 nh\u1ea5n Break Link.<\/p>\n

            \"C\u00e1cNh\u1ea5n Break Link \u0111\u1ec3 x\u00f3a li\u00ean k\u1ebft d\u1eef li\u1ec7u<\/em><\/p>\n

            B\u01b0\u1edbc 2:<\/strong> Khi Excel y\u00eau c\u1ea7u x\u00e1c nh\u1eadn, ti\u1ebfp t\u1ee5c nh\u1ea5n Break Link<\/strong> l\u1ea7n n\u1eefa \u0111\u1ec3 ho\u00e0n t\u1ea5t vi\u1ec7c ng\u1eaft li\u00ean k\u1ebft.<\/p>\n

            \n

            2.7. X\u00f3a c\u1eeda s\u1ed5 theo d\u00f5i (Watch Window)<\/h3>\n<\/div>\n

            B\u01b0\u1edbc 1:<\/strong> M\u1edf b\u1ea3ng t\u00ednh m\u00e0 b\u1ea1n mu\u1ed1n lo\u1ea1i b\u1ecf Watch Window \u0111\u1ec3 b\u1eaft \u0111\u1ea7u thao t\u00e1c.<\/p>\n

            B\u01b0\u1edbc 2: <\/strong>Tr\u00ean thanh menu, chuy\u1ec3n sang th\u1ebb Formulas<\/strong>, sau \u0111\u00f3 ch\u1ecdn Watch Window<\/strong> \u0111\u1ec3 m\u1edf danh s\u00e1ch c\u00e1c \u00f4 \u0111ang \u0111\u01b0\u1ee3c theo d\u00f5i.<\/p>\n

            B\u01b0\u1edbc 3:<\/strong> Trong c\u1eeda s\u1ed5 Watch Window, ch\u1ecdn m\u1ee5c c\u1ea7n x\u00f3a r\u1ed3i nh\u1ea5n Delete Watch<\/strong>.<\/p>\n

            \"X\u00f3aX\u00f3a m\u1ee5c theo d\u00f5i b\u1eb1ng Delete Watch trong Watch Window<\/em><\/p>\n

            Thao t\u00e1c n\u00e0y s\u1ebd g\u1ee1 b\u1ecf to\u00e0n b\u1ed9 theo d\u00f5i \u0111\u00e3 thi\u1ebft l\u1eadp.<\/p>\n

            \n

            2.8. X\u00f3a c\u00e1c ph\u1ea1m vi \u0111\u01b0\u1ee3c \u0111\u1eb7t t\u00ean (Named Range) trong file Excel<\/h3>\n<\/div>\n

            B\u01b0\u1edbc 1:<\/strong> M\u1edf b\u1ea3ng t\u00ednh ch\u1ee9a c\u00e1c Named Range m\u00e0 b\u1ea1n c\u1ea7n ki\u1ec3m tra v\u00e0 x\u00f3a.<\/p>\n

            B\u01b0\u1edbc 2:<\/strong> Tr\u00ean thanh menu, v\u00e0o th\u1ebb Formulas<\/strong>, sau \u0111\u00f3 ch\u1ecdn Name Manager<\/strong> \u0111\u1ec3 xem danh s\u00e1ch to\u00e0n b\u1ed9 c\u00e1c v\u00f9ng \u0111\u01b0\u1ee3c \u0111\u1eb7t t\u00ean.<\/p>\n

            \"XemXem danh s\u00e1ch Named Range trong Name Manager<\/em><\/p>\n

            B\u01b0\u1edbc 3: <\/strong>T\u00ecm nh\u1eefng t\u00ean \u0111\u00e3 l\u1ed7i ho\u1eb7c kh\u00f4ng c\u00f2n s\u1eed d\u1ee5ng, ch\u1ecdn ch\u00fang v\u00e0 nh\u1ea5n Delete <\/strong>\u0111\u1ec3 lo\u1ea1i b\u1ecf.<\/p>\n

            \"Ch\u1ecdnCh\u1ecdn t\u00ean l\u1ed7i v\u00e0 nh\u1ea5n Delete trong Name Manager<\/em><\/p>\n

            B\u01b0\u1edbc 4:<\/strong> Nh\u1ea5n OK <\/strong>\u0111\u1ec3 x\u00e1c nh\u1eadn thao t\u00e1c v\u00e0 ho\u00e0n t\u1ea5t vi\u1ec7c x\u00f3a Named Range.<\/p>\n

            \"B\u1ea5mX\u00e1c nh\u1eadn x\u00f3a Named Range b\u1eb1ng OK v\u00e0 \u0111\u00f3ng c\u1eeda s\u1ed5<\/em><\/p>\n

            \n

            2.9. Gi\u1ea3m dung l\u01b0\u1ee3ng file Excel b\u1eb1ng ph\u1ea7n m\u1ec1m<\/h3>\n<\/div>\n

            B\u00ean c\u1ea1nh c\u00e1c thao t\u00e1c t\u1ed1i \u01b0u tr\u1ef1c ti\u1ebfp trong Excel, b\u1ea1n c\u0169ng c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng th\u00eam nh\u1eefng ph\u1ea7n m\u1ec1m h\u1ed7 tr\u1ee3 n\u00e9n file chuy\u00ean d\u1ee5ng \u0111\u1ec3 l\u00e0m nh\u1eb9 b\u1ea3ng t\u00ednh. M\u1ed9t s\u1ed1 c\u00f4ng c\u1ee5 th\u01b0\u1eddng \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng g\u1ed3m:<\/p>\n

              \n
            • NXPowerLite Desktop:<\/strong> https:\/\/neuxpower.com\/nxpowerlite-desktop\/<\/li>\n
            • FILEminimizer Office:<\/strong> https:\/\/balesio.com\/fileminimizer\/eng\/index.php<\/li>\n<\/ul>\n

              Nh\u1eefng \u1ee9ng d\u1ee5ng n\u00e0y gi\u00fap r\u00fat g\u1ecdn k\u00edch th\u01b0\u1edbc file nhanh v\u00e0 ti\u1ec7n, tuy nhi\u00ean b\u1ea1n c\u1ea7n c\u00e0i \u0111\u1eb7t v\u00e0o m\u00e1y. M\u1ed9t v\u00e0i c\u00f4ng c\u1ee5 c\u00f2n y\u00eau c\u1ea7u tr\u1ea3 ph\u00ed, v\u00ec v\u1eady b\u1ea1n n\u00ean \u01b0u ti\u00ean th\u1eed c\u00e1c c\u00e1ch t\u1ed1i \u01b0u ngay trong Excel tr\u01b0\u1edbc. N\u1ebfu c\u00e1c ph\u01b0\u01a1ng ph\u00e1p n\u1ed9i b\u1ed9 kh\u00f4ng mang l\u1ea1i k\u1ebft qu\u1ea3, l\u00fac \u0111\u00f3 m\u1edbi c\u00e2n nh\u1eafc d\u00f9ng ph\u1ea7n m\u1ec1m n\u00e9n nh\u01b0 l\u1ef1a ch\u1ecdn cu\u1ed1i c\u00f9ng.<\/p>\n

              \n

              2.10. N\u00e9n t\u1eadp tin<\/h3>\n<\/div>\n

              N\u00e9n file Excel th\u00e0nh t\u1ec7p ZIP c\u00f3 th\u1ec3 gi\u00fap gi\u1ea3m dung l\u01b0\u1ee3ng kho\u1ea3ng 10% \u0111\u1ebfn 15%. C\u00e1ch n\u00e0y kh\u00f4ng l\u00e0m Excel ch\u1ea1y nhanh h\u01a1n, nh\u01b0ng l\u1ea1i r\u1ea5t h\u1eefu \u00edch khi b\u1ea1n c\u1ea7n g\u1eedi t\u00e0i li\u1ec7u qua email ho\u1eb7c chia s\u1ebb online v\u00ec k\u00edch th\u01b0\u1edbc t\u1ec7p nh\u1ecf h\u01a1n \u0111\u00e1ng k\u1ec3. B\u1ea1n ch\u1ec9 c\u1ea7n th\u1ef1c hi\u1ec7n theo c\u00e1c b\u01b0\u1edbc sau:<\/p>\n

              B\u01b0\u1edbc 1: <\/strong>M\u1edf th\u01b0 m\u1ee5c ch\u1ee9a file Excel c\u1ea7n n\u00e9n.<\/p>\n

              B\u01b0\u1edbc 2:<\/strong> Nh\u1ea5p chu\u1ed9t ph\u1ea3i v\u00e0o file Excel.<\/p>\n

              B\u01b0\u1edbc 3: <\/strong>Ch\u1ecdn Send to (G\u1eedi \u0111\u1ebfn).<\/p>\n

              B\u01b0\u1edbc 4:<\/strong> Ch\u1ecdn Compressed (zipped) folder.<\/p>\n

              \"C\u00e1cThao t\u00e1c ch\u1ecdn Send to v\u00e0 t\u1ea1o t\u1ec7p ZIP \u0111\u1ec3 n\u00e9n file Excel<\/em><\/p>\n

              \n

              2.11. X\u00f3a b\u1ed9 nh\u1edb \u0111\u1ec7m Pivot<\/h3>\n<\/div>\n

              Khi b\u1ea1n t\u1ea1o m\u1ed9t PivotTable, Excel s\u1ebd t\u1ea1o k\u00e8m m\u1ed9t Pivot Cache. \u0110\u00e2y l\u00e0 b\u1ea3n sao c\u1ee7a to\u00e0n b\u1ed9 d\u1eef li\u1ec7u g\u1ed1c m\u00e0 PivotTable d\u00f9ng \u0111\u1ec3 x\u1eed l\u00fd v\u00e0 hi\u1ec3n th\u1ecb k\u1ebft qu\u1ea3. PivotTable ch\u1ec9 l\u00e0m vi\u1ec7c v\u1edbi Pivot Cache, kh\u00f4ng l\u00e0m vi\u1ec7c tr\u1ef1c ti\u1ebfp v\u1edbi ngu\u1ed3n d\u1eef li\u1ec7u. V\u00ec v\u1eady, n\u1ebfu d\u1eef li\u1ec7u l\u1edbn, Pivot Cache c\u0169ng s\u1ebd l\u1edbn theo v\u00e0 l\u00e0m t\u0103ng dung l\u01b0\u1ee3ng file. Tr\u01b0\u1edbc khi l\u01b0u, vi\u1ec7c lo\u1ea1i b\u1ecf d\u1eef li\u1ec7u tr\u00f9ng l\u1eb7p ho\u1eb7c kh\u00f4ng c\u1ea7n thi\u1ebft s\u1ebd gi\u00fap t\u1ec7p nh\u1eb9 h\u01a1n.<\/p>\n

              \u0110\u1ec3 gi\u1ea3m k\u00edch th\u01b0\u1edbc file m\u00e0 v\u1eabn gi\u1eef nguy\u00ean d\u1eef li\u1ec7u g\u1ed1c, b\u1ea1n c\u00f3 th\u1ec3 t\u1eaft ch\u1ee9c n\u0103ng l\u01b0u Pivot Cache khi l\u01b0u t\u1ec7p:<\/p>\n

              B\u01b0\u1edbc 1: <\/strong>M\u1edf file Excel c\u00f3 ch\u1ee9a PivotTable, sau \u0111\u00f3 nh\u1ea5p v\u00e0o m\u1ed9t \u00f4 b\u1ea5t k\u1ef3 trong b\u1ea3ng Pivot \u0111\u1ec3 k\u00edch ho\u1ea1t c\u00e1c t\u00f9y ch\u1ecdn c\u1ee7a PivotTable.<\/p>\n

              B\u01b0\u1edbc 2:<\/strong> Ch\u1ecdn PivotTable Options tr\u00ean thanh c\u00f4ng c\u1ee5.<\/p>\n

              B\u01b0\u1edbc 3:<\/strong> M\u1edf tab Data<\/strong>.<\/p>\n

              B\u01b0\u1edbc 4:<\/strong> B\u1ecf ch\u1ecdn Save source data with file<\/strong> \u0111\u1ec3 Excel kh\u00f4ng l\u01b0u Pivot Cache theo t\u1ec7p.<\/p>\n

              B\u01b0\u1edbc 5:<\/strong> (T\u00f9y ch\u1ecdn) B\u1eadt Refresh data when opening the file<\/strong> n\u1ebfu b\u1ea1n mu\u1ed1n PivotTable t\u1ef1 l\u00e0m m\u1edbi khi m\u1edf file.<\/p>\n

              \"T\u1eaftT\u1eaft l\u01b0u Pivot Cache trong PivotTable Options \u0111\u1ec3 gi\u1ea3m dung l\u01b0\u1ee3ng file<\/em><\/p>\n

              Xem th\u00eam: <\/strong>So s\u00e1nh h\u00e0m FIND v\u00e0 SEARCH trong Excel: Kh\u00e1c nhau nh\u01b0 th\u1ebf n\u00e0o?<\/div>\n
              \n

              3. L\u1ee3i \u00edch c\u1ee7a vi\u1ec7c gi\u1ea3m dung l\u01b0\u1ee3ng file Excel<\/h2>\n<\/div>\n

              Gi\u1ea3m dung l\u01b0\u1ee3ng b\u1ea3ng t\u00ednh kh\u00f4ng ch\u1ec9 gi\u00fap c\u00f4ng vi\u1ec7c tr\u1edf n\u00ean nh\u1eb9 nh\u00e0ng h\u01a1n, m\u00e0 c\u00f2n mang l\u1ea1i nhi\u1ec1u l\u1ee3i \u00edch thi\u1ebft th\u1ef1c trong qu\u00e1 tr\u00ecnh s\u1eed d\u1ee5ng Excel. D\u01b0\u1edbi \u0111\u00e2y l\u00e0 nh\u1eefng \u0111i\u1ec3m n\u1ed5i b\u1eadt m\u00e0 b\u1ea1n s\u1ebd nh\u1eadn \u0111\u01b0\u1ee3c khi t\u1ed1i \u01b0u k\u00edch th\u01b0\u1edbc t\u1ec7p:<\/p>\n

                \n
              • Gi\u00fap Excel x\u1eed l\u00fd nhanh h\u01a1n, gi\u1ea3m t\u00ecnh tr\u1ea1ng treo ho\u1eb7c ph\u1ea3n h\u1ed3i ch\u1eadm.<\/li>\n
              • D\u1ec5 d\u00e0ng g\u1eedi file qua email, chia s\u1ebb online ho\u1eb7c t\u1ea3i l\u00ean h\u1ec7 th\u1ed1ng.<\/li>\n
              • Kh\u00f4ng c\u1ea7n c\u00e0i th\u00eam ph\u1ea7n m\u1ec1m n\u00e9n, thao t\u00e1c t\u1ed1i \u01b0u ngay trong Excel v\u1eabn hi\u1ec7u qu\u1ea3.<\/li>\n<\/ul>\n

                T\u1ed1i \u01b0u dung l\u01b0\u1ee3ng gi\u00fap file Excel nh\u1eb9, d\u1ec5 chia s\u1ebb v\u00e0 ho\u1ea1t \u0111\u1ed9ng m\u01b0\u1ee3t h\u01a1n trong m\u1ecdi t\u00e1c v\u1ee5. B\u1ea1n c\u00f3 th\u1ec3 \u00e1p d\u1ee5ng t\u1eebng b\u01b0\u1edbc \u1edf tr\u00ean \u0111\u1ec3 c\u1ea3i thi\u1ec7n hi\u1ec7u su\u1ea5t ngay l\u1eadp t\u1ee9c. \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 m\u1eb9o hay kh\u00e1c.<\/p>\n

                N\u1ebfu b\u1ea1n \u0111ang t\u00ecm ki\u1ebfm c\u00e1c ph\u1ee5 ki\u1ec7n vi t\u00ednh b\u1ec1n b\u1ec9 v\u00e0 ph\u00f9 h\u1ee3p cho c\u00f4ng vi\u1ec7c h\u1eb1ng ng\u00e0y, h\u00e3y gh\u00e9 Si\u00eau Th\u1ecb \u0110i\u1ec7n M\u00e1y – N\u1ed9i Th\u1ea5t Ch\u1ee3 L\u1edbn \u0111\u1ec3 ch\u1ecdn ngay nh\u1eefng s\u1ea3n ph\u1ea9m h\u1ed7 tr\u1ee3 l\u00e0m vi\u1ec7c hi\u1ec7u qu\u1ea3 h\u01a1n.<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"

                File Excel qu\u00e1 n\u1eb7ng d\u1ec5 khi\u1ebfn thao t\u00e1c ch\u1eadm, m\u1edf file l\u00e2u v\u00e0 kh\u00f3 chia s\u1ebb. B\u00e0i vi\u1ebft n\u00e0y h\u01b0\u1edbng d\u1eabn b\u1ea1n c\u00e1c c\u00e1ch t\u1ed1i \u01b0u dung l\u01b0\u1ee3ng nh\u01b0 x\u00f3a \u0111\u1ecbnh d\u1ea1ng th\u1eeba, lo\u1ea1i b\u1ecf li\u00ean k\u1ebft, n\u00e9n h\u00ecnh \u1ea3nh v\u00e0 tinh ch\u1ec9nh PivotTable \u0111\u1ec3 b\u1ea3ng t\u00ednh ch\u1ea1y nh\u1eb9 v\u00e0 m\u01b0\u1ee3t h\u01a1n. H\u01b0\u1edbng d\u1eabn c\u00e1ch […]<\/p>\n","protected":false},"author":1,"featured_media":4596,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[8],"tags":[],"class_list":["post-4595","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\/19277.jpg","_links":{"self":[{"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/posts\/4595","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=4595"}],"version-history":[{"count":0,"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/posts\/4595\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/media\/4596"}],"wp:attachment":[{"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/media?parent=4595"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/categories?post=4595"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/tags?post=4595"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}