{"id":5189,"date":"2018-05-10T15:16:45","date_gmt":"2018-05-10T08:16:45","guid":{"rendered":"http:\/\/gcloudvn.wam.vn\/cach-tu-dong-hoa-cac-cong-viec-tren-google-sheet-voi-macro\/"},"modified":"2024-05-15T14:32:44","modified_gmt":"2024-05-15T07:32:44","slug":"cach-tu-dong-hoa-cac-cong-viec-tren-google-sheet-voi-macro","status":"publish","type":"post","link":"https:\/\/gcloudvn.com\/en\/kienthuc\/cach-tu-dong-hoa-cac-cong-viec-tren-google-sheet-voi-macro\/","title":{"rendered":"How to automate tasks on Google Sheet with Macro"},"content":{"rendered":"<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Since its inception nearly 40 years ago, Spreadsheets have remained the core product for helping businesses get work done. From quarterly revenue analysis to product catalog updates, spreadsheets are the primary tool for helping companies collect and share data, helping you make more informed decisions quickly \u2013 so What more will you get when this already-useful product is brought to the cloud?<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Google has been focusing on making Google Sheets better for businesses, and that&#039;s why Google recently added new features to help business teams analyze and visualize their data. On April 11, Google announced additional updates to Sheet, including:<\/span><\/p>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">How to save macros in the cloud to automate repetitive actions<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Other format options.<\/span><\/li>\n<\/ul>\n<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\/cach-tu-dong-hoa-cac-cong-viec-tren-google-sheet-voi-macro\/#Vay_Macro_la_gi\" >So what are Macros?<\/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\/cach-tu-dong-hoa-cac-cong-viec-tren-google-sheet-voi-macro\/#Them_cac_cap_nhat_moi_cho_Sheets\" >Add new updates to Sheets<\/a><\/li><\/ul><\/nav><\/div>\n<h2 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Vay_Macro_la_gi\"><\/span><b><i>So what are Macros? <\/i><\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify;\"><b>Macro<\/b><span style=\"font-weight: 400;\"> tool to help you <\/span><b>automation<\/b><span style=\"font-weight: 400;\"> some operations that you must<\/span><b> repeat <\/b><span style=\"font-weight: 400;\">when working on GoogleSheet, it is a command to execute a certain job script. <\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">To put it simply, when you save a macro is when <\/span><b>you shoot a video<\/b><span style=\"font-weight: 400;\"> perform a sequence of actions: action A, then action B, C, and ending with action D. After that, Google Sheets will <\/span><b>Based on that video and do exactly what you just did<\/b><span style=\"font-weight: 400;\">, with other files. So, instead of having to do the same sequence of operations over and over, on different files, now you only need to make a sample once and Sheets will automatically do the rest.<\/span><\/p>\n<p style=\"text-align: justify;\"><b>Record macros in Google Sheets, skipping redundant operations<\/b><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Google wants to help companies automate work by approaching macros in a different way: the cloud. You can now record macros in Sheets. Let&#039;s say you need to format newly imported data or build the same chart type on multiple pages of quarterly data. Repeating the same steps manually can take hours, but thanks to sheets&#039; macro recording feature, you can record certain actions and let Google sheets follow through without having to write any code. which code.<\/span><\/p>\n<div style=\"text-align: justify;\"><iframe loading=\"lazy\" src=\"https:\/\/www.youtube.com\/embed\/DCW1J3zg4YM\" width=\"854\" height=\"480\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><\/iframe><\/div>\n<p style=\"text-align: justify;\"><em>Instructions on how to use Macros in Google Sheet to automate operations.<\/em><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Here&#039;s how macros work: When you record a macro, Sheets automatically converts the action you just took into one <\/span><a href=\"https:\/\/developers.google.com\/apps-script\/overview\" target=\"_blank\" rel=\"nofollow noopener\"><span style=\"font-weight: 400;\">Apps Script \u2013 Application Scripts<\/span><\/a><span style=\"font-weight: 400;\">. If you want to update your macros, you can simply re-edit the scripts directly instead of having to rewrite the macros from scratch. You can also <\/span><a href=\"https:\/\/developers.google.com\/apps-script\/guides\/sheets\/macros\" target=\"_blank\" rel=\"nofollow noopener\"><span style=\"font-weight: 400;\">write your own application scripts<\/span><\/a><span style=\"font-weight: 400;\"> and <\/span><a href=\"https:\/\/developers.google.com\/apps-script\/guides\/sheets\/macros#importing_functions_as_macros\" target=\"_blank\" rel=\"nofollow noopener\"><span style=\"font-weight: 400;\">import it into new macros<\/span><\/a><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">The best part about macros in Sheets is that they are designed for use in files built on the Cloud platform. That means a team can run macros at the same time as other teams are also working on that sheet, without affecting each other&#039;s work. For example, a finance team with a budget meeting can run a macro while reviewing the same spreadsheet. This also means that colleagues or customers won&#039;t need to download files containing sensitive data to use your macros. Since your Sheets file is in the Cloud, you can <\/span><a href=\"https:\/\/support.google.com\/docs\/answer\/2494893?co=GENIE.Platform%3DDesktop&amp;hl=en\" target=\"_blank\" rel=\"nofollow noopener\"><span style=\"font-weight: 400;\">tighter control<\/span><\/a><span style=\"font-weight: 400;\"> for who can view and reshare your data.<\/span><\/p>\n<h2 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Them_cac_cap_nhat_moi_cho_Sheets\"><\/span><b>Add new updates to Sheets<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">It&#039;s easy to see that over the past few years, Google has been working to build Sheet features to help businesses view, analyze and share their data more easily. This includes the addition of new chart types (e.g. histogram <\/span><span style=\"font-weight: 400;\">waterfall and 3D<\/span><span style=\"font-weight: 400;\"><a href=\"https:\/\/gcloudvn.com\/en\/kienthuc\/google-sheets-giup-doanh-nghiep-phan-tich-du-lieu-chuyen-sau\/\">)<\/a>, or how <\/span><span style=\"font-weight: 400;\">dip<\/span><span style=\"font-weight: 400;\"><a href=\"https:\/\/gcloudvn.com\/en\/kienthuc\/nhung-bieu-do-tu-google-sheets-vao-google-docs-va-slides\/\">\u00a0and update charts in Docs and Slides<\/a> (even when you move files), more functions (now more than <\/span><span style=\"font-weight: 400;\">400<\/span><span style=\"font-weight: 400;\"> features), additional features options <\/span><a href=\"https:\/\/gsuiteupdates.googleblog.com\/2017\/02\/support-for-rotated-text-accounting.html\" target=\"_blank\" rel=\"nofollow noopener\"><span style=\"font-weight: 400;\">text formatting \u2013 formatting<\/span><\/a><span style=\"font-weight: 400;\">, the<\/span><a href=\"https:\/\/support.google.com\/docs\/table\/25273\" target=\"_blank\" rel=\"nofollow noopener\"><span style=\"font-weight: 400;\"> print option<\/span><\/a><span style=\"font-weight: 400;\"> and more.<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Google also announced other requested features, including the ability to<\/span><a href=\"https:\/\/support.google.com\/docs\/answer\/7663148\" target=\"_blank\" rel=\"nofollow noopener\"><span style=\"font-weight: 400;\"> add print page breaks, customize paper size<\/span><\/a><span style=\"font-weight: 400;\">, more options for <\/span><a href=\"https:\/\/support.google.com\/docs\/answer\/54813\" target=\"_blank\" rel=\"nofollow noopener\"><span style=\"font-weight: 400;\">grouping rows and columns<\/span><\/a><span style=\"font-weight: 400;\"> and <\/span><a href=\"https:\/\/support.google.com\/docs\/answer\/7684717\" target=\"_blank\" rel=\"nofollow noopener\"><span style=\"font-weight: 400;\">how to add checkboxes in cells<\/span><\/a><span style=\"font-weight: 400;\"> of file sheets. Google can help you too<\/span><a href=\"https:\/\/support.google.com\/docs\/answer\/7572895\" target=\"_blank\" rel=\"nofollow noopener\"><span style=\"font-weight: 400;\"> grouping data<\/span><\/a><span style=\"font-weight: 400;\"> according to the time frame (like week, month, or year) when you create the pivot table.<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Regarding pivot tables, Google&#039;s engineering team has also worked hard to bring the power of artificial intelligence to Sheets to help teams pull more information from their data. You may have noticed that recently Google added <\/span><a href=\"https:\/\/blog.google\/products\/g-suite\/pivot-cloud-intelligent-features-google-sheets-help-businesses-uncover-insights\/\" target=\"_blank\" rel=\"nofollow noopener\"><span style=\"font-weight: 400;\">pivot tables \u2013 smart pivot table<\/span><\/a><span style=\"font-weight: 400;\"> in sheets, to help you analyze data more deeply, whether you are a master of numbers or just a beginner.<\/span><\/p>\n<p style=\"text-align: justify;\">Also, you can see more about <a href=\"https:\/\/gcloudvn.com\/en\/kienthuc\/huong-dan-han-che-quyen-truy-cap-trong-google-sheets\/\" target=\"_blank\" rel=\"noopener\">how to limit editing permission in Google Sheets here.<\/a><\/p>\n<p>&nbsp;<\/p>\n<p style=\"text-align: right;\"><strong>Updated: Gimasys<\/strong><\/p>","protected":false},"excerpt":{"rendered":"<p>K\u1ec3 t\u1eeb khi ra \u0111\u1eddi c\u00e1ch \u0111\u00e2y g\u1ea7n 40 n\u0103m, c\u00e1c trang t\u00ednh &#8211; Spreadsheet v\u1eabn l\u00e0 s\u1ea3n ph\u1ea9m c\u1ed1t l\u00f5i \u0111\u1ec3 gi\u00fap c\u00e1c doanh nghi\u1ec7p ho\u00e0n th\u00e0nh c\u00f4ng vi\u1ec7c. T\u1eeb ph\u00e2n t\u00edch doanh thu h\u00e0ng qu\u00fd \u0111\u1ec3 c\u1eadp nh\u1eadt&hellip;<\/p>","protected":false},"author":1,"featured_media":5190,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"inline_featured_image":false,"footnotes":""},"categories":[1],"tags":[],"class_list":["post-5189","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\/5189","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=5189"}],"version-history":[{"count":0,"href":"https:\/\/gcloudvn.com\/en\/wp-json\/wp\/v2\/posts\/5189\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/gcloudvn.com\/en\/wp-json\/wp\/v2\/media\/5190"}],"wp:attachment":[{"href":"https:\/\/gcloudvn.com\/en\/wp-json\/wp\/v2\/media?parent=5189"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/gcloudvn.com\/en\/wp-json\/wp\/v2\/categories?post=5189"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/gcloudvn.com\/en\/wp-json\/wp\/v2\/tags?post=5189"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}