{"id":7571,"date":"2021-08-12T14:43:24","date_gmt":"2021-08-12T07:43:24","guid":{"rendered":"https:\/\/tct.vn\/blog\/?p=7571"},"modified":"2021-08-18T11:08:32","modified_gmt":"2021-08-18T04:08:32","slug":"7-meo-giup-dung-excel-hieu-qua-va-nhanh-hon","status":"publish","type":"post","link":"https:\/\/tct.vn\/blog\/7-meo-giup-dung-excel-hieu-qua-va-nhanh-hon\/","title":{"rendered":"7 m\u1eb9o gi\u00fap d\u00f9ng excel hi\u1ec7u qu\u1ea3 v\u00e0 nhanh h\u01a1n"},"content":{"rendered":"

1. D\u00f9ng m\u1eabu c\u00f3 s\u1eb5n (template)<\/strong><\/h3>\n

M\u1ed9t trong nh\u1eefng c\u00e1ch ti\u1ebft ki\u1ec7m th\u1eddi gian t\u1ed1t nh\u1ea5t cho h\u1ea7u h\u1ebft m\u1ecdi t\u00e1c v\u1ee5 l\u00e0 s\u1eed d\u1ee5ng c\u00e1c m\u1eabu (template). B\u1ea1n c\u00f3 th\u1ec3 d\u00f9ng template timeline d\u1ef1 \u00e1n, l\u1ecbch, h\u00f3a \u0111\u01a1n, ng\u00e2n s\u00e1ch v\u00e0 nhi\u1ec1u m\u1eabu kh\u00e1c. L\u1ee3i d\u1ee5ng nh\u1eefng c\u00f4ng c\u1ee5 \u0111\u1ecbnh d\u1ea1ng s\u1eb5n, l\u1ea1i c\u1ef1c k\u1ef3 thu\u1eadn ti\u1ec7n n\u00e0y ch\u1eafc ch\u1eafn s\u1ebd gi\u00fap ti\u1ebft ki\u1ec7m \u0111\u01b0\u1ee3c nhi\u1ec1u th\u1eddi gian v\u00e0 c\u00f4ng s\u1ee9c.<\/p>\n

Vi\u1ec7c thu th\u1eadp c\u00e1c m\u1eabu b\u1ea3ng t\u00ednh c\u1ea7n thi\u1ebft c\u0169ng d\u1ec5 d\u00e0ng nh\u01b0 khi s\u1eed d\u1ee5ng ch\u00fang. Trang web c\u1ee7a Microsoft cung c\u1ea5p r\u1ea5t nhi\u1ec1u m\u1eabu Excel kh\u00e1c nhau cho l\u1ecbch, k\u1ebf ho\u1ea1ch, c\u00f4ng c\u1ee5 theo d\u00f5i, b\u1ea3ng th\u1eddi gian,\u2026 Vertex24 c\u00f3 nhi\u1ec1u l\u1ef1a ch\u1ecdn m\u1eabu th\u00fa v\u1ecb cho l\u1ecbch, ng\u00e2n s\u00e1ch, danh s\u00e1ch vi\u1ec7c c\u1ea7n l\u00e0m v\u00e0 b\u1ea3ng c\u00e2n \u0111\u1ed1i. M\u1ed9t ngu\u1ed3n m\u1eabu Excel kh\u1ed5ng l\u1ed3 cho h\u00f3a \u0111\u01a1n, h\u00e0ng t\u1ed3n kho, form \u0111\u0103ng nh\u1eadp,\u2026 l\u00e0 Spreadsheet 123.<\/p>\n

\"\"

S\u1eed d\u1ee5ng excel b\u1eb1ng s\u1eed d\u1ee5ng m\u1eabu<\/p><\/div>\n

 <\/p>\n

2. C\u1ed1 \u0111\u1ecbnh h\u00e0ng v\u00e0 c\u1ed9t khi s\u1eed d\u1ee5ng Excel<\/strong><\/h3>\n

N\u1ebfu c\u00f3 m\u1ed9t b\u1ea3ng d\u00e0i ch\u1ee9a h\u00e0ng t\u1ea5n d\u1eef li\u1ec7u, b\u1ea1n c\u00f3 th\u1ec3 ph\u1ea3i cu\u1ed9n chu\u1ed9t xu\u1ed1ng ho\u1eb7c l\u00ean r\u1ea5t l\u00e2u \u0111\u1ec3 c\u00f3 th\u1ec3 t\u00ecm \u0111\u1ebfn v\u00f9ng m\u00ecnh c\u1ea7n, nh\u01b0ng khi t\u00ecm \u0111\u01b0\u1ee3c d\u1eef li\u1ec7u l\u1ea1i kh\u00f4ng bi\u1ebft n\u00f3 l\u00e0 c\u00e1i g\u00ec, do d\u00f2ng ti\u00eau \u0111\u1ec1 kh\u00f4ng th\u1ec3 nh\u00ecn th\u1ea5y. \u0110i\u1ec1u n\u00e0y r\u1ea5t m\u1ea5t th\u1eddi gian khi ph\u1ea3i k\u00e9o l\u00ean k\u00e9o xu\u1ed1ng li\u00ean t\u1ee5c ch\u1ec9 \u0111\u1ec3 xem ti\u00eau \u0111\u1ec1 c\u1ee7a d\u1eef li\u1ec7u. Tuy nhi\u00ean, n\u1ebfu \u0111\u00f3ng b\u0103ng c\u00e1c h\u00e0ng v\u00e0 c\u1ed9t th\u00ec nh\u1eefng ti\u00eau \u0111\u1ec1 v\u1eabn s\u1ebd \u0111\u01b0\u1ee3c gi\u1eef nguy\u00ean khi di chuy\u1ec3n chu\u1ed9t trong b\u1ea3ng t\u00ednh.<\/p>\n

V\u00e0o tab\u00a0View > Freeze Panes<\/strong>\u00a0tr\u00ean d\u1ea3i Ribbon. Trong menu th\u1ea3 xu\u1ed1ng c\u1ee7a Freeze Panes, ch\u1ecdn\u00a0Freezze Panes<\/strong>\u00a0(\u0111\u00f3ng b\u0103ng c\u1ea3 h\u00e0ng tr\u00ean c\u00f9ng v\u00e0 c\u1ed9t \u0111\u1ea7u ti\u00ean),\u00a0Freeze Top Row\u00a0<\/strong>(\u0111\u00f3ng b\u0103ng h\u00e0ng tr\u00ean c\u00f9ng c\u1ee7a b\u1ea3ng t\u00ednh),\u00a0Freeze First Column<\/strong>\u00a0(\u0111\u00f3ng b\u0103ng c\u1ed9t \u0111\u1ea7u ti\u00ean c\u1ee7a b\u1ea3ng t\u00ednh).<\/p>\n

\"\"

C\u1ed1 \u0111\u1ecbnh h\u00e0ng v\u00e0 c\u1ed9t khi s\u1eed d\u1ee5ng excel<\/p><\/div>\n

B\u00e2y gi\u1edd, khi cu\u1ed9n chu\u1ed9t xu\u1ed1ng d\u01b0\u1edbi, l\u00ean tr\u00ean, sang ph\u1ea3i, sang tr\u00e1i, b\u1ea1n s\u1ebd th\u1ea5y c\u1ed9t v\u00e0 h\u00e0ng \u0111\u00e3 \u0111\u00f3ng b\u0103ng kh\u00f4ng b\u1ecb di chuy\u1ec3n v\u00e0 lu\u00f4n \u1edf trong t\u1ea7m m\u1eaft. \u0110\u1ec3 h\u1ee7y b\u1ecf \u0111\u00f3ng b\u0103ng nh\u1eefng h\u00e0ng, c\u1ed9t n\u00e0y, ch\u1ec9 c\u1ea7n ch\u1ecdn l\u1ec7nh\u00a0Freeze Panes<\/strong>\u00a0l\u1ea7n n\u1eefa v\u00e0 nh\u1ea5p v\u00e0o\u00a0Unfreeze Panes<\/strong>.<\/p>\n

L\u01b0u \u00fd:<\/u><\/strong>\u00a0V\u1edbi nh\u1eefng phi\u00ean b\u1ea3n Excel c\u0169 h\u01a1n, qu\u00e1 tr\u00ecnh tr\u00ean c\u00f3 th\u1ec3 kh\u00e1c bi\u1ec7t \u0111\u00f4i ch\u00fat. Ch\u1ecdn \u00f4 chung cho c\u1ea3 h\u00e0ng v\u00e0 c\u1ed9t mu\u1ed1n \u0111\u00f3ng b\u0103ng, sau \u0111\u00f3 nh\u1ea5p v\u00e0o\u00a0Freeze Panes<\/strong>.<\/p>\n

3. S\u1eed d\u1ee5ng Fill Handle<\/strong><\/h3>\n

Fill Handle l\u00e0 m\u1ed9t d\u1ea5u ch\u1ea5m \u0111en xu\u1ea5t hi\u1ec7n \u1edf g\u00f3c d\u01b0\u1edbi b\u00ean ph\u1ea3i khi ch\u1ecdn m\u1ed9t ho\u1eb7c m\u1ed9t nh\u00f3m c\u00e1c \u00f4 trong m\u1ed9t c\u1ed9t. Bi\u1ebft c\u00e1ch s\u1eed d\u1ee5ng Fill Handle s\u1ebd gi\u00fap b\u1ea1n ti\u1ebft ki\u1ec7m \u0111\u01b0\u1ee3c h\u00e0ng t\u1ea5n th\u1eddi gian khi c\u1ea7n ph\u1ea3i \u0111i\u1ec1n d\u1eef li\u1ec7u nh\u01b0 s\u1ed1 th\u1ee9 t\u1ef1, ng\u00e0y, th\u00e1ng, n\u0103m li\u00ean t\u1ee5c v\u00e0o nhi\u1ec1u \u00f4. C\u00f3 v\u00e0i c\u00e1ch \u0111\u1ec3 s\u1eed d\u1ee5ng Fill Handle.<\/p>\n

\u0110\u1ea7u ti\u00ean, c\u00f3 th\u1ec3 nhanh ch\u00f3ng t\u1ea1o ra danh s\u00e1ch c\u00e1c s\u1ed1 \u0111\u1ebfm b\u1eb1ng c\u00e1ch nh\u1eadp 1 v\u00e0o \u00f4 \u0111\u1ea7u ti\u00ean, 2 v\u00e0o \u00f4 b\u00ean d\u01b0\u1edbi n\u00f3, r\u1ed3i ch\u1ecdn c\u1ea3 hai \u00f4, Fill Handle xu\u1ea5t hi\u1ec7n, k\u00e9o xu\u1ed1ng c\u00e1c \u00f4 b\u00ean d\u01b0\u1edbi cho \u0111\u1ebfn khi \u0111\u1ea1t \u0111\u1ebfn s\u1ed1 mong mu\u1ed1n. Kh\u00f4ng nh\u1ea5t thi\u1ebft ph\u1ea3i \u0111i\u1ec1n t\u1eeb 1, b\u1ea1n c\u00f3 th\u1ec3 l\u00e0m t\u1eeb b\u1ea5t c\u1ee9 s\u1ed1 n\u00e0o nh\u01b0 15, 20, nh\u01b0ng n\u00f3 ch\u1ec9 c\u00f3 th\u1ec3 t\u1ea1o ra m\u1ed9t d\u00e3y s\u1ed1 ti\u1ebfn, li\u00ean t\u1ee5c. Ngh\u0129a l\u00e0 n\u1ebfu \u0111i\u1ec1n 15, b\u1ea1n s\u1ebd t\u1ea1o \u0111c danh s\u00e1ch t\u1eeb 15, 16, 17, 18,\u2026<\/p>\n

\"\"<\/p>\n

Khi s\u1eed d\u1ee5ng t\u00ednh n\u0103ng n\u00e0y cho ng\u00e0y th\u00e1ng, ch\u1ec9 c\u1ea7n \u0111i\u1ec1n v\u00e0o m\u1ed9t ng\u00e0y b\u1ea5t k\u1ef3 nh\u01b0 05\/01\/2017, ch\u1ecdn \u00f4 \u0111\u00f3 v\u00e0 k\u00e9o xu\u1ed1ng d\u01b0\u1edbi, Excel s\u1ebd t\u1ef1 \u0111\u1ed9ng t\u0103ng ng\u00e0y th\u00e1ng \u0111\u00fang y nh\u01b0 l\u1ecbch. Thao t\u00e1c n\u00e0y c\u0169ng c\u00f3 th\u1ec3 \u00e1p d\u1ee5ng khi c\u1ea7n t\u1ea1o c\u1ed9t cho c\u00e1c th\u00e1ng trong n\u0103m hay c\u00e1c ng\u00e0y trong tu\u1ea7n.<\/p>\n

\"\"<\/p>\n

M\u1ed9t c\u00e1ch s\u1eed s\u1ee5ng h\u1eefu \u00edch kh\u00e1c l\u00e0 khi c\u1ea7n \u0111i\u1ec1n gi\u00e1 tr\u1ecb t\u01b0\u01a1ng t\u1ef1 v\u00e0o to\u00e0n b\u1ed9 c\u1ed9t trong b\u1ea3ng t\u00ednh. V\u00ed d\u1ee5, \u0111i\u1ec1n v\u00e0o \u00f4 ch\u1eef c\u00e1i A, ch\u1ecdn \u00f4 v\u00e0 nh\u1ea5p \u0111\u00fap chu\u1ed9t v\u00e0o Fill Handle. Thao t\u00e1c n\u00e0y s\u1ebd nh\u1eadp gi\u00e1 tr\u1ecb A cho t\u1ea5t c\u1ea3 c\u00e1c \u00f4 c\u00f2n l\u1ea1i c\u1ee7a c\u1ed9t trong b\u1ea3ng t\u00ednh.<\/p>\n

4. Chuy\u1ec3n \u0111\u1ed5i gi\u1eefa c\u1ed9t v\u00e0 h\u00e0ng khi s\u1eed d\u1ee5ng Excel<\/strong><\/h3>\n

N\u1ebfu b\u1ea1n c\u00f3 m\u1ed9t b\u1ea3ng t\u00ednh s\u1eed d\u1ee5ng c\u00e1c \u0111\u1ec1 m\u1ee5c trong c\u1ed9t ho\u1eb7c h\u00e0ng (ho\u1eb7c c\u1ea3 2) v\u00e0 ngh\u0129 r\u1eb1ng khi \u0111\u1ed5i c\u1ed9t cho h\u00e0ng th\u00ec b\u1ea3ng t\u00ednh s\u1ebd tr\u1ef1c quan h\u01a1n th\u00ec h\u00e3y s\u1eed d\u1ee5ng m\u1eb9o n\u00e0y \u0111\u1ec3 th\u1ef1c hi\u1ec7n nhanh ch\u00f3ng v\u00e0 d\u1ec5 d\u00e0ng. N\u00f3 gi\u00fap b\u1ea1n ti\u1ebft ki\u1ec7m nhi\u1ec1u th\u1eddi gian h\u01a1n khi kh\u00f4ng ph\u1ea3i g\u00f5 l\u1ea1i c\u00e1c ti\u00eau \u0111\u1ec1.<\/p>\n

D\u01b0\u1edbi \u0111\u00e2y l\u00e0 c\u00e1c b\u01b0\u1edbc \u0111\u1ec3 di chuy\u1ec3n c\u00e1c \u00f4 t\u1eeb h\u00e0ng ti\u00eau \u0111\u1ec1 sang c\u1ed9t ti\u00eau \u0111\u1ec1:<\/strong><\/p>\n

    \n
  • Ch\u1ecdn c\u00e1c \u00f4 trong c\u1ed9t ch\u1ee9a ti\u00eau \u0111\u1ec1.<\/li>\n
  • Nh\u1ea5p chu\u1ed9t ph\u1ea3i, ch\u1ecdn\u00a0Copy<\/strong>\u00a0ho\u1eb7c nh\u1ea5p v\u00e0o n\u00fat\u00a0Copy<\/strong>\u00a0tr\u00ean tab\u00a0Home<\/strong>\u00a0c\u1ee7a d\u1ea3i Ribbon.<\/li>\n
  • Ch\u1ecdn \u00f4 trong h\u00e0ng v\u00e0 c\u1ed9t b\u1ea1n mu\u1ed1n c\u00e1c ti\u00eau \u0111\u1ec1 b\u1eaft \u0111\u1ea7u.<\/li>\n
  • Nh\u1ea5p chu\u1ed9t ph\u1ea3i v\u00e0 ch\u1ecdn\u00a0Paste Special<\/strong>\u00a0ho\u1eb7c nh\u1ea5p\u00a0Paste > Paste Special<\/strong>\u00a0tr\u00ean tab\u00a0Home<\/strong>\u00a0c\u1ee7a d\u1ea3i Ribbon.<\/li>\n
  • T\u00edch v\u00e0o h\u1ed9p checkbox\u00a0Transpose<\/strong>\u00a0\u1edf g\u00f3c d\u01b0\u1edbi b\u00ean ph\u1ea3i.<\/li>\n
  • Nh\u1ea5n\u00a0OK<\/strong>\u00a0v\u00e0 xem k\u1ebft qu\u1ea3.<\/li>\n<\/ul>\n

    \"\"<\/p>\n

    5. Truy c\u1eadp m\u00e1y t\u00ednh khi s\u1eed d\u1ee5ng Excel<\/strong><\/h3>\n

    B\u00ean c\u1ea1nh vi\u1ec7c h\u1ed7 tr\u1ee3 add-in m\u00e1y t\u00ednh t\u1eeb b\u00ean ngo\u00e0i, Excel c\u0169ng t\u00edch h\u1ee3p s\u1eb5n t\u00ednh n\u0103ng m\u00e1y t\u00ednh, do \u0111\u00f3 n\u1ebfu kh\u00f4ng mu\u1ed1n c\u00e0i th\u00eam add-in, b\u1ea1n c\u00f3 th\u1ec3 t\u1eadn d\u1ee5ng l\u1ee3i th\u1ebf c\u1ee7a m\u00e1y t\u00ednh c\u00f3 s\u1eb5n n\u00e0y. \u0110i\u1ec1u n\u00e0y s\u1ebd ti\u1ec7n l\u1ee3i trong tr\u01b0\u1eddng h\u1ee3p mu\u1ed1n t\u00ednh to\u00e1n nhanh ch\u00f3ng ph\u00e9p t\u00ednh kh\u00f4ng \u0111\u01b0\u1ee3c x\u00e2y d\u1ef1ng trong b\u1ea3ng t\u00ednh.<\/p>\n

    Khi s\u1eed d\u1ee5ng Excel cho ph\u00e9p th\u00eam m\u00e1y t\u00ednh v\u00e0o c\u1ea3 d\u1ea3i Ribbon v\u00e0 thanh c\u00f4ng c\u1ee5 Quick Access.<\/p>\n

    \u0110\u1ec3 th\u00eam m\u00e1y t\u00ednh v\u00e0o 2 v\u1ecb tr\u00ed n\u00e0y, b\u1eaft \u0111\u1ea7u b\u1eb1ng c\u00e1ch ch\u1ecdn\u00a0File > Options<\/strong>. Sau \u0111\u00f3, ch\u1ecdnCustomize Ribbon<\/strong>\u00a0(th\u00eam m\u00e1y t\u00ednh v\u00e0o d\u1ea3i Ribbon) ho\u1eb7c\u00a0Quick Access Toolbar<\/strong>\u00a0(th\u00eam v\u00e0o Quick Access), t\u00f9y thu\u1ed9c v\u00e0o v\u1ecb tr\u00ed b\u1ea1n mu\u1ed1n.<\/p>\n

    Trong\u00a0Choose commands from: > All Commands > Calculator<\/strong>\u00a0v\u00e0 nh\u1ea5n\u00a0Add >><\/strong>\u00a0\u0111\u1ec3 th\u00eam m\u00e1y t\u00ednh v\u00e0o thanh c\u00f4ng c\u1ee5 Quick Access. N\u1ebfu th\u00eam v\u00e0o Ribbon th\u00ec c\u1ea7n t\u1ea1o m\u1ed9t nh\u00f3m t\u00f9y ch\u1ec9nh r\u1ed3i th\u00eam m\u00e1y t\u00ednh v\u00e0o \u0111\u00f3.<\/p>\n

    \"\"<\/p>\n

    Truy c\u1eadp m\u00e1y t\u00ednh khi s\u1eed d\u1ee5ng excecl<\/em><\/p>\n

    6. Li\u00ean k\u1ebft c\u00e1c tab ho\u1eb7c c\u00e1c c\u1ed9t<\/strong><\/h3>\n

    N\u1ebfu s\u1eed d\u1ee5ng Excel\u00a0 file c\u1ee7a b\u1ea1n c\u00f3 ch\u1ee9a nhi\u1ec1u b\u1ea3ng t\u00ednh v\u1edbi d\u1eef li\u1ec7u \u0111\u01b0\u1ee3c tham chi\u1ebfu ch\u00e9o gi\u1eefa ch\u00fang th\u00ec vi\u1ec7c t\u1ea1o ra m\u1ed9t li\u00ean k\u1ebft tr\u1ef1c ti\u1ebfp s\u1ebd gi\u00fap truy c\u1eadp nhanh h\u01a1n. \u0110i\u1ec1u n\u00e0y \u0111\u1eb7c bi\u1ec7t h\u1eefu \u00edch n\u1ebfu c\u1ea7n chia s\u1ebb b\u1ea3ng t\u00ednh v\u1edbi nh\u1eefng ng\u01b0\u1eddi kh\u00e1c \u0111\u1ec3 h\u1ecd c\u00f3 th\u1ec3 di chuy\u1ec3n \u0111\u1ebfn d\u1eef li\u1ec7u \u0111\u01b0\u1ee3c tham chi\u1ebfu m\u1ed9t c\u00e1ch nhanh ch\u00f3ng.<\/p>\n

    Th\u1ef1c hi\u1ec7n theo c\u00e1c b\u01b0\u1edbc \u0111\u01a1n gi\u1ea3n d\u01b0\u1edbi \u0111\u00e2y \u0111\u1ec3 t\u1ea1o li\u00ean k\u1ebft:<\/strong><\/p>\n

      \n
    • Ch\u1ecdn \u00f4 c\u00f3 ch\u1ee9a d\u1eef li\u1ec7u mu\u1ed1n li\u00ean k\u1ebft.<\/li>\n
    • Nh\u1ea5p chu\u1ed9t ph\u1ea3i ch\u1ecdn\u00a0Hyperlink<\/strong>\u00a0ho\u1eb7c \u0111i \u0111\u1ebfn tab\u00a0Insert<\/strong>, ch\u1ecdn<\/li>\n
    • Trong c\u1eeda s\u1ed5 pop-up hi\u1ec7n ra, ch\u1ecdn\u00a0Place in this Document.<\/strong><\/li>\n
    • Sau \u0111\u00f3 nh\u1eadp v\u0103n b\u1ea3n \u0111\u1ec3 hi\u1ec3n th\u1ecb trong \u00f4 \u0111\u00f3, nh\u1eadp m\u1ed9t tham chi\u1ebfu \u00f4 c\u1ee5 th\u1ec3 n\u1ebfu mu\u1ed1n v\u00e0 b\u1ea3ng t\u00ednh trong file Excel v\u1edbi d\u1eef li\u1ec7u \u0111ang li\u00ean k\u1ebft \u0111\u1ebfn.<\/li>\n
    • Nh\u1ea5n OK<\/li>\n<\/ul>\n
      \"\"

      Li\u00ean k\u1ebft c\u00e1 Tab ho\u1eb7c c\u00e1c c\u1ed9t<\/p><\/div>\n

       <\/p>\n

      7. S\u1eed d\u1ee5ng ph\u00edm t\u1eaft c\u1ee7a Excel<\/strong><\/h3>\n

      Th\u01b0\u1eddng xuy\u00ean s\u1eed d\u1ee5ng c\u00e1c ph\u00edm t\u1eaft khi s\u1eed d\u1ee5ng Excel ch\u1eafc ch\u1eafn l\u00e0 m\u1ed9t gi\u1ea3i ph\u00e1p ti\u1ebft ki\u1ec7m th\u1eddi gian hi\u1ec7u qu\u1ea3.<\/p>\n

      D\u01b0\u1edbi \u0111\u00e2y l\u00e0 m\u1ed9t s\u1ed1 ph\u00edm t\u1eaft c\u00f3 th\u1ec3 t\u0103ng t\u1ed1c \u0111\u1ed9 c\u00f4ng vi\u1ec7c m\u1ed9t c\u00e1ch \u0111\u00e1ng k\u1ec3:<\/strong><\/p>\n

        \n
      • F4\u00a0<\/strong>ho\u1eb7c\u00a0Fn + F4<\/strong>\u00a0\u0111\u1ec3 l\u1eb7p l\u1ea1i l\u1ec7nh cu\u1ed1i c\u00f9ng, bao g\u1ed3m thay \u0111\u1ed5i \u0111\u1ecbnh d\u1ea1ng nh\u01b0 m\u00e0u s\u1eafc ho\u1eb7c ph\u00f4ng ch\u1eef<\/li>\n
      • Alt + H, E, A<\/strong>\u00a0\u0111\u1ec3 x\u00f3a c\u00e1c n\u1ed9i dung, \u0111\u1ecbnh d\u1ea1ng v\u00e0 d\u1eef li\u1ec7u \u0111\u00ednh k\u00e8m kh\u00e1c trong \u00f4 \u0111\u01b0\u1ee3c ch\u1ecdn<\/li>\n
      • Ctrl + W<\/strong>\u00a0\u0111\u1ec3 \u0111\u00f3ng b\u1ea3ng t\u00ednh v\u00e0\u00a0Ctrl + O<\/strong>\u00a0\u0111\u1ec3 m\u1edf b\u1ea3ng m\u1edbi<\/li>\n
      • Ctrl + Shift + :<\/strong>\u00a0(d\u1ea5u hai ch\u1ea5m) \u0111\u1ec3 nh\u1eadp v\u00e0o th\u1eddi gian hi\u1ec7n t\u1ea1i v\u00e0\u00a0Ctrl + Shift + ;<\/strong>\u00a0(d\u1ea5u ch\u1ea5m ph\u1ea9y) \u0111\u1ec3 nh\u1eadp v\u00e0o ng\u00e0y hi\u1ec7n t\u1ea1i<\/li>\n
      • Shift + F9<\/strong>\u00a0\u0111\u1ec3 t\u00ednh to\u00e1n c\u00e1c b\u1ea3ng t\u00ednh \u0111ang ho\u1ea1t \u0111\u1ed9ng<\/li>\n
      • Shift + Tab<\/strong>\u00a0\u0111\u1ec3 di chuy\u1ec3n \u0111\u1ebfn \u00f4 tr\u01b0\u1edbc ho\u1eb7c t\u00f9y ch\u1ecdn<\/li>\n
      • Ctrl + Home<\/strong>\u00a0\u0111\u1ec3 di chuy\u1ec3n \u0111\u1ebfn \u0111\u1ea7u b\u1ea3ng t\u00ednh<\/li>\n
      • Ctrl + Page Down<\/strong>\u00a0\u0111\u1ec3 di chuy\u1ec3n \u0111\u1ebfn b\u1ea3ng ti\u1ebfp theo trong m\u1ed9t file Excel v\u00e0\u00a0Ctrl + Page Up<\/strong>\u00a0\u0111\u1ec3 di chuy\u1ec3n \u0111\u1ebfn b\u1ea3ng t\u00ednh tr\u01b0\u1edbc \u0111\u00f3<\/li>\n<\/ul>\n

        Tr\u00ean \u0111\u00e2y ch\u1ec9 l\u00e0 v\u00e0i th\u1ee7 thu\u1eadt nh\u1ecf gi\u00fap b\u1ea1n \u0111\u1ecdc ti\u1ebft ki\u1ec7m th\u1eddi gian khi s\u1eed d\u1ee5ng Excel. N\u1ebfu y\u00eau th\u00edch c\u0169ng nh\u01b0 th\u01b0\u1eddng xuy\u00ean s\u1eed d\u1ee5ng Excel, b\u1ea1n c\u00f3 th\u1ec3 \u0111\u00f3ng g\u00f3p nh\u1eefng m\u1eb9o ti\u1ebft ki\u1ec7m th\u1eddi gian m\u00e0 m\u00ecnh \u0111\u00e3 t\u00ecm \u0111\u01b0\u1ee3c v\u00e0 chia s\u1ebb v\u1edbi m\u1ecdi ng\u01b0\u1eddi \u1edf ph\u1ea7n b\u00ecnh lu\u1eadn b\u00ean d\u01b0\u1edbi b\u00e0i vi\u1ebft.<\/p>\n","protected":false},"excerpt":{"rendered":"

        1. D\u00f9ng m\u1eabu c\u00f3 s\u1eb5n (template) M\u1ed9t trong nh\u1eefng c\u00e1ch ti\u1ebft ki\u1ec7m th\u1eddi gian t\u1ed1t nh\u1ea5t cho h\u1ea7u h\u1ebft m\u1ecdi t\u00e1c v\u1ee5 l\u00e0 s\u1eed d\u1ee5ng c\u00e1c m\u1eabu (template). B\u1ea1n c\u00f3 th\u1ec3 d\u00f9ng template timeline d\u1ef1 \u00e1n, l\u1ecbch, h\u00f3a \u0111\u01a1n, ng\u00e2n s\u00e1ch v\u00e0 nhi\u1ec1u m\u1eabu kh\u00e1c. L\u1ee3i d\u1ee5ng nh\u1eefng c\u00f4ng c\u1ee5 \u0111\u1ecbnh d\u1ea1ng s\u1eb5n, l\u1ea1i c\u1ef1c […]<\/p>\n","protected":false},"author":3,"featured_media":7579,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[508],"tags":[],"class_list":["post-7571","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-office"],"_links":{"self":[{"href":"https:\/\/tct.vn\/blog\/wp-json\/wp\/v2\/posts\/7571","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/tct.vn\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/tct.vn\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/tct.vn\/blog\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/tct.vn\/blog\/wp-json\/wp\/v2\/comments?post=7571"}],"version-history":[{"count":0,"href":"https:\/\/tct.vn\/blog\/wp-json\/wp\/v2\/posts\/7571\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/tct.vn\/blog\/wp-json\/wp\/v2\/media\/7579"}],"wp:attachment":[{"href":"https:\/\/tct.vn\/blog\/wp-json\/wp\/v2\/media?parent=7571"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/tct.vn\/blog\/wp-json\/wp\/v2\/categories?post=7571"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/tct.vn\/blog\/wp-json\/wp\/v2\/tags?post=7571"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}