{"id":562,"date":"2019-06-16T16:43:15","date_gmt":"2019-06-16T09:43:15","guid":{"rendered":"https:\/\/webvocuc.com\/blog\/?p=562"},"modified":"2022-04-06T20:58:24","modified_gmt":"2022-04-06T13:58:24","slug":"5-huong-dan-su-dung-google-sheet","status":"publish","type":"post","link":"https:\/\/webvocuc.com\/blog\/5-huong-dan-su-dung-google-sheet.html","title":{"rendered":"5 h\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng Google Sheet"},"content":{"rendered":"

Google Sheets<\/a> – m\u1ed9t c\u00f4ng c\u1ee5 v\u00f4 c\u00f9ng h\u1eefu \u00edch trong th\u1eddi \u0111\u1ea1i to\u00e0n c\u1ea7u hi\u1ec7n nay. Ch\u00fang ta c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng nh\u01b0 phi\u00ean b\u1ea3n Excel online, ti\u1ebfn h\u00e0nh k\u1ebb c\u00e1c b\u1ea3ng th\u00f4ng k\u00ea s\u1ed1 li\u1ec7u, l\u01b0u tr\u1eef d\u1eef li\u1ec7u tr\u1ef1c tuy\u1ebfn ngay khi nh\u1eadp n\u1ed9i dung. B\u00ean c\u1ea1nh \u0111\u00f3, Google Sheets h\u1ed7 tr\u1ee3 ch\u00fang ta r\u1ea5t nhi\u1ec1u v\u1edbi nh\u1eefng t\u00ednh n\u0103ng h\u1eefu \u00edch kh\u00e1c. H\u00e3y c\u00f9ng t\u00ecm hi\u1ec3u 5 h\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng Google Sheet <\/strong><\/a>m\u1ed9t c\u00e1ch hi\u1ec7u qu\u1ea3 nh\u1ea5t nh\u00e9.<\/p>\n

\"h\u01b0\u1edbng<\/p>\n

1. \u0110\u00f3ng b\u0103ng h\u00e0ng, c\u1ed9t trong Google Sheets:<\/h2>\n

Trong qu\u00e1 tr\u00ecnh ch\u00fang ta ti\u1ebfn h\u00e0nh x\u1eed l\u00fd n\u1ed9i dung b\u1ea3ng t\u00ednh. S\u1ebd c\u00f3 nh\u1eefng c\u1ed9t ho\u1eb7c b\u1ea3ng ch\u00fang ta mu\u1ed1n s\u1eed d\u1ee5ng \u1edf ch\u1ebf \u0111\u1ed9 “\u0111\u00f3ng b\u0103ng” lu\u00f4n lu\u00f4n hi\u1ec3n th\u1ecb \u0111\u1ec3 thu\u1eadn ti\u1ec7n cho vi\u1ec7c theo d\u00f5i. Ch\u00ednh v\u00ec v\u1eady, ch\u00fang ta c\u1ea7n ti\u1ebfn h\u00e0nh \u0111\u00f3ng b\u0103ng c\u1ed9t ho\u1eb7c h\u00e0ng \u0111\u00f3 l\u1ea1i.<\/p>\n

Ch\u00fang ta nh\u1ea5n ch\u1ecdn v\u00e0o tab “View” v\u00e0 ch\u1ecdn “Freeze”.<\/p>\n

Ti\u1ebfp \u0111\u1ebfn ch\u1ecdn “Freeze” s\u1ebd c\u00f3 th\u00eam c\u00e1c t\u00f9y ch\u1ecdn cho c\u1ed9t ho\u1eb7c h\u00e0ng. T\u1ea1i \u0111\u00f3, b\u1ea1n c\u00f3 th\u1ec3 l\u1ef1a ch\u1ecdn \u0111\u00f3ng b\u0103ng b\u1ea5t c\u1ee9 h\u00e0ng ho\u1eb7c c\u1ed9t n\u00e0o n\u1ebfu mu\u1ed1n. T\u00ednh t\u1eeb h\u00e0ng 1 c\u1ed9t 1.<\/p>\n

V\u1edbi tr\u01b0\u1eddng h\u1ee3p ch\u00fang ta \u0111\u00e3 ch\u1ecdn 1 \u00f4 tr\u01b0\u1edbc khi th\u1ef1c hi\u1ec7n thao t\u00e1c nh\u1ea5n View. T\u00f9y ch\u1ecdn s\u1ebd \u0111\u1ed5i th\u00e0nh \u0111\u00f3ng b\u0103ng h\u00e0ng ho\u1eb7c c\u1ed9t t\u1eeb \u0111\u1ea7u \u0111\u1ebfn \u00f4 \u0111\u00e3 ch\u1ecdn. Up to current row, Up to current column.<\/p>\n

2. Th\u1ef1c hi\u1ec7n t\u00ednh t\u1ed5ng nhanh tr\u00ean Google Sheets:<\/h2>\n

Ta c\u00f3 th\u1ec3 th\u1ef1c hi\u1ec7n c\u00e1c ph\u00e9p t\u00ednh tr\u00ean Google Sheets nh\u01b0 khi l\u00e0m vi\u1ec7c v\u1edbi Excel. H\u00e0m t\u00ednh t\u1ed5ng SUM l\u00e0 m\u1ed9t trong nh\u1eefng h\u00e0m v\u00f4 c\u00f9ng quen thu\u1ed9c khi x\u1eed l\u00fd b\u1ea3ng s\u1ed1 li\u1ec7u.<\/p>\n

Google Sheets h\u1ed7 tr\u1ee3 ng\u01b0\u1eddi d\u00f9ng c\u00f3 th\u1ec3 th\u1ef1c hi\u1ec7n t\u00ednh t\u1ed5ng nhanh cho c\u00e1c d\u00e3y s\u1ed1 li\u1ec7u. B\u1eb1ng c\u00e1ch k\u00e9o chu\u1ed9t v\u00e0o nh\u1eefng \u00f4 mu\u1ed1n t\u00ednh t\u1ed5ng. Sau \u0111\u00f3 s\u1ebd xu\u1ea5t hi\u1ec7n t\u1ed5ng SUM \u1edf g\u00f3c b\u00ean ph\u1ea3i d\u01b0\u1edbi c\u00f9ng.<\/p>\n

N\u1ebfu ch\u00fang ta click chu\u1ed9t v\u00e0o \u0111\u00f3 s\u1ebd xu\u1ea5t hi\u1ec7n b\u1ea3ng chi ti\u1ebft h\u01a1n. V\u1edbi gi\u00e1 tr\u1ecb Min v\u00e0 Max c\u1ee7a d\u00e3y s\u1ed1 t\u00ednh t\u1ed5ng hay nhi\u1ec1u gi\u00e1 tr\u1ecb kh\u00e1c.<\/p>\n

V\u00e0 c\u00e1ch t\u00ednh t\u1ed5ng truy\u1ec1n th\u1ed1ng tr\u00ean Google Sheets \u0111\u00f3 l\u00e0 g\u00f5 c\u00f4ng th\u1ee9c v\u00e0o m\u1ed9t \u00f4 tr\u1ed1ng =sum(B4:B9). V\u1edbi B4 l\u00e0 \u00f4 b\u1eaft \u0111\u1ea7u v\u00e0 B9 l\u00e0 \u00f4 k\u1ebft th\u00fac c\u1ee7a d\u00e3y s\u1ed1 t\u00ednh t\u1ed5ng. Ngay sau \u0111\u00f3, k\u1ebft qu\u1ea3 t\u00ednh t\u1ed5ng c\u0169ng s\u1ebd \u0111\u01b0\u1ee3c hi\u1ec3n th\u1ecb.<\/p>\n

3. H\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng Google Sheet –<\/strong> T\u1ea1o form \u0111\u0103ng k\u00fd tr\u00ean Google Sheets:<\/h2>\n

\u0110\u1ed1i v\u1edbi nh\u1eefng ai c\u00f3 nhu c\u1ea7u t\u1ea1o phi\u1ebfu kh\u1ea3o s\u00e1t c\u00e2u h\u1ecfi. \u0110\u01a1n \u0111\u0103ng k\u00fd th\u00ec Google Sheets s\u1ebd gi\u00fap ch\u00fang ta l\u00e0m vi\u1ec7c \u0111\u00f3. C\u00e1ch th\u1ef1c hi\u1ec7n r\u1ea5t \u0111\u01a1n gi\u1ea3n.<\/p>\n

B\u01b0\u1edbc 1: Nh\u1ea5n v\u00e0o m\u1ee5c Tools v\u00e0 ch\u1ecdn Create a form.<\/h4>\n

B\u01b0\u1edbc 2: Xu\u1ea5t hi\u1ec7n giao di\u1ec7n m\u1edbi.<\/h4>\n

T\u1ea1i \u0111\u00e2y, ng\u01b0\u1eddi d\u00f9ng s\u1ebd nh\u1eadp t\u00ean ti\u00eau \u0111\u1ec1 c\u0169ng nh\u01b0 n\u1ed9i dung m\u00f4 t\u1ea3 cho form m\u1edbi n\u00e0y. N\u1ed9i dung s\u1ebd \u0111\u01b0\u1ee3c l\u01b0u t\u1ef1 \u0111\u1ed9ng l\u1ea1i tr\u00ean b\u1ea3ng \u0111i\u1ec1u tra.<\/p>\n

B\u01b0\u1edbc 3: Ch\u00fang ta s\u1ebd \u0111i\u1ec1n c\u00e2u h\u1ecfi v\u00e0o ph\u1ea7n Untitled Question.<\/h4>\n

L\u1ef1a ch\u1ecdn d\u1ea1ng c\u00e2u tr\u1ea3 l\u1eddi nh\u01b0 tr\u1eafc nghi\u1ec7m (Multiple choice), t\u00edch v\u00e0o c\u00e2u tr\u1ea3 l\u1eddi (Checkboxes). Ho\u1eb7c t\u1ef1 vi\u1ebft c\u00e2u tr\u1ea3 l\u1eddi (short answer).. . Ti\u1ebfp theo, ch\u00fang ta c\u00f3 th\u1ec3 thay \u0111\u1ed5i c\u00e1c t\u00f9y ch\u1ec9nh thi\u1ebft l\u1eadp cho giao di\u1ec7n form.<\/p>\n

Nh\u1eefng h\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng Google Sheet ph\u00eda tr\u00ean kh\u00e1 \u0111\u01a1n gi\u1ea3n v\u00e0 h\u1eefu \u00edch ph\u1ea3i kh\u00f4ng n\u00e0o? Ti\u1ebfp t\u1ee5c t\u00ecm hi\u1ec3u nh\u00e9.<\/p>\n

4. Ch\u00e8n h\u00ecnh \u1ea3nh v\u00e0o \u00f4 tr\u00ean Google Sheets:<\/h2>\n

Ngay t\u1ea1i \u00f4 c\u1ea7n ch\u00e8n \u1ea3nh, g\u00f5 =image(“URL \u1ea3nh mu\u1ed1n ch\u00e8n”). H\u00ecnh \u1ea3nh n\u00e0y s\u1ebd t\u1ef1 \u0111\u1ed9ng \u0111i\u1ec1u ch\u1ec9nh k\u00edch th\u01b0\u1edbc v\u1edbi \u00f4 \u0111\u00f3.<\/p>\n

Ch\u00fang ta c\u00f3 th\u1ec3 t\u1ef1 \u0111\u1ed9ng \u0111i\u1ec1u ch\u1ec9nh k\u00edch th\u01b0\u1edbc \u1ea3nh v\u1edbi c\u00e1c c\u00f4ng th\u1ee9c:<\/p>\n

=image (“URL \u1ea3nh”,2): thay \u0111\u1ed5i k\u00edch th\u01b0\u1edbc \u1ea3nh \u0111\u1ec3 v\u1eeba v\u1edbi \u00f4.<\/p>\n

=image (“URL \u1ea3nh “,3): gi\u1eef nguy\u00ean k\u00edch th\u01b0\u1edbc c\u1ee7a \u1ea3nh nh\u01b0ng kh\u00f4ng l\u00e0m thay \u0111\u1ed5i k\u00edch th\u01b0\u1edbc \u00f4.<\/p>\n

5. H\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng Google Sheet – \u0110\u1ecbnh d\u1ea1ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n tr\u00ean Google Sheets:<\/h2>\n

\u0110\u1ea7u ti\u00ean b\u1ea1n c\u1ea7n \u1ea5n Form, ch\u1ecdn Conditional formatting.<\/p>\n

Ngay b\u00ean ph\u1ea3i giao di\u1ec7n s\u1ebd xu\u1ea5t hi\u1ec7n m\u1ed9t h\u1ed9p tho\u1ea1i v\u1edbi c\u00e1c m\u1ee5c tr\u00ecnh b\u00e0y theo \u0111i\u1ec1u ki\u1ec7n.<\/p>\n

\u1ede \u0111\u00e2y, b\u1ea1n c\u00f3 th\u1ec3 l\u1ef1a ch\u1ecdn c\u1ed9t ho\u1eb7c h\u00e0ng mu\u1ed1n \u0111\u1ecbnh d\u1ea1ng theo \u0111i\u1ec1u ki\u1ec7n Apply to range. Ch\u1ecdn \u0111i\u1ec1u ki\u1ec7n \u0111\u1ec3 l\u1ecdc Format cells if, ch\u1ecdn m\u00e0u cho c\u1ed9t \u0111\u1ecbnh d\u1ea1ng theo quy lu\u1eadt,…<\/p>\n

Cu\u1ed1i c\u00f9ng nh\u1ea5n Done \u0111\u1ec3 l\u01b0u l\u1ea1i.<\/p>\n

Nh\u1eefng h\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng Google Sheet tr\u00ean kh\u00e1 \u0111\u01a1n gi\u1ea3n v\u1edbi nh\u1eefng thao t\u00e1c kh\u00f4ng qu\u00e1 ph\u1ee9c t\u1ea1p. 5 thao t\u00e1c c\u0169ng nh\u01b0 t\u00ednh n\u0103ng n\u00e0y s\u1ebd gi\u00fap ch\u00fang ta c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng th\u00e0nh th\u1ea1o Google Sheets h\u01a1n. T\u0103ng hi\u1ec7u su\u1ea5t l\u00e0m vi\u1ec7c v\u00e0 thao t\u00e1c nhanh h\u01a1n khi th\u1ef1c hi\u1ec7n x\u1eed l\u00fd d\u1eef li\u1ec7u v\u1edbi Google Sheet.<\/p>\n","protected":false},"excerpt":{"rendered":"

Google Sheets – m\u1ed9t c\u00f4ng c\u1ee5 v\u00f4 c\u00f9ng h\u1eefu \u00edch trong th\u1eddi \u0111\u1ea1i to\u00e0n c\u1ea7u hi\u1ec7n nay. Ch\u00fang ta c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng nh\u01b0 phi\u00ean b\u1ea3n Excel online, ti\u1ebfn h\u00e0nh k\u1ebb c\u00e1c b\u1ea3ng th\u00f4ng k\u00ea s\u1ed1 li\u1ec7u, l\u01b0u tr\u1eef d\u1eef li\u1ec7u tr\u1ef1c tuy\u1ebfn ngay khi nh\u1eadp n\u1ed9i dung. B\u00ean c\u1ea1nh \u0111\u00f3, Google Sheets h\u1ed7 tr\u1ee3 […]<\/p>\n","protected":false},"author":2,"featured_media":564,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[7],"tags":[44],"class_list":["post-562","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-online-marketing","tag-huong-dan-su-dung-google-sheet"],"jetpack_featured_media_url":"https:\/\/webvocuc.com\/blog\/wp-content\/uploads\/2020\/10\/5-huong-dan-su-dung-google-sheet-01_ztnb8m.jpg","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/webvocuc.com\/blog\/wp-json\/wp\/v2\/posts\/562","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/webvocuc.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/webvocuc.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/webvocuc.com\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/webvocuc.com\/blog\/wp-json\/wp\/v2\/comments?post=562"}],"version-history":[{"count":2,"href":"https:\/\/webvocuc.com\/blog\/wp-json\/wp\/v2\/posts\/562\/revisions"}],"predecessor-version":[{"id":6184,"href":"https:\/\/webvocuc.com\/blog\/wp-json\/wp\/v2\/posts\/562\/revisions\/6184"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/webvocuc.com\/blog\/wp-json\/wp\/v2\/media\/564"}],"wp:attachment":[{"href":"https:\/\/webvocuc.com\/blog\/wp-json\/wp\/v2\/media?parent=562"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/webvocuc.com\/blog\/wp-json\/wp\/v2\/categories?post=562"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/webvocuc.com\/blog\/wp-json\/wp\/v2\/tags?post=562"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}