{"id":13530,"date":"2015-09-18T03:51:00","date_gmt":"2015-09-18T03:51:00","guid":{"rendered":"https:\/\/centax.dsoftware.vn\/?p=13530"},"modified":"2015-09-29T09:22:38","modified_gmt":"2015-09-29T09:22:38","slug":"cac-phim-tat-thuong-dung-trong-ke-toan-excel","status":"publish","type":"post","link":"https:\/\/centax.dsoftware.vn\/?p=13530","title":{"rendered":"C\u00e1c ph\u00edm t\u1eaft th\u01b0\u1eddng d\u00f9ng trong k\u1ebf to\u00e1n Excel"},"content":{"rendered":"

\"C\u00e1c<\/span><\/h2>\n

\u0110\u1ec3 ti\u1ebft ki\u1ec7m th\u1eddi gian c\u0169ng nh\u01b0 l\u00e0m vi\u1ec7c hi\u1ec7u qu\u1ea3 khi c\u00e1c b\u1ea1n l\u00e0m\u00a0c\u00f4ng vi\u1ec7c k\u1ebf to\u00e1n tr\u00ean Excel th\u00ec c\u00e1c b\u1ea1n ph\u1ea3i s\u1eed d\u1ee5ng th\u00e0nh th\u1ea1o c\u00e1c thao t\u00e1c tr\u00ean b\u00e0n ph\u00edm. K\u1ebf to\u00e1n Centax\u00a0<\/a><\/strong> xin chia s\u1ebb c\u00e1c ph\u00edm t\u1eaft th\u01b0\u1eddng d\u00f9ng khi l\u00e0m k\u1ebf to\u00e1n Excel. <\/span><\/p>\n

M\u1eddi c\u00e1c b\u1ea1n tham kh\u1ea3o.<\/span><\/p>\n

1. Nh\u1eefng ph\u00edm t\u1eaft c\u01a1 b\u1ea3n<\/span><\/h2>\n

Ctrl + A: Ch\u1ecdn to\u00e0n b\u1ed9 b\u1ea3ng t\u00ednh<\/span><\/p>\n

Ctrl + C: Sao ch\u00e9p.\u00a0<\/span><\/p>\n

Enter: d\u00e1n m\u1ed9t l\u1ea7n.<\/span><\/p>\n

Ctrl + V: d\u00e1n nhi\u1ec1u l\u1ea7n<\/span><\/p>\n

Ctrl + F: B\u1eadt h\u1ed9p tho\u1ea1i t\u00ecm ki\u1ebfm<\/span><\/p>\n

Ctrl + H: B\u1eadt h\u1ed9p tho\u1ea1i t\u00ecm ki\u1ebfm v\u00e0 thay th\u1ebf.<\/span><\/p>\n

Ctrl + N: T\u1ea1o m\u1edbi m\u1ed9t b\u1ea3ng t\u00ednh tr\u1eafng<\/span><\/p>\n

Ctrl + P: B\u1eadt h\u1ed9p tho\u1ea1i in \u1ea5n<\/span><\/p>\n

Ctrl + S: L\u01b0u b\u1ea3ng t\u00ednh<\/span><\/p>\n

Ctrl + X: c\u1eaft m\u1ed9t n\u1ed9i dung \u0111ang ch\u1ecdn<\/span><\/p>\n

Ctrl + Z: Ph\u1ee5c h\u1ed3i thao t\u00e1c tr\u01b0\u1edbc \u0111\u00f3<\/span><\/p>\n

Ctrl + *: Ch\u1ecdn v\u00f9ng d\u1eef li\u1ec7u li\u00ean quan \u0111\u1ebfn \u00f4 hi\u1ec7n t\u1ea1i.<\/span><\/p>\n

Ctrl + F4, Alt + F4: \u0110\u00f3ng b\u1ea3ng t\u00ednh, \u0111\u00f3ng Excel<\/span><\/p>\n

2. Ph\u00edm t\u1eaft trong di chuy\u1ec3n<\/span><\/h2>\n

Ctrl + M\u0169i t\u00ean Di chuy\u1ec3n \u0111\u1ebfn v\u00f9ng d\u1eef li\u1ec7u k\u1ebf ti\u1ebfp<\/span><\/p>\n

Ctrl + Home: V\u1ec1 \u00f4 A1<\/span><\/p>\n

Ctrl + End: v\u1ec1 \u00f4 c\u00f3 d\u1eef li\u1ec7u cu\u1ed1i c\u00f9ng<\/span><\/p>\n

Ctrl + Shift + Home: Ch\u1ecdn t\u1eeb \u00f4 hi\u1ec7n t\u1ea1i \u0111\u1ebfn \u00f4 A1<\/span><\/p>\n

Ctrl + Shift + End: Ch\u1ecdn t\u1eeb \u00f4 hi\u1ec7n t\u1ea1i \u0111\u1ebfn \u00f4 c\u00f3 d\u1eef li\u1ec7u cu\u1ed1i c\u00f9ng<\/span><\/p>\n

3. Ph\u00edm t\u1eaft trong \u0111\u1ecbnh d\u1ea1ng<\/span><\/h2>\n

Ctrl + B: \u0110\u1ecbnh d\u1ea1ng in \u0111\u1eadm<\/span><\/p>\n

Ctrl + I: \u0110\u1ecbnh d\u1ea1ng in nghi\u00eang.<\/span><\/p>\n

Ctrl + U: \u0110\u1ecbnh d\u1ea1ng g\u1ea1ch ch\u00e2n.<\/span><\/p>\n

Ctrl + 1: Hi\u1ec3n th\u1ecb h\u1ed9p tho\u1ea1i Format Cells.<\/span><\/p>\n

4.Ch\u00e8n c\u1ed9t, d\u00f2ng trong b\u1ea3ng t\u00ednh<\/span><\/h2>\n

Ctrl + Spacebar: Ch\u00e8n c\u1ed9t<\/span><\/p>\n

Shift + Spacebar: Ch\u00e8n d\u00f2ng<\/span><\/p>\n

Shift + F11: Ch\u00e8n m\u1ed9t trang b\u1ea3ng t\u00ednh m\u1edbi<\/span><\/p>\n

5. C\u00f4ng th\u1ee9c m\u1ea3ng<\/span><\/h2>\n

Ctrl + G: B\u1eadt h\u1ed9p tho\u1ea1i Go to \u0111\u1ec3 \u0111\u1ebfn m\u1ed9t m\u1ea3ng \u0111\u00e3 \u0111\u01b0\u1ee3c \u0111\u1eb7t t\u00ean trong b\u1ea3ng t\u00ednh.<\/span><\/p>\n

Shift + F3: Nh\u1eadp c\u00f4ng th\u1ee9c b\u1eb1ng c\u1eeda s\u1ed5 Insert Function<\/span><\/p>\n

Ctrl + Shift + Enter : K\u1ebft th\u00fac m\u1ed9t c\u00f4ng th\u1ee9c m\u1ea3ng<\/span><\/p>\n

Ctrl + F3: \u0110\u1eb7t t\u00ean m\u1ea3ng cho m\u1ed9t v\u00f9ng d\u1eef li\u1ec7u.<\/span><\/p>\n

F3: D\u00e1n m\u1ed9t t\u00ean m\u1ea3ng v\u00e0o c\u00f4ng th\u1ee9c.<\/span><\/p>\n

6. Thao t\u00e1c ph\u00edm \u1ea9n hi\u1ec7n c\u00e1c c\u1ed9t<\/span><\/h2>\n

Ctrl + 0: \u1ea9n c\u00e1c c\u1ed9t \u0111ang ch\u1ecdn<\/span><\/p>\n

Ctrl + Shift + 0: hi\u1ec7n c\u00e1c c\u1ed9t b\u1ecb \u1ea9n trong v\u00f9ng \u0111ang ch\u1ecdn<\/span><\/p>\n

7. Ch\u1ecdn c\u00e1c v\u00f9ng, \u00f4 kh\u00f4ng li\u00ean t\u1ee5c<\/span><\/h2>\n

\u0110\u1ec3 ch\u1ecdn c\u00e1c v\u00f9ng \u00f4, d\u00e3y \u00f4 kh\u00f4ng li\u00ean t\u1ee5c. B\u1ea1n d\u00f9ng chu\u1ed9t k\u1ebft h\u1ee3p gi\u1eef ph\u00edm Ctrl \u0111\u1ec3 ch\u1ecdn c\u00e1c v\u00f9ng \u00f4 kh\u00f4ng li\u00ean t\u1ee5c c\u1ea7n ch\u1ecdn.\u00a0<\/span><\/p>\n

8. Chuy\u1ec3n \u0111\u1ed5i gi\u1eefa c\u00e1c b\u1ea3ng t\u00ednh \u0111ang m\u1edf<\/span><\/h2>\n

Ctrl + Tab, ho\u1eb7c Ctrl + F6: \u0111\u1ec3 chuy\u1ec3n \u0111\u1ed5i qua l\u1ea1i gi\u1eefa c\u00e1c b\u1ea3ng t\u00ednh \u0111ang m\u1edf.<\/span><\/p>\n

9. Chuy\u1ec3n \u0111\u1ed5i gi\u1eefa c\u00e1c trang b\u1ea3ng t\u00ednh<\/span><\/h2>\n

Ctrl + Page Up: Chuy\u1ec3n sang sheet tr\u01b0\u1edbc.<\/span><\/p>\n

Ctrl + Page Down: Chuy\u1ec3n sang sheet k\u1ebf ti\u1ebfp<\/span><\/p>\n

10. D\u00e1n n\u1ed9i d\u1ee5ng cho nhi\u1ec1u \u00f4 c\u00f9ng m\u1ed9t l\u00fac<\/span><\/h2>\n

Ch\u1ecdn m\u1ed9t n\u1ed9i dung c\u1ea7n sao ch\u00e9p, nh\u1ea5n Ctrl + C. Nh\u1eadp \u0111\u1ecba ch\u1ec9 v\u00f9ng \u00f4 c\u1ea7n d\u00e1n n\u1ed9i dung v\u00e0o m\u1ee5c Name Box tr\u00ean thanh Fomular d\u1ea1ng <\u00f4 \u0111\u1ea7u> : <\u00f4 cu\u1ed1i> Nh\u1ea5n Enter \u0111\u1ec3 d\u00e1n n\u1ed9i dung v\u00e0o v\u00f9ng \u00f4 tr\u00ean<\/span><\/p>\n

11. Kh\u00f4ng chuy\u1ec3n sang \u00f4 kh\u00e1c sau khi nh\u1eadp<\/span><\/h2>\n

Nh\u1ea5n t\u1ed5 h\u1ee3p ph\u00edm Ctrl + Enter sau khi nh\u1eadp \u0111\u1ec3 kh\u00f4ng di chuy\u1ec3n con tr\u1ecf sang \u00f4 k\u1ebf ti\u1ebfp. Ho\u1eb7c v\u00e0o menu Tools – Options. Ch\u1ecdn th\u1ebb Edit. B\u1ecf ch\u1ecdn m\u1ee5c Move selection after Enter Direction.<\/span><\/p>\n

M\u1eddi b\u1ea1n tham kh\u1ea3o c\u00e1c b\u00e0i vi\u1ebft c\u00f3 li\u00ean quan kh\u00e1c:<\/span><\/p>\n

T\u1ed5ng h\u1ee3p c\u00e1c h\u00e0m\u00a0excel hay d\u00f9ng trong k\u1ebf to\u00e1n<\/a><\/span><\/p>\n

Ph\u1ea7n m\u1ec1m k\u1ebf to\u00e1n\u00a0excel<\/a><\/span><\/p>\n

C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m sumif trong\u00a0excel<\/a><\/span><\/p>\n

C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m countif trong\u00a0excel<\/a><\/span><\/p>\n

C\u00e1ch\u00a0\u0111\u1ed5i s\u1ed1 th\u00e0nh ch\u1eef trong\u00a0excel 2003, 2007, 2010,2013<\/a><\/span><\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n","protected":false},"excerpt":{"rendered":"

K\u1ebf to\u00e1n Centax xin gi\u1edbi thi\u1ec7u C\u00e1c ph\u00edm t\u1eaft th\u01b0\u1eddng d\u00f9ng trong k\u1ebf to\u00e1n Excel \u0111\u1ec3 n\u00e2ng cao hi\u1ec7u qu\u1ea3 c\u00f4ng vi\u1ec7c c\u1ee7a c\u00e1c b\u1ea1n. M\u1eddi b\u1ea1n \u0111\u1ecdc tham kh\u1ea3o.<\/p>\n","protected":false},"author":7,"featured_media":13776,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"tags":[1706],"_links":{"self":[{"href":"https:\/\/centax.dsoftware.vn\/index.php?rest_route=\/wp\/v2\/posts\/13530"}],"collection":[{"href":"https:\/\/centax.dsoftware.vn\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/centax.dsoftware.vn\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/centax.dsoftware.vn\/index.php?rest_route=\/wp\/v2\/users\/7"}],"replies":[{"embeddable":true,"href":"https:\/\/centax.dsoftware.vn\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=13530"}],"version-history":[{"count":0,"href":"https:\/\/centax.dsoftware.vn\/index.php?rest_route=\/wp\/v2\/posts\/13530\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/centax.dsoftware.vn\/index.php?rest_route=\/wp\/v2\/media\/13776"}],"wp:attachment":[{"href":"https:\/\/centax.dsoftware.vn\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=13530"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/centax.dsoftware.vn\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=13530"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}