{"id":13448,"date":"2015-09-16T09:22:15","date_gmt":"2015-09-16T09:22:15","guid":{"rendered":"https:\/\/centax.dsoftware.vn\/?p=13448"},"modified":"2015-09-29T09:31:29","modified_gmt":"2015-09-29T09:31:29","slug":"cach-ve-do-thi-trong-excel-2007-2010","status":"publish","type":"post","link":"https:\/\/centax.dsoftware.vn\/?p=13448","title":{"rendered":"C\u00e1ch v\u1ebd \u0111\u1ed3 th\u1ecb trong Excel 2007 2010"},"content":{"rendered":"

V\u1ebd bi\u1ec3u \u0111\u1ed3 trong Excel l\u00e0 1 ti\u1ec7n \u00edch v\u01b0\u1ee3t tr\u1ed9i c\u1ee7a Excel so v\u1edbi c\u00e1c c\u00f4ng c\u1ee5 v\u1ebd bi\u1ec3u \u0111\u1ed3 kh\u00e1c. Excel c\u00f3 r\u1ea5t nhi\u1ec1u ti\u1ec7n \u00edch m\u00e0 ch\u00fang ta ch\u01b0a kh\u00e1m ph\u00e1 h\u1ebft \u0111\u01b0\u1ee3c. Vi\u1ec7c l\u00e0m vi\u1ec7c v\u1edbi c\u00e1c con s\u1ed1 tr\u00ean Excel l\u00e0 vi\u1ec7c th\u01b0\u1eddng ng\u00e0y c\u1ee7a nh\u1eefng ng\u01b0\u1eddi d\u00f9ng Excel, \u1edf 1 l\u0129nh v\u1ef1c n\u00e0o \u0111\u00f3 c\u00e1c con s\u1ed1 s\u1ebd kh\u00f4ng th\u1ec3 di\u1ec5n t\u1ea3 h\u1ebft \u0111\u01b0\u1ee3c nh\u1eefng th\u00f4ng \u0111i\u1ec7p, nh\u1eefng s\u1ef1 so s\u00e1nh m\u00e0 ng\u01b0\u1eddi vi\u1ebft mu\u1ed1n ng\u01b0\u1eddi \u0111\u1ecdc hi\u1ec3u \u0111\u01b0\u1ee3c n\u00f3.<\/span><\/p>\n

\u0110\u1ed3 th\u1ecb trong Excel l\u00e0 c\u00e1ch ta bi\u1ebfn nh\u1eefng con s\u1ed1 th\u1ed1ng k\u00ea trong b\u1ea3ng th\u00e0nh nh\u1eefng h\u00ecnh \u1ea3nh d\u1ec5 hi\u1ec3u, d\u1ec5 h\u00ecnh dung v\u00e0 so s\u00e1nh v\u1ec1 s\u1ef1 t\u01b0\u01a1ng quan gi\u1eefa c\u00e1c s\u1ed1 li\u1ec7u. T\u1eeb phi\u00ean b\u1ea3n Excel 2007 th\u00ec vi\u1ec7c v\u1ebd \u0111\u1ed3 th\u1ecb tr\u1edf n\u00ean r\u1ea5t d\u1ec5 d\u00e0ng v\u00e0 h\u00ecnh \u1ea3nh \u0111\u1eb9p h\u01a1n. H\u00f4m nay, K\u1ebf to\u00e1n Centax<\/a>\u00a0s\u1ebd h\u01b0\u1edbng d\u1eabn c\u00e1c b\u1ea1n v\u1ebd bi\u1ec3u \u0111\u1ed3 trong Excel 2007, Excel \u00a02010.<\/span><\/p>\n

\u0110\u1ec3 th\u1ef1c h\u00e0nh Centax xin \u0111\u01b0a ra v\u00ed d\u1ee5 sau v\u1ec1 c\u00e1ch v\u1ebd \u0111\u1ed3 th\u1ecb trong Excel:<\/span><\/p>\n

Ta c\u00f3 1 b\u1ea3ng d\u1eef li\u1ec7u s\u1ea3n l\u01b0\u1ee3ng l\u01b0\u01a1ng th\u1ef1c c\u1ea7n v\u1ebd \u0111\u1ed3 th\u1ecb.<\/span><\/p>\n

\"C\u00e1ch<\/h2>\n

Y\u00eau c\u1ea7u:<\/strong> V\u1ebd bi\u1ec3u \u0111\u1ed3 h\u00ecnh c\u1ed9t m\u00f4 t\u1ea3 s\u1ea3n l\u01b0\u1ee3ng thu \u0111\u01b0\u1ee3c c\u1ee7a c\u00e1c s\u1ea3n ph\u1ea9m trong qu\u00fd II n\u0103m 2013<\/span><\/p>\n

\u0110\u1ec3 v\u1ebd \u0111\u01b0\u1ee3c bi\u1ec3u \u0111\u1ed3 c\u1ee7a c\u00e1c s\u1ea3n ph\u1ea9m n\u00e0y tr\u00ean Excel 2007, Excel 2010 ch\u00fang ta ti\u1ebfn h\u00e0nh tr\u00ean c\u00e1c b\u01b0\u1edbc nh\u01b0 sau:<\/span><\/p>\n

B\u01b0\u1edbc 1: Ch\u1ecdn to\u00e0n b\u1ed9 ph\u1ea7n d\u1eef li\u1ec7u c\u1ea7n v\u1ebd bi\u1ec3u \u0111\u1ed3.<\/span><\/p>\n

B\u01b0\u1edbc 2: K\u00edch v\u00e0o m\u1ee5c \u201cInsert\u201d tr\u00ean thanh c\u00f4ng c\u1ee5. T\u1ea1i \u0111\u00e2y ta ch\u1ecdn m\u1ee5c \u201cColumn\u201d. Khi k\u00edch v\u00e0o m\u1ee5c\u201cColumn\u201d s\u1ebd ra r\u1ea5t nhi\u1ec1u lo\u1ea1i bi\u1ec3u \u0111\u1ed3 cho b\u1ea1n l\u1ef1a ch\u1ecdn. C\u00e1c b\u1ea1n ch\u1ec9 c\u1ea7n ch\u1ecdn 1 lo\u1ea1i bi\u1ec3u \u0111\u1ed3 m\u00e0 m\u00ecnh mu\u1ed1n th\u1ec3 hi\u1ec7n.<\/span><\/p>\n

\"ve-bieu-do-trong-excel\"<\/p>\n

V\u1eady l\u00e0 ch\u00fang ta \u0111\u00e3 c\u00f3 ngay \u0111\u01b0\u1ee3c k\u1ebft qu\u1ea3 l\u00e0 bi\u1ec3u \u0111\u1ed3 th\u1ec3 hi\u1ec7n c\u00e1c s\u1ed1 li\u1ec7u m\u00e0 ta \u0111\u00e3 l\u1ef1a ch\u1ecdn.<\/span><\/p>\n

\"cach-ve-bieu-do-trong-excel\"<\/p>\n

N\u1ebfu nh\u01b0 giao di\u1ec7n c\u1ee7a bi\u1ec3u \u0111\u1ed3 ch\u01b0a \u0111\u01b0\u1ee3c b\u1eaft m\u1eaft, ch\u01b0a \u0111\u01b0\u1ee3c \u01b0ng \u00fd th\u00ec c\u00e1c b\u1ea1n c\u00f3 th\u1ec3 thay \u0111\u1ed5i \u0111\u01b0\u1ee3c Style\u00a0v\u1eeba v\u1ebd c\u1ee7a bi\u1ec3u \u0111\u1ed3 1 c\u00e1ch d\u1ec5 d\u00e0ng trong Excel. \u0110\u1ec3 th\u1ef1c hi\u1ec7n vi\u1ec7c thay \u0111\u1ed5i n\u00e0y tr\u00ean thanh c\u00f4ng c\u1ee5 ch\u1ecdn\u201cDesign\u201d v\u00e0 ch\u1ecdn d\u1ea1ng bi\u1ec3u \u0111\u1ed3 kh\u00e1c \u1edf trong \u201cChart Styles\u201d, chon ki\u1ec3u style b\u1ea1n th\u00edch nh\u01b0 h\u00ecnh d\u01b0\u1edbi.<\/span><\/p>\n

\"ve-do-thi-trong-excel\"<\/p>\n

C\u00f3 1 ti\u1ec7n \u00edch r\u1ea5t \u0111\u00e1ng ch\u00fa \u00fd trong vi\u1ec7c th\u1ec3 hi\u1ec7n \u0111\u1ed3 th\u1ecb \u1edf \u0111\u00e2y m\u00e0 c\u00e1c b\u1ea1n c\u1ea7n bi\u1ebft: \u0111\u00f3 l\u00e0 ch\u00fang ta ho\u00e0n to\u00e0n c\u00f3 th\u1ec3 \u0111\u1ed5i h\u00e0ng th\u00e0nh c\u1ed9t, \u0111\u1ed5i c\u1ed9t th\u00e0nh h\u00e0ng \u0111\u1ec3 bi\u1ec3u \u0111\u1ed3 d\u1ec5 xem nh\u1ea5t theo \u00fd c\u1ee7a b\u1ea1n.<\/span><\/p>\n

\u0110\u1ec3 th\u1ef1c hi\u1ec7n \u0111\u01b0\u1ee3c \u0111i\u1ec1u n\u00e0y \u0111\u1ea7u ti\u00ean c\u00e1c b\u1ea1n ch\u1ecdn v\u00e0o \u201cDesign\u201d sau \u0111\u00f3 c\u00e1c b\u1ea1n ch\u1ecdn \u201cSwitch Row\/Column\u201d ch\u00fang ta \u0111\u00e3 th\u1ea5y k\u1ebft qu\u1ea3: M\u1ee5c \u201cth\u00e1ng\u201d v\u00e0 m\u1ee5c \u201cS\u1ea3n ph\u1ea9m\u201d \u0111\u00e3 \u0111\u01b0\u1ee3c \u0111\u1ed5i v\u1ecb tr\u00ed cho nhau.<\/span><\/p>\n

\"cach-ve-do-thi-trong-excel\"<\/p>\n

Tr\u00ean \u0111\u00e2y K\u1ebf to\u00e1n Thi\u00ean \u01afng \u0111\u00e3 h\u01b0\u1edbng d\u1eabn xong c\u00e1c b\u1ea1n c\u00e1ch v\u1ebd \u0111\u1ed3 th\u1ecb trong Excel 2007, Excel 2010, r\u1ea5t d\u1ec5 d\u00e0ng v\u00e0 hi\u1ec7u qu\u1ea3.<\/span><\/p>\n

C\u00e1c b\u1ea1n c\u00f3 th\u1ec3 tham kh\u1ea3o th\u00eam:\u00a0<\/span>C\u00e1c l\u1ed7i th\u01b0\u1eddng g\u1eb7p trong Word<\/a><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"

V\u1ebd bi\u1ec3u \u0111\u1ed3 trong Excel l\u00e0 1 ti\u1ec7n \u00edch v\u01b0\u1ee3t tr\u1ed9i c\u1ee7a Excel so v\u1edbi c\u00e1c c\u00f4ng c\u1ee5 v\u1ebd bi\u1ec3u \u0111\u1ed3 kh\u00e1c. \u0110\u1ed3 th\u1ecb trong Excel gi\u00fap ch\u00fang ta nh\u00ecn nh\u1eadn c\u00e1c s\u1ed1 li\u1ec7u m\u1ed9t c\u00e1ch d\u1ec5 d\u00e0ng.<\/p>\n","protected":false},"author":7,"featured_media":13454,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"tags":[1686],"_links":{"self":[{"href":"https:\/\/centax.dsoftware.vn\/index.php?rest_route=\/wp\/v2\/posts\/13448"}],"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=13448"}],"version-history":[{"count":0,"href":"https:\/\/centax.dsoftware.vn\/index.php?rest_route=\/wp\/v2\/posts\/13448\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/centax.dsoftware.vn\/index.php?rest_route=\/wp\/v2\/media\/13454"}],"wp:attachment":[{"href":"https:\/\/centax.dsoftware.vn\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=13448"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/centax.dsoftware.vn\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=13448"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}