Make data -based decisions in Google Sheets

If Google Sheets is used as a database, it may be necessary to Download the data .This manipulation is the same as for the Data carrier on Excel .

Google Sheets

Google Sheets is the Google version of a Tool Tool Tool, such as the Excel software from Microsoft, accessible online or on your mobile device, it is connected to your Google Drive account.

From € 69.00 per year

• Android
• iOS iPhone / iPad
• Online service

Why use Google Sheets ?

What are the news of the latest version of Google Sheets ?

With which google sheets bones is compatible ?

What are the best alternatives to Google Sheets ?

Description

Google Sheets is a spreadsheet application, as can be Excel, But in an online and free version as with its Microsoft 365 version. Sheets has been accessible directly since Google Drive From your internet browser or in the form of a separate mobile application (Android and iOS).

Thanks to its cloud storage space, the Mountain View firm thus offers you a free and complete online office suite, accessible from anywhere by connecting to your Google account. The interface is clear and simple to understand. In this calculation sheet tool (as in Docs Or Slid) You have access to all the basic functions via a banner located under the main menu, the latter allows you to access advanced insertion, formatting, data management, etc. tools, etc.

Why use Google Sheets ?

The basic features of Google Sheets are the same as those of all current spreadsheets, you can therefore do in your sheet of calculation of the simple text in table with the possibility of changing the colors of the boxes, the format of the text, the Alignments (vertical and horizontal), you can go to the line in a box, create lines for your tables, sort the data, etc.

When you open a Sheets file, you can add as many tabs as you wish. For the fun and practical side, know that it is possible to color the tabs (to better differentiate them or find them faster), you can also duplicate them, hide them, and protect them.

Sheets also offers the use of functions, the same as under Excel But not translated into French (for example the sum function, is called SUM). A tool for choosing your function is also included, and when you use a function, you are guided in its filling. Note that there are even functions that allow values ​​to be linked between different Google Sheets files.

Google Sheets makes it possible to create conditional shaping (color of the box or text depending on its content), insert graphics or to create dynamic tables. And, icing on the cake, you can even, as in Excel, create macros from a recorder and even modify them with the editor !

Note also that you can connect a Sheets sheet to a form Google Forms. The results of the form response then appear in the form of a table. You can then treat them directly according to your needs (sorting, filter, etc.)).

And if the default features are not enough for you, know that you can install additional modules, to create forms, add Google Analytics data, create connections between your files, etc. Please note, some of these extensions are chargeable (some are included in the subscription Google Workspace)).

Regarding compatibility, know that you can open any file in Office formats (XLS and XLSX) but also those in Open Document ODS format (created with Open Office Or LIBEROFICE)). When you open a file in office format from Google Drive, It opens directly in the suitable application (and more in reading mode alone, or overview, as was the case before).

You can also download the documents created with Sheets to save them on your computer or mobile, the registration format is that of Office and your file will be in XLSX format.

Collaboration in Google Sheets

In Google Sheets, you will be able to create tables (spreadsheets), and share them with other people by giving them specific rights. A right of reading allows you to consult your table without being able to modify it. A right of modification will therefore allow them to modify it to fill it or add information to it. You will still have the possibility of protecting cells, lines or columns so that only you can modify them. This allows you to create a table to be filled without other people being able to delete important data.

Because the key to using the tools of Google Drive (Docs, Sheets, Slid, etc.) It is this possibility of working together at a distance. All changes in the files made are recorded in real time, and it is possible to know who has changed what, when and even go back if necessary. In addition, when you leave comments, you can use the smart writing functionality.

All files are saved on the cloud storage space, which allows you to access it from any place in the world. Ideal when you are on telework, for example. In order to perfect this, Sheets is included in the professional subscription Google Workspace (ex G Suite).

Is Google Sheets free ?

The use and download of Sheets (Android and iOS) applications, as well as the use of the service from your Internet browser are completely free. However, note that using the storage space for Google Drive is only free at 15 GB (space to share with other office applications, Gmail And Google Photos)).

If you need more than 15 GB, no worries, because Google has everything planned. You can thus subscribe to one of the Google One subscriptions: Basic, Standard or Premium. These subscriptions increase the cloud space and even share it with your family (free Google Family account).

Note that if you are a company or a school, you will also be interested in a professional subscription Google Workspace. These subscriptions allow the addition of several users each with a storage quota and also make it possible to use the specific tools of Google Workspace as Google Cat Pro, all in a complete workspace. In addition, it is possible to share files with a special invitation that users can open even if they do not have a Google account. They can, according to your settings: display, comment and modify.

What are the news of the latest version of Google Sheets ?

Google regularly adds new features to improve the user experience in Google Sheets.

For its office automation software, the Mountain View firm has added new features related to AI. Deployed on Google Workspace since March 2023, these new features are aesthetic and functional since a new interface simplifies the user experience by reducing the size of toolbar, and thus improves productivity. For calculation sheets, the filters have been improved allowing you to add or delete them to your guide.

With which google sheets bones is compatible ?

Google Sheets is above all a web service. To access it, you just have to have a Google account and open the service in any web browser, on any operating system (Windows, Mac, Linux and others).

There is also a Sheets mobile application that you can download for your Android or iOS (iPhone, iPad) smartphone or tablet of Apple brand mobile devices from the Play Store and the App Store.

What are the best alternatives to Google Sheets ?

The best alternative to Sheets is, of course,, Excel. Especially since the release of Microsoft 365 which enabled the Office office suite to benefit, like that of Google, from a free online version connected to the cloud space OneDrive (which simplifies work in collaboration thanks to file sharing). You can therefore now connect to your Microsoft account (free) directly via the online service and take advantage of the functions of Online office, Excel, Word, Power point and others at 95% of their capacities and for free (within the limit of the cloud space).

If you are looking for a office suite to download and install on your computer, then you can turn to the free and free office suite LIBEROFICE (derived from the famous Open Office)). In LibreOffice, you have a spreadsheet, word processing and a presentation tool. Everything you need to create professional type documents. Collaboration work is possible via the addition of notes and comments, but Libreoffice does not offer any cloud space, you will therefore have to go back and forth. For Windows, Mac and Linux.

Always in Desktop version, you can also turn to WPS Office. This office suite to the major interest in offering versions for various operating systems. You can download it for Windows, Mac, Linux, Android and iOS (iPhone, iPad). Here on the other hand no online service, but if you create a WPS account, your data will be synchronized on all your devices. WPS also offers the functions necessary for work in collaboration. Of course, WPS offers a spreadsheet, word processor, presentation software, etc. The suite exists in free version (with advertising).

If you landed here, because you think that a spreadsheet is just software that allows you to create lists, then know that there are specialized, lighter and, therefore more suitable applications for that. You can for example use Microsoft To-Do, which allows you to create lists, tasks and reminders, but also Color which allows you to create lists, but also small memos and to classify them easily by changing their color, or Google Tasks which allows you to follow up on all your tasks to be performed and include them directly in Google Agenda, To name a few.

Make data -based decisions in Google Sheets

Create online spreadsheets and collaborate on them in real time from any device.

you do not have an account?

Anna Chang

T h e s e n u m b e r s l o o k v e r y s t r o n g !

Collaborate on data, wherever you are

Establish a field truth from the data from your online spreadsheet, with simplified sharing and real -time modification. Use the comments and assign tasks to ensure the smooth running of the analysis.

Get statistics faster thanks to integrated intelligent features

Assistance features, such as Smartfill and formula suggestions, allow you to analyze data more quickly while reducing the number of errors. Quickly get statistics by asking questions about your data in simple language.

Easily connect to other Google applications

Sheets is ingeniously connected to the other Google applications you enjoy, which saves you time. Easily analyze Google Forms data in Sheets, or integrate Sheets graphics in Google Slides and Docs. You can also respond to comments directly in Gmail and easily present your spreadsheets in Google Meet.

Extend collaborative and intelligent features to Excel files

Easily modify Microsoft Excel online calculation sheets without converting them, and enjoy the improved collaboration and assistance features of sheets, such as comments, tasks and smartfill.

Create personalized solutions

Accelerate workflows by creating applications and self -izations for businesses. Use Appsheet to create personalized applications from spreadsheets, without having to write code. Or add functions, menu options and personalized macros with script apps.

Always work with up -to -date data

With spreadsheets, everyone is still working on the latest version of a spreadsheet. The changes being automatically recorded in the versions history, you can easily cancel the modifications or even consult the history of a cell changes in a spreadsheet.

Connect easily to essential data

Import and analyze data from other tools you use, such as your customer data in Salesforce. Enterprise customers can also use connected sheets to analyze billions of BigQuery data lines in calculation sheets, without having to write code.

Safety, compliance and confidentiality

Default

We apply advanced security measures to protect your data, including advanced protections against malware. Calculation sheets is also native in clouds, which eliminates the use of local files and reduces the risks for your devices.

Transit encryption and rest

All files set over in Google disk or created in calculation sheets are encrypted in transit and at rest.

Compliance to support regulatory requirements

The security, confidentiality and compliance checks of our products, including calculation sheets, are regularly the subject of an independent verification.

Confidentiality integrated into the design

Calculation sheets adheres to the same confidentiality commitments and the same protections of robust data as other services for Google Cloud companies.

How to use Google Sheets in the office ?

Google Sheets is an office tool as popular as Microsoft Excel . The Google tool offers the same features as Excel. Accessible online, it is easier to share. For Use Google Sheets , Here is a little Google Sheets user manual .

• How to open a spreadsheet
• How to make a table on Google Sheets
• Merge cells on Google Sheets
• How to make a graphic on Google Sheets
• Use of Google Sheets
• Select several sheets on Google Sheets
• Apply Google Sheets formulas
• Use the shortcuts
• Protest
• Import data
• Sort data

How to open a spreadsheet

To use Google’s office suite, the creation of a Google account is compulsory. There are two ways to access Google Sheets .

The first by typing it in the Google Chrome search bar. The second by accessing it via Google applications, accessible at the top left of the screen. (where Google Drive is located, Google Photos etc).

To create a spreadsheet Google Sheets, nothing could be simpler. Just click on Create a spreadsheet. First, be sure to name the table to find it faster. This application Google also allows you to open an existing table on your computer.

How to make a table on Google Sheets

For the formatting of a table, Google Sheets is easy to use. Enter the desired data in lines and columns. It is then easy to organize a table as we want. The right click is very useful since it allows, in particular to add or delete a line, a column.

It is also possible to carry out this function by going to the Edition tab. This tab offers other uses to format lines and columns. Like Excel, it is possible to adjust the lines and columns to Google Sheets .

The format tab is just as necessary for the Layout of a table . To format a specific cell, click on it and then select the Format tab. Options are then displayed to apply a specific font or character.

Themes are also offered by Google Sheets to personalize its spreadsheet. To do this, just click on the Formats tab and select theme.

Know that you can access your Sheet Tables in Outside connection mode and work on your file. The changes made are synchronized during an internet connection. The particularity of the Google suite is to be able to manage your Files and folders easily.

Merge cells on Google Sheets

Know perfectly Google Sheets is essential in many trades, including secretariat and human resources. Create a new clear and clear document is all the more. There cell fusion is an essential function.

To do this, just click on the cell to merge, choose the Format tab Merge cells . Several options are possible. If the chosen cells are vertical or horizontal, click merge vertically or horizontally. If it is a cell cell, turn off everything.

You think you are holding the road with the manipulation of the Google suite ? Besides, you know Google Sheets On the fingertips ? Come and show us what you can do. We are waiting for you, to keep the best.

How to make a graphic on Google Sheets

L ’’Insertion of a graphic also allows a better understanding of the data. In the task bar, click on the insertion then graphic tab. Google Sheets also authorizes the insertion of images, links, drawings, forms or diagrams.

A small table is displayed to configure or customize the graphic. It is also possible to change the appearance of a graphic, for this, click on graphic style and make the desired changes.

In order to modify the data range of a graphic, click Configuration then click Configuration. It then takes the data range and click on the grid.

Use of Google Sheets

Formatting of the spreadsheet is finally finished. Now it is to use Google Sheets correctly.

Select several sheets on Google Sheets

Within a company, especially in the administrative service, juggling several spreadsheets within different binders is very useful. For Select several sheets on Google Sheets , Two solutions are possible.

The first using a keyboard shortcut : click on a first spreadsheet, hold CRTL and select the others. The second is to use the right click: click with the right click button on one of the spreadsheets then select Select all sheets.

Apply Google Sheets formulas

Like the Excel spreadsheet, Google Sheets offer the possibility of making formulas. Again, this feature is easy to use. In the task bar, go to the function tab and click on function. All types of useful calculations are encountered.

It is also possible to enter the data into the formula directly.

Use the shortcuts

For to use Google Sheets effectively, some keyboard shortcuts can help us. If you are capital letters that want to be tiny, type = low (.

here are the keyboard shortcuts The most common:

Protest

The advantage of this online spreadsheet is the possibility of sharing. Google Sheet is privileged for collaborative work, in particular thanks to the ease of use as well as automatic synchronization.

To share a table Google Sheets With several users, a Share tab is at the top right of the screen. It is also possible to simply send the sharing link.

Nevertheless, poor manipulation has quickly arrived and some data disappear. In order to avoid this kind of hassle, it is possible to protect the contents of the cell.

To do this, select the cells or the data range, click on the Data tab and then choose Leafs and Protected Beaches.

Import data

Google can be used in different ways. One of the most common uses is the database.

To create a table Google Sheets , It is sometimes necessary to import data from another spreadsheet. It finally corresponds to creating Links between leaves , to refer to data from another document. To do this, click on the cell where you want to import a data and type = import (“’ Url du Document ”;” Name of the sheet!the value range ”) . This gives for example:

= Import (
“Https: // docs.Google.com/spreadsheets/e/15785_jp106w; ”!A3; A15 ”!)).

Since Google has thought of everything, the data from the document is updated in the event of revisions.

You have the possibility ofexport Your Google Sheets table.

Sort data

If Google Sheets is used as a database, it may be necessary to Download the data .This manipulation is the same as for the Data carrier on Excel .

Just name the names of columns that wish to be distinguished and click on the filter function. This is located in the task bar and is represented by a funnel symbol. An icon then appears in the selected cells. From there, Google Sheets offers several sorting possibilities.

Google Sheets now no longer has any secrets! And you, do you know Use Google Sheets professional?

No, and besides, I would like you to take care of processing my Excel documents.

For further :

• Why are Word and Excel privileged in business ?
• How to use an Excel workbook in a company ?
• How to use Google Sheets in the office ?
• The essential features of Google Sheets;
• Create a Google Sheets;
• Freeze a line on Google Sheets;
• Freeze a column on Google Sheet;
• Make a graphic under Google Sheets as a pro;
• Make elementary calculations on Google Sheet;
• Create a drop -down list in Google Sheets;
• Calculate public holidays on Google Spreadsheet.