{"id":12343,"date":"2025-01-15T08:18:04","date_gmt":"2025-01-15T08:18:04","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/15\/huong-dan-chuyen-doi-ty-gia-tien-te-trong-excel\/"},"modified":"2025-01-15T08:18:04","modified_gmt":"2025-01-15T08:18:04","slug":"huong-dan-chuyen-doi-ty-gia-tien-te-trong-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/15\/huong-dan-chuyen-doi-ty-gia-tien-te-trong-excel\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn chuy\u1ec3n \u0111\u1ed5i t\u1ef7 gi\u00e1 ti\u1ec1n t\u1ec7 trong Excel"},"content":{"rendered":"
\n

Ch\u1eafc \u00a0ch\u1eafn khi l\u00e0m vi\u1ec7c \u1edf m\u1ed9t s\u1ed1 c\u00f4ng ty, b\u1ea1n c\u1ea7n ph\u1ea3i chuy\u1ec3n \u0111\u1ed5i t\u1ef7 gi\u00e1 ti\u1ec1n t\u1ec7 c\u1ee7a m\u1ed9t s\u1ed1 qu\u1ed1c gia sang \u0111\u1ed3ng Vi\u1ec7t Nam v\u00e0 ng\u01b0\u1ee3c l\u1ea1i. V\u1eady l\u00e0m th\u1ebf n\u00e0o b\u1ea1n c\u00f3 th\u1ec3 chuy\u1ec3n \u0111\u1ed5i m\u1ed9t l\u01b0\u1ee3ng l\u1edbn d\u1eef li\u1ec7u c\u00f9ng m\u1ed9t l\u00fac?<\/strong><\/em><\/p>\n

Hi v\u1ecdng, v\u1edbi b\u00e0i chia s\u1ebb n\u00e0y cu\u0309a Blog Ho\u0323c Excel Online<\/a> se\u0303 giu\u0301p b\u1ea1n c\u00f3 th\u1ec3 v\u00f4 t\u01b0 chuy\u1ec3n \u0111\u1ed5i b\u1ea5t k\u00ec lo\u1ea1i ti\u1ec1n n\u00e0o tr\u00ean Th\u1ebf gi\u1edbi.<\/p>\n

Gi\u1ea3 s\u1eed b\u1ea1n c\u00f3 m\u1ed9t ng\u00e2n s\u00e1ch v\u1edbi \u0111\u1ed3ng \u0111\u00f4 la M\u1ef9 USD<\/strong> v\u00e0 c\u1ea7n ph\u1ea3i chuy\u1ec3n \u0111\u1ed5i c\u00e1c s\u1ed1 li\u1ec7u \u0111\u00f3 th\u00e0nh \u0111\u1ed3ng VN\u0110<\/strong>, h\u00e3y l\u00e0m theo c\u00e1c b\u01b0\u1edbc sau:<\/p>\n

B\u01b0\u1edbc 1<\/strong>:\u00a0T\u00ecm hi\u1ec3u c\u00e1c t\u1ef7 gi\u00e1 h\u1ed1i \u0111o\u00e1i hi\u1ec7n nay gi\u1eefa \u0111\u1ed3ng USD<\/strong> v\u00e0 VN\u0110<\/strong> v\u00e0 nh\u1eadp n\u00f3 v\u00e0o m\u1ed9t \u00f4 tr\u1ed1ng. (\u00d4 E3 trong v\u00ed d\u1ee5)<\/em><\/p>\n

<\/p>\n

B\u01b0\u1edbc 2<\/strong>: Trong \u00f4 D3 \u1edf c\u1ed9t VN\u0110, nh\u1eadp c\u00f4ng th\u1ee9c c\u1ee7a =B3*$E$3.\u00a0<\/strong>( Trong \u0111\u00f3 th\u00e0nh ph\u1ea7n $..$ d\u00f9ng \u0111\u1ec3 c\u1ed1 \u0111\u1ecbnh 1 \u0111\u1ed1i t\u01b0\u1ee3ng khi t\u00ednh to\u00e1n s\u1ed1 li\u1ec7u trong Excel, t\u1ea1o\u00a0b\u1eb1ng c\u00e1ch \u1ea5n F4 sau khi b\u1ea1n ch\u1ecdn \u00f4 F3).<\/p>\n

<\/p>\n

=> K\u1ebft qu\u1ea3 thu \u0111\u01b0\u1ee3c:<\/p>\n

\n
\n
\n
\n<\/a>\n<\/div>\n<\/div>\n

<\/p>\n

V\u1eady l\u00e0 xong r\u1ed3i.<\/p>\n

\u0110\u1ec3 c\u00f3 th\u1ec3 \u1ee9ng d\u1ee5ng t\u1ed1t Excel v\u00e0o trong c\u00f4ng vi\u1ec7c, ch\u00fang ta kh\u00f4ng ch\u1ec9 n\u1eafm v\u1eefng \u0111\u01b0\u1ee3c c\u00e1c h\u00e0m m\u00e0 c\u00f2n ph\u1ea3i s\u1eed d\u1ee5ng t\u1ed1t c\u1ea3 c\u00e1c c\u00f4ng c\u1ee5 c\u1ee7a Excel. Nh\u1eefng h\u00e0m n\u00e2ng cao gi\u00fap \u00e1p d\u1ee5ng t\u1ed1t v\u00e0o c\u00f4ng vi\u1ec7c nh\u01b0 SUMIFS, COUNTIFS, SUMPRODUCT, INDEX + MATCH\u2026 Nh\u1eefng c\u00f4ng c\u1ee5 th\u01b0\u1eddng s\u1eed d\u1ee5ng l\u00e0 Data validation, Conditional formatting, Pivot table\u2026<\/p>\n

To\u00e0n b\u1ed9 nh\u1eefng ki\u1ebfn th\u1ee9c n\u00e0y c\u00e1c b\u1ea1n \u0111\u1ec1u c\u00f3 th\u1ec3 h\u1ecdc \u0111\u01b0\u1ee3c trong kh\u00f3a h\u1ecdc\u00a0<\/p>\n<\/div>\n

\n

Click \u0111\u0103ng k\u00fd h\u1ecdc t\u1ea1i:<\/p>\n

T\u1ea5t c\u1ea3 kho\u00e1 h\u1ecdc\u00a0\ud83d\udcd6<\/span><\/a><\/p>\n

H\u01b0\u1edbng d\u1eabn k\u00edch ho\u1ea1t<\/a><\/p>\n

HKD H\u1ecdc Excel Online
S\u1ed1 \u0110K: 17A80048102<\/p>\n<\/div>\n

\n

\u00a9 document.currentScript.insertAdjacentHTML(‘afterend’, ” + new Intl.DateTimeFormat(document.documentElement.lang, {year: ‘numeric’}).format() + ”); H\u1ecdc Excel Online. All rights reserved.<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"

\n
\n
\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":12344,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-12343","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-co-ban"],"_links":{"self":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/12343","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/comments?post=12343"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/12343\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/12344"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=12343"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=12343"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=12343"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}