home > A computer > Add file to google docs. Google Doc (google docs) - a complete overview of the service

Add file to google docs. Google Doc (google docs) - a complete overview of the service

Do you want to know how to earn from 50 thousand monthly on the Internet?
Watch my video interview with Igor Krestinin
=>> .

GoogleDoc online. How to create Google Docs

Hello blog readers. Andrey Khvostov is in touch. For successful management, it is necessary to use online information transfer services.

And if you are leading or participating in a training, taking a course, then it is convenient to share information, reports on the work done in the Google Docs service or, as the name of the service is shortened - Google Doc. About who invented these services, read the article about the founder of Google.

Cloud storage of information based on Google Docs

The basis of "cloud" technologies is the ability to store and process information using server tools, and calculations can be seen inside the browser window.

One of the most popular such services is Google Docs. It allows you to create and edit documents.

This is a kind of office in the network. At the same time, users can create a Word document online, it is also possible to change documents online, to collaborate with different users online.

This is a program that runs inside a web browser and does not require installation on a personal computer.

Creationdocuments on the Internet

With the help of Google Doc, it is possible to create a document word online, basic office documents in the usual way or using a template, implement all known from Word programs operations.

including use bulleted lists, sort data by columns, create tables, insert images, write comments, use formulas, different fonts and everything related to office documents.

Google Docs online allows users to work with all popular file formats. In addition, this application also supports standard MS Office formats.

Desktop in Google Doc is similar to Word

Similar to Word toolbar icons. File sharing and collaboration with different users on the network is available.

Definitiondocument access rights

A jointchange documents with other people online

You can view and edit documents at the same time as others. At the same time, your work will be safe, and your data will be securely stored.

Online- the office is accessible from any part of the planet

You just need to have access to the Internet. You can access your documents whenever and wherever you want, because Google Docs is available online, that is, anytime and anywhere you have Internet access.

Yourdata is safe and work is saved

You can store your data online and it will be saved automatically so you don't have to worry about your computer crashing. hard drive or power outage.

Preservationand export copies

You can save documents to your PC in different formats.

Organizationtheir documents

You can easily find your documents and organize them into folders. You can create as many folders as you want, as well as your own Google docs, the entrance to which will be available only to you. You can also share documents with others.

Publicationyour work as a web page

Accessfor yourself or everyone

It is possible to publish your document with access to the whole world, only to some users and only to yourself. (Removal from publication is possible at any time).

transferyour blog documents

After creating a document, you can post it on your blog. And that's not all the useful features of Google Doc.

Beginwork withGoogledocs

First, register to use Google services.

GoogleDox registration

To access the service, you must first register. We open Google and select “Login” at the top, another page will open, in it you will need to click on the “Create” link.

You will see a registration form.
Here you need to carefully fill in the proposed fields, save your registration data in a safe place.

Googledox input

So, we already know what Google documents are, you can enter them by entering the address of the Google page in the address bar of your browser and clicking "Login".

In order to log in, you must enter your account information that you provided during registration.

You can log in to Google Doc by clicking the "Services" button. A tab will open where we click "Disk".

Disk opens. There, click the "Create" button. And in the tab that opens, select Google Docs.

Howcreate a document in google docs.Creationnew online text document

To create online Text Document you need to go to the main Google page, which is located on www.google.ru, and in the upper right you need to click the box Services / More / Other Google services.

In the tab that opens, select the "Home and Office" section. Select "Documents" there. You will see your Google Docs page.
Naturally, if you just created your account, there will be no documents on it. Therefore, a new document should be created. Click the plus icon, the button of which is located at the bottom right.

A new text document will open and you can create it. It is created in the same way as in the offline Microsoft office that is familiar to us.

We enter the text, we use all the same methods of copying and pasting, they are available from the "Edit" menu, you can also use familiar key combinations, such as: Ctrl + C, Ctrl + V.

To format the typed text, you can use the google docs online interface.

Besides this service has the ability to check spelling. To start them, you do not need to do anything, this function is immediately active.

All incorrect words are underlined with a red dotted line. In order to see possible words for replacement, you need to open context menu at the word underlined by a dotted line and choose the right one.

Automatic text translation

It is also interesting to have automatic translation of the created document. To run it, you need to select "Tools" in the menu, and "Translate Document".

A dialog box with the name "Document Translation" will open, in it you must enter the name of the document to be translated, and select desired translation. Of course, one should not expect high results from this translation.

So, you can return your document to some of the states during the creation process. You can view the history of your changes in File / View Change History.

One of the important advantages of such services is that you can work together on the same document. You can allow other authors to view and modify your documents.

To share or give access only to certain people to the file that is being edited, you must click on "Grant access", this button is located at the top right.

A dialog box called "Sharing Settings" will open, using its controls you can set the access rights to the document you want to edit.

Can send created document as an attachment to an e-mail. Click "File" from the menu and then "Attach to Email".

You will see a dialog box called "Sending a message", in which you will have to write the recipients' e-mail addresses and text.

In addition, you can upload your document created on your PC to the provider's server. Of course, later it will be possible to change it using this system online.

Downloading a Document to Google Doc

To download a document created on your PC, go to the personal http docs google com page and click "Download", this button is located at the top left of the page.

Another menu will open, in it you need to click "Files". Next, you will see a dialog box, in which you select the file to download.

In the next window, you need to check the box "Convert documents, presentations, and so on to Google Docs format." This is necessary so that you can then make corrections and changes to your file.

You can see all created and uploaded files in your Google Docs. To organize, delete, rename files, you need to use commands from the context menu.

It is also possible to download google docs documents to a computer.
Of course, in addition to the fact that you use the files that were created using the service online, you can download your Google Docs to your local PC in order to subsequently edit them in google mode docs offline.

Why do you need to use the "File" / "Download as" command.

That's all about Google Docs text documents for now. If you need Additional Information, then you can get it from the help section. Help can be accessed using the "Help" command.

TableGoogle Docs

Let's start by learning the basic principles of how Google Sheets works.
To create a new table, you need to Google page Docs, click "Create", then another menu will appear, select "Table" from it.

You will immediately open a tab in the browser, it contains an empty table.

As in MS Excel, to start entering a formula, you must enter the assignment operator (sign "="). To specify links to the contents of other cells, you can use the mouse by clicking on the required cell.

To create the required formula, you need to use the calculation operators: (+), (-) and the like. When you have finished entering the formula, press the "Enter" key.

PDFfileonline via google doc

Also, this "cloud" service provides the ability to create pdf document online. This is probably the most simple and fast way creating such a document.

As usual, select “documents” in the window on the right, click “Create” in the window at the top left and proceed to create the document. Insert pictures, write text.

Select "Print" and print as PDF and click on the small "Print" button located on the right. Choose a location to save the document and give it a name.

All Google Documents to create, as you can see, is very easy, and most importantly convenient.

Analog google docs

Not so long ago this year, Mail.ru launched a beta version of a new online editor text documents, which operates on the basis of the Cloud Mail.ru file storage service. Who knows, perhaps such a solution is a good analogue of google docs.

Google Docs. Video

Watch the video of my infobusiness partner on working with Google Docs.

P.S. I am attaching a screenshot of mine. And I remind you that everyone can earn money in this way, even a beginner! The main thing is to do it correctly, which means to learn from those who are already earning money, that is, from Internet business professionals.

Do you want to know what mistakes beginners make?

99% of beginners make these mistakes and fail in business and making money on the Internet! Take care not to repeat these mistakes - “3 + 1 BEGINNER MISTAKES KILLING THE RESULT”.

Do you urgently need money?

Download for free: TOP - 5 ways to make money on the Internet". 5 better ways earnings on the Internet, which are guaranteed to bring you results from 1,000 rubles per day or more.

Hello, dear readers of the blog site. Many of you in life are faced with the need to create a document, draw a table, and something else of the same kind. What do you use for this?

Oh yes, of course, available on almost every computer popular programs such as, for example, Word, Excel, PowerPoint, Open Office and many others, including online versions (cloud) of some editors.

Yes, they are undeniably good, but not in the case when it is still worth sweating over this project, table, online presentation to bring it to mind, and not only you are working on the project, but also your colleagues, who cannot be all time is at your side. For this, your indispensable assistant can become free and multifunctional program from Google. Let's get acquainted.

What is Google Docs?

Many of you, including me, are used to working with various documents in such office programs, such as Word, Excel, or PowerPoint, which you first need to install on your computer.

All this is just great if the file is intended only for you. And if you are limited, for example, in time? If you need to urgently show this very text file or presentation to someone, and even so that this someone makes the necessary changes without delay? This is exactly what is needed free online service Google Docs, the possibilities of which we will try to consider in this article.

You probably already guessed that the developer of this miracle is none other than Google itself. Google Docs does not require installation on a computer, besides, google documents or spreadsheets are automatically saved to special server and you can view them from any computer (you just need to know the password to enter and have access to the Internet, but more on that below).

What else can the Google Docs online service do? And here's what:

Multiple people can work on Google Docs at once who have access to them. They can make any edits, leave comments, chat using real-time chat.
Supports a large number of popular formats(e.g. docx, pdf, odt, rtf, txt, html).
History is saved all edits ever made in Google Docs (in case you need to go back a few steps to an earlier version that has not yet been edited).
maybe creating and editing google documents on iPhone, iPad and Android
If necessary, it is possible to work offline (without the Internet).
It is possible to select access rights for each user or for individual groups. That is, we can allow someone to edit text or a table, and we can only give someone the opportunity to view and leave some comments on them.

Google Docs - Create and Edit

In order to create a text file, an online spreadsheet or a presentation, you do not need to install any software, everything is created directly in the browser used (learn about, popular, well-known, new), as well as with one file several people can work at once(all changes will be saved automatically).

To get started, go to the page creating a google document and click on the icon with three dashes in the right upper corner:

We open a list with what we want to create: a document, a table, a presentation, a form, and further down the list:

This is what the window looks like Firefox browser. In browser Chrome tabs with the choice of creation are located directly on the main page:

In the window that opens, we can view the documents we already have (if any):

Create a presentation online from Google

Here you can create various presentations, work on them, edit them, and all this at the same time with their colleagues, being at a respectful distance from each other. And most importantly, that all this can be done absolutely free!

Click on the big blue button "Open Google Slides":

Then, as in previous cases, click on the big red button with a plus, located in the lower right corner.

Choosing a topic for an online presentation in Google and the size of the slide (widescreen or standard), click on ok:

We give our online presentation in Google a name and with the help of a plus choose a layout our future slide:

We also select the font we like, its size, color, you can also italicize it, make it bold or underline (see the screen above).

Then enter title and subtitle by placing the mouse cursor in the corresponding fields. If desired, by grabbing the selected squares with the mouse, we can increase / decrease our text, as well as rotate it to the right or left:

Features of the program for online presentations in the Google Docs service

What possibilities does it hide from us? free program about Google? Let's see:

there is a rollback a few steps back (or forward), as well as printing
copy formatting
canvas fit to screen
the magnifying glass is responsible for zooming
enter text or insert an image
insert a shape, wide arrow, callout, formula (there is a good selection of symbols listed)
insert line, arrow, angled and curved connectors, curve, polyline and scribble
insert comment
customize input methods
on the “Advanced” tab, you can change the background of the layout, the entire layout, change the theme of your presentation, add animation transition between slides(insert blackout, add flip, gallery, etc.)

The "File" tab in Google Docs allows you to create something (online document, table, presentation, form, drawing, you can choose something from the existing rich Google Template Galleries). Here you can also rename your creation, create a copy of it, move it to another folder, delete it, import slides. Well, and, of course, view the history of all changes made, select the language, download, publish on the Internet, send to co-authors and attach to the message in e-mail.

The Insert tab includes the following features:

By selecting the appropriate command in the presentation program, you can insert any text on the selected slide, add an image, video, link (), line, shape, table. You can also number the google docs slides and add comments. Well adding a new slide to a Google Docs online presentation and their import is present.

The Slide tab is where you work with slides. This includes adding a new slide, and duplicating, and deleting. Here you can also change the background, layout and theme, insert transitions between slides and change the entire template.

By selecting, for example, text or an image on a slide, it can be move from back to front(and vice versa), rotate, group and ungroup. All this you will find on the "Organize" tab.

Creating a Google Docs Form

We have already discussed in detail how, how to add this very Internet survey to your site and how to view the results of the survey and then make any changes (edit), so I will explain briefly.

To conduct any online surveys, and then get a table with the results of these same surveys, and completely is free, go to the tab creating a google doc form :

Then click on the big blue "Create Form" button:

The following window will open in front of you creating a new google form:

You can add a poll here:

Choose a topic:

Set some settings:

Get and view individual responses:

We enter a question without a title (if you put the mouse cursor in this field, then it is possible to insert an image - take a picture, insert a url, drag it with the mouse from the computer), and the question type (text, list, scale, grid, date, time):

On the right, there are a few more buttons with which you can add a poll, title, description, image, video, and section:

How to Publish Google Docs, Spreadsheets, Presentations, and Drawings

If you look in the settings, you will notice a very important detail: publication is possible not only of the entire document, but also of a single part of it. For example, you can publish only individual sheets. As for the online presentation, here you can choose the speed of the slides. As for the picture, you can choose the size of the image published on the Internet.

After you click on "Publish", you will see a link in front of your eyes, which you will need to insert into the code of your website, blog, online store.

There is another very interesting thing which is about publishing google spreadsheet − changing the visibility of some of its elements:

Making changes to an already published document

When making any changes (editing) to the original document or an online table in Google docs, you can be sure that these same changes made will also appear in the published copy. But this can be avoided if you do not need it.

To do this, you select from the menu the items "File" - "Publish on the Internet", then click on "Published materials and settings" and uncheck the box "Automatically publish after changes are made":

Unpublishing Google Docs on the Internet

Open the file you want to unpublish. Then go to the "File" menu and select the "Publish to the Internet" item there. Go again to the "Published materials and settings" and there select the item "Unpublish".

How to set permissions on Google Docs

Without setting permissions, other users will not be able to make any changes to the document you have published. For example, in Google documents they will not be able to access the toolbar, in tables also (they will be able to see all sorts of charts, cell formatting and their values, but they will not be able to make changes). As for the presentation online, users will be able to see either the preview version or view it in full screen mode. So, to avoid all this, we can for some of our project colleagues set file publishing permissions.

We open the document we need and in the upper right corner we find the button "Access settings":

After that, in the window that opens, we find the item "Advanced" and activate the item "Prohibit editors from adding users and changing access settings", click on "Save". Now users will be able to publish the file, as well as edit it.

On this, I think, we can complete our acquaintance with this free and promising program from Google. Good luck learning!

Good luck to you! See you soon on the blog pages site

Google Docs - editing Word from the Google service

Google Docs - in this moment best service for creating and editing Word documents, working with .doc and .doc formats. Google Docs differs from similar online editors, first of all, by the simplicity of the interface, which makes working with the service convenient. At the same time, its functionality is quite wide, the editor contains a set of tools that allow you to format text, correct typos in real mode, insert pictures, and also convert and export a document to other formats.

To get started with the Google service, you need:

Go to the website of the online editor - https://www.google.com/intl/en/docs/about/ ;
From the list of available document formats located in the top panel of the service, select the one you need and by clicking the left mouse button activate the “Open Google Docs/Spreadsheets/Presentation/Forms” tab (depending on your choice);
A window opens with a list of documents available for viewing and (or) editing, we can open any by clicking on it with the left mouse button;
To create a new Word document, you must click on the plus icon located in the lower right corner of the page;
An editing panel opens, similar to the one included in local versions of the Microsoft office suite;
The document is saved automatically, and to download it, you need to click on the "File / Download as" tab and select the format you need to save from the pop-up list.

In addition to the standard features, Google Docs also has its own interesting features, such as “Sharing”, which allows you to edit Word file online, shared with other users, get a link to it or set up access.

“Sharing” is implemented by sequentially opening the “File / Sharing” tabs, then you need to enter the name of your project and in the next window indicate the email addresses of the users with whom you plan to edit the document;
To get a link for publishing a file, you need to step by step activate the “File / Publish” sections and select the “Publish” tab in the window that opens, a link is automatically generated that you can copy and use when publishing a document on third-party resources;
In order to configure access, you need to open the "Access settings" block located in the upper right corner, in the window that appears, click on the "Advanced" tab and in the "Access levels" block, click "Change", and then select the desired degree of protection.

Microsoft Word Online - help you create and edit a Word document

Microsoft Word online – cloud office suite Word applications, which has the same features and functionality as a similar local version. Besides, online service the possibility of joint editing of documents is implemented.

To use the Word editor, you must register an account. Microsoft entry. Registration is available at the following link - https://signup.live.com/signup .

After creating an account, you can start using the service - for this you need:

Go to the Microsoft Word Online site - https://products.office.com/en-us/office-online ;
Select any of the tiles located under the site menu;
If you are interested in other editors, then click on the "Seemore" tab located under the tiles;
After confirming the choice, the corresponding editor opens, which implements all the functionality of the standard Office package;
To save the document, successively click "File / Save As", here the option of uploading the file to the cloud service in OneDrive is available, directly to your PC in doc / PDF / ODT format, confirm saving by clicking on the desired option.

To start a joint online editing, select the "Sharing" tab, located on the right above the Word toolbar and in the form that opens, enter email address The user with whom you are going to share the document.

OpenOffice Writer is a great word processor

rollApp: Open Office Writer- this service closes the top three online Word editors. It differs from analogues in the interface of 2003-2007 that is familiar to many users. To use the service, you must register a rollApp account. For this:

Learn more about choosing the optimal cloud storage and connecting it:

Now you know which online Word editors and how to use them. I hope the article was helpful for you.

Google Docs ("Documents Online") is a free Office Word and Excel software package located on the Internet.
If you have the Internet, then perhaps you can do without an office at all using analogues on the Google Docs website. Of course, some people are intimidated by the abundance of the words "online", " cloud technologies”, “word processor” or “spreadsheet processor”, so it seems to them that it is actually easier to work in the familiar OpenOffice or MS Office packages.
In fact, the Google Docs service is aimed at an ordinary teapot who does not have special skills.
Google Docs programs are simple, free, and even a slow computer will pull all the features.
What can Google Docs really do?

Let's start with the fact that in the online word processor Google Docs (analogous to Microsoft Word), online documents are created and edited, saved on local disk or on a storage backups.

As you can see, a significant advantage of the service is the ability to create a backup copy. After all, life is unpredictable, and every person at least once got into a situation where you urgently need to edit a print file, and the computer does not boot due to some system problems.
Using the Google Docs service will allow you to continue working with the desired document from any computer that has remote access. Another important advantage of the Google Docs word processor is its excellent functionality against the background of the relative simplicity of the interface, however, first things first.

Cloud Opportunities Google service docs
All you need to know about cloud technologies is that web server tools are used to process and store information, and the result of the operations performed is provided to the user using a web browser. The name of such technologies was given by the traditional schematic designation of the Internet and remote services in the form of a cloud.
Online office features:
1. creation and editing of text documents (as in Microsoft Word);
2. creating and editing tables (as in Microsoft Excel);
3. creation and demonstration of presentations (as in Microsoft Power Point);
4. creating simple or "vector" images;
5. editing graphic files(in particular, photographs);
6. storage of backup copies of files on the provider's disk space;
7. sending and receiving e-mail messages.
And all this is free.

How to get started with Google Docs

To gain access to all the features of the online office, you should go through a simple one on www.google.ru - the main web page of the search engine. Google systems. You must enter this address into the address bar of your browser, and then select the "Login" link at the top of the web page.

Fig.1

Rice. 2

As a result, the registration form for the new user opens.

In the fields of the registration form, you must enter personal data, as well as your username and password, which will later be used to enter the system.

How to Create a Google Docs Text Document

Need to go back to start page and select the "More" tab.

Rice. 3

In the drop-down menu, select the "All services" item, and on the page that opens, find the "Documents" service.

Rice. four

Because the Account has just been created, it does not yet contain a single document, and in the future this page will display all the documents that were created and edited in the online office "Google Docs" - the new features of the service provide for such a function.

Google Docs Tools

A closer look at the Google Docs toolbar reveals that the interface (menu) is intuitive, so it doesn't need to be explained in detail. All icons are visually very similar to the familiar MS Office and OpenOffice applications.
In addition, it should be noted that the online office "Google Docs" is equipped with a spell checker, activated by default. In order to improve the ease of use of the application, it was equipped with the function of automatic document translation.

Rice. 5

Collaboration in Google Docs

Of course, the functionality of Google Docs is quite similar to desktop applications like MS Word, but we should not forget that Google Docs is a full-fledged online word processor with a number of advantages. One of these advantages is Ability to collaborate on a document with multiple users, while the file can be accessed from any computer with access to the Internet.
A Google Docs user, depending on their role, can be either the document owner or a collaborator.
The file owner also has the ability to grant individual users the right to view the document (with editing features disabled).
The top row lists users who have personal access to the document, the owner of the document is indicated below.
At the bottom of the window there is a line for adding other users who will be granted the rights to view or collaborate on the document.

Possible difficulties
What to do if the service is not functioning correctly?
- Check your browser name and version. According to the developers, the correct operation of the Google Docs service is supported by the following web browsers: Google Chrome, Mozilla Firefox, Safari (version 4 and up), and internet explorer(version 8 and above).

What if the purpose of the tools is not clear and questions arise in the process of working with the online office?
- You should refer to Google Docs Help by typing http://support.google.com/docs in the address bar of your browser

What if everything is in English?
- Select Russian.

So, at present, the Google Docs online office is a worthy competitor to conventional word processors. It is actively used by bloggers, journalists and representatives of other professions related to the timely placement and editing of information. The first place in popularity among American schoolchildren and students was taken by the Google Docs service - new opportunities provide students with the texts of reports and abstracts at any convenient time and in any convenient place - from public transport on the way to study or in the reading room of the library. Soon, domestic students and schoolchildren will also appreciate all the advantages that the use of an online office has.

Greetings, dear readers and guests of my blog. Today I will continue to talk about services search engines and tell you how to simplify your life and learn how to work with useful tools. Ready for some cool tutorial? Then let's start reading!

Most of the people who use the internet don't know about such a great application as Google Docs, but in vain. After all, it is no worse than popular office suites Open Office and Microsoft Office.

What is Google Docs and its purpose

The developer company cares about its users, constantly releases the latest products. One of them is Google Docs with integrated word processor and programs for creating and editing spreadsheets and online presentations. The application is free and can be used both online and offline. Created documents can be instantly sent by e-mail, give links to them to other users for viewing, editing and commenting.

In cloud storage You can place an infinite number of objects. Free Google Drive provides 1 gigabyte for storing any files, which can be further increased up to 15 gigabytes. You can work with files both online and offline. The latter requires the Chrome browser, in which you need to enable offline mode for working with files. The application has many advantages, here are some of them:

auto-save ensures that work never goes to waste, even with PC crashes and shutdowns. All changes can be viewed in the history, which is very convenient and makes it possible to roll back to earlier versions;
documents can be downloaded in all popular formats. For example, you can create a text file in Word on your own computer, save it to Google Drive, and edit or finalize elsewhere from another device;
you can give access to anyone who needs it to make changes, view or comment.

Google Docs Spreadsheets Online: How to Create and Edit a Document

In order to be able to work with objects offline, you need to enable the function offline mode. This will allow you to correct existing documents and create new ones. The next time you connect to the network, all data is synchronized. To enable the function, you need to open Google Drive and enter the settings by clicking on the gear at the top right. ( All images below are CLICKABLE )

On the screen that appears, check the box for “Offline access”, agree with the requirement to install the extension “Google Docs offline”.

Unfortunately, this feature is not available in all browsers. That's why best solution to work with the application will use the Chrome browser, which allows you to use it fully, with all the available features.

To create and edit Google Spreadsheets online way you need to go to the Disk of the same name. Then you should click on "Create" at the top left. Select "Google Sheets" from the pop-up menu.

This will open the next tab in File Explorer. Let's start creating a document.

First, let's rename it, since by default it is called "New Table". To do this, click on the name and enter your name. Next, click on the "Borders" button, in the menu that opens, select what is required. For example, "All Borders". As a result, we have a completed table.

The screenshot shows that the control panel is quite simple and intuitive. It is possible to change fonts, fill, color, etc. For those who have worked in Excel, everything is elementary. After entering all the data, you need to determine who can access the file. To do this, click on the page of our document "Access Settings" and select the desired item.

After that, when you hover the mouse over this button, a pop-up inscription about the accessibility mode appears. Thus, you can see what value is set in these settings.

Now, in order for other users to view this file, it is enough to send them the appropriate link.

There is nothing complicated in the preparation of documents in this service. When creating new files, the Google Docs page will get cluttered, so it's best to sort all the objects into folders right away. To do this, on the Disk, click on the “Create” plate, in the drop-down window, select “New Folder”. Give it a name and drag your object into it with the mouse.

A little about the compatibility of Dox and browsers. This app works great in Chrome, Mozilla, Safari and Internet Explorer above version 8. Dox may not work correctly in other browsers. The presentation can also be done in it, as well as working with drawings. PNG formats, JPEG, as well as with PDF files.

How to make dropdown lists in a table

In the application, you can add text from a ready-made list. How to create a Google spreadsheet with such functions, I will show in the following example. To the already compiled "Progress" we will make a list of students on the second sheet.

On the first sheet, select a column for selecting surnames from the list. Right-click to open the menu, click on "Data Validation", in the menu that appears, select the items "Rules", "Value from the range" in turn and click on the barred rectangle icon to select the data range. The list of surnames can be made on the first sheet.

Then we go to " Sheet2”, select all the data and click OK.

Now you can easily enter the desired names from the drop-down list by clicking on the arrow at the bottom of the cell.

Similarly, you can create a list in the dialog box itself. To do this, you just need to select "Value from the list" and manually enter the names separated by commas.

How to fix speakers

Freezing columns is a very handy feature when creating a Google Docs spreadsheet that contains a lot of information. To do this, open the file we need.

It can be seen that some of the data will not be visible when scrolling. Here detailed instructions in order to pin a specific area:

Select the required columns with the mouse.

At the top, select the item "View", "Pin" and click on the required indicator. We choose "1 line". For this, by the way, it is not necessary to select a column. The screenshot shows that there are many options. You can highlight the desired column and select "To Current Column".

Everything, fixing is done. Now the first columns will always stay at the top when scrolling down.

To unfreeze, go back to the "View" menu and click on "Unfreeze rows" in the drop-down menu.

Creating additional sheets and fields

It is very easy to add an additional sheet in this application. There are two ways:

You need to click on the “+” icon in the lower left corner and a new sheet will appear.
Click on the "Insert" tab at the top, select "New Sheet".

You can add and remove various fields to analyze data in a PivotTable. To do this, create a document by clicking on the "Data" tab and "Pivot Table ...".

Left, in sheet3, there will be a menu where you can select the parameters of interest, on the basis of which you can make a report on all the information provided.

What is Google Forms

They are required to create online surveys. This is a highly requested feature that the developer has built into this app. They can solve many problems. For example:

collect customer opinions about the new product;
create a questionnaire for testing applicants for a job;
embed feedback to the web page;
create a text test for a creative competition.

This is an indispensable thing for collecting information on the Internet. With this application, you can create a survey that collects data for free, without undue intellectual effort. All you need is an internet connection and a Google account.

The developer took care of the additions that expand the capabilities of this processor; completely free of charge. For example:

after filling out the surveys, a message is sent to the mail;
formulas can be inserted into the questionnaire;
the number of respondents may be limited;
at the end of the survey, a message is sent to Slack;
All email addresses in surveys are verified.

Therefore, there is no need to look for an alternative if you did not find something in the forms - it may be in the add-ons.

How to create a registration form

Let's see how to make an online registration form using the following example:

On the Disk, select the "Create" button and then "Google Forms".

In the window that appears with a new document, we see the editor.

Enter the name and fill in the question line.

In the "Answer option" section, click on "Text (string)". The question will be made mandatory, which will not allow the respondent to submit data without completing this field.

We fill in the field of the second question, set the value "Date". Turn off the "Required answer" button.

Click on the "+" sign to add a new question. Fill in the field that opens. This time we select "One from the list", enter the options - "Male" and "Female". Click on the cross to delete the "Respondent's answer".

In the next question, select "Several from the list" and write down the options.

In the fifth paragraph, add the "Drop-down List" and fill in all the options.

We draw up the next question as in the screenshot, selecting the “Scale” value.

Add a new item "Grid", enter everything that is required as in the screenshot.

To select a design, click on the icon with a palette and select your favorite theme.

To view, click on the image of the eye, and if you like everything, then click on the three dots in the right corner and set up access.

If desired, the file can be published to in social networks– Facebook, Twitter, etc., as well as send by email. You can also get a code to embed in a blog or website.

On the "Responses" tab, you can view them in a table. And on the icon with vertical dots, you can set the mode for receiving them. The screenshot shows several options that you can choose from.

You can see the responses both as a summary and as an individual user.

You can edit the form at any time by clicking on the desired object with the mouse.

How to create a google form survey

You'll need to sign in to Drive first to complete the survey. As usual, click on "Create", "Google Forms". The application window will open in a new tab. Enter the name and explanation for the people who will take the survey (this field is optional).

Consider, for example, compiling a questionnaire for parents of schoolchildren. We fill in the first paragraph. By clicking with the mouse, instead of “Question without a title”, we print the required text. Set the question type to "One from the list" and add options. Move the slider to the "Required answer" option.

If you need to delete any values, then to do this, click on the cross next to unnecessary option. Answers can be swapped by dragging the three dots icon with the mouse. You don't need to save anything, auto-save works.

To enter the next item, click on the “+” icon on the right side of the screen.

To change the text, you just need to click on the desired line with the mouse. Answers can be shuffled by clicking on the icon with three dots and selecting the appropriate item. This is very convenient, as many often choose only the top answers, and shuffling gives a more objective assessment.

There are several types of questions in Google Forms. Here they are in the screenshot.

They were discussed in more detail above. They can be copied if they are repeated in certain variants.

In the settings above the text, you can edit the values. When the "Show the progress of the survey" is enabled, the respondent can see how much of the questionnaire he filled out and how much more he needs to go through. If “Only one answer per person” is set, then only one respondent can be from one account.

In the confirmation text, you can enter the wording that the person will read after filling out the questionnaire.

After finishing work with the form, the questionnaire can be published on the blog and social networks. You just need to click on the "Submit" button in the upper right corner. In the dialog box that opens, fill in the required fields and click OK.

You can not only link to forms, but also embed them in your own website. You can edit the questionnaire at any time by clicking the left mouse button on the corrected value. You can find the survey and its answers in the form of a Google Docs spreadsheet in your Drive. But before that, you need to enter the "Answers" menu and click on the green icon at the top.

How to set permissions on Google Docs

As already mentioned, you can give other people access to Google objects to edit them, view them, and leave comments. To open rights to other people, you need to do the following steps:

On the Disk, select the desired object, right-click on it and select "Sharing ...".

Select the desired value or enter a username, click OK.

To grant rights to other users to several documents at once, select the necessary objects and click "Open access to files".

Set the required values in the menu that appears. Similarly, access to the folder is granted.

You can also open rights to people with a Google account. To do this, on the Disk, select the desired object and click on the "Share" icon. In the menu that opens, enter the address of the email or Google group.

Having considered the functions of Docs, we can say that, despite some limitations, the application copes with its tasks and can be useful as a lightweight cloud editor. And the undoubted advantages are its simplicity and accessibility.

I hope the article was useful, and you will use it as a cheat sheet when working. In order not to forget the article and always return to it, I would advise you to add it to your bookmarks. I will be grateful for the repost of the article. All the best and see you soon -))).

Sincerely, Galiulin Ruslan.

20.08.2020

A computer

The most interesting: