{"id":1611,"date":"2023-09-28T00:33:40","date_gmt":"2023-09-27T17:33:40","guid":{"rendered":"https:\/\/trannghiait.com\/?p=1611"},"modified":"2023-09-29T00:40:11","modified_gmt":"2023-09-28T17:40:11","slug":"nhung-to-hop-phim-don-gian-tiet-kiem-thoi-gian-trong-excel","status":"publish","type":"post","link":"https:\/\/trannghiait.com\/index.php\/2023\/09\/28\/nhung-to-hop-phim-don-gian-tiet-kiem-thoi-gian-trong-excel\/","title":{"rendered":"Nh\u1eefng t\u1ed5 h\u1ee3p ph\u00edm \u0111\u01a1n gi\u1ea3n ti\u1ebft ki\u1ec7m th\u1eddi gian trong excel"},"content":{"rendered":"\n

Excel l\u00e0 m\u1ed9t trong nh\u1eefng c\u00f4ng c\u1ee5 ph\u1ed5 bi\u1ebfn nh\u1ea5t trong vi\u1ec7c qu\u1ea3n l\u00fd v\u00e0 x\u1eed l\u00fd d\u1eef li\u1ec7u s\u1ed1. N\u00f3 cung c\u1ea5p m\u1ed9t giao di\u1ec7n \u0111\u1ed3 h\u1ecda d\u1ec5 s\u1eed d\u1ee5ng, cho ph\u00e9p ng\u01b0\u1eddi d\u00f9ng t\u1ea1o v\u00e0 qu\u1ea3n l\u00fd c\u00e1c b\u1ea3ng t\u00ednh, t\u00ednh to\u00e1n s\u1ed1 li\u1ec7u, th\u1ef1c hi\u1ec7n c\u00e1c ph\u00e9p t\u00ednh to\u00e1n ph\u1ee9c t\u1ea1p, v\u00e0 t\u1ea1o ra bi\u1ec3u \u0111\u1ed3 v\u00e0 \u0111\u1ed3 th\u1ecb. Ngo\u00e0i ra, Excel c\u00f2n cung c\u1ea5p nhi\u1ec1u t\u00ednh n\u0103ng m\u1ea1nh m\u1ebd kh\u00e1c nh\u01b0 t\u1ef1 \u0111\u1ed9ng h\u00f3a c\u00f4ng vi\u1ec7c, t\u1ea1o c\u00e1c c\u00f4ng th\u1ee9c v\u00e0 h\u00e0m t\u00ednh to\u00e1n, v\u00e0 ph\u00e2n t\u00edch d\u1eef li\u1ec7u. V\u1edbi kh\u1ea3 n\u0103ng linh ho\u1ea1t v\u00e0 \u0111a d\u1ea1ng c\u1ee7a n\u00f3, Excel \u0111\u00e3 tr\u1edf th\u00e0nh m\u1ed9t c\u00f4ng c\u1ee5 quan tr\u1ecdng trong nhi\u1ec1u l\u0129nh v\u1ef1c nh\u01b0 k\u1ebf to\u00e1n, t\u00e0i ch\u00ednh, qu\u1ea3n l\u00fd d\u1ef1 \u00e1n v\u00e0 nghi\u00ean c\u1ee9u…<\/p>\n\n\n\n

T\u1ed5 h\u1ee3p ph\u00edm v\u00e0 c\u00e1c c\u00f4ng d\u1ee5ng nh\u01b0 sau:<\/h2>\n\n\n\n

Ctrl + a => ch\u1ecdn t\u1ea5t c\u1ea3<\/p>\n\n\n\n

Ctrl + b => in \u0111\u1eadm<\/p>\n\n\n\n

Ctrl + c => sao ch\u00e9p<\/p>\n\n\n\n

Ctrl + D => m\u1edf h\u1ed9p tho\u1ea1i \u0111\u1ecbnh d\u1ea1ng font ch\u1eef<\/p>\n\n\n\n

Ctrl + F => t\u00ecm ki\u1ebfm<\/p>\n\n\n\n

Ctrl + g => t\u00ecm v\u00ed d\u1ee5 ti\u1ebfp theo c\u1ee7a v\u0103n b\u1ea3n<\/p>\n\n\n\n

Ctrl + h => thay th\u1ebf<\/p>\n\n\n\n

Ctrl + i => nghi\u00eang<\/p>\n\n\n\n

Ctrl + k => ch\u00e8n m\u1ed9t si\u00eau li\u00ean k\u1ebft<\/p>\n\n\n\n

Ctrl + n => m\u1edf m\u1edbi workbook<\/p>\n\n\n\n

Ctrl + p => in<\/p>\n\n\n\n

Ctrl + s => l\u01b0u tr\u1eef<\/p>\n\n\n\n

Ctrl + u => g\u1ea1ch g\u1ea1ch<\/p>\n\n\n\n

Ctrl + v => d\u00e1n<\/p>\n\n\n\n

Ctrl + w => g\u1ea7n<\/p>\n\n\n\n

Ctrl + x => c\u1eaft<\/p>\n\n\n\n

Ctrl + y => l\u1eb7p l\u1ea1i<\/p>\n\n\n\n

Ctrl + z => h\u1ee7y b\u1ecf, quay tr\u1edf l\u1ea1i<\/p>\n\n\n\n

F1 => gi\u00fap \u0111\u1ee1<\/p>\n\n\n\n

F2 => phi\u00ean b\u1ea3n<\/p>\n\n\n\n

F3 => d\u00e1n t\u00ean<\/p>\n\n\n\n

F4 => l\u1eb7p l\u1ea1i h\u00e0nh \u0111\u1ed9ng cu\u1ed1i c\u00f9ng<\/p>\n\n\n\n

F5 => truy c\u1eadp<\/p>\n\n\n\n

F6 => ng\u0103n ti\u1ebfp theo<\/p>\n\n\n\n

F7 => ki\u1ec3m tra \u0111\u00e1nh v\u1ea7n<\/p>\n\n\n\n

F8 => ph\u1ea7n m\u1edf r\u1ed9ng c\u1ee7a ch\u1ebf \u0111\u1ed9<\/p>\n\n\n\n

F9 => recalculate t\u1ea5t c\u1ea3 m\u1ecdi ng\u01b0\u1eddi<\/p>\n\n\n\n

F10 => k\u00edch ho\u1ea1t thanh th\u1ef1c \u0111\u01a1n<\/p>\n\n\n\n

F11 => \u0111\u1ed3 th\u1ecb m\u1edbi<\/p>\n\n\n\n

Ctrl + +: => ch\u00e8n v\u00e0o th\u1eddi \u0111i\u1ec3m hi\u1ec7n t\u1ea1i<\/p>\n\n\n\n

Ctrl + +; => ch\u00e8n ng\u00e0y hi\u1ec7n t\u1ea1i<\/p>\n\n\n\n

Ctrl + ” => sao ch\u00e9p gi\u00e1 tr\u1ecb ph\u1ea7n t\u1eed \u1edf tr\u00ean<\/p>\n\n\n\n

Ctrl + ‘ => sao ch\u00e9p c\u00f4ng th\u1ee9c t\u1eeb ph\u1ea7n t\u1eed \u1edf tr\u00ean<\/p>\n\n\n

\n
\"\"<\/figure><\/div>\n\n\n

Ca: \u0111i\u1ec1u ch\u1ec9nh b\u1ea3n d\u1ecbch cho c\u00e1c ch\u1ee9c n\u0103ng b\u1ed5 sung trong th\u1ef1c \u0111\u01a1n excel<\/strong><\/p>\n\n\n\n

Ca + F2 => ch\u1ec9nh s\u1eeda b\u00ecnh lu\u1eadn<\/p>\n\n\n\n

Ca + F3 => d\u00e1n ch\u1ee9c n\u0103ng v\u00e0o c\u00f4ng th\u1ee9c<\/p>\n\n\n\n

Ca + F4 => t\u00ecm ki\u1ebfm ti\u1ebfp theo<\/p>\n\n\n\n

Ca + F5 => t\u00ecm<\/p>\n\n\n\n

Ca + F6 => b\u1ea3ng \u0111i\u1ec1u khi\u1ec3n tr\u01b0\u1edbc \u0111\u00e2y<\/p>\n\n\n\n

Ca + F8 => th\u00eam v\u00e0o l\u1ef1a ch\u1ecdn<\/p>\n\n\n\n

Ca + F9 => t\u00ednh b\u1ea3ng l\u00e0m vi\u1ec7c ho\u1ea1t \u0111\u1ed9ng<\/p>\n\n\n\n

Ca + F10 => tr\u01b0ng b\u00e0y th\u1ef1c \u0111\u01a1n popup<\/p>\n\n\n\n

Ca + F11 => b\u1ea3ng t\u00ednh m\u1edbi<\/p>\n\n\n\n

Ctrl + F3 => \u0111\u1eb7t t\u00ean<\/p>\n\n\n\n

Ctrl + F4 => g\u1ea7n<\/p>\n\n\n\n

Ctrl + F5 => k\u00edch th\u01b0\u1edbc c\u1ee7a c\u1eeda s\u1ed5 ph\u1ee5c h\u1ed3i<\/p>\n\n\n\n

Ctrl + F6 => c\u1eeda s\u1ed5 workbook ti\u1ebfp theo<\/p>\n\n\n\n

Ca + Ctrl + F6 => c\u1eeda s\u1ed5 workbook tr\u01b0\u1edbc \u0111\u00e2y<\/p>\n\n\n\n

Ctrl + F7 => di chuy\u1ec3n c\u1eeda s\u1ed5<\/p>\n\n\n\n

Ctrl + F8 => thay \u0111\u1ed5i k\u00edch c\u1ee1 c\u1eeda s\u1ed5<\/p>\n\n\n\n

Ctrl + F9 => gi\u1ea3m thi\u1ec3u c\u00e1c workbook<\/p>\n\n\n\n

Ctrl + F10 => t\u1ed1i \u0111a ho\u1eb7c ph\u1ee5c h\u1ed3i c\u1eeda s\u1ed5<\/p>\n\n\n\n

Ctrl + F11 => inset 4.0 t\u1edd macro<\/p>\n\n\n\n

Ctrl + F1 => t\u1eadp tin m\u1edf<\/p>\n\n\n\n

Alt + F1 => ch\u00e8n \u0111\u1ed3 th\u1ecb<\/p>\n\n\n\n

Alt + F4 => tho\u00e1t kh\u1ecfi \u1ee9ng d\u1ee5ng ho\u1eb7c t\u1eaft m\u00e1y<\/p>\n\n\n\n

Alt + F11 => bi\u00ean t\u1eadp vi\u00ean c\u01a1 b\u1ea3n visual<\/p>\n\n\n\n

Ctrl + Shift + F3 => t\u1ea1o t\u00ean s\u1eed d\u1ee5ng t\u00ean c\u1ee7a h\u00e0ng v\u00e0 nh\u00e3n c\u1ed9t<\/p>\n\n\n\n

Ctrl + Shift + F6 => c\u1eeda s\u1ed5 tr\u01b0\u1edbc<\/p>\n\n\n\n

Ctrl + Shift + F12 => in<\/p>\n\n\n\n

Alt + ca + F1 => b\u1ea3ng t\u00ednh m\u1edbi<\/p>\n\n\n\n

Ctrl + ‘ => Chuy\u1ec3n \u0111\u1ed5i gi\u00e1 tr\u1ecb \/ Hi\u1ec3n th\u1ecb c\u1ee7a c\u00f4ng th\u1ee9c<\/p>\n\n\n\n

Ctrl + Shift + a => ch\u00e8n t\u00ean trong c\u00f4ng th\u1ee9c<\/p>\n\n\n\n

M\u0169i T\u00ean Alt + down => danh s\u00e1ch xem t\u1ef1 \u0111\u1ed9ng<\/p>\n\n\n\n

Ctrl + Shift + ~ => \u0111\u1ecbnh d\u1ea1ng chung.<\/p>\n","protected":false},"excerpt":{"rendered":"

nh\u1eefng t\u1ed5 h\u1ee3p ph\u00edm \u0111\u01a1n gi\u1ea3n ti\u1ebft ki\u1ec7m th\u1eddi gian trong excel b\u1ea1n c\u1ea7n bi\u1ebft…xem th\u00eam<\/p>\n<\/div>","protected":false},"author":3,"featured_media":1613,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[10,13],"tags":[],"class_list":["post-1611","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-kien-thuc-excel","category-tien-ich-hay"],"_links":{"self":[{"href":"https:\/\/trannghiait.com\/index.php\/wp-json\/wp\/v2\/posts\/1611","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/trannghiait.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/trannghiait.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/trannghiait.com\/index.php\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/trannghiait.com\/index.php\/wp-json\/wp\/v2\/comments?post=1611"}],"version-history":[{"count":1,"href":"https:\/\/trannghiait.com\/index.php\/wp-json\/wp\/v2\/posts\/1611\/revisions"}],"predecessor-version":[{"id":1614,"href":"https:\/\/trannghiait.com\/index.php\/wp-json\/wp\/v2\/posts\/1611\/revisions\/1614"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/trannghiait.com\/index.php\/wp-json\/wp\/v2\/media\/1613"}],"wp:attachment":[{"href":"https:\/\/trannghiait.com\/index.php\/wp-json\/wp\/v2\/media?parent=1611"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/trannghiait.com\/index.php\/wp-json\/wp\/v2\/categories?post=1611"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/trannghiait.com\/index.php\/wp-json\/wp\/v2\/tags?post=1611"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}