{"id":265668,"date":"2024-03-13T20:07:40","date_gmt":"2024-03-13T19:07:40","guid":{"rendered":"https:\/\/www.sheetgo.com\/?p=265668"},"modified":"2026-10-29T15:18:15","modified_gmt":"2026-10-29T14:18:15","slug":"como-usar-google-sheets","status":"publish","type":"post","link":"https:\/\/www.sheetgo.com\/pt\/blog\/google-sheets-features\/how-to-use-google-sheets\/","title":{"rendered":"Como usar o Google Sheets (guia completo)"},"content":{"rendered":"<p>[et_pb_section fb_built=&#8221;1&#8243; admin_label=&#8221;section&#8221; _builder_version=&#8221;4.16&#8243; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221; da_is_popup=&#8221;off&#8221; da_exit_intent=&#8221;off&#8221; da_has_close=&#8221;on&#8221; da_alt_close=&#8221;off&#8221; da_dark_close=&#8221;off&#8221; da_not_modal=&#8221;on&#8221; da_is_singular=&#8221;off&#8221; da_with_loader=&#8221;off&#8221; da_has_shadow=&#8221;on&#8221; da_disable_devices=&#8221;off|off|off&#8221;][et_pb_row admin_label=&#8221;row&#8221; _builder_version=&#8221;4.16&#8243; background_size=&#8221;initial&#8221; background_position=&#8221;top_left&#8221; background_repeat=&#8221;repeat&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][et_pb_column type=&#8221;4_4&#8243; _builder_version=&#8221;4.16&#8243; custom_padding=&#8221;|||&#8221; global_colors_info=&#8221;{}&#8221; custom_padding__hover=&#8221;|||&#8221; theme_builder_area=&#8221;post_content&#8221;][et_pb_text _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<p>Google Sheets is not only a powerful spreadsheet tool, but it&#8217;s completely free to use. With an increasingly impressive list of tools, features, and add-ons, you can use Google Sheets to do practically anything: performing basic calculations or lookups, creating complex dashboards, or building custom apps using the API and Google Apps Script.<\/p>\n<p>In this post, you will learn what Google Sheets is and how to use it. You will start with the basics you need to get started, including how to get Google Sheets, how to create your first spreadsheet, how to navigate Google Sheets, how to format cells, and how to switch to and from Microsoft Excel. Finally, you will learn about some of the more advanced features to help you get the most out of your data.<\/p>\n<p>[\/et_pb_text][et_pb_text module_id=&#8221;what-is-google-sheets&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<h2>What is Google Sheets?<\/h2>\n<p>Google Sheets is a spreadsheet program included in the Google Docs Editors Suite, along with other free, web-based software like Google Docs, Google Slides, Google Forms, and Google Sites. While it offers similar functionality to Microsoft Excel, there are differences between the two regarding multiple aspects. To learn more about this topic, check out our post on <a href=\"https:\/\/www.sheetgo.com\/blog\/spreadsheets-tips\/google-sheets-vs-microsoft-excel\/\" rel=\"noreferrer noopener\" target=\"_blank\">the differences between Google Sheets and Excel<\/a>.<\/p>\n<p>[\/et_pb_text][et_pb_text module_id=&#8221;how-to-use-google-sheets-the-basics&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<h2>How to use Google Sheets: The basics<\/h2>\n<p>Whether you\u2019re completely new to spreadsheet software or you\u2019re switching from another program, like Microsoft Excel, there are some things you need to know to get started.<\/p>\n<p>[\/et_pb_text][et_pb_text module_id=&#8221;how-to-get-google-sheets&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<h2>How to get Google Sheets?<\/h2>\n<p>The first thing you need to do is <a href=\"https:\/\/sheets.google.com\/\" rel=\"noreferrer noopener\" target=\"_blank\">access Google Sheets<\/a>. Since the program is web-based, you can access it from practically any device or browser, though Google Chrome allows you to use extra features, like working offline.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/google-sheets-home-start-new-spreadsheet.webp&#8221; alt=&#8221;Google Sheets \u2014 home page with Start a new spreadsheet and the template gallery&#8221; title_text=&#8221;Home page with Start a new spreadsheet and the template gallery&#8221; align=&#8221;center&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text module_id=&#8221;how-to-create-your-first-spreadsheet&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<h2>How to create your first spreadsheet?<\/h2>\n<p>Now that you know how to access Google Sheets, it&#8217;s time to create a spreadsheet. From the main page, you can create a blank spreadsheet, use a <a href=\"https:\/\/www.sheetgo.com\/blog\/spreadsheets-tips\/google-sheets-templates-2\/\" rel=\"noreferrer noopener\" target=\"_blank\">free Google Sheets template<\/a>, or open an existing file.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/google-sheets-create-blank-spreadsheet.webp&#8221; alt=&#8221;Google Sheets \u2014 Blank option highlighted under Start a new spreadsheet&#8221; title_text=&#8221;Blank option highlighted under Start a new spreadsheet&#8221; align=&#8221;center&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text module_id=&#8221;how-to-navigate-google-sheets&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<h2>How to navigate Google Sheets?<\/h2>\n<p>Let&#8217;s take a look at what\u2019s on the spreadsheet editor and how to move around in it.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/google-sheets-change-title-and-location.webp&#8221; alt=&#8221;Google Sheets \u2014 spreadsheet title and My Drive folder icon marked Change Title and Change Location&#8221; title_text=&#8221;Spreadsheet title and My Drive folder icon marked Change Title and Change Location&#8221; align=&#8221;center&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<h3>Toolbar<\/h3>\n<p>The toolbar provides quick access to frequently used features, including formatting.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/google-sheets-toolbar.webp&#8221; alt=&#8221;Google Sheets \u2014 toolbar highlighted below the menu bar&#8221; title_text=&#8221;Toolbar highlighted below the menu bar&#8221; align=&#8221;center&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<h3>Menus<\/h3>\n<p>Using the menus, you can access all of Google Sheets\u2019 features. Below, you can see the \u2018Insert\u2019 menu, where you can add <a href=\"https:\/\/www.sheetgo.com\/blog\/google-sheets-features\/how-to-merge-cells-in-google-sheets\/\" rel=\"noreferrer noopener\" target=\"_blank\">cells<\/a>, <a href=\"https:\/\/www.sheetgo.com\/blog\/google-sheets-features\/how-to-make-a-pie-chart-in-google-sheets\/\" rel=\"noreferrer noopener\" target=\"_blank\">charts<\/a>, <a href=\"https:\/\/www.sheetgo.com\/blog\/excel-features\/100-functions-formulas-for-google-sheets-excel-basics\/\" rel=\"noreferrer noopener\" target=\"_blank\">functions<\/a>, or any of the available objects.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/google-sheets-insert-menu.webp&#8221; alt=&#8221;Google Sheets \u2014 Insert menu with cells, rows, columns, chart, pivot table, function, and checkbox&#8221; title_text=&#8221;Insert menu with cells, rows, columns, chart, pivot table, function, and checkbox&#8221; align=&#8221;center&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text module_id=&#8221;how-to-format-cells&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<h2>How to format cells?<\/h2>\n<p>You can format cells by using the toolbar or by accessing the \u2018Format\u2019 menu. The screenshot below shows the wide range of number formats available.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/google-sheets-format-number-menu.webp&#8221; alt=&#8221;Google Sheets \u2014 Format menu with the Number submenu showing number, currency, date, and time formats&#8221; title_text=&#8221;Format menu with the Number submenu showing number, currency, date, and time formats&#8221; align=&#8221;center&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<p>To learn how to use more advanced formatting tools, check out our guide on <a href=\"https:\/\/www.sheetgo.com\/blog\/google-sheets-features\/conditional-formatting-based-on-another-cell-in-google-sheets\/\" rel=\"noreferrer noopener\" target=\"_blank\">how to use conditional formatting in Google Sheets<\/a>.<\/p>\n<p>[\/et_pb_text][et_pb_text module_id=&#8221;how-to-filter-sort-data-cells&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<h2>How to filter &amp; sort data cells?<\/h2>\n<p>To quickly filter and sort your data, select one of the headers and go to Data &gt; Create a filter.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/google-sheets-data-create-filter.webp&#8221; alt=&#8221;Google Sheets \u2014 Data menu with Create a filter over a sales agent table&#8221; title_text=&#8221;Data menu with Create a filter over a sales agent table&#8221; align=&#8221;center&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<p>Click on any of the filter symbols to quickly sort, filter, or search the column\u2019s data.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/google-sheets-filter-symbol-sort-options.webp&#8221; alt=&#8221;Google Sheets \u2014 filter symbol open on the product column with sort and filter options&#8221; title_text=&#8221;Filter symbol open on the product column with sort and filter options&#8221; align=&#8221;center&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<p>To learn more about filtering data without affecting other users, check out this article on <a href=\"https:\/\/golayer.io\/blog\/google-sheets\/google-sheets-filter-view\/\" rel=\"noreferrer noopener\" target=\"_blank\">how to create and use Google Sheets filter view<\/a>.<\/p>\n<p>[\/et_pb_text][et_pb_text module_id=&#8221;how-to-switch-to-and-from-microsoft-exce&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<h2>How to switch to and from Microsoft Excel?<\/h2>\n<p>Fortunately, it&#8217;s easy to convert Microsoft Excel files to the Google Sheets format and vice versa. For step-by-step instructions on how to do this, see the articles below:<\/p>\n<ul>\n<li><a href=\"https:\/\/www.sheetgo.com\/blog\/how-to-solve-with-sheetgo\/convert-excel-to-google-sheets\/\" rel=\"noreferrer noopener\" target=\"_blank\">How to Convert Excel Files to Google Sheets<\/a><\/li>\n<li><a href=\"https:\/\/www.sheetgo.com\/blog\/how-to-solve-with-sheetgo\/convert-google-sheets-to-excel\/\" rel=\"noreferrer noopener\" target=\"_blank\">How to convert Google Sheets to Excel automatically<\/a><\/li>\n<\/ul>\n<p>[\/et_pb_text][et_pb_text module_id=&#8221;google-sheets-formulas&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<h2>Google Sheets formulas<\/h2>\n<p>Google Sheets offers many built-in functions in a variety of areas: time\/date, engineering, filter, financial, Google functions, information, logical, lookup, math, operator, statistical, text, database, parser, array, and web. However, you can also create your own formulas by typing them in directly or using Google Apps Script to write complex functions in JavaScript.<\/p>\n<p>To learn more about formulas in Google Sheets, check out our guide on <a href=\"https:\/\/www.sheetgo.com\/blog\/excel-features\/100-functions-formulas-for-google-sheets-excel-basics\/\" rel=\"noreferrer noopener\" target=\"_blank\">100+ functions and formulas for Google Sheets and Excel<\/a>.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/google-sheets-insert-function-list.webp&#8221; alt=&#8221;Google Sheets \u2014 Insert, Function, All menu listing functions from ABS to AVERAGE&#8221; title_text=&#8221;Insert, Function, All menu listing functions from ABS to AVERAGE&#8221; align=&#8221;center&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<p><strong>1.<\/strong> Whether you use a built-in function or write your own formula, you always start with the equal sign.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/google-sheets-formula-equal-sign.webp&#8221; alt=&#8221;Google Sheets formula \u2014 equal sign typed in cell F2 next to the sales data&#8221; title_text=&#8221;Equal sign typed in cell F2 next to the sales data&#8221; align=&#8221;center&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<p><strong>2.<\/strong> For example, say you simply want to add one value to another. You can type the values directly into the formula:<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/google-sheets-formula-type-values.webp&#8221; alt=&#8221;Google Sheets formula \u2014 =1343.82+1904.62 typed in cell F2&#8243; title_text=&#8221;=1343.82+1904.62 typed in cell F2&#8243; align=&#8221;center&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<p><strong>3.<\/strong> Press \u2018Enter\u2019 to get the result.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/google-sheets-formula-result.webp&#8221; alt=&#8221;Google Sheets formula \u2014 result 3248.44 in cell F2&#8243; title_text=&#8221;Result 3248.44 in cell F2&#8243; align=&#8221;center&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<p><strong>4.<\/strong> However, you can also select the cells containing the values instead of typing them. This reduces the chances of errors and allows you to select the values quickly and avoid mistakes.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/google-sheets-formula-cell-references.webp&#8221; alt=&#8221;Google Sheets formula \u2014 =D2+D3 in cell F4 with the two sales amounts selected&#8221; title_text=&#8221;=D2+D3 in cell F4 with the two sales amounts selected&#8221; align=&#8221;center&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<p><strong>5.<\/strong> However, by using built-in functions, you can easily perform calculations on multiple values at the same time. For example, you can use SUM to add a whole column of values, as shown below.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/google-sheets-sum-function.webp&#8221; alt=&#8221;Google Sheets SUM function \u2014 =SUM(D2:D14) in cell F7 with the sales amount column selected&#8221; title_text=&#8221;=SUM(D2:D14) in cell F7 with the sales amount column selected&#8221; align=&#8221;center&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<p><strong>6.<\/strong> You can perform other operations just as quickly, like finding the average for the values we previously summed.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/google-sheets-average-function.webp&#8221; alt=&#8221;Google Sheets AVERAGE function \u2014 =AVERAGE(D2:D14) in cell F8 below the $12,838.86 sum&#8221; title_text=&#8221;=AVERAGE(D2:D14) in cell F8 below the $12,838.86 sum&#8221; align=&#8221;center&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<p><strong>7.<\/strong> Finally, let\u2019s get the count of values in our column.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/google-sheets-count-function.webp&#8221; alt=&#8221;Google Sheets COUNT function \u2014 =COUNT(D2:D14) in cell F9 below the sum and average&#8221; title_text=&#8221;=COUNT(D2:D14) in cell F9 below the sum and average&#8221; align=&#8221;center&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<p><strong>8.<\/strong> That\u2019s it. In just a few seconds, you have the sum, average, and count of the values in that column.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/google-sheets-sum-average-count-results.png&#8221; alt=&#8221;Google Sheets functions \u2014 sum $12,838.86, average $987.60, and count 13 in column F&#8221; title_text=&#8221;Sum $12,838.86, average $987.60, and count 13 in column F&#8221; align=&#8221;center&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text module_id=&#8221;google-sheets-for-collaboration&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<h2>Google Sheets for collaboration<\/h2>\n<p>One of the benefits of using a web-based spreadsheet like Google Sheets is improved collaboration and sharing. You can share the spreadsheet or parts of it, manage permissions, make and respond to comments, and view all changes and their authors for <a href=\"https:\/\/www.sheetgo.com\/blog\/google-sheets-features\/google-sheets-version-history\/\" rel=\"noreferrer noopener\" target=\"_blank\">all versions of the Google Sheet<\/a>.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/google-sheets-collaboration-quick-access.png&#8221; alt=&#8221;Google Sheets collaboration \u2014 File History, Comments, Meet, and Sharing Options icons marked at the top right&#8221; title_text=&#8221;File History, Comments, Meet, and Sharing Options icons marked at the top right&#8221; align=&#8221;center&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<p>To learn more about collaboration and sharing in Google Sheets and protecting your spreadsheets by setting up the proper security permissions during the process, check out the guides below:<\/p>\n<h3>Google Sheets sharing and collaboration guides<\/h3>\n<ul>\n<li><a href=\"https:\/\/www.sheetgo.com\/blog\/google-sheets-features\/how-to-share-google-sheets\/\" rel=\"noreferrer noopener\" target=\"_blank\">How to Share Google Sheets<\/a><\/li>\n<li><a href=\"https:\/\/www.sheetgo.com\/blog\/google-sheets-features\/google-sheets-share-only-one-tab\/\" rel=\"noreferrer noopener\" target=\"_blank\">How to share only one tab in Google Sheets<\/a><\/li>\n<li><a href=\"https:\/\/www.sheetgo.com\/blog\/google-sheets-features\/collaborate-on-google-sheets\/\" rel=\"noreferrer noopener\" target=\"_blank\">How to collaborate on Google Sheets<\/a><\/li>\n<li><a href=\"https:\/\/www.sheetgo.com\/blog\/google-sheets-features\/how-to-make-google-sheets-editable\/\" rel=\"noreferrer noopener\" target=\"_blank\">How to make Google Sheets editable (by multiple users)<\/a><\/li>\n<li><a href=\"https:\/\/www.sheetgo.com\/blog\/google-sheets-features\/get-notified-if-someone-edits-my-google-sheets\/\" rel=\"noreferrer noopener\" target=\"_blank\">How to get Google Sheets notifications after an edit?<\/a><\/li>\n<\/ul>\n<h3>Google Sheets security and permissions guides<\/h3>\n<ul>\n<li><a href=\"https:\/\/www.sheetgo.com\/blog\/google-sheets-features\/password-protect-google-sheets\/\" rel=\"noreferrer noopener\" target=\"_blank\">How to password-protect a Google Sheet?<\/a><\/li>\n<li><a href=\"https:\/\/www.sheetgo.com\/blog\/how-to-solve-with-sheetgo\/track-changes-in-google-sheets\/\" rel=\"noreferrer noopener\" target=\"_blank\">Track changes in Google Sheets: How to record historic values<\/a><\/li>\n<li><a href=\"https:\/\/www.sheetgo.com\/blog\/google-sheets-features\/google-sheets-permissions\/\" rel=\"noreferrer noopener\" target=\"_blank\">Google Sheets permissions: edit, comment, view<\/a><\/li>\n<li><a href=\"https:\/\/www.sheetgo.com\/blog\/google-sheets-features\/how-to-view-the-history-of-changes-in-google-sheets\/\" rel=\"noreferrer noopener\" target=\"_blank\">How to view the edit history in Google Sheets?<\/a><\/li>\n<li><a href=\"https:\/\/www.sheetgo.com\/blog\/google-sheets-features\/how-to-unhide-sheets-in-google-sheets\/\" rel=\"noreferrer noopener\" target=\"_blank\">How to hide and unhide tabs in Google Sheets<\/a><\/li>\n<\/ul>\n<p>[\/et_pb_text][et_pb_text module_id=&#8221;google-sheets-shortcuts&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<h2>Google Sheets shortcuts<\/h2>\n<p>If you like to use shortcuts, you can access the list of Google Sheets keyboard shortcuts by going to Help &gt; Keyboard shortcuts.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/google-sheets-keyboard-shortcuts.png&#8221; alt=&#8221;Google Sheets \u2014 Keyboard shortcuts window with the Editing shortcuts list&#8221; title_text=&#8221;Keyboard shortcuts window with the Editing shortcuts list&#8221; align=&#8221;center&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text module_id=&#8221;extend-google-sheets-functionality&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<h2>Extend Google Sheets\u2019 functionality<\/h2>\n<p>Once you\u2019ve mastered the basics, you may be interested in extending Google Sheets\u2019 functionality. Fortunately, Google Sheets provides advanced tools that allow you to build on its basic functionality.<\/p>\n<h3>Macros<\/h3>\n<p>You can automate simple, repetitive tasks in Google Sheets by creating Macros. These macros record your actions within Google Sheets and automatically generate the JavaScript code required to repeat those actions. Therefore, you don\u2019t need to know anything about JavaScript to record and run Macros. However, if you are familiar with JavaScript, you may want to consider using Google Apps Script.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/google-sheets-extensions-macros.png&#8221; alt=&#8221;Google Sheets \u2014 Extensions menu with Macros open on Record macro&#8221; title_text=&#8221;Extensions menu with Macros open on Record macro&#8221; align=&#8221;center&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<p>To learn more about using Macros in Google Sheets, check out this post on <a href=\"https:\/\/www.sheetgo.com\/blog\/google-sheets-features\/create-macros-in-google-sheets\/\" rel=\"noreferrer noopener\" target=\"_blank\">Google Sheets macros: enable, create &amp; use them<\/a>.<\/p>\n<h3>Google Apps Script<\/h3>\n<p>If you\u2019re familiar with JavaScript or open to learning it, Google Apps Script opens a whole new world of possibilities. You can easily create functions and apps using the many libraries available. These include all the elements of Google Sheets, as well as other Google apps and services. To learn more about Google Apps Script, check out our guide on <a href=\"https:\/\/www.sheetgo.com\/blog\/google-sheets-features\/use-google-apps-script-in-google-sheets\/\">how to use Google Apps Script in Google Sheets<\/a>.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/google-sheets-extensions-apps-script.png&#8221; alt=&#8221;Google Sheets \u2014 Extensions menu with Apps Script highlighted&#8221; title_text=&#8221;Extensions menu with Apps Script highlighted&#8221; align=&#8221;center&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<h3>Google Sheets API<\/h3>\n<p><a href=\"https:\/\/www.sheetgo.com\/blog\/google-sheets-features\/google-sheets-api\/\" rel=\"noreferrer noopener\" target=\"_blank\">The Google Sheets API<\/a> allows you to manipulate Sheets data from outside Google Sheets. You can manipulate it programmatically using your preferred programming language or through any app or platform that lets you connect to an API. This allows you to use your Google Sheets spreadsheets as databases. To learn more about this topic, read this article on Google Sheets API: What It Is and How to Use It.<\/p>\n<h3>Google Sheets add-ons &amp; integrations<\/h3>\n<p>In addition to all the tools already mentioned, you can always extend functionality further by adding any of the numerous add-ons available for Google Sheets.<\/p>\n<p>For the top add-ons and integrations, check out our list of the <a href=\"https:\/\/www.sheetgo.com\/blog\/marketing-processes\/top-5-google-sheets-add-ons-for-marketing\/\" rel=\"noreferrer noopener\" target=\"_blank\">top 5 Google Sheets add-ons for marketing<\/a>. Also, below, you can find guides on how to use some of the most popular Google Sheets add-ons.<\/p>\n<ul>\n<li><a href=\"https:\/\/www.sheetgo.com\/blog\/marketing-processes\/how-to-use-supermetrics-add-on-for-google-sheets\/\" rel=\"noreferrer noopener\" target=\"_blank\">How to use the Supermetrics add-on for Google Sheets<\/a><\/li>\n<li><a href=\"https:\/\/www.sheetgo.com\/blog\/google-sheets-features\/google-finance-crypto\/\" rel=\"noreferrer noopener\" target=\"_blank\">How to get crypto prices in Google Sheets with Google Finance<\/a><\/li>\n<li><a href=\"https:\/\/www.sheetgo.com\/blog\/how-to-solve-with-sheetgo\/how-to-get-data-from-bigquery-to-google-sheets-automatically\/\" rel=\"noreferrer noopener\" target=\"_blank\">Transfer data from BigQuery to Google Sheets automatically<\/a><\/li>\n<li><a href=\"https:\/\/www.sheetgo.com\/blog\/google-sheets-features\/google-sheets-salesforce-connector\/\" rel=\"noreferrer noopener\" target=\"_blank\">How to use the Google Sheets Salesforce connector<\/a><\/li>\n<li><a href=\"https:\/\/www.sheetgo.com\/blog\/google-sheets-features\/goal-seek-google-sheets\/\" rel=\"noreferrer noopener\" target=\"_blank\">How to use goal seek in Google Sheets<\/a><\/li>\n<\/ul>\n<p>[\/et_pb_text][et_pb_text module_id=&#8221;conclusion&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<h2>Conclusion<\/h2>\n<p>If you&#8217;re looking for a spreadsheet program, Google Sheets is a great choice. It\u2019s free, web-based for easier collaboration, features an increasingly long list of tools, features, functions, and add-ons, and it&#8217;s easy to build on using Google Apps Script or the API. It&#8217;s up to you whether you want to use it to perform simple calculations or build complex apps. When your data sits in several spreadsheets, <a href=\"https:\/\/www.sheetgo.com\/automations\/\">Sheetgo<\/a>, an AI-powered data automation platform, can connect them and keep the numbers up to date.<\/p>\n<p>You now know what Google Sheets is and the basics to get you started: how to get Google Sheets, create a spreadsheet, navigate the interface, switch to and from Excel, format cells, and filter and sort data. You also know about some of its more advanced features like formulas, shortcuts, and collaboration.<\/p>\n<p>You also know about features that can greatly extend the functionality of your spreadsheets, like the Google Sheets API, Google Apps Script, and numerous add-ons. To learn even more about Google Sheets, check out these in-depth guides below.<\/p>\n<h3>Google Sheets data import guides<\/h3>\n<ul>\n<li><a href=\"https:\/\/www.sheetgo.com\/blog\/how-to-solve-with-sheetgo\/import-google-sheets-data-into-another-sheet\/\" rel=\"noreferrer noopener\" target=\"_blank\">Import Google Sheets data into another sheet<\/a><\/li>\n<li><a href=\"https:\/\/www.sheetgo.com\/blog\/google-sheets-features\/google-sheets-reference-another-sheet\/\" rel=\"noreferrer noopener\" target=\"_blank\">Linking Google Sheets: How to reference another sheet?<\/a><\/li>\n<li><a href=\"https:\/\/www.sheetgo.com\/blog\/google-sheets-formulas\/importrange\/\" rel=\"noreferrer noopener\" target=\"_blank\">IMPORTRANGE in Google Sheets: The ultimate guide<\/a><\/li>\n<li><a href=\"https:\/\/www.sheetgo.com\/blog\/google-sheets-formulas\/importxml-formula-google-sheets\/\" rel=\"noreferrer noopener\" target=\"_blank\">How to use the IMPORTXML formula in Google Sheets<\/a><\/li>\n<li><a href=\"https:\/\/www.sheetgo.com\/blog\/google-sheets-formulas\/importhtml-formula-google-sheets\/\" rel=\"noreferrer noopener\" target=\"_blank\">How to use the IMPORTHTML Google Sheets formula<\/a><\/li>\n<li><a href=\"https:\/\/www.sheetgo.com\/blog\/google-sheets-formulas\/importdata-formula-google-sheets\/\" rel=\"noreferrer noopener\" target=\"_blank\">How to use the Google Sheets IMPORTDATA formula<\/a><\/li>\n<li><a href=\"https:\/\/www.sheetgo.com\/blog\/how-to-solve-with-sheetgo\/import-csv-to-google-sheets-automatically\/\" rel=\"noreferrer noopener\" target=\"_blank\">How to import CSV to Google Sheets automatically<\/a><\/li>\n<li><a href=\"https:\/\/www.sheetgo.com\/blog\/google-sheets-features\/how-to-use-google-forms\/\" rel=\"noreferrer noopener\" target=\"_blank\">How to use Google Forms to collect data in a spreadsheet?<\/a><\/li>\n<\/ul>\n<h3>Google Sheets data editing guides<\/h3>\n<ul>\n<li><a href=\"https:\/\/www.sheetgo.com\/blog\/how-to-solve-with-sheetgo\/combine-google-sheets\/\" rel=\"noreferrer noopener\" target=\"_blank\">How to combine Google Sheets by merging multiple sheets<\/a><\/li>\n<li><a href=\"https:\/\/www.sheetgo.com\/blog\/google-sheets-features\/google-sheets-checkbox\/\" rel=\"noreferrer noopener\" target=\"_blank\">How to add a checkbox in Google Sheets<\/a><\/li>\n<li><a href=\"https:\/\/www.sheetgo.com\/blog\/google-sheets-features\/how-to-create-dropdown-lists-in-google-sheets\/\" rel=\"noreferrer noopener\" target=\"_blank\">How to create dropdown lists in Google Sheets<\/a><\/li>\n<li><a href=\"https:\/\/www.sheetgo.com\/blog\/google-sheets-features\/how-to-search-in-google-sheets\/\" rel=\"noreferrer noopener\" target=\"_blank\">How to search in Google Sheets? (multiple methods)<\/a><\/li>\n<li><a href=\"https:\/\/www.sheetgo.com\/blog\/google-sheets-formulas\/sparkline-formula-google-sheets\/\" rel=\"noreferrer noopener\" target=\"_blank\">How to use the Google Sheets SPARKLINE function<\/a><\/li>\n<\/ul>\n<h3>Google Sheets data analysis guides<\/h3>\n<ul>\n<li><a href=\"https:\/\/www.sheetgo.com\/blog\/google-sheets-features\/data-analysis-google-sheets\/\" rel=\"noreferrer noopener\" target=\"_blank\">Data analysis in Google Sheets (+ tips and examples)<\/a><\/li>\n<li><a href=\"https:\/\/golayer.io\/blog\/google-sheets\/how-to-sort-in-google-sheets\/\" rel=\"noreferrer noopener\" target=\"_blank\">How to sort in Google Sheets (+ examples)<\/a><\/li>\n<li><a href=\"https:\/\/www.sheetgo.com\/blog\/google-sheets-features\/how-to-create-a-pivot-table-in-google-sheets\/\" rel=\"noreferrer noopener\" target=\"_blank\">How to create a pivot table in Google Sheets<\/a><\/li>\n<li><a href=\"https:\/\/www.sheetgo.com\/blog\/google-sheets-formulas\/highlight-duplicates-in-google-sheets\/\" rel=\"noreferrer noopener\" target=\"_blank\">How to highlight duplicates in Google Sheets? (2026 tutorial)<\/a><\/li>\n<li><a href=\"https:\/\/www.sheetgo.com\/blog\/google-sheets-features\/google-sheets-as-database\/\" rel=\"noreferrer noopener\" target=\"_blank\">How to use Google Sheets as a database<\/a><\/li>\n<\/ul>\n<p>[\/et_pb_text][\/et_pb_column][\/et_pb_row][\/et_pb_section]<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Aprenda a usar o Google Sheets: crie uma planilha, formate c\u00e9lulas, escreva f\u00f3rmulas, compartilhe seu trabalho e amplie os recursos com complementos.<\/p>","protected":false},"author":2,"featured_media":265690,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_et_pb_use_builder":"on","_et_pb_old_content":"","_et_gb_content_width":"","footnotes":""},"categories":[37],"tags":[],"class_list":["post-265668","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-google-sheets-features"],"acf":[],"permalink_manager":null,"_links":{"self":[{"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/posts\/265668","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/comments?post=265668"}],"version-history":[{"count":0,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/posts\/265668\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/media\/265690"}],"wp:attachment":[{"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/media?parent=265668"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/categories?post=265668"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/tags?post=265668"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}