Imports a range of cells from a specified spreadsheet.

Syntax:

IMPORTRANGE("https://docs.google.com/spreadsheets/d/abcd123abcd123", "sheet1!A1:C10")

Pivot tables help you summarize data, find patterns, and reorganize information. You can add pivot tables based on suggestions in Google Sheets or create them manually. After you create a pivot table, you can add and move data, add a filter, drill down to see details about a calculation, group data, and more.

Slicers are a new way of filtering for reports or dashboards by condition and by values. To learn more about using Slicers click here

Data Validation is a feature that’s most commonly used to add dropdown lists into cells within Sheets.

When working with interrelated data, one of the most common challenges is finding information across multiple sheets. Google Sheets VLOOKUP works in a similar way - looks up and retrieves matching data from another table on the same sheet or from a different sheet.

HLOOKUP function simply being the transposed version of VLOOKUP. It stands for ‘Horizontal Lookup’. The function searches for a key value in the first row of the input range, and returns the value of a specific cell from the column where it finds the key.

If you have sensitive content in a spreadsheet, you can restrict people from updating it. Users can then see which content is protected by clicking View>Protected ranges. A striped background appears over protected cells. Or, instead, you can just show a warning when someone tries to update certain content. If users try to enter content in a protected cell, they get the warning message, and can proceed or not.

Returns a filtered version of the source range, returning only rows or columns that meet the specified conditions.

Filtering huge tables helps focusing your attention on the most needed information

You can ask questions about the data in your spreadsheet. Based on your data, you’ll get suggestions for formatting, charts, and analysis.

Read more

With Connected Sheets, you can access, analyze, visualize, and share billions of rows of BigQuery data from your Sheets spreadsheet.

You can also do the following:

• Collaborate with partners, analysts, or other stakeholders in a familiar spreadsheet interface.

• Ensure a single source of truth for data analysis without additional spreadsheet exports.

• Streamline your reporting and dashboard workflows.

With Connected Sheets, you can access, analyze, visualize, and share billions of rows of BigQuery data from your Sheets spreadsheet.

You can also do the following:

• Collaborate with partners, analysts, or other stakeholders in a familiar spreadsheet interface.

• Ensure a single source of truth for data analysis without additional spreadsheet exports.

• Streamline your reporting and dashboard workflows.

Google Charts provides a perfect way to visualize data on your spreadsheet or website. From simple line charts to complex hierarchical tree maps, the chart gallery provides a large number of ready-to-use chart types. The most common way to use Google Charts is with simple JavaScript that you embed in your web page.

Use a pie chart, also known as a pie graph, to show data as "slices of pie," or proportions of a whole. Learn more about pie charts.

A macro is a series of recorded actions within Google Sheets. Once recorded, you can activate a macro to repeat those actions later with a menu item or shortcut key. You can both create and update your own macros in both Google Sheets and the Apps Script code editor.

The Google Workspace add-on will help convert Visual Basic for Applications (VBA) code used in Microsoft Excel macros to Apps Script code that works in Google Sheets.

This can help teams to recreate Excel macros in Sheets, which can help teams save time through automation while reducing the work needed to convert files.

Simplify the process of producing visually rich mail merges using Gmail and combining it with data from Google Sheets. With this solution you can automatically populate an email template created as a Gmail draft with data from Google Sheets. Merged emails are sent from your Gmail account allowing you to respond to recipient replies.

Cells, rows, or columns can be formatted to change text or background color if they meet certain conditions. For example, if they contain a certain word or a number.

Read more