{"id":164997,"date":"2024-09-28T10:14:16","date_gmt":"2024-09-28T03:14:16","guid":{"rendered":"https:\/\/amis.misa.vn\/?p=164997"},"modified":"2024-09-27T15:05:31","modified_gmt":"2024-09-27T08:05:31","slug":"cac-phim-tat-excel","status":"publish","type":"post","link":"https:\/\/amis.misa.vn\/164997\/cac-phim-tat-excel\/","title":{"rendered":"T\u1ed5ng H\u1ee3p C\u00e1c Ph\u00edm T\u1eaft Excel H\u1eefu \u00cdch Cho Ng\u01b0\u1eddi L\u00e0m K\u1ebf To\u00e1n"},"content":{"rendered":"<p style=\"text-align: justify;\">Excel l\u00e0 c\u00f4ng c\u1ee5 kh\u00f4ng th\u1ec3 thi\u1ebfu trong c\u00f4ng vi\u1ec7c h\u00e0ng ng\u00e0y c\u1ee7a m\u1ed9t k\u1ebf to\u00e1n vi\u00ean. Vi\u1ec7c s\u1eed d\u1ee5ng c\u00e1c ph\u00edm t\u1eaft kh\u00f4ng ch\u1ec9 gi\u00fap t\u0103ng t\u1ed1c \u0111\u1ed9 x\u1eed l\u00fd v\u00e0 c\u1ea3i thi\u1ec7n hi\u1ec7u su\u1ea5t c\u00f4ng vi\u1ec7c m\u00e0 c\u00f2n gi\u00fap c\u00e1c nh\u00e2n vi\u00ean k\u1ebf to\u00e1n t\u1eadp trung h\u01a1n v\u00e0o ph\u00e2n t\u00edch v\u00e0 ra quy\u1ebft \u0111\u1ecbnh t\u00e0i ch\u00ednh. D\u01b0\u1edbi \u0111\u00e2y l\u00e0 danh s\u00e1ch c\u00e1c ph\u00edm t\u1eaft Excel quan tr\u1ecdng m\u00e0 m\u1ecdi k\u1ebf to\u00e1n vi\u00ean n\u00ean bi\u1ebft \u0111\u1ec3 t\u1ed1i \u01b0u h\u00f3a c\u00f4ng vi\u1ec7c c\u1ee7a m\u00ecnh.<\/p>\n<h2><b>1. C\u00e1c ph\u00edm t\u1eaft d\u00f9ng \u0111\u1ecbnh d\u1ea1ng c\u1ed9t v\u00e0 d\u00f2ng trong excel<\/b><\/h2>\n<p>C\u00e1c ph\u00edm t\u1eaft \u0111\u1ecbnh d\u1ea1ng d\u00f2ng v\u00e0 c\u1ed9t th\u01b0\u1eddng d\u00f9ng bao g\u1ed3m<\/p>\n<ul>\n<li style=\"text-align: justify;\"><span style=\"font-weight: 400;\"><strong>Alt + E, S, V:<\/strong> M\u1edf h\u1ed9p tho\u1ea1i Paste Special \u0111\u1ec3 d\u00e1n d\u1eef li\u1ec7u v\u1edbi c\u00e1c t\u00f9y ch\u1ecdn \u0111\u1ecbnh d\u1ea1ng \u0111\u1eb7c bi\u1ec7t.<\/span><\/li>\n<li style=\"text-align: justify;\"><span style=\"font-weight: 400;\"><strong>Alt + O, C, A:<\/strong> T\u1ef1 \u0111\u1ed9ng \u0111i\u1ec1u ch\u1ec9nh chi\u1ec1u r\u1ed9ng c\u1ee7a c\u1ed9t.<\/span><\/li>\n<li style=\"text-align: justify;\"><span style=\"font-weight: 400;\"><strong>Alt + O, R, A:<\/strong> T\u1ef1 \u0111\u1ed9ng \u0111i\u1ec1u ch\u1ec9nh chi\u1ec1u cao c\u1ee7a h\u00e0ng.<\/span><\/li>\n<li style=\"text-align: justify;\"><span style=\"font-weight: 400;\"><strong>Ctrl + Shift + L<\/strong>: B\u1eadt\/t\u1eaft b\u1ed9 l\u1ecdc t\u1ef1 \u0111\u1ed9ng cho d\u1eef li\u1ec7u c\u1ee7a b\u1ea1n.<\/span><\/li>\n<li style=\"text-align: justify;\"><span style=\"font-weight: 400;\"><strong>Ctrl + Space:<\/strong> Ch\u1ecdn c\u1ed9t hi\u1ec7n t\u1ea1i.<\/span><\/li>\n<li style=\"text-align: justify;\"><span style=\"font-weight: 400;\"><strong>Shift + Space:<\/strong> Ch\u1ecdn h\u00e0ng hi\u1ec7n t\u1ea1i.<\/span><\/li>\n<li style=\"text-align: justify;\"><span style=\"font-weight: 400;\"><strong>Ctrl + 0<\/strong> (s\u1ed1 kh\u00f4ng): \u1ea8n c\u1ed9t \u0111\u01b0\u1ee3c ch\u1ecdn.<\/span><\/li>\n<li style=\"text-align: justify;\"><span style=\"font-weight: 400;\"><strong>Ctrl + 9:<\/strong> \u1ea8n h\u00e0ng \u0111\u01b0\u1ee3c ch\u1ecdn.<\/span><\/li>\n<li style=\"text-align: justify;\"><span style=\"font-weight: 400;\"><strong>Ctrl + Shift + 0:<\/strong> Hi\u1ec7n l\u1ea1i c\u00e1c c\u1ed9t b\u1ecb \u1ea9n.<\/span><\/li>\n<li style=\"text-align: justify;\"><span style=\"font-weight: 400;\"><strong>Ctrl + Shift + 9:<\/strong> Hi\u1ec7n l\u1ea1i c\u00e1c h\u00e0ng b\u1ecb \u1ea9n.<\/span><\/li>\n<li style=\"text-align: justify;\"><span style=\"font-weight: 400;\"><strong>Alt + H, O, I:<\/strong> T\u1ef1 \u0111\u1ed9ng \u0111i\u1ec1u ch\u1ec9nh chi\u1ec1u r\u1ed9ng c\u1ed9t \u0111\u1ec3 ph\u00f9 h\u1ee3p v\u1edbi n\u1ed9i dung.<\/span><\/li>\n<li style=\"text-align: justify;\"><span style=\"font-weight: 400;\"><strong>Alt + H, O, R:<\/strong> \u0110\u1ed5i t\u00ean c\u1ed9t ho\u1eb7c h\u00e0ng \u0111\u01b0\u1ee3c ch\u1ecdn.<\/span><\/li>\n<li style=\"text-align: justify;\"><span style=\"font-weight: 400;\"><strong>Alt + H, O, U, L:<\/strong> \u0110\u1eb7t chi\u1ec1u cao h\u00e0ng b\u1eb1ng gi\u00e1 tr\u1ecb t\u00f9y ch\u1ecdn.<\/span><\/li>\n<li style=\"text-align: justify;\"><span style=\"font-weight: 400;\"><strong>Alt + H, O, W:<\/strong> \u0110\u1eb7t chi\u1ec1u r\u1ed9ng c\u1ed9t b\u1eb1ng gi\u00e1 tr\u1ecb t\u00f9y ch\u1ecdn.<\/span><\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-165039\" src=\"\/wp-content\/uploads\/2024\/09\/cac-phim-tat-trong-excel-5.jpg\" alt=\"\" width=\"1920\" height=\"1080\" srcset=\"\/wp-content\/uploads\/2024\/09\/cac-phim-tat-trong-excel-5.jpg 1920w, \/wp-content\/uploads\/2024\/09\/cac-phim-tat-trong-excel-5-500x281.jpg 500w, \/wp-content\/uploads\/2024\/09\/cac-phim-tat-trong-excel-5-1024x576.jpg 1024w, \/wp-content\/uploads\/2024\/09\/cac-phim-tat-trong-excel-5-768x432.jpg 768w, \/wp-content\/uploads\/2024\/09\/cac-phim-tat-trong-excel-5-1536x864.jpg 1536w\" sizes=\"(max-width: 1920px) 100vw, 1920px\" \/><\/p>\n<p><span style=\"font-weight: 400;\">C\u00e1c ph\u00edm t\u1eaft \u0111\u1ecbnh d\u1ea1ng \u00f4 bao g\u1ed3m:<\/span><\/p>\n<ul>\n<li style=\"text-align: justify;\"><span style=\"font-weight: 400;\"><strong>Ctrl + 1:<\/strong> M\u1edf h\u1ed9p tho\u1ea1i Format Cells \u0111\u1ec3 \u0111\u1ecbnh d\u1ea1ng chi ti\u1ebft c\u00e1c \u00f4 (bao g\u1ed3m s\u1ed1, ph\u00f4ng ch\u1eef, bi\u00ean, ki\u1ec3u, v.v.).<\/span><\/li>\n<li style=\"text-align: justify;\"><span style=\"font-weight: 400;\"><strong>Ctrl + Shift + $:<\/strong> \u00c1p d\u1ee5ng \u0111\u1ecbnh d\u1ea1ng ti\u1ec1n t\u1ec7.<\/span><\/li>\n<li style=\"text-align: justify;\"><span style=\"font-weight: 400;\"><strong>Ctrl + Shift + %:<\/strong> \u00c1p d\u1ee5ng \u0111\u1ecbnh d\u1ea1ng ph\u1ea7n tr\u0103m.<\/span><\/li>\n<li style=\"text-align: justify;\"><span style=\"font-weight: 400;\"><strong>Ctrl + Shift + #:<\/strong> \u00c1p d\u1ee5ng \u0111\u1ecbnh d\u1ea1ng ng\u00e0y th\u00e1ng.<\/span><\/li>\n<li style=\"text-align: justify;\"><span style=\"font-weight: 400;\"><strong>Ctrl + Shift + ^:<\/strong> \u00c1p d\u1ee5ng \u0111\u1ecbnh d\u1ea1ng s\u1ed1 m\u0169.<\/span><\/li>\n<li style=\"text-align: justify;\"><span style=\"font-weight: 400;\"><strong>Ctrl + Shift + @:<\/strong> \u00c1p d\u1ee5ng \u0111\u1ecbnh d\u1ea1ng th\u1eddi gian.<\/span><\/li>\n<li style=\"text-align: justify;\"><span style=\"font-weight: 400;\"><strong>Ctrl + Shift + ~:<\/strong> \u00c1p d\u1ee5ng \u0111\u1ecbnh d\u1ea1ng s\u1ed1 chung.<\/span><\/li>\n<li style=\"text-align: justify;\"><span style=\"font-weight: 400;\"><strong>Ctrl + B:<\/strong> In \u0111\u1eadm n\u1ed9i dung trong \u00f4 \u0111\u01b0\u1ee3c ch\u1ecdn.<\/span><\/li>\n<li style=\"text-align: justify;\"><span style=\"font-weight: 400;\"><strong>Ctrl + I:<\/strong> In nghi\u00eang n\u1ed9i dung trong \u00f4 \u0111\u01b0\u1ee3c ch\u1ecdn.<\/span><\/li>\n<li style=\"text-align: justify;\"><span style=\"font-weight: 400;\"><strong>Ctrl + U:<\/strong> G\u1ea1ch ch\u00e2n n\u1ed9i dung trong \u00f4 \u0111\u01b0\u1ee3c ch\u1ecdn.<\/span><\/li>\n<li style=\"text-align: justify;\"><span style=\"font-weight: 400;\"><strong>Alt + H, B:<\/strong> Th\u00eam bi\u00ean cho c\u00e1c \u00f4 \u0111\u01b0\u1ee3c ch\u1ecdn.<\/span><\/li>\n<li style=\"text-align: justify;\"><span style=\"font-weight: 400;\"><strong>Alt + H, L:<\/strong> \u00c1p d\u1ee5ng m\u00e0u n\u1ec1n cho \u00f4.<\/span><\/li>\n<li style=\"text-align: justify;\"><span style=\"font-weight: 400;\"><strong>Alt + H, F, C:<\/strong> Ch\u1ecdn m\u00e0u ch\u1eef.<\/span><\/li>\n<\/ul>\n<p><a href=\"https:\/\/amis.misa.vn\/register\/?appcode=Accounting&amp;s_pd=amis-ke-toan-Blog?source=Blog&amp;medium=content&amp;campaign=TCKT&amp;content=phim-tat-excel&amp;term=act_\" target=\"_blank\" rel=\"noopener\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-163983\" src=\"\/wp-content\/uploads\/2023\/02\/Ads-Blog-1440x400-02-min.png\" alt=\"\" width=\"3000\" height=\"834\" srcset=\"\/wp-content\/uploads\/2023\/02\/Ads-Blog-1440x400-02-min.png 3000w, \/wp-content\/uploads\/2023\/02\/Ads-Blog-1440x400-02-min-500x139.png 500w, \/wp-content\/uploads\/2023\/02\/Ads-Blog-1440x400-02-min-1024x285.png 1024w, \/wp-content\/uploads\/2023\/02\/Ads-Blog-1440x400-02-min-768x214.png 768w, \/wp-content\/uploads\/2023\/02\/Ads-Blog-1440x400-02-min-1536x427.png 1536w, \/wp-content\/uploads\/2023\/02\/Ads-Blog-1440x400-02-min-2048x569.png 2048w\" sizes=\"(max-width: 3000px) 100vw, 3000px\" \/><\/a><\/p>\n<h2><b>2. C\u00e1c ph\u00edm t\u1eaft d\u00e0nh \u0111\u1ecbnh d\u1ea1ng s\u1ed1<\/b><\/h2>\n<p><span style=\"font-weight: 400;\">Ph\u00edm t\u1eaft excel chung cho \u0111\u1ecbnh d\u1ea1ng s\u1ed1 nh\u01b0 sau:<\/span><\/p>\n<ul>\n<li><span style=\"font-weight: 400;\"><strong>Ctrl + Shift + ~:<\/strong> \u00c1p d\u1ee5ng \u0111\u1ecbnh d\u1ea1ng s\u1ed1 chung.<\/span><\/li>\n<li><span style=\"font-weight: 400;\"><strong>Ctrl + Shift + $:<\/strong> \u00c1p d\u1ee5ng \u0111\u1ecbnh d\u1ea1ng ti\u1ec1n t\u1ec7.<\/span><\/li>\n<li><span style=\"font-weight: 400;\"><strong>Ctrl + Shift + %:<\/strong> \u00c1p d\u1ee5ng \u0111\u1ecbnh d\u1ea1ng ph\u1ea7n tr\u0103m.<\/span><\/li>\n<li><span style=\"font-weight: 400;\"><strong>Ctrl + Shift + #<\/strong>: \u00c1p d\u1ee5ng \u0111\u1ecbnh d\u1ea1ng ng\u00e0y th\u00e1ng.<\/span><\/li>\n<li><span style=\"font-weight: 400;\"><strong>Ctrl + Shift + @:<\/strong> \u00c1p d\u1ee5ng \u0111\u1ecbnh d\u1ea1ng th\u1eddi gian.<\/span><\/li>\n<li><span style=\"font-weight: 400;\"><strong>Ctrl + Shift + ^:<\/strong> \u00c1p d\u1ee5ng \u0111\u1ecbnh d\u1ea1ng s\u1ed1 m\u0169.<\/span><\/li>\n<li><span style=\"font-weight: 400;\"><strong>Ctrl + Shift + !:<\/strong> \u00c1p d\u1ee5ng \u0111\u1ecbnh d\u1ea1ng s\u1ed1 v\u1edbi d\u1ea5u ph\u1ea9y ph\u00e2n c\u00e1ch h\u00e0ng ngh\u00ecn.<\/span><\/li>\n<\/ul>\n<p><span style=\"font-weight: 400;\">\u0110\u1ecbnh d\u1ea1ng t\u00f9y ch\u1ec9nh v\u00e0 n\u00e2ng cao:<\/span><\/p>\n<ul>\n<li style=\"text-align: justify;\"><span style=\"font-weight: 400;\"><strong>Ctrl + 1:<\/strong> M\u1edf h\u1ed9p tho\u1ea1i &#8220;Format Cells&#8221;, n\u01a1i b\u1ea1n c\u00f3 th\u1ec3 ch\u1ecdn c\u00e1c t\u00f9y ch\u1ecdn \u0111\u1ecbnh d\u1ea1ng s\u1ed1 n\u00e2ng cao h\u01a1n, bao g\u1ed3m \u0111\u1ecbnh d\u1ea1ng t\u00f9y ch\u1ec9nh v\u00e0 c\u00e1c ki\u1ec3u \u0111\u1ecbnh d\u1ea1ng kh\u00e1c kh\u00f4ng \u0111\u01b0\u1ee3c li\u1ec7t k\u00ea \u1edf tr\u00ean.<\/span><\/li>\n<\/ul>\n<p><span style=\"font-weight: 400;\">\u00c1p d\u1ee5ng v\u00e0 x\u00f3a \u0111\u1ecbnh d\u1ea1ng:<\/span><\/p>\n<ul>\n<li><span style=\"font-weight: 400;\"><strong>Alt + E, S, T:<\/strong> M\u1edf h\u1ed9p tho\u1ea1i &#8220;Paste Special&#8221;, sau \u0111\u00f3 nh\u1ea5n T \u0111\u1ec3 ch\u1ecdn &#8220;Formats&#8221;. \u0110i\u1ec1u n\u00e0y cho ph\u00e9p b\u1ea1n sao ch\u00e9p \u0111\u1ecbnh d\u1ea1ng t\u1eeb m\u1ed9t \u00f4 \u0111\u00e3 ch\u1ecdn v\u00e0 \u00e1p d\u1ee5ng n\u00f3 cho \u00f4 kh\u00e1c.<\/span><\/li>\n<li><span style=\"font-weight: 400;\"><strong>Alt + H, E, F:<\/strong> X\u00f3a \u0111\u1ecbnh d\u1ea1ng c\u1ee7a \u00f4 \u0111\u01b0\u1ee3c ch\u1ecdn m\u00e0 kh\u00f4ng x\u00f3a d\u1eef li\u1ec7u trong \u00f4.<\/span><\/li>\n<\/ul>\n<p><span style=\"font-weight: 400;\">\u0110\u1ecbnh d\u1ea1ng \u0111i\u1ec1u ki\u1ec7n:<\/span><\/p>\n<ul>\n<li style=\"text-align: justify;\"><span style=\"font-weight: 400;\"><strong>Alt + O, D:<\/strong> M\u1edf h\u1ed9p tho\u1ea1i &#8220;Conditional Formatting&#8221; \u0111\u1ec3 thi\u1ebft l\u1eadp c\u00e1c quy t\u1eafc \u0111\u1ecbnh d\u1ea1ng d\u1ef1a tr\u00ean \u0111i\u1ec1u ki\u1ec7n cho d\u1eef li\u1ec7u c\u1ee7a b\u1ea1n.<\/span><\/li>\n<\/ul>\n<h2 style=\"text-align: justify;\"><strong>3. C\u00e1c ph\u00edm t\u1eaft khi l\u00e0m vi\u1ec7c li\u00ean quan \u0111\u1ebfn c\u00e1c h\u00e0m v\u00e0 thanh c\u00f4ng th\u1ee9c<\/strong><\/h2>\n<figure id=\"attachment_165031\" aria-describedby=\"caption-attachment-165031\" style=\"width: 1200px\" class=\"wp-caption alignnone\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-165031\" src=\"\/wp-content\/uploads\/2024\/09\/cac-phim-tat-trong-excel-2.jpg\" alt=\"\" width=\"1200\" height=\"675\" srcset=\"\/wp-content\/uploads\/2024\/09\/cac-phim-tat-trong-excel-2.jpg 1200w, \/wp-content\/uploads\/2024\/09\/cac-phim-tat-trong-excel-2-500x281.jpg 500w, \/wp-content\/uploads\/2024\/09\/cac-phim-tat-trong-excel-2-1024x576.jpg 1024w, \/wp-content\/uploads\/2024\/09\/cac-phim-tat-trong-excel-2-768x432.jpg 768w\" sizes=\"(max-width: 1200px) 100vw, 1200px\" \/><figcaption id=\"caption-attachment-165031\" class=\"wp-caption-text\">xr:d:DAF7GIvLnpc:233,j:1367264046352028673,t:24031315<\/figcaption><\/figure>\n<p>C\u00e1c ph\u00edm t\u1eaft excel khi l\u00e0m vi\u1ec7c v\u1edbi c\u00e1c \u00f4 nh\u01b0 sau:<\/p>\n<ul>\n<li><strong>Ctrl + T ho\u1eb7c Ctrl + L:<\/strong> Chuy\u1ec3n ph\u1ea1m vi d\u1eef li\u1ec7u \u0111\u01b0\u1ee3c ch\u1ecdn th\u00e0nh b\u1ea3ng (Table).<\/li>\n<li style=\"text-align: justify;\"><strong>Shift + Space:<\/strong> Ch\u1ecdn h\u00e0ng ho\u00e0n ch\u1ec9nh.<\/li>\n<li style=\"text-align: justify;\"><strong>Ctrl + Space:<\/strong> Ch\u1ecdn c\u1ed9t ho\u00e0n ch\u1ec9nh.<\/li>\n<li style=\"text-align: justify;\">Ctrl + D: S\u1eed d\u1ee5ng l\u1ec7nh Fill Down \u0111\u1ec3 sao ch\u00e9p n\u1ed9i dung v\u00e0 \u0111\u1ecbnh d\u1ea1ng c\u1ee7a \u00f4 tr\u00ean c\u00f9ng xu\u1ed1ng c\u00e1c \u00f4 \u0111\u00e3 ch\u1ecdn b\u00ean d\u01b0\u1edbi.<\/li>\n<li style=\"text-align: justify;\">Ctrl + R: S\u1eed d\u1ee5ng l\u1ec7nh Fill Right \u0111\u1ec3 sao ch\u00e9p n\u1ed9i dung v\u00e0 \u0111\u1ecbnh d\u1ea1ng c\u1ee7a \u00f4 b\u00ean tr\u00e1i sang c\u00e1c \u00f4 \u0111\u00e3 ch\u1ecdn b\u00ean ph\u1ea3i.<\/li>\n<\/ul>\n<p>C\u00e1c ph\u00edm t\u1eaft excel khi l\u00e0m vi\u1ec7c v\u1edbi c\u00e1c H\u00e0m:<\/p>\n<ul>\n<li style=\"text-align: justify;\"><strong>Shift + F3:<\/strong> M\u1edf h\u1ed9p tho\u1ea1i Insert Function, gi\u00fap b\u1ea1n t\u00ecm ki\u1ebfm v\u00e0 ch\u00e8n c\u00e1c h\u00e0m.<\/li>\n<li style=\"text-align: justify;\"><strong>Alt + =:<\/strong> T\u1ef1 \u0111\u1ed9ng ch\u00e8n c\u00f4ng th\u1ee9c t\u1ed5ng c\u1ed9ng cho d\u1eef li\u1ec7u \u0111\u00e3 ch\u1ecdn.<\/li>\n<li style=\"text-align: justify;\"><strong>Ctrl + Shift + Enter:<\/strong> Khi nh\u1eadp m\u1ed9t c\u00f4ng th\u1ee9c m\u1ea3ng, d\u00f9ng t\u1ed5 h\u1ee3p ph\u00edm n\u00e0y \u0111\u1ec3 \u00e1p d\u1ee5ng c\u00f4ng th\u1ee9c \u0111\u00f3 nh\u01b0 m\u1ed9t c\u00f4ng th\u1ee9c m\u1ea3ng.<\/li>\n<\/ul>\n<p>C\u00e1c ph\u00edm t\u1eaft excel khi l\u00e0m vi\u1ec7c v\u1edbi Thanh c\u00f4ng th\u1ee9c:<\/p>\n<ul>\n<li style=\"text-align: justify;\"><strong>F2:<\/strong> Ch\u1ec9nh s\u1eeda \u00f4 ho\u1eb7c c\u00f4ng th\u1ee9c hi\u1ec7n t\u1ea1i trong thanh c\u00f4ng th\u1ee9c.<\/li>\n<li style=\"text-align: justify;\"><strong>Ctrl + Shift + U:<\/strong> M\u1edf r\u1ed9ng ho\u1eb7c thu g\u1ecdn thanh c\u00f4ng th\u1ee9c \u0111\u1ec3 hi\u1ec3n th\u1ecb nhi\u1ec1u d\u00f2ng h\u01a1n, gi\u00fap ch\u1ec9nh s\u1eeda c\u00f4ng th\u1ee9c d\u1ec5 d\u00e0ng h\u01a1n.<\/li>\n<li style=\"text-align: justify;\"><strong>Esc:<\/strong> H\u1ee7y b\u1ecf m\u1ecdi thay \u0111\u1ed5i trong \u00f4 ho\u1eb7c thanh c\u00f4ng th\u1ee9c v\u00e0 quay tr\u1edf l\u1ea1i b\u1ea3ng t\u00ednh.<\/li>\n<li style=\"text-align: justify;\"><strong>Enter:<\/strong> \u00c1p d\u1ee5ng c\u00f4ng th\u1ee9c ho\u1eb7c thay \u0111\u1ed5i \u0111\u00e3 nh\u1eadp v\u00e0o thanh c\u00f4ng th\u1ee9c v\u00e0 chuy\u1ec3n \u0111\u1ebfn \u00f4 ti\u1ebfp theo.<\/li>\n<\/ul>\n<p><a href=\"https:\/\/amis.misa.vn\/register\/?appcode=Accounting&amp;s_pd=amis-ke-toan-Blog?source=Blog&amp;medium=content&amp;campaign=TCKT&amp;content=phim-tat-excel&amp;term=act_\" target=\"_blank\" rel=\"noopener\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-165027\" src=\"\/wp-content\/uploads\/2024\/09\/12-4.jpg\" alt=\"\" width=\"1500\" height=\"185\" srcset=\"\/wp-content\/uploads\/2024\/09\/12-4.jpg 1500w, \/wp-content\/uploads\/2024\/09\/12-4-500x62.jpg 500w, \/wp-content\/uploads\/2024\/09\/12-4-1024x126.jpg 1024w, \/wp-content\/uploads\/2024\/09\/12-4-768x95.jpg 768w\" sizes=\"(max-width: 1500px) 100vw, 1500px\" \/><\/a><\/p>\n<h2><strong>4. C\u00e1c ph\u00edm t\u1eaft v\u1ec1 qu\u1ea3n l\u00fd trang t\u00ednh<\/strong><\/h2>\n<p>Ph\u00edm t\u1eaft cho qu\u1ea3n l\u00fd trang t\u00ednh:<\/p>\n<ul>\n<li><strong>Ctrl + Page Down:<\/strong> Chuy\u1ec3n \u0111\u1ebfn trang t\u00ednh ti\u1ebfp theo trong s\u1ed5 l\u00e0m vi\u1ec7c.<\/li>\n<li style=\"text-align: justify;\"><strong>Ctrl + Page Up:<\/strong> Chuy\u1ec3n \u0111\u1ebfn trang t\u00ednh tr\u01b0\u1edbc \u0111\u00f3 trong s\u1ed5 l\u00e0m vi\u1ec7c.<\/li>\n<li style=\"text-align: justify;\"><strong>Shift + F11 ho\u1eb7c Alt + Shift + F1:<\/strong> T\u1ea1o m\u1ed9t trang t\u00ednh m\u1edbi.<\/li>\n<li style=\"text-align: justify;\"><strong>Ctrl + Shift + Page Down:<\/strong> Ch\u1ecdn trang t\u00ednh hi\u1ec7n t\u1ea1i v\u00e0 m\u1ed7i trang t\u00ednh ti\u1ebfp theo.<\/li>\n<li style=\"text-align: justify;\"><strong>Ctrl + Shift + Page Up:<\/strong> Ch\u1ecdn trang t\u00ednh hi\u1ec7n t\u1ea1i v\u00e0 m\u1ed7i trang t\u00ednh tr\u01b0\u1edbc \u0111\u00f3.<\/li>\n<\/ul>\n<p>Ph\u00edm t\u1eaft \u0111\u1ec3 \u0111\u1ed5i t\u00ean, di chuy\u1ec3n, ho\u1eb7c x\u00f3a trang t\u00ednh:<\/p>\n<ul>\n<li style=\"text-align: justify;\"><strong>Alt + O, H, R:<\/strong> \u0110\u1ed5i t\u00ean trang t\u00ednh hi\u1ec7n t\u1ea1i.<\/li>\n<li style=\"text-align: justify;\"><strong>Alt + E, L:<\/strong> X\u00f3a trang t\u00ednh hi\u1ec7n t\u1ea1i.<\/li>\n<li style=\"text-align: justify;\"><strong>Alt + E, M:<\/strong> Di chuy\u1ec3n ho\u1eb7c sao ch\u00e9p trang t\u00ednh hi\u1ec7n t\u1ea1i.<\/li>\n<\/ul>\n<p>Ph\u00edm t\u1eaft \u0111\u1ec3 \u0111\u1ecbnh d\u1ea1ng trang t\u00ednh:<\/p>\n<ul>\n<li style=\"text-align: justify;\"><strong>Alt + O, H, T:<\/strong> M\u1edf h\u1ed9p tho\u1ea1i \u0111\u1ec3 thi\u1ebft l\u1eadp m\u00e0u tab cho trang t\u00ednh.<\/li>\n<li style=\"text-align: justify;\"><strong>Alt + O, H, H:<\/strong> M\u1edf h\u1ed9p tho\u1ea1i \u0111\u1ec3 thi\u1ebft l\u1eadp n\u1ec1n cho trang t\u00ednh.<\/li>\n<\/ul>\n<p>Ph\u00edm t\u1eaft kh\u00e1c li\u00ean quan \u0111\u1ebfn trang t\u00ednh:<\/p>\n<ul>\n<li style=\"text-align: justify;\"><strong>Ctrl + K:<\/strong> Ch\u00e8n li\u00ean k\u1ebft si\u00eau d\u1eef li\u1ec7u trong trang t\u00ednh, c\u00f3 th\u1ec3 li\u00ean k\u1ebft \u0111\u1ebfn m\u1ed9t trang web, m\u1ed9t \u0111\u1ecba ch\u1ec9 email, ho\u1eb7c m\u1ed9t v\u1ecb tr\u00ed trong t\u00e0i li\u1ec7u Excel.<\/li>\n<li style=\"text-align: justify;\"><strong>Alt + W, L:<\/strong> Chuy\u1ec3n sang ch\u1ebf \u0111\u1ed9 xem b\u00ecnh th\u01b0\u1eddng c\u1ee7a trang t\u00ednh.<\/li>\n<li style=\"text-align: justify;\"><strong>Alt + W, V:<\/strong> Chuy\u1ec3n sang ch\u1ebf \u0111\u1ed9 xem Page Layout, n\u01a1i b\u1ea1n c\u00f3 th\u1ec3 xem trang t\u00ednh nh\u01b0 n\u00f3 s\u1ebd xu\u1ea5t hi\u1ec7n khi \u0111\u01b0\u1ee3c in.<\/li>\n<li style=\"text-align: justify;\"><strong>Alt + W, Q:<\/strong> M\u1edf h\u1ed9p tho\u1ea1i Zoom, cho ph\u00e9p b\u1ea1n \u0111i\u1ec1u ch\u1ec9nh k\u00edch th\u01b0\u1edbc xem c\u1ee7a trang t\u00ednh.<\/li>\n<\/ul>\n<h2><strong>5. C\u00e1c ph\u00edm t\u1eaft trong excel \u0111\u1ed1i v\u1edbi Macbook<\/strong><\/h2>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-165033\" src=\"\/wp-content\/uploads\/2024\/09\/cac-phim-tat-trong-excel-4.jpg\" alt=\"\" width=\"1200\" height=\"630\" srcset=\"\/wp-content\/uploads\/2024\/09\/cac-phim-tat-trong-excel-4.jpg 1200w, \/wp-content\/uploads\/2024\/09\/cac-phim-tat-trong-excel-4-500x263.jpg 500w, \/wp-content\/uploads\/2024\/09\/cac-phim-tat-trong-excel-4-1024x538.jpg 1024w, \/wp-content\/uploads\/2024\/09\/cac-phim-tat-trong-excel-4-768x403.jpg 768w\" sizes=\"(max-width: 1200px) 100vw, 1200px\" \/><\/p>\n<p style=\"text-align: justify;\">Tr\u00ean MacBook, c\u00e1c ph\u00edm t\u1eaft trong Excel th\u01b0\u1eddng \u0111\u01b0\u1ee3c thay \u0111\u1ed5i m\u1ed9t ch\u00fat so v\u1edbi phi\u00ean b\u1ea3n Windows do s\u1ef1 kh\u00e1c bi\u1ec7t trong b\u1ed1 c\u1ee5c b\u00e0n ph\u00edm v\u00e0 t\u1ed5 h\u1ee3p ph\u00edm Command thay v\u00ec Control.<\/p>\n<p style=\"text-align: justify;\">D\u01b0\u1edbi \u0111\u00e2y l\u00e0 danh s\u00e1ch c\u00e1c ph\u00edm t\u1eaft Excel ph\u1ed5 bi\u1ebfn tr\u00ean MacBook m\u00e0 b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng \u0111\u1ec3 t\u0103ng t\u1ed1c \u0111\u1ed9 l\u00e0m vi\u1ec7c v\u00e0 hi\u1ec7u qu\u1ea3:<\/p>\n<p>Ph\u00edm t\u1eaft c\u01a1 b\u1ea3n:<\/p>\n<ul>\n<li><strong>Cmd + N:<\/strong> M\u1edf m\u1ed9t s\u1ed5 l\u00e0m vi\u1ec7c m\u1edbi.<\/li>\n<li><strong>Cmd + O:<\/strong> M\u1edf m\u1ed9t s\u1ed5 l\u00e0m vi\u1ec7c \u0111\u00e3 c\u00f3.<\/li>\n<li><strong>Cmd + S:<\/strong> L\u01b0u s\u1ed5 l\u00e0m vi\u1ec7c hi\u1ec7n t\u1ea1i.<\/li>\n<li><strong>Cmd + P:<\/strong> In s\u1ed5 l\u00e0m vi\u1ec7c.<\/li>\n<li><strong>Cmd + C:<\/strong> Sao ch\u00e9p \u00f4 ho\u1eb7c v\u00f9ng ch\u1ecdn \u0111\u1ebfn clipboard.<\/li>\n<li><strong>Cmd + X:<\/strong> C\u1eaft \u00f4 ho\u1eb7c v\u00f9ng ch\u1ecdn.<\/li>\n<li><strong>Cmd + V:<\/strong> D\u00e1n n\u1ed9i dung t\u1eeb clipboard.<\/li>\n<li><strong>Cmd + Z:<\/strong> Ho\u00e0n t\u00e1c thao t\u00e1c tr\u01b0\u1edbc.<\/li>\n<li><strong>Cmd + Y:<\/strong> L\u00e0m l\u1ea1i thao t\u00e1c \u0111\u00e3 ho\u00e0n t\u00e1c.<\/li>\n<li><strong>Cmd + T:<\/strong> M\u1edf m\u1ed9t tab m\u1edbi trong c\u1eeda s\u1ed5 Finder.<\/li>\n<\/ul>\n<p>\u0110i\u1ec1u h\u01b0\u1edbng v\u00e0 l\u1ef1a ch\u1ecdn:<\/p>\n<ul>\n<li><strong>Cmd + Arrow Key:<\/strong> Di chuy\u1ec3n \u0111\u1ebfn c\u1ea1nh c\u1ee7a d\u1eef li\u1ec7u trong h\u01b0\u1edbng ch\u1ec9 \u0111\u1ecbnh.<\/li>\n<li><strong>Cmd + Shift + K:<\/strong> Ch\u00e8n m\u1ed9t li\u00ean k\u1ebft si\u00eau d\u1eef li\u1ec7u.<\/li>\n<li><strong>Option + Arrow Key:<\/strong> Di chuy\u1ec3n m\u1ed9t t\u1eeb m\u1ed7i l\u1ea7n nh\u1ea5n.<\/li>\n<li><strong>Shift + Cmd + T:<\/strong> Hi\u1ec3n th\u1ecb ho\u1eb7c \u1ea9n thanh c\u00f4ng th\u1ee9c.<\/li>\n<\/ul>\n<p>\u0110\u1ecbnh d\u1ea1ng s\u1ed1:<\/p>\n<ul>\n<li><strong>Cmd + Shift + $:<\/strong> \u00c1p d\u1ee5ng \u0111\u1ecbnh d\u1ea1ng ti\u1ec1n t\u1ec7.<\/li>\n<li><strong>Cmd + Shift + %:<\/strong> \u00c1p d\u1ee5ng \u0111\u1ecbnh d\u1ea1ng ph\u1ea7n tr\u0103m.<\/li>\n<li><strong>Cmd + Shift + #:<\/strong> \u00c1p d\u1ee5ng \u0111\u1ecbnh d\u1ea1ng ng\u00e0y th\u00e1ng.<\/li>\n<li><strong>Cmd + Shift + ^:<\/strong> \u00c1p d\u1ee5ng \u0111\u1ecbnh d\u1ea1ng s\u1ed1 m\u0169.<\/li>\n<li><strong>Cmd + Shift + @:<\/strong> \u00c1p d\u1ee5ng \u0111\u1ecbnh d\u1ea1ng th\u1eddi gian.<\/li>\n<li><strong>Cmd + 1:<\/strong> M\u1edf h\u1ed9p tho\u1ea1i Format Cells.<\/li>\n<\/ul>\n<p>Qu\u1ea3n l\u00fd trang t\u00ednh:<\/p>\n<ul>\n<li><strong>Cmd + T:<\/strong> T\u1ea1o m\u1ed9t b\u1ea3ng trong Excel.<\/li>\n<li><strong>Cmd + Shift + F6:<\/strong> Chuy\u1ec3n gi\u1eefa c\u00e1c trang t\u00ednh trong s\u1ed5 l\u00e0m vi\u1ec7c.<\/li>\n<li><strong>Cmd + K:<\/strong> Ch\u00e8n li\u00ean k\u1ebft si\u00eau d\u1eef li\u1ec7u.<\/li>\n<\/ul>\n<p>\u0110\u1ecbnh d\u1ea1ng d\u00f2ng v\u00e0 c\u1ed9t:<\/p>\n<ul>\n<li><strong>Cmd + Shift + 0:<\/strong> Hi\u1ec7n c\u1ed9t b\u1ecb \u1ea9n.<\/li>\n<li><strong>Cmd + Shift + 9:<\/strong> Hi\u1ec7n h\u00e0ng b\u1ecb \u1ea9n.<\/li>\n<li><strong>Cmd + Option + K:<\/strong> B\u1eaft \u0111\u1ea7u ho\u1eb7c k\u1ebft th\u00fac nh\u00f3m h\u00e0ng ho\u1eb7c c\u1ed9t.<\/li>\n<li><strong>Cmd + Option + J:<\/strong> Ch\u00e8n ho\u1eb7c x\u00f3a h\u00e0ng ho\u1eb7c c\u1ed9t.<\/li>\n<\/ul>\n<p>C\u00e1c ph\u00edm t\u1eaft kh\u00e1c:<\/p>\n<ul>\n<li><strong>Cmd + Shift + P:<\/strong> Ph\u00f3ng to ho\u1eb7c thu nh\u1ecf k\u00edch th\u01b0\u1edbc font ch\u1eef.<\/li>\n<li><strong>Cmd + Option + V:<\/strong> D\u00e1n \u0111\u1eb7c bi\u1ec7t.<\/li>\n<li><strong>Cmd + Shift + T<\/strong>: M\u1edf thanh c\u00f4ng c\u1ee5.<\/li>\n<\/ul>\n<p style=\"text-align: justify;\">C\u00e1c ph\u00edm t\u1eaft trong Excel l\u00e0 c\u00f4ng c\u1ee5 kh\u00f4ng th\u1ec3 thi\u1ebfu cho b\u1ea5t k\u1ef3 ai mu\u1ed1n n\u00e2ng cao n\u0103ng su\u1ea5t l\u00e0m vi\u1ec7c trong m\u00f4i tr\u01b0\u1eddng s\u1eed d\u1ee5ng b\u1ea3ng t\u00ednh. T\u1eeb vi\u1ec7c \u0111\u1ecbnh d\u1ea1ng nhanh c\u00e1c \u00f4, d\u00f2ng, c\u1ed9t cho \u0111\u1ebfn vi\u1ec7c th\u1ef1c thi c\u00e1c h\u00e0m ph\u1ee9c t\u1ea1p v\u00e0 \u0111i\u1ec1u h\u01b0\u1edbng qua l\u1ea1i gi\u1eefa c\u00e1c trang t\u00ednh, ph\u00edm t\u1eaft gi\u00fap ti\u1ebft ki\u1ec7m th\u1eddi gian \u0111\u00e1ng k\u1ec3 v\u00e0 gi\u1ea3m b\u1edbt g\u00e1nh n\u1eb7ng trong vi\u1ec7c th\u1ef1c hi\u1ec7n c\u00e1c thao t\u00e1c chu\u1ed9t ph\u1ee9c t\u1ea1p. B\u1eb1ng c\u00e1ch l\u00e0m quen v\u00e0 \u00e1p d\u1ee5ng th\u01b0\u1eddng xuy\u00ean nh\u1eefng ph\u00edm t\u1eaft n\u00e0y, k\u1ebf to\u00e1n c\u00f3 th\u1ec3 t\u1eadn d\u1ee5ng t\u1ed1i \u0111a kh\u1ea3 n\u0103ng c\u1ee7a Excel, t\u1eeb \u0111\u00f3 t\u0103ng hi\u1ec7u qu\u1ea3 c\u00f4ng vi\u1ec7c v\u00e0 \u0111\u1ea1t \u0111\u01b0\u1ee3c k\u1ebft qu\u1ea3 t\u1ed1t h\u01a1n trong m\u1ecdi d\u1ef1 \u00e1n li\u00ean quan \u0111\u1ebfn d\u1eef li\u1ec7u.<\/p>\n<p style=\"text-align: justify;\">MISA AMIS l\u00e0 n\u1ec1n t\u1ea3ng cung c\u1ea5p kh\u00f4ng ch\u1ec9 ki\u1ebfn th\u1ee9c chuy\u00ean s\u00e2u v\u1ec1 k\u1ebf to\u00e1n, m\u00e0 c\u00f2n h\u1ed7 tr\u1ee3 ng\u01b0\u1eddi d\u00f9ng trong c\u00e1c nghi\u1ec7p v\u1ee5 k\u1ebf to\u00e1n quan tr\u1ecdng nh\u01b0 Excel. Ngo\u00e0i ra, MISA AMIS cung c\u1ea5p <a href=\"https:\/\/amis.misa.vn\/register\/?appcode=Accounting&amp;s_pd=amis-ke-toan-Blog?source=Blog&amp;medium=content&amp;campaign=TCKT&amp;content=phim-tat-excel&amp;term=act_\" target=\"_blank\" rel=\"noopener\"><strong>ph\u1ea7n m\u1ec1m k\u1ebf to\u00e1n online MISA AMIS<\/strong> <\/a>v\u1edbi c\u00e1c t\u00ednh n\u0103ng n\u1ed5i b\u1eadt nh\u01b0:<\/p>\n<ul>\n<li style=\"text-align: justify;\">T\u1ef1 \u0111\u1ed9ng h\u00f3a quy tr\u00ecnh nh\u1eadp li\u1ec7u excel, h\u1ea1ch to\u00e1n, gi\u1ea3m b\u1edbt th\u1eddi gian v\u00e0 sai s\u00f3t.<\/li>\n<li style=\"text-align: justify;\">K\u1ebft n\u1ed1i tr\u1ef1c ti\u1ebfp v\u1edbi ng\u00e2n h\u00e0ng, gi\u00fap \u0111\u1ed1i chi\u1ebfu v\u00e0 ki\u1ec3m so\u00e1t s\u1ed1 li\u1ec7u ng\u00e2n h\u00e0ng d\u1ec5 d\u00e0ng.<\/li>\n<li style=\"text-align: justify;\">B\u00e1o c\u00e1o t\u00e0i ch\u00ednh nhanh ch\u00f3ng, c\u1eadp nh\u1eadt s\u1ed1 li\u1ec7u theo th\u1eddi gian th\u1ef1c.<\/li>\n<li style=\"text-align: justify;\">T\u00edch h\u1ee3p nhi\u1ec1u ph\u1ea7n m\u1ec1m qu\u1ea3n l\u00fd, \u0111\u1ed3ng b\u1ed9 d\u1eef li\u1ec7u gi\u1eefa c\u00e1c b\u1ed9 ph\u1eadn.<\/li>\n<li style=\"text-align: justify;\">Qu\u1ea3n l\u00fd thu\u1ebf linh ho\u1ea1t, l\u1eadp v\u00e0 n\u1ed9p t\u1edd khai thu\u1ebf ch\u00ednh x\u00e1c v\u00e0 \u0111\u00fang h\u1ea1n.<\/li>\n<\/ul>\n<p style=\"text-align: center;\"><strong>Tr\u1ea3i nghi\u1ec7m 15 ng\u00e0y d\u00f9ng th\u1eed mi\u1ec5n ph\u00ed MISA AMIS \u2013 ph\u1ea7n m\u1ec1m k\u1ebf to\u00e1n online gi\u00fap b\u1ea1n qu\u1ea3n l\u00fd t\u00e0i ch\u00ednh hi\u1ec7u qu\u1ea3 h\u01a1n<\/strong><\/p>\n<p><a href=\"https:\/\/amis.misa.vn\/register\/?appcode=Accounting&amp;s_pd=amis-ke-toan-Blog?source=Blog&amp;medium=content&amp;campaign=TCKT&amp;content=phim-tat-excel&amp;term=act_\" target=\"_blank\" rel=\"noopener\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-164107\" src=\"\/wp-content\/uploads\/2023\/12\/Untitled-design-28.png\" alt=\"\" width=\"800\" height=\"366\" srcset=\"\/wp-content\/uploads\/2023\/12\/Untitled-design-28.png 800w, \/wp-content\/uploads\/2023\/12\/Untitled-design-28-500x229.png 500w, \/wp-content\/uploads\/2023\/12\/Untitled-design-28-768x351.png 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/><\/a><\/p>\n<div class=\"pvc_clear\"><\/div>\n<p id=\"pvc_stats_164997\" class=\"pvc_stats total_only  \" data-element-id=\"164997\" style=\"\"><i class=\"pvc-stats-icon medium\" aria-hidden=\"true\"><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" version=\"1.0\" viewBox=\"0 0 502 315\" preserveAspectRatio=\"xMidYMid meet\"><g transform=\"translate(0,332) scale(0.1,-0.1)\" fill=\"\" stroke=\"none\"><path d=\"M2394 3279 l-29 -30 -3 -207 c-2 -182 0 -211 15 -242 39 -76 157 -76 196 0 15 31 17 60 15 243 l-3 209 -33 29 c-26 23 -41 29 -80 29 -41 0 -53 -5 -78 -31z\"\/><path d=\"M3085 3251 c-45 -19 -58 -50 -96 -229 -47 -217 -49 -260 -13 -295 52 -53 146 -42 177 20 16 31 87 366 87 410 0 70 -86 122 -155 94z\"\/><path d=\"M1751 3234 c-13 -9 -29 -31 -37 -50 -12 -29 -10 -49 21 -204 19 -94 39 -189 45 -210 14 -50 54 -80 110 -80 34 0 48 6 76 34 21 21 34 44 34 59 0 14 -18 113 -40 219 -37 178 -43 195 -70 221 -36 32 -101 37 -139 11z\"\/><path d=\"M1163 3073 c-36 -7 -73 -59 -73 -102 0 -56 133 -378 171 -413 34 -32 83 -37 129 -13 70 36 67 87 -16 290 -86 209 -89 214 -129 231 -35 14 -42 15 -82 7z\"\/><path d=\"M3689 3066 c-15 -9 -33 -30 -42 -48 -48 -103 -147 -355 -147 -375 0 -98 131 -148 192 -74 13 15 57 108 97 206 80 196 84 226 37 273 -30 30 -99 39 -137 18z\"\/><path d=\"M583 2784 c-38 -19 -67 -74 -58 -113 9 -42 211 -354 242 -373 16 -10 45 -18 66 -18 51 0 107 52 107 100 0 39 -1 41 -124 234 -80 126 -108 162 -133 173 -41 17 -61 16 -100 -3z\"\/><path d=\"M4250 2784 c-14 -9 -74 -91 -133 -183 -95 -150 -107 -173 -107 -213 0 -55 33 -94 87 -104 67 -13 90 8 211 198 130 202 137 225 78 284 -27 27 -42 34 -72 34 -22 0 -50 -8 -64 -16z\"\/><path d=\"M2275 2693 c-553 -48 -1095 -270 -1585 -649 -135 -104 -459 -423 -483 -476 -23 -49 -22 -139 2 -186 73 -142 361 -457 571 -626 285 -228 642 -407 990 -497 242 -63 336 -73 660 -74 310 0 370 5 595 52 535 111 1045 392 1455 803 122 121 250 273 275 326 19 41 19 137 0 174 -41 79 -309 363 -465 492 -447 370 -946 591 -1479 653 -113 14 -422 18 -536 8z m395 -428 c171 -34 330 -124 456 -258 112 -119 167 -219 211 -378 27 -96 24 -300 -5 -401 -72 -255 -236 -447 -474 -557 -132 -62 -201 -76 -368 -76 -167 0 -236 14 -368 76 -213 98 -373 271 -451 485 -162 444 86 934 547 1084 153 49 292 57 452 25z m909 -232 c222 -123 408 -262 593 -441 76 -74 138 -139 138 -144 0 -16 -233 -242 -330 -319 -155 -123 -309 -223 -461 -299 l-81 -41 32 46 c18 26 49 83 70 128 143 306 141 649 -6 957 -25 52 -61 116 -79 142 l-34 47 45 -20 c26 -10 76 -36 113 -56z m-2057 25 c-40 -58 -105 -190 -130 -263 -110 -324 -59 -707 132 -981 25 -35 42 -64 37 -64 -19 0 -241 119 -326 174 -188 122 -406 314 -532 468 l-58 71 108 103 c185 178 428 349 672 473 66 33 121 60 123 61 2 0 -10 -19 -26 -42z\"\/><path d=\"M2375 1950 c-198 -44 -350 -190 -395 -379 -18 -76 -8 -221 19 -290 114 -284 457 -406 731 -260 98 52 188 154 231 260 27 69 37 214 19 290 -38 163 -166 304 -326 360 -67 23 -215 33 -279 19z\"\/><\/g><\/svg><\/i> <img loading=\"lazy\" decoding=\"async\" width=\"16\" height=\"16\" alt=\"Loading\" src=\"\/wp-content\/plugins\/page-views-count\/ajax-loader-2x.gif\" border=0 \/><\/p>\n<div class=\"pvc_clear\"><\/div>\n<div style='text-align:center' class='yasr-auto-insert-visitor'><\/div>","protected":false},"excerpt":{"rendered":"<p>Excel l\u00e0 c\u00f4ng c\u1ee5 kh\u00f4ng th\u1ec3 thi\u1ebfu trong c\u00f4ng vi\u1ec7c h\u00e0ng ng\u00e0y c\u1ee7a m\u1ed9t k\u1ebf to\u00e1n vi\u00ean. Vi\u1ec7c s\u1eed d\u1ee5ng c\u00e1c ph\u00edm t\u1eaft kh\u00f4ng ch\u1ec9 gi\u00fap t\u0103ng t\u1ed1c \u0111\u1ed9 x\u1eed l\u00fd v\u00e0 c\u1ea3i thi\u1ec7n hi\u1ec7u su\u1ea5t c\u00f4ng vi\u1ec7c m\u00e0 c\u00f2n gi\u00fap c\u00e1c nh\u00e2n vi\u00ean k\u1ebf to\u00e1n t\u1eadp trung h\u01a1n v\u00e0o ph\u00e2n t\u00edch v\u00e0 ra quy\u1ebft [&hellip;]<\/p>\n<div class=\"pvc_clear\"><\/div>\n<p id=\"pvc_stats_164997\" class=\"pvc_stats total_only  \" data-element-id=\"164997\" style=\"\"><i class=\"pvc-stats-icon medium\" aria-hidden=\"true\"><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" version=\"1.0\" viewBox=\"0 0 502 315\" preserveAspectRatio=\"xMidYMid meet\"><g transform=\"translate(0,332) scale(0.1,-0.1)\" fill=\"\" stroke=\"none\"><path d=\"M2394 3279 l-29 -30 -3 -207 c-2 -182 0 -211 15 -242 39 -76 157 -76 196 0 15 31 17 60 15 243 l-3 209 -33 29 c-26 23 -41 29 -80 29 -41 0 -53 -5 -78 -31z\"\/><path d=\"M3085 3251 c-45 -19 -58 -50 -96 -229 -47 -217 -49 -260 -13 -295 52 -53 146 -42 177 20 16 31 87 366 87 410 0 70 -86 122 -155 94z\"\/><path d=\"M1751 3234 c-13 -9 -29 -31 -37 -50 -12 -29 -10 -49 21 -204 19 -94 39 -189 45 -210 14 -50 54 -80 110 -80 34 0 48 6 76 34 21 21 34 44 34 59 0 14 -18 113 -40 219 -37 178 -43 195 -70 221 -36 32 -101 37 -139 11z\"\/><path d=\"M1163 3073 c-36 -7 -73 -59 -73 -102 0 -56 133 -378 171 -413 34 -32 83 -37 129 -13 70 36 67 87 -16 290 -86 209 -89 214 -129 231 -35 14 -42 15 -82 7z\"\/><path d=\"M3689 3066 c-15 -9 -33 -30 -42 -48 -48 -103 -147 -355 -147 -375 0 -98 131 -148 192 -74 13 15 57 108 97 206 80 196 84 226 37 273 -30 30 -99 39 -137 18z\"\/><path d=\"M583 2784 c-38 -19 -67 -74 -58 -113 9 -42 211 -354 242 -373 16 -10 45 -18 66 -18 51 0 107 52 107 100 0 39 -1 41 -124 234 -80 126 -108 162 -133 173 -41 17 -61 16 -100 -3z\"\/><path d=\"M4250 2784 c-14 -9 -74 -91 -133 -183 -95 -150 -107 -173 -107 -213 0 -55 33 -94 87 -104 67 -13 90 8 211 198 130 202 137 225 78 284 -27 27 -42 34 -72 34 -22 0 -50 -8 -64 -16z\"\/><path d=\"M2275 2693 c-553 -48 -1095 -270 -1585 -649 -135 -104 -459 -423 -483 -476 -23 -49 -22 -139 2 -186 73 -142 361 -457 571 -626 285 -228 642 -407 990 -497 242 -63 336 -73 660 -74 310 0 370 5 595 52 535 111 1045 392 1455 803 122 121 250 273 275 326 19 41 19 137 0 174 -41 79 -309 363 -465 492 -447 370 -946 591 -1479 653 -113 14 -422 18 -536 8z m395 -428 c171 -34 330 -124 456 -258 112 -119 167 -219 211 -378 27 -96 24 -300 -5 -401 -72 -255 -236 -447 -474 -557 -132 -62 -201 -76 -368 -76 -167 0 -236 14 -368 76 -213 98 -373 271 -451 485 -162 444 86 934 547 1084 153 49 292 57 452 25z m909 -232 c222 -123 408 -262 593 -441 76 -74 138 -139 138 -144 0 -16 -233 -242 -330 -319 -155 -123 -309 -223 -461 -299 l-81 -41 32 46 c18 26 49 83 70 128 143 306 141 649 -6 957 -25 52 -61 116 -79 142 l-34 47 45 -20 c26 -10 76 -36 113 -56z m-2057 25 c-40 -58 -105 -190 -130 -263 -110 -324 -59 -707 132 -981 25 -35 42 -64 37 -64 -19 0 -241 119 -326 174 -188 122 -406 314 -532 468 l-58 71 108 103 c185 178 428 349 672 473 66 33 121 60 123 61 2 0 -10 -19 -26 -42z\"\/><path d=\"M2375 1950 c-198 -44 -350 -190 -395 -379 -18 -76 -8 -221 19 -290 114 -284 457 -406 731 -260 98 52 188 154 231 260 27 69 37 214 19 290 -38 163 -166 304 -326 360 -67 23 -215 33 -279 19z\"\/><\/g><\/svg><\/i> <img loading=\"lazy\" decoding=\"async\" width=\"16\" height=\"16\" alt=\"Loading\" src=\"\/wp-content\/plugins\/page-views-count\/ajax-loader-2x.gif\" border=0 \/><\/p>\n<div class=\"pvc_clear\"><\/div>\n","protected":false},"author":163,"featured_media":165029,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"yasr_overall_rating":0,"yasr_post_is_review":"","yasr_auto_insert_disabled":"","yasr_review_type":"","footnotes":""},"categories":[2627,1399,24],"tags":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v22.9 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>T\u1ed5ng H\u1ee3p C\u00e1c Ph\u00edm T\u1eaft Excel H\u1eefu \u00cdch Cho Ng\u01b0\u1eddi L\u00e0m K\u1ebf To\u00e1n<\/title>\n<meta name=\"description\" content=\"D\u01b0\u1edbi \u0111\u00e2y l\u00e0 danh s\u00e1ch c\u00e1c ph\u00edm t\u1eaft Excel quan tr\u1ecdng m\u00e0 m\u1ecdi k\u1ebf to\u00e1n vi\u00ean n\u00ean bi\u1ebft \u0111\u1ec3 t\u1ed1i \u01b0u h\u00f3a c\u00f4ng vi\u1ec7c c\u1ee7a m\u00ecnh.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<meta name=\"twitter:label1\" content=\"\u0110\u01b0\u1ee3c vi\u1ebft b\u1edfi\" \/>\n\t<meta name=\"twitter:data1\" content=\"ACT. K-0014 DTTLinh\" \/>\n\t<meta name=\"twitter:label2\" content=\"\u01af\u1edbc t\u00ednh th\u1eddi gian \u0111\u1ecdc\" \/>\n\t<meta name=\"twitter:data2\" content=\"12 ph\u00fat\" \/>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"T\u1ed5ng H\u1ee3p C\u00e1c Ph\u00edm T\u1eaft Excel H\u1eefu \u00cdch Cho Ng\u01b0\u1eddi L\u00e0m K\u1ebf To\u00e1n","description":"D\u01b0\u1edbi \u0111\u00e2y l\u00e0 danh s\u00e1ch c\u00e1c ph\u00edm t\u1eaft Excel quan tr\u1ecdng m\u00e0 m\u1ecdi k\u1ebf to\u00e1n vi\u00ean n\u00ean bi\u1ebft \u0111\u1ec3 t\u1ed1i \u01b0u h\u00f3a c\u00f4ng vi\u1ec7c c\u1ee7a m\u00ecnh.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"twitter_misc":{"\u0110\u01b0\u1ee3c vi\u1ebft b\u1edfi":"ACT. K-0014 DTTLinh","\u01af\u1edbc t\u00ednh th\u1eddi gian \u0111\u1ecdc":"12 ph\u00fat"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/amis.misa.vn\/164997\/cac-phim-tat-excel\/","url":"https:\/\/amis.misa.vn\/164997\/cac-phim-tat-excel\/","name":"T\u1ed5ng H\u1ee3p C\u00e1c Ph\u00edm T\u1eaft Excel H\u1eefu \u00cdch Cho Ng\u01b0\u1eddi L\u00e0m K\u1ebf To\u00e1n","isPartOf":{"@id":"https:\/\/amis.misa.vn\/#website"},"primaryImageOfPage":{"@id":"https:\/\/amis.misa.vn\/164997\/cac-phim-tat-excel\/#primaryimage"},"image":{"@id":"https:\/\/amis.misa.vn\/164997\/cac-phim-tat-excel\/#primaryimage"},"thumbnailUrl":"\/wp-content\/uploads\/2024\/09\/cac-phim-tat-trong-excel.jpg","datePublished":"2024-09-28T03:14:16+00:00","dateModified":"2024-09-27T08:05:31+00:00","author":{"@id":"https:\/\/amis.misa.vn\/#\/schema\/person\/8efa885b11f0dd252d609df07bdcb0f1"},"description":"D\u01b0\u1edbi \u0111\u00e2y l\u00e0 danh s\u00e1ch c\u00e1c ph\u00edm t\u1eaft Excel quan tr\u1ecdng m\u00e0 m\u1ecdi k\u1ebf to\u00e1n vi\u00ean n\u00ean bi\u1ebft \u0111\u1ec3 t\u1ed1i \u01b0u h\u00f3a c\u00f4ng vi\u1ec7c c\u1ee7a m\u00ecnh.","breadcrumb":{"@id":"https:\/\/amis.misa.vn\/164997\/cac-phim-tat-excel\/#breadcrumb"},"inLanguage":"vi","potentialAction":[{"@type":"ReadAction","target":["https:\/\/amis.misa.vn\/164997\/cac-phim-tat-excel\/"]}]},{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/amis.misa.vn\/164997\/cac-phim-tat-excel\/#primaryimage","url":"\/wp-content\/uploads\/2024\/09\/cac-phim-tat-trong-excel.jpg","contentUrl":"\/wp-content\/uploads\/2024\/09\/cac-phim-tat-trong-excel.jpg","width":1200,"height":900},{"@type":"BreadcrumbList","@id":"https:\/\/amis.misa.vn\/164997\/cac-phim-tat-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/amis.misa.vn\/"},{"@type":"ListItem","position":2,"name":"T\u1ed5ng H\u1ee3p C\u00e1c Ph\u00edm T\u1eaft Excel H\u1eefu \u00cdch Cho Ng\u01b0\u1eddi L\u00e0m K\u1ebf To\u00e1n"}]},{"@type":"Person","@id":"https:\/\/amis.misa.vn\/#\/schema\/person\/8efa885b11f0dd252d609df07bdcb0f1","name":"ACT. K-0014 DTTLinh","url":"https:\/\/amis.misa.vn\/"}]}},"yasr_visitor_votes":{"stars_attributes":{"read_only":false,"span_bottom":false},"number_of_votes":0,"sum_votes":0},"_links":{"self":[{"href":"https:\/\/amis.misa.vn\/wp-json\/wp\/v2\/posts\/164997"}],"collection":[{"href":"https:\/\/amis.misa.vn\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/amis.misa.vn\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/amis.misa.vn\/wp-json\/wp\/v2\/users\/163"}],"replies":[{"embeddable":true,"href":"https:\/\/amis.misa.vn\/wp-json\/wp\/v2\/comments?post=164997"}],"version-history":[{"count":3,"href":"https:\/\/amis.misa.vn\/wp-json\/wp\/v2\/posts\/164997\/revisions"}],"predecessor-version":[{"id":165047,"href":"https:\/\/amis.misa.vn\/wp-json\/wp\/v2\/posts\/164997\/revisions\/165047"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/amis.misa.vn\/wp-json\/wp\/v2\/media\/165029"}],"wp:attachment":[{"href":"https:\/\/amis.misa.vn\/wp-json\/wp\/v2\/media?parent=164997"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/amis.misa.vn\/wp-json\/wp\/v2\/categories?post=164997"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/amis.misa.vn\/wp-json\/wp\/v2\/tags?post=164997"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}