AND 10 MORE SECRETS OF GOOGLE TABLES

Google Tables easily turns any tablet into a workplace of office plankton. All data is stored in the cloud, and thus losing the result of many hours of work is almost impossible. And according to Google’s capabilities, the tables even give odds to MS Excel. We look at the following 10 methods of work.

1. TRANSLATION OF TEXT WITHOUT USING OTHER PROGRAMS.

You can translate the text directly in the cells of the table. For communication with the Google Translate service there is a special function GOOGLETRANSLATE. That tact will look like the translation of the phrase from French into Russian:

=GOOGLETRANSLATE("je ne sais quoi","fr","ru")

2. USE MACROS FOR REPETITIVE TASKS.

Using macros, you can record the execution of operations, and then easily reproduce them.

Have repeated document operations? Go to Tools Macros > Record Macro . Perform all the necessary operations. And then it remains only to select the recorded macro and run it on another data set. And all operations will be performed without your participation.

Saved macros are available in Tools → Macros.

Macros for repetitive tasks in Google Tables

3. ALLOW COLLEAGUES TO COLLABORATE ON DATA

You can easily add anyone to the list of admitted to work with your table. You can choose the full rights to edit or limit only the ability to view data.

Use the ACCESS SETTING button on the top right. And in the window that opens, you can provide access to the link or add a specific Google account to the list of persons allowed to the data.

4. JUST PRINT YOUR SPREADSHEET.

Data from the table is needed not only electronically in a computer. Paper reports may be needed anywhere.

The Google Tables Printing System will help you easily and quickly prepare a document for output to paper. Click the printer button and customize the appearance of the printed information.

5. COPY FORMATTING TO OTHER TABLE CELLS.

The ability to quickly copy the format of a cell or group of cells is one of the great features of Google Tables. Everything you need can be done in two clicks.

Select the cells with the desired format. Then click on the icon in the form of a paint roller. And then select the cells that need to be formatted. Everything is done very quickly and saves time on the necessary operations.

Copy formatting to other cells

6. USE PIVOT TABLES FOR QUICK DATA ANALYSIS.

Experienced MS Excel users will appreciate the PivotTables tool in Google Spreadsheets. In summary, pivot tables can be thought of as a drag-and-drop tool for quickly building reports on large data sets.

But it will take some time to master this powerful tool.

7. FORMATTING – THE PATH TO A CLEAR VIEW OF THE DATA.

Formatting helps bring meaning to the data set. The larger the table, the more important the formatting elements are for easier reading.

Alignment, frames, text and background color, and other formatting elements help your readers quickly look at the table and identify what is important in a set of numbers and symbols.

8. USE GOOGLE FORMS TO INSERT DATA INTO THE TABLE.

Google Spreadsheets are a great tool for collecting and formatting various data. But the process of filling the tables becomes a tedious and lengthy process. For ease, you can use forms in which the input fields are structured.

The service takes user answers and automatically places them in the Google Table.

9 FINANCIAL DATA ONLINE

If you follow stock reports, then the GOOGLEFINANCE function will help you to get the latest information.

An example of using the function:

=GOOGLEFINANCE("AMZN","price",date(2017,2,7))

10. PROTECT THE ENTIRE TABLE FROM EDITING.

Not only individual cells can be protected from editing, but the entire table as well. A very useful feature when data is laid out for public access to the network. Users can only read, and no one accidentally spoil the report.