{"id":1044,"date":"2012-07-20T10:00:48","date_gmt":"2012-07-20T10:00:48","guid":{"rendered":"http:\/\/congnghepc.com\/2012\/07\/20\/vai-thu-thuat-nho-khi-lam-viec-voi-excel\/"},"modified":"2012-07-20T10:00:48","modified_gmt":"2012-07-20T10:00:48","slug":"vai-thu-thuat-nho-khi-lam-viec-voi-excel","status":"publish","type":"post","link":"https:\/\/tapchicntt.com\/vai-thu-thuat-nho-khi-lam-viec-voi-excel\/","title":{"rendered":"V\u00e0i th\u1ee7 thu\u1eadt nh\u1ecf khi l\u00e0m vi\u1ec7c v\u1edbi Excel"},"content":{"rendered":"

\n\tSau \u0111ây xin gi\u1edbi thi\u1ec7u \u0111\u1ebfn b\u1ea1n \u0111\u1ecdc hai th\u1ee7 thu\u1eadt Excel dành cho nh\u01b0ng ai th\u01b0\u1eddng xuyên làm vi\u1ec7c v\u1edbi bi\u1ec3u \u0111\u1ed3 và danh sách dài.<\/p>\n

\n\tT\u1ea1o bi\u1ec3u \u0111\u1ed3 \u0111\u1ed9ng<\/h2>\n

\n\tKhi b\u1ea1n th\u1ef1c hi\u1ec7n t\u1ea1o bi\u1ec3u \u0111\u1ed3ng cho m\u1ed9t dãy s\u1ed1 li\u1ec7u thì m\u1ed7i khi b\u1ea1n thay \u0111\u1ed5i các thông s\u1ed1 trong dãy s\u1ed1 li\u1ec7u này thì l\u1eadp t\u1ee9c bi\u1ec3u \u0111\u1ed3 s\u1ebd t\u1ef1 \u0111\u1ed9ng \u0111i\u1ec1u ch\u1ec9nh \u0111\u1ec3 phù h\u1ee3p v\u1edbi s\u1ed1 li\u1ec7u t\u1ea1i vùng d\u1eef li\u1ec7u \u0111ã ch\u1ecdn. Tuy nhiên trong tr\u01b0\u1eddng h\u1ee3p b\u1ea1n thêm m\u1edbi ho\u1eb7c gi\u1ea3m b\u1edbt vùng d\u1eef li\u1ec7u thì bi\u1ec3u \u0111\u1ed3 s\u1ebd không t\u1ef1 \u0111\u1ed9ng \u0111i\u1ec1u ch\u1ec9nh mà thay vào \u0111ó b\u1ea1n ph\u1ea3i th\u1ef1c hi\u1ec7n l\u1ea1i thao tác t\u1ea1o bi\u1ec3u \u0111\u1ed3 trên vùng d\u1eef li\u1ec7u m\u1edbi.<\/p>\n

\n\tTrong Excel 2007 và Excel 2010 b\u1ea1n có th\u1ec3 d\u1ec5 dàng thi\u1ebft l\u1eadp \u0111\u1ec1 bi\u1ec3u \u0111\u1ed3 t\u1ef1 \u0111\u1ed9ng \u0111i\u1ec1u ch\u1ec9nh. Cách làm nh\u01b0 sau:<\/strong><\/p>\n

\n\tT\u1ea1i trang b\u1ea3ng tính hi\u1ec7n hành, b\u1ea1n ti\u1ebfn hành quét kh\u1ed1i vùng d\u1eef li\u1ec7u \u0111\u1ecbnh t\u1ea1o bi\u1ec3u \u0111\u1ed3.<\/p>\n

\n\t\"V\u00e0i<\/p>\n

\n\tCh\u1ecdn th\u1ebb Insert<\/strong> trên thanh menu, ti\u1ebfp theo ch\u1ecdn bi\u1ec3u t\u01b0\u1ee3ng Table<\/strong> trong nhóm l\u1ec7nh \u0111\u1ea7u tiên.<\/p>\n

\n\t\"V\u00e0i<\/p>\n

\n\tM\u1ed9t c\u1eeda s\u1ed5 nh\u1ecf hi\u1ec7n ra ch\u1ee9a thông tin v\u1ec1 vùng d\u1eef li\u1ec7u b\u1ea1n \u0111ã ch\u1ecdn, B\u1ea5m OK<\/strong> \u0111\u1ec3 l\u01b0u thi\u1ebft l\u1eadp này l\u1ea1i.<\/p>\n

\n\t\"V\u00e0i<\/p>\n

\n\tTi\u1ebfp theo c\u0169ng trên th\u1ebb Insert<\/strong>, l\u1ef1a ch\u1ecdn ki\u1ec3u bi\u1ec3u \u0111\u1ed3 c\u1ea7n hi\u1ec3n th\u1ecb trong nhóm công c\u1ee5 Chart.<\/strong><\/p>\n

\n\t\"V\u00e0i<\/p>\n

\n\tBan \u0111\u1ea7u, Excel s\u1ebd t\u1ea1o ra bi\u1ec3u \u0111\u1ed3 d\u1ef1a trên s\u1ed1 li\u1ec7u c\u1ee7a vùng d\u1eef li\u1ec7u \u0111ã ch\u1ecdn ban \u0111\u1ea7u.<\/p>\n

\n\t\"V\u00e0i<\/p>\n

\n\tTuy nhiên, n\u1ebfu b\u1ea1n thêm m\u1ed9t hàng m\u1edbi li\u1ec1n k\u1ec1 vùng d\u1eef li\u1ec7u b\u1ea1n \u0111\u1ea7u thì l\u1eadp t\u1ee9c bi\u1ec3u \u0111\u1ed3 c\u0169ng s\u1ebd t\u1ef1 \u0111\u1ed9ng \u0111i\u1ec1u ch\u1ec9nh \u0111\u1ec3 thêm các s\u1ed1 li\u1ec7u b\u1ea1n v\u1eeba thêm vào.<\/p>\n

\n\t\"V\u00e0i<\/p>\n

\n\tTô màu xen k\u1ebd các dòng trong b\u1ea3ng tính s\u1ed1 l\u01b0\u1ee3ng l\u1edbn<\/h2>\n

\n\tTrong quá trình s\u1eed d\u1ee5ng Excel \u0111\u1ec3 th\u1ed1ng kê s\u1ed1 li\u1ec7u theo d\u1ea1ng danh sách, \u1eafc h\u1eb3n \u0111a s\u1ed1 ng\u01b0\u1eddi dùng s\u1ebd ch\u1ecdn ph\u01b0\u01a1ng pháp tô màu cho các dòng xen k\u1ebb nhau \u0111\u1ec3 thu\u1eadn ti\u1ec7n trong vi\u1ec7c tra c\u1ee9u, \u0111\u1eb7c bi\u1ec7t là \u0111\u1ed1i v\u1edbi các b\u1ea3ng tính c\u1ea7n ph\u1ea3i in ra gi\u1ea5y. Tuy nhiên n\u1ebfu b\u1ea3ng tính này không ph\u1ea3i do ng\u01b0\u1eddi dùng t\u1ea1o ra mà nó \u0111\u01b0\u1ee3c xu\u1ea5t ra t\u1eeb m\u1ed9t \u1ee9ng d\u1ee5ng nào \u0111ó, b\u1ea1n không th\u1ec3 thao tác tô màu cho các dòng v\u1edbi s\u1ed1 l\u01b0\u1ee3ng l\u1edbn.<\/p>\n

\n\tMay thay trong Excel 2010 có s\u1eb5n tùy ch\u1ecdn \u0111\u1ec3 b\u1ea1n làm vi\u1ec7c này h\u1ebft s\u1ee9c nhanh chóng và \u0111\u01a1n gi\u1ea3n. Cách làm nh\u01b0 sau:<\/p>\n

\n\t\u0110\u1ea7u tiên, trên b\u1ea3ng tính c\u1ea7n thi\u1ebft l\u1eadp ch\u1ebf \u0111\u1ed9 tô màu xen k\u1ebb các hàng ti\u1ebfn hành quét kh\u1ed1i vùng c\u1ea7n tô màu. Sau \u0111ó, trên th\u1ebb Home<\/strong> ch\u1ecdn Styles \/ Conditional Formatting \/ New Rule…<\/strong><\/p>\n

\n\t\"V\u00e0i<\/p>\n

\n\tTrong c\u1eeda s\u1ed5 New Formatting Rule,<\/strong> t\u1ea1i tr\u01b0\u1eddng Select a Rule Tyle<\/strong> b\u1ea1n ch\u1ecdn dòng Use a Formula to Determine Which Cells to Format<\/strong>. Ti\u1ebfp theo, t\u1ea1i ô nh\u1eadp công th\u1ee9c bên d\u01b0\u1edbi b\u1ea1n nh\u1eadp vào công th\u1ee9c =MOD(ROW()\/2,1)>0<\/strong><\/p>\n

\n\t\"V\u00e0i<\/p>\n

\n\tC\u0169ng t\u1ea1i c\u1eeda s\u1ed5 New Formatting Rule,<\/strong> b\u1ea1n nh\u1ea5n vào nút Format…<\/strong> bên d\u01b0\u1edbi ô công th\u1ee9c r\u1ed3i chuy\u1ec3n sang th\u1ebb Fill <\/strong>\u0111\u1ec3 ti\u1ebfn hành l\u1ef1a ch\u1ecdn màu cho các ô s\u1ebd \u0111\u01b0\u1ee3c tô.<\/p>\n

\n\t \"V\u00e0i<\/p>\n

\n\tSau khi nh\u1eadp xong công th\u1ee9c và l\u1ef1a ch\u1ecdn màu, b\u1ea1n nh\u1ea5n OK <\/strong>\u0111\u1ec3 th\u1ef1c thi l\u1ec7nh.<\/p>\n

\n\tNgay l\u1eadp t\u1ee9c, k\u1ebft qu\u1ea3 s\u1ebd \u0111\u01b0\u1ee3c hi\u1ec3n th\u1ecb ngay trong b\u1ea3ng tính v\u1edbi các ô \u0111\u01b0\u1ee3c tô màu xen k\u1ebd v\u1edbi nhau.<\/p>\n

\n\t\"V\u00e0i<\/p>\n

\n\tV\u1edbi hai th\u1ee7 thu\u1eadt nh\u1ecf trên hi v\u1ecdng s\u1ebd ph\u1ea7n nào giúp b\u1ea1n \u0111\u1ecdc có th\u1ec3 n\u1eafm b\u1eaft và s\u1eed d\u1ee5ng Excel hi\u1ec7u qu\u1ea3 h\u01a1n trong công vi\u1ec7c h\u1eb1ng ngày c\u1ee7a mình.<\/p>\n","protected":false},"excerpt":{"rendered":"

\n\t\"V\u00e0i<\/p>\n

\n\tExcel là \u1ee9ng d\u1ee5ng v\u0103n phòng n\u1eb1m trong b\u1ed9 ph\u1ea7n m\u1ec1m MS Office c\u1ee7a Microsoft, Excel \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng khá ph\u1ed5 bi\u1ebfn trong công tác k\u1ebf toán c\u0169ng nh\u01b0 th\u1ed1ng kê. N\u1ebfu b\u1ea1n là ng\u01b0\u1eddi th\u01b0\u1eddng xuyên s\u1eed d\u1ee5ng Excel thì ch\u1eafc h\u1eb3n s\u1ebd g\u1eb7p tình tr\u1ea1ng l\u1eb7p \u0111i l\u1eb7p l\u1ea1i thao tác c\u1eadp nh\u1eadt n\u1ebfu s\u1ed1 li\u1ec7u thay \u0111\u1ed5i ho\u1eb7c b\u1ea5t c\u1eadp trong quá trình s\u1eed d\u1ee5ng.<\/span><\/p>\n","protected":false},"author":6,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[128],"tags":[],"class_list":["post-1044","post","type-post","status-publish","format-standard","hentry","category-van-phong"],"views":378,"_links":{"self":[{"href":"https:\/\/tapchicntt.com\/rest-api\/wp\/v2\/posts\/1044","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/tapchicntt.com\/rest-api\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/tapchicntt.com\/rest-api\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/tapchicntt.com\/rest-api\/wp\/v2\/users\/6"}],"replies":[{"embeddable":true,"href":"https:\/\/tapchicntt.com\/rest-api\/wp\/v2\/comments?post=1044"}],"version-history":[{"count":0,"href":"https:\/\/tapchicntt.com\/rest-api\/wp\/v2\/posts\/1044\/revisions"}],"wp:attachment":[{"href":"https:\/\/tapchicntt.com\/rest-api\/wp\/v2\/media?parent=1044"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/tapchicntt.com\/rest-api\/wp\/v2\/categories?post=1044"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/tapchicntt.com\/rest-api\/wp\/v2\/tags?post=1044"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}