{"id":47239,"date":"2023-12-16T16:58:38","date_gmt":"2023-12-16T16:58:38","guid":{"rendered":"https:\/\/masterskills.org\/blog\/10-thu-thuat-tin-hoc-van-phong-tiet-kiem-thoi-gian-nang-cao-hieu-suat.html"},"modified":"2023-12-16T16:58:38","modified_gmt":"2023-12-16T16:58:38","slug":"10-thu-thuat-tin-hoc-van-phong-tiet-kiem-thoi-gian-nang-cao-hieu-suat","status":"publish","type":"post","link":"https:\/\/masterskills.org\/blog\/10-thu-thuat-tin-hoc-van-phong-tiet-kiem-thoi-gian-nang-cao-hieu-suat.html","title":{"rendered":"10 Th\u1ee7 Thu\u1eadt Tin H\u1ecdc V\u0103n Ph\u00f2ng Ti\u1ebft Ki\u1ec7m Th\u1eddi Gian, N\u00e2ng Cao Hi\u1ec7u Su\u1ea5t"},"content":{"rendered":"
\n

Khi c\u00f4ng ngh\u1ec7 th\u00f4ng tin ng\u00e0y c\u00e0ng ph\u00e1t tri\u1ec3n nhu c\u1ea7u \u1ee9ng d\u1ee5ng tin h\u1ecdc v\u00e0o qu\u00e1 tr\u00ecnh l\u00e0m vi\u1ec7c ng\u00e0y \u0111\u01b0\u1ee3c m\u1ed9t quan t\u00e2m. Ch\u00ednh v\u00ec th\u1ebf vi\u1ec7c n\u1eafm r\u00f5 c\u00e1c th\u1ee7 thu\u1eadt tin h\u1ecdc v\u0103n ph\u00f2ng<\/strong> l\u00e0 c\u00e1ch gi\u00fap b\u1ea1n x\u1eed l\u00fd c\u00f4ng vi\u1ec7c nhanh h\u01a1n, d\u1ec5 d\u00e0ng h\u01a1n v\u00e0 \u0111em l\u1ea1i hi\u1ec7u qu\u1ea3 cao trong qu\u00e1 tr\u00ecnh l\u00e0m vi\u1ec7c. V\u1eady c\u00f3 nh\u1eefng th\u1ee7 thu\u1eadt tin h\u1ecdc v\u0103n ph\u00f2ng n\u00e0o c\u1ea7n n\u1eafm? D\u01b0\u1edbi \u0111\u00e2y l\u00e0 10 m\u1eb9o v\u1eb7t tin h\u1ecdc<\/strong> m\u00e0 Masterskills mu\u1ed1n chia s\u1ebb \u0111\u1ebfn b\u1ea1n<\/p>\n

1. Chuy\u1ec3n \u0111\u1ed5i ch\u1eef hoa v\u00e0 ch\u1eef th\u01b0\u1eddng<\/strong><\/h2>\n

\u0110\u1ec3 th\u1ef1c hi\u1ec7n chuy\u1ec3n \u0111\u1ed5i ch\u1eef hoa v\u00e0 ch\u1eef th\u01b0\u1eddng trong file word s\u1ebd b\u1ea1n c\u00f3 th\u1ec3 th\u1ef1c hi\u1ec7n nh\u01b0 sau:<\/p>\n

    \n
  • B\u01b0\u1edbc 1: Ch\u1ecdn ph\u1ea7n v\u0103n b\u1ea3n mu\u1ed1n ch\u1ec9nh s\u1eeda r\u1ed3i nh\u1ea5n chu\u1ed9t ph\u1ea3i -> Ch\u1ecdn Copy\u00a0<\/li>\n
  • B\u01b0\u1edbc 2: Nh\u1ea5n v\u00e0o bi\u1ec3u t\u01b0\u1ee3ng Unikey d\u01b0\u1edbi g\u00f3c ph\u1ea3i m\u00e0n h\u00ecnh \u0111\u1ec3 h\u1ec7 th\u1ed1ng k\u00edch ho\u1ea1t c\u00f4ng c\u1ee5 chuy\u1ec3n \u0111\u1ed5i. Sau \u0111\u00f3 ch\u1ecdn Ctrl + Shift + F6.<\/li>\n
  • B\u01b0\u1edbc 3: Khi h\u1ed9p tho\u1ea1i Unikey Toolkit xu\u1ea5t hi\u1ec7n b\u1ea1n ch\u1ecdn b\u1ea3ng m\u00e3 Ngu\u1ed3n v\u00e0 \u0110\u00edch l\u00e0 Unicode -> Ch\u1ecdn Sang ch\u1eef hoa -> Nh\u1ea5n chuy\u1ec3n m\u00e3 -> Nh\u1ea5n OK \u0111\u1ec3 x\u00e1c nh\u1eadn qu\u00e1 tr\u00ecnh chuy\u1ec3n m\u00e3 th\u00e0nh c\u00f4ng.<\/li>\n<\/ul>\n

    Ngo\u00e0i c\u00e1ch l\u00e0m tr\u00ean, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng ngay t\u1ed5 h\u1ee3p ph\u00edm SHIFT + F3 \u0111\u1ec3 chuy\u1ec3n \u0111\u1ed5i ch\u1eef hoa v\u00e0 ch\u1eef th\u01b0\u1eddng v\u1edbi nhau. C\u00e1ch n\u00e0y kh\u00e1 \u0111\u01a1n gi\u1ea3n b\u1ea1n ch\u1ec9 c\u1ea7n b\u00f4i \u0111en ch\u1ed7 c\u1ea7n chuy\u1ec3n \u0111\u1ed5i ch\u1eef hoa v\u00e0 ch\u1eef th\u01b0\u1eddng l\u00e0 \u0111\u01b0\u1ee3c.\u00a0<\/p>\n

    \n
    \"S\u1eed\"S\u1eed
    S\u1eed d\u1ee5ng SHIFT + F3 \u0111\u1ec3 chuy\u1ec3n \u0111\u1ed5i ch\u1eef hoa v\u00e0 ch\u1eef th\u01b0\u1eddng v\u1edbi nhau<\/figcaption><\/figure>\n<\/div>\n

    2. C\u1ed1 \u0111\u1ecbnh h\u00e0ng ho\u1eb7c c\u1ed9t ti\u00eau \u0111\u1ec1\u00a0<\/strong><\/h2>\n

    Trong qu\u00e1 tr\u00ecnh thao t\u00e1c tr\u00ean file excel, d\u1eef li\u1ec7u trong b\u1ea3ng qu\u00e1 nhi\u1ec1u \u0111i\u1ec1u n\u00e0y khi\u1ebfn cho h\u00e0ng c\u1ed9t v\u00e0 h\u00e0ng ti\u00eau \u0111\u1ec1 c\u1ee7a b\u1ea3ng c\u0169ng ch\u1ea1y theo khi\u1ebfn cho b\u1ea1n g\u1eb7p kh\u00f3 kh\u0103n trong vi\u1ec7c \u0111\u1ed1i chi\u1ebfu s\u1ed1 li\u1ec7u. Do \u0111\u00f3 \u0111\u1ec3 gi\u1ea3i quy\u1ebft v\u1ea5n \u0111\u1ec1 n\u00e0y b\u1ea1n c\u1ea7n ch\u1ecdn c\u00f4ng c\u1ee5 Freeze Panes.<\/p>\n

    \u0110\u1ec3 c\u1ed1 \u0111\u1ecbnh h\u00e0ng ho\u1eb7c c\u1ed9t ti\u00eau \u0111\u1ec1 b\u1ea1n th\u1ef1c hi\u1ec7n nh\u01b0 sau:<\/p>\n

      \n
    • B\u01b0\u1edbc 1: Ch\u1ecdn h\u00e0ng ho\u1eb7c c\u1ed9t ti\u00eau \u0111\u1ec1 trong file d\u1eef li\u1ec7u excel\u00a0<\/li>\n
    • B\u01b0\u1edbc 2: Di chuy\u1ec3n chu\u1ed9t l\u00ean thanh menu -> Ch\u1ecdn VIEW -> Ch\u1ecdn Freeze Panes.\n
        \n
      • Freeze Panes: C\u1ed1 \u0111\u1ecbnh h\u00e0ng v\u00e0 c\u1ed9t khi cu\u1ed9n b\u1ea3ng t\u00ednh, \u0111\u1ec3 th\u1ef1c hi\u1ec7n c\u1ed1 \u0111\u1ecbnh h\u00e0ng ti\u00eau \u0111\u1ec1 v\u00e0 c\u1ed9t ti\u00eau \u0111\u1ec1, b\u1ea1n c\u1ea7n \u0111\u1eb7t con tr\u1ecf chu\u1ed9t sau c\u1ed9t ti\u00eau \u0111\u1ec1 v\u00e0 d\u01b0\u1edbi h\u00e0ng ti\u00eau \u0111\u1ec1.\u00a0<\/li>\n
      • Freeze Top Row: C\u1ed1 \u0111\u1ecbnh h\u00e0ng tr\u00ean c\u00f9ng khi cu\u1ed9n b\u1ea3ng t\u00ednh<\/li>\n
      • Freeze First Column: C\u1ed1 \u0111\u1ecbnh c\u1ed9t \u0111\u1ea7u ti\u00ean khi k\u00e9o b\u1ea3ng t\u00ednh<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n

        \u0110\u1ec3 b\u1ecf l\u1ec7nh Freeze Panes, b\u1ea1n ch\u1ec9 c\u1ea7n v\u00e0o VIEW -> Ch\u1ecdn Unfreeze panes<\/p>\n

        3. L\u1eb7p l\u1ea1i l\u1ec7nh tr\u01b0\u1edbc \u0111\u00f3 v\u1edbi F4\u00a0<\/strong><\/h2>\n

        Ph\u00edm F4 trong c\u00e1c ph\u1ea7n m\u1ec1m v\u0103n ph\u00f2ng th\u00f4ng th\u01b0\u1eddng ch\u00ednh l\u00e0 m\u1ed9t trong s\u1ed1 nh\u1eefng th\u1ee7 thu\u1eadt trong tin h\u1ecdc v\u0103n ph\u00f2ng <\/strong>\u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 gi\u00fap b\u1ea1n l\u1eb7p l\u1ea1i m\u1ed9t l\u1ec7nh \u0111i\u1ec1u khi\u1ec3n m\u00e0 kh\u00f4ng ph\u1ea3i ai c\u0169ng bi\u1ebft.<\/p>\n

        V\u00ed d\u1ee5: N\u1ebfu b\u1ea1n mu\u1ed1n \u0111\u1ecbnh d\u1ea1ng t\u00e0i li\u1ec7u word c\u1ee7a m\u00ecnh b\u1eb1ng c\u00e1ch g\u1ea1ch ch\u00e2n v\u00e0 in \u0111\u1eadm t\u1ea5t c\u1ea3 ti\u00eau \u0111\u1ec1 c\u1ee7a c\u00e1c \u0111o\u1ea1n, th\u00ec h\u00e3y \u0111\u01b0a l\u1ec7nh \u0111i\u1ec1u khi\u1ec3n tr\u00ean ti\u00eau \u0111\u1ec1 \u0111\u1ea7u ti\u00ean b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng menu Format, ti\u1ebfp \u0111\u1ebfn l\u00e0 Font. Sau \u0111\u00f3 ch\u1ec9 c\u1ea7n th\u1ef1c hi\u1ec7n b\u00f4i \u0111en ti\u00eau \u0111\u1ec1 th\u1ee9 2 v\u00e0 \u1ea5n F4 N\u00f3 s\u1ebd th\u1ef1c hi\u1ec7n in \u0111\u1eadm v\u00e0 g\u1ea1ch ch\u00e2n t\u1ef1 \u0111\u1ed9ng cho b\u1ea1n.<\/p>\n

        S\u1eed d\u1ee5ng l\u1eb7p l\u1ea1i l\u1ec7nh tr\u01b0\u1edbc \u0111\u00f3 v\u1edbi F4 l\u00e0 m\u1ed9t trong nh\u1eefng m\u1eb9o v\u1eb7t tin h\u1ecdc<\/strong> \u0111\u01b0\u1ee3c d\u00e2n v\u0103n ph\u00f2ng s\u1eed d\u1ee5ng. V\u00e0 b\u1ea1n c\u1ea7n n\u1eafm r\u00f5 khi l\u00e0m vi\u1ec7c \u0111\u1ec3 qu\u00e1 tr\u00ecnh l\u00e0m vi\u1ec7c \u0111\u01b0\u1ee3c nhanh ch\u00f3ng v\u00e0 \u0111\u1ea1t k\u1ebft qu\u1ea3 cao.\u00a0<\/p>\n

        \n
        \"Ph\u00edm\"Ph\u00edm
        Ph\u00edm F4 d\u00f9ng \u0111\u1ec3 l\u1eb7p l\u1ea1i l\u1ec7nh tr\u01b0\u1edbc \u0111\u00f3<\/figcaption><\/figure>\n<\/div>\n

        4. Thay \u0111\u1ed5i \u0111\u1ecbnh d\u1ea1ng t\u00e0i li\u1ec7u tr\u00ean Word<\/strong><\/h2>\n

        Th\u00f4ng th\u01b0\u1eddng ng\u01b0\u1eddi d\u00f9ng s\u1ebd s\u1eed d\u1ee5ng template Normal.dot \u0111\u1ec3 th\u1ef1c hi\u1ec7n qu\u00e1 tr\u00ecnh ch\u1ec9nh s\u1eeda, \u0111\u1ecbnh d\u1ea1ng v\u0103n b\u1ea3n c\u1ee7a m\u00ecnh. H\u1ea7u h\u1ebft c\u00e1c thay \u0111\u1ed5i \u0111\u01b0\u1ee3c thay \u0111\u1ed5i v\u0129nh vi\u1ec5n b\u1eb1ng vi\u1ec7c s\u1eed d\u1ee5ng Default v\u00e0 Add to Template trong h\u1ea7u h\u1ebft c\u00e1c khung \u0111\u1ecbnh d\u1ea1ng.\u00a0<\/p>\n

        Trong tr\u01b0\u1eddng h\u1ee3p ng\u01b0\u1eddi d\u00f9ng mu\u1ed1n \u0111i\u1ec1u ch\u1ec9nh Normal.dot tr\u1ef1c ti\u1ebfp th\u00ec \u0111\u1ec3 t\u00ecm t\u1ec7p tin n\u00e0y b\u1ea1n n\u00ean t\u00ecm ki\u1ebfm trong m\u1ee5c Templates ch\u1eb3ng h\u1ea1n: C:Documents and SettingsyourusernameApplication DataMicrosoftTemplates. <\/em>T\u00ean \u0111\u01b0\u1eddng d\u1eabn n\u00e0y s\u1ebd ph\u1ee5 thu\u1ed9c v\u00e0o \u0111\u01b0\u1eddng d\u1eabn \u1ed5 \u0111\u0129a \u0111\u00e3 \u0111\u01b0\u1ee3c c\u00e0i \u0111\u1eb7t trong Windows.\u00a0<\/p>\n

        5. Chuy\u1ec3n \u0111\u1ed5i c\u1ed9t th\u00e0nh d\u00f2ng v\u00e0 ng\u01b0\u1ee3c l\u1ea1i\u00a0<\/strong><\/h2>\n

        Tr\u01b0\u1eddng h\u1ee3p b\u1ea1n mu\u1ed1n chuy\u1ec3n \u0111\u1ed5i d\u00f2ng th\u00e0nh c\u1ed9t v\u00e0 c\u1ed9t th\u00e0nh d\u00f2ng th\u00ec th\u1ef1c hi\u1ec7n theo c\u00e1c b\u01b0\u1edbc sau \u0111\u00e2y:<\/p>\n

          \n
        • B\u01b0\u1edbc 1: B\u00f4i \u0111en b\u1ea3ng t\u00ednh trong file excel c\u1ee7a m\u00ecnh.\u00a0<\/li>\n
        • B\u01b0\u1edbc 2: Ch\u1ecdn Copy -> Ch\u1ecdn Paste Special, sau khi ch\u1ecdn th\u00e0nh c\u00f4ng m\u00e0n h\u00ecnh s\u1ebd xu\u1ea5t hi\u1ec7n c\u1eeda s\u1ed5 l\u1ef1a ch\u1ecdn.\u00a0<\/li>\n
        • B\u01b0\u1edbc 3: B\u1ea1n th\u1ef1c hi\u1ec7n ch\u1ecdn Transpose -> Nh\u1ea5n OK.<\/li>\n<\/ul>\n

          Sau khi th\u1ef1c hi\u1ec7n xong c\u1ed9t v\u00e0 d\u00f2ng s\u1ebd \u0111\u01b0\u1ee3c ho\u00e1n \u0111\u1ed5i v\u1ecb tr\u00ed cho nhau.<\/p>\n

          6. Chuy\u1ec3n \u0111\u1ed5i ch\u1eef hoa v\u00e0 ch\u1eef th\u01b0\u1eddng trong Excel\u00a0<\/strong><\/h2>\n

          Khi l\u00e0m vi\u1ec7c tr\u00ean file d\u1eef li\u1ec7u v\u1edbi danh s\u00e1ch h\u1ecd t\u00ean ch\u01b0a \u0111\u01b0\u1ee3c s\u1eafp x\u1ebfp v\u00e0 r\u1ea5t l\u1ed9n x\u1ed9n. Trong tr\u01b0\u1eddng h\u1ee3p b\u1ea1n mu\u1ed1n c\u00e1c h\u1ecd t\u00ean n\u00e0y ph\u1ea3i theo ki\u1ec3u ch\u1eef hoa to\u00e0n b\u1ed9, hay ch\u1eef hoa ch\u1eef c\u00e1i \u0111\u1ea7u ti\u00ean, v.v. Th\u00ec h\u00e3y th\u1ef1c hi\u1ec7n theo c\u00e1c h\u00e0m sau \u0111\u00e2y \u0111\u1ec3 \u0111\u1ed5i ch\u1eef ki\u1ec3u ch\u1eef in hoa hay in th\u01b0\u1eddng theo mong mu\u1ed1n.<\/p>\n

            \n
          • C\u00e1ch vi\u1ebft hoa t\u1ea5t c\u1ea3 c\u00e1c ch\u1eef c\u00e1i: B\u1ea1n ch\u1ecdn \u00f4 h\u1ecd t\u00ean trong file v\u00e0 g\u00f5 h\u00e0m =UPPER(\u2026) r\u1ed3i nh\u1ea5n Enter.\u00a0<\/li>\n
          • C\u00e1ch vi\u1ebft th\u01b0\u1eddng t\u1ea5t c\u1ea3 c\u00e1c ch\u1eef c\u00e1i: B\u1ea1n ch\u1ecdn \u00f4 h\u1ecd t\u00ean trong file v\u00e0 g\u00f5 h\u00e0m\u00a0 =LOWER(\u2026) r\u1ed3i nh\u1ea5n Enter.\u00a0<\/li>\n
          • C\u00e1ch vi\u1ebft hoa ch\u1eef c\u00e1i \u0111\u1ea7u ti\u00ean: B\u1ea1n ch\u1ecdn \u00f4 h\u1ecd t\u00ean trong file v\u00e0 g\u00f5 h\u00e0m =PROPER(\u2026) r\u1ed3i nh\u1ea5n Enter.\u00a0<\/li>\n<\/ul>\n

            (\u2026) ch\u00ednh l\u00e0 \u00f4 h\u1ecd t\u00ean m\u00e0 b\u1ea1n mu\u1ed1n thay \u0111\u1ed5i, v\u00ed d\u1ee5: =UPPER(A4)<\/p>\n

            7. Lo\u1ea1i b\u1ecf nh\u1eefng k\u00fd t\u1ef1 l\u1ea1 khi sao ch\u00e9p v\u0103n b\u1ea3n v\u00e0o Word<\/strong><\/h2>\n

            \u0110\u1ec3 th\u1ef1c hi\u1ec7n lo\u1ea1i b\u1ecf nh\u1eefng k\u00fd t\u1ef1 l\u1ea1 khi sao ch\u00e9p v\u0103n b\u1ea3n v\u00e0o word b\u1ea1n ch\u1ec9 c\u1ea7n th\u1ef1c hi\u1ec7n theo h\u01b0\u1edbng d\u1eabn sau \u0111\u00e2y:<\/p>\n

              \n
            • Ch\u1ecdn Edit -> Replace \u0111\u1ec3 lo\u1ea1i b\u1ecf k\u00fd t\u1ef1 l\u1ea1 b\u1ea1n ch\u1ec9 c\u1ea7n g\u00f5 ^l ( g\u00f5 d\u1ea5u ^ v\u00e0 ch\u1eef \u2018L\u2019 th\u01b0\u1eddng)<\/li>\n
            • \u1ede tr\u01b0\u1eddng Find What ch\u1ec9 c\u1ea7n g\u00f5 d\u1ea5u c\u00e1ch (sMasterskillsbar) v\u00e0o tr\u01b0\u1eddng Replace<\/li>\n
            • Cu\u1ed1i c\u00f9ng l\u00e0 ch\u1ecdn Replace All, khi xu\u1ea5t hi\u1ec7n h\u1ed9i tho\u1ea1i b\u1ea1n c\u00f3 mu\u1ed1n ti\u1ebfp t\u1ee5c thay th\u1ebf to\u00e0n b\u1ed9 v\u0103n b\u1ea3n kh\u00f4ng th\u00ec ch\u1ecdn No.<\/li>\n<\/ul>\n

              8. M\u1edf nhi\u1ec1u b\u1ea3ng t\u00ednh trong Excel c\u00f9ng m\u1ed9t l\u00fac<\/strong><\/h2>\n

              \u0110\u1ec3 c\u00f3 th\u1ec3 m\u1edf nhi\u1ec1u b\u1ea3ng t\u00ednh trong excel c\u00f9ng m\u1ed9t l\u00fac thay v\u00ec ph\u1ea3i m\u1edf t\u1eebng file m\u1ed9t, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng ph\u00edm Ctrl v\u00e0 k\u00edch ch\u1ecdn file c\u1ea7n m\u1edf sau \u0111\u00f3 nh\u1ea5n ph\u00edm Enter \u0111\u1ec3 m\u1edf c\u00e1c b\u1ea3ng t\u00ednh trong Excel m\u00e0 b\u1ea1n mu\u1ed1n.\u00a0<\/p>\n

              9. In m\u1ed9t v\u00f9ng nh\u1ea5t \u0111\u1ecbnh trong Excel<\/strong><\/h2>\n

              Trong qu\u00e1 tr\u00ecnh l\u00e0m vi\u1ec7c ch\u1eafc r\u1eb1ng b\u1ea1n s\u1ebd c\u00f3 l\u00fac c\u1ea7n in m\u1ed9t v\u00f9ng nh\u1ea5t \u0111\u1ecbnh trong file excel c\u1ee7a m\u00ecnh. V\u00e0 \u0111\u1ec3 th\u1ef1c hi\u1ec7n in m\u1ed9t v\u00f9ng nh\u1ea5t \u0111\u1ecbnh ph\u1ea3i l\u00e0m th\u1ebf n\u00e0o? \u0110\u00e2y l\u00e0 th\u1eafc m\u1eafc \u0111\u01b0\u1ee3c r\u1ea5t nhi\u1ec1u ng\u01b0\u1eddi quan t\u00e2m.\u00a0<\/p>\n

              \u0110\u1ed1i v\u1edbi in m\u1ed9t v\u00f9ng nh\u1ea5t \u0111\u1ecbnh trong Excel Masterskills xin chia s\u1ebb \u0111\u1ebfn b\u1ea1n m\u1eb9o tin h\u1ecdc nh\u01b0 sau:\u00a0<\/p>\n

                \n
              • B\u01b0\u1edbc 1: B\u1ea1n c\u1ea7n b\u00f4i \u0111en v\u00f9ng m\u00e0 b\u1ea1n mu\u1ed1n in\u00a0\u00a0<\/li>\n
              • B\u01b0\u1edbc 2: Di chuy\u1ec3n chu\u1ed9t l\u00ean thanh menu, ch\u1ecdn Page Layout -> Ch\u1ecdn Print Area -> Ch\u1ecdn Set Print Area\u00a0<\/li>\n
              • B\u01b0\u1edbc 3: Sau khi \u0111\u00e3 \u0111\u1eb7t v\u00f9ng in b\u1ea1n ti\u1ebfn h\u00e0nh in nh\u01b0 b\u00ecnh th\u01b0\u1eddng, \u0111\u1ec3 v\u0103n b\u1ea3n in \u0111\u01b0\u1ee3c h\u01a1n b\u1ea1n c\u1ea7n c\u0103n ch\u1ec9nh v\u0103n b\u1ea3n tr\u01b0\u1edbc khi in n\u1ebfu c\u1ea7n.\u00a0<\/li>\n<\/ul>\n

                10. Chuy\u1ec3n \u0111\u1ed5i qua l\u1ea1i c\u00e1c c\u1eeda s\u1ed5 l\u00e0m vi\u1ec7c tr\u00ean m\u00e1y t\u00ednh<\/strong><\/h2>\n

                L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 chuy\u1ec3n \u0111\u1ed5i qua l\u1ea1i gi\u1eefa c\u00e1c c\u1eeda s\u1ed5 l\u00e0m vi\u1ec7c tr\u00ean m\u00e1y t\u00ednh \u0111\u1ec3 gi\u00fap qu\u00e1 tr\u00ecnh l\u00e0m vi\u1ec7c \u0111\u01b0\u1ee3c hi\u1ec7u qu\u1ea3 h\u01a1n. \u0110\u1eb7c bi\u1ec7t trong tr\u01b0\u1eddng h\u1ee3p kh\u00f4ng c\u00f3 chu\u1ed9t ho\u1eb7c n\u1ebfu c\u00f3 chu\u1ed9t th\u00ec vi\u1ec7c di chuy\u1ec3n gi\u1eefa c\u00e1c tab m\u1ea5t kh\u00e1 nhi\u1ec1u th\u1eddi gian.\u00a0<\/p>\n

                V\u1eady th\u1ee7 thu\u1eadt tin h\u1ecdc v\u0103n ph\u00f2ng<\/strong> \u0111\u1ec3 chuy\u1ec3n \u0111\u1ed5i qua l\u1ea1i gi\u1eefa c\u00e1c c\u1eeda s\u1ed5 l\u00e0m vi\u1ec7c tr\u00ean m\u00e1y t\u00ednh l\u00e0 g\u00ec? M\u1ed9t trong nh\u1eefng m\u1eb9o tin h\u1ecdc m\u00e0 b\u1ea1n n\u00ean s\u1eed d\u1ee5ng ch\u00ednh l\u00e0 d\u00f9ng t\u1ed5 h\u1ee3p ph\u00edm t\u1eaft Ctrl + Page up ho\u1eb7c Ctrl + Page down \u0111\u1ec3 d\u1ec5 d\u00e0ng chuy\u1ec3n \u0111\u1ed5i qua l\u1ea1i gi\u1eefa c\u00e1c sheet v\u1edbi nhau. \u0110\u00e2y l\u00e0 m\u1eb9o hay gi\u00fap b\u1ea1n chuy\u1ec3n \u0111\u1ed5i gi\u1eefa c\u00e1c c\u1eeda s\u1ed5 m\u00e0 kh\u00f4ng c\u1ea7n d\u00f9ng t\u1edbi chu\u1ed9t.\u00a0<\/p>\n

                \n
                \"D\u00f9ng\"D\u00f9ng
                D\u00f9ng Ctrl + Page up\/Page down \u0111\u1ec3 chuy\u1ec3n \u0111\u1ed5i qua l\u1ea1i gi\u1eefa c\u00e1c sheet<\/figcaption><\/figure>\n<\/div>\n

                K\u1ebft lu\u1eadn<\/strong><\/h2>\n

                Tr\u00ean \u0111\u00e2y l\u00e0 10th\u1ee7 thu\u1eadt tin h\u1ecdc v\u0103n ph\u00f2ng<\/strong> v\u00f4 c\u00f9ng h\u1eefu \u00edch m\u00e0 Masterskills mu\u1ed1n chia s\u1ebb \u0111\u1ebfn b\u1ea1n \u0111\u1ecdc. Th\u00f4ng qua nh\u1eefng m\u1eb9o tin h\u1ecdc tr\u00ean b\u1ea1n s\u1ebd c\u1ea3m th\u1ea5y t\u1ef1 tin h\u01a1n trong qu\u00e1 tr\u00ecnh l\u00e0m vi\u1ec7c, ph\u1ea7n n\u00e0o gi\u00fap b\u1ea1n ti\u1ebft ki\u1ec7m \u0111\u01b0\u1ee3c th\u1eddi gian trong c\u00f4ng vi\u1ec7c v\u00e0 th\u1ec3 hi\u1ec7n s\u1ef1 chuy\u00ean nghi\u1ec7p trong k\u1ef9 n\u0103ng tin h\u1ecdc v\u0103n ph\u00f2ng.<\/p>\n

                Theo d\u00f5i Masterskills \u0111\u1ec3 xem th\u00eam nhi\u1ec1u th\u00f4ng tin h\u1eefu \u00edch kh\u00e1c nh\u00e9!<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"

                Khi c\u00f4ng ngh\u1ec7 th\u00f4ng tin ng\u00e0y c\u00e0ng ph\u00e1t tri\u1ec3n nhu c\u1ea7u \u1ee9ng d\u1ee5ng tin h\u1ecdc v\u00e0o qu\u00e1 tr\u00ecnh l\u00e0m vi\u1ec7c ng\u00e0y \u0111\u01b0\u1ee3c m\u1ed9t quan t\u00e2m. Ch\u00ednh v\u00ec th\u1ebf vi\u1ec7c n\u1eafm r\u00f5 c\u00e1c th\u1ee7 thu\u1eadt tin h\u1ecdc v\u0103n ph\u00f2ng l\u00e0 c\u00e1ch gi\u00fap b\u1ea1n x\u1eed l\u00fd c\u00f4ng vi\u1ec7c nhanh h\u01a1n, d\u1ec5 d\u00e0ng h\u01a1n v\u00e0 \u0111em l\u1ea1i hi\u1ec7u […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[211],"tags":[],"_links":{"self":[{"href":"https:\/\/masterskills.org\/blog\/wp-json\/wp\/v2\/posts\/47239"}],"collection":[{"href":"https:\/\/masterskills.org\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/masterskills.org\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/masterskills.org\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/masterskills.org\/blog\/wp-json\/wp\/v2\/comments?post=47239"}],"version-history":[{"count":0,"href":"https:\/\/masterskills.org\/blog\/wp-json\/wp\/v2\/posts\/47239\/revisions"}],"wp:attachment":[{"href":"https:\/\/masterskills.org\/blog\/wp-json\/wp\/v2\/media?parent=47239"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/masterskills.org\/blog\/wp-json\/wp\/v2\/categories?post=47239"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/masterskills.org\/blog\/wp-json\/wp\/v2\/tags?post=47239"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}