{"id":19357,"date":"2024-06-17T11:35:14","date_gmt":"2024-06-17T04:35:14","guid":{"rendered":"https:\/\/gcloudvn.com\/?p=19357"},"modified":"2024-07-31T09:57:47","modified_gmt":"2024-07-31T02:57:47","slug":"new-ways-to-quickly-format-and-organize-data-with-tables-in-google-sheets","status":"publish","type":"post","link":"https:\/\/gcloudvn.com\/en\/ban-tin\/new-ways-to-quickly-format-and-organize-data-with-tables-in-google-sheets\/","title":{"rendered":"New ways to quickly format and organize data with tables in Google Sheets\u00a0"},"content":{"rendered":"<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_80 counter-hierarchy ez-toc-counter ez-toc-grey ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Table of contents<\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"Toggle Table of Content\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewbox=\"0 0 24 24\" version=\"1.2\" baseprofile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/span><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/gcloudvn.com\/en\/ban-tin\/new-ways-to-quickly-format-and-organize-data-with-tables-in-google-sheets\/#Co_gi_thay_doi\" >What\u2019s changing\u00a0<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/gcloudvn.com\/en\/ban-tin\/new-ways-to-quickly-format-and-organize-data-with-tables-in-google-sheets\/#Ai_bi_anh_huong\" >Who\u2019s impacted<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/gcloudvn.com\/en\/ban-tin\/new-ways-to-quickly-format-and-organize-data-with-tables-in-google-sheets\/#Tai_sao_lai_quan_trong\" >Why it\u2019s important<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/gcloudvn.com\/en\/ban-tin\/new-ways-to-quickly-format-and-organize-data-with-tables-in-google-sheets\/#Bat_dau\" >Getting started<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/gcloudvn.com\/en\/ban-tin\/new-ways-to-quickly-format-and-organize-data-with-tables-in-google-sheets\/#Thoi_gian_trien_khai\" >Rollout pace<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/gcloudvn.com\/en\/ban-tin\/new-ways-to-quickly-format-and-organize-data-with-tables-in-google-sheets\/#Tinh_kha_dung\" >Availability<\/a><\/li><\/ul><\/nav><\/div>\n<h2><span class=\"ez-toc-section\" id=\"Co_gi_thay_doi\"><\/span><b>What\u2019s changing\u00a0<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400;\">Google know it can be time consuming to perform repetitive tasks like updating data in a spreadsheet. In addition, maintaining the structure and format of the data can be difficult when there are multiple people updating the document.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">\u0110\u1ec3 gi\u00fap gi\u1ea3i quy\u1ebft v\u1ea5n \u0111\u1ec1 n\u00e0y, Google r\u1ea5t vui m\u1eebng \u0111\u01b0\u1ee3c gi\u1edbi thi\u1ec7u b\u1ea3ng trong Google Trang t\u00ednh. V\u1edbi b\u1ea3ng, b\u1ea1n c\u00f3 th\u1ec3 \u0111\u01a1n gi\u1ea3n h\u00f3a v\u00e0 t\u0103ng t\u1ed1c vi\u1ec7c x\u00e2y d\u1ef1ng b\u1ea3ng t\u00ednh b\u1eb1ng c\u00e1ch \u0111\u01b0a \u0111\u1ecbnh d\u1ea1ng v\u00e0 c\u1ea5u tr\u00fac v\u00e0o c\u00e1c ph\u1ea1m vi kh\u00f4ng \u0111\u01b0\u1ee3c s\u1eafp x\u1ebfp. B\u1eb1ng c\u00e1ch ch\u1ecdn ph\u1ea1m vi d\u1eef li\u1ec7u c\u1ee7a b\u1ea1n v\u00e0 v\u00e0o \u0110\u1ecbnh d\u1ea1ng &gt; Chuy\u1ec3n \u0111\u1ed5i th\u00e0nh b\u1ea3ng, Trang t\u00ednh hi\u1ec7n th\u1ef1c hi\u1ec7n c\u00f4ng vi\u1ec7c n\u1eb7ng nh\u1ecdc l\u00e0 \u0111\u1ecbnh d\u1ea1ng v\u00e0 s\u1eafp x\u1ebfp d\u1eef li\u1ec7u v\u1edbi thi\u1ebft k\u1ebf \u0111\u01b0\u1ee3c trau chu\u1ed1t bao g\u1ed3m c\u00e1c lo\u1ea1i c\u1ed9t, b\u1ed9 l\u1ecdc, m\u00e3 m\u00e0u, menu th\u1ea3 xu\u1ed1ng v\u00e0 nhi\u1ec1u h\u01a1n n\u1eefa.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Sau \u0111\u00e2y l\u00e0 c\u00e1ch s\u1eed d\u1ee5ng b\u1ea3ng gi\u00fap gi\u1ea3m th\u1eddi gian b\u1ea1n th\u01b0\u1eddng ph\u1ea3i d\u00e0nh \u0111\u1ec3 \u0111\u1ecbnh d\u1ea1ng d\u1eef li\u1ec7u theo c\u00e1ch th\u1ee7 c\u00f4ng:<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Auto-applied formatting: When you convert your data to a table, Sheets automatically applies formatting to polish your data so that all inputs are properly aligned, reducing the need for manual changes. You can further customize your table by changing colors, readjusting the row height, and more.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Column types: For each column, you can set the appropriate column type (e.g., date, currency, dropdown), and your table will make sure all entered data has the right formatting based on the column type. Data entered that does not align with a set column type will result in a warning.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Unified menu: Above the table, you will see a menu option to manage table-level settings (e.g., adjust table range) and take action (e.g., create a filter view for your table).<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Table references: Table references are a special way to refer to a table or parts of a table in a formula. When you convert your data to a table, Sheets provides a name for the table and each column header. When you reference table elements by name, the references update whenever you add or remove data from the table. For example: Instead of explicit cell references: =COUNTIF(B2:B10, \u201cP0\u201d), you can use table references: =COUNTIF(Task_tracker[Priority], \u201cP0\u201d).<\/span><\/li>\n<\/ul>\n<p><span style=\"font-weight: 400;\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-19358\" src=\"https:\/\/gcloudvn.com\/wp-content\/uploads\/2024\/06\/Screenshot-2024-06-17-at-10.17.37.png\" alt=\"\" width=\"1286\" height=\"1138\" srcset=\"https:\/\/gcloudvn.com\/wp-content\/uploads\/2024\/06\/Screenshot-2024-06-17-at-10.17.37.png 1286w, https:\/\/gcloudvn.com\/wp-content\/uploads\/2024\/06\/Screenshot-2024-06-17-at-10.17.37-768x680.png 768w, https:\/\/gcloudvn.com\/wp-content\/uploads\/2024\/06\/Screenshot-2024-06-17-at-10.17.37-14x12.png 14w\" sizes=\"auto, (max-width: 1286px) 100vw, 1286px\" \/><\/span><\/p>\n<p><span style=\"font-weight: 400;\">When you are using tables, you\u2019ll also have access to our new type of view, group by, where you can aggregate your data into groups based on a selected column. For instance, you can decide to group all data at the same priority level in one place, as shown below.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Google is also introducing pre-built tables that you can populate with common data types for everyday tasks like project management, inventory management, event planning and more. Now with pre-built tables, you never have to build a spreadsheet from scratch again.<\/span><\/p>\n<h3><b><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-19359\" src=\"https:\/\/gcloudvn.com\/wp-content\/uploads\/2024\/06\/Screenshot-2024-06-17-at-10.21.51.png\" alt=\"\" width=\"1748\" height=\"1106\" srcset=\"https:\/\/gcloudvn.com\/wp-content\/uploads\/2024\/06\/Screenshot-2024-06-17-at-10.21.51.png 1748w, https:\/\/gcloudvn.com\/wp-content\/uploads\/2024\/06\/Screenshot-2024-06-17-at-10.21.51-768x486.png 768w, https:\/\/gcloudvn.com\/wp-content\/uploads\/2024\/06\/Screenshot-2024-06-17-at-10.21.51-1536x972.png 1536w, https:\/\/gcloudvn.com\/wp-content\/uploads\/2024\/06\/Screenshot-2024-06-17-at-10.21.51-18x12.png 18w\" sizes=\"auto, (max-width: 1748px) 100vw, 1748px\" \/><\/b><\/h3>\n<h2><span class=\"ez-toc-section\" id=\"Ai_bi_anh_huong\"><\/span><b>Who\u2019s impacted<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400;\">End users<\/span><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Tai_sao_lai_quan_trong\"><\/span><b>Why it\u2019s important<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400;\">Tables will transform the way teams organize their data, simplify data creation, and reduce the repetitive tasks needed to format, input, and update data. They also allow teams to confidently share data widely while maintaining its integrity and consistency.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Tables are Googlell suited for tracking and organizing information such as project tracking, event planning, and inventory management.<\/span><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Bat_dau\"><\/span><b>Getting started<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Admins: There is no admin control for this feature.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">End users: Visit the Help Center to learn more about <\/span><a href=\"https:\/\/support.google.com\/docs\/answer\/14239833\" target=\"_blank\" rel=\"noopener\"><span style=\"font-weight: 400;\">using tables in Google Sheets<\/span><\/a><span style=\"font-weight: 400;\">.\u00a0<\/span><\/li>\n<\/ul>\n<h2><span class=\"ez-toc-section\" id=\"Thoi_gian_trien_khai\"><\/span><b>Rollout pace<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Rapid Release domains: Extended rollout (potentially longer than 15 days for feature visibility) starting on May 8, 2024, with expected completion by June 13, 2024<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Scheduled Release domains: Gradual rollout (up to 15 days for feature visibility) starting on June 13, 2024<\/span><\/li>\n<\/ul>\n<h2><span class=\"ez-toc-section\" id=\"Tinh_kha_dung\"><\/span><b>Availability<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Available to all Google Workspace customers, Google Workspace Individual subscribers, and users with personal Google accounts<\/span><\/li>\n<\/ul>\n<p style=\"text-align: right;\"><strong>Source: Gimasys<\/strong><\/p>","protected":false},"excerpt":{"rendered":"<p>C\u00f3 g\u00ec thay \u0111\u1ed5i\u00a0 Google bi\u1ebft r\u1eb1ng vi\u1ec7c th\u1ef1c hi\u1ec7n c\u00e1c t\u00e1c v\u1ee5 l\u1eb7p \u0111i l\u1eb7p l\u1ea1i nh\u01b0 c\u1eadp nh\u1eadt d\u1eef li\u1ec7u trong b\u1ea3ng t\u00ednh c\u00f3 th\u1ec3 t\u1ed1n th\u1eddi gian. Ngo\u00e0i ra, vi\u1ec7c duy tr\u00ec c\u1ea5u tr\u00fac v\u00e0 \u0111\u1ecbnh d\u1ea1ng&hellip;<\/p>","protected":false},"author":2,"featured_media":15121,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"inline_featured_image":false,"footnotes":""},"categories":[134],"tags":[],"class_list":["post-19357","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-google-workspace","entry","has-media"],"_links":{"self":[{"href":"https:\/\/gcloudvn.com\/en\/wp-json\/wp\/v2\/posts\/19357","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/gcloudvn.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/gcloudvn.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/gcloudvn.com\/en\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/gcloudvn.com\/en\/wp-json\/wp\/v2\/comments?post=19357"}],"version-history":[{"count":0,"href":"https:\/\/gcloudvn.com\/en\/wp-json\/wp\/v2\/posts\/19357\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/gcloudvn.com\/en\/wp-json\/wp\/v2\/media\/15121"}],"wp:attachment":[{"href":"https:\/\/gcloudvn.com\/en\/wp-json\/wp\/v2\/media?parent=19357"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/gcloudvn.com\/en\/wp-json\/wp\/v2\/categories?post=19357"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/gcloudvn.com\/en\/wp-json\/wp\/v2\/tags?post=19357"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}