{"id":12745,"date":"2015-09-08T09:01:59","date_gmt":"2015-09-08T09:01:59","guid":{"rendered":"https:\/\/centax.dsoftware.vn\/?p=12745"},"modified":"2015-09-29T09:22:05","modified_gmt":"2015-09-29T09:22:05","slug":"cach-doi-so-thanh-chu-trong-excel-2003-2007-2010-2013","status":"publish","type":"post","link":"https:\/\/centax.dsoftware.vn\/?p=12745","title":{"rendered":"C\u00e1ch \u0111\u1ed5i s\u1ed1 th\u00e0nh ch\u1eef trong Excel 2003, 2007, 2010, 2013"},"content":{"rendered":"

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

Chuy\u1ec3n s\u1ed1 th\u00e0nh ch\u1eef trong Excel l\u00e0 vi\u1ec7c l\u00e0m h\u1ebft s\u1ee9c c\u1ea7n thi\u1ebft cho m\u1ecdi k\u1ebf to\u00e1n \u0111\u1eb7c bi\u1ec7t v\u1edbi nh\u1eefng k\u1ebf to\u00e1n ti\u1ec1n l\u01b0\u01a1ng, k\u1ebf to\u00e1n b\u00e1n h\u00e0ng… n\u00f3i chung l\u00e0 nh\u1eefng c\u00f4ng vi\u1ec7c li\u00ean quan \u0111\u1ebfn ti\u1ec1n.<\/span><\/p>\n

\u0110\u1ec3 \u00fd trong nh\u1eefng phi\u1ebfu thu, phi\u1ebfu chi, b\u1ea3ng thanh to\u00e1n ti\u1ec1n l\u01b0\u01a1ng… ngay d\u01b0\u1edbi c\u1ed9t t\u1ed5ng s\u1ed1 ti\u1ec1n l\u00e0 m\u1ee5c s\u1ed1 ti\u1ec1n b\u1eb1ng ch\u1eef. S\u1ed1 ti\u1ec1n b\u1eb1ng ch\u1eef n\u00e0y k\u1ebf to\u00e1n c\u00f3 th\u1ec3 t\u1ef1 \u0111\u00e1nh v\u00e0o nh\u01b0ng s\u1ebd m\u1ea5t th\u1eddi gian, thi\u1ebfu chuy\u00ean nghi\u1ec7p v\u00e0 kh\u00f4ng \u0111\u1ea3m b\u1ea3o ch\u00ednh x\u00e1c ho\u00e0n to\u00e0n. V\u1eady\u00a0C\u00e1ch \u0111\u1ed5i t\u1eeb s\u1ed1 sang ch\u1eef trong Excel t\u1eeb Excel 2003 – 2013 t\u1ef1 \u0111\u1ed9ng nh\u01b0 th\u1ebf n\u00e0o? K\u1ebf to\u00e1n Centax<\/a><\/strong> m\u1eddi b\u1ea1n\u00a0\u0111\u1ecdc tham kh\u1ea3o b\u00e0i vi\u1ebft sau:\u00a0<\/span><\/p>\n

Tr\u01b0\u1edbc ti\u00ean,\u00a0\u0111\u1ec3\u00a0\u0111\u1ed5i\u00a0\u0111\u01b0\u1ee3c s\u1ed1 sang ch\u1eef c\u00e1c b\u1ea1n c\u1ea7n c\u00e0i\u00a0\u0111\u1eb7t 1 ph\u1ea7n m\u1ec1m t\u00ean: AccHelper<\/strong><\/span><\/span><\/p>\n

C\u00e1c b\u1ea1n t\u1ea3i ph\u1ea7n m\u1ec1m t\u1ea1i\u00a0\u0111\u00e2y<\/a><\/span><\/p>\n

Sau khi t\u1ea3i xong, b\u1ea1n\u00a0\u0111\u1ecdc ti\u1ebfn h\u00e0nh gi\u1ea3i n\u00e9n v\u00e0 c\u00e0i\u00a0\u0111\u1eb7t nh\u01b0 sau:<\/span><\/p>\n

1.\u00a0\u0110\u1ed1i v\u1edbi\u00a0Excel 2007,\u00a0Excel 2010,\u00a0Excel 2013<\/span><\/p>\n

B\u01b0\u1edbc 1: M\u1edf 1 file\u00a0Excel b\u1ea5t k\u1ef3\u00a0<\/span><\/p>\n

B\u01b0\u1edbc 2: K\u00edch v\u00e0o bi\u1ec3u t\u01b0\u1ee3ng trang ch\u1ee7 c\u1ee7a\u00a0Excel hay n\u00fat file => Ch\u1ecdn “Excel Options”\u00a0<\/span><\/p>\n

B\u01b0\u1edbc 3: T\u1ea1i c\u1eeda s\u1ed5 ”\u00a0Excel option” ch\u1ecdn “AddIns” sau\u00a0\u0111\u00f3 ch\u1ecdn ”\u00a0Excel AddIns” => Go<\/span><\/p>\n

\"C\u00e1ch<\/span><\/p>\n

B\u01b0\u1edbc 4: T\u1ea1i c\u1eeda s\u1ed1 m\u1edbi v\u1eeba hi\u1ec7n ra, b\u1ea1n t\u00ecm\u00a0\u0111\u1ebfn v\u1ecb tr\u00ed c\u1ee7a ph\u1ea7n m\u1ec1m AccHelper v\u1eeba t\u1ea3i v\u1ec1, k\u00edch ch\u1ecdn ” AccHelper” ( D\u00e0nh cho\u00a0Excel 2007, 2010, 2013) => Open<\/span><\/p>\n

\"C\u00e1ch<\/span><\/p>\n

B\u01b0\u1edbc 5: C\u1eeda s\u1ed5 m\u1edbi hi\u1ec7n ra b\u1ea1n\u00a0\u1ea5n “OK” coi nh\u01b0\u00a0\u0111\u00e3 xong vi\u1ec7c c\u00e0i\u00a0\u0111\u1eb7t<\/span><\/p>\n

\"C\u00e1ch<\/span><\/p>\n

2. C\u00e1ch chuy\u1ec3n s\u1ed1 sang ch\u1eef v\u1edbi\u00a0Excel 2003<\/span><\/p>\n

\u0110\u1ed1i v\u1edbi Excel 2003, vi\u1ec7c c\u00e0i \u0111\u1eb7t t\u1ea1i\u00a0b\u01b0\u1edbc 1, 2, 3 t\u01b0\u01a1ng t\u1ef1 nh\u01b0\u00a0Excel 2007, 2010, 2013<\/span><\/p>\n

T\u1ea1i b\u01b0\u1edbc 4, Thay v\u00ec ch\u1ecdn AccHelper ta ch\u1ecdn AccHelperEx\u00a0<\/span><\/p>\n

V\u00e0 b\u01b0\u1edbc 5 nh\u1ea5n ok l\u00e0 coi nh\u01b0 \u0111\u00e3 xong qu\u00e1 tr\u00ecnh c\u00e0i \u0111\u1eb7t<\/span><\/p>\n

3. C\u00f4ng th\u1ee9c: = VND(\u00f4 c\u1ea7n chuy\u1ec3n)<\/span><\/p>\n

V\u00ed d\u1ee5: M\u1eddi b\u1ea1n\u00a0\u0111\u1ecdc quan s\u00e1t b\u1ea3ng l\u01b0\u01a1ng c\u1ee7a K\u1ebf to\u00e1n Centax t\u1ea1i\u00a0\u0111\u00e2y<\/span><\/p>\n

\"C\u00e1ch<\/span><\/p>\n

\u00a0T\u1ea1i\u00a0\u00f4 C16, b\u1ea1n mu\u1ed1n bi\u1ebft t\u1ed5ng ti\u1ec1n l\u01b0\u01a1ng ph\u1ea3i tr\u1ea3 cho nh\u00e2n vi\u00ean b\u1eb1ng ch\u1eef<\/span><\/p>\n

B\u1ea1n \u0111\u1eb7t c\u00f4ng th\u1ee9c t\u1ea1i \u00f4 C16 = VND(H14) => Enter v\u00e0 nh\u1eadn k\u1ebft qu\u1ea3 nh\u01b0 h\u00ecnh v\u1ebd tr\u00ean<\/span><\/p>\n

Ch\u00fac c\u00e1c b\u1ea1n c\u00e0i \u0111\u1eb7t v\u00e0 s\u1eed d\u1ee5ng th\u00e0nh c\u00f4ng<\/span><\/p>\n

Ngo\u00e0i ra, m\u1eddi b\u1ea1n \u0111\u1ecdc tham kh\u1ea3o th\u00eam c\u00e1c b\u00e0i vi\u1ebft sau:<\/span><\/p>\n

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

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

\u00a0C\u1eadp nh\u1eadt ph\u1ea7n m\u1ec1m HTKK 3.3.3 m\u1edbi nh\u1ea5t<\/a><\/span><\/p>\n

M\u00f4 t\u1ea3 c\u00f4ng vi\u1ec7c c\u1ee7a k\u1ebf to\u00e1n t\u1ed5ng h\u1ee3p<\/a><\/span><\/p>\n

M\u1eabu b\u00e1o c\u00e1o t\u00e0i ch\u00ednh theo Th\u00f4ng t\u01b0 200\/2014\/TT-BTC<\/a><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"

K\u1ebf to\u00e1n Centax xin gi\u1edbi thi\u1ec7u C\u00e1ch \u0111\u1ed5i s\u1ed1 th\u00e0nh ch\u1eef trong Excel 2003, 2007, 2010, 2013. \u0110\u00e2y l\u00e0 m\u1ed9t c\u00f4ng c\u1ee5 \u0111\u1eafc l\u1ef1c trong c\u00f4ng t\u00e1c k\u1ebf to\u00e1n. M\u1eddi b\u1ea1n \u0111\u1ecdc tham kh\u1ea3o trong b\u00e0i vi\u1ebft sau<\/p>\n","protected":false},"author":7,"featured_media":12809,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"tags":[1592,1589,1590,1591],"_links":{"self":[{"href":"https:\/\/centax.dsoftware.vn\/index.php?rest_route=\/wp\/v2\/posts\/12745"}],"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=12745"}],"version-history":[{"count":0,"href":"https:\/\/centax.dsoftware.vn\/index.php?rest_route=\/wp\/v2\/posts\/12745\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/centax.dsoftware.vn\/index.php?rest_route=\/wp\/v2\/media\/12809"}],"wp:attachment":[{"href":"https:\/\/centax.dsoftware.vn\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=12745"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/centax.dsoftware.vn\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=12745"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}