{"id":4568,"date":"2025-11-13T11:59:03","date_gmt":"2025-11-13T04:59:03","guid":{"rendered":"https:\/\/autofillform.com\/blog\/cac-thao-tac-co-ban-trong-excel-don-gian-danh-cho-nguoi-moi\/"},"modified":"2025-11-13T11:59:03","modified_gmt":"2025-11-13T04:59:03","slug":"cac-thao-tac-co-ban-trong-excel-don-gian-danh-cho-nguoi-moi","status":"publish","type":"post","link":"https:\/\/autofillform.com\/blog\/cac-thao-tac-co-ban-trong-excel-don-gian-danh-cho-nguoi-moi\/","title":{"rendered":"C\u00e1c thao t\u00e1c c\u01a1 b\u1ea3n trong Excel \u0111\u01a1n gi\u1ea3n d\u00e0nh cho ng\u01b0\u1eddi m\u1edbi"},"content":{"rendered":"
\n

Excel l\u00e0 c\u00f4ng c\u1ee5 h\u1ed7 tr\u1ee3 \u0111\u1eafc l\u1ef1c trong c\u00f4ng vi\u1ec7c v\u0103n ph\u00f2ng. B\u00e0i vi\u1ebft n\u00e0y s\u1ebd h\u01b0\u1edbng d\u1eabn b\u1ea1n chi ti\u1ebft t\u1eeb c\u00e1ch kh\u1edfi \u0111\u1ed9ng, t\u1ea1o workbook m\u1edbi, th\u00eam ho\u1eb7c x\u00f3a worksheet \u0111\u1ebfn c\u00e1c thao t\u00e1c c\u01a1 b\u1ea3n nh\u01b0 nh\u1eadp li\u1ec7u, \u1ea9n nh\u00f3m h\u00e0ng c\u1ed9t, ch\u00e8n \u0111\u01b0\u1eddng ch\u00e9o v\u00e0 \u0111\u1ecbnh d\u1ea1ng d\u1eef li\u1ec7u.<\/p>\n

\"C\u00e1cH\u01b0\u1edbng d\u1eabn c\u00e1c thao t\u00e1c c\u01a1 b\u1ea3n trong Excel<\/em><\/p>\n

\n

1. M\u1edf ph\u1ea7n m\u1ec1m Microsoft Excel<\/h2>\n<\/div>\n
\n

1.1. Kh\u1edfi \u0111\u1ed9ng tr\u00ean m\u00e0n h\u00ecnh Desktop<\/h3>\n<\/div>\n

T\u1ea1i m\u00e0n h\u00ecnh ch\u00ednh c\u1ee7a m\u00e1y t\u00ednh, b\u1ea1n t\u00ecm bi\u1ec3u t\u01b0\u1ee3ng Microsoft Excel, sau \u0111\u00f3 nh\u1ea5p \u0111\u00fap chu\u1ed9t tr\u00e1i \u0111\u1ec3 kh\u1edfi \u0111\u1ed9ng \u1ee9ng d\u1ee5ng v\u00e0 b\u1eaft \u0111\u1ea7u l\u00e0m vi\u1ec7c v\u1edbi b\u1ea3ng t\u00ednh.<\/p>\n

\"Nh\u1ea5pM\u1edf Microsoft Excel tr\u00ean m\u00e0n h\u00ecnh Desktop<\/em><\/p>\n

\n

1.2. Kh\u1edfi \u0111\u1ed9ng b\u1eb1ng n\u00fat Start tr\u00ean thanh Taskbar<\/h3>\n<\/div>\n

B\u1ea1n nh\u1ea5n v\u00e0o \u00f4 Type here to search (khung t\u00ecm ki\u1ebfm) \u1edf g\u00f3c tr\u00e1i ph\u00eda d\u01b0\u1edbi m\u00e0n h\u00ecnh, sau \u0111\u00f3 nh\u1eadp t\u1eeb kh\u00f3a Excel. Khi bi\u1ec3u t\u01b0\u1ee3ng Microsoft Excel xu\u1ea5t hi\u1ec7n trong danh s\u00e1ch k\u1ebft qu\u1ea3, h\u00e3y b\u1ea5m ch\u1ecdn \u0111\u1ec3 kh\u1edfi ch\u1ea1y ch\u01b0\u01a1ng tr\u00ecnh.<\/p>\n

\"M\u1edfM\u1edf Excel b\u1eb1ng \u00f4 t\u00ecm ki\u1ebfm tr\u00ean thanh Start<\/em><\/p>\n

Xem th\u00eam: <\/strong>11 C\u00e1ch l\u00e0m gi\u1ea3m dung l\u01b0\u1ee3ng, t\u0103ng t\u1ed1c x\u1eed l\u00fd file Excel<\/div>\n
\n

2. T\u1ea1o m\u1ed9t workbook m\u1edbi<\/h2>\n<\/div>\n

\u0110\u1ec3 b\u1eaft \u0111\u1ea7u l\u00e0m vi\u1ec7c v\u1edbi m\u1ed9t b\u1ea3ng t\u00ednh m\u1edbi, b\u1ea1n th\u1ef1c hi\u1ec7n nh\u01b0 sau:<\/p>\n

B\u01b0\u1edbc 1:<\/strong> Tr\u00ean thanh c\u00f4ng c\u1ee5, ch\u1ecdn File \u2192 New.<\/p>\n

B\u01b0\u1edbc 2: <\/strong>\u1ede m\u1ee5c New, nh\u1ea5p ch\u1ecdn Blank workbook \u0111\u1ec3 m\u1edf s\u1ed5 l\u00e0m vi\u1ec7c tr\u1ed1ng.<\/p>\n

\"Ch\u1ecdnCh\u1ecdn File New \u0111\u1ec3 t\u1ea1o workbook m\u1edbi<\/em><\/p>\n

M\u1eb9o nhanh: Nh\u1ea5n t\u1ed5 h\u1ee3p Ctrl + N \u0111\u1ec3 m\u1edf nhanh m\u1ed9t workbook m\u1edbi m\u00e0 kh\u00f4ng c\u1ea7n qua menu.<\/p>\n

\n

3. Th\u00eam v\u00e0 qu\u1ea3n l\u00fd worksheet<\/h2>\n<\/div>\n
\n

3.1. Th\u00eam worksheet m\u1edbi<\/h3>\n<\/div>\n

Khi c\u1ea7n t\u1ea1o th\u00eam b\u1ea3ng t\u00ednh trong c\u00f9ng m\u1ed9t workbook, b\u1ea1n c\u00f3 th\u1ec3 th\u1ef1c hi\u1ec7n theo c\u00e1c c\u00e1ch sau:<\/p>\n

C\u00e1ch 1: D\u00f9ng bi\u1ec3u t\u01b0\u1ee3ng \u201c+\u201d<\/h4>\n

\u1ede thanh tab ph\u00eda d\u01b0\u1edbi c\u00f9ng c\u1ee7a Excel (n\u01a1i hi\u1ec3n th\u1ecb c\u00e1c sheet nh\u01b0 Sheet1, Sheet2\u2026), b\u1ea1n nh\u1ea5n v\u00e0o bi\u1ec3u t\u01b0\u1ee3ng \u201c+<\/strong>\u201d n\u1eb1m b\u00ean ph\u1ea3i \u0111\u1ec3 th\u00eam m\u1ed9t worksheet m\u1edbi<\/strong> ngay l\u1eadp t\u1ee9c.<\/p>\n

\"Nh\u1ea5nTh\u00eam worksheet m\u1edbi b\u1eb1ng bi\u1ec3u t\u01b0\u1ee3ng d\u1ea5u c\u1ed9ng<\/em><\/p>\n

C\u00e1ch 2: D\u00f9ng menu Home<\/h4>\n

V\u00e0o tab Home <\/strong>\u2192 nh\u00f3m Cells <\/strong>\u2192 ch\u1ecdn Insert <\/strong>\u2192 ch\u1ecdn Insert Sheet<\/strong> \u0111\u1ec3 th\u00eam b\u1ea3ng t\u00ednh m\u1edbi.<\/p>\n

\"C\u00e1chTh\u00eam worksheet b\u1eb1ng menu Home v\u00e0 ch\u1ecdn Insert Sheet<\/em><\/p>\n

C\u00e1ch 3: D\u00f9ng menu chu\u1ed9t ph\u1ea3i<\/h4>\n

Nh\u1ea5n chu\u1ed9t ph\u1ea3i v\u00e0o t\u00ean sheet b\u1ea5t k\u1ef3 \u2192 ch\u1ecdn Insert<\/strong>… \u2192 ch\u1ecdn Worksheet<\/strong> \u2192 b\u1ea5m OK<\/strong>.<\/p>\n

\"Ch\u00e8nCh\u00e8n worksheet qua menu chu\u1ed9t ph\u1ea3i Insert Worksheet<\/em><\/p>\n

C\u00e1c c\u00e1ch tr\u00ean \u0111\u1ec1u gi\u00fap b\u1ea1n th\u00eam b\u1ea3ng t\u00ednh m\u1edbi nhanh ch\u00f3ng \u0111\u1ec3 ti\u1ebfp t\u1ee5c nh\u1eadp v\u00e0 x\u1eed l\u00fd d\u1eef li\u1ec7u trong c\u00f9ng file Excel.<\/p>\n

\n

3.2. Th\u00eam nhi\u1ec1u worksheet c\u00f9ng l\u00fac<\/h3>\n<\/div>\n

Khi c\u1ea7n t\u1ea1o c\u00f9ng l\u00fac nhi\u1ec1u b\u1ea3ng t\u00ednh trong m\u1ed9t workbook, b\u1ea1n c\u00f3 th\u1ec3 thao t\u00e1c nh\u01b0 sau:<\/p>\n

B\u01b0\u1edbc 1: <\/strong>Nh\u1ea5n gi\u1eef ph\u00edm Shift <\/strong>r\u1ed3i ch\u1ecdn s\u1ed1 l\u01b0\u1ee3ng tab worksheet hi\u1ec7n c\u00f3 t\u01b0\u01a1ng \u1ee9ng v\u1edbi s\u1ed1 b\u1ea3ng t\u00ednh b\u1ea1n mu\u1ed1n th\u00eam.<\/p>\n

V\u00ed d\u1ee5:<\/strong> N\u1ebfu mu\u1ed1n th\u00eam 3 worksheet m\u1edbi, b\u1ea1n ch\u1ecdn 3 tab hi\u1ec7n c\u00f3 (v\u00ed d\u1ee5 Sheet1, Sheet2, Sheet3<\/em>).<\/p>\n

B\u01b0\u1edbc 2: <\/strong>V\u00e0o tab Home <\/strong>\u2192 Insert<\/strong> \u2192 Insert Sheet<\/strong> \u0111\u1ec3 th\u00eam m\u1edbi c\u00f9ng l\u00fac nhi\u1ec1u worksheet.<\/p>\n

\"Th\u00eamTh\u00eam nhi\u1ec1u worksheet c\u00f9ng l\u00fac trong Excel<\/em><\/p>\n

Ho\u1eb7c:<\/strong><\/p>\n

    \n
  • Nh\u1ea5p chu\u1ed9t ph\u1ea3i v\u00e0o c\u00e1c worksheet \u0111\u00e3 ch\u1ecdn \u2192 ch\u1ecdn Insert<\/strong>.<\/li>\n
  • Trong h\u1ed9p tho\u1ea1i Insert<\/strong>, t\u1ea1i tab General<\/strong>, ch\u1ecdn Worksheet <\/strong>\u2192 nh\u1ea5n OK<\/strong>.<\/li>\n<\/ul>\n

    \"Ch\u1ecdnCh\u1ecdn nhi\u1ec1u worksheet \u0111\u1ec3 th\u00eam \u0111\u1ed3ng th\u1eddi<\/em><\/p>\n

    Sau khi th\u1ef1c hi\u1ec7n, Excel s\u1ebd th\u00eam c\u00f9ng l\u00fac s\u1ed1 l\u01b0\u1ee3ng worksheet t\u01b0\u01a1ng \u1ee9ng ngay sau c\u00e1c sheet b\u1ea1n \u0111\u00e3 ch\u1ecdn.<\/p>\n

    \n

    3.3. \u0110\u1ed5i t\u00ean worksheet<\/h3>\n<\/div>\n

    Khi mu\u1ed1n thay \u0111\u1ed5i t\u00ean c\u1ee7a m\u1ed9t b\u1ea3ng t\u00ednh \u0111\u1ec3 d\u1ec5 qu\u1ea3n l\u00fd, b\u1ea1n c\u00f3 th\u1ec3 l\u00e0m nh\u01b0 sau:<\/p>\n

    B\u01b0\u1edbc 1: <\/strong>Nh\u1ea5p chu\u1ed9t ph\u1ea3i v\u00e0o tab sheet \u1edf ph\u00eda d\u01b0\u1edbi m\u00e0n h\u00ecnh \u2192 ch\u1ecdn Rename<\/strong>.<\/p>\n

    \"\u0110\u1ed5iNh\u1ea5p chu\u1ed9t ph\u1ea3i v\u00e0o tab sheet v\u00e0 ch\u1ecdn Rename<\/em><\/p>\n

    B\u01b0\u1edbc 2:<\/strong> Nh\u1eadp t\u00ean m\u1edbi cho worksheet theo \u00fd b\u1ea1n, r\u1ed3i nh\u1ea5n Enter <\/strong>\u0111\u1ec3 ho\u00e0n t\u1ea5t.<\/p>\n

    M\u1eb9o nhanh:<\/strong> B\u1ea1n c\u0169ng c\u00f3 th\u1ec3 nh\u1ea5p \u0111\u00fap chu\u1ed9t<\/strong> tr\u1ef1c ti\u1ebfp v\u00e0o t\u00ean sheet, g\u00f5 t\u00ean m\u1edbi v\u00e0 nh\u1ea5n Enter<\/strong>, thao t\u00e1c n\u00e0y nhanh h\u01a1n khi c\u1ea7n \u0111\u1ed5i t\u00ean nhi\u1ec1u sheet li\u00ean ti\u1ebfp.<\/p>\n

    \"Nh\u1ea5n\u0110\u1ed5i t\u00ean worksheet v\u00e0 nh\u1ea5n Enter \u0111\u1ec3 ho\u00e0n t\u1ea5t<\/em><\/p>\n

    \n

    3.4. X\u00f3a m\u1ed9t ho\u1eb7c nhi\u1ec1u worksheet<\/h3>\n<\/div>\n

    X\u00f3a m\u1ed9t worksheet<\/h4>\n

    B\u01b0\u1edbc 1:<\/strong> Nh\u1ea5p chu\u1ed9t ph\u1ea3i v\u00e0o tab sheet mu\u1ed1n x\u00f3a (v\u00ed d\u1ee5 Sheet2).<\/p>\n

    B\u01b0\u1edbc 2: <\/strong>Ch\u1ecdn Delete<\/strong>.<\/p>\n

    Ngay l\u1eadp t\u1ee9c, worksheet \u0111\u00f3 s\u1ebd b\u1ecb x\u00f3a kh\u1ecfi file Excel.<\/p>\n

    \"X\u00f3aX\u00f3a m\u1ed9t worksheet trong Excel<\/em><\/p>\n

    X\u00f3a nhi\u1ec1u worksheet c\u00f9ng l\u00fac<\/h4>\n

    B\u01b0\u1edbc 1: <\/strong>Nh\u1ea5n gi\u1eef Ctrl <\/strong>(\u0111\u1ec3 ch\u1ecdn c\u00e1c sheet r\u1eddi r\u1ea1c) ho\u1eb7c Shift <\/strong>(\u0111\u1ec3 ch\u1ecdn c\u00e1c sheet li\u1ec1n k\u1ec1).<\/p>\n

    B\u01b0\u1edbc 2: <\/strong>Ch\u1ecdn nh\u1eefng sheet c\u1ea7n x\u00f3a \u2192 nh\u1ea5p chu\u1ed9t ph\u1ea3i v\u00e0o m\u1ed9t trong s\u1ed1 \u0111\u00f3 \u2192 ch\u1ecdn Delete<\/strong>.<\/p>\n

    \"X\u00f3aX\u00f3a nhi\u1ec1u worksheet c\u00f9ng l\u00fac trong Excel<\/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

    4. M\u1ed9t s\u1ed1 thao t\u00e1c c\u01a1 b\u1ea3n trong Excel<\/h2>\n<\/div>\n
    \n

    4.1. Ch\u1ecdn t\u1ea5t c\u1ea3 d\u1eef li\u1ec7u<\/h3>\n<\/div>\n

    Th\u00f4ng th\u01b0\u1eddng, b\u1ea1n c\u00f3 th\u1ec3 d\u00f9ng ph\u00edm t\u1eaft Ctrl + A<\/strong> \u0111\u1ec3 ch\u1ecdn to\u00e0n b\u1ed9 d\u1eef li\u1ec7u trong b\u1ea3ng t\u00ednh.<\/p>\n

    Tuy nhi\u00ean, c\u00f2n m\u1ed9t c\u00e1ch nhanh h\u01a1n m\u00e0 \u00edt ng\u01b0\u1eddi \u0111\u1ec3 \u00fd:<\/p>\n

    H\u00e3y nh\u1ea5p chu\u1ed9t v\u00e0o \u00f4 vu\u00f4ng nh\u1ecf n\u1eb1m \u1edf g\u00f3c tr\u00ean b\u00ean tr\u00e1i c\u1ee7a b\u1ea3ng t\u00ednh<\/strong>, l\u00e0 giao \u0111i\u1ec3m gi\u1eefa ti\u00eau \u0111\u1ec1 c\u1ed9t (A, B, C, \u2026) v\u00e0 ti\u00eau \u0111\u1ec1 h\u00e0ng (1, 2, 3, \u2026).<\/p>\n

    Ngay l\u1eadp t\u1ee9c, to\u00e0n b\u1ed9 d\u1eef li\u1ec7u trong worksheet s\u1ebd \u0111\u01b0\u1ee3c ch\u1ecdn m\u00e0 kh\u00f4ng c\u1ea7n d\u00f9ng ph\u00edm t\u1eaft.<\/p>\n

    \"Ch\u1ecdnCh\u1ecdn to\u00e0n b\u1ed9 d\u1eef li\u1ec7u trong b\u1ea3ng t\u00ednh Excel<\/em><\/p>\n

    \n

    4.2. Xem th\u1ed1ng k\u00ea d\u1eef li\u1ec7u<\/h3>\n<\/div>\n

    Excel cho ph\u00e9p b\u1ea1n xem nhanh c\u00e1c th\u1ed1ng k\u00ea c\u01a1 b\u1ea3n c\u1ee7a v\u00f9ng d\u1eef li\u1ec7u m\u00e0 kh\u00f4ng c\u1ea7n d\u00f9ng h\u00e0m t\u00ednh to\u00e1n.<\/p>\n

    C\u00e1ch th\u1ef1c hi\u1ec7n:<\/strong><\/p>\n

      \n
    • D\u00f9ng chu\u1ed9t qu\u00e9t ch\u1ecdn to\u00e0n b\u1ed9 c\u1ed9t ho\u1eb7c v\u00f9ng d\u1eef li\u1ec7u<\/strong> m\u00e0 b\u1ea1n mu\u1ed1n xem th\u1ed1ng k\u00ea.<\/li>\n
    • Ngay sau \u0111\u00f3, Excel s\u1ebd t\u1ef1 \u0111\u1ed9ng hi\u1ec3n th\u1ecb k\u1ebft qu\u1ea3 th\u1ed1ng k\u00ea \u1edf thanh tr\u1ea1ng th\u00e1i (Status Bar)<\/strong> ph\u00eda d\u01b0\u1edbi c\u00f9ng c\u1ee7a c\u1eeda s\u1ed5 l\u00e0m vi\u1ec7c.<\/li>\n<\/ul>\n

      C\u00e1c th\u00f4ng tin hi\u1ec3n th\u1ecb g\u1ed3m c\u00f3:<\/strong><\/p>\n

        \n
      • Average:<\/strong> Gi\u00e1 tr\u1ecb trung b\u00ecnh c\u1ee7a c\u00e1c \u00f4 ch\u1ee9a s\u1ed1.<\/li>\n
      • Count:<\/strong> T\u1ed5ng s\u1ed1 \u00f4 \u0111\u00e3 ch\u1ecdn.<\/li>\n
      • Numerical Count:<\/strong> S\u1ed1 \u00f4 c\u00f3 ch\u1ee9a gi\u00e1 tr\u1ecb s\u1ed1.<\/li>\n
      • Sum:<\/strong> T\u1ed5ng c\u1ee7a c\u00e1c gi\u00e1 tr\u1ecb s\u1ed1 trong v\u00f9ng ch\u1ecdn.<\/li>\n
      • Min:<\/strong> Gi\u00e1 tr\u1ecb nh\u1ecf nh\u1ea5t.<\/li>\n
      • Max:<\/strong> Gi\u00e1 tr\u1ecb l\u1edbn nh\u1ea5t.<\/li>\n<\/ul>\n

        L\u01b0u \u00fd:<\/strong> C\u00e1c m\u1ee5c nh\u01b0 Sum, Average, Min v\u00e0 Max<\/strong> ch\u1ec9 hi\u1ec3n th\u1ecb ch\u00ednh x\u00e1c v\u1edbi d\u1eef li\u1ec7u d\u1ea1ng s\u1ed1<\/strong>.<\/p>\n

        \"XemXem th\u1ed1ng k\u00ea d\u1eef li\u1ec7u nhanh tr\u00ean thanh tr\u1ea1ng th\u00e1i<\/em><\/p>\n

        \n

        4.3. T\u1ef1 \u0111\u1ed9ng nh\u1eadp li\u1ec7u<\/h3>\n<\/div>\n

        T\u00ednh n\u0103ng AutoFill <\/strong>gi\u00fap b\u1ea1n nh\u1eadp nhanh d\u1eef li\u1ec7u l\u1eb7p l\u1ea1i ho\u1eb7c theo quy lu\u1eadt m\u00e0 kh\u00f4ng c\u1ea7n g\u00f5 th\u1ee7 c\u00f4ng t\u1eebng \u00f4.<\/p>\n

        C\u00e1ch th\u1ef1c hi\u1ec7n:<\/strong><\/p>\n

          \n
        • Nh\u1eadp gi\u00e1 tr\u1ecb \u0111\u1ea7u ti\u00ean (ho\u1eb7c 2 gi\u00e1 tr\u1ecb \u0111\u1ea7u n\u1ebfu l\u00e0 d\u00e3y c\u00f3 quy lu\u1eadt, v\u00ed d\u1ee5: 1 v\u00e0 2, Th\u1ee9 Hai v\u00e0 Th\u1ee9 Ba).<\/li>\n
        • Di chuy\u1ec3n chu\u1ed9t \u0111\u1ebfn g\u00f3c d\u01b0\u1edbi b\u00ean ph\u1ea3i c\u1ee7a \u00f4<\/strong> \u2013 con tr\u1ecf s\u1ebd chuy\u1ec3n th\u00e0nh d\u1ea5u \u201c+<\/strong>\u201d nh\u1ecf<\/strong>.<\/li>\n
        • Gi\u1eef chu\u1ed9t v\u00e0 k\u00e9o th\u1ea3 xu\u1ed1ng ho\u1eb7c sang ph\u1ea3i<\/strong> \u0111\u1ec3 sao ch\u00e9p n\u1ed9i dung ban \u0111\u1ea7u.<\/li>\n
        • N\u1ebfu mu\u1ed1n t\u1ea1o chu\u1ed7i t\u1ef1 \u0111\u1ed9ng<\/strong> (v\u00ed d\u1ee5: 1, 2, 3\u2026 ho\u1eb7c Th\u00e1ng 1, Th\u00e1ng 2\u2026), gi\u1eef th\u00eam ph\u00edm Ctrl trong l\u00fac k\u00e9o<\/strong>.<\/li>\n<\/ul>\n

          \"T\u1ef1T\u1ef1 \u0111\u1ed9ng nh\u1eadp li\u1ec7u b\u1eb1ng t\u00ednh n\u0103ng AutoFill<\/em><\/p>\n

          \n

          4.4. Hi\u1ec3n th\u1ecb ng\u00e0y th\u00e1ng<\/h3>\n<\/div>\n

          Excel cho ph\u00e9p b\u1ea1n nh\u1eadp v\u00e0 hi\u1ec3n th\u1ecb ng\u00e0y th\u00e1ng linh ho\u1ea1t theo nhi\u1ec1u \u0111\u1ecbnh d\u1ea1ng kh\u00e1c nhau, gi\u00fap b\u1ea3ng t\u00ednh r\u00f5 r\u00e0ng v\u00e0 chuy\u00ean nghi\u1ec7p h\u01a1n.<\/p>\n

          C\u00e1ch th\u1ef1c hi\u1ec7n:<\/strong><\/p>\n

            \n
          • Nh\u1eadp ng\u00e0y th\u00e1ng theo c\u1ea5u tr\u00fac chu\u1ea9n, v\u00ed d\u1ee5: 12\/11\/2025 ho\u1eb7c 11-12-2025.<\/li>\n
          • Ch\u1ecdn c\u00e1c \u00f4 ch\u1ee9a d\u1eef li\u1ec7u ng\u00e0y th\u00e1ng c\u1ea7n \u0111\u1ecbnh d\u1ea1ng.<\/li>\n
          • Tr\u00ean thanh c\u00f4ng c\u1ee5, v\u00e0o Home \u2192 Number \u2192 ch\u1ecdn m\u0169i t\u00ean m\u1edf r\u1ed9ng (Format Cells).<\/li>\n
          • Trong h\u1ed9p tho\u1ea1i Format Cells, ch\u1ecdn tab Number \u2192 Date.<\/li>\n
          • Ch\u1ecdn ki\u1ec3u hi\u1ec3n th\u1ecb b\u1ea1n mu\u1ed1n (v\u00ed d\u1ee5: dd\/mm\/yyyy, mmm dd, yyyy, ho\u1eb7c Th\u1ee9, Ng\u00e0y Th\u00e1ng N\u0103m).<\/li>\n
          • Nh\u1ea5n OK <\/strong>\u0111\u1ec3 \u00e1p d\u1ee5ng.<\/li>\n<\/ul>\n

            \"\u0110\u1ecbnh\u0110\u1ecbnh d\u1ea1ng hi\u1ec3n th\u1ecb ng\u00e0y th\u00e1ng trong Excel<\/em><\/p>\n

            M\u1eb9o: <\/strong>C\u00f3 th\u1ec3 nh\u1ea5n Ctrl + <\/strong>; \u0111\u1ec3 ch\u00e8n nhanh ng\u00e0y hi\u1ec7n t\u1ea1i<\/strong> v\u00e0o \u00f4 \u0111ang ch\u1ecdn.<\/p>\n

            \"Ch\u00e8nCh\u00e8n nhanh ng\u00e0y hi\u1ec7n t\u1ea1i b\u1eb1ng ph\u00edm t\u1eaft<\/em><\/p>\n

            \n

            4.5. \u1ea8n h\u00e0ng v\u00e0 c\u1ed9t theo nh\u00f3m<\/h3>\n<\/div>\n

            T\u00ednh n\u0103ng Group trong Excel gi\u00fap b\u1ea1n gom c\u00e1c h\u00e0ng ho\u1eb7c c\u1ed9t c\u00f3 li\u00ean quan l\u1ea1i v\u1edbi nhau, sau \u0111\u00f3 c\u00f3 th\u1ec3 \u1ea9n ho\u1eb7c hi\u1ec7n ch\u00fang ch\u1ec9 b\u1eb1ng m\u1ed9t c\u00fa nh\u1ea5p chu\u1ed9t. C\u00e1ch n\u00e0y r\u1ea5t h\u1eefu \u00edch khi l\u00e0m vi\u1ec7c v\u1edbi b\u1ea3ng d\u1eef li\u1ec7u l\u1edbn, \u0111\u1eb7c bi\u1ec7t l\u00e0 b\u00e1o c\u00e1o ho\u1eb7c b\u1ea3ng th\u1ed1ng k\u00ea nhi\u1ec1u ph\u1ea7n.<\/p>\n

            C\u00e1ch th\u1ef1c hi\u1ec7n:<\/strong><\/p>\n

            B\u01b0\u1edbc 1:<\/strong> Ch\u1ecdn c\u00e1c h\u00e0ng ho\u1eb7c c\u1ed9t<\/strong> b\u1ea1n mu\u1ed1n gom nh\u00f3m.<\/p>\n

            V\u00ed d\u1ee5: <\/strong>ch\u1ecdn c\u00e1c h\u00e0ng t\u1eeb 5 \u0111\u1ebfn 10 ho\u1eb7c c\u00e1c c\u1ed9t t\u1eeb A \u0111\u1ebfn D.<\/p>\n

            B\u01b0\u1edbc 2:<\/strong> Tr\u00ean thanh c\u00f4ng c\u1ee5, ch\u1ecdn tab Data \u2192 Group (n\u1eb1m trong nh\u00f3m Outline).<\/p>\n

            Excel s\u1ebd t\u1ef1 \u0111\u1ed9ng th\u00eam d\u1ea5u tr\u1eeb (-)<\/strong> \u1edf ph\u00eda tr\u00e1i (n\u1ebfu nh\u00f3m h\u00e0ng) ho\u1eb7c ph\u00eda tr\u00ean (n\u1ebfu nh\u00f3m c\u1ed9t) \u0111\u1ec3 b\u1ea1n d\u1ec5 d\u00e0ng thu g\u1ecdn ho\u1eb7c m\u1edf r\u1ed9ng.<\/p>\n

            \"Nh\u00f3mNh\u00f3m h\u00e0ng ho\u1eb7c c\u1ed9t b\u1eb1ng t\u00ednh n\u0103ng Group trong tab Data<\/em><\/p>\n

            B\u01b0\u1edbc 3:<\/strong> Nh\u1ea5p v\u00e0o d\u1ea5u \u201c\u2013<\/strong>\u201d \u0111\u1ec3 \u1ea9n nh\u00f3m, v\u00e0 \u201c+<\/strong>\u201d \u0111\u1ec3 hi\u1ec3n th\u1ecb l\u1ea1i.<\/p>\n

            \n

            4.6. Chuy\u1ec3n qua l\u1ea1i gi\u1eefa c\u00e1c b\u1ea3ng t\u00ednh<\/h3>\n<\/div>\n

            Khi l\u00e0m vi\u1ec7c v\u1edbi nhi\u1ec1u b\u1ea3ng t\u00ednh (worksheet) trong c\u00f9ng m\u1ed9t file Excel, b\u1ea1n c\u00f3 th\u1ec3 d\u1ec5 d\u00e0ng di chuy\u1ec3n qua l\u1ea1i gi\u1eefa ch\u00fang b\u1eb1ng nhi\u1ec1u c\u00e1ch kh\u00e1c nhau:<\/p>\n

            C\u00e1ch 1: D\u00f9ng chu\u1ed9t<\/h4>\n
              \n
            • \u1ede thanh tab ph\u00eda d\u01b0\u1edbi c\u00f9ng c\u1ee7a c\u1eeda s\u1ed5 Excel, b\u1ea1n s\u1ebd th\u1ea5y c\u00e1c sheet nh\u01b0 Sheet1, Sheet2, Sheet3\u2026<\/em><\/li>\n
            • Nh\u1ea5p tr\u1ef1c ti\u1ebfp v\u00e0o t\u00ean sheet b\u1ea1n mu\u1ed1n m\u1edf \u0111\u1ec3 chuy\u1ec3n sang b\u1ea3ng t\u00ednh \u0111\u00f3.<\/li>\n<\/ul>\n

              C\u00e1ch 2: D\u00f9ng n\u00fat \u0111i\u1ec1u h\u01b0\u1edbng sheet<\/h4>\n

              \u1ede g\u00f3c d\u01b0\u1edbi b\u00ean tr\u00e1i c\u1ee7a c\u1eeda s\u1ed5 Excel (ngay tr\u01b0\u1edbc c\u00e1c tab sheet), b\u1ea1n s\u1ebd th\u1ea5y hai n\u00fat m\u0169i t\u00ean nh\u1ecf \u0111\u1ec3 di chuy\u1ec3n qua l\u1ea1i gi\u1eefa c\u00e1c sheet khi danh s\u00e1ch b\u1ecb tr\u00e0n ra ngo\u00e0i m\u00e0n h\u00ecnh.<\/p>\n

                \n
              • Nh\u1ea5n chu\u1ed9t tr\u00e1i<\/strong> \u0111\u1ec3 cu\u1ed9n l\u1ea7n l\u01b0\u1ee3t sang tr\u00e1i ho\u1eb7c ph\u1ea3i.<\/li>\n
              • Nh\u1ea5n chu\u1ed9t ph\u1ea3i<\/strong> v\u00e0o m\u1ed9t trong hai n\u00fat n\u00e0y, Excel s\u1ebd hi\u1ec3n th\u1ecb danh s\u00e1ch to\u00e0n b\u1ed9 sheet<\/strong> c\u00f3 trong file.<\/li>\n
              • Ch\u1ecdn sheet b\u1ea1n mu\u1ed1n m\u1edf, Excel s\u1ebd chuy\u1ec3n ngay \u0111\u1ebfn b\u1ea3ng t\u00ednh t\u01b0\u01a1ng \u1ee9ng.<\/li>\n<\/ul>\n

                \"D\u00f9ngD\u00f9ng n\u00fat \u0111i\u1ec1u h\u01b0\u1edbng \u0111\u1ec3 chuy\u1ec3n qua l\u1ea1i gi\u1eefa c\u00e1c b\u1ea3ng t\u00ednh<\/em><\/p>\n

                \n

                4.7. \u0110\u1ed5i c\u1ed9t th\u00e0nh d\u00f2ng, \u0111\u1ed5i d\u00f2ng th\u00e0nh c\u1ed9t<\/h3>\n<\/div>\n

                T\u00ednh n\u0103ng Transpose trong Excel cho ph\u00e9p b\u1ea1n ho\u00e1n \u0111\u1ed5i v\u1ecb tr\u00ed gi\u1eefa h\u00e0ng v\u00e0 c\u1ed9t, gi\u00fap tr\u00ecnh b\u00e0y d\u1eef li\u1ec7u g\u1ecdn g\u00e0ng v\u00e0 d\u1ec5 so s\u00e1nh h\u01a1n m\u00e0 kh\u00f4ng c\u1ea7n nh\u1eadp l\u1ea1i th\u1ee7 c\u00f4ng.<\/p>\n

                B\u01b0\u1edbc 1:<\/strong> Ch\u1ecdn v\u00e0 sao ch\u00e9p v\u00f9ng d\u1eef li\u1ec7u<\/strong> b\u1ea1n mu\u1ed1n ho\u00e1n \u0111\u1ed5i (Ctrl + C).<\/p>\n

                B\u01b0\u1edbc 2:<\/strong> Ch\u1ecdn v\u1ecb tr\u00ed \u00f4 tr\u1ed1ng<\/strong> n\u01a1i b\u1ea1n mu\u1ed1n d\u00e1n d\u1eef li\u1ec7u m\u1edbi.<\/p>\n

                B\u01b0\u1edbc 3: <\/strong>Tr\u00ean thanh c\u00f4ng c\u1ee5, v\u00e0o Home<\/strong> \u2192 Paste <\/strong>\u2192 Paste Special<\/strong>.<\/p>\n

                \"Ch\u1ecdnCh\u1ecdn Paste Special \u0111\u1ec3 ho\u00e1n \u0111\u1ed5i h\u00e0ng v\u00e0 c\u1ed9t<\/em><\/p>\n

                B\u01b0\u1edbc 4:<\/strong> Trong h\u1ed9p tho\u1ea1i Paste Special, \u0111\u00e1nh d\u1ea5u ch\u1ecdn \u00f4 Transpose <\/strong>\u2192 nh\u1ea5n OK<\/strong>.<\/p>\n

                \"\u0110\u00e1nh\u0110\u00e1nh d\u1ea5u Transpose trong Paste Special \u0111\u1ec3 \u0111\u1ed5i v\u1ecb tr\u00ed d\u1eef li\u1ec7u<\/em><\/p>\n

                Excel s\u1ebd t\u1ef1 \u0111\u1ed9ng \u0111\u1ed5i h\u00e0ng th\u00e0nh c\u1ed9t v\u00e0 ng\u01b0\u1ee3c l\u1ea1i.<\/p>\n

                \n

                4.8. C\u00e1ch th\u00eam m\u1ed9t \u0111\u01b0\u1eddng ch\u00e9o trong \u00f4<\/h3>\n<\/div>\n

                \u0110\u01b0\u1eddng ch\u00e9o trong \u00f4 th\u01b0\u1eddng \u0111\u01b0\u1ee3c d\u00f9ng \u0111\u1ec3 chia \u00f4 ti\u00eau \u0111\u1ec1<\/strong>, \u00a0v\u00ed d\u1ee5 \u0111\u1ec3 ghi \u201cH\u00e0ng\u201d \u1edf g\u00f3c tr\u00ean v\u00e0 \u201cC\u1ed9t\u201d \u1edf g\u00f3c d\u01b0\u1edbi, gi\u00fap b\u1ea3ng t\u00ednh g\u1ecdn v\u00e0 d\u1ec5 \u0111\u1ecdc h\u01a1n.<\/p>\n

                B\u01b0\u1edbc 1:<\/strong> Ch\u1ecdn \u00f4 c\u1ea7n k\u1ebb \u0111\u01b0\u1eddng ch\u00e9o.<\/p>\n

                B\u01b0\u1edbc 2:<\/strong> Tr\u00ean thanh c\u00f4ng c\u1ee5, v\u00e0o Home \u2192 nh\u00f3m Font \u2192 bi\u1ec3u t\u01b0\u1ee3ng Borders (vi\u1ec1n \u00f4) \u2192 ch\u1ecdn More Borders (ho\u1eb7c Format Cells \u2192 tab Border).<\/p>\n

                B\u01b0\u1edbc 3:<\/strong> Trong ph\u1ea7n Border, ch\u1ecdn \u0111\u01b0\u1eddng ch\u00e9o t\u1eeb g\u00f3c tr\u00ean tr\u00e1i xu\u1ed1ng g\u00f3c d\u01b0\u1edbi ph\u1ea3i (ho\u1eb7c ng\u01b0\u1ee3c l\u1ea1i).<\/p>\n

                B\u01b0\u1edbc 4:<\/strong> Nh\u1ea5n OK \u0111\u1ec3 ho\u00e0n t\u1ea5t.<\/p>\n

                \"Th\u00eamTh\u00eam \u0111\u01b0\u1eddng ch\u00e9o trong \u00f4 b\u1eb1ng c\u00f4ng c\u1ee5 Borders<\/em><\/p>\n

                Excel s\u1ebd th\u00eam ngay m\u1ed9t \u0111\u01b0\u1eddng ch\u00e9o chia \u00f4 l\u00e0m hai ph\u1ea7n.<\/p>\n

                \n

                4.9. Th\u00eam nhi\u1ec1u d\u00f2ng ho\u1eb7c c\u1ed9t m\u1edbi<\/h3>\n<\/div>\n

                C\u00e1ch 1: Th\u00eam b\u1eb1ng chu\u1ed9t<\/h4>\n

                B\u01b0\u1edbc 1:<\/strong> B\u00f4i \u0111en s\u1ed1 l\u01b0\u1ee3ng d\u00f2ng ho\u1eb7c c\u1ed9t b\u1eb1ng \u0111\u00fang s\u1ed1 l\u01b0\u1ee3ng b\u1ea1n mu\u1ed1n th\u00eam.<\/p>\n

                V\u00ed d\u1ee5:<\/strong> mu\u1ed1n th\u00eam 3 d\u00f2ng m\u1edbi<\/strong>, h\u00e3y ch\u1ecdn s\u1eb5n 3 d\u00f2ng<\/strong> (nh\u1ea5p v\u00e0o s\u1ed1 th\u1ee9 t\u1ef1 c\u1ee7a d\u00f2ng \u1edf b\u00ean tr\u00e1i).<\/p>\n

                B\u01b0\u1edbc 2:<\/strong> Nh\u1ea5p chu\u1ed9t ph\u1ea3i \u2192 ch\u1ecdn Insert<\/strong>.<\/p>\n

                \"Th\u00eamTh\u00eam nhi\u1ec1u d\u00f2ng m\u1edbi b\u1eb1ng c\u00e1ch nh\u1ea5n Insert<\/em><\/p>\n

                Excel s\u1ebd t\u1ef1 \u0111\u1ed9ng ch\u00e8n v\u00e0o 3 d\u00f2ng tr\u1ed1ng ph\u00eda tr\u00ean<\/strong> (ho\u1eb7c 3 c\u1ed9t tr\u1ed1ng b\u00ean tr\u00e1i<\/strong>) c\u1ee7a v\u00f9ng b\u1ea1n \u0111\u00e3 ch\u1ecdn.<\/p>\n

                C\u00e1ch 2: Th\u00eam t\u1eeb thanh c\u00f4ng c\u1ee5<\/h4>\n

                B\u01b0\u1edbc 1:<\/strong> Ch\u1ecdn d\u00f2ng ho\u1eb7c c\u1ed9t m\u00e0 b\u1ea1n mu\u1ed1n ch\u00e8n th\u00eam.<\/p>\n

                B\u01b0\u1edbc 2:<\/strong> V\u00e0o tab Home \u2192 nh\u00f3m Cells \u2192 Insert, sau \u0111\u00f3 ch\u1ecdn m\u1ed9t trong c\u00e1c t\u00f9y ch\u1ecdn:<\/p>\n

                  \n
                • Insert Sheet Rows<\/strong> \u2192 th\u00eam d\u00f2ng.<\/li>\n
                • Insert Sheet Columns<\/strong> \u2192 th\u00eam c\u1ed9t.<\/li>\n<\/ul>\n

                  \"Th\u00eamTh\u00eam d\u00f2ng ho\u1eb7c c\u1ed9t t\u1eeb thanh c\u00f4ng c\u1ee5 Insert<\/em><\/p>\n

                  Tr\u00ean \u0111\u00e2y l\u00e0 nh\u1eefng thao t\u00e1c c\u01a1 b\u1ea3n gi\u00fap b\u1ea1n s\u1eed d\u1ee5ng Excel hi\u1ec7u qu\u1ea3 h\u01a1n, t\u1eeb kh\u1edfi \u0111\u1ed9ng, t\u1ea1o b\u1ea3ng t\u00ednh \u0111\u1ebfn ch\u1ec9nh s\u1eeda v\u00e0 qu\u1ea3n l\u00fd d\u1eef li\u1ec7u. H\u00e3y th\u01b0\u1eddng xuy\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 h\u1eefu \u00edch.<\/p>\n

                  N\u1ebfu b\u1ea1n th\u01b0\u1eddng xuy\u00ean l\u00e0m vi\u1ec7c v\u1edbi Excel hay c\u00e1c ph\u1ea7n m\u1ec1m v\u0103n ph\u00f2ng, \u0111\u1eebng qu\u00ean trang b\u1ecb cho m\u00ecnh nh\u1eefng ph\u1ee5 ki\u1ec7n vi t\u00ednh ch\u1ea5t l\u01b0\u1ee3ng. Kh\u00e1m ph\u00e1 ngay c\u00e1c s\u1ea3n ph\u1ea9m ch\u00ednh h\u00e3ng, gi\u00e1 t\u1ed1t t\u1ea1i Si\u00eau Th\u1ecb \u0110i\u1ec7n M\u00e1y – N\u1ed9i Th\u1ea5t Ch\u1ee3 L\u1edbn \u0111\u1ec3 l\u00e0m vi\u1ec7c hi\u1ec7u qu\u1ea3 v\u00e0 tho\u1ea3i m\u00e1i h\u01a1n m\u1ed7i ng\u00e0y.<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"

                  Excel l\u00e0 c\u00f4ng c\u1ee5 h\u1ed7 tr\u1ee3 \u0111\u1eafc l\u1ef1c trong c\u00f4ng vi\u1ec7c v\u0103n ph\u00f2ng. B\u00e0i vi\u1ebft n\u00e0y s\u1ebd h\u01b0\u1edbng d\u1eabn b\u1ea1n chi ti\u1ebft t\u1eeb c\u00e1ch kh\u1edfi \u0111\u1ed9ng, t\u1ea1o workbook m\u1edbi, th\u00eam ho\u1eb7c x\u00f3a worksheet \u0111\u1ebfn c\u00e1c thao t\u00e1c c\u01a1 b\u1ea3n nh\u01b0 nh\u1eadp li\u1ec7u, \u1ea9n nh\u00f3m h\u00e0ng c\u1ed9t, ch\u00e8n \u0111\u01b0\u1eddng ch\u00e9o v\u00e0 \u0111\u1ecbnh d\u1ea1ng d\u1eef li\u1ec7u. H\u01b0\u1edbng […]<\/p>\n","protected":false},"author":1,"featured_media":4569,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[8],"tags":[],"class_list":["post-4568","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\/19286.jpg","_links":{"self":[{"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/posts\/4568","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=4568"}],"version-history":[{"count":0,"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/posts\/4568\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/media\/4569"}],"wp:attachment":[{"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/media?parent=4568"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/categories?post=4568"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/tags?post=4568"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}