{"id":3680,"date":"2022-12-29T03:54:43","date_gmt":"2022-12-29T03:54:43","guid":{"rendered":"http:\/\/it.ntc.edu.vn\/?p=3680"},"modified":"2022-12-31T04:56:20","modified_gmt":"2022-12-31T04:56:20","slug":"huong-dan-su-dung-microsoft-excel","status":"publish","type":"post","link":"http:\/\/taingo.ddns.net\/it.ntc.edu.vn\/huong-dan-su-dung-microsoft-excel\/","title":{"rendered":"H\u01af\u1edaNG D\u1eaaN S\u1eec D\u1ee4NG MICROSOFT EXCEL"},"content":{"rendered":"

H\u01af\u1edaNG D\u1eaaN S\u1eec D\u1ee4NG MICROSOFT EXCEL 365<\/strong><\/span><\/p>\n

\u00a0<\/strong>M\u1ee4C L\u1ee4C<\/strong><\/p>\n

    \n
  1. GI\u1edaI THI\u1ec6U V\u1ec0 MICROSOFT EXCEL 365<\/strong><\/li>\n<\/ol>\n

    1.1. Excel 365 d\u00f9ng \u0111\u1ec3 l\u00e0m g\u00ec?<\/strong><\/p>\n

    1.2. Excel 365 c\u00f3 nh\u1eefng \u01b0u \u0111i\u1ec3m n\u00e0o?<\/strong><\/p>\n

    1.3. V\u00ec sao n\u00ean s\u1eed d\u1ee5ng Excel 365S?<\/strong><\/p>\n

      \n
    1. L\u00c0M QUEN V\u1edaI EXCEL 365<\/strong><\/li>\n<\/ol>\n

      2.1. \u0110\u0103ng nh\u1eadp t\u00e0i kho\u1ea3n Microsoft<\/strong><\/p>\n

      2.2. Excel 365 Website<\/strong><\/p>\n

      2.3. Excel 365 PC<\/strong><\/p>\n

      2.4. Excel 365 Mobile<\/strong><\/p>\n

      2.4.1. Qua b\u1ed9 c\u00f4ng c\u1ee5 Office 365 Mobile<\/strong><\/p>\n

      2.4.2. Qua \u1ee9ng d\u1ee5ng Excel 365 Mobile<\/strong><\/p>\n

        \n
      1. H\u01af\u1edaNG D\u1eaaN S\u1eec D\u1ee4NG C\u0102N B\u1ea2N EXCEL 365 PC<\/strong><\/li>\n<\/ol>\n

        3.1. Ki\u1ebfn th\u1ee9c c\u01a1 b\u1ea3n v\u1ec1 b\u1ea3ng t\u00ednh (Workbook)<\/strong><\/p>\n

        3.1.1. Kh\u00e1i ni\u1ec7m b\u1ea3ng t\u00ednh<\/strong><\/p>\n

        3.1.2. C\u00e1c b\u01b0\u1edbc x\u00e2y d\u1ef1ng b\u1ea3ng t\u00ednh th\u00f4ng th\u01b0\u1eddng<\/strong><\/p>\n

        3.2. S\u1eed d\u1ee5ng Excel 365 PC<\/strong><\/p>\n

        3.2.1. Giao di\u1ec7n<\/strong><\/p>\n

        3.2.2. Thao t\u00e1c tr\u00ean t\u1eadp tin b\u1ea3ng t\u00ednh<\/strong><\/p>\n

        3.3. Thao t\u00e1c v\u1edbi \u00f4 d\u1eef li\u1ec7u<\/strong><\/p>\n

        3.3.1. C\u00e1c ki\u1ec3u d\u1eef li\u1ec7u<\/strong><\/p>\n

        3.3.2. C\u00e1ch nh\u1eadp d\u1eef li\u1ec7u<\/strong><\/p>\n

        3.3.3. Ch\u1ec9nh s\u1eeda d\u1eef li\u1ec7u<\/strong><\/p>\n

        3.4. L\u00e0m vi\u1ec7c v\u1edbi trang t\u00ednh (Wooksheet)<\/strong><\/p>\n

        3.4.1. D\u00f2ng v\u00e0 c\u1ed9t<\/strong><\/p>\n

        3.4.2. Trang t\u00ednh<\/strong><\/p>\n

        3.5. \u0110\u1ecbnh d\u1ea1ng \u00f4, d\u00e3y \u00f4<\/strong><\/p>\n

        3.5.1. \u0110\u1ecbnh d\u1ea1ng ki\u1ec3u s\u1ed1, ng\u00e0y, ti\u1ec1n t\u1ec7<\/strong><\/p>\n

        3.5.2. \u0110\u1ecbnh d\u1ea1ng v\u0103n b\u1ea3n<\/strong><\/p>\n

        3.5.3. C\u0103n ch\u1ec9nh, hi\u1ec7u \u1ee9ng vi\u1ec1n<\/strong><\/p>\n

        3.6. Bi\u1ec3u th\u1ee9c v\u00e0 h\u00e0m<\/strong><\/p>\n

        3.6.1. Bi\u1ec3u th\u1ee9c s\u1ed1 h\u1ecdc<\/strong><\/p>\n

        3.6.2. H\u00e0m<\/strong><\/p>\n

        3.7. Bi\u1ec3u \u0111\u1ed3<\/strong><\/p>\n

        3.7.1. T\u1ea1o bi\u1ec3u \u0111\u1ed3<\/strong><\/p>\n

        3.7.2. Ch\u1ec9nh s\u1eeda, c\u1eaft d\u00e1n, di chuy\u1ec3n, xo\u00e1 ti\u00eau \u0111\u1ec1 b\u1ea3n \u0111\u1ed3<\/strong><\/p>\n

        3.8. K\u1ebft xu\u1ea5t v\u00e0 ph\u00e2n ph\u1ed1i trang t\u00ednh, b\u1ea3ng t\u00ednh<\/strong><\/p>\n

        3.8.1. Tr\u00ecnh b\u00e0y trang t\u00ednh \u0111\u1ec3 in<\/strong><\/p>\n

        3.8.2. Ki\u1ec3m tra v\u00e0 in<\/strong><\/p>\n

        3.8.3 Ph\u00e2n ph\u1ed1i trang in<\/strong><\/p>\n

        3.9. M\u1ed9t s\u1ed1 \u0111i\u1ec3m kh\u00e1c bi\u1ec7t c\u1ee7a Excel 365 v\u1edbi c\u00e1c<\/strong>\u00a0phi\u00ean b\u1ea3n c\u0169 h\u01a1n<\/strong><\/p>\n

          \n
        1. K\u1ebeT LU\u1eacN<\/strong><\/li>\n<\/ol>\n

          \u00a0<\/strong><\/p>\n

          \"\"<\/strong><\/p>\n

          \u00a0<\/strong><\/p>\n

          <\/a>1. GI\u1edaI THI\u1ec6U V\u1ec0 MICROSOFT EXCEL 365<\/strong><\/h1>\n

          \u0110\u01b0\u1ee3c ph\u00e1t h\u00e0nh t\u1eeb nh\u1eefng n\u0103m 1990, Excel \u0111\u00e3 tr\u1edf th\u00e0nh m\u1ed9t trong nh\u1eefng \u1ee9ng d\u1ee5ng g\u1eafn li\u1ec1n v\u1edbi c\u00e1c th\u1ebf h\u1ec7 8x, 9x \u0111\u1eddi \u0111\u1ea7u. Qua nhi\u1ec1u n\u0103m, nhu c\u1ea7u c\u1ee7a ng\u01b0\u1eddi d\u00f9ng ng\u00e0y c\u00e0ng t\u0103ng cao, \u0111\u00f2i h\u1ecfi \u1ee9ng d\u1ee5ng ph\u1ea3i \u0111\u01b0\u1ee3c c\u1eadp nh\u1eadt c\u00e1c t\u00ednh n\u0103ng m\u1edbi ho\u1eb7c c\u1ea3i ti\u1ebfn c\u00e1c t\u00ednh n\u0103ng \u0111\u1eb7c tr\u01b0ng, v\u00e0 Excel c\u0169ng kh\u00f4ng ph\u1ea3i l\u00e0 m\u1ed9t tr\u01b0\u1eddng h\u1ee3p ngo\u1ea1i l\u1ec7. Sau nhi\u1ec1u l\u1ea7n \u0111\u01b0\u1ee3c n\u00e2ng c\u1ea5p qua c\u00e1c n\u0103m, t\u01b0\u01a1ng \u1ee9ng v\u1edbi c\u00e1c phi\u00ean b\u1ea3n \u0111\u1ed5i m\u1edbi, xu\u1ea5t ph\u00e1t t\u1eeb 2003 \u0111\u1ebfn n\u0103m 2021, Excel \u0111\u00e3 ti\u1ebfn t\u1edbi m\u1ed9t s\u1ef1 v\u01b0\u1ee3t b\u1eadc m\u1edbi v\u1edbi t\u00ean g\u1ecdi Microsoft Excel (thu\u1ed9c b\u1ed9 c\u00f4ng c\u1ee5 Microsoft 365). V\u1edbi nhi\u1ec1u s\u1ef1 thay \u0111\u1ed5i, ch\u1ec9nh s\u1eeda sao cho thu\u1eadn ti\u1ec7n v\u1edbi ng\u01b0\u1eddi d\u00f9ng nh\u1ea5t c\u00f3 th\u1ec3, c\u00f9ng nhi\u1ec1u \u01b0u \u0111i\u1ec3m n\u1ed5i b\u1eadt khi\u1ebfn Excel 365 tr\u1edf th\u00e0nh m\u1ed9t c\u00f4ng c\u1ee5 \u0111\u1eafc l\u1ef1c \u1edf c\u00e1c l\u0129nh v\u1ef1c nh\u01b0 t\u00e0i ch\u00ednh, kinh t\u1ebf,\u2026 v\u00e0 l\u00e0 c\u00f4ng c\u1ee5 \u0111\u01b0\u1ee3c nh\u1eafc \u0111\u1ebfn \u0111\u1ea7u ti\u00ean khi th\u1ef1c hi\u1ec7n l\u1eadp b\u00e1o c\u00e1o th\u1ed1ng k\u00ea, ph\u00e2n t\u00edch s\u1ed1 li\u1ec7u,…<\/p>\n

          T\u00e0i li\u1ec7u n\u00e0y s\u1ebd l\u00e0m r\u00f5 Microsoft Excel 365 d\u00f9ng \u0111\u1ec3 l\u00e0m nh\u1eefng g\u00ec, c\u00f3 c\u00e1c \u01b0u \u0111i\u1ec3m n\u00e0o, v\u00e0 m\u1ed9t s\u1ed1 l\u00ed do thuy\u1ebft ph\u1ee5c qu\u00fd th\u1ea7y c\u00f4 l\u1ef1a ch\u1ecdn Microsoft Excel.<\/p>\n

          <\/a>1.1. Excel 365 d\u00f9ng \u0111\u1ec3 l\u00e0m g\u00ec?<\/strong><\/h2>\n

          Microsoft Excel 365 (g\u1ecdi t\u1eaft l\u00e0 Excel 365) l\u00e0 m\u1ed9t ph\u1ea7n m\u1ec1m b\u1ea3ng t\u00ednh n\u1eb1m trong b\u1ed9 Microsoft Office 365. Excel 365 gi\u00fap ng\u01b0\u1eddi d\u00f9ng ghi l\u1ea1i d\u1eef li\u1ec7u, tr\u00ecnh b\u00e0y th\u00f4ng tin d\u01b0\u1edbi d\u1ea1ng b\u1ea3ng, t\u00ednh to\u00e1n, x\u1eed l\u00fd th\u00f4ng tin nhanh ch\u00f3ng v\u00e0 ch\u00ednh x\u00e1c v\u1edbi l\u01b0\u1ee3ng d\u1eef li\u1ec7u l\u1edbn m\u1ed9t c\u00e1ch c\u1ea3i thi\u1ec7n h\u01a1n so v\u1edbi c\u00e1c phi\u00ean b\u1ea3n c\u0169 tr\u01b0\u1edbc \u0111\u00f3.<\/p>\n

          C\u00e1c phi\u00ean b\u1ea3n c\u0169 ph\u1ed5 bi\u1ebfn c\u1ee7a Excel do Microsoft ph\u00e1t h\u00e0nh:<\/p>\n