Features Demo’d

Auto Filter

Collecting data is often much easier than analyzing or understanding it, especially for large data sets. The Filter feature in Google spreadsheets makes it easier to analyze and view your data by hiding the data that you temporarily want to take out of view. When you want all of your data to be visible again, all you have to do is disable the filter.

Transpose

Transposes the rows and columns of an array. Array is the array in the spreadsheet that is to be transposed.

Query

The QUERY function is a built-in function that allows you to perform a query over an array of values using the Google Visualization API Query Language.

Pivot Tables

A pivot table report is a dynamic table that lets you interpret data in different ways without ever having to enter a formula. Pivot table reports are particularly useful when you want to narrow down a large data set or analyze relationships between data points.

Apps Script

Google Apps Script is a JavaScript cloud scripting language that provides easy ways to automate tasks across Google products and third party services. Google Apps Script is available through Google spreadsheets by selecting Tools > Scripts.

Google Lookup

Using the Web, the GoogleLookup function attempts to find the values for straightforward facts about specific things. Keep in mind that while the GoogleLookup function knows quite a bit, it doesn't know everything. Although not all of the formulas you try will work, we encourage you to experiment.

Google Finance

You can get stock market quotes and other data updated to your spreadsheets by using the GoogleFinance function.

Google Translate

You can use these functions in your Google spreadsheet to translate text and detect the language in any of the cells. You'll need to type a valid ISO 639-1 language code with either of these functions.

Gadgets

Google Spreadsheets allows you to insert gadgets to display data in a variety of ways. The following is a list of gadgets created by Google, though you can use a variety of additional third-party gadgets as well.