{"id":5280,"date":"2018-06-26T17:22:08","date_gmt":"2018-06-26T10:22:08","guid":{"rendered":"http:\/\/gcloudvn.wam.vn\/cac-tinh-nang-co-ban-chua-biet-trong-google-sheets\/"},"modified":"2023-06-12T10:51:50","modified_gmt":"2023-06-12T03:51:50","slug":"cac-tinh-nang-co-ban-chua-biet-trong-google-sheets","status":"publish","type":"post","link":"https:\/\/gcloudvn.com\/en\/kienthuc\/cac-tinh-nang-co-ban-chua-biet-trong-google-sheets\/","title":{"rendered":"Features you may not know in Google Sheets"},"content":{"rendered":"<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Google Sheet is a tool provided by Google to users with the ability to manipulate spreadsheets (Spreadsheet), simplify and optimize teamwork, to maximize productivity based on electricity. cloud computing. <\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">In addition to providing all the basic functions to work, Google Sheet also provides advanced features, features that users may rarely use but extremely useful.<\/span><\/p>\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\/cac-tinh-nang-co-ban-chua-biet-trong-google-sheets\/#Them_hinh_anh_vao_bang_tinh\" >Add images to spreadsheets<\/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-tinh-nang-co-ban-chua-biet-trong-google-sheets\/#Khoa_Sheet_hoac_Cell_de_dam_bao_toan_ven_du_lieu\" >Lock Sheet or Cell to ensure data integrity<\/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-tinh-nang-co-ban-chua-biet-trong-google-sheets\/#Add-ons_%E2%80%93_Toi_da_hoa_tinh_nang_cua_Google_Sheets\" >Add-ons \u2013 Maximize the functionality of Google Sheets<\/a><\/li><\/ul><\/nav><\/div>\n<h2 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Them_hinh_anh_vao_bang_tinh\"><\/span><b>Add images to spreadsheets<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Sometimes you need to add images to Sheets for some reason?. Simple syntax \u00a0<\/span><b>=image(\u201cURL of the image\u201d) <\/b><span style=\"font-weight: 400;\">supported by Google in Google Sheets will help you do just that.<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\"> Besides, there are some advanced syntaxes that can be used as follows<\/span><\/p>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\"><b>=image(\u201cURL of the image\u201d,1)<\/b><span style=\"font-weight: 400;\"> \u2013 The image is inserted into a cell in Spreadsheets.<\/span><\/li>\n<li style=\"font-weight: 400;\"><b>=image(\u201cURL of the image\u201d,1)<\/b><span style=\"font-weight: 400;\"> \u2013 Image is inserted into 2 cells in Spreadsheets.<\/span><\/li>\n<li style=\"font-weight: 400;\"><b>=image(\u201cURL of the image\u201d,1)<\/b><span style=\"font-weight: 400;\"> \u2013 The image is inserted into 3 cells in Spreadsheets.<\/span><\/li>\n<li style=\"font-weight: 400;\"><b>=image(\u201cURL of the image\u201d,1)<\/b><span style=\"font-weight: 400;\"> \u2013 Image is inserted into 4 cells in Spreadsheets<\/span><\/li>\n<\/ul>\n<h2 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Khoa_Sheet_hoac_Cell_de_dam_bao_toan_ven_du_lieu\"><\/span><b>Lock Sheet or Cell to ensure data integrity<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">When sharing data, you may need to ensure that the data you previously entered is intact and has not been altered by others. Feature &quot;<\/span><b>Protect sheet<\/b><span style=\"font-weight: 400;\">\u201d provided by Google into Google Sheets will help you do this.<\/span><\/p>\n<p style=\"text-align: justify;\">You can see <a href=\"https:\/\/gcloudvn.com\/en\/kienthuc\/huong-dan-han-che-quyen-truy-cap-trong-google-sheets\/\" target=\"_blank\" rel=\"noopener\">Instructions to restrict access in Google Sheets<\/a>.<\/p>\n<h2 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Add-ons_%E2%80%93_Toi_da_hoa_tinh_nang_cua_Google_Sheets\"><\/span><b> Add-ons \u2013 Maximize the functionality of Google Sheets<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Receiving support and contributions from the community through <\/span><b>Add-ons (extensions \u2013 extensions)<\/b><span style=\"font-weight: 400;\"> from Google, the capabilities of Google Sheets are supported to the maximum, similar to Google Chrome,\u00a0<\/span><b>Google Sheets<\/b><span style=\"font-weight: 400;\"> have a warehouse <\/span><b>Add-ons\u00a0<\/b><span style=\"font-weight: 400;\">with hundreds of functions researched and added by third parties.<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Users simply need to click on the\u00a0<\/span><b>Add-ons\u00a0<\/b>in the toolbar, select <strong>Get add-ons:<\/strong><\/p>\n<p style=\"text-align: justify;\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-7173 size-full\" src=\"https:\/\/gcloudvn.com\/wp-content\/uploads\/2018\/06\/step-two.png\" alt=\"Features you may not know in Google Sheets 1\" width=\"1000\" height=\"522\" \/><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">When this store of add-ons appears, you can choose the <\/span><b>Add-ons<\/b><span style=\"font-weight: 400;\"> Essential for your business needs from more than 250 available features. For easier search, you can also <\/span><\/p>\n<ul style=\"text-align: justify;\">\n<li><span style=\"font-weight: 400;\">Sort by available items: Click on the down arrow on the left \u2013 You will now see items like <em>All \u2013 Business Tools \u2013 Education \u2013 Productivity<\/em>\u2026 and apps that Google recommends specifically for your business (<em>For tencongty.com<\/em>)<\/span><\/li>\n<li><span style=\"font-weight: 400;\">Search by keyword: Type the keyword you want to find in the search box on the right. For example: analytics, marketing, etc.<\/span><\/li>\n<\/ul>\n<p style=\"text-align: justify;\">Each add-on will have an accompanying video or image to help you better understand their functionality. To install these features, you don&#039;t need to download software or do many operations, all you need to do is click on the blue box &quot;<strong>+ Free<\/strong>&#8220;.<\/p>\n<figure id=\"attachment_7174\" aria-describedby=\"caption-attachment-7174\" style=\"width: 1076px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-7174 size-full\" src=\"https:\/\/gcloudvn.com\/wp-content\/uploads\/2018\/06\/Capture.png\" alt=\"Example: When you install add-ons Analytics\u00a0\" width=\"1076\" height=\"619\" \/><figcaption id=\"caption-attachment-7174\" class=\"wp-caption-text\"><em>Example: When you install add-ons Analytics\u00a0<\/em><\/figcaption><\/figure>\n<p style=\"text-align: justify;\"><em><strong>You can refer to add-ons that effectively support your work (Marketing, Analytics, Business, ...).<\/strong><\/em><\/p>\n<p>&nbsp;<\/p>\n<p style=\"text-align: right;\"><strong>Update: <a href=\"https:\/\/gcloudvn.com\/en\/\">Gimasys<\/a><\/strong><\/p>","protected":false},"excerpt":{"rendered":"<p>Google Sheet l\u00e0 m\u1ed9t c\u00f4ng c\u1ee5 \u0111\u01b0\u1ee3c Google cung c\u1ea5p \u0111\u1ebfn ng\u01b0\u1eddi d\u00f9ng v\u1edbi kh\u1ea3 n\u0103ng thao t\u00e1c c\u00e1c b\u1ea3ng t\u00ednh (Spreadsheet), \u0111\u01a1n gi\u1ea3n v\u00e0 t\u1ed1i \u01b0u h\u00f3a kh\u1ea3 n\u0103ng l\u00e0m vi\u1ec7c nh\u00f3m, nh\u1eb1m t\u0103ng n\u0103ng su\u1ea5t t\u1ed1i \u0111a c\u00f4ng&hellip;<\/p>","protected":false},"author":1,"featured_media":5281,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"inline_featured_image":false,"footnotes":""},"categories":[1],"tags":[],"class_list":["post-5280","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\/5280","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=5280"}],"version-history":[{"count":0,"href":"https:\/\/gcloudvn.com\/en\/wp-json\/wp\/v2\/posts\/5280\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/gcloudvn.com\/en\/wp-json\/wp\/v2\/media\/5281"}],"wp:attachment":[{"href":"https:\/\/gcloudvn.com\/en\/wp-json\/wp\/v2\/media?parent=5280"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/gcloudvn.com\/en\/wp-json\/wp\/v2\/categories?post=5280"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/gcloudvn.com\/en\/wp-json\/wp\/v2\/tags?post=5280"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}