{"id":1497,"date":"2022-07-06T12:30:54","date_gmt":"2022-07-06T05:30:54","guid":{"rendered":"https:\/\/dt-corp.com.vn\/?p=1497"},"modified":"2022-07-06T12:30:54","modified_gmt":"2022-07-06T05:30:54","slug":"13-thu-thuat-excel-co-ban-dan-van-phong-ke-toan-nen-biet-qua","status":"publish","type":"post","link":"https:\/\/dt-corp.com.vn\/?p=1497","title":{"rendered":"13 th\u1ee7 thu\u1eadt Excel c\u01a1 b\u1ea3n d\u00e2n v\u0103n ph\u00f2ng, k\u1ebf to\u00e1n n\u00ean bi\u1ebft qua"},"content":{"rendered":"<h3>Excel lu\u00f4n l\u00e0 1 c\u00f4ng c\u1ee5 tuy\u1ec7t v\u1eddi d\u00e0nh cho d\u00e2n v\u0103n ph\u00f2ng v\u00e0 vi\u1ec7c bi\u1ebft \u0111\u01b0\u1ee3c nh\u1eefng th\u1ee7 thu\u1eadt c\u01a1 b\u1ea3n \u0111\u1ec3 s\u1eed d\u1ee5ng Excel th\u00e0nh th\u1ea1o v\u00e0 chuy\u00ean nghi\u1ec7p nh\u1ea5t l\u00e0 1 \u0111i\u1ec1u kh\u00f4ng th\u1ec3 thi\u1ebfu. H\u00e3y theo d\u00f5i b\u00e0i vi\u1ebft sau \u0111\u00e2y \u0111\u1ec3 bi\u1ebft th\u00eam v\u1ec1 c\u00e1c th\u1ee7 thu\u1eadt \u0111\u00f3 nh\u00e9.<\/h3>\n<div class=\"infobox\">\n<p>B\u00e0i vi\u1ebft \u0111\u01b0\u1ee3c th\u1ef1c hi\u1ec7n tr\u00ean\u00a0<a title=\"m\u00e1y t\u00ednh\" href=\"https:\/\/www.thegioididong.com\/laptop\" target=\"_blank\" rel=\"dofollow noopener\" data-cke-saved-href=\"https:\/\/www.thegioididong.com\/laptop\">m\u00e1y t\u00ednh<\/a>\u00a0h\u1ec7 \u0111i\u1ec1u h\u00e0nh Windows v\u1edbi phi\u00ean b\u1ea3n Excel 2016, ngo\u00e0i ra c\u0169ng c\u00f3 th\u1ec3 th\u1ef1c hi\u1ec7n tr\u00ean c\u00e1c phi\u00ean b\u1ea3n Excel 2003, 2007, 2010, 2013 v\u00e0 tr\u00ean MacOS v\u1edbi thao t\u00e1c t\u01b0\u01a1ng t\u1ef1.<\/p>\n<\/div>\n<h3 id=\"hmenuid1\"><strong>1. M\u1edf nhi\u1ec1u b\u1ea3ng t\u00ednh Excel c\u00f9ng l\u00fac<\/strong><\/h3>\n<p><strong>V\u1ea5n \u0111\u1ec1:<\/strong>\u00a0Trong l\u00fac l\u00e0m vi\u1ec7c ch\u1eafc h\u1eb3n s\u1ebd c\u00f3 nhi\u1ec1u trang t\u00ednh b\u1ea1n c\u1ea7n ph\u1ea3i m\u1edf c\u00f9ng l\u00fac \u0111\u1ec3 c\u00f3 th\u1ec3 \u0111\u1ed1i chi\u1ebfu th\u00f4ng tin qua l\u1ea1i.<\/p>\n<p><strong>Gi\u1ea3i ph\u00e1p:<\/strong>\u00a0B\u1ea1n nh\u1ea5n<strong>\u00a0gi\u1eef Ctrl<\/strong>\u00a0v\u00e0\u00a0<strong>ch\u1ecdn nh\u1eefng file Excel<\/strong>\u00a0mu\u1ed1n m\u1edf &gt; Nh\u1ea5n\u00a0<strong>Enter.<\/strong><\/p>\n<h3 id=\"hmenuid2\"><strong>2. Xem th\u1ed1ng k\u00ea c\u1ef1c nhanh<\/strong><\/h3>\n<p><strong>L\u01b0u \u00fd:<\/strong>\u00a0\u0110\u1ed1i v\u1edbi T\u1ed5ng (<a title=\"Sum\" href=\"https:\/\/www.thegioididong.com\/game-app\/5-cach-tinh-tong-trong-excel-nhanh-nhat-don-gian-ai-cung-lam-1301651\" target=\"_blank\" rel=\"dofollow noopener\" data-cke-saved-href=\"https:\/\/www.thegioididong.com\/game-app\/5-cach-tinh-tong-trong-excel-nhanh-nhat-don-gian-ai-cung-lam-1301651\">Sum<\/a>), Trung b\u00ecnh (<a title=\"Average\" href=\"https:\/\/www.thegioididong.com\/game-app\/cach-su-dung-ham-average-trong-excel-co-bai-tap-kem-1331946\" target=\"_blank\" rel=\"dofollow noopener\" data-cke-saved-href=\"https:\/\/www.thegioididong.com\/game-app\/cach-su-dung-ham-average-trong-excel-co-bai-tap-kem-1331946\">Average<\/a>),\u00a0<a title=\"Min\" href=\"https:\/\/www.thegioididong.com\/game-app\/cach-su-dung-ham-min-trong-excel-tinh-gia-tri-nho-nhat-cuc-1335724\" target=\"_blank\" rel=\"dofollow noopener\" data-cke-saved-href=\"https:\/\/www.thegioididong.com\/game-app\/cach-su-dung-ham-min-trong-excel-tinh-gia-tri-nho-nhat-cuc-1335724\">Min<\/a>\u00a0v\u00e0\u00a0<a title=\"Max\" href=\"https:\/\/www.thegioididong.com\/game-app\/cach-su-dung-ham-max-trong-excel-tinh-gia-tri-lon-nhat-cuc-1336343\" target=\"_blank\" rel=\"dofollow noopener\" data-cke-saved-href=\"https:\/\/www.thegioididong.com\/game-app\/cach-su-dung-ham-max-trong-excel-tinh-gia-tri-lon-nhat-cuc-1336343\">Max<\/a>\u00a0th\u00ec ch\u1ec9 hi\u1ec3n th\u1ecb \u0111\u00fang \u0111\u1ed1i v\u1edbi d\u1eef li\u1ec7u d\u1ea1ng s\u1ed1.<\/p>\n<p>Excel c\u0169ng gi\u00fap b\u1ea1n xem\u00a0<a title=\"th\u1ed1ng k\u00ea\" href=\"https:\/\/www.thegioididong.com\/game-app\/tong-hop-cac-ham-thong-ke-trong-excel-cuc-chi-tiet-co-bai-tap-1353538\" target=\"_blank\" rel=\"dofollow noopener\" data-cke-saved-href=\"https:\/\/www.thegioididong.com\/game-app\/tong-hop-cac-ham-thong-ke-trong-excel-cuc-chi-tiet-co-bai-tap-1353538\">th\u1ed1ng k\u00ea<\/a>\u00a0c\u00e1c d\u1eef li\u1ec7u c\u1ef1c nhanh nh\u01b0 sau:<\/p>\n<p><strong>Qu\u00e9t to\u00e0n b\u1ed9 c\u1ed9t<\/strong>\u00a0b\u1ea1n mu\u1ed1n xem v\u00e0 Excel s\u1ebd th\u1ed1ng k\u00ea cho b\u1ea1n<\/p>\n<p><strong>Trong \u0111\u00f3:<\/strong><\/p>\n<ul>\n<li><strong>Average:<\/strong>\u00a0S\u1ed1 trung b\u00ecnh c\u1ee7a c\u00e1c d\u1eef li\u1ec7u s\u1ed1.<\/li>\n<li><strong>Count:\u00a0<\/strong>\u0110\u1ebfm t\u1ed5ng s\u1ed1 \u00f4 b\u1ea1n \u0111\u00e3 qu\u00e9t.<\/li>\n<li><strong>Sum:\u00a0<\/strong>T\u1ed5ng c\u1ee7a d\u1eef li\u1ec7u s\u1ed1 b\u1ea1n \u0111\u00e3 nh\u1eadp.<\/li>\n<li><strong>Numercial Count:<\/strong>\u00a0\u0110\u1ebfm c\u00e1c \u00f4 c\u00f3 ch\u1ee9a d\u1eef li\u1ec7u trong \u0111\u00f3.<\/li>\n<li><strong>Min:\u00a0<\/strong>Gi\u00e1 tr\u1ecb nh\u1ecf nh\u1ea5t.<\/li>\n<li><strong>Max:\u00a0<\/strong>Gi\u00e1 tr\u1ecb l\u1edbn nh\u1ea5t.<\/li>\n<\/ul>\n<h3 id=\"hmenuid3\"><strong>3. Hi\u1ec3n th\u1ecb c\u00f4ng th\u1ee9c si\u00eau nhanh<\/strong><\/h3>\n<p><strong>V\u1ea5n \u0111\u1ec1<\/strong>: Mu\u1ed1n ki\u1ec3m tra c\u00f4ng th\u1ee9c nh\u01b0ng l\u1ea1i c\u00f3 qu\u00e1 nhi\u1ec1u d\u1eef li\u1ec7u v\u00e0 kh\u00f4ng th\u1ec3 ki\u1ec3m tra t\u1eebng c\u00e1i 1.<\/p>\n<p><strong>Gi\u1ea3i ph\u00e1p:<\/strong>\u00a0Ch\u1ec9 c\u1ea7n nh\u1ea5n t\u1ed5 h\u1ee3p ph\u00edm\u00a0<strong>Ctrl + ~<\/strong>\u00a0l\u00e0 b\u1ea1n c\u00f3 th\u1ec3 xem c\u00e1c c\u00f4ng th\u1ee9c c\u1ef1c nhanh.<\/p>\n<h3 id=\"hmenuid4\"><strong>4. T\u1ef1 \u0111\u1ed9ng nh\u1eadp d\u1eef li\u1ec7u<\/strong><\/h3>\n<p><strong>V\u1ea5n \u0111\u1ec1:<\/strong>\u00a0Ph\u1ea3i nh\u1eadp th\u1ee7 c\u00f4ng t\u1eebng d\u1eef li\u1ec7u gi\u1ed1ng nhau v\u00e0o c\u00e1c \u00f4 trong Excel.<\/p>\n<p><strong>Gi\u1ea3i ph\u00e1p:<\/strong>\u00a0B\u1ea1n ch\u1ec9 c\u1ea7n nh\u1eadp d\u1eef li\u1ec7u \u0111\u00f3 1 l\u1ea7n sau \u0111\u00f3\u00a0<strong>nh\u1ea5n gi\u1eef \u00f4 vu\u00f4ng nh\u1ecf g\u00f3c ph\u1ea3i<\/strong>\u00a0c\u1ee7a \u00f4 \u0111\u00f3 v\u00e0\u00a0<strong>k\u00e9o xu\u1ed1ng.<\/strong><\/p>\n<h3 id=\"hmenuid5\"><strong>5. Nh\u1eadp ng\u00e0y th\u00e1ng c\u1ef1c nhanh th\u00f4ng qua ph\u00edm t\u1eaft<\/strong><\/h3>\n<p><strong>V\u1ea5n \u0111\u1ec1:<\/strong>\u00a0C\u1ed9t ng\u00e0y th\u00e1ng ph\u1ea3i nh\u00ecn xu\u1ed1ng \u0111\u1ed3ng h\u1ed3 g\u00f3c ph\u1ea3i ph\u00eda d\u01b0\u1edbi m\u00e0n h\u00ecnh v\u00e0 nh\u1eadp t\u1eebng ng\u00e0y th\u1ee7 c\u00f4ng ho\u1eb7c ph\u1ea3i s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c.<\/p>\n<p><strong>Gi\u1ea3i ph\u00e1p:<\/strong>\u00a0B\u1ea1n ch\u1ec9 c\u1ea7n\u00a0<strong>qu\u00e9t c\u00e1c \u00f4 c\u1ea7n nh\u1eadp<\/strong>\u00a0&gt; Nh\u1ea5n t\u1ed5 h\u1ee3p ph\u00edm\u00a0<strong>Ctrl<\/strong>\u00a0+\u00a0<strong>;<\/strong><\/p>\n<h3 id=\"hmenuid6\"><strong>6. T\u1ef1 \u0111\u1ed9ng t\u00ednh t\u1ed5ng kh\u00f4ng c\u1ea7n d\u00f9ng h\u00e0m =Sum<\/strong><\/h3>\n<p>C\u00f3 th\u1ec3 b\u1ea1n \u0111\u00e3 bi\u1ebft \u0111\u1ebfn h\u00e0m\u00a0<strong>=Sum<\/strong>\u00a0\u0111\u1ec3 t\u00ednh t\u1ed5ng trong Excel, th\u1ec3 nh\u01b0ng c\u00f3 1 c\u00e1ch t\u00ednh t\u1ed5ng c\u1ef1c k\u1ef3 nhanh n\u1eefa m\u00e0 b\u1ea1n n\u00ean bi\u1ebft!<\/p>\n<p>B\u1ea1n ch\u1ec9 c\u1ea7n\u00a0<strong>qu\u00e9t to\u00e0n b\u1ed9 c\u1ed9t<\/strong>\u00a0b\u1ea1n<strong>\u00a0mu\u1ed1n t\u00ednh t\u1ed5ng<\/strong>\u00a0&gt; Nh\u1ea5n t\u1ed5 h\u1ee3p ph\u00edm\u00a0<strong>Alt + =<\/strong><\/p>\n<h3 id=\"hmenuid7\"><strong>7. \u0110\u1ed5i c\u1ed9t th\u00e0nh d\u00f2ng v\u00e0 \u0111\u1ed5i d\u00f2ng th\u00e0nh c\u1ed9t<\/strong><\/h3>\n<p><strong>V\u1ea5n \u0111\u1ec1:<\/strong>\u00a0Kh\u00f4ng th\u1ec3 \u0111\u1ed5i \u0111\u01b0\u1ee3c ti\u00eau \u0111\u1ec1 \u1edf d\u00f2ng th\u00e0nh c\u1ed9t 1 l\u1ea7n m\u00e0 ph\u1ea3i \u0111\u1ed5i th\u1ee7 c\u00f4ng t\u1eebng c\u00e1i.<\/p>\n<p><strong>Gi\u1ea3i ph\u00e1p:<\/strong>\u00a0B\u1ea1n ch\u1ec9 c\u1ea7n th\u1ef1c hi\u1ec7n nh\u01b0 sau:<\/p>\n<p><strong>Qu\u00e9t<\/strong>\u00a0ch\u1ecdn\u00a0<strong>to\u00e0n b\u1ed9 b\u1ea3ng d\u1eef li\u1ec7u<\/strong>\u00a0b\u1ea1n mu\u1ed1n thay \u0111\u1ed5i &gt; Nh\u1ea5n\u00a0<strong>chu\u1ed9t ph\u1ea3i<\/strong>\u00a0ch\u1ecdn\u00a0<strong>Copy<\/strong>\u00a0&gt; Ch\u1ecdn\u00a0<strong>1 \u00f4 b\u1ea5t k\u1ef3<\/strong>\u00a0&gt; Nh\u1ea5n\u00a0<strong>chu\u1ed9t ph\u1ea3i<\/strong>\u00a0ch\u1ecdn\u00a0<strong>Paste Special<\/strong>\u00a0&gt; T\u00edch ch\u1ecdn \u00f4\u00a0<strong>Tranpose<\/strong>.<\/p>\n<h3 id=\"hmenuid8\"><strong>8. \u1ea8n h\u00e0ng v\u00e0 c\u1ed9t theo nh\u00f3m<\/strong><\/h3>\n<p><strong>V\u1ea5n \u0111\u1ec1:<\/strong>\u00a0B\u1ea1n mu\u1ed1n \u1ea9n c\u00e1c c\u1ed9t v\u00e0 h\u00e0ng nh\u01b0ng ch\u1ec9 \u1ea9n \u0111\u01b0\u1ee3c 1 \u00f4 d\u1eef li\u1ec7u tr\u00ean h\u00e0ng v\u00e0 tr\u00ean c\u1ed9t:<\/p>\n<p><strong>Gi\u1ea3i ph\u00e1p:<\/strong>\u00a0B\u1ea1n h\u00e3y th\u1ef1c hi\u1ec7n theo c\u00e1c sau \u0111\u00e2y:<\/p>\n<p><strong>B\u01b0\u1edbc 1:<\/strong>\u00a0Qu\u00e9t ch\u1ecdn to\u00e0n b\u1ed9 d\u00f2ng v\u00e0 c\u1ed9t b\u1ea1n mu\u1ed1n \u1ea9n &gt; Nh\u1ea5n t\u1ed5 h\u1ee3p ph\u00edm\u00a0<strong>Alt + Shift + m\u0169i t\u00ean ph\u1ea3i\u00a0<\/strong>&gt; H\u1ed9p tho\u1ea1i Group hi\u1ec7n l\u00ean ch\u1ecdn nh\u00f3m theo\u00a0<strong>c\u1ed9t (Columns)<\/strong>\u00a0ho\u1eb7c theo\u00a0<strong>d\u00f2ng (Row)<\/strong><\/p>\n<p><img decoding=\"async\" class=\"lazy\" style=\"margin: 15px auto 5px; padding: 0px; border: 0px; display: block; max-width: 100%; height: auto; min-height: 200px;\" title=\"Qu\u00e9t ch\u1ecdn to\u00e0n b\u1ed9 d\u00f2ng v\u00e0 c\u1ed9t b\u1ea1n mu\u1ed1n \u1ea9n &gt; Nh\u1ea5n t\u1ed5 h\u1ee3p ph\u00edm Alt + Shift + m\u0169i t\u00ean ph\u1ea3i\" src=\"https:\/\/cdn.tgdd.vn\/hoi-dap\/1392089\/13-thu-thuat-excel-co-ban-dan-van-phong-ke-toan-nen-biet3-800x450.jpg\" alt=\"Qu\u00e9t ch\u1ecdn to\u00e0n b\u1ed9 d\u00f2ng v\u00e0 c\u1ed9t b\u1ea1n mu\u1ed1n \u1ea9n &gt; Nh\u1ea5n t\u1ed5 h\u1ee3p ph\u00edm Alt + Shift + m\u0169i t\u00ean ph\u1ea3i\" data-cke-saved-src=\"\/\/cdn.tgdd.vn\/hoi-dap\/1392089\/13-thu-thuat-excel-co-ban-dan-van-phong-ke-toan-nen-biet3-800x450.jpg\" data-original=\"\/\/cdn.tgdd.vn\/hoi-dap\/1392089\/13-thu-thuat-excel-co-ban-dan-van-phong-ke-toan-nen-biet3-800x450.jpg\" \/><\/p>\n<p>Qu\u00e9t ch\u1ecdn to\u00e0n b\u1ed9 d\u00f2ng v\u00e0 c\u1ed9t b\u1ea1n mu\u1ed1n \u1ea9n &gt; Nh\u1ea5n t\u1ed5 h\u1ee3p ph\u00edm Alt + Shift + m\u0169i t\u00ean ph\u1ea3i<\/p>\n<p>&nbsp;<\/p>\n<p><strong>B\u01b0\u1edbc 2:<\/strong>\u00a0Tr\u00ean b\u1ea3ng t\u00ednh s\u1ebd xu\u1ea5t hi\u1ec7n nh\u00f3m h\u00e0ng c\u1ed9t, \u0111\u1ec3\u00a0<strong>\u1ea9n d\u1eef li\u1ec7u<\/strong>\u00a0b\u1ea1n ch\u1ec9 c\u1ea7n nh\u1ea5n\u00a0<strong>d\u1ea5u tr\u1eeb &#8220;-&#8220;<\/strong>, \u0111\u1ec3\u00a0<strong>hi\u1ec7n d\u1eef li\u1ec7u<\/strong>\u00a0b\u1ea1n ch\u1ec9 c\u1ea7n nh\u1ea5n<strong>\u00a0d\u1ea5u c\u1ed9ng &#8220;+&#8221;<\/strong>.<\/p>\n<p><img decoding=\"async\" class=\"lazy\" title=\"Tr\u00ean b\u1ea3ng t\u00ednh s\u1ebd xu\u1ea5t hi\u1ec7n nh\u00f3m h\u00e0ng c\u1ed9t, \u0111\u1ec3 \u1ea9n d\u1eef li\u1ec7u b\u1ea1n ch\u1ec9 c\u1ea7n nh\u1ea5n d\u1ea5u tr\u1eeb \" src=\"https:\/\/cdn.tgdd.vn\/hoi-dap\/1392089\/13-thu-thuat-excel-co-ban-dan-van-phong-ke-toan-nen-biet4-800x451.jpg\" alt=\"Tr\u00ean b\u1ea3ng t\u00ednh s\u1ebd xu\u1ea5t hi\u1ec7n nh\u00f3m h\u00e0ng c\u1ed9t, \u0111\u1ec3 \u1ea9n d\u1eef li\u1ec7u b\u1ea1n ch\u1ec9 c\u1ea7n nh\u1ea5n d\u1ea5u tr\u1eeb \" data-original=\"\/\/cdn.tgdd.vn\/hoi-dap\/1392089\/13-thu-thuat-excel-co-ban-dan-van-phong-ke-toan-nen-biet4-800x451.jpg\" \/><\/p>\n<p>Tr\u00ean b\u1ea3ng t\u00ednh s\u1ebd xu\u1ea5t hi\u1ec7n nh\u00f3m h\u00e0ng c\u1ed9t, \u0111\u1ec3 \u1ea9n d\u1eef li\u1ec7u b\u1ea1n ch\u1ec9 c\u1ea7n nh\u1ea5n d\u1ea5u tr\u1eeb<\/p>\n<p>&nbsp;<\/p>\n<p><strong>B\u01b0\u1edbc 2:\u00a0<\/strong>\u0110\u1ec3\u00a0<strong>hi\u1ec7n d\u1eef li\u1ec7u<\/strong>\u00a0b\u1ea1n ch\u1ec9 c\u1ea7n nh\u1ea5n<strong>\u00a0d\u1ea5u c\u1ed9ng &#8220;+&#8221;<\/strong>.<\/p>\n<p><img decoding=\"async\" class=\"lazy\" title=\"\u0110\u1ec3 hi\u1ec7n d\u1eef li\u1ec7u b\u1ea1n ch\u1ec9 c\u1ea7n nh\u1ea5n d\u1ea5u c\u1ed9ng \" src=\"https:\/\/cdn.tgdd.vn\/hoi-dap\/1392089\/13-thu-thuat-excel-co-ban-dan-van-phong-ke-toan-nen-biet5-800x450.jpg\" alt=\"\u0110\u1ec3 hi\u1ec7n d\u1eef li\u1ec7u b\u1ea1n ch\u1ec9 c\u1ea7n nh\u1ea5n d\u1ea5u c\u1ed9ng \" data-original=\"\/\/cdn.tgdd.vn\/hoi-dap\/1392089\/13-thu-thuat-excel-co-ban-dan-van-phong-ke-toan-nen-biet5-800x450.jpg\" \/><\/p>\n<p>\u0110\u1ec3 hi\u1ec7n d\u1eef li\u1ec7u b\u1ea1n ch\u1ec9 c\u1ea7n nh\u1ea5n d\u1ea5u c\u1ed9ng<\/p>\n<h3 id=\"hmenuid9\"><strong>9. C\u1ed1 \u0111\u1ecbnh d\u00f2ng ti\u00eau \u0111\u1ec1, c\u1ed9t ti\u00eau \u0111\u1ec1<\/strong><\/h3>\n<p><strong>V\u1ea5n \u0111\u1ec1:<\/strong>\u00a0B\u1ea1n \u0111ang l\u00e0m vi\u1ec7c v\u1edbi nhi\u1ec1u d\u1eef li\u1ec7u v\u00e0 khi k\u00e9o xu\u1ed1ng nh\u1eefng \u00f4 b\u00ean d\u01b0\u1edbi \u0111\u1ec3 \u0111i\u1ec1n d\u1eef li\u1ec7u th\u00ec l\u1ea1i b\u1ecb m\u1ea5t thanh Ti\u00eau \u0111\u1ec1 v\u00e0 kh\u00f4ng bi\u1ebft ph\u1ea3i \u0111i\u1ec1n v\u00e0o \u0111\u00e2u.<\/p>\n<p><strong>Gi\u1ea3i ph\u00e1p:<\/strong>\u00a0B\u1ea1n \u0111\u1eebng lo h\u00e3y s\u1eed d\u1ee5ng c\u00f4ng c\u1ee5\u00a0<strong>Frezze Panes<\/strong>\u00a0\u0111\u1ec3 gi\u1ea3i quy\u1ebft vi\u1ec7c n\u00e0y!<\/p>\n<p>\u0110\u1ec3\u00a0<strong>c\u1ed1 \u0111\u1ecbnh d\u00f2ng ti\u00eau \u0111\u1ec1<\/strong>\u00a0c\u1ee7a b\u1ea3ng t\u00ednh th\u00ec b\u1ea1n h\u00e3y v\u00e0o th\u1ebb\u00a0<strong>View<\/strong>\u00a0&gt; ch\u1ecdn\u00a0<strong>Freeze Top Row.<\/strong><\/p>\n<p><img decoding=\"async\" class=\"lazy\" style=\"margin: 15px auto 5px; padding: 0px; border: 0px; display: block; max-width: 100%; height: auto; min-height: 200px;\" title=\"V\u00e0o th\u1ebb View &gt; ch\u1ecdn Freeze Top Row\" src=\"https:\/\/cdn.tgdd.vn\/hoi-dap\/1392089\/13-thu-thuat-excel-co-ban-dan-van-phong-ke-toan-nen-biet2-800x450.jpg\" alt=\"V\u00e0o th\u1ebb View &gt; ch\u1ecdn Freeze Top Row\" data-cke-saved-src=\"\/\/cdn.tgdd.vn\/hoi-dap\/1392089\/13-thu-thuat-excel-co-ban-dan-van-phong-ke-toan-nen-biet2-800x450.jpg\" data-original=\"\/\/cdn.tgdd.vn\/hoi-dap\/1392089\/13-thu-thuat-excel-co-ban-dan-van-phong-ke-toan-nen-biet2-800x450.jpg\" \/><\/p>\n<p>V\u00e0o th\u1ebb View &gt; ch\u1ecdn Freeze Top Row<\/p>\n<p>&nbsp;<\/p>\n<p>\u0110\u1ec3\u00a0<strong>c\u1ed1 \u0111\u1ecbnh c\u1ed9t ti\u00eau \u0111\u1ec1<\/strong>\u00a0b\u1ea1n h\u00e3y v\u00e0o th\u1ebb\u00a0<strong>View<\/strong>\u00a0&gt; Ch\u1ecdn\u00a0<strong>Freeze First Columns.<\/strong><\/p>\n<p><img decoding=\"async\" class=\"lazy\" style=\"margin: 15px auto 5px; padding: 0px; border: 0px; display: block; max-width: 100%; height: auto; min-height: 200px;\" title=\"V\u00e0o th\u1ebb View &gt; Ch\u1ecdn Freeze First Columns\" src=\"https:\/\/cdn.tgdd.vn\/hoi-dap\/1392089\/13-thu-thuat-excel-co-ban-dan-van-phong-ke-toan-nen-biet1-800x450.jpg\" alt=\"V\u00e0o th\u1ebb View &gt; Ch\u1ecdn Freeze First Columns\" data-cke-saved-src=\"\/\/cdn.tgdd.vn\/hoi-dap\/1392089\/13-thu-thuat-excel-co-ban-dan-van-phong-ke-toan-nen-biet1-800x450.jpg\" data-original=\"\/\/cdn.tgdd.vn\/hoi-dap\/1392089\/13-thu-thuat-excel-co-ban-dan-van-phong-ke-toan-nen-biet1-800x450.jpg\" \/><\/p>\n<p>V\u00e0o th\u1ebb View &gt; Ch\u1ecdn Freeze First Columns<\/p>\n<h3 id=\"hmenuid10\"><strong>10. Sao ch\u00e9p d\u1eef li\u1ec7u nhanh ch\u00f3ng<\/strong><\/h3>\n<p>\u0110\u1ec3\u00a0<strong>sao ch\u00e9p d\u1eef li\u1ec7u<\/strong>\u00a0nhanh ch\u00f3ng ch\u1ec9 v\u1edbi\u00a0<strong>4 thao t\u00e1c<\/strong>\u00a0b\u1ea1n h\u00e3y th\u1ef1c hi\u1ec7n nh\u01b0 sau nh\u00e9:<\/p>\n<p>Qu\u00e9t to\u00e0n b\u1ed9 d\u1eef li\u1ec7u c\u1ea7n sao ch\u00e9p &gt; Nh\u1ea5n t\u1ed5 h\u1ee3p ph\u00edm\u00a0<strong>Ctrl + C\u00a0<\/strong>&gt; Ch\u1ecdn \u00f4 c\u1ea7n d\u00e1n &gt; Nh\u1ea5n\u00a0<strong>Ctrl + V<\/strong>.<\/p>\n<h3 id=\"hmenuid11\"><strong>11. In 1 v\u00f9ng t\u00f9y ch\u1ecdn trong Excel<\/strong><\/h3>\n<p><strong>V\u1ea5n \u0111\u1ec1:<\/strong>\u00a0B\u1ea1n ch\u1ec9 mu\u1ed1n in 1 ph\u1ea7n trong c\u00e1c d\u1eef li\u1ec7u c\u1ee7a file Excel nh\u01b0ng khi in th\u00ec l\u1ea1i hi\u1ec3n th\u1ecb h\u1ebft c\u1ea3 trang t\u00ednh.<\/p>\n<p><strong>Gi\u1ea3i ph\u00e1p:<\/strong>\u00a0B\u1ea1n h\u00e3y l\u00e0m theo c\u00e1ch sau \u0111\u00e2y:<\/p>\n<p><strong>B\u01b0\u1edbc 1: Ch\u1ecdn v\u00f9ng in.<\/strong><\/p>\n<p>C\u00e1c b\u1ea1n ch\u1ecdn v\u00f9ng in b\u1eb1ng c\u00e1ch b\u00f4i \u0111en v\u00f9ng c\u1ea7n in.<\/p>\n<p><img decoding=\"async\" class=\"lazy\" title=\"Ch\u1ecdn v\u00f9ng in b\u1eb1ng c\u00e1ch b\u00f4i \u0111en v\u00f9ng c\u1ea7n in\" src=\"https:\/\/cdn.tgdd.vn\/hoi-dap\/1392089\/13-thu-thuat-excel-co-ban-dan-van-phong-ke-toan-nen-biet6-800x450.jpg\" alt=\"Ch\u1ecdn v\u00f9ng in b\u1eb1ng c\u00e1ch b\u00f4i \u0111en v\u00f9ng c\u1ea7n in\" data-original=\"\/\/cdn.tgdd.vn\/hoi-dap\/1392089\/13-thu-thuat-excel-co-ban-dan-van-phong-ke-toan-nen-biet6-800x450.jpg\" data-cke-saved-src=\"\/\/cdn.tgdd.vn\/hoi-dap\/1392089\/13-thu-thuat-excel-co-ban-dan-van-phong-ke-toan-nen-biet6-800x450.jpg\" \/><\/p>\n<p>Ch\u1ecdn v\u00f9ng in b\u1eb1ng c\u00e1ch b\u00f4i \u0111en v\u00f9ng c\u1ea7n in<\/p>\n<p>&nbsp;<\/p>\n<p><strong>B\u01b0\u1edbc 2: \u0110\u1eb7t v\u00f9ng in<\/strong><\/p>\n<p>\u0110\u1ec3 in \u0111\u01b0\u1ee3c v\u00f9ng \u0111\u00e3 ch\u1ecdn \u1edf\u00a0<strong>B\u01b0\u1edbc 1<\/strong>\u00a0ch\u00fang ra s\u1ebd ph\u1ea3i \u0111\u1eb7t v\u00f9ng in nh\u01b0 sau: V\u00e0o<strong>\u00a0Page layout &gt; Print Aria<\/strong>\u00a0&gt;<strong>\u00a0Set Print Aria.<\/strong><\/p>\n<p><img decoding=\"async\" class=\"lazy\" style=\"margin: 15px auto 5px; padding: 0px; border: 0px; display: block; max-width: 100%; height: auto; min-height: 200px;\" title=\"V\u00e0o Page layout &gt; Print Aria &gt; Set Print Aria\" src=\"https:\/\/cdn.tgdd.vn\/hoi-dap\/1392089\/13-thu-thuat-excel-co-ban-dan-van-phong-ke-toan-nen-biet7-800x450.jpg\" alt=\"V\u00e0o Page layout &gt; Print Aria &gt; Set Print Aria\" data-cke-saved-src=\"\/\/cdn.tgdd.vn\/hoi-dap\/1392089\/13-thu-thuat-excel-co-ban-dan-van-phong-ke-toan-nen-biet7-800x450.jpg\" data-original=\"\/\/cdn.tgdd.vn\/hoi-dap\/1392089\/13-thu-thuat-excel-co-ban-dan-van-phong-ke-toan-nen-biet7-800x450.jpg\" \/><\/p>\n<p>V\u00e0o Page layout &gt; Print Aria &gt; Set Print Aria<\/p>\n<p>&nbsp;<\/p>\n<p><strong>B\u01b0\u1edbc 3: In v\u00f9ng \u0111\u00e3 ch\u1ecdn<\/strong><\/p>\n<p>Sau khi \u0111\u1eb7t v\u00f9ng in ch\u00fang ra ti\u1ebfn h\u00e0nh in nh\u01b0 b\u00ecnh th\u01b0\u1eddng, c\u00e1c b\u1ea1n c\u00f3 th\u1ec3 c\u0103n ch\u1ec9nh nh\u01b0 in c\u00e1c v\u0103n b\u1ea3n kh\u00e1c tr\u01b0\u1edbc khi in n\u1ebfu c\u1ea7n.<\/p>\n<h3 id=\"hmenuid12\"><strong>12. Chuy\u1ec3n \u0111\u1ed5i qua l\u1ea1i gi\u1eefa c\u00e1c Tab, c\u00e1c Sheet l\u00e0m vi\u1ec7c<\/strong><\/h3>\n<p><strong>V\u1ea5n \u0111\u1ec1:<\/strong>\u00a0B\u1ea1n \u0111ang l\u00e0m vi\u1ec7c tr\u00ean 1 trang t\u00ednh v\u00e0 mu\u1ed1n chuy\u1ec3n qua trang t\u00ednh kh\u00e1c nh\u01b0ng n\u1ebfu d\u00f9ng chu\u1ed9t th\u00ec s\u1ebd l\u00e2u.<\/p>\n<p><strong>Gi\u1ea3i ph\u00e1p:<\/strong>\u00a0B\u1ea1n h\u00e3y s\u1eed d\u1ee5ng 2 t\u1ed5 h\u1ee3p ph\u00edm t\u1eaft\u00a0<strong>Ctrl<\/strong>\u00a0+\u00a0<strong>Pg Up<\/strong>\u00a0v\u00e0\u00a0<strong>Ctrl<\/strong>\u00a0+\u00a0<strong>Pg Down<\/strong><\/p>\n<h3 id=\"hmenuid13\"><strong>13. \u0110\u1ecbnh h\u01b0\u1edbng \u0111\u01b0\u1ee3c con tr\u1ecf khi nh\u1ea5n Enter<\/strong><\/h3>\n<p><strong>V\u1ea5n \u0111\u1ec1:<\/strong>\u00a0B\u1ea1n \u0111ang nh\u1eadp d\u1eef li\u1ec7u v\u00e0 khi nh\u1ea5n Enter th\u00ec con tr\u1ecf chu\u1ed9t s\u1ebd di chuy\u1ec3n l\u00ean xu\u1ed1ng gi\u1eefa c\u00e1c \u00f4 kh\u00e1c. Nh\u01b0ng b\u1ea1n mu\u1ed1n con tr\u1ecf chu\u1ed9t s\u1ebd nh\u1ea3y sang tr\u00e1i ph\u1ea3i \u0111\u1ec3 ti\u1ec7n cho vi\u1ec7c nh\u1eadp d\u1eef li\u1ec7u d\u1ea1ng ngang.<\/p>\n<p><strong>Gi\u1ea3i ph\u00e1p:<\/strong>\u00a0B\u1ea1n h\u00e3y th\u1ef1c hi\u1ec7n theo c\u00e1ch sau:<\/p>\n<p><strong>B\u01b0\u1edbc 1:<\/strong>\u00a0Nh\u1ea5n v\u00e0o th\u1ebb\u00a0<strong>File.<\/strong><\/p>\n<p><img decoding=\"async\" class=\"lazy\" title=\"Nh\u1ea5n v\u00e0o File\" src=\"https:\/\/cdn.tgdd.vn\/hoi-dap\/1392089\/13-thu-thuat-excel-co-ban-dan-van-phong-ke-toan-nen-biet8-800x450.jpg\" alt=\"Nh\u1ea5n v\u00e0o File\" data-original=\"\/\/cdn.tgdd.vn\/hoi-dap\/1392089\/13-thu-thuat-excel-co-ban-dan-van-phong-ke-toan-nen-biet8-800x450.jpg\" data-cke-saved-src=\"\/\/cdn.tgdd.vn\/hoi-dap\/1392089\/13-thu-thuat-excel-co-ban-dan-van-phong-ke-toan-nen-biet8-800x450.jpg\" \/><\/p>\n<p>Nh\u1ea5n v\u00e0o File<\/p>\n<p>&nbsp;<\/p>\n<p><strong>B\u01b0\u1edbc 2:\u00a0<\/strong>Ch\u1ecdn<strong>\u00a0Options.<\/strong><\/p>\n<p><img decoding=\"async\" class=\"lazy\" title=\"Ch\u1ecdn Options\" src=\"https:\/\/cdn.tgdd.vn\/hoi-dap\/1392089\/13-thu-thuat-excel-co-ban-dan-van-phong-ke-toan-nen-biet9-800x450.jpg\" alt=\"Ch\u1ecdn Options\" data-original=\"\/\/cdn.tgdd.vn\/hoi-dap\/1392089\/13-thu-thuat-excel-co-ban-dan-van-phong-ke-toan-nen-biet9-800x450.jpg\" data-cke-saved-src=\"\/\/cdn.tgdd.vn\/hoi-dap\/1392089\/13-thu-thuat-excel-co-ban-dan-van-phong-ke-toan-nen-biet9-800x450.jpg\" \/><\/p>\n<p>Ch\u1ecdn Options<\/p>\n<p>&nbsp;<\/p>\n<p><strong>B\u01b0\u1edbc 3:<\/strong>\u00a0Ch\u1ecdn m\u1ee5c\u00a0<strong>Advanced<\/strong>\u00a0&gt; ch\u1ecdn\u00a0<strong>After Pressing Enter<\/strong>\u00a0<strong>move Selection<\/strong>\u00a0&gt; \u1edf ph\u1ea7n\u00a0<strong>Direction<\/strong>\u00a0ch\u1ecdn<strong>\u00a0v\u1ecb tr\u00ed con tr\u1ecf chu\u1ed9t.<\/strong><\/p>\n<p><img decoding=\"async\" class=\"lazy\" title=\"Ch\u1ecdn m\u1ee5c Advanced\" src=\"https:\/\/cdn.tgdd.vn\/hoi-dap\/1392089\/13-thu-thuat-excel-co-ban-dan-van-phong-ke-toan-nen-biet10-800x450.jpg\" alt=\"Ch\u1ecdn m\u1ee5c Advanced\" data-original=\"\/\/cdn.tgdd.vn\/hoi-dap\/1392089\/13-thu-thuat-excel-co-ban-dan-van-phong-ke-toan-nen-biet10-800x450.jpg\" data-cke-saved-src=\"\/\/cdn.tgdd.vn\/hoi-dap\/1392089\/13-thu-thuat-excel-co-ban-dan-van-phong-ke-toan-nen-biet10-800x450.jpg\" \/><\/p>\n<p>Ch\u1ecdn m\u1ee5c Advanced<\/p>\n<p>&nbsp;<\/p>\n<p><em>\u0110\u00f3 l\u00e0 nh\u1eefng th\u1ee7 thu\u1eadt c\u01a1 b\u1ea3n trong Excel c\u1ef1c k\u1ef3 h\u1eefu d\u1ee5ng m\u00e0 d\u00e2n v\u0103n ph\u00f2ng n\u00ean bi\u1ebft \u0111\u1ec3 c\u00f3 th\u1ec3 thao t\u00e1c nhanh v\u00e0 chuy\u00ean nghi\u1ec7p trong c\u00f4ng vi\u1ec7c, b\u1ea1n h\u00e3y tham kh\u1ea3o nh\u00e9. Ngo\u00e0i ra n\u1ebfu c\u00f3 th\u1eafc m\u1eafc g\u00ec b\u1ea1n h\u00e3y \u0111\u1ec3 l\u1ea1i b\u00ecnh lu\u1eadn b\u00ean d\u01b0\u1edbi, c\u00f2n n\u1ebfu th\u1ea5y hay h\u00e3y chia s\u1ebb cho m\u1ecdi ng\u01b0\u1eddi c\u00f9ng xem nh\u00e9. Ch\u00fac b\u1ea1n th\u00e0nh c\u00f4ng!!!<\/em><\/p>\n<p>Theo: <a href=\"https:\/\/www.thegioididong.com\/hoi-dap\/13-thu-thuat-excel-co-ban-dan-van-phong-ke-toan-nen-biet-1392089#hmenuid11\">Th\u1ebf gi\u1edbi di \u0111\u1ed9ng<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p class=\"tx-excerpt\">Excel lu\u00f4n l\u00e0 1 c\u00f4ng c\u1ee5 tuy\u1ec7t v\u1eddi d\u00e0nh cho d\u00e2n v\u0103n ph\u00f2ng v\u00e0 vi\u1ec7c bi\u1ebft \u0111\u01b0\u1ee3c nh\u1eefng th\u1ee7 thu\u1eadt c\u01a1 b\u1ea3n \u0111\u1ec3 s\u1eed d\u1ee5ng Excel th\u00e0nh th\u1ea1o v\u00e0 chuy\u00ean nghi\u1ec7p nh\u1ea5t l\u00e0","protected":false},"author":3,"featured_media":1498,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[13],"tags":[],"class_list":["post-1497","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-blog"],"jetpack_sharing_enabled":true,"jetpack_featured_media_url":"https:\/\/dt-corp.com.vn\/wp-content\/uploads\/2022\/07\/13-thu-thuat-excel-co-ban-dan-van-phong-ke-toan-nen-biet.png","_links":{"self":[{"href":"https:\/\/dt-corp.com.vn\/index.php?rest_route=\/wp\/v2\/posts\/1497","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/dt-corp.com.vn\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/dt-corp.com.vn\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/dt-corp.com.vn\/index.php?rest_route=\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/dt-corp.com.vn\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1497"}],"version-history":[{"count":1,"href":"https:\/\/dt-corp.com.vn\/index.php?rest_route=\/wp\/v2\/posts\/1497\/revisions"}],"predecessor-version":[{"id":1499,"href":"https:\/\/dt-corp.com.vn\/index.php?rest_route=\/wp\/v2\/posts\/1497\/revisions\/1499"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/dt-corp.com.vn\/index.php?rest_route=\/wp\/v2\/media\/1498"}],"wp:attachment":[{"href":"https:\/\/dt-corp.com.vn\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1497"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dt-corp.com.vn\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1497"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dt-corp.com.vn\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1497"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}