{"id":6053,"date":"2019-09-10T14:59:33","date_gmt":"2019-09-10T07:59:33","guid":{"rendered":"http:\/\/gcloudvn.wam.vn\/cac-cong-cu-bo-sung-cho-bao-cao-nang-cao-trong-google-sheets\/"},"modified":"2023-05-08T14:04:51","modified_gmt":"2023-05-08T07:04:51","slug":"cac-cong-cu-bo-sung-cho-bao-cao-nang-cao-trong-google-sheets","status":"publish","type":"post","link":"https:\/\/gcloudvn.com\/en\/kienthuc\/cac-cong-cu-bo-sung-cho-bao-cao-nang-cao-trong-google-sheets\/","title":{"rendered":"Additional tools for advanced reporting in Google Sheets"},"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\/cac-cong-cu-bo-sung-cho-bao-cao-nang-cao-trong-google-sheets\/#Nhung_gi_thay_doi\" >What changed?\u00a0\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\/kienthuc\/cac-cong-cu-bo-sung-cho-bao-cao-nang-cao-trong-google-sheets\/#Ai_se_chiu_anh_huong\" >Who will be affected?<\/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\/cac-cong-cu-bo-sung-cho-bao-cao-nang-cao-trong-google-sheets\/#Tai_sao_ban_lai_su_dung_chung\" >Why are you using them?\u00a0<\/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\/cac-cong-cu-bo-sung-cho-bao-cao-nang-cao-trong-google-sheets\/#Lam_the_nao_de_bat_dau\" >How to get 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\/kienthuc\/cac-cong-cu-bo-sung-cho-bao-cao-nang-cao-trong-google-sheets\/#Chi_tiet_bo_sung\" >Additional details\u00a0<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/gcloudvn.com\/en\/kienthuc\/cac-cong-cu-bo-sung-cho-bao-cao-nang-cao-trong-google-sheets\/#Slicers\" >Slicers:<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/gcloudvn.com\/en\/kienthuc\/cac-cong-cu-bo-sung-cho-bao-cao-nang-cao-trong-google-sheets\/#Scorecard_charts\" >Scorecard charts:<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/gcloudvn.com\/en\/kienthuc\/cac-cong-cu-bo-sung-cho-bao-cao-nang-cao-trong-google-sheets\/#Themes\" >Themes:<\/a><\/li><\/ul><\/li><\/ul><\/nav><\/div>\n<h2 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Nhung_gi_thay_doi\"><\/span><span style=\"font-size: 14pt;\"><b>What changed?\u00a0\u00a0<\/b><\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">We&#039;ve added three new tools to help you create more compelling reports and display data better in Google Sheets.\u00a0<\/span><\/p>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Slicers<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Scorecard Charts<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Themes<\/span><\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><a href=\"https:\/\/gsuiteupdates.googleblog.com\/2019\/04\/new-tools-sheets.html\" target=\"_blank\" rel=\"nofollow noopener\"><span style=\"font-weight: 400;\"><span style=\"color: #0000ff;\">Earlier this year we announced some new features for objects in Sheets<\/span><\/span><\/a><span style=\"font-weight: 400;\">. Together, these new features create a more impactful reporting experience in Sheets.\u00a0<\/span><\/p>\n<figure id=\"attachment_14742\" aria-describedby=\"caption-attachment-14742\" style=\"width: 640px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-14742 size-full\" src=\"https:\/\/gcloudvn.com\/wp-content\/uploads\/2019\/09\/air-asia-dashboard-1.gif\" alt=\"Using Slicers, Scorecard Charts, and Themes together to enhance reporting.\" width=\"640\" height=\"425\" \/><figcaption id=\"caption-attachment-14742\" class=\"wp-caption-text\"><em>Using Slicers, Scorecard Charts, and Themes together to enhance reporting.<\/em><\/figcaption><\/figure>\n<h2 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Ai_se_chiu_anh_huong\"><\/span><span style=\"font-size: 14pt;\"><b>Who will be affected?<\/b><\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">End users\u00a0<\/span><\/p>\n<h2 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Tai_sao_ban_lai_su_dung_chung\"><\/span><span style=\"font-size: 14pt;\"><b>Why are you using them?\u00a0<\/b><\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">You can use these tools to filter, display key data, and customize the look and feel of your spreadsheets, making it easier and faster to create attractive, informative reports\u00a0<\/span><\/p>\n<h2 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Lam_the_nao_de_bat_dau\"><\/span><span style=\"font-size: 14pt;\"><b>How to get started<\/b><\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\"><b>Admins:<\/b><span style=\"font-weight: 400;\"> No action<\/span><\/li>\n<li style=\"font-weight: 400;\"><b>End users: <\/b><span style=\"font-weight: 400;\">See details below on how to use the new tools in Sheets.<\/span><\/li>\n<\/ul>\n<h2 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Chi_tiet_bo_sung\"><\/span><span style=\"font-size: 14pt;\"><b>Additional details\u00a0<\/b><\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<ul style=\"text-align: justify;\">\n<li>\n<h3><span class=\"ez-toc-section\" id=\"Slicers\"><\/span><span style=\"color: #333399;\"><b>Slicers:<\/b><\/span><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<\/li>\n<\/ul>\n<p style=\"padding-left: 40px; text-align: justify;\"><span style=\"font-weight: 400;\">Slicers are a new way of filtering reports or dashboards by condition and by values. <\/span><a href=\"https:\/\/support.google.com\/docs\/answer\/9245556\" target=\"_blank\" rel=\"nofollow noopener\"><span style=\"font-weight: 400;\"><span style=\"color: #0000ff;\">To learn more about using Slicers in Pages, check out our help center.<\/span><\/span><\/a><\/p>\n<ul style=\"text-align: justify;\">\n<li>\n<h3><span class=\"ez-toc-section\" id=\"Scorecard_charts\"><\/span><span style=\"color: #333399;\"><b>Scorecard charts:<\/b><\/span><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<\/li>\n<\/ul>\n<p style=\"padding-left: 40px; text-align: justify;\"><span style=\"font-weight: 400;\">Scorecard charts are a new way to call up key metrics, such as KPIs, or key metrics, in your worksheet. You have the option of showing your metrics relative to another number, for example showing a percentage increase or decrease over time. <\/span><span style=\"color: #0000ff;\"><a style=\"color: #0000ff;\" href=\"https:\/\/support.google.com\/docs\/answer\/9245873\" target=\"_blank\" rel=\"nofollow noopener\"><span style=\"font-weight: 400;\">See our help center for more information on how to insert a Scorecard chart in Sheets<\/span><\/a><span style=\"font-weight: 400;\">.\u00a0<\/span><\/span><\/p>\n<ul style=\"text-align: justify;\">\n<li>\n<h3><span class=\"ez-toc-section\" id=\"Themes\"><\/span><span style=\"color: #333399;\"><b>Themes:<\/b><\/span><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<\/li>\n<\/ul>\n<p style=\"padding-left: 40px; text-align: justify;\"><span style=\"font-weight: 400;\">Now you can quickly change the look and feel of your entire spreadsheet \u2013 including charts, and cells \u2013 to ensure a consistent look and feel for your spreadsheets. To apply an existing theme, select <\/span><i><span style=\"font-weight: 400;\">Format &gt; Theme <\/span><\/i><span style=\"font-weight: 400;\">and select an option, or to create a custom theme, select <\/span><b>Customize<\/b><span style=\"font-weight: 400;\"> at the top right.\u00a0<\/span><\/p>\n<p style=\"text-align: right;\"><strong>Source: <a href=\"https:\/\/gcloudvn.com\/en\/\">Gimasys<\/a><\/strong><\/p>\n<div id=\"gtx-trans\" style=\"position: absolute; left: 1px; top: 84.6667px;\">\n<div class=\"gtx-trans-icon\" style=\"text-align: justify;\"><\/div>\n<\/div>","protected":false},"excerpt":{"rendered":"<p>Nh\u1eefng g\u00ec thay \u0111\u1ed5i\u00a0\u00a0 Ch\u00fang t\u00f4i \u0111\u00e3 th\u00eam ba c\u00f4ng c\u1ee5 m\u1edbi \u0111\u1ec3 gi\u00fap b\u1ea1n t\u1ea1o c\u00e1c b\u00e1o c\u00e1o h\u1ea5p d\u1eabn h\u01a1n v\u00e0 d\u1eef li\u1ec7u hi\u1ec3n th\u1ecb t\u1ed1t h\u01a1n trong Google Sheets.\u00a0 Slicers Scorecard Charts Themes \u0110\u1ea7u n\u0103m nay ch\u00fang&hellip;<\/p>","protected":false},"author":1,"featured_media":6054,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"inline_featured_image":false,"footnotes":""},"categories":[1],"tags":[],"class_list":["post-6053","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\/6053","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=6053"}],"version-history":[{"count":0,"href":"https:\/\/gcloudvn.com\/en\/wp-json\/wp\/v2\/posts\/6053\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/gcloudvn.com\/en\/wp-json\/wp\/v2\/media\/6054"}],"wp:attachment":[{"href":"https:\/\/gcloudvn.com\/en\/wp-json\/wp\/v2\/media?parent=6053"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/gcloudvn.com\/en\/wp-json\/wp\/v2\/categories?post=6053"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/gcloudvn.com\/en\/wp-json\/wp\/v2\/tags?post=6053"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}