Google dox login. Google Docs - what is it? Limitless possibilities of Google Docs

Many people think that online text editor Google Docs You can only type simple texts; it’s simply not suitable for anything more. In fact, this is far from the case. In the depths of this web application lies many useful functions that will help you work no worse than in any other Microsoft Office.

1. Enable offline access

Google Docs can work offline. At the same time, you can create new and continue to edit existing documents. The next time you connect to the Internet, all changes will be synced. To activate this function, open the Google Drive website and go to the settings menu, which appears after clicking on the gear button.

2. Collaboration

The Google Docs editor gives us everything we need to collaborate on documents. You can easily share the text, and it is possible to fine-tune file access rights. So, you can allow only viewing, viewing and commenting, or even give full access for editing. In the latter case, all changes made by your employees will be reflected in real time, and you will work on the text together in the literal sense of the word.

3. Publish documents

Finished documents can be demonstrated not only to a limited circle of employees, but also published on the Internet. To do this, click File - Publish online. Get a link to a web page or a code to embed a document on your site.

4. Look for mistakes

Checking errors in the Google Docs editor is not difficult at all. Just search in the menu Tools team Spell check, and a small panel will appear in front of you, sequentially displaying each error found and offering ways to fix it.

5. Insert links

Google's online editor includes a convenient tool for inserting links. As soon as you highlight a word in the text and click on the insert link button, a pop-up window will appear offering the most likely relevant links. Typically this is an article from Wikipedia and the first few links from Google search for this word.

6. Use your styles

If the built-in text formatting styles do not suit you, you can easily set your own. To do this, type the text in the required font, and then select the command from the style selection menu Update style to match selection.

7. Personal dictionary

If the editor constantly underlines a word for you as incorrect, but you know for sure that it is not, then simply add it to the user dictionary. To do this, select it in the text, and then select it in context menu team Add to custom dictionary.

8. Web Clipboard

Google Office Suite has a very interesting feature called “Web Clipboard”. This function allows you to copy several passages of text, pictures, tables at once and then paste them into any Google document. Thus, this is a dimensionless clipboard that is accessible from any computer and operates within office Google programs. It can be accessed from the menu Edit - Web Clipboard.

9. Advanced search

The advanced search tool in Google Docs is a special panel that is used to search for various information while working on a document. To call it, you can use a special item in the menu Tools or hotkey combination Ctrl + Alt + R. You can learn more about this function from.

10. Additions

The functionality of Google Docs can be expanded using special add-ons. They are available both from third-party developers and from the Google. Typically they serve to add support for new formats, file conversion, and more convenient use of the editor for various purposes. You can get acquainted with some of the useful add-ons.

11. Insert images by dragging and dropping from your desktop or other website

Not everyone knows, but you can insert pictures into a Google Docs document by simply dragging them from your desktop or file manager. And if you need to insert a picture from another web page, then simply drag and drop it into Right place in the text, and it will automatically appear in your document.

12. Translate documents

If you work with documents in a foreign language, then Google Docs has a built-in translator. It's located in the menu Tools - Translate Document.

13. Navigating complex documents

If you have opened a complex, large document, then displaying a table of contents will help you easily navigate its structure. You can find this function in the menu Add-ons - Table of contents - Show in sidebar.

14. Enable full screen mode

Many people like special text editors that contain a minimum of distracting elements and occupy the entire monitor screen. This helps you work more productively and focus only on the text. You can activate a similar mode in Google Docs. To do this, open the menu View and uncheck the box Show ruler. Then select the command Compact controls or Full Screen.

15. Use the template gallery

Don't forget that Google's office suite contains a pretty good gallery of templates. It is located at this address, and it contains many useful preparations that can make your work easier.

16. Automatic content insertion

If you want to insert a table of contents into your document, you don't have to do it manually. Just find it in the menu Insert paragraph Table of contents, and the editor will do everything for you.

17. Use bookmarks in your document

Sometimes it happens that you need to provide a link not to the entire document, which can be quite lengthy, but to a separate paragraph. In this case, bookmarks will come to our aid. Place the cursor at the desired location in the text, and then select from the menu Insert paragraph Bookmark.

Google took care of its users by integrating the MS Word text editor into the Google Drive service.

The result is a good free text editor “in the cloud”, with which you can not only type, edit, print reports or other documents, but also instantly send them. These are Google Docs documents.

Why did I write: “Google took care of its users”? Yes, yes, Google provides its services only to those users who have their own Google account, or rather, have their own mailbox on gmail.com something like this Nadezda @ gmail.com.

If you don’t have an email account on Google, then create one. The main thing is to come up with a suitable login and password for your email.

I write everything below for those who have (or will have) their own Google account.

1. What can you do in Google Docs?

Google documents online have almost the same functionality as in the usual local Word from Microsoft (MS Word), namely:

• The mobility of Google Dox is useful for those who move and work with documents where it is convenient and where there is an Internet connection. You can continue working on a document even if you are disconnected from the Internet.
• Want to create documents from scratch? Easily! In addition, it is possible to download regular Word documents from your computer and edit them.
• Documents in html, txt, odt, rtf, doc, docx, pdf formats are uploaded to Google Dox.
• You can work as a whole team on a document: just send your colleagues a link to the document.
• All changes in the document are logged and in an unexpected case, when, for example, “a cat walked across the keyboard,” you can “roll back” to the previous version of the document.
• You can work with Google Docs documents on Android and iOS devices. To do this you will need to install the appropriate free application“Google Docs” to your Android device or iOS.

2. Google Docs tools for working with text

The first thing to note is the ability to write text, perhaps this is the most important thing.

There are also tools that allow you to work with text:

• color,
• size,
• fonts,
• alignment,
• formatting,
• spell checking,
• inserting tables, figures,
• and "children's" opportunities.

3. How to create a google document

Before you start working with the text, you should write it or download it, for example, from your computer. Let's try to create new document, as they say, “with clean slate" So, this can be done as follows.

Enter your username and password.

2) Click on the “Create” button located in the left vertical menu(number 1 in Fig. 1), after which a list will appear in which we select Google documents (Docs).

The same can be done using Shift keys+ t.

Rice. 1. In Google Drive, find a GoogleDocument and create it

After you enter text, you can style it or “comb it.” Let's start with styles. We are invited to format our text as regular text, with headings and even make a table of contents.

If you place the cursor in any place in the text or select any part of the text, then in the window marked with number 1 in Fig. 2, the style that matches the marked text will immediately appear.

Rice. 2. How to change text styles: Plain text, Heading, subtitle, etc.

In Fig. 2 the text “Punish me with contempt” is highlighted and in window 1 in Fig. 2 you can see that this is “Plain text”.

To make a document title, you need to select the corresponding text and click on “Title” (number 3 in Fig. 2), it will have the largest font. This is usually the title of a book or project.

The following chapters can be made in the text:
Heading 1 – number 5 in Fig. 2,
Heading 2 – number 6 in Fig. 2, smaller font than Heading 1,
Heading 3 – number 7 in Fig. 2, smaller font than Heading 2.

In addition to headings, there may be subheadings - number 4 in Fig. 2.

5. Automatic table of contents

1) After the text is marked up using the above styles (Heading 1, Heading 2, etc.), you can create a Table of Contents for the entire document.

2) Place the cursor in the place where the table of contents will be, usually this is the beginning of the text.
3) Go to the “Insert” menu (number 8 in Fig. 2).
4) There we select the last menu item – “Table of Contents”.

This will automatically generate a table of contents for the text.

6. Select the text font

Fonts are created by designers and have a specific license. You cannot add it for the Russian language - this is considered a violation of copyright. Therefore, in the Google Dox service there is a choice of free fonts for which the service has the right to use.

Rice. 3. How to change the font in Google Docs

To select a font, select the text (number 1 in Fig. 3). And then click on the list with fonts (number 2 in Fig. 3), and select the one you need (for example, number 3 in Fig. 3).

What is in Fig. 3, a check mark next to the Arial font means that the selected text (number 1 in Fig. 3) is typed in this particular font.

Just click anywhere in your text and the Google Docs Toolbar (number 2 in Fig. 3) will tell you everything about this text: what font it has, color, font size, style, etc.

7. Text font size

To change the font size of text in a Google Docs document, you need to select the desired piece of text (number 1 in Fig. 4), and then click on the appropriate font size from the drop-down list (number 2 in Fig. 4).

Rice. 4. How to change the font size of text in a Google Docs document

If there is no suitable size for the selected text, for example, 13 or 20, then click in the field marked with number 2 in Fig. 4, and enter the desired font size there.

8. Text formatting

If you want to format the text, first be sure to select the part of the text that you want to “comb” using formatting, and then click on any formatting option (Fig. 5).

Rice. 5 Buttons for formatting text in Google Dox

As can be seen in Fig. 5, available the following options formatting:

• B- Bold

To make an important part of the text bold, you need to select (in other words, paint over) this text, and then click on the “B” icon, or press the hot keys Ctrl+B.

If you need to remove the bold text and make it regular text, select this text and click on the “B” icon, or press Ctrl+B.

• I- Italics

If you select the text and then click the " I", or press the hot keys Ctrl+ I, then the text will also become inclined(highlighted italics).

To remove italics from text, you need to select the italic text and use the “ I", or Ctrl+ keys I.

• U - Stressed

Select part of the text and click on the “ U", or press Ctrl+ U, the text becomes underlined.

Didn't like it underlined text? Select (paint over) it and use the “ U", or Ctrl+ keys U.

• A- Text color

First of all, select the text, and then you can change the font color or background color for the selected text

9. Change text color and background

To change the color or background of text, first select the section you want. Then click the button on the toolbar, select “Text Color” or “Background Color” and specify a color.

Rice. 6. Change the text color, text background color

The Google Dox service offers to stylize text by changing its color and background. To do this, just select the required area of ​​text and click on the button with the image of an underlined capital letter “ A”, after which a list will drop out (Fig. 6), in which you can select the appropriate font color and background.

10. Comments on the text for editing

If any text causes you doubts, then you can mark it: select it, click “Insert comment” (Ctrl + Alt + M) and indicate the reason, so that later it will be clear what needs to be corrected.

Rice. 7 Insert comments on selected text to explain corrections that need to be made

This can also be useful when several people are working on the same document.

11. Other formatting tools

You are writing an article in which you want to cite a source that confirms your words, then click on the “Insert link” button, then enter the text of the link, and add it in the field below.

Rice. 8 Formatting tools in Google Doc

There is also a situation where it is necessary to align the text. Most often this is a heading that needs to be placed in the center. To perform this procedure, select the desired area and from the top menu choose how you want to align: left, center or right.

From left to right there are buttons:

• Align text left (Ctrl+Shift+L)
• Center (Ctrl+Shift+E)
• Right Align (Ctrl+Shift+R)
• Align Left (Ctrl+Shift+L)

To perform Alignment, select the desired area and in the top menu choose how you want to align: left, center or right.

4 in Fig. 8 - Line spacing (or Line spacing)

There is no need to select anything here, just click on the “Line spacing” button and select the required indentation; by default it is 1. You can also set the spacing yourself: click on the “Adjust spacing” button and adapt it to suit you.

5 in Fig. 8 - Numbered list (Ctrl+Shift+7)

Are you creating a menu for a restaurant that includes different types of salads? Of course, this is where a list tool comes in handy. You can choose a bulleted or numbered list. You can also change its design: click on the dropbox (arrow) next to the one you want to select.

6 in Fig. 8 - Bulleted list(Ctrl+Shift+8)
7 in Fig. 8 -Decrease indentation (Ctrl+[)
Increase indent (Ctrl+])
8 in Fig. 8 -Clear formatting (Ctrl+Space)

12. Google document viewing modes

Despite their uselessness when creating files, it’s still worth familiarizing yourself with them, in case they come in handy.

In the “View” menu (Fig. 9) you can select different document viewing modes.

Rice. 9 Google Doc Viewing Modes

This tool will be needed in any case, since you can go into viewing mode and see what the final document will be like, and then return to editing and correct any errors found.

13. Insert

Rice. 10 You can insert a table of maximum 20x20

Using the “Insert” tool (number 1 in Fig. 10) you can insert

• image,
• table or
• formula
• and also make a footnote, used in books to explain something.

You can also work with pages: add a table of contents, numbering, bookmarks. As you can see, there are enough tools to write your book.

14. Useless buns

Of course, it’s hard to believe that such a serious service will include children’s buns. Yes, they are quite unchildish. But they can be called that because they harm the document.

This is a translation of a document through Google Translator, as well as a spell check. You shouldn't use them. It's better to pay a little and get quality results.

15. Allow your colleagues to help you with your work

To do this, you need to give them access to the Google document.

Rice. 11 We give access to Google documents to our colleagues

You can put in open access my job. To do this, in the right top corner Click on the “Access Settings” button (number 1 in Fig. 11), go to “Advanced” settings (number 4 in Fig. 11) and configure the file access level (number 3 in Fig. 11).

Setting up access is also useful if several people are working on a Google document, when there is team work. You can add people who will subsequently have the right to edit, read and comment on the document. A very useful tool if used correctly.

16. Saving and other features

The main feature of Google Docs is that the file is saved automatically in Google Drive and you don’t have to press the “Save” or Shift + f12 button every time, as in MS Word.

For each Google document, a history of changes is saved (number 5 in Fig. 11) and there is a chance to find a normal copy, where everything was not as bad as it became.

You can also rename the Google document, and also download it to your computer in various formats.

In addition to these functions, the service allows you to print a document to a printer directly from the cloud: in the top menu there is a button with an image of a printer (number 1 in Fig. 9), after clicking on it, a page with file settings for printing will open.

In Fig. 9 you can see that in the top menu there is not only “File”, but also “Help”. By clicking on this option, you can get even more information than what is stated above.

Computer Literacy Exercise

Dear Colleagues! Checking the operation of Google Docs. To do this, follow the link:

We print a couple of lines of text. Is Google Doc working?

Check out other computer literacy articles:

Receive the latest computer literacy articles directly to your inbox.
Already more 3,000 subscribers

.

Online editors, although not a complete replacement for desktop ones office packages, however, they have their undoubted advantages, including the ability to collaborate with documents. No less important are the “cloud” properties of online offices and related services; this allows them to be used for file storage and document flow.

This review will examine in detail 5 online office packages based on the following criteria:

• Interface: convenience, design, response speed, observed failures during operation.
• Word Processor Toolkit: availability of all the necessary tools for working with text, inserting tables, images and other elements; Toolbar functionality, menu composition.
• Office Applications: since it is impossible to consider all the components of office suites within the framework of one article, key attention will be paid to the word processor as part of the office, other applications will be discussed briefly. Table editors will probably be covered in a separate review, since this is also a fairly broad topic for research and comparisons.
• Supported Formats: Import/export capabilities.
• Collaboration: tools for setting access rights, categorization.
• File storage: provided disk space (primarily in free version, if available), synchronization with PC; limits on the size of documents for storage/downloading, file sharing functions.
• mobile version: availability of a mobile web version, as well as applications for various devices.
• Rates: tariff plans, availability of a free version.

Review participants:

1. Google Docs
2. Zoho Docs (Zoho Office Suite)
3. Microsoft Office Web Apps
4. Teamlab Office
5. Thinkfree Online

Google Docs

The Google Docs service, or Google Docs, appeared as a result of the merger of two components - Writely ( word processor) and Google Spreadsheets (working with spreadsheets), created by Upstartle and 2Web Technologies, respectively. Both products were taken over by Google and integrated with Google Accounts in 2006. In 2012, the online office was assigned to Google Drive, supplemented by other applications at this time.

Interface

The design of Google Docs office applications is made in a style typical of other Google services - Gmail, Calendar, etc. Therefore, when a global design update is carried out by Google, it is not so rare that changes affect all Docs applications.

Most functional elements have gray, white and blue tones. No colored icons, strict style. In principle, a similar move towards minimalism is also characteristic of Microsoft, as will be seen in the case of the set Office applications Web Apps.

The toolbar is located in one row, above is a menu, buttons for commenting and sharing. You can hide unnecessary panels at any time, leaving only the toolbar visible. It is also easy to remove the ruler and/or formula bar through the “View” menu section. This makes editing in the browser more comfortable by expanding your workspace and focusing on the tools you need most.

In general, document editing occurs without any lag. Unstable operation can occur when opening several dozen documents - but in this case it all comes down to browser resources. Among the shortcomings, it is necessary to note failures, which, albeit rarely, still occur on Google servers - at such moments it is impossible to edit the document.

Writely Toolkit

The main operations are placed on the toolbar, auxiliary commands are placed in the menu bar. For some reason, the developers decided that inserting objects (tables, pictures, special characters, etc.) is not needed in the panel for quick access, so this group also moved to the menu. Generally speaking, many menu and panel commands are duplicated.

Basic options are available for fonts: selection of paragraph style (with preview), typeface (limited to a set of 8 fonts), and outline style (among which there is no strikethrough, although it is found in the Sheets component). Alignment, indentation, and spacing settings are also available.

Interestingly, you can embed additional fonts into your document. and in addition, an extended list of default fonts is provided. So, if you change the document language to English, the result will be surprising. Why the developers hid the option to add a custom font to Russian-language documents is unclear.

You can add bookmarks to a document internal links(anchors), table of contents. Almost everything that is needed to create structure and markup is implemented in a word processor. It has been noted that it is not possible to add a digital signature or watermark to the document for security purposes. In the latter case there is alternative way using a custom CSS style, but this, of course, is not very convenient and obvious.

Spell check available: you can add new terms to the dictionary, and correction options are offered in the context menu. However, you cannot manually specify the text checking language; the only workaround is to change it in the document settings (“File → Language…”).

Hotkeys can be found in the memo (Ctrl + /), by hovering over the command icon or through the menu.

Office Applications

Google Drive includes apps for working with text documents(Writely component, or Docs), tables (Sheets), presentations (Slides), forms (Forms), drawings (Drawings). According to , there are only three main components - Documents, Tables and Slides. Any of them can be accessed from the start page. Google page Disk.

Sheets

The Sheets (or Spreadsheets) processor allows you to work with spreadsheets, functions, and perform calculations. In this online version, several remarkable features can be noted in comparison with any offline spreadsheet processor - say, MS Excel. Firstly, script connection is available Google Apps Script (a kind of alternative to VBA scripts), which opens up enormous opportunities for creating applications, automation, etc.

Secondly, integration with forms for collecting data into tables. Forms is not mentioned in Google Help as a document component, but it is an important part of office applications. Forms interact closely with Sheets tables. Using the application, you can create questionnaires, polls, and data collection forms, which can later be conveniently viewed in the form of tables. At the same time, text fields, switches and other interactive elements can be used to build voting polls, etc.

The list of functions compared to MS Excel is limited and is available only in the English version. However, it’s not difficult to get used to, especially since you need to understand: this is not a copy of formulas from an offline office package. The list can be found in the section List of Google Sheets Features. You may notice that Sheets has its own functions: for example, for importing data from HTML and XML, Google features and etc.

Working with cells is standard: sorting, filtering, creating ranges, conditional formatting. At the same time, no freezes were noticed, although pauses occurred when capturing large ranges. Some familiar commands are missing. For example, for such a simple task as finding duplicates, you have to use Apps Script or other workarounds.

In Sheets you can build simple pivot tables. There are tools for constructing diagrams: linear, combined, columnar, pie, histograms, etc. There are also less common types of them - organizational, geographical. Perhaps the only thing missing is (available as a gadget, and not in the best implementation).

Slides (Presentations)

The slide application is designed for creating presentations and then exporting them to PDF, PPTX, or directly viewing them in a browser. Transition effects, animation, and templates are supported. You can add videos, diagrams from related Docs applications, WordArt, etc. to your presentation.

There are some features of Slides that should be listed for later comparison with other services. Firstly, multi-selection of slides, and in addition to standard operations with the clipboard, you can make changes en masse - change transitions, change the structure of layouts. Secondly, inserting notes. As a comparison of cloud offices shows, this opportunity is not obvious and conveniently implemented everywhere. Thirdly, a fairly simple, not overloaded interface.

Drawings

The Drawings application (in Russian it sounds more vague - “Google Drawings”) allows you to create drawings using lines, shapes, and text. Guides, grid snapping, and automatic distribution make your work easier.

The service can be used to create sketches, simple design, and to create graphs and diagrams. Strength Drawings - the ability to collaborate on a document. Without this, perhaps, the value of the program would decrease, because graphic editors there is plenty of this kind.

Collaboration

One of the main cloud benefits Google Docs - ease of collaboration with documents and distribution of roles. A few important functions can be briefly listed.

All changes in the process of working with a document are displayed in real time in the form of cursors of different colors in those positions where editing occurs (in the case of the Writely component). In Sheets and Slides, the corresponding cell/slide is highlighted.

A chat is available in the sidebar, so you can have a discussion in the document; this option is not found in the Drive interface. You can also comment on text, cells, and slides.

Access rights are quite easy to manage. You can share a document, as well as add a user and specify their access level (editor, owner, commenting, reading).

Contacts can be easily combined into groups, which makes the distribution of rights more efficient, especially when working in a team.

Collections used to be available in Google Docs, but after the “rebranding” to Google Drive, they were replaced by folders. And if before it was possible to add a file to several collections, now this option is missing. It can be assumed that this was done due to the impossibility of synchronizing collections and folders in local storage. In addition, when using folders, there are no difficulties with access rights for user groups. On the other hand, with tags (as, for example, in Zoho Docs) it would be much more convenient to put things in order in Google Docs.

Supported Document Formats

Documentation

Two ISO document standards are supported - OpenDocument (open/export) and Office Open XML (open only), plus proprietary formats. As a result, the import/export list in the Docs word processor looks like this: Word, ODF, RTF, PDF, HTML and ZIP. When uploading documents to the service, the files can be converted from MS Office into a format for further editing using the service tools.

Tables

Import: XLS, CSV, TXT and ODS
Export: XLS, CSV, TXT, ODS, PDF and HTML

Presentations

Import: PPT and PPS
Export: PDF, PPT and TXT

Images

Export: PNG, JPEG, SVG and PDF

In addition to the above list, there is also a separate list of formats supported by the universal Google Drive viewer, which is also available for mobile devices(see below).

File storage

"Save" button on the toolbar in Google apps There are no documents, all changes are saved automatically. Documents keep records of previous versions with the ability to open them in preview mode or download to a computer.

As already mentioned, the file storage is Google Drive. 5 GB of storage is allocated free of charge. Maximum size documents can be 1,024,000 characters or 1 MB for text files uploaded to Google for editing. For tables, the limit is 400,000 cells, for presentations - 50 MB, which is approximately 200 slides.

Rates

Google Drive is free, plans with increased disk space are listed. Discounts apply for educational and non-profit organizations. You can also use Documents as part of a suite of cloud-based Google services Apps.

[+] Free and no significant restrictions
[+] Convenient, non-distracting design
[+] Smart collaboration in the cloud
[+] Integration with Google services
[+] Regular innovations
[+] Template gallery
[−] Occasionally there are malfunctions
[−] There is no possibility of personalizing the workspace (branding)

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

Most people who use the Internet are not aware of such a great application as Google Dox, but in vain. After all, it is no worse than the popular office suites OpenOffice and Microsoft Office.

What is Google Docs and its purpose

The developer company takes care of its users and 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 via e-mail, provide links to them for other users to view, edit and comment.

In cloud storage You can place countless objects. Google Drive provides 1 gigabyte of free storage for any files, which can later be 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:

• automatic saving ensures that your work is never wasted, even despite PC crashes and shutdowns. All changes can be viewed in 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 on Google Drive, and edit or modify it elsewhere from another device;
• you can open access to anyone you want to make changes, view or comment.

Google Dox Sheets online: how to create and edit a document

In order to be able to work with objects offline, you will 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 in the top right. ( All images below are CLICKABLE )

On the screen that appears, check the “Offline access” box and agree to the requirement to install the “Google Documents Offline” extension.

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

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

After this, the next tab will open in Explorer. Let's start creating the 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, and in the menu that opens, select what you need. 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 message 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 drawing up documents in this service. When creating new files, the page Google Docs will become cluttered, so it is better to immediately sort all objects into folders. To do this, click on the “Create” checkbox on Disk and select “New Folder” in the drop-down window. Give it a name and move your object into it with the mouse.

A little about Dox and browser compatibility. This application works perfectly in Chrome, Mozilla, Safari and Internet Explorer above version 8. Dox may not work correctly in other browsers. Presentation can also be made in it, as well as working with drawings PNG formats, JPEG, and also with PDF files.

How to make dropdown lists in a table

In the application, you can add text from a ready-made list. I will show you how to create a Google Sheet with such functions using the following example. In addition 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 the mouse to open the menu, click on “Data check”, in the menu that appears, select the items “Rules”, “Value from range” one by one and click on the barred rectangle icon to select the data range. A 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 surnames 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 last names separated by commas.

How to fix speakers

Freezing columns is a very convenient feature when creating a Google Docs table into which a lot of information is entered. 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 to pin a specific area:

• Select the desired columns with the mouse.

• At the top, select “View”, “Pin” and click on the required indicator. We select "1 line". To do this, by the way, it is not necessary to select a column. The screenshot shows that there are many options here. You can highlight the column you want and select Up to Current Column.

• That's it, the consolidation is done. Now the first columns will always remain in the top position when scrolling down.

To unfreeze, go back to the “View” menu and click on “Do not freeze rows” in the drop-down menu.

Create 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” and “Pivot Table...” tab.

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

What are Google Forms

They are needed 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 a new product;
• create a questionnaire for testing job applicants;
• embed feedback to the website;
• create a test in the text for a creative competition.

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

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

• After filling out the surveys, a message is sent to your email;
• you can insert formulas 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 confirmed.

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 Drive, 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 out the question line.

• In the “Answer option” item, click on “Text (line)”. We will make the question mandatory, which will not allow the respondent to submit data without filling out this field.

• Fill out the field for the second question and set the value to “Date”. Turn off the “Required Answer” button.

• Click on the “+” icon 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 “Drop-down list” and fill in all the options.

• We formulate 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 palette icon and select the theme you like.

• 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 configure access.

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

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

You can see the answers both in the form of a summary and an individual user.

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

How to create a survey in Google Form

First, to create a survey, you will need to sign in to Drive. As usual, click on “Create”, “Google Forms”. The window with the questionnaire will open in a new tab. We enter the name and explanation for the people who will take the survey (this field is not required to be filled in).

Let's take an example of compiling a questionnaire for parents of schoolchildren. Let's fill out the first paragraph. By clicking the mouse, instead of “Question without title” we type the required text. Specify the question type as “One from the list” and add options. Move the slider to the “Required answer” option.

If you need to delete any values, then click on the cross next to unnecessary option. Answers can be swapped by dragging the three-dot icon with the mouse. There is no need to save anything specially, autosave 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. Answers can be shuffled by clicking on the three dots icon and selecting the appropriate item. This is very convenient, since many people 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 shown in the screenshot.

They were discussed in more detail above. They can be copied if they are repeated in one way or another.

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

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

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

You can not only provide links to forms, but also embed them into your own website. You can edit the questionnaire at any time by left-clicking on the value to be corrected. You can find the survey and answers to it in the form of a Google Docs table on your Drive. But before that, you need to go to the “Answers” ​​menu and click on the green icon at the top.

How to set permissions on Google Docs

As 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 take the following steps:

• On Disk, select the desired object, right-click on it and select “Share...”.

• Select the required value or enter the user name and click OK.

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

In the menu that appears, set the required values. Access to the folder is provided in the same way.

You can also open rights to people who have a Google account. To do this, select the desired object on Disk and click on the “Open access” icon. In the menu that opens, enter the email address or Google group.

Having looked at Docs' features, we can say that, despite some limitations, the application copes with its tasks and can be useful as a lightweight cloud editor. And its 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 reposting the article. All the best and see you soon -))).

Sincerely, Galiulin Ruslan.

(or ) is a free online "Office" that supports spreadsheet and word processing. In addition, it is possible to create presentations. Another standard feature of this Internet service is cloud storage of files with the ability to share. The resource was created by merging Google Spreadsheets with Writely.

In other words, we are talking about web-based software development. That is, the development operates within an Internet browser. There is no need to install the service on your computer. The tables and documents that the user creates are located in a specialized storage.

Besides, the ability to export information to a file is available. This feature is a key benefit. The stored data can be accessed from any machine that is connected to the Internet. In this case, access will be denied using a password.

If you don't consider yourself a Microsoft Office 101 level user (don't use macros or similar functionality), you'll most likely be happy working with web office. Additional benefit there will be a fact that this solution is completely free. Google Docs is used to create and view documents, presentations, and various spreadsheets (tools that are built into Google Drive by default). In addition, there are similarities with desktop programs (interfaces).

At the core Google Docs & Spreadsheets two different solutions are used - Writely and Google Spreadsheets. It is known that Writely is a word processor for the cloud. It was created by Upstartle. Among the available functions, we note joint editing, as well as access control.

IN 2006 Google became the owner of Upstartle. At that time, the number of Upstartle employees did not exceed four people. The owners of Writely closed registration on their own resource when they “sent” the project to Google servers. In the summer of 2006, the creators of Writely sent out invitations to people who requested job information before the end of the summer. On August 23, we sent invitations to all users who left a request. Then the resource became open to everyone.

IN 2010 Google showed the public how to save and share files using Google Docs. In addition, there was the opportunity to work with PDF format. In 2011 the service supported 29 languages ​​(Russian was also present).

Writely

Writely (Document) word processor allows you to edit various documents - OpenDocument, Word and various spreadsheets. It is based on AJAX technology. Users have access and the ability to edit documents from a computer connected to .

Also A huge number of formatting tools are available- to change dimensions, font style, edit colors and decorations. You can also create lists, tables, insert images, links and special characters.

Saving documents happens in automatic mode when making any changes. However, each edit is recorded. Cancel mode available. This function can be compared to that used in a standard text editor. If necessary, you can upload files of various formats to the server and from there.

In addition, you can work with in plain text, RTF, HTML, files Microsoft Word, OpenDocument, as well as the format PDF and some graphic templates. The developers have announced their support Word Perfect.

Google Spreadsheets

Google Spreadsheets used to enter various information into rows and columns. In addition, you can work with spreadsheets and do simple calculations. In the utility there is a possibility of import/export information in format Microsoft Excel, CSV, OpenDocument.

It is easy to give other users access to the finished table with or without the ability to edit (no more than 10 people at once).

This software development cannot be compared with fully functional spreadsheets. For example, Microsoft Excel and OpenOffice.org Calc.

Google Presentations

Google Presentations can be used to create electronic presentations. In this case there is a function to import/export PPT format(Microsoft PowerPoint).

The basis of Google Presentations is the development of Tonic Systems, which Google bought in 2007.

If we consider Google Docs business model, we can say that it is identical to the general strategy of the Internet giant’s “cloud” information storage course. For example, you can take the services Gmail and Picasa.

There is no limit to the number of files you can save in Google Docs format. For other formats it provides 5 GB of online disk space absolutely free. Additional memory that is shared between various services(Google Docs, Gmail, Picasa, Blogger, Google drive), can be purchased for $2.49 - 25 GB for one month, and $4.99 - 100 GB for a month.

Watch a short video (1.5 minutes) about the capabilities of Google Docs for