{"id":6613,"date":"2020-10-14T16:41:07","date_gmt":"2020-10-14T09:41:07","guid":{"rendered":"http:\/\/gcloudvn.wam.vn\/google-sheets-cac-tinh-nang-moi-giup-cai-thien-va-phan-tich-du-lieu\/"},"modified":"2023-04-13T15:50:29","modified_gmt":"2023-04-13T08:50:29","slug":"google-sheets-cac-tinh-nang-moi-giup-cai-thien-va-phan-tich-du-lieu","status":"publish","type":"post","link":"https:\/\/gcloudvn.com\/en\/kienthuc\/google-sheets-cac-tinh-nang-moi-giup-cai-thien-va-phan-tich-du-lieu\/","title":{"rendered":"Google Sheets: New features to improve and analyze data"},"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\/kienthuc\/google-sheets-cac-tinh-nang-moi-giup-cai-thien-va-phan-tich-du-lieu\/#Co_gi_thay_doi\" >What\u2019s changing<\/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\/kienthuc\/google-sheets-cac-tinh-nang-moi-giup-cai-thien-va-phan-tich-du-lieu\/#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\/kienthuc\/google-sheets-cac-tinh-nang-moi-giup-cai-thien-va-phan-tich-du-lieu\/#Co_gi_quan_trong\" >What&#039;s 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\/kienthuc\/google-sheets-cac-tinh-nang-moi-giup-cai-thien-va-phan-tich-du-lieu\/#Thong_tin_them\" >Additional details<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/gcloudvn.com\/en\/kienthuc\/google-sheets-cac-tinh-nang-moi-giup-cai-thien-va-phan-tich-du-lieu\/#De_xuat_don_dep\" >Suggested cleaning<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/gcloudvn.com\/en\/kienthuc\/google-sheets-cac-tinh-nang-moi-giup-cai-thien-va-phan-tich-du-lieu\/#Thong_ke_cot\" >Column statistics<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/gcloudvn.com\/en\/kienthuc\/google-sheets-cac-tinh-nang-moi-giup-cai-thien-va-phan-tich-du-lieu\/#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-8\" href=\"https:\/\/gcloudvn.com\/en\/kienthuc\/google-sheets-cac-tinh-nang-moi-giup-cai-thien-va-phan-tich-du-lieu\/#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-9\" href=\"https:\/\/gcloudvn.com\/en\/kienthuc\/google-sheets-cac-tinh-nang-moi-giup-cai-thien-va-phan-tich-du-lieu\/#Kha_dung\" >Available now<\/a><\/li><\/ul><\/nav><\/div>\n<h2 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Co_gi_thay_doi\"><\/span><b>What\u2019s changing<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Google sheets \u0111ang ra m\u1eaft t\u00ednh n\u0103ng D\u1ecdn d\u1eb9p th\u00f4ng minh tr\u00ean Trang t\u00ednh, hai t\u00ednh n\u0103ng gi\u00fap chu\u1ea9n b\u1ecb v\u00e0 ph\u00e2n t\u00edch d\u1eef li\u1ec7u trong Trang t\u00ednh d\u1ec5 d\u00e0ng h\u01a1n:<\/span><\/p>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Cleanup recommendations, which help ensure your data is accurate by identifying and recommending fixes for common data errors.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Column statistics, which provide automatic insights into the values in a column, so you can identify outliers and quickly understand what your data looks like.\u00a0<\/span><\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Previously, Google announced that the feature <\/span><a href=\"https:\/\/cloud.google.com\/blog\/products\/g-suite\/connected-sheets-is-generally-available\" target=\"_blank\" rel=\"nofollow noopener\"><span style=\"font-weight: 400;\">Smart Cleanup of Sheets<\/span><\/a><span style=\"font-weight: 400;\"> coming soon.\u00a0<\/span><\/p>\n<h2 style=\"text-align: justify;\"><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 style=\"text-align: justify;\"><span style=\"font-weight: 400;\">End users<\/span><\/p>\n<h2 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Co_gi_quan_trong\"><\/span><b>What&#039;s important?<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">These features assist in identifying potential cleanup actions and give you more confidence that your data is not distorted by simple errors. It will also enable faster analysis by creating intelligent views that can help surface detailed information, which you can then choose to look at more closely.<\/span><\/p>\n<h2 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Thong_tin_them\"><\/span><b>Additional details<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<h3 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"De_xuat_don_dep\"><\/span><strong>Suggested cleaning<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Before analyzing and making decisions based on the data in your worksheet, it&#039;s important to clean your data by correcting errors and improving data consistency. Suggested cleaning helps you do this by displaying smart suggestions in the side panel. These suggestions may include removing extra spaces, removing duplicate rows, adding number formatting, identifying anomalies, fixing inconsistent data, etc. This can help clean up the data faster and more accurate.<\/span><\/p>\n<p style=\"text-align: justify;\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-17389 size-full\" src=\"https:\/\/gcloudvn.com\/wp-content\/uploads\/2020\/10\/Smart-cleanup-in-sheets.gif\" alt=\"Google Sheets: New features to help improve and analyze data (1)\" width=\"639\" height=\"472\" \/><\/p>\n<h3 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Thong_ke_cot\"><\/span><strong>Column statistics<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Column statistics can help you quickly understand your data by automatically creating visualizations and key statistics that provide detailed information about the data in a specific column. These insights can include count and distribution charts, frequency tables, and summary statistics. This can help you quickly catch potential outliers and confidently move on to deeper analysis.<\/span><\/p>\n<p style=\"text-align: justify;\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-17390 size-full\" src=\"https:\/\/gcloudvn.com\/wp-content\/uploads\/2020\/10\/Column-stats-in-sheets.gif\" alt=\"Google Sheets: New features to help improve and analyze data (2)\" width=\"639\" height=\"472\" \/><\/p>\n<h2 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Bat_dau\"><\/span><b>Getting started<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Admin: No permissions at all.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">End users<\/span>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Cleanup recommendations: When you&#039;re in Sheets, go to Data &gt; Cleanup recommendations. When you import data into Sheets, you may also see proactive notifications. <\/span><span style=\"font-weight: 400;\">Visit the Help Center<\/span><span style=\"font-weight: 400;\"> Google to learn more about cleaning recommendations.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Column Statistics: Once you&#039;re in Sheets, go to Data &gt; Column Statistics. <\/span><a href=\"https:\/\/support.corp.google.com\/docs\/answer\/10098582\" target=\"_blank\" rel=\"nofollow noopener\"><span style=\"font-weight: 400;\">Visit the Google Help Center<\/span><\/a><span style=\"font-weight: 400;\"> to learn more about column statistics.<\/span><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<h2 style=\"text-align: justify;\"><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 style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Rapid release domains: Gradual rollout (up to 15 days for feature visibility) starting September 29, 2020<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Scheduled release domains: Gradual release (up to 15 days for feature visibility) starting October 13, 2020<\/span><\/li>\n<\/ul>\n<h2 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Kha_dung\"><\/span><b>Available now<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Available to all G Suite customers and users with personal Google Accounts<\/span><\/li>\n<\/ul>\n<p style=\"text-align: right;\"><strong>Source: <a href=\"https:\/\/gcloudvn.com\/en\/\">Gimasys<\/a><\/strong><\/p>","protected":false},"excerpt":{"rendered":"<p>C\u00f3 g\u00ec thay \u0111\u1ed5i Google sheets \u0111ang ra m\u1eaft t\u00ednh n\u0103ng D\u1ecdn d\u1eb9p th\u00f4ng minh tr\u00ean Trang t\u00ednh, hai t\u00ednh n\u0103ng gi\u00fap chu\u1ea9n b\u1ecb v\u00e0 ph\u00e2n t\u00edch d\u1eef li\u1ec7u trong Trang t\u00ednh d\u1ec5 d\u00e0ng h\u01a1n: \u0110\u1ec1 xu\u1ea5t d\u1ecdn d\u1eb9p, gi\u00fap&hellip;<\/p>","protected":false},"author":1,"featured_media":6614,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"inline_featured_image":false,"footnotes":""},"categories":[1],"tags":[],"class_list":["post-6613","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-kienthuc","entry","has-media"],"_links":{"self":[{"href":"https:\/\/gcloudvn.com\/en\/wp-json\/wp\/v2\/posts\/6613","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\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/gcloudvn.com\/en\/wp-json\/wp\/v2\/comments?post=6613"}],"version-history":[{"count":0,"href":"https:\/\/gcloudvn.com\/en\/wp-json\/wp\/v2\/posts\/6613\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/gcloudvn.com\/en\/wp-json\/wp\/v2\/media\/6614"}],"wp:attachment":[{"href":"https:\/\/gcloudvn.com\/en\/wp-json\/wp\/v2\/media?parent=6613"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/gcloudvn.com\/en\/wp-json\/wp\/v2\/categories?post=6613"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/gcloudvn.com\/en\/wp-json\/wp\/v2\/tags?post=6613"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}