{"id":11192,"date":"2025-01-15T02:01:38","date_gmt":"2025-01-15T02:01:38","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/15\/huong-dan-su-dung-toi-uu-cac-phim-tat-trong-excel\/"},"modified":"2025-01-15T02:01:38","modified_gmt":"2025-01-15T02:01:38","slug":"huong-dan-su-dung-toi-uu-cac-phim-tat-trong-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/15\/huong-dan-su-dung-toi-uu-cac-phim-tat-trong-excel\/","title":{"rendered":"H\u01b0\u1edbng D\u1eabn S\u1eed D\u1ee5ng T\u1ed1i \u01afu C\u00e1c Ph\u00edm T\u1eaft Trong Excel"},"content":{"rendered":"
\n

Ng\u01b0\u1eddi d\u00f9ng Excel- \u0111\u1eb7c bi\u1ec7t l\u00e0 c\u00e1c nh\u00e0 ph\u00e2n t\u00edch c\u1ea7n s\u1eed d\u1ee5ng ph\u00edm t\u1eaft \u0111\u1ec3 t\u0103ng t\u1ed1c \u0111\u1ed9 x\u1eed l\u00fd d\u1eef li\u1ec7u v\u00e0 truy\u1ec1n \u0111\u1ea1t ch\u00fang th\u00e0nh nh\u1eefng th\u00f4ng tin h\u1eefu \u00edch.<\/p>\n

Th\u1ef1c s\u1ef1 th\u00ec kh\u00f4ng ph\u1ea3i l\u00fac n\u00e0o s\u1eed d\u1ee5ng chu\u1ed9t b\u00e0n ph\u00edm c\u0169ng l\u00e0 c\u00e1ch nhanh nh\u1ea5t. Theo th\u1ed1ng k\u00ea trung b\u00ecnh th\u00ec ng\u01b0\u1eddi ta c\u00f3 th\u1ec3 ti\u1ebft ki\u1ec7m th\u1eddi gian \u0111\u1ebfn 10,79 m\u1ed9t ng\u00e0y v\u00e0 47 gi\u1edd m\u1ed9t n\u0103m b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng c\u00e1c ph\u00edm t\u1eaft.<\/p>\n

\u0110i\u1ec1u n\u00e0y th\u1ef1c s\u1ef1 c\u1ea7n thi\u1ebft cho c\u00e1c nh\u00e0 ph\u00e2n t\u00edch khi ph\u1ea3i h\u1ecdc \u0111\u01b0\u1ee3c c\u00e1c ph\u00edm t\u1eaft m\u1edbi trong Excel<\/a> \u0111\u1ec3 \u0111\u1ea1t \u0111\u01b0\u1ee3c t\u1ed1c \u0111\u1ed9 y\u00eau c\u1ea7u. Nh\u01b0ng v\u1ea5n \u0111\u1ec1 l\u00e0 l\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 nh\u1edb h\u1ebft t\u1ea5t c\u1ea3 c\u00e1c ph\u00edm t\u1eaft \u0111\u00f3?<\/p>\n

S\u1ef1 th\u1eadt l\u00e0 b\u1ea1n s\u1ebd kh\u00f4ng th\u1ec3 nh\u1edb cho \u0111\u1ebfn khi b\u1ea1n s\u1eed d\u1ee5ng ch\u00fang m\u1ed9t c\u00e1ch th\u01b0\u1eddng xuy\u00ean.<\/p>\n

V\u00ec v\u1eady, trong b\u00e0i vi\u00eat n\u00e0y, ch\u00fang t\u00f4i \u0111\u00e3 l\u00ean danh s\u00e1ch cho b\u1ea1n nh\u1eefng ph\u00edm t\u1eaft h\u1eefu d\u1ee5ng nh\u1ea5t<\/a> trong v\u00e0 di\u1ec5n \u0111\u1ea1t theo c\u00e1ch m\u00e0 c\u00f3 th\u1ec3 gi\u00fap b\u1ea1n ghi nh\u1edb l\u00e2u h\u01a1n.<\/p>\n

34 ph\u00edm t\u1eaft Excel gi\u00fap b\u1ea1n n\u00e2ng cao n\u0103ng su\u1ea5t l\u00e0m vi\u1ec7c<\/strong><\/a><\/p>\n

T\u01b0\u1edfng t\u01b0\u1ee3ng r\u1eb1ng vi\u1ec7c di chuy\u1ec3n con chu\u1ed9t tr\u00ean m\u00e0n h\u00ecnh \u0111\u1ec3 thao t\u00e1c tr\u00ean Excel th\u1eadt kh\u00f3 kh\u0103n v\u00e0 m\u1ea5t th\u1eddi gian. D\u01b0\u1edbi \u0111\u00e2y l\u00e0 danh s\u00e1ch 34 ph\u00edm t\u1eaft Excel \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng nhi\u1ec1u nh\u1ea5t d\u1ef1a theo nghi\u00ean c\u1ee9u.<\/p>\n

<\/p>\n

\n
\n
\n
\n<\/a>\n<\/div>\n<\/div>\n

B\u1ea1n c\u00f3 bi\u1ebft \u0111\u1ebfn Excel ABCD\u2019s? <\/strong><\/p>\n

C\u00f3 r\u1ea5t nhi\u1ec1u ph\u00edm t\u1eaft trong Excel c\u00f3 d\u1ea1ng: ph\u00edm c\u1ed9ng v\u1edbi ch\u1eef trong b\u1ea3ng ch\u1eef c\u00e1i.<\/p>\n

V\u00ed d\u1ee5: t\u1ed5 h\u1ee3p ph\u00edm Control + A s\u1ebd gi\u00fap b\u1ea1n ch\u1ecdn to\u00e0n b\u1ed9 n\u1ed9i dung worksheet, t\u01b0\u01a1ng t\u1ef1 Control + C l\u00e0 sao ch\u00e9p \u00f4 \u0111\u01b0\u1ee3c ch\u1ecdn.<\/p>\n

\u0110\u00e2y l\u00e0 danh s\u00e1ch c\u00e1c ph\u00edm t\u1eaft \u0111\u01b0\u1ee3c s\u1eafp x\u1ebfp theo th\u1ee9 t\u1ef1 d\u1ef1a tr\u00ean t\u1ed5 h\u1ee3p ph\u00edm Control + Alphabet.<\/p>\n

L\u01b0u \u00fd r\u1eb1ng: \u0110\u1ed1i v\u1edbi m\u1ed9t v\u00e0i ch\u1eef c\u00e1i m\u00e0 kh\u00f4ng c\u00f3 b\u1ea5t k\u1ef3 ph\u00edm t\u1eaft n\u00e0o \u0111\u01b0\u1ee3c thi\u1ebft l\u1eadp, ch\u00fang s\u1ebd \u0111\u01b0\u1ee3c \u0111\u00e1nh d\u1ea5u l\u00e0 n\/a (not available)<\/p>\n

<\/p>\n

Ph\u00edm t\u1eaft Excel v\u1edbi s\u1ed1<\/strong><\/p>\n

Trong ph\u1ea7n n\u00e0y, ch\u00fang t\u00f4i \u0111\u01b0a ra danh s\u00e1ch c\u00e1c ph\u00edm t\u1eaft c\u00f3 d\u1ea1ng Control+ Number. L\u01b0u \u00fd r\u1eb1ng, n\u1ebfu b\u1ea1n \u0111ang s\u1eed d\u1ee5ng b\u00e0n ph\u00edm c\u1ee7a m\u00e1y t\u00ednh \u0111\u1ec3 b\u00e0n th\u00ec h\u00e3y s\u1eed d\u1ee5ng c\u00e1c ph\u00edm s\u1ed1 n\u1eb1m d\u01b0\u1edbi c\u00e1c ph\u00edm ch\u1ee9c n\u0103ng.<\/p>\n

<\/p>\n

H\u01b0\u1edbng d\u1eabn t\u1ef1 t\u1ea1o ph\u00edm t\u1eaft<\/strong><\/p>\n

M\u1eb7c d\u00f9 c\u00f3 r\u1ea5t nhi\u1ec1u ph\u00edm t\u1eaft gi\u00fap t\u0103ng t\u1ed1c \u0111\u1ed9 l\u00e0m vi\u1ec7c, tuy nhi\u00ean \u0111\u00f4i khi b\u1ea1n c\u0169ng c\u1ea7n ph\u1ea3i t\u1ef1 t\u1ea1o cho m\u00ecnh ph\u00edm t\u1eaft ri\u00eang \u0111\u1ec3 \u0111\u00e1p \u1ee9ng nhu c\u1ea7u c\u1ee7a m\u00ecnh.<\/p>\n

V\u00ed d\u1ee5, th\u00f4ng th\u01b0\u1eddng ch\u00fang ta ph\u1ea3i s\u1eed d\u1ee5ng t\u1ed5 h\u1ee3p ph\u00edm \u201c Alt+E+S+V\u201d \u0111\u1ec3 ch\u1ec9 d\u00e1n gi\u00e1 tr\u1ecb v\u00e0o trong \u00f4 (paste values). Nh\u01b0ng c\u00e1ch l\u00e0m \u0111\u00f3 r\u1ea5t m\u1ea5t th\u1eddi gian. Ta c\u00f3 th\u1ec3 t\u1ef1 t\u1ea1o ph\u00edm t\u1eaft nh\u01b0 d\u01b0\u1edbi \u0111\u00e2y:<\/p>\n

B\u01b0\u1edbc 1<\/strong>: Ch\u1ecdn File \u1edf g\u00f3c tr\u00ean b\u00ean tr\u00e1i (\u201coffice button\u201d trong Excel 2007) \u2192Options \u2192\u00a0Quick access toolbar<\/p>\n

B\u01b0\u1edbc 2<\/strong>: \u1ede ph\u1ea7n m\u0169i t\u00ean ch\u1ec9 xu\u1ed1ng \u0111\u1ea7u ti\u00ean ch\u1ecdn \u201cAll commands\u201d<\/p>\n

B\u01b0\u1edbc 3<\/strong>: T\u00ecm \u201cPaste values\u201d\u2192 ch\u1ecdn Add \u2192 OK<\/p>\n

B\u01b0\u1edbc 4<\/strong>: \u1ea4n ph\u00edm Alt \u0111\u1ec3 hi\u1ec7n th\u1ecb t\u1ea5t c\u1ea3 c\u00e1c ph\u00edm t\u1eaft tr\u00ean thanh c\u00f4ng c\u1ee5. B\u1ea1n s\u1ebd th\u1ea5y c\u00f3 s\u1ed1 4 m\u1edbi \u0111\u01b0\u1ee3c th\u00eam v\u00e0o- bi\u1ec3u th\u1ecb cho ph\u00edm t\u1eaft \u201cPaste values\u201d.<\/p>\n

B\u01b0\u1edbc 5<\/strong>: V\u1eady l\u00e0 ta \u0111\u00e3 c\u00f3 t\u1ed5 h\u1ee3p ph\u00edm \u201cAlt+ 4\u201d d\u00f9ng \u0111\u1ec3 d\u00e1n m\u1ed7i gi\u00e1 tr\u1ecb v\u00e0o trong \u00f4.<\/p>\n

T\u01b0\u01a1ng t\u1ef1 nh\u01b0 \u201c Paste values\u201d, b\u1ea1n c\u00f3 th\u1ec3 t\u1ef1 t\u1ea1o cho m\u00ecnh b\u1ea5t c\u1ee9 lo\u1ea1i ph\u00edm t\u1eaft n\u00e0o b\u1ea1n mu\u1ed1n.<\/p>\n

\u00a0<\/p>\n

\u00a0<\/p>\n

\u00a0<\/p>\n

\u00a0<\/p>\n

\u00a0<\/p>\n

\u00a0<\/p>\n

\u00a0<\/p>\n<\/div>\n

\n

Click \u0111\u0103ng k\u00fd h\u1ecdc t\u1ea1i:<\/p>\n

T\u1ea5t c\u1ea3 kho\u00e1 h\u1ecdc\u00a0\ud83d\udcd6<\/span><\/a><\/p>\n

H\u01b0\u1edbng d\u1eabn k\u00edch ho\u1ea1t<\/a><\/p>\n

HKD H\u1ecdc Excel Online
S\u1ed1 \u0110K: 17A80048102<\/p>\n<\/div>\n

\n

\u00a9 document.currentScript.insertAdjacentHTML(‘afterend’, ” + new Intl.DateTimeFormat(document.documentElement.lang, {year: ‘numeric’}).format() + ”); H\u1ecdc Excel Online. All rights reserved.<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"

\n
\n
\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":11193,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-11192","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-co-ban"],"_links":{"self":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/11192","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/comments?post=11192"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/11192\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/11193"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=11192"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=11192"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=11192"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}