{"id":4115,"date":"2025-11-06T23:55:53","date_gmt":"2025-11-06T16:55:53","guid":{"rendered":"http:\/\/htttdn.com\/?post_type=ht_kb&#038;p=4115"},"modified":"2025-11-06T23:59:37","modified_gmt":"2025-11-06T16:59:37","slug":"20-thu-thuat-google-sheet-nhat-dinh-ban-phai-biet","status":"publish","type":"ht_kb","link":"https:\/\/htttdn.com\/index.php\/tin-tuc\/20-thu-thuat-google-sheet-nhat-dinh-ban-phai-biet\/","title":{"rendered":"20+ Th\u1ee7 thu\u1eadt Google Sheet nh\u1ea5t \u0111\u1ecbnh b\u1ea1n ph\u1ea3i bi\u1ebft"},"content":{"rendered":"<p><span style=\"font-weight: 400;\">Google Sheets l\u00e0 m\u1ed9t c\u00f4ng c\u1ee5 b\u1ea3ng t\u00ednh v\u00f4 c\u00f9ng h\u1eefu \u00edch v\u1edbi c\u00e1c t\u00ednh n\u0103ng th\u00fa v\u1ecb v\u00e0 nhi\u1ec1u th\u1ee7 thu\u1eadt Google sheet m\u00e0 h\u1ea7u h\u1ebft ng\u01b0\u1eddi d\u00f9ng ch\u01b0a khai th\u00e1c h\u1ebft. C\u00f9ng <\/span><a href=\"https:\/\/fast.com.vn\/\" target=\"_blank\" rel=\"noopener noreferrer\"><span style=\"font-weight: 400;\">FAST <\/span><\/a><span style=\"font-weight: 400;\">t\u00ecm hi\u1ec3u ngay nh\u00e9!<\/span><\/p>\n<p><img loading=\"lazy\" class=\"alignnone size-full wp-image-4116\" src=\"http:\/\/htttdn.com\/wp-content\/uploads\/2025\/11\/thu-thuat-gg-sheet.jpg\" alt=\"thu-thuat-gg-sheet\" width=\"1200\" height=\"628\" srcset=\"https:\/\/htttdn.com\/wp-content\/uploads\/2025\/11\/thu-thuat-gg-sheet.jpg 1200w, https:\/\/htttdn.com\/wp-content\/uploads\/2025\/11\/thu-thuat-gg-sheet-300x157.jpg 300w, https:\/\/htttdn.com\/wp-content\/uploads\/2025\/11\/thu-thuat-gg-sheet-1024x536.jpg 1024w, https:\/\/htttdn.com\/wp-content\/uploads\/2025\/11\/thu-thuat-gg-sheet-768x402.jpg 768w, https:\/\/htttdn.com\/wp-content\/uploads\/2025\/11\/thu-thuat-gg-sheet-50x26.jpg 50w, https:\/\/htttdn.com\/wp-content\/uploads\/2025\/11\/thu-thuat-gg-sheet-60x31.jpg 60w, https:\/\/htttdn.com\/wp-content\/uploads\/2025\/11\/thu-thuat-gg-sheet-100x52.jpg 100w\" sizes=\"(max-width: 1200px) 100vw, 1200px\" \/><\/p>\n<h2><span style=\"font-weight: 400;\">Ch\u00e8n \u1ea3nh v\u00e0o b\u00ean trong Google Sheets<\/span><\/h2>\n<p><span style=\"font-weight: 400;\">Tr\u00ean th\u1ef1c t\u1ebf b\u1ea3ng d\u1eef li\u1ec7u Google kh\u00f4ng ch\u1ec9 c\u00f3 c\u00e1c h\u00e0ng v\u00e0 c\u1ed9t d\u1eef li\u1ec7u m\u00e0 ng\u01b0\u1eddi d\u00f9ng c\u00f3 th\u1ec3 ch\u00e8n th\u00eam h\u00ecnh \u1ea3nh v\u00e0o b\u1ea3ng t\u00ednh \u0111\u1ec3 th\u00eam m\u1ed9t c\u00e1ch th\u1ec3 hi\u1ec7n tr\u1ef1c quan h\u00f3a d\u1eef li\u1ec7u c\u1ee7a m\u00ecnh.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">\u0110\u1ec3 s\u1eed d\u1ee5ng t\u00ednh n\u0103ng n\u00e0y, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng h\u00e0m IMAGE v\u1edbi c\u00f4ng th\u1ee9c \u0111\u1ea7y \u0111\u1ee7 nh\u01b0 sau:<\/span><\/p>\n<p><i><span style=\"font-weight: 400;\">=IMAGE (url, [mode], [height], [width])<\/span><\/i><\/p>\n<p><img loading=\"lazy\" class=\"alignnone size-full wp-image-4117\" src=\"http:\/\/htttdn.com\/wp-content\/uploads\/2025\/11\/img_1-image-in-sheets.jpg\" alt=\"\" width=\"850\" height=\"347\" srcset=\"https:\/\/htttdn.com\/wp-content\/uploads\/2025\/11\/img_1-image-in-sheets.jpg 850w, https:\/\/htttdn.com\/wp-content\/uploads\/2025\/11\/img_1-image-in-sheets-300x122.jpg 300w, https:\/\/htttdn.com\/wp-content\/uploads\/2025\/11\/img_1-image-in-sheets-768x314.jpg 768w, https:\/\/htttdn.com\/wp-content\/uploads\/2025\/11\/img_1-image-in-sheets-50x20.jpg 50w, https:\/\/htttdn.com\/wp-content\/uploads\/2025\/11\/img_1-image-in-sheets-60x24.jpg 60w, https:\/\/htttdn.com\/wp-content\/uploads\/2025\/11\/img_1-image-in-sheets-100x41.jpg 100w\" sizes=\"(max-width: 850px) 100vw, 850px\" \/><\/p>\n<h2><span style=\"font-weight: 400;\">Th\u1ee7 thu\u1eadt Google sheet v\u1edbi ph\u00edm t\u1eaft<\/span><\/h2>\n<h3><b>T\u1ea1o trang t\u00ednh m\u1edbi<\/b><\/h3>\n<p><span style=\"font-weight: 400;\">L\u1ea7n t\u1edbi khi b\u1ea1n c\u1ea7n t\u1ea1o m\u1ed9t Google Sheet, b\u1ea1n kh\u00f4ng c\u1ea7n m\u1edf trang Google Sheets v\u00e0 nh\u1ea5p v\u00e0o n\u00fat t\u1ea1o m\u1edbi n\u1eefa.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Thay v\u00e0o \u0111\u00f3, b\u1ea1n ch\u1ec9 c\u1ea7n nh\u1eadp \u201csheet.new\u201d tr\u1ef1c ti\u1ebfp v\u00e0o thanh \u0111\u1ecba ch\u1ec9 c\u1ee7a tr\u00ecnh duy\u1ec7t (tr\u01b0\u1edbc \u0111\u00f3 \u0111\u00e3 \u0111\u0103ng nh\u1eadp v\u00e0o t\u00e0i kho\u1ea3n Google), thao t\u00e1c n\u00e0y s\u1ebd t\u1ea1o m\u1ed9t b\u1ea3ng t\u00ednh m\u1edbi cho b\u1ea1n.<\/span><\/p>\n<h3><b>Ph\u00edm t\u1eaft ch\u00e8n ng\u00e0y, gi\u1edd<\/b><\/h3>\n<p><span style=\"font-weight: 400;\">Nh\u1ea5n Ctrl ho\u1eb7c Cmd v\u00e0 ph\u00edm ch\u1ea5m ph\u1ea9y (;) \u0111\u1ec3 th\u00eam ng\u00e0y<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Ctrl ho\u1eb7c Cmd c\u00f9ng v\u1edbi Shift v\u00e0 ph\u00edm ch\u1ea5m ph\u1ea9y (;) \u0111\u1ec3 th\u00eam th\u1eddi gian<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Ctrl ho\u1eb7c Cmd c\u00f9ng v\u1edbi Alt v\u00e0 Shift v\u00e0 ph\u00edm ch\u1ea5m ph\u1ea9y (;) \u0111\u1ec3 th\u00eam ng\u00e0y v\u00e0 gi\u1edd c\u00f9ng nhau.<\/span><\/p>\n<figure id=\"attachment_4118\" aria-describedby=\"caption-attachment-4118\" style=\"width: 722px\" class=\"wp-caption alignnone\"><img loading=\"lazy\" class=\"size-full wp-image-4118\" src=\"http:\/\/htttdn.com\/wp-content\/uploads\/2025\/11\/img_phim-tat-them-gio-trong-google-sheet.jpg\" alt=\"Th\u1ee7 thu\u1eadt google sheet ch\u00e8n th\u1eddi gian\" width=\"722\" height=\"148\" srcset=\"https:\/\/htttdn.com\/wp-content\/uploads\/2025\/11\/img_phim-tat-them-gio-trong-google-sheet.jpg 722w, https:\/\/htttdn.com\/wp-content\/uploads\/2025\/11\/img_phim-tat-them-gio-trong-google-sheet-300x61.jpg 300w, https:\/\/htttdn.com\/wp-content\/uploads\/2025\/11\/img_phim-tat-them-gio-trong-google-sheet-50x10.jpg 50w, https:\/\/htttdn.com\/wp-content\/uploads\/2025\/11\/img_phim-tat-them-gio-trong-google-sheet-60x12.jpg 60w, https:\/\/htttdn.com\/wp-content\/uploads\/2025\/11\/img_phim-tat-them-gio-trong-google-sheet-100x20.jpg 100w\" sizes=\"(max-width: 722px) 100vw, 722px\" \/><figcaption id=\"caption-attachment-4118\" class=\"wp-caption-text\">Th\u1ee7 thu\u1eadt google sheet ch\u00e8n th\u1eddi gian<\/figcaption><\/figure>\n<h3><b>S\u1eed d\u1ee5ng ph\u00edm t\u1eaft \u0111\u1ec3 \u0111\u1ecbnh d\u1ea1ng nhanh<\/b><\/h3>\n<p><span style=\"font-weight: 400;\">Ctrl-Shift-1: \u0110\u1ecbnh d\u1ea1ng d\u01b0\u1edbi d\u1ea1ng th\u1eadp ph\u00e2n<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Ctrl-Shift-2: \u0110\u1ecbnh d\u1ea1ng theo th\u1eddi gian<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Ctrl-Shift-3: \u0110\u1ecbnh d\u1ea1ng d\u01b0\u1edbi d\u1ea1ng ng\u00e0y<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Ctrl-Shift-4: \u0110\u1ecbnh d\u1ea1ng d\u01b0\u1edbi d\u1ea1ng ti\u1ec1n t\u1ec7<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Ctrl-Shift-5: \u0110\u1ecbnh d\u1ea1ng theo ph\u1ea7n tr\u0103m<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Ctrl-Shift-6: \u0110\u1ecbnh d\u1ea1ng d\u01b0\u1edbi d\u1ea1ng s\u1ed1 m\u0169<\/span><\/p>\n<h2><span style=\"font-weight: 400;\">Th\u1ee7 thu\u1eadt Google Sheet d\u00f9ng h\u00e0m, c\u00f4ng th\u1ee9c x\u1eed l\u00fd d\u1eef li\u1ec7u<\/span><\/h2>\n<h3><b>H\u00e0m IMPORTRANGE l\u1ea5y d\u1eef li\u1ec7u t\u1eeb sheet n\u00e0y sang sheet kh\u00e1c<\/b><\/h3>\n<p><span style=\"font-weight: 400;\">N\u1ebfu b\u1ea1n mu\u1ed1n l\u1ea5y m\u1ed9t c\u1ed9t d\u1eef li\u1ec7u c\u1ee5 th\u1ec3 t\u1eeb b\u1ea3ng n\u00e0y sang b\u1ea3ng kh\u00e1c, b\u1ea1n h\u00e3y s\u1eed d\u1ee5ng h\u00e0m IMPORTRANGE trong Google sheet, v\u00ed d\u1ee5:<\/span><\/p>\n<p><i><span style=\"font-weight: 400;\">=IMPORTRANGE(&#8220;https:\/\/docs.google.com\/spreadsheets\/d\/1aBcDEf&#8221;, &#8220;Sheet1!D1:D15&#8221;)<\/span><\/i><\/p>\n<p><span style=\"font-weight: 400;\">trong \u0111\u00f3:<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">URL trong c\u00f4ng th\u1ee9c tr\u00ean l\u00e0 sheet ch\u1ee9a d\u1eef li\u1ec7u mu\u1ed1n l\u1ea5y.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Sheet1! D1: D15: \u0111\u00e2y l\u00e0 ph\u1ea1m vi d\u1eef li\u1ec7u (D1:D5) mu\u1ed1n l\u1ea5y t\u1eeb Sheet 1<\/span><\/li>\n<\/ul>\n<p><span style=\"font-weight: 400;\">Sau \u0111\u00f3, nh\u1ea5p v\u00e0o m\u1ed9t n\u00fat \u0111\u1ec3 cho ph\u00e9p hai trang t\u00ednh \u0111\u01b0\u1ee3c k\u1ebft n\u1ed1i v\u00e0 sau \u0111\u00f3 t\u1ea5t c\u1ea3 d\u1eef li\u1ec7u t\u1eeb trang t\u00ednh ngu\u1ed3n c\u1ee7a b\u1ea1n s\u1ebd xu\u1ea5t hi\u1ec7n m\u1ed9t c\u00e1ch k\u1ef3 di\u1ec7u.<\/span><\/p>\n<p><img loading=\"lazy\" class=\"alignnone size-full wp-image-4119\" src=\"http:\/\/htttdn.com\/wp-content\/uploads\/2025\/11\/img_hien-thi-du-lieu-bang-ham-importrange-trong-google-sheet.jpg\" alt=\"\" width=\"720\" height=\"375\" srcset=\"https:\/\/htttdn.com\/wp-content\/uploads\/2025\/11\/img_hien-thi-du-lieu-bang-ham-importrange-trong-google-sheet.jpg 720w, https:\/\/htttdn.com\/wp-content\/uploads\/2025\/11\/img_hien-thi-du-lieu-bang-ham-importrange-trong-google-sheet-300x156.jpg 300w, https:\/\/htttdn.com\/wp-content\/uploads\/2025\/11\/img_hien-thi-du-lieu-bang-ham-importrange-trong-google-sheet-50x26.jpg 50w, https:\/\/htttdn.com\/wp-content\/uploads\/2025\/11\/img_hien-thi-du-lieu-bang-ham-importrange-trong-google-sheet-60x31.jpg 60w, https:\/\/htttdn.com\/wp-content\/uploads\/2025\/11\/img_hien-thi-du-lieu-bang-ham-importrange-trong-google-sheet-100x52.jpg 100w\" sizes=\"(max-width: 720px) 100vw, 720px\" \/><\/p>\n<h3><b>H\u00e0m IMPORTHTML l\u1ea5y d\u1eef li\u1ec7u t\u1eeb web<\/b><\/h3>\n<p><span style=\"font-weight: 400;\">Trang t\u00ednh c\u0169ng c\u00f3 th\u1ec3 l\u1ea5y d\u1eef li\u1ec7u t\u1eeb b\u1ea5t k\u1ef3 trang web c\u00f4ng khai n\u00e0o, mi\u1ec5n l\u00e0 trang \u0111\u00f3 c\u00f3 b\u1ea3ng \u0111\u01b0\u1ee3c \u0111\u1ecbnh d\u1ea1ng \u0111\u00fang. Ta d\u00f9ng h\u00e0m IMPORTHTML trong Google Sheet nh\u01b0 sau:\u00a0<\/span><\/p>\n<p><i><span style=\"font-weight: 400;\">=IMPORTHTML(&#8220;https:\/\/en.wikipedia.org\/wiki\/List_of_sandwiches&#8221;, &#8220;table&#8221;, 1)<\/span><\/i><\/p>\n<p><span style=\"font-weight: 400;\">Ta s\u1eed d\u1ee5ng h\u00e0m v\u1edbi b\u1ea5t k\u1ef3 URL n\u00e0o b\u1ea1n c\u1ea7n v\u00e0 s\u1ed1 cho bi\u1ebft b\u1ea3ng n\u00e0o tr\u00ean trang b\u1ea1n mu\u1ed1n nh\u1eadp (\u201c1\u201d cho b\u1ea3ng \u0111\u1ea7u ti\u00ean, \u201c2\u201d cho b\u1ea3ng th\u1ee9 hai, v.v.). C\u1ee9 nh\u01b0 v\u1eady, t\u1ea5t c\u1ea3 th\u00f4ng tin s\u1ebd xu\u1ea5t hi\u1ec7n trong b\u1ea3ng t\u00ednh c\u1ee7a b\u1ea1n.<\/span><\/p>\n<p><img loading=\"lazy\" class=\"alignnone size-full wp-image-4120\" src=\"http:\/\/htttdn.com\/wp-content\/uploads\/2025\/11\/img_4004_1.jpg\" alt=\"\" width=\"610\" height=\"439\" srcset=\"https:\/\/htttdn.com\/wp-content\/uploads\/2025\/11\/img_4004_1.jpg 610w, https:\/\/htttdn.com\/wp-content\/uploads\/2025\/11\/img_4004_1-300x216.jpg 300w, https:\/\/htttdn.com\/wp-content\/uploads\/2025\/11\/img_4004_1-50x36.jpg 50w, https:\/\/htttdn.com\/wp-content\/uploads\/2025\/11\/img_4004_1-60x43.jpg 60w, https:\/\/htttdn.com\/wp-content\/uploads\/2025\/11\/img_4004_1-100x72.jpg 100w\" sizes=\"(max-width: 610px) 100vw, 610px\" \/><\/p>\n<h3><b>H\u00e0m TRIM \u0111\u1ec3 x\u00f3a kho\u1ea3ng tr\u1eafng th\u1eeba<\/b><\/h3>\n<p><span style=\"font-weight: 400;\">N\u1ebfu b\u1ea1n ph\u00e1t hi\u1ec7n ra m\u1ed9t s\u1ed1 kho\u1ea3ng tr\u1eafng th\u1eeba tr\u01b0\u1edbc ho\u1eb7c sau d\u1eef li\u1ec7u trong b\u1ea3ng t\u00ednh, h\u00e3y d\u00f9ng TRIM c\u1ee7a Google Sheets.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">N\u1ebfu b\u1ea1n mu\u1ed1n th\u1ef1c hi\u1ec7n h\u00e0m cho nhi\u1ec1u \u00f4 c\u00f9ng m\u1ed9t l\u00fac, h\u00e3y s\u1eed d\u1ee5ng \u0111\u1ecbnh d\u1ea1ng n\u00e0y cho b\u1ea5t k\u1ef3 ph\u1ea1m vi n\u00e0o b\u1ea1n c\u1ea7n:<\/span><\/p>\n<p><i><span style=\"font-weight: 400;\">= ArrayFormula (TRIM (A2: A50))<\/span><\/i><\/p>\n<p><img loading=\"lazy\" class=\"alignnone size-full wp-image-4121\" src=\"http:\/\/htttdn.com\/wp-content\/uploads\/2025\/11\/img_ham-trim-trong-google-sheet-de-xoa-khoang-trang.jpg\" alt=\"\" width=\"626\" height=\"302\" srcset=\"https:\/\/htttdn.com\/wp-content\/uploads\/2025\/11\/img_ham-trim-trong-google-sheet-de-xoa-khoang-trang.jpg 626w, https:\/\/htttdn.com\/wp-content\/uploads\/2025\/11\/img_ham-trim-trong-google-sheet-de-xoa-khoang-trang-300x145.jpg 300w, https:\/\/htttdn.com\/wp-content\/uploads\/2025\/11\/img_ham-trim-trong-google-sheet-de-xoa-khoang-trang-50x24.jpg 50w, https:\/\/htttdn.com\/wp-content\/uploads\/2025\/11\/img_ham-trim-trong-google-sheet-de-xoa-khoang-trang-60x29.jpg 60w, https:\/\/htttdn.com\/wp-content\/uploads\/2025\/11\/img_ham-trim-trong-google-sheet-de-xoa-khoang-trang-100x48.jpg 100w\" sizes=\"(max-width: 626px) 100vw, 626px\" \/><\/p>\n<h3><b>H\u00e0m LOWER, UPPER, PROPER \u0111\u1ec3 chu\u1ea9n h\u00f3a ch\u1eef hoa ch\u1eef th\u01b0\u1eddng<\/b><\/h3>\n<p><span style=\"font-weight: 400;\">File c\u1ee7a b\u1ea1n ch\u1ee9a nhi\u1ec1u \u0111o\u1ea1n ch\u1eef hoa l\u1eabn ch\u1eef th\u01b0\u1eddng l\u1ed9n x\u1ed9n th\u00ec h\u00e3y tham kh\u1ea3o nh\u1eefng c\u00f4ng th\u1ee9c d\u01b0\u1edbi \u0111\u00e2y:<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">UPPER (A1)<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">LOWER (A1)<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">PROPER (A1)<\/span><\/li>\n<\/ul>\n<h3><b>H\u00e0m ISEMAIL \u0111\u1ec3 ki\u1ec3m tra danh s\u00e1ch \u0111\u1ecba ch\u1ec9 email<\/b><\/h3>\n<p><span style=\"font-weight: 400;\">C\u00f3 th\u1ec3 b\u1ea1n c\u00f3 m\u1ed9t danh s\u00e1ch \u0111\u1ecba ch\u1ec9 email c\u1ea7n g\u1eedi. B\u1ea1n c\u00f3 th\u1ec3 nh\u1edd Google Sheets xem qua ch\u00fang c\u00f3 \u0111\u01b0\u1ee3c \u0111\u1ecbnh d\u1ea1ng \u0111\u00fang hay kh\u00f4ng v\u1edbi c\u00f4ng th\u1ee9c:<\/span><\/p>\n<p><i><span style=\"font-weight: 400;\">= ArrayFormula (ISEMAIL (A2: A50))<\/span><\/i><\/p>\n<p><span style=\"font-weight: 400;\">Trang t\u00ednh s\u1ebd cung c\u1ea5p cho b\u1ea1n c\u00e2u tr\u1ea3 l\u1eddi \u201c\u0110\u00daNG\u201d ho\u1eb7c \u201cSAI\u201d cho m\u1ecdi \u0111\u1ecba ch\u1ec9 email m\u00e0 b\u1ea1n cung c\u1ea5p. ArrayFormula d\u00f9ng \u0111\u1ec3 tham chi\u1ebfu theo d\u1ea3i \u00f4.<\/span><\/p>\n<h3><b>H\u00e0m\u00a0 ISURL gi\u00fap x\u00e1c th\u1ef1c URL<\/b><\/h3>\n<p><span style=\"font-weight: 400;\">B\u1ea1n c\u0169ng c\u00f3 th\u1ec3 x\u00e1c th\u1ef1c URL trong b\u1ea3ng t\u00ednh \u0111\u1ec3 \u0111\u1ea3m b\u1ea3o r\u1eb1ng b\u1ea1n kh\u00f4ng c\u00f3 b\u1ea5t k\u1ef3 m\u1ee5c n\u00e0o kh\u00f4ng ph\u00f9 h\u1ee3p trong danh s\u00e1ch c\u1ee7a m\u00ecnh. H\u00e3y s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c m\u1ea3ng v\u1edbi ArrayFormula \u0111\u1ec3 thao t\u00e1c nhanh h\u01a1n:<\/span><\/p>\n<p><i><span style=\"font-weight: 400;\">= ArrayFormula (ISURL (A2: A50))<\/span><\/i><\/p>\n<p><span style=\"font-weight: 400;\">Trang t\u00ednh s\u1ebd cung c\u1ea5p cho b\u1ea1n c\u00e2u tr\u1ea3 l\u1eddi \u201c\u0110\u00daNG\u201d ho\u1eb7c \u201cSAI\u201d cho m\u1ecdi URL m\u00e0 b\u1ea1n c\u1ea7n ki\u1ec3m tra.<\/span><\/p>\n<h2><span style=\"font-weight: 400;\">Th\u1ee7 thu\u1eadt Google sheet \u0111\u1ec3 t\u00ednh to\u00e1n v\u00e0 ph\u00e2n t\u00edch d\u1eef li\u1ec7u<\/span><\/h2>\n<h3><b>Xem nhanh t\u1ed5ng, trung b\u00ecnh,\u2026 c\u1ee7a d\u00e3y \u00f4<\/b><\/h3>\n<p><span style=\"font-weight: 400;\">Theo m\u1eb7c \u0111\u1ecbnh, Google Sheets s\u1ebd hi\u1ec3n th\u1ecb cho b\u1ea1n t\u1ed5ng gi\u00e1 tr\u1ecb c\u00e1c \u00f4, h\u00e0ng\/ c\u1ed9t m\u00e0 b\u1ea1n ch\u1ecdn. Sau \u0111\u00f3, b\u1ea1n c\u00f3 th\u1ec3 nh\u1ea5p v\u00e0o h\u1ed9p c\u00f3 th\u00f4ng tin \u0111\u00f3 v\u00e0 y\u00eau c\u1ea7u n\u00f3 hi\u1ec3n th\u1ecb trung b\u00ecnh, t\u1ed1i thi\u1ec3u ho\u1eb7c t\u1ed1i \u0111a ho\u1eb7c t\u1ed5ng s\u1ed1.<\/span><\/p>\n<p><img loading=\"lazy\" class=\"alignnone size-full wp-image-4122\" src=\"http:\/\/htttdn.com\/wp-content\/uploads\/2025\/11\/img_tinh-tong-nhanh-trong-google-sheet.jpg\" alt=\"\" width=\"622\" height=\"424\" srcset=\"https:\/\/htttdn.com\/wp-content\/uploads\/2025\/11\/img_tinh-tong-nhanh-trong-google-sheet.jpg 622w, https:\/\/htttdn.com\/wp-content\/uploads\/2025\/11\/img_tinh-tong-nhanh-trong-google-sheet-300x205.jpg 300w, https:\/\/htttdn.com\/wp-content\/uploads\/2025\/11\/img_tinh-tong-nhanh-trong-google-sheet-50x34.jpg 50w, https:\/\/htttdn.com\/wp-content\/uploads\/2025\/11\/img_tinh-tong-nhanh-trong-google-sheet-60x41.jpg 60w, https:\/\/htttdn.com\/wp-content\/uploads\/2025\/11\/img_tinh-tong-nhanh-trong-google-sheet-100x68.jpg 100w\" sizes=\"(max-width: 622px) 100vw, 622px\" \/><\/p>\n<h3><b>H\u00e0m Sparkline t\u1ea1o bi\u1ec3u \u0111\u1ed3 nh\u1ecf trong m\u1ed9t \u00f4 duy nh\u1ea5t<\/b><\/h3>\n<p><span style=\"font-weight: 400;\">B\u1ea1n c\u00f3 th\u1ec3 t\u1ea1o m\u1ed9t bi\u1ec3u \u0111\u1ed3 nh\u1ecf trong m\u1ed9t \u00f4 duy nh\u1ea5t b\u1eb1ng h\u00e0m Sparkline ti\u1ec7n l\u1ee3i c\u1ee7a Sheets. Ch\u1ec9 c\u1ea7n nh\u1eadp l\u1ec7nh = SPARKLINE, nh\u01b0 c\u00f4ng th\u1ee9c b\u00ean d\u01b0\u1edbi:<\/span><\/p>\n<p><i><span style=\"font-weight: 400;\">=SPARKLINE(F3:Q3)<\/span><\/i><\/p>\n<p><img loading=\"lazy\" class=\"alignnone size-full wp-image-4123\" src=\"http:\/\/htttdn.com\/wp-content\/uploads\/2025\/11\/img_ham-ve-bieu-do-trong-google-sheet.jpg\" alt=\"\" width=\"764\" height=\"364\" srcset=\"https:\/\/htttdn.com\/wp-content\/uploads\/2025\/11\/img_ham-ve-bieu-do-trong-google-sheet.jpg 764w, https:\/\/htttdn.com\/wp-content\/uploads\/2025\/11\/img_ham-ve-bieu-do-trong-google-sheet-300x143.jpg 300w, https:\/\/htttdn.com\/wp-content\/uploads\/2025\/11\/img_ham-ve-bieu-do-trong-google-sheet-50x24.jpg 50w, https:\/\/htttdn.com\/wp-content\/uploads\/2025\/11\/img_ham-ve-bieu-do-trong-google-sheet-60x29.jpg 60w, https:\/\/htttdn.com\/wp-content\/uploads\/2025\/11\/img_ham-ve-bieu-do-trong-google-sheet-100x48.jpg 100w\" sizes=\"(max-width: 764px) 100vw, 764px\" \/><\/p>\n<p><span style=\"font-weight: 400;\">B\u00ean c\u1ea1nh \u0111\u00f3, b\u1ea1n c\u00f3 th\u1ec3 th\u00eam v\u00e0o c\u00f4ng th\u1ee9c m\u00e0u s\u1eafc, ph\u00e9p t\u00ednh, \u0111\u1ecbnh d\u1ea1ng,&#8230; \u0111\u1ec3 gi\u00fap bi\u1ec3u \u0111\u1ed3 nh\u1ecf c\u1ee7a b\u1ea1n tr\u00f4ng \u0111\u1eb9p m\u1eaft h\u01a1n.<\/span><\/p>\n<p><i><span style=\"font-weight: 400;\">=SPARKLINE(A1:A5, {&#8220;charttype&#8221;,&#8221;column&#8221;; &#8220;axis&#8221;, true; &#8220;axiscolor&#8221;, &#8220;red&#8221;})<\/span><\/i><\/p>\n<p><img loading=\"lazy\" class=\"alignnone size-full wp-image-4124\" src=\"http:\/\/htttdn.com\/wp-content\/uploads\/2025\/11\/img_4004_2.jpg\" alt=\"\" width=\"650\" height=\"274\" srcset=\"https:\/\/htttdn.com\/wp-content\/uploads\/2025\/11\/img_4004_2.jpg 650w, https:\/\/htttdn.com\/wp-content\/uploads\/2025\/11\/img_4004_2-300x126.jpg 300w, https:\/\/htttdn.com\/wp-content\/uploads\/2025\/11\/img_4004_2-50x21.jpg 50w, https:\/\/htttdn.com\/wp-content\/uploads\/2025\/11\/img_4004_2-60x25.jpg 60w, https:\/\/htttdn.com\/wp-content\/uploads\/2025\/11\/img_4004_2-100x42.jpg 100w\" sizes=\"(max-width: 650px) 100vw, 650px\" \/><\/p>\n<h3><b>T\u1ef1 \u0111\u1ed9ng ch\u1ecdn lo\u1ea1i bi\u1ec3u \u0111\u1ed3 th\u00edch h\u1ee3p v\u1edbi AI<\/b><\/h3>\n<p><span style=\"font-weight: 400;\">Khai th\u00e1c tr\u00ed th\u00f4ng minh nh\u00e2n t\u1ea1o c\u1ee7a Google v\u00e0 \u0111\u1ec3 Trang t\u00ednh th\u1ef1c hi\u1ec7n c\u00e1c lo\u1ea1i ph\u00e2n t\u00edch d\u1eef li\u1ec7u kh\u00e1c nhau v\u00e0 t\u1ea1o c\u00e1c bi\u1ec3u \u0111\u1ed3 ph\u1ee9c t\u1ea1p cho b\u1ea1n.\u00a0\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Di chu\u1ed9t qua bi\u1ec3u t\u01b0\u1ee3ng h\u00ecnh ng\u00f4i sao \u1edf g\u00f3c d\u01b0\u1edbi b\u00ean ph\u1ea3i m\u00e0n h\u00ecnh v\u00e0 b\u1ea1n s\u1ebd th\u1ea5y t\u1eeb \u201cExplore\u201d xu\u1ea5t hi\u1ec7n. Nh\u1ea5p v\u00e0o n\u00fat \u0111\u00f3 v\u00e0 Sheets s\u1ebd b\u1eadt l\u00ean m\u1ed9t b\u1ea3ng th\u00f4ng tin li\u00ean quan \u0111\u1ebfn d\u1eef li\u1ec7u c\u1ee7a b\u1ea1n.\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400;\">T\u00ednh n\u0103ng Explore c\u1ee7a Trang t\u00ednh s\u1eed d\u1ee5ng AI \u0111\u1ec3 cung c\u1ea5p cho b\u1ea1n t\u1ea5t c\u1ea3 c\u00e1c lo\u1ea1i bi\u1ec3u \u0111\u1ed3 v\u00e0 th\u00f4ng tin h\u1eefu \u00edch.<\/span><\/p>\n<p><img loading=\"lazy\" class=\"alignnone size-full wp-image-4125\" src=\"http:\/\/htttdn.com\/wp-content\/uploads\/2025\/11\/img_8-sheets-ai-view.jpg\" alt=\"S\u1eed d\u1ee5ng AI \u0111\u1ec3 t\u1ea1o bi\u1ec3u \u0111\u1ed3 v\u00e0 b\u00e1o c\u00e1o\" width=\"850\" height=\"515\" srcset=\"https:\/\/htttdn.com\/wp-content\/uploads\/2025\/11\/img_8-sheets-ai-view.jpg 850w, https:\/\/htttdn.com\/wp-content\/uploads\/2025\/11\/img_8-sheets-ai-view-300x182.jpg 300w, https:\/\/htttdn.com\/wp-content\/uploads\/2025\/11\/img_8-sheets-ai-view-768x465.jpg 768w, https:\/\/htttdn.com\/wp-content\/uploads\/2025\/11\/img_8-sheets-ai-view-50x30.jpg 50w, https:\/\/htttdn.com\/wp-content\/uploads\/2025\/11\/img_8-sheets-ai-view-60x36.jpg 60w, https:\/\/htttdn.com\/wp-content\/uploads\/2025\/11\/img_8-sheets-ai-view-100x61.jpg 100w\" sizes=\"(max-width: 850px) 100vw, 850px\" \/><\/p>\n<h2><span style=\"font-weight: 400;\">\u0110\u1ecbnh d\u1ea1ng b\u1ea3ng t\u00ednh m\u1ed9t c\u00e1ch chuy\u00ean nghi\u1ec7p<\/span><\/h2>\n<h3><b>\u1ea8n b\u1ea5t k\u1ef3 h\u00e0ng n\u00e0o<\/b><\/h3>\n<p><span style=\"font-weight: 400;\">Google Sheets cho ph\u00e9p b\u1ea1n \u1ea9n b\u1ea5t k\u1ef3 h\u00e0ng n\u00e0o b\u1ea1n mu\u1ed1n. Nh\u1ea5p v\u00e0o s\u1ed1 c\u1ee7a n\u00f3 trong c\u1ed9t m\u00e0u x\u00e1m \u1edf ngo\u00e0i c\u00f9ng b\u00ean tr\u00e1i c\u1ee7a m\u00e0n h\u00ecnh v\u00e0 ch\u1ecdn \u201c\u1ea8n h\u00e0ng\u201d t\u1eeb menu xu\u1ea5t hi\u1ec7n.<\/span><\/p>\n<h3><b>L\u00e0m trang t\u00ednh n\u1ed5i b\u1eadt<\/b><\/h3>\n<p><span style=\"font-weight: 400;\">T\u00ecm t\u00f9y ch\u1ecdn \u201cM\u00e0u thay th\u1ebf\u201d trong menu \u0110\u1ecbnh d\u1ea1ng c\u1ee7a Google sheets. B\u1ea1n s\u1ebd th\u1ea5y c\u00e1c t\u00f9y ch\u1ecdn \u0111\u01a1n gi\u1ea3n \u0111\u1ec3 \u00e1p d\u1ee5ng m\u1ed9t m\u1eabu m\u00e0u s\u1eafc n\u00e9t cho c\u00e1c h\u00e0ng.<\/span><\/p>\n<h3><b>Xoay v\u0103n b\u1ea3n ti\u00eau \u0111\u1ec1<\/b><\/h3>\n<p><span style=\"font-weight: 400;\">Xoay v\u0103n b\u1ea3n h\u00e0ng ti\u00eau \u0111\u1ec1 v\u00e0 th\u00eam m\u00e0u xen k\u1ebd l\u00e0 nh\u1eefng c\u00e1ch d\u1ec5 d\u00e0ng \u0111\u1ec3 mang l\u1ea1i s\u1ef1 h\u1ea5p d\u1eabn cho b\u1ea3ng t\u00ednh c\u1ee7a b\u1ea1n. H\u00e3y \u0111\u00e1nh d\u1ea5u h\u00e0ng, sau \u0111\u00f3 nh\u1ea5p v\u00e0o bi\u1ec3u t\u01b0\u1ee3ng hi\u1ec3n th\u1ecb ch\u1eef \u201cA\u201d g\u00f3c c\u1ea1nh v\u1edbi m\u0169i t\u00ean h\u01b0\u1edbng l\u00ean b\u00ean d\u01b0\u1edbi h\u00e0ng (ngay b\u00ean tr\u00e1i c\u1ee7a c\u00f4ng c\u1ee5 ch\u00e8n li\u00ean k\u1ebft).\u00a0<\/span><\/p>\n<p><img loading=\"lazy\" class=\"alignnone size-full wp-image-4126\" src=\"http:\/\/htttdn.com\/wp-content\/uploads\/2025\/11\/img_4004_4.jpg\" alt=\"\" width=\"608\" height=\"351\" srcset=\"https:\/\/htttdn.com\/wp-content\/uploads\/2025\/11\/img_4004_4.jpg 608w, https:\/\/htttdn.com\/wp-content\/uploads\/2025\/11\/img_4004_4-300x173.jpg 300w, https:\/\/htttdn.com\/wp-content\/uploads\/2025\/11\/img_4004_4-330x190.jpg 330w, https:\/\/htttdn.com\/wp-content\/uploads\/2025\/11\/img_4004_4-50x29.jpg 50w, https:\/\/htttdn.com\/wp-content\/uploads\/2025\/11\/img_4004_4-60x35.jpg 60w, https:\/\/htttdn.com\/wp-content\/uploads\/2025\/11\/img_4004_4-100x58.jpg 100w\" sizes=\"(max-width: 608px) 100vw, 608px\" \/><\/p>\n<h3><b>Sao ch\u00e9p \u0111\u1ecbnh d\u1ea1ng \u00f4<\/b><\/h3>\n<p><span style=\"font-weight: 400;\">\u0110\u1ea7u ti\u00ean, b\u1ea1n h\u00e3y nh\u1ea5p v\u00e0o \u00f4 c\u00f3 \u0111\u1ecbnh d\u1ea1ng b\u1ea1n mu\u1ed1n sao ch\u00e9p. Sau \u0111\u00f3, nh\u1ea5p v\u00e0o bi\u1ec3u t\u01b0\u1ee3ng con l\u0103n s\u01a1n \u2013 tr\u00ean thanh c\u00f4ng c\u1ee5 \u2013 v\u00e0 nh\u1ea5p v\u00e0o \u00f4 m\u00e0 b\u1ea1n mu\u1ed1n \u00e1p d\u1ee5ng \u0111\u1ecbnh d\u1ea1ng. T\u1ea5t c\u1ea3 m\u1ecdi th\u1ee9 t\u1eeb k\u00edch th\u01b0\u1edbc ph\u00f4ng ch\u1eef v\u00e0 m\u00e0u s\u1eafc \u0111\u1ebfn ki\u1ec3u t\u00f4 b\u00f3ng \u00f4 v\u00e0 s\u1ed1 s\u1ebd \u0111\u01b0\u1ee3c th\u1ef1c hi\u1ec7n.<\/span><\/p>\n<p><img loading=\"lazy\" class=\"alignnone size-full wp-image-4127\" src=\"http:\/\/htttdn.com\/wp-content\/uploads\/2025\/11\/img_15-format-painter.jpg\" alt=\"\" width=\"850\" height=\"297\" srcset=\"https:\/\/htttdn.com\/wp-content\/uploads\/2025\/11\/img_15-format-painter.jpg 850w, https:\/\/htttdn.com\/wp-content\/uploads\/2025\/11\/img_15-format-painter-300x105.jpg 300w, https:\/\/htttdn.com\/wp-content\/uploads\/2025\/11\/img_15-format-painter-768x268.jpg 768w, https:\/\/htttdn.com\/wp-content\/uploads\/2025\/11\/img_15-format-painter-50x17.jpg 50w, https:\/\/htttdn.com\/wp-content\/uploads\/2025\/11\/img_15-format-painter-60x21.jpg 60w, https:\/\/htttdn.com\/wp-content\/uploads\/2025\/11\/img_15-format-painter-100x35.jpg 100w\" sizes=\"(max-width: 850px) 100vw, 850px\" \/><\/p>\n<h3><b>T\u1ea1o h\u1ed9p ki\u1ec3m trong Google Sheets<\/b><\/h3>\n<p><span style=\"font-weight: 400;\">B\u1ea1n ch\u1ecdn m\u1ed9t lo\u1ea1t \u00f4 tr\u1ed1ng, m\u1edf menu Ch\u00e8n v\u00e0 ch\u1ecdn \u201ccheckbox\u201d. Sau \u0111\u00f3, b\u1ea1n c\u00f3 th\u1ec3 \u0111\u1eb7t c\u00e1c m\u1ee5c vi\u1ec7c c\u1ea7n l\u00e0m c\u1ee7a m\u00ecnh v\u00e0o c\u1ed9t ti\u1ebfp theo v\u00e0 c\u1ea3m th\u1ea5y h\u00e0i l\u00f2ng khi \u0111\u00e1nh d\u1ea5u c\u00e1c m\u1ee5c khi b\u1ea1n ho\u00e0n th\u00e0nh ch\u00fang.<\/span><\/p>\n<h2><span style=\"font-weight: 400;\">Chia s\u1ebb v\u00e0 c\u1ed9ng t\u00e1c trong Google Sheets<\/span><\/h2>\n<h3><b>T\u1ea1o li\u00ean k\u1ebft t\u00f9y ch\u1ec9nh<\/b><\/h3>\n<p><span style=\"font-weight: 400;\">Ch\u1ec9 c\u1ea7n sao ch\u00e9p URL trong thanh \u0111\u1ecba ch\u1ec9 c\u1ee7a tr\u00ecnh duy\u1ec7t khi b\u1ea1n \u0111ang xem b\u1ea3ng t\u00ednh v\u00e0 thay th\u1ebf t\u1eeb \u201cedit\u201d \u1edf cu\u1ed1i url b\u1eb1ng \u201ccopy\u201d, t\u1ea1o m\u1ed9t li\u00ean k\u1ebft t\u01b0\u01a1ng t\u1ef1 nh\u01b0 sau:<\/span><\/p>\n<p><i><span style=\"font-weight: 400;\">https:\/\/docs.google.com\/spreadsheets\/d\/1aBcDEfgHZ\/copy<\/span><\/i><\/p>\n<p><span style=\"font-weight: 400;\">B\u1ea5t k\u1ef3 ai c\u00f3 quy\u1ec1n truy c\u1eadp v\u00e0o b\u1ea3ng t\u00ednh m\u1edf li\u00ean k\u1ebft \u0111\u00f3, h\u1ecd s\u1ebd ngay l\u1eadp t\u1ee9c \u0111\u01b0\u1ee3c nh\u1eafc t\u1ea1o m\u1ed9t b\u1ea3n sao b\u1eb1ng m\u1ed9t c\u00fa nh\u1ea5p chu\u1ed9t ngay l\u00fac \u0111\u00f3.<\/span><\/p>\n<p><img loading=\"lazy\" class=\"alignnone size-full wp-image-4128\" src=\"http:\/\/htttdn.com\/wp-content\/uploads\/2025\/11\/img_4004_5.jpg\" alt=\"\" width=\"613\" height=\"306\" srcset=\"https:\/\/htttdn.com\/wp-content\/uploads\/2025\/11\/img_4004_5.jpg 613w, https:\/\/htttdn.com\/wp-content\/uploads\/2025\/11\/img_4004_5-300x150.jpg 300w, https:\/\/htttdn.com\/wp-content\/uploads\/2025\/11\/img_4004_5-50x25.jpg 50w, https:\/\/htttdn.com\/wp-content\/uploads\/2025\/11\/img_4004_5-60x30.jpg 60w, https:\/\/htttdn.com\/wp-content\/uploads\/2025\/11\/img_4004_5-100x50.jpg 100w\" sizes=\"(max-width: 613px) 100vw, 613px\" \/><\/p>\n<h3><b>Nhanh ch\u00f3ng Xu\u1ea5t trang t\u00ednh d\u01b0\u1edbi \u0111\u1ecbnh d\u1ea1ng kh\u00e1c<\/b><\/h3>\n<p><span style=\"font-weight: 400;\">Google sheets gi\u00fap b\u1ea1n d\u1ec5 d\u00e0ng xu\u1ea5t b\u1ea3ng t\u00ednh c\u1ee7a m\u00ecnh \u1edf nhi\u1ec1u \u0111\u1ecbnh d\u1ea1ng th\u00f4ng qua t\u00f9y ch\u1ecdn \u201cT\u1ea3i xu\u1ed1ng d\u01b0\u1edbi d\u1ea1ng\u201d trong menu T\u1ec7p.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Nh\u01b0ng n\u1ebfu b\u1ea1n t\u1ea3i v\u1ec1 d\u01b0\u1edbi d\u1ea1ng PDF, h\u00e3y thay th\u1ebf t\u1eeb \u201cedit\u201d \u1edf cu\u1ed1i b\u1eb1ng \u201cexport? format = pdf\u201d, t\u1ea1o m\u1ed9t li\u00ean k\u1ebft gi\u1ed1ng nh\u01b0 sau:<\/span><\/p>\n<p><i><span style=\"font-weight: 400;\">https:\/\/docs.google.com\/spreadsheets\/d\/1aBcD\/export?format=pdf<\/span><\/i><\/p>\n<p><span style=\"font-weight: 400;\">Nh\u1eefng ng\u01b0\u1eddi c\u00f3 quy\u1ec1n truy c\u1eadp v\u00e0o b\u1ea3ng t\u00ednh s\u1ebd ngay l\u1eadp t\u1ee9c \u0111\u01b0\u1ee3c xu\u1ea5t b\u1ea3n PDF ngay khi h\u1ecd m\u1edf li\u00ean k\u1ebft.<\/span><\/p>\n<h3><b>Th\u00f4ng b\u00e1o khi Trang t\u00ednh thay \u0111\u1ed5i<\/b><\/h3>\n<p><span style=\"font-weight: 400;\">T\u00ecm t\u00f9y ch\u1ecdn \u201cQuy t\u1eafc th\u00f4ng b\u00e1o\u201d trong menu C\u00f4ng c\u1ee5 \u0111\u1ec3 \u0111\u1eb7t t\u00f9y ch\u1ecdn c\u1ee7a b\u1ea1n cho b\u1ea5t k\u1ef3 b\u1ea3ng t\u00ednh c\u1ee5 th\u1ec3 n\u00e0o khi c\u00f3 s\u1ef1 thay \u0111\u1ed5i.<\/span><\/p>\n<h2><span style=\"font-weight: 400;\">Th\u1eed m\u1ed9t ho\u1eb7c 2 t\u00ednh n\u0103ng n\u00e2ng cao<\/span><\/h2>\n<h3><b>T\u1ea1o QR code v\u1edbi h\u00e0m IMAGE<\/b><\/h3>\n<p><span style=\"font-weight: 400;\">Google sheets c\u00f3 kh\u1ea3 n\u0103ng t\u1ea1o m\u00e3 QR s\u1ebd k\u00e9o l\u00ean b\u1ea5t k\u1ef3 URL n\u00e0o b\u1ea1n mu\u1ed1n khi ch\u00fang \u0111\u01b0\u1ee3c qu\u00e9t. Nh\u1eadp URL c\u1ee7a b\u1ea1n v\u00e0o m\u1ed9t \u00f4 (c\u00f3 \u201chttp: \/\/\u201d ho\u1eb7c \u201chttps: \/\/\u201d \u1edf ph\u00eda tr\u01b0\u1edbc), sau \u0111\u00f3 s\u1eed d\u1ee5ng h\u00e0m sau v\u1edbi s\u1ed1 \u00f4 c\u1ee7a ch\u00ednh b\u1ea1n thay cho \u201cA2\u201d:<\/span><\/p>\n<p><i><span style=\"font-weight: 400;\">= image (&#8220;https:\/\/chart.googleapis.com\/chart?chs=150\u00d7150&amp;cht=qr&amp;chl=&#8221; &amp; A2)<\/span><\/i><\/p>\n<p><span style=\"font-weight: 400;\">M\u00e3 QR s\u1ebd ngay l\u1eadp t\u1ee9c xu\u1ea5t hi\u1ec7n v\u00e0 c\u00f3 s\u1eb5n \u0111\u1ec3 sao ch\u00e9p, chia s\u1ebb ho\u1eb7c thao t\u00e1c theo b\u1ea5t k\u1ef3 c\u00e1ch n\u00e0o m\u00e0 b\u1ea1n mong mu\u1ed1n.<\/span><\/p>\n<h3><b>T\u1ea1o bi\u1ec3u \u0111\u1ed3 nhi\u1ec7t v\u1edbi \u0111\u1ecbnh d\u1ea1ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n<\/b><\/h3>\n<p><span style=\"font-weight: 400;\">T\u1ea1o b\u1ea3n \u0111\u1ed3 nhi\u1ec7t \u0111\u1ec3 \u0111\u00e1nh d\u1ea5u c\u00e1c m\u1ee9c cao v\u00e0 th\u1ea5p v\u00e0 gi\u00fap b\u1ea1n d\u1ec5 d\u00e0ng xem nh\u1eefng th\u1ee9 nh\u01b0 doanh s\u1ed1 b\u00e1n h\u00e0ng ho\u1eb7c m\u00f4 h\u00ecnh th\u00e0nh c\u00f4ng v\u1ec1 l\u01b0u l\u01b0\u1ee3ng truy c\u1eadp web.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Ch\u1ecdn b\u1ea5t k\u1ef3 d\u1ea3i d\u1eef li\u1ec7u n\u00e0o b\u1ea1n mu\u1ed1n, sau \u0111\u00f3 t\u00ecm t\u00f9y ch\u1ecdn \u201c\u0110\u1ecbnh d\u1ea1ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n\u201d trong menu \u0110\u1ecbnh d\u1ea1ng. Nh\u1ea5p v\u00e0o tab &#8220;Thang m\u00e0u&#8221; \u1edf tr\u00ean c\u00f9ng v\u00e0 ch\u1ec9 \u0111\u1ecbnh m\u00e0u cho c\u1ea3 &#8220;Gi\u00e1 tr\u1ecb nh\u1ecf nh\u1ea5t&#8221; v\u00e0 &#8220;Gi\u00e1 tr\u1ecb l\u1edbn nh\u1ea5t&#8221;.\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Hi\u1ec7u \u1ee9ng s\u1ebd ho\u1ea1t \u0111\u1ed9ng t\u1ed1t nh\u1ea5t n\u1ebfu b\u1ea1n s\u1eed d\u1ee5ng phi\u00ean b\u1ea3n m\u00e0u s\u00e1ng cho m\u00e0u tr\u01b0\u1edbc v\u00e0 phi\u00ean b\u1ea3n t\u1ed1i c\u00f9ng m\u00e0u cho m\u00e0u sau.<\/span><\/p>\n<p><img loading=\"lazy\" class=\"alignnone size-full wp-image-4129\" src=\"http:\/\/htttdn.com\/wp-content\/uploads\/2025\/11\/img_4004_6.jpg\" alt=\"\" width=\"596\" height=\"283\" srcset=\"https:\/\/htttdn.com\/wp-content\/uploads\/2025\/11\/img_4004_6.jpg 596w, https:\/\/htttdn.com\/wp-content\/uploads\/2025\/11\/img_4004_6-300x142.jpg 300w, https:\/\/htttdn.com\/wp-content\/uploads\/2025\/11\/img_4004_6-50x24.jpg 50w, https:\/\/htttdn.com\/wp-content\/uploads\/2025\/11\/img_4004_6-60x28.jpg 60w, https:\/\/htttdn.com\/wp-content\/uploads\/2025\/11\/img_4004_6-100x47.jpg 100w\" sizes=\"(max-width: 596px) 100vw, 596px\" \/><\/p>\n<h3><b>Theo d\u00f5i gi\u00e1 c\u1ed5 phi\u1ebfu v\u1edbi h\u00e0m GOOGLEFINANCE\u00a0<\/b><\/h3>\n<p><span style=\"font-weight: 400;\">H\u1ec7 th\u1ed1ng c\u00f3 th\u1ec3 cung c\u1ea5p cho b\u1ea1n gi\u00e1 c\u1ed5 phi\u1ebfu theo th\u1eddi gian th\u1ef1c ho\u1eb7c l\u1ecbch s\u1eed c\u00f9ng v\u1edbi t\u1ea5t c\u1ea3 c\u00e1c lo\u1ea1i d\u1eef li\u1ec7u li\u00ean quan \u0111\u1ebfn th\u1ecb tr\u01b0\u1eddng kh\u00e1c cho b\u1ea5t k\u1ef3 c\u00f4ng ty giao d\u1ecbch c\u00f4ng khai n\u00e0o v\u1edbi h\u00e0m GOOGLEFINANCE:<\/span><\/p>\n<p><i><span style=\"font-weight: 400;\">=GOOGLEFINANCE (ticker, [attribute], [start_date], [end_date|num_days], [interval])<\/span><\/i><\/p>\n<p><span style=\"font-weight: 400;\">V\u1edbi ticker l\u00e0 M\u00e3 ch\u1ee9ng kho\u00e1n c\u1ee7a lo\u1ea1i ch\u1ee9ng kho\u00e1n c\u1ea7n xem x\u00e9t.<\/span><\/p>\n<p><img loading=\"lazy\" class=\"alignnone size-full wp-image-4130\" src=\"http:\/\/htttdn.com\/wp-content\/uploads\/2025\/11\/img_19-cat-stock.jpg\" alt=\"\" width=\"849\" height=\"509\" srcset=\"https:\/\/htttdn.com\/wp-content\/uploads\/2025\/11\/img_19-cat-stock.jpg 849w, https:\/\/htttdn.com\/wp-content\/uploads\/2025\/11\/img_19-cat-stock-300x180.jpg 300w, https:\/\/htttdn.com\/wp-content\/uploads\/2025\/11\/img_19-cat-stock-768x460.jpg 768w, https:\/\/htttdn.com\/wp-content\/uploads\/2025\/11\/img_19-cat-stock-50x30.jpg 50w, https:\/\/htttdn.com\/wp-content\/uploads\/2025\/11\/img_19-cat-stock-60x36.jpg 60w, https:\/\/htttdn.com\/wp-content\/uploads\/2025\/11\/img_19-cat-stock-100x60.jpg 100w\" sizes=\"(max-width: 849px) 100vw, 849px\" \/><\/p>\n<h3><b>X\u00e1c \u0111\u1ecbnh v\u00e0 d\u1ecbch c\u00e1c ng\u00f4n ng\u1eef kh\u00e1c nhau\u00a0<\/b><\/h3>\n<p><span style=\"font-weight: 400;\">Google sheets c\u00f3 th\u1ec3 x\u00e1c \u0111\u1ecbnh b\u1ea5t k\u1ef3 ng\u00f4n ng\u1eef n\u00e0o \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng trong b\u1ea3ng t\u00ednh v\u00e0 th\u1eadm ch\u00ed d\u1ecbch n\u00f3 sang ti\u1ebfng m\u1eb9 \u0111\u1ebb c\u1ee7a b\u1ea1n ngay t\u1ea1i ch\u1ed7. \u0110\u1ec3 ph\u00e1t hi\u1ec7n m\u1ed9t ng\u00f4n ng\u1eef, h\u00e3y s\u1eed d\u1ee5ng h\u00e0m sau&#8221;<\/span><\/p>\n<p><i><span style=\"font-weight: 400;\">= DETECTLANGUAGE (A1)<\/span><\/i><\/p>\n<p><span style=\"font-weight: 400;\">B\u1ea1n c\u0169ng c\u00f3 th\u1ec3 nh\u1eadp m\u1ed9t t\u1eeb thay cho s\u1ed1 \u00f4, n\u1ebfu b\u1ea1n mu\u1ed1n:<\/span><\/p>\n<p><i><span style=\"font-weight: 400;\">=DETECTLANGUAGE(&#8220;queso&#8221;)<\/span><\/i><\/p>\n<p><span style=\"font-weight: 400;\">Google s\u1ebd cung c\u1ea5p cho b\u1ea1n m\u1ed9t m\u00e3 g\u1ed3m hai ch\u1eef c\u00e1i cho b\u1ea1n bi\u1ebft ng\u00f4n ng\u1eef \u0111\u00e3 \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng. Trong khi \u0111\u00f3, \u0111\u1ec3 d\u1ecbch, h\u00e3y s\u1eed d\u1ee5ng l\u1ec7nh sau:<\/span><\/p>\n<p><i><span style=\"font-weight: 400;\">=GOOGLETRANSLATE(A1, &#8220;auto&#8221;, &#8220;vi&#8221;)<\/span><\/i><\/p>\n<h2><span style=\"font-weight: 400;\">Kh\u00f3a c\u00e1c \u00f4 \u0111\u1ec3 ng\u0103n c\u00e1c thay \u0111\u1ed5i kh\u00f4ng mong mu\u1ed1n<\/span><\/h2>\n<p><span style=\"font-weight: 400;\">B\u1ea1n \u0111i t\u1edbi\u00a0 t\u00f9y ch\u1ecdn menu <\/span><b>Data &gt; Protected sheets and ranges<\/b><span style=\"font-weight: 400;\">. M\u1ed9t menu s\u1ebd m\u1edf ra ph\u00eda b\u00ean ph\u1ea3i cho ph\u00e9p b\u1ea1n ch\u1ec9 c\u1ea7n nh\u1ea5p v\u00e0 k\u00e9o qua d\u1eef li\u1ec7u c\u1ea7n \u0111\u01b0\u1ee3c b\u1ea3o v\u1ec7.<\/span><\/p>\n<p><img loading=\"lazy\" class=\"alignnone size-full wp-image-4131\" src=\"http:\/\/htttdn.com\/wp-content\/uploads\/2025\/11\/img_5-data-protected-sheets-example.jpg\" alt=\"\" width=\"850\" height=\"349\" srcset=\"https:\/\/htttdn.com\/wp-content\/uploads\/2025\/11\/img_5-data-protected-sheets-example.jpg 850w, https:\/\/htttdn.com\/wp-content\/uploads\/2025\/11\/img_5-data-protected-sheets-example-300x123.jpg 300w, https:\/\/htttdn.com\/wp-content\/uploads\/2025\/11\/img_5-data-protected-sheets-example-768x315.jpg 768w, https:\/\/htttdn.com\/wp-content\/uploads\/2025\/11\/img_5-data-protected-sheets-example-50x21.jpg 50w, https:\/\/htttdn.com\/wp-content\/uploads\/2025\/11\/img_5-data-protected-sheets-example-60x25.jpg 60w, https:\/\/htttdn.com\/wp-content\/uploads\/2025\/11\/img_5-data-protected-sheets-example-100x41.jpg 100w\" sizes=\"(max-width: 850px) 100vw, 850px\" \/><\/p>\n<h2><span style=\"font-weight: 400;\">L\u1ecdc b\u1ea3ng t\u00ednh \u0111\u1ec3 t\u00ecm d\u1eef li\u1ec7u c\u1ee5 th\u1ec3<\/span><\/h2>\n<p><span style=\"font-weight: 400;\">S\u1eed d\u1ee5ng t\u00ednh n\u0103ng l\u1ecdc d\u1eef li\u1ec7u trong Google Sheets c\u00f3 th\u1ec3 gi\u00fap l\u1ecdc d\u1eef li\u1ec7u khi b\u1ea1n c\u00f3 b\u1ea3ng d\u1eef li\u1ec7u Google Sheets kh\u1ed5ng l\u1ed3 c\u1ea7n x\u1eed l\u00fd.<\/span><\/p>\n<p><img loading=\"lazy\" class=\"alignnone size-full wp-image-4132\" src=\"http:\/\/htttdn.com\/wp-content\/uploads\/2025\/11\/img_7-filter-data-sheets.jpg\" alt=\"\" width=\"850\" height=\"491\" srcset=\"https:\/\/htttdn.com\/wp-content\/uploads\/2025\/11\/img_7-filter-data-sheets.jpg 850w, https:\/\/htttdn.com\/wp-content\/uploads\/2025\/11\/img_7-filter-data-sheets-300x173.jpg 300w, https:\/\/htttdn.com\/wp-content\/uploads\/2025\/11\/img_7-filter-data-sheets-768x444.jpg 768w, https:\/\/htttdn.com\/wp-content\/uploads\/2025\/11\/img_7-filter-data-sheets-330x190.jpg 330w, https:\/\/htttdn.com\/wp-content\/uploads\/2025\/11\/img_7-filter-data-sheets-50x29.jpg 50w, https:\/\/htttdn.com\/wp-content\/uploads\/2025\/11\/img_7-filter-data-sheets-60x35.jpg 60w, https:\/\/htttdn.com\/wp-content\/uploads\/2025\/11\/img_7-filter-data-sheets-100x58.jpg 100w\" sizes=\"(max-width: 850px) 100vw, 850px\" \/><\/p>\n<h3><b>S\u1eed d\u1ee5ng macro \u0111\u1ec3 th\u1ef1c hi\u1ec7n c\u00e1c nhi\u1ec7m v\u1ee5 l\u1eb7p l\u1ea1i<\/b><\/h3>\n<p><span style=\"font-weight: 400;\">N\u1ebfu c\u00f3 m\u1ed9t c\u00f4ng vi\u1ec7c th\u01b0\u1eddng ng\u00e0y m\u00e0 b\u1ea1n ph\u1ea3i th\u1ef1c hi\u1ec7n l\u1eb7p \u0111i l\u1eb7p l\u1ea1i trong b\u1ea3ng d\u1eef li\u1ec7u Google Sheets th\u00ec thay v\u00ec th\u1ef1c hi\u1ec7n th\u1ee7 c\u00f4ng, m\u1ea5t nhi\u1ec1u th\u1eddi gian. B\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng c\u00e1c m\u00e3 macro \u0111\u1ec3 gi\u00fap b\u1ea1n th\u1ef1c hi\u1ec7n vi\u1ec7c \u0111\u00f3 ho\u00e0n to\u00e0n t\u1ef1 \u0111\u1ed9ng.\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400;\">\u0110\u1ec3 b\u1eaft \u0111\u1ea7u, h\u00e3y chuy\u1ec3n \u0111\u1ebfn menu <\/span><b>Tools &gt; Macros &gt; Record Macro<\/b><span style=\"font-weight: 400;\">. Sau \u0111\u00f3, th\u1ef1c hi\u1ec7n c\u00e1c b\u01b0\u1edbc m\u00e0 b\u1ea1n mu\u1ed1n th\u1ef1c hi\u1ec7n l\u1eb7p l\u1ea1i sau v\u00e0 l\u01b0u l\u1ea1i.\u00a0<\/span><\/p>\n<p><img loading=\"lazy\" class=\"alignnone size-full wp-image-4133\" src=\"http:\/\/htttdn.com\/wp-content\/uploads\/2025\/11\/img_12-use-macros-repetitive-tasks.jpg\" alt=\"\" width=\"850\" height=\"207\" srcset=\"https:\/\/htttdn.com\/wp-content\/uploads\/2025\/11\/img_12-use-macros-repetitive-tasks.jpg 850w, https:\/\/htttdn.com\/wp-content\/uploads\/2025\/11\/img_12-use-macros-repetitive-tasks-300x73.jpg 300w, https:\/\/htttdn.com\/wp-content\/uploads\/2025\/11\/img_12-use-macros-repetitive-tasks-768x187.jpg 768w, https:\/\/htttdn.com\/wp-content\/uploads\/2025\/11\/img_12-use-macros-repetitive-tasks-50x12.jpg 50w, https:\/\/htttdn.com\/wp-content\/uploads\/2025\/11\/img_12-use-macros-repetitive-tasks-60x15.jpg 60w, https:\/\/htttdn.com\/wp-content\/uploads\/2025\/11\/img_12-use-macros-repetitive-tasks-100x24.jpg 100w\" sizes=\"(max-width: 850px) 100vw, 850px\" \/><\/p>\n<h2><span style=\"font-weight: 400;\">In b\u1ea3ng t\u00ednh c\u1ee7a b\u1ea1n m\u1ed9t c\u00e1ch d\u1ec5 d\u00e0ng\u00a0<\/span><\/h2>\n<p><span style=\"font-weight: 400;\">C\u00e1c b\u1ea3ng d\u1eef li\u1ec7u Google Sheets kh\u00f4ng ph\u1ea3i l\u00fac n\u00e0o c\u0169ng ch\u1ec9 \u0111\u1ec3 l\u01b0u tr\u1eef tr\u00ean m\u00e1y. \u0110\u00f4i khi, b\u1ea1n c\u0169ng c\u1ea7n ph\u1ea3i in m\u1ed9t b\u1ea3ng t\u00ednh \u0111\u00e3 ho\u00e0n th\u00e0nh \u0111\u1ec3 \u0111em \u0111i xem x\u00e9t v\u00e0 ph\u00e2n t\u00edch.\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Vi\u1ec7c in \u1ea5n c\u00e1c b\u1ea3ng d\u1eef li\u1ec7u trong Google Sheets tr\u01b0\u1edbc gi\u1edd v\u1eabn ph\u1ee9c t\u1ea1p h\u01a1n so v\u1edbi in b\u1ea3ng t\u00ednh Excel.\u00a0<\/span><\/p>\n<p><img loading=\"lazy\" class=\"alignnone size-full wp-image-4134\" src=\"http:\/\/htttdn.com\/wp-content\/uploads\/2025\/11\/img_14-sheets-print-preview.jpg\" alt=\"\" width=\"850\" height=\"552\" srcset=\"https:\/\/htttdn.com\/wp-content\/uploads\/2025\/11\/img_14-sheets-print-preview.jpg 850w, https:\/\/htttdn.com\/wp-content\/uploads\/2025\/11\/img_14-sheets-print-preview-300x195.jpg 300w, https:\/\/htttdn.com\/wp-content\/uploads\/2025\/11\/img_14-sheets-print-preview-768x499.jpg 768w, https:\/\/htttdn.com\/wp-content\/uploads\/2025\/11\/img_14-sheets-print-preview-50x32.jpg 50w, https:\/\/htttdn.com\/wp-content\/uploads\/2025\/11\/img_14-sheets-print-preview-60x39.jpg 60w, https:\/\/htttdn.com\/wp-content\/uploads\/2025\/11\/img_14-sheets-print-preview-100x65.jpg 100w\" sizes=\"(max-width: 850px) 100vw, 850px\" \/><\/p>\n<p><span style=\"font-weight: 400;\">Hy v\u1ecdng v\u1edbi b\u00e0i vi\u1ebft n\u00e0y, b\u1ea1n \u0111\u00e3 b\u1ecf t\u00fai \u0111\u01b0\u1ee3c m\u1ed9t v\u00e0i th\u1ee7 thu\u1eadt Google sheet h\u1eefu \u00edch.\u00a0<\/span><\/p>\n<p style=\"text-align: right;\"><i><span style=\"font-weight: 400;\">Ngu\u1ed3n: Tr\u1ea7n V\u0103n Hu\u1ec7.<\/span><\/i><\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<div class='heateorSssClear'><\/div><div  class='heateor_sss_sharing_container heateor_sss_horizontal_sharing' heateor-sss-data-href='https:\/\/htttdn.com\/index.php\/tin-tuc\/20-thu-thuat-google-sheet-nhat-dinh-ban-phai-biet\/'><div class='heateor_sss_sharing_title' style=\"font-weight:bold\" ><\/div><ul class=\"heateor_sss_sharing_ul\"><li style=\"padding:4.2px 0 !important\" class=\"heateor_sss_facebook_like\"><ss class=\"heateor_sss_square_count\">&nbsp;<\/ss><div class=\"fb-like\" data-href=\"https:\/\/htttdn.com\/index.php\/tin-tuc\/20-thu-thuat-google-sheet-nhat-dinh-ban-phai-biet\/\" data-layout=\"button_count\" data-action=\"like\" data-show-faces=\"false\" data-share=\"false\"><\/div><\/li><li style=\"padding:4.2px 0 !important\" class=\"heateor_sss_facebook_share\"><ss class=\"heateor_sss_square_count\">&nbsp;<\/ss><div class=\"fb-share-button\" data-href=\"https:\/\/htttdn.com\/index.php\/tin-tuc\/20-thu-thuat-google-sheet-nhat-dinh-ban-phai-biet\/\" data-layout=\"button_count\"><\/div><\/li><li class=\"heateorSssSharingRound\"><i style=\"width:20px;height:20px;border-radius:999px;\" alt=\"Instagram\" Title=\"Instagram\" class=\"heateorSssSharing heateorSssInstagramBackground\"><a href=\"https:\/\/www.instagram.com\/\" rel=\"nofollow noopener\" target=\"_blank\"><ss style=\"display:block;border-radius:999px;\" class=\"heateorSssSharingSvg heateorSssInstagramSvg\"><\/ss><\/a><\/i><ss class=\"heateor_sss_square_count heateor_sss_instagram_count\">&nbsp;<\/ss><\/li><li class=\"heateorSssSharingRound\"><i style=\"width:20px;height:20px;border-radius:999px;\" alt=\"Twitter\" Title=\"Twitter\" class=\"heateorSssSharing heateorSssTwitterBackground\" onclick='heateorSssPopup(\"http:\/\/twitter.com\/intent\/tweet?text=20%2B%20Th%E1%BB%A7%20thu%E1%BA%ADt%20Google%20Sheet%20nh%E1%BA%A5t%20%C4%91%E1%BB%8Bnh%20b%E1%BA%A1n%20ph%E1%BA%A3i%20bi%E1%BA%BFt&url=https%3A%2F%2Fhtttdn.com%2Findex.php%2Ftin-tuc%2F20-thu-thuat-google-sheet-nhat-dinh-ban-phai-biet%2F\")'><ss style=\"display:block;border-radius:999px;\" class=\"heateorSssSharingSvg heateorSssTwitterSvg\"><\/ss><\/i><ss class=\"heateor_sss_square_count heateor_sss_twitter_count\">&nbsp;<\/ss><\/li><li class=\"heateorSssSharingRound\"><i style=\"width:20px;height:20px;border-radius:999px;\" alt=\"Pinterest\" Title=\"Pinterest\" class=\"heateorSssSharing heateorSssPinterestBackground\" onclick=\"javascript:void( (function() {var e=document.createElement('script' );e.setAttribute('type','text\/javascript' );e.setAttribute('charset','UTF-8' );e.setAttribute('src','\/\/assets.pinterest.com\/js\/pinmarklet.js?r='+Math.random()*99999999);document.body.appendChild(e)})());\"><ss style=\"display:block;border-radius:999px;\" class=\"heateorSssSharingSvg heateorSssPinterestSvg\"><\/ss><\/i><ss class=\"heateor_sss_square_count heateor_sss_pinterest_count\">&nbsp;<\/ss><\/li><li class=\"heateorSssSharingRound\"><ss class=\"heateor_sss_square_count\">&nbsp;<\/ss><i style=\"width:20px;height:20px;border-radius:999px;\" title=\"More\" alt=\"More\" class=\"heateorSssSharing heateorSssMoreBackground\" onclick=\"heateorSssMoreSharingPopup(this, 'https:\/\/htttdn.com\/index.php\/tin-tuc\/20-thu-thuat-google-sheet-nhat-dinh-ban-phai-biet\/', '20%2B%20Th%E1%BB%A7%20thu%E1%BA%ADt%20Google%20Sheet%20nh%E1%BA%A5t%20%C4%91%E1%BB%8Bnh%20b%E1%BA%A1n%20ph%E1%BA%A3i%20bi%E1%BA%BFt', '' )\" ><ss style=\"display:block\" class=\"heateorSssSharingSvg heateorSssMoreSvg\"><\/ss><\/i><\/li><li class=\"heateorSssSharingRound\"><ss class=\"heateor_sss_square_count\">&nbsp;<\/ss><i style=\"width:20px;height:20px;border-radius:999px;margin-left:9px !important;\" title=\"Total Shares\" class=\"heateorSssSharing heateorSssTCBackground\"><\/i><\/li><\/ul><div class=\"heateorSssClear\"><\/div><\/div><div class='heateorSssClear'><\/div><p>Google Sheets l\u00e0 m\u1ed9t c\u00f4ng c\u1ee5 b\u1ea3ng t\u00ednh v\u00f4 c\u00f9ng h\u1eefu \u00edch v\u1edbi c\u00e1c t\u00ednh n\u0103ng th\u00fa v\u1ecb v\u00e0 nhi\u1ec1u th\u1ee7 thu\u1eadt Google sheet m\u00e0 h\u1ea7u h\u1ebft ng\u01b0\u1eddi d\u00f9ng ch\u01b0a khai th\u00e1c h\u1ebft. C\u00f9ng FAST t\u00ecm hi\u1ec3u ngay nh\u00e9! Ch\u00e8n \u1ea3nh v\u00e0o b\u00ean trong Google Sheets Tr\u00ean th\u1ef1c t\u1ebf b\u1ea3ng&#8230;<\/p>\n","protected":false},"author":3,"comment_status":"closed","ping_status":"closed","template":"","format":"standard","meta":[],"ht-kb-category":[94],"ht-kb-tag":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v15.2.1 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\r\n<title>20+ Th\u1ee7 thu\u1eadt Google Sheet nh\u1ea5t \u0111\u1ecbnh b\u1ea1n ph\u1ea3i bi\u1ebft - H\u1ec7 th\u1ed1ng th\u00f4ng tin doanh nghi\u1ec7p<\/title>\r\n<meta name=\"description\" content=\"Google Sheets l\u00e0 m\u1ed9t c\u00f4ng c\u1ee5 b\u1ea3ng t\u00ednh v\u00f4 c\u00f9ng h\u1eefu \u00edch v\u1edbi c\u00e1c t\u00ednh n\u0103ng th\u00fa v\u1ecb v\u00e0 nhi\u1ec1u th\u1ee7 thu\u1eadt th\u00fa v\u1ecb. C\u00f9ng FAST t\u00ecm hi\u1ec3u ngay nh\u00e9!\" \/>\r\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\r\n<link rel=\"canonical\" href=\"http:\/\/htttdn.com\/index.php\/tin-tuc\/20-thu-thuat-google-sheet-nhat-dinh-ban-phai-biet\/\" \/>\r\n<meta property=\"og:locale\" content=\"vi_VN\" \/>\r\n<meta property=\"og:type\" content=\"article\" \/>\r\n<meta property=\"og:title\" content=\"20+ Th\u1ee7 thu\u1eadt Google Sheet nh\u1ea5t \u0111\u1ecbnh b\u1ea1n ph\u1ea3i bi\u1ebft - H\u1ec7 th\u1ed1ng th\u00f4ng tin doanh nghi\u1ec7p\" \/>\r\n<meta property=\"og:description\" content=\"Google Sheets l\u00e0 m\u1ed9t c\u00f4ng c\u1ee5 b\u1ea3ng t\u00ednh v\u00f4 c\u00f9ng h\u1eefu \u00edch v\u1edbi c\u00e1c t\u00ednh n\u0103ng th\u00fa v\u1ecb v\u00e0 nhi\u1ec1u th\u1ee7 thu\u1eadt th\u00fa v\u1ecb. C\u00f9ng FAST t\u00ecm hi\u1ec3u ngay nh\u00e9!\" \/>\r\n<meta property=\"og:url\" content=\"http:\/\/htttdn.com\/index.php\/tin-tuc\/20-thu-thuat-google-sheet-nhat-dinh-ban-phai-biet\/\" \/>\r\n<meta property=\"og:site_name\" content=\"H\u1ec7 th\u1ed1ng th\u00f4ng tin doanh nghi\u1ec7p\" \/>\r\n<meta property=\"article:modified_time\" content=\"2025-11-06T16:59:37+00:00\" \/>\r\n<meta property=\"og:image\" content=\"https:\/\/htttdn.com\/wp-content\/uploads\/2025\/11\/thu-thuat-gg-sheet.jpg\" \/>\r\n\t<meta property=\"og:image:width\" content=\"1200\" \/>\r\n\t<meta property=\"og:image:height\" content=\"628\" \/>\r\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\r\n<meta name=\"twitter:label1\" content=\"Written by\">\n\t<meta name=\"twitter:data1\" content=\"Ho\u00e0ng Th\u1ecb Thanh B\u00ecnh\">\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\">\n\t<meta name=\"twitter:data2\" content=\"15 ph\u00fat\">\r\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebSite\",\"@id\":\"https:\/\/htttdn.com\/#website\",\"url\":\"https:\/\/htttdn.com\/\",\"name\":\"H\\u1ec7 th\\u1ed1ng th\\u00f4ng tin doanh nghi\\u1ec7p\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":\"https:\/\/htttdn.com\/?s={search_term_string}\",\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"vi\"},{\"@type\":\"ImageObject\",\"@id\":\"http:\/\/htttdn.com\/index.php\/tin-tuc\/20-thu-thuat-google-sheet-nhat-dinh-ban-phai-biet\/#primaryimage\",\"inLanguage\":\"vi\",\"url\":\"https:\/\/htttdn.com\/wp-content\/uploads\/2025\/11\/thu-thuat-gg-sheet.jpg\",\"width\":1200,\"height\":628,\"caption\":\"thu-thuat-gg-sheet\"},{\"@type\":\"WebPage\",\"@id\":\"http:\/\/htttdn.com\/index.php\/tin-tuc\/20-thu-thuat-google-sheet-nhat-dinh-ban-phai-biet\/#webpage\",\"url\":\"http:\/\/htttdn.com\/index.php\/tin-tuc\/20-thu-thuat-google-sheet-nhat-dinh-ban-phai-biet\/\",\"name\":\"20+ Th\\u1ee7 thu\\u1eadt Google Sheet nh\\u1ea5t \\u0111\\u1ecbnh b\\u1ea1n ph\\u1ea3i bi\\u1ebft - H\\u1ec7 th\\u1ed1ng th\\u00f4ng tin doanh nghi\\u1ec7p\",\"isPartOf\":{\"@id\":\"https:\/\/htttdn.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"http:\/\/htttdn.com\/index.php\/tin-tuc\/20-thu-thuat-google-sheet-nhat-dinh-ban-phai-biet\/#primaryimage\"},\"datePublished\":\"2025-11-06T16:55:53+00:00\",\"dateModified\":\"2025-11-06T16:59:37+00:00\",\"description\":\"Google Sheets l\\u00e0 m\\u1ed9t c\\u00f4ng c\\u1ee5 b\\u1ea3ng t\\u00ednh v\\u00f4 c\\u00f9ng h\\u1eefu \\u00edch v\\u1edbi c\\u00e1c t\\u00ednh n\\u0103ng th\\u00fa v\\u1ecb v\\u00e0 nhi\\u1ec1u th\\u1ee7 thu\\u1eadt th\\u00fa v\\u1ecb. C\\u00f9ng FAST t\\u00ecm hi\\u1ec3u ngay nh\\u00e9!\",\"inLanguage\":\"vi\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"http:\/\/htttdn.com\/index.php\/tin-tuc\/20-thu-thuat-google-sheet-nhat-dinh-ban-phai-biet\/\"]}]}]}<\/script>\r\n<!-- \/ Yoast SEO plugin. -->","_links":{"self":[{"href":"https:\/\/htttdn.com\/index.php\/wp-json\/wp\/v2\/ht-kb\/4115"}],"collection":[{"href":"https:\/\/htttdn.com\/index.php\/wp-json\/wp\/v2\/ht-kb"}],"about":[{"href":"https:\/\/htttdn.com\/index.php\/wp-json\/wp\/v2\/types\/ht_kb"}],"author":[{"embeddable":true,"href":"https:\/\/htttdn.com\/index.php\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/htttdn.com\/index.php\/wp-json\/wp\/v2\/comments?post=4115"}],"version-history":[{"count":2,"href":"https:\/\/htttdn.com\/index.php\/wp-json\/wp\/v2\/ht-kb\/4115\/revisions"}],"predecessor-version":[{"id":4136,"href":"https:\/\/htttdn.com\/index.php\/wp-json\/wp\/v2\/ht-kb\/4115\/revisions\/4136"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/htttdn.com\/index.php\/wp-json\/wp\/v2\/media\/4116"}],"wp:attachment":[{"href":"https:\/\/htttdn.com\/index.php\/wp-json\/wp\/v2\/media?parent=4115"}],"wp:term":[{"taxonomy":"ht_kb_category","embeddable":true,"href":"https:\/\/htttdn.com\/index.php\/wp-json\/wp\/v2\/ht-kb-category?post=4115"},{"taxonomy":"ht_kb_tag","embeddable":true,"href":"https:\/\/htttdn.com\/index.php\/wp-json\/wp\/v2\/ht-kb-tag?post=4115"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}