{"id":8231,"date":"2021-08-20T13:03:44","date_gmt":"2021-08-20T06:03:44","guid":{"rendered":"https:\/\/tct.vn\/blog\/?p=8231"},"modified":"2021-08-20T13:03:44","modified_gmt":"2021-08-20T06:03:44","slug":"dich-van-ban-cuc-nhanh-tren-google-spreadsheets","status":"publish","type":"post","link":"https:\/\/tct.vn\/blog\/dich-van-ban-cuc-nhanh-tren-google-spreadsheets\/","title":{"rendered":"D\u1ecbch v\u0103n b\u1ea3n c\u1ef1c nhanh tr\u00ean Google Spreadsheets"},"content":{"rendered":"

#1. C\u00e1ch d\u1ecbch v\u0103n b\u1ea3n c\u1ef1c nhanh tr\u00ean Google Spreadsheets<\/strong><\/span><\/h3>\n

Google Spreadsheets<\/strong>\u00a0hay c\u00f2n g\u1ecdi l\u00e0\u00a0Google Trang T\u00ednh<\/strong>, n\u00f3 c\u0169ng t\u01b0\u01a1ng t\u1ef1 nh\u01b0 \u1ee9ng d\u1ee5ng Excel c\u1ee7a Microsoft v\u1eady.<\/p>\n

Th\u1ee7 thu\u1eadt n\u00e0y \u0111\u01b0\u1ee3c chia s\u1ebb b\u1edfi trang Jake Miller Tech, m\u00ecnh l\u01b0\u1edbt Facebook th\u1ea5y hay n\u00ean m\u00ecnh quy\u1ebft \u0111\u1ecbnh vi\u1ebft b\u00e0i n\u00e0y \u0111\u1ec3 chia s\u1ebb l\u1ea1i v\u1edbi c\u00e1c b\u1ea1n lu\u00f4n.<\/p>\n

+ B\u01b0\u1edbc 1:<\/strong>\u00a0\u0110\u1ea7u ti\u00ean truy c\u1eadp v\u00e0o\u00a0Google Trang t\u00ednh, \u0111\u0103ng nh\u1eadp v\u00e0o\u00a0t\u00e0i kho\u1ea3n Google\u00a0c\u1ee7a b\u1ea1n => sau \u0111\u00f3 m\u1edf b\u1ea5t k\u00ec, ho\u1eb7c l\u00e0 t\u1ea1o m\u1ed9t trang t\u00ednh m\u1edbi nh\u01b0 m\u00ecnh l\u00e0m trong h\u00ecnh:<\/p>\n

\"\"<\/p>\n

+ B\u01b0\u1edbc 2:<\/strong>\u00a0B\u1ea1n ti\u1ebfn h\u00e0nh t\u1ea1o ra 2 c\u1ed9t,\u00a0c\u1ed9t \u0111\u1ea7u ti\u00ean<\/strong>\u00a0ch\u1ee9a nh\u1eefng t\u1eeb\/ c\u1ee5m t\u1eeb\/ \u0111o\u1ea1n n\u1ed9i dung m\u00e0 b\u1ea1n mu\u1ed1n d\u1ecbch,\u00a0c\u1ed9t c\u00f2n<\/strong>\u00a0l\u1ea1i s\u1ebd l\u00e0 n\u01a1i ch\u00fang ta nh\u1eadp c\u00f4ng th\u1ee9c v\u00e0 hi\u1ec3n th\u1ecb k\u1ebft qu\u1ea3 d\u1ecbch c\u1ee7a t\u1eeb\/ c\u1ee5m t\u1eeb\/ \u0111o\u1ea1n n\u1ed9i dung t\u01b0\u01a1ng \u1ee9ng.<\/p>\n

\u1ede \u0111\u00e2y m\u00ecnh s\u1ebd d\u1ecbch Ti\u1ebfng Anh sang ti\u1ebfng Ph\u00e1p, v\u1eady n\u00ean c\u1ed9t \u0111\u1ea7u m\u00ecnh \u0111\u1ec3 l\u00e0\u00a0English<\/code>\u00a0c\u00f2n c\u1ed9t hai l\u00e0\u00a0France<\/code>\u00a0nh\u00e9 !<\/p>\n

<\/div>\n

Ch\u00fang ta s\u1ebd s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c chung \u0111\u00f3 l\u00e0:\u00a0=GOOGLETRANSLATE(c\u1ed9t-n\u1ed9i-dung-mu\u1ed1n-d\u1ecbch;\u201cng\u00f4n-ng\u1eef-ngu\u1ed3n\u201d;\u201cng\u00f4n-ng\u1eef-\u0111\u00edch\u201d)<\/strong><\/p>\n

Th\u1ef1c hi\u1ec7n:<\/strong><\/p>\n

B\u1ea1n h\u00e3y nh\u1eadp t\u1eeb ti\u1ebfng Anh mu\u1ed1n d\u1ecbch v\u00e0o c\u1ed9t \u0111\u1ea7u ti\u00ean, c\u1ed9t th\u1ee9 hai b\u1ea1n s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c n\u00e0y b\u00ean d\u01b0\u1edbi => r\u1ed3i\u00a0ENTER<\/code>.<\/p>\n

=GOOGLETRANSLATE(A3;\"en\";\"fr\")<\/code><\/p><\/blockquote>\n

M\u00ecnh s\u1ebd gi\u1ea3i th\u00edch t\u1eebng ph\u1ea7n trong c\u00f4ng th\u1ee9c nh\u01b0 sau:<\/p>\n

    \n
  • GOOGLETRANSLATE:<\/strong>\u00a0\u0110\u00e2y l\u00e0 h\u00e0m d\u1ecbch gi\u00fap ch\u00fang ta c\u00f3 th\u1ec3 d\u1ecbch ng\u00f4n ng\u1eef nhanh ch\u00f3ng.<\/li>\n
  • A3:<\/strong>\u00a0L\u00e0 \u0111\u1ecba ch\u1ec9 c\u1ee7a \u00f4 ch\u1ee9a t\u1eeb ng\u1eef mu\u1ed1n d\u1ecbch. C\u00e1ch x\u00e1c \u0111\u1ecbnh th\u00ec \u0111\u01a1n gi\u1ea3n th\u00f4i, ch\u1eafc ai c\u0169ng bi\u1ebft r\u1ed3i ha, \u201cA,B,C\u2026\u201d l\u00e0 c\u1ed9t \u2013 n\u1eb1m ngang b\u00ean tr\u00ean c\u00f2n \u201c1,2,3,82,99\u2026\u201d l\u00e0 h\u00e0ng \u2013 ch\u00ednh l\u00e0 c\u1ed9t d\u1ecdc b\u00ean ph\u1ea3i. B\u1ea1n gh\u00e9p 2 c\u00e1i n\u00e0y l\u1ea1i l\u00e0 th\u00e0nh \u0111\u1ecba ch\u1ec9 \u00f4, v\u00e0 n\u1ebfu b\u1ea1n nh\u1eadp \u0111\u00fang th\u00ec c\u00e1i \u00f4 \u0111\u00f3 s\u1ebd s\u00e1ng l\u00ean m\u00e0u v\u00e0ng nh\u01b0 trong h\u00ecnh.<\/li>\n
  • en:<\/strong>\u00a0L\u00e0 ng\u00f4n ng\u1eef c\u1ee7a t\u1eeb ng\u1eef ban \u0111\u1ea7u mu\u1ed1n d\u1ecbch, v\u00ed d\u1ee5 nh\u01b0 l\u00e0: en, es, cn, vi\u2026<\/li>\n
  • fr:<\/strong>\u00a0Ng\u00f4n ng\u1eef \u0111\u00edch, l\u00e0 ng\u00f4n ng\u1eef b\u1ea1n mu\u1ed1n d\u1ecbch sang, c\u0169ng nh\u1eadp gi\u1ed1ng b\u00ean tr\u00ean : es, fr, de\u2026<\/li>\n<\/ul>\n

    => Nh\u1eadp xong th\u00ec\u00a0ENTER<\/code>\u00a0l\u00e0 \u0111\u01b0\u1ee3c b\u1ea1n s\u1ebd c\u00f3 k\u1ebft qu\u1ea3 ngay, l\u00e0m t\u01b0\u01a1ng t\u1ef1, b\u1ea1n ch\u1ec9 c\u1ea7n \u0111\u1ed5i \u0111\u1ecba ch\u1ec9 \u00f4 l\u00e0 \u0111\u01b0\u1ee3c.<\/p>\n

    \"\"<\/p>\n

    <\/div>\n

    Khi m\u00ecnh \u0111\u1ed5i sang ng\u00f4n ng\u1eef Vi\u1ec7t Nam th\u00ec n\u00f3 b\u00e1o l\u1ed7i, \u0111\u1ea1i lo\u1ea1i l\u00e0 kh\u00f4ng h\u1ed7 tr\u1ee3 ng\u00f4n ng\u1eef Vi\u1ec7t Nam, hy v\u1ecdng l\u00e0 trong t\u01b0\u01a1ng l\u1ea1i s\u1ebd c\u1eadp nh\u1eadt th\u00eam cho ch\u00fang ta s\u1eed d\u1ee5ng.<\/p>\n

    \"\"<\/p>\n

    [C\u1eacP NH\u1eacT B\u1edeI ADMIN]<\/strong>\u00a0\u0110\u00e3 h\u1ed7 tr\u1ee3 d\u1ecbch ng\u00f4n ng\u1eef kh\u00e1c sang Ti\u1ebfng Vi\u1ec7t r\u1ed3i nh\u00e9 c\u00e1c b\u1ea1n. B\u00e0i vi\u1ebft n\u00e0y CTV b\u00ean m\u00ecnh vi\u1ebft kho\u1ea3ng 1 n\u0103m r\u1ed3i nh\u1eefng gi\u1edd m\u00ecnh c\u1eadp nh\u1eadt cho c\u00e1c b\u1ea1n \u0111\u01b0\u1ee3c ?<\/p>\n

    \"\"<\/p>\n

    #2. D\u1ecbch ng\u00f4n ng\u1eef ngay tr\u00ean Excel<\/strong><\/span><\/h3>\n

    Trong Excel th\u00ec d\u1ec5 d\u00e0ng h\u01a1n r\u1ea5t nhi\u1ec1u, b\u1ea1n l\u00e0m nh\u01b0 sau:<\/p>\n

    B\u1ea1n m\u1edf trang t\u00ednh m\u1edbi l\u00ean => chuy\u1ec3n sang th\u1ebb\u00a0Review<\/code>\u00a0tr\u00ean thanh \u0111i\u1ec1u h\u01b0\u1edbng. B\u1ea1n s\u1ebd th\u1ea5y bi\u1ec3u t\u01b0\u1ee3ng\u00a0Translate<\/code>\u00a0nh\u01b0 h\u00ecnh => b\u1ea1n b\u1ea5m v\u00e0o \u0111\u00f3 \u0111\u1ec3 m\u1edf ch\u1ee9c n\u0103ng d\u1ecbch.<\/p>\n

    \"\"<\/p>\n

    Ch\u1ecdn ng\u00f4n ng\u1eef c\u1ee7a t\u1eeb\/ c\u1ee5m t\u1eeb\/ \u0111o\u1ea1n n\u1ed9i dung m\u00e0 b\u1ea1n mu\u1ed1n d\u1ecbch trong ph\u1ea7n\u00a0From<\/code>, ho\u1eb7c b\u1ea1n c\u00f3 th\u1ec3 \u0111\u1ec3\u00a0Auto-detect<\/code>\u00a0\u0111\u1ec3 n\u00f3 t\u1ef1 nh\u1eadn di\u1ec7n ng\u00f4n ng\u1eef => Sau \u0111\u00f3 nh\u1eadp t\u1eeb mu\u1ed1n d\u1ecbch v\u00e0o \u00f4 tr\u1ed1ng \u0111\u1ea7u ti\u00ean.<\/p>\n

    => Ti\u1ebfp theo, b\u1ea1n ch\u1ecdn ng\u00f4n ng\u1eef \u0111\u00edch trong ph\u1ea7n\u00a0To<\/code>, ngay l\u1eadp t\u1ee9c k\u1ebft qu\u1ea3 d\u1ecbch s\u1ebd hi\u1ec3n th\u1ecb ra \u1edf \u00f4 tr\u1ed1ng c\u00f2n l\u1ea1i b\u00ean d\u01b0\u1edbi. R\u1ea5t \u0111\u01a1n gi\u1ea3n v\u00e0 ti\u1ec7n l\u1ee3i ph\u1ea3i kh\u00f4ng n\u00e0o !<\/p>\n

    \"\"<\/p>\n

    #3. L\u1eddi k\u1ebft<\/strong><\/span><\/h3>\n

    Okay, nh\u01b0 v\u1eady l\u00e0 m\u00ecnh \u0111\u00e3 h\u01b0\u1edbng d\u1eabn xong cho b\u1ea1n c\u00e1ch\u00a0d\u1ecbch ng\u00f4n ng\u1eef ngay tr\u00ean Excel<\/strong>\u00a0v\u00e0 Google Trang T\u00ednh r\u1ed3i nh\u00e9.<\/p>\n

    M\u1ed9t th\u1ee7 thu\u1eadt tuy nh\u1ecf nh\u01b0ng kh\u00e1 ti\u1ec7n \u00edch v\u00e0 h\u1eefu d\u1ee5ng ph\u1ea3i kh\u00f4ng c\u00e1c b\u1ea1n \u00a0\u1d54\u1d25\u1d54 Hy v\u1ecdng l\u00e0 m\u1eb9o nh\u1ecf n\u00e0y s\u1ebd gi\u00fap cho b\u1ea1n l\u00e0m vi\u1ec7c \u0111\u01b0\u1ee3c hi\u1ec7u qu\u1ea3 h\u01a1n.<\/p>\n

    N\u1ebfu b\u1ea1n th\u1ea5y b\u00e0i vi\u1ebft n\u00e0y hay th\u00ec \u0111\u1eebng qu\u00ean chia s\u1ebb cho m\u1ecdi ng\u01b0\u1eddi c\u00f9ng h\u1ecdc h\u1ecfi n\u1eefa nh\u00e9. Ch\u00fac c\u00e1c b\u1ea1n th\u00e0nh c\u00f4ng.<\/p>\n","protected":false},"excerpt":{"rendered":"

    #1. C\u00e1ch d\u1ecbch v\u0103n b\u1ea3n c\u1ef1c nhanh tr\u00ean Google Spreadsheets Google Spreadsheets\u00a0hay c\u00f2n g\u1ecdi l\u00e0\u00a0Google Trang T\u00ednh, n\u00f3 c\u0169ng t\u01b0\u01a1ng t\u1ef1 nh\u01b0 \u1ee9ng d\u1ee5ng Excel c\u1ee7a Microsoft v\u1eady. Th\u1ee7 thu\u1eadt n\u00e0y \u0111\u01b0\u1ee3c chia s\u1ebb b\u1edfi trang Jake Miller Tech, m\u00ecnh l\u01b0\u1edbt Facebook th\u1ea5y hay n\u00ean m\u00ecnh quy\u1ebft \u0111\u1ecbnh vi\u1ebft b\u00e0i n\u00e0y \u0111\u1ec3 chia s\u1ebb l\u1ea1i […]<\/p>\n","protected":false},"author":3,"featured_media":8237,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[506],"tags":[],"class_list":["post-8231","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-thu-thuat"],"_links":{"self":[{"href":"https:\/\/tct.vn\/blog\/wp-json\/wp\/v2\/posts\/8231","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/tct.vn\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/tct.vn\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/tct.vn\/blog\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/tct.vn\/blog\/wp-json\/wp\/v2\/comments?post=8231"}],"version-history":[{"count":0,"href":"https:\/\/tct.vn\/blog\/wp-json\/wp\/v2\/posts\/8231\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/tct.vn\/blog\/wp-json\/wp\/v2\/media\/8237"}],"wp:attachment":[{"href":"https:\/\/tct.vn\/blog\/wp-json\/wp\/v2\/media?parent=8231"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/tct.vn\/blog\/wp-json\/wp\/v2\/categories?post=8231"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/tct.vn\/blog\/wp-json\/wp\/v2\/tags?post=8231"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}