setrcreate.blogg.se - Google docs spreadsheet tutorial

#GOOGLE DOCS SPREADSHEET TUTORIAL INSTALL#
#GOOGLE DOCS SPREADSHEET TUTORIAL FULL#
#GOOGLE DOCS SPREADSHEET TUTORIAL PC#

Open your Drive, click New > Google Sheets > Blank Spreadsheet:Īnd finally, if you open the table you worked with previously, you can create a new table by choosing File > New > Spreadsheet: It is created automatically once you register a Gmail account. Click on it:Īnother way to start working with Google Sheets is via Google Drive. (In the future, you'll have a list of your recently used files here.) At the top of the page, you'll see all the options to start a new spreadsheet, including Blank. Click the Docs option from the Google apps menu in your profile and choose Sheets. Once you register, you'll be able to use the service. If you don't have one - it's never too late to create it.

If you are still not convinced then please tell us: what tasks can be solved within Excel but not with the help of Google Sheets?įor starters, you will need a Gmail account. I believe that the combination of all these features is enough for Google Sheets to meet your basic table needs.

#GOOGLE DOCS SPREADSHEET TUTORIAL FULL#

You can find the full list of these shortcuts for PC, Mac, Chromebook and Android here. Google Sheets has a couple of dozens of keyboard shortcuts for almost every operation. Just open the Store with all the available add-ons from the menu: Add-ons > Get add-ons. If you can't solve your task with the standard features of Google Sheets, you can try looking for the necessary add-on. Google Apps Script allows the following apps to work with the Sheets:

To run the scenario, you need to set a certain condition (time if the table is open if the cell is edited) or just click the button. These scenarios can alter the data, merge various tables, read files and much more. Google Apps Script programming language (an extended JavaScript version for Google services) opens multiple possibilities: you can write a separate scenario (script) for every table. You can create your own function using Script editor: If you didn't manage to find a familiar or necessary Google Sheets function, it doesn't mean you need to give up the service right away. Useful Google Sheets functions for daily use: formula examples.īut you may be surprised at how this apparent shortage in Google turns into an advantage. Google Sheets numbers 371 functions! Here you can find a full list of them with their descriptions. Let's examine Google Sheets functions and features more closely since it is they that interest many of us the most.

The variety of the functions is not so wide as in MS Excel but it's more than enough for the majority of the users.

Lose the account and you may lose the documents as well.

The safety of the documents depends on the safety of your Google account.

It works a little slower, especially if you have a slow Internet connection.

If you know Excel through and through you'll get used to Google Sheets in no time since their functions are very much alike.

If, for some reason, some data vanish, they can be restored in a couple of clicks. You'll see who worked with the table and what changes were made. The history of the changes shows what's been happening with the file from the very moment of its creation.

Version history is very convenient: if a mistake sneaks into the document but you discover it some time later, there's no need to press Ctrl + Z a thousand times.

Thus, you no longer need to email the edited versions of the files to one another. Work with colleagues simultaneously and you'll see the changes in the table immediately. You can adjust the access settings for every user as well as for groups of people. Decide who can edit your tables and who can only view them and comment on the data.

It's perfect for team work one file can be edited by several users at the same time.

The electronic devices, in addition, give an opportunity to manage the tables even without the Internet connection.

#GOOGLE DOCS SPREADSHEET TUTORIAL PC#

Work with the table from the PC or a laptop browser, tablet or a smartphone and it doesn't matter what operating system is installed on the device.

You can access the Google Sheets tables not only at your home or office but at any place with the Internet.

Sharing the documents has never been so easy - just give someone the link to the file.

We can't really say the same about Excel where the information is stored on one computer unless you intentionally copy it somewhere else.

All the information is stored on Google Cloud, meaning that if your machine dies, the information will remain intact.

Charts, filters and pivot tables contribute to effective data analysis.

#GOOGLE DOCS SPREADSHEET TUTORIAL INSTALL#

You don't need to install any additional software since you work with the tables right in your browser. This service can become a true MS Excel replacement for many users if, of course, they are aware of all the advantages and options Google offers.

But to be honest - it is an utter fallacy. Many of us think that Google Sheets is just a convenient tool to view the tables that are sent via email.