{"id":4204,"date":"2025-11-10T19:42:37","date_gmt":"2025-11-10T12:42:37","guid":{"rendered":"https:\/\/autofillform.com\/blog\/nhung-thu-ma-google-sheet-lam-duoc-ma-excel-chua-co\/"},"modified":"2025-11-10T19:42:37","modified_gmt":"2025-11-10T12:42:37","slug":"nhung-thu-ma-google-sheet-lam-duoc-ma-excel-chua-co","status":"publish","type":"post","link":"https:\/\/autofillform.com\/blog\/nhung-thu-ma-google-sheet-lam-duoc-ma-excel-chua-co\/","title":{"rendered":"Nh\u1eefng th\u1ee9 m\u00e0 Google Sheet l\u00e0m \u0111\u01b0\u1ee3c m\u00e0 Excel ch\u01b0a c\u00f3"},"content":{"rendered":"
\n

Google Sheet ng\u00e0y c\u00e0ng \u0111\u01b0\u1ee3c \u01b0a chu\u1ed9ng kh\u00f4ng ch\u1ec9 b\u1edfi t\u00ednh ti\u1ec7n l\u1ee3i m\u00e0 c\u00f2n nh\u1edd h\u00e0ng lo\u1ea1t t\u00ednh n\u0103ng th\u00f4ng minh v\u01b0\u1ee3t tr\u1ed9i so v\u1edbi Excel. T\u1eeb vi\u1ec7c theo d\u00f5i ch\u1ee9ng kho\u00e1n, d\u1ecbch ng\u00f4n ng\u1eef t\u1ef1 \u0111\u1ed9ng cho \u0111\u1ebfn chia s\u1ebb v\u00e0 ch\u1ec9nh s\u1eeda theo th\u1eddi gian th\u1ef1c, t\u1ea5t c\u1ea3 \u0111\u1ec1u \u0111\u01b0\u1ee3c t\u00edch h\u1ee3p linh ho\u1ea1t tr\u00ean n\u1ec1n t\u1ea3ng tr\u1ef1c tuy\u1ebfn. C\u00f9ng kh\u00e1m ph\u00e1 nh\u1eefng th\u1ee9 m\u00e0 Google Sheet l\u00e0m \u0111\u01b0\u1ee3c m\u00e0 Excel ch\u01b0a c\u00f3 ngay d\u01b0\u1edbi \u0111\u00e2y.<\/p>\n

\"\u0110i\u1ec3mNh\u1eefng t\u00ednh n\u0103ng n\u1ed5i b\u1eadt c\u1ee7a Google Sheet m\u00e0 Excel ch\u01b0a c\u00f3<\/em><\/p>\n

\n

1. Theo d\u00f5i bi\u1ebfn \u0111\u1ed9ng ch\u1ee9ng kho\u00e1n b\u1eb1ng Google Finance<\/h2>\n<\/div>\n

M\u1ed9t trong nh\u1eefng \u01b0u \u0111i\u1ec3m n\u1ed5i b\u1eadt c\u1ee7a Google Sheet l\u00e0 kh\u1ea3 n\u0103ng c\u1eadp nh\u1eadt v\u00e0 theo d\u00f5i th\u00f4ng tin t\u00e0i ch\u00ednh, ch\u1ee9ng kho\u00e1n c\u1ef1c k\u1ef3 ti\u1ec7n l\u1ee3i.<\/p>\n

Nh\u1edd c\u00f3 h\u00e0m GOOGLEFINANCE, ng\u01b0\u1eddi d\u00f9ng c\u00f3 th\u1ec3 l\u1ea5y d\u1eef li\u1ec7u tr\u1ef1c ti\u1ebfp t\u1eeb h\u1ec7 th\u1ed1ng Google Finance ch\u1ec9 trong v\u00e0i gi\u00e2y. Trong b\u1ea3ng t\u00ednh Google Sheet, b\u1ea1n ch\u1ec9 c\u1ea7n nh\u1eadp c\u00f4ng th\u1ee9c sau v\u00e0o m\u1ed9t \u00f4 b\u1ea5t k\u1ef3:<\/p>\n

=GOOGLEFINANCE(“m\u00e3_ch\u1ee9ng_kho\u00e1n”)<\/strong><\/p>\n

Ngay sau \u0111\u00f3, Google Sheet s\u1ebd t\u1ef1 \u0111\u1ed9ng hi\u1ec3n th\u1ecb th\u00f4ng tin li\u00ean quan \u0111\u1ebfn m\u00e3 ch\u1ee9ng kho\u00e1n m\u00e0 b\u1ea1n mu\u1ed1n theo d\u00f5i – gi\u00fap vi\u1ec7c c\u1eadp nh\u1eadt gi\u00e1 v\u00e0 xu h\u01b0\u1edbng th\u1ecb tr\u01b0\u1eddng tr\u1edf n\u00ean nhanh ch\u00f3ng, ch\u00ednh x\u00e1c v\u00e0 ho\u00e0n to\u00e0n t\u1ef1 \u0111\u1ed9ng.<\/p>\n

\"TheoC\u1eadp nh\u1eadt ch\u1ec9 s\u1ed1 ch\u1ee9ng kho\u00e1n t\u1ee9c th\u00ec ngay tr\u00ean Google Sheet<\/em><\/p>\n

\n

2. D\u1ecbch t\u1ef1 \u0111\u1ed9ng \u0111a ng\u00f4n ng\u1eef v\u1edbi Google Translate<\/h2>\n<\/div>\n

Google Sheet c\u00f2n h\u1ed7 tr\u1ee3 ng\u01b0\u1eddi d\u00f9ng d\u1ecbch t\u1ef1 \u0111\u1ed9ng gi\u1eefa nhi\u1ec1u ng\u00f4n ng\u1eef kh\u00e1c nhau th\u00f4ng qua h\u00e0m GOOGLETRANSLATE, gi\u00fap b\u1ea1n d\u1ec5 d\u00e0ng x\u1eed l\u00fd n\u1ed9i dung \u0111a ng\u00f4n ng\u1eef ngay trong b\u1ea3ng t\u00ednh.<\/p>\n

C\u00f4ng th\u1ee9c s\u1eed d\u1ee5ng nh\u01b0 sau:<\/p>\n

=GOOGLETRANSLATE(v\u0103n_b\u1ea3n; [ng\u00f4n_ng\u1eef_ngu\u1ed3n];[ng\u00f4n_ng\u1eef_\u0111\u00edch])<\/strong><\/p>\n

Trong \u0111\u00f3:<\/p>\n

    \n
  • v\u0103n_b\u1ea3n:<\/strong> l\u00e0 \u0111o\u1ea1n n\u1ed9i dung ho\u1eb7c t\u1eeb c\u1ea7n d\u1ecbch.<\/li>\n
  • ng\u00f4n_ng\u1eef_ngu\u1ed3n: <\/strong>m\u00e3 g\u1ed3m hai k\u00fd t\u1ef1 th\u1ec3 hi\u1ec7n ng\u00f4n ng\u1eef g\u1ed1c, v\u00ed d\u1ee5 “en” cho ti\u1ebfng Anh, “vi” cho ti\u1ebfng Vi\u1ec7t, “ko” cho ti\u1ebfng H\u00e0n, ho\u1eb7c “auto” \u0111\u1ec3 Google t\u1ef1 nh\u1eadn di\u1ec7n ng\u00f4n ng\u1eef.<\/li>\n
  • ng\u00f4n_ng\u1eef_\u0111\u00edch:<\/strong> m\u00e3 g\u1ed3m hai k\u00fd t\u1ef1 th\u1ec3 hi\u1ec7n ng\u00f4n ng\u1eef mu\u1ed1n d\u1ecbch sang.<\/li>\n<\/ul>\n

    V\u00ed d\u1ee5:<\/strong>=GOOGLETRANSLATE(“Apple”; “en”; “vi”)<\/strong> \u2192 K\u1ebft qu\u1ea3: \u201cQu\u1ea3 t\u00e1o<\/strong>\u201d.<\/p>\n

    T\u00ednh n\u0103ng n\u00e0y r\u1ea5t h\u1eefu \u00edch cho ng\u01b0\u1eddi l\u00e0m vi\u1ec7c v\u1edbi d\u1eef li\u1ec7u qu\u1ed1c t\u1ebf, gi\u00fap ti\u1ebft ki\u1ec7m th\u1eddi gian v\u00e0 \u0111\u1ea3m b\u1ea3o t\u00ednh linh ho\u1ea1t khi x\u1eed l\u00fd th\u00f4ng tin.<\/p>\n

    \"D\u1ecbchD\u1ec5 d\u00e0ng d\u1ecbch song ng\u1eef tr\u1ef1c ti\u1ebfp trong b\u1ea3ng t\u00ednh Google Sheet<\/em><\/p>\n

    \n

    3. L\u01b0u tr\u1eef to\u00e0n b\u1ed9 l\u1ecbch s\u1eed phi\u00ean b\u1ea3n t\u00e0i li\u1ec7u<\/h2>\n<\/div>\n

    Trong qu\u00e1 tr\u00ecnh l\u00e0m vi\u1ec7c v\u1edbi Excel, ch\u1eafc h\u1eb3n b\u1ea1n t\u1eebng ph\u1ea3i l\u01b0u nhi\u1ec1u b\u1ea3n kh\u00e1c nhau nh\u01b0 v01, v02, v03\u2026 \u0111\u1ec3 theo d\u00f5i c\u00e1c l\u1ea7n ch\u1ec9nh s\u1eeda. Tuy nhi\u00ean, v\u1edbi Google Sheet, vi\u1ec7c n\u00e0y tr\u1edf n\u00ean \u0111\u01a1n gi\u1ea3n h\u01a1n r\u1ea5t nhi\u1ec1u. M\u1ecdi thay \u0111\u1ed5i c\u1ee7a b\u1ea1n \u0111\u1ec1u \u0111\u01b0\u1ee3c t\u1ef1 \u0111\u1ed9ng l\u01b0u l\u1ea1i th\u00e0nh c\u00e1c phi\u00ean b\u1ea3n kh\u00e1c nhau.<\/p>\n

    Khi c\u1ea7n xem ho\u1eb7c kh\u00f4i ph\u1ee5c l\u1ea1i n\u1ed9i dung c\u0169, b\u1ea1n ch\u1ec9 c\u1ea7n v\u00e0o File (T\u1ec7p)<\/strong> \u2192 See Revision History<\/strong> (Xem l\u1ecbch s\u1eed phi\u00ean b\u1ea3n) \u0111\u1ec3 xem danh s\u00e1ch c\u00e1c phi\u00ean b\u1ea3n tr\u01b0\u1edbc \u0111\u00f3 v\u00e0 ch\u1ecdn b\u1ea3n m\u00e0 b\u1ea1n mu\u1ed1n kh\u00f4i ph\u1ee5c.<\/p>\n

    \"XemXem l\u1ea1i v\u00e0 kh\u00f4i ph\u1ee5c c\u00e1c phi\u00ean b\u1ea3n c\u0169 ch\u1ec9 trong gi\u00e2y<\/em><\/p>\n

    Xem th\u00eam: <\/strong>Nguy\u00ean nh\u00e2n v\u00e0 c\u00e1ch s\u1eeda l\u1ed7i file Excel b\u1ecb tr\u1eafng c\u1ef1c \u0111\u01a1n gi\u1ea3n<\/div>\n
    \n

    4. Chia s\u1ebb v\u00e0 c\u1ed9ng t\u00e1c ch\u1ec9nh s\u1eeda linh ho\u1ea1t<\/h2>\n<\/div>\n

    M\u1ed9t \u01b0u \u0111i\u1ec3m kh\u00e1c gi\u00fap Google Sheet \u0111\u01b0\u1ee3c \u01b0a chu\u1ed9ng ch\u00ednh l\u00e0 kh\u1ea3 n\u0103ng chia s\u1ebb v\u00e0 ch\u1ec9nh s\u1eeda linh ho\u1ea1t theo th\u1eddi gian th\u1ef1c. C\u00f4ng c\u1ee5 n\u00e0y cho ph\u00e9p nhi\u1ec1u ng\u01b0\u1eddi c\u00f9ng m\u1edf, xem v\u00e0 ch\u1ec9nh s\u1eeda m\u1ed9t b\u1ea3ng t\u00ednh c\u00f9ng l\u00fac. B\u1ea1n th\u1eadm ch\u00ed c\u00f3 th\u1ec3 th\u1ea5y ai \u0111ang thao t\u00e1c tr\u00ean \u00f4 n\u00e0o, gi\u00fap qu\u00e1 tr\u00ecnh c\u1ed9ng t\u00e1c tr\u1edf n\u00ean nhanh ch\u00f3ng v\u00e0 minh b\u1ea1ch h\u01a1n.<\/p>\n

    Ngo\u00e0i ra, Google Sheet c\u00f2n t\u00edch h\u1ee3p t\u00ednh n\u0103ng tr\u00f2 chuy\u1ec7n nh\u00f3m (chat), gi\u00fap c\u00e1c th\u00e0nh vi\u00ean trao \u0111\u1ed5i tr\u1ef1c ti\u1ebfp trong khi l\u00e0m vi\u1ec7c, t\u1ed1i \u01b0u hi\u1ec7u qu\u1ea3 h\u1ee3p t\u00e1c m\u00e0 kh\u00f4ng c\u1ea7n chuy\u1ec3n sang n\u1ec1n t\u1ea3ng kh\u00e1c.<\/p>\n

    \"ChiaC\u00f9ng l\u00e0m vi\u1ec7c, ch\u1ec9nh s\u1eeda th\u1eddi gian th\u1ef1c ngay tr\u00ean c\u00f9ng file<\/em><\/p>\n

    \n

    5. T\u1ef1 \u0111\u1ed9ng sao l\u01b0u, \u0111\u1ea3m b\u1ea3o an to\u00e0n d\u1eef li\u1ec7u<\/h2>\n<\/div>\n

    To\u00e0n b\u1ed9 d\u1eef li\u1ec7u b\u1ea1n nh\u1eadp v\u00e0 ch\u1ec9nh s\u1eeda trong Google Sheet \u0111\u1ec1u \u0111\u01b0\u1ee3c t\u1ef1 \u0111\u1ed9ng l\u01b0u tr\u1eef tr\u00ean Google Drive, gi\u00fap \u0111\u1ea3m b\u1ea3o an to\u00e0n tuy\u1ec7t \u0111\u1ed1i cho t\u00e0i li\u1ec7u. Nh\u1edd c\u01a1 ch\u1ebf l\u01b0u li\u00ean t\u1ee5c n\u00e0y, b\u1ea1n kh\u00f4ng c\u1ea7n lo b\u1ecb m\u1ea5t d\u1eef li\u1ec7u khi g\u1eb7p s\u1ef1 c\u1ed1 nh\u01b0 m\u1ea5t \u0111i\u1ec7n hay h\u1ecfng m\u00e1y t\u00ednh.<\/p>\n

    B\u00ean c\u1ea1nh \u0111\u00f3, Google Drive c\u00f2n mang \u0111\u1ebfn s\u1ef1 linh ho\u1ea1t t\u1ed1i \u0111a, b\u1ea1n c\u00f3 th\u1ec3 m\u1edf v\u00e0 l\u00e0m vi\u1ec7c v\u1edbi file \u1edf b\u1ea5t k\u1ef3 \u0111\u00e2u, tr\u00ean b\u1ea5t k\u1ef3 thi\u1ebft b\u1ecb n\u00e0o c\u00f3 k\u1ebft n\u1ed1i Internet. Khi c\u1ea7n x\u1eed l\u00fd c\u00f4ng vi\u1ec7c g\u1ea5p, ch\u1ec9 c\u1ea7n truy c\u1eadp v\u00e0o Google Trang t\u00ednh l\u00e0 c\u00f3 th\u1ec3 ch\u1ec9nh s\u1eeda ngay, thay v\u00ec ph\u1ea3i g\u1eedi qua l\u1ea1i nhi\u1ec1u phi\u00ean b\u1ea3n nh\u01b0 khi s\u1eed d\u1ee5ng Excel truy\u1ec1n th\u1ed1ng.<\/p>\n

    \"N\u1ed9iT\u00ednh n\u0103ng t\u1ef1 \u0111\u1ed9ng sao l\u01b0u tr\u00ean Google Sheet<\/em><\/p>\n

    \n

    6. S\u1eed d\u1ee5ng mi\u1ec5n ph\u00ed, kh\u00f4ng c\u1ea7n c\u00e0i \u0111\u1eb7t<\/h2>\n<\/div>\n

    Google Drive cung c\u1ea5p cho ng\u01b0\u1eddi d\u00f9ng 15GB dung l\u01b0\u1ee3ng l\u01b0u tr\u1eef mi\u1ec5n ph\u00ed, \u0111\u1ee7 \u0111\u1ec3 l\u01b0u tr\u1eef h\u00e0ng ng\u00e0n t\u00e0i li\u1ec7u, h\u00ecnh \u1ea3nh v\u00e0 b\u1ea3ng t\u00ednh. N\u1ebfu c\u1ea7n th\u00eam kh\u00f4ng gian, b\u1ea1n ho\u00e0n to\u00e0n c\u00f3 th\u1ec3 n\u00e2ng c\u1ea5p g\u00f3i dung l\u01b0\u1ee3ng v\u1edbi chi ph\u00ed r\u1ea5t ph\u1ea3i ch\u0103ng.<\/p>\n

    \u0110i\u1ec1u n\u00e0y tr\u1edf th\u00e0nh m\u1ed9t l\u1ee3i th\u1ebf l\u1edbn c\u1ee7a h\u1ec7 sinh th\u00e1i Google, khi ng\u01b0\u1eddi d\u00f9ng c\u00f3 th\u1ec3 truy c\u1eadp v\u00e0 s\u1eed d\u1ee5ng m\u1ecdi t\u00ednh n\u0103ng m\u00e0 kh\u00f4ng c\u1ea7n mua b\u1ea3n quy\u1ec1n \u0111\u1eaft \u0111\u1ecf nh\u01b0 b\u1ed9 Microsoft Office truy\u1ec1n th\u1ed1ng.<\/p>\n

    \"GaoTruy c\u1eadp Google Sheet d\u1ec5 d\u00e0ng, s\u1eed d\u1ee5ng mi\u1ec5n ph\u00ed m\u1ecdi l\u00fac<\/em><\/p>\n

    Google Sheet mang \u0111\u1ebfn tr\u1ea3i nghi\u1ec7m l\u00e0m vi\u1ec7c linh ho\u1ea1t, ti\u1ec7n l\u1ee3i v\u00e0 th\u00f4ng minh h\u01a1n bao gi\u1edd h\u1ebft, t\u1eeb theo d\u00f5i ch\u1ee9ng kho\u00e1n, d\u1ecbch t\u1ef1 \u0111\u1ed9ng, l\u01b0u l\u1ecbch s\u1eed ch\u1ec9nh s\u1eeda \u0111\u1ebfn c\u1ed9ng t\u00e1c th\u1eddi gian th\u1ef1c v\u00e0 sao l\u01b0u an to\u00e0n. \u0110\u00e2y ch\u00ednh l\u00e0 nh\u1eefng \u0111i\u1ec3m m\u00e0 Excel kh\u00f3 c\u00f3 th\u1ec3 s\u00e1nh k\u1ecbp.<\/p>\n

    \u0110\u1eebng qu\u00ean theo d\u00f5i chuy\u00ean m\u1ee5c Kinh nghi\u1ec7m c\u1ee7a Si\u00eau Th\u1ecb \u0110i\u1ec7n M\u00e1y – N\u1ed9i Th\u1ea5t Ch\u1ee3 L\u1edbn \u0111\u1ec3 c\u1eadp nh\u1eadt th\u00eam nhi\u1ec1u m\u1eb9o h\u1eefu \u00edch kh\u00e1c.<\/p>\n

    N\u1ebfu b\u1ea1n \u0111ang t\u00ecm ki\u1ebfm ph\u1ee5 ki\u1ec7n vi t\u00ednh ch\u1ea5t l\u01b0\u1ee3ng, h\u00e3y truy c\u1eadp ngay Si\u00eau Th\u1ecb \u0110i\u1ec7n M\u00e1y – N\u1ed9i Th\u1ea5t Ch\u1ee3 L\u1edbn \u0111\u1ec3 kh\u00e1m ph\u00e1 nh\u1eefng s\u1ea3n ph\u1ea9m gi\u00fap t\u0103ng c\u01b0\u1eddng hi\u1ec7u qu\u1ea3 l\u00e0m vi\u1ec7c c\u1ee7a b\u1ea1n!<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"

    Google Sheet ng\u00e0y c\u00e0ng \u0111\u01b0\u1ee3c \u01b0a chu\u1ed9ng kh\u00f4ng ch\u1ec9 b\u1edfi t\u00ednh ti\u1ec7n l\u1ee3i m\u00e0 c\u00f2n nh\u1edd h\u00e0ng lo\u1ea1t t\u00ednh n\u0103ng th\u00f4ng minh v\u01b0\u1ee3t tr\u1ed9i so v\u1edbi Excel. T\u1eeb vi\u1ec7c theo d\u00f5i ch\u1ee9ng kho\u00e1n, d\u1ecbch ng\u00f4n ng\u1eef t\u1ef1 \u0111\u1ed9ng cho \u0111\u1ebfn chia s\u1ebb v\u00e0 ch\u1ec9nh s\u1eeda theo th\u1eddi gian th\u1ef1c, t\u1ea5t c\u1ea3 \u0111\u1ec1u \u0111\u01b0\u1ee3c t\u00edch h\u1ee3p […]<\/p>\n","protected":false},"author":1,"featured_media":4205,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[8],"tags":[],"class_list":["post-4204","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-thu-thuat"],"jetpack_featured_media_url":"https:\/\/autofillform.com\/blog\/wp-content\/uploads\/2025\/11\/19224.jpg","_links":{"self":[{"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/posts\/4204","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/comments?post=4204"}],"version-history":[{"count":0,"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/posts\/4204\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/media\/4205"}],"wp:attachment":[{"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/media?parent=4204"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/categories?post=4204"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/tags?post=4204"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}