2.5 Essentials of Google Workspace

Overview of Google Workspace

Google Workspace consists of several applications that are useful in the workplace. You may be most familiar with its communication and scheduling tools (Gmail and Google Calendar, discussed in Communication and Calendar Applications). Google also offers a suite of applications similar to those in Office, including software for word processing (Google Docs), spreadsheets (Google Sheets), and presentations (Google Slides).

One distinctive feature of Google’s Docs, Sheets, and Slides applications is that your work is automatically saved to the cloud. This automatic save function helps prevent accidental file loss. Google also maintains a history of all versions of the file, so if you need to restore to an earlier version or check on the history of an edit formatting change, you can view that information in the Version history, which will be covered later in this section.

Although each application has specific purposes and performs different tasks, some features are shared across the entire Google suite of products. These include essential functions like opening and saving a file, formatting fonts and spacing, inserting objects like a visual image, and accessing help to learn new skills within the software.

Applications

Once you have a Gmail account set up, you can access Google’s applications by opening the Google Chrome browser or any other browser by going to google.com and signing into your account. In the upper-right corner, you will see nine dots arranged in a 3 × 3 array, as shown in Figure 2.39. Clicking on the dots opens a menu of all the Google apps.

Figure 2.39 Click on the dots in the upper-right corner to open the menu of apps. (Gmail is a trademark of Google LLC.)

You will see two sections of offerings. In the first, shown in Figure 2.40a, you can access your Google account settings and can use common tools such as the Google search engine for internet searches, Maps for locating places and navigating trips, Play for accessing apps for your mobile device, Meet for online meetings, Drive for storing your files, Gmail for email, and Calendar for scheduling.

The second section includes the offerings that are the focus of this course. You will see various applications, including Docs and Sheets. If you wanted to work on a presentation, you would select the Google Slides option, as shown in Figure 2.40b.

Figure 2.40 (a) Gmail includes many apps. (b) Slides, which is similar to PowerPoint, is one of them. (Gmail is a trademark of Google LLC.)

Like most application suites, Google continually expands and changes its offerings. Older applications may be phased out over time, while the most popular applications undergo regular updates. Table 2.6 provides a summary of Google offerings. In this course, we will focus mostly on Google Docs, Sheets, and Slides.

Application	Type	Description
Docs	Word processing	Create documents such as reports, memos, and agendas
Sheets	Spreadsheet	Create data-based spreadsheets for storing and analyzing data
Slides	Presentations	Create slide presentations such as for a workplace meeting or client showcase
Gmail	Email	Send and receive emails
Calendar	Calendar	Schedule individual events and collaborative meetings
Search	Internet search	Search the internet based on search terms
Maps	Maps and navigation	Provide navigation directions based on location or address
Play	Application store	List apps on android devices that are available for download
Meet	Online meetings	Video Conference with others
Drive	File storage	Store files; similar to OneDrive; the cloud-based storage for files in Google
Contacts	Contact information	Organize and store contact information such as email addresses and phone numbers for people
Classroom	Educational interface	Create a classroom interface to share files, turn in assignments, and have class discussions virtually

Table 2.6 Common Google Applications The Google Workspace includes applications for all the tools you need in the workplace from communicating with colleagues to creating documents and presentations.

Menu Overview

As you’ve learned, all the applications in the Google Workspace share some general features and functions, which are found in the menus. Although there are slight differences between the apps, they all contain these essential menus: File, Edit, View, Insert, Format, Tools, Add-ons or Extensions, and Help, as Figure 2.41 shows. These menus are similar to the tabs in Office, but in Google they are called menus.

Figure 2.41 The main menu bars for (a) Docs, (b) Sheets, and (c) Slides are similar—from File to Help. (Google Workspace is a trademark of Google LLC.)

Not only are there similarities between the various Google applications, but many of the menu options are also similar to those you learned about in Essentials of Microsoft Office). As you progress through the course, you will learn and practice most of the specific features within each menu. Here, our focus is on the essential shared functions.

File Menu

The File menu is used to open files in Drive, to create new files, and to print materials. In addition, the Make Available Offline option lets you work on files when you do not have internet access. (See Figure 2.42.)

Figure 2.42 The File menu is mainly used for opening and saving documents. (Google Docs is a trademark of Google LLC.)

The File menu also has tools for saving and exporting files in different formats. Docs and Sheets are compatible with their Microsoft counterparts, so users have the option of either working on a Word or Excel file in Docs or converting the file into a Google file. This appears in the menu as the Save as Google Docs command. Google files can be opened and edited in only a browser window, from your Drive.

Recall that Google automatically saves your work for you in the cloud. If you want to save files locally or to other locations, you will need to use the Download command, which enables you to export the current version of the document onto your own computer as a Word document, Excel spreadsheet, PDF, or some other file format.

The Download command brings up the menu shown in Figure 2.43. Using Slides as an example, one of the download options enables you to download your presentation as a PowerPoint file.

Figure 2.43 Download your presentation to one of seven other formats, including a PowerPoint file. (Google Slides is a trademark of Google LLC.)

The File menu also allows you to explore your document settings. You can use the Email command to send the file to one or more collaborators. The Document Details option contains the file’s statistics and technical data. The Page Setup command can modify paper size or format; as in Word, you can make your document’s orientation either portrait (vertical) or landscape (horizontal).

The two most critical tools in the File menu are Version history and Share. Version history is a feature unique to Docs. Every time you make a change in a file, Google autosaves your document, keeping many versions of the file. Version history allows you to revert to a previous version of a file or simply to look back at previous versions for reference.

The Share command enables a document’s owner to invite others to work on it. It is used to tag or add collaborators who can read, comment, develop, or edit the file.

If you want to create a copy of an existing file, you can use the Save a Copy command. As Figure 2.44 shows, this command allows you to make a copy of your Doc and save the document under another name. You can save it to the Drive, which uses the cloud, as discussed. Or you can save the file to your hard drive, but your files are safer in the cloud, and using cloud storage allows you to free up storage on your local device.

Figure 2.44 Creating a copy of an existing file by using the Save a Copy command. (Google Docs is a trademark of Google LLC.)

Opening an Existing File

To open an existing presentation in Slides, first, go to Drive (called My Drive on your computer). You will see your recently saved presentations listed across the top. Even if you are working offline, you will still have access to your files. If you do not see your presentation file, click on Recent under My Drive in the left pane, or scroll down.

Figure 2.45 shows a typical Drive page. Your most recent presentations will be shown across the top, and below you will find all the files you created using one of the Google apps. Click on your presentation to open it.

Figure 2.45 This is a typical Drive page showing recent presentations and other recent work. (Google Drive is a trademark of Google LLC.)

Creating a New File

In the File menu, selecting New opens a menu, as shown in Figure 2.46. You can select a new Presentation From template, new Document, new Spreadsheet, new Form, or new Drawing.

Figure 2.46 Select New Presentation, New Document, New Spreadsheet, New Form, or New Drawing. (Google Drive is a trademark of Google LLC.)

After you have chosen the file type you want to create, a blank file of that type will appear on the screen. The document will open with a default name based on the program. For example, a new Doc will have the default name of “Untitled Document” and this will be listed at the top of the screen (see Figure 2.47). To change this name to something more meaningful, double-click on the current title at the top of the screen. This will highlight the words “Untitled Document” so that you can delete that and rename the file. You can also access the Rename command in the File menu. The process is the same for Sheets and Slides.

Figure 2.47 You can also rename the file you just created by using the Rename command in the File menu. (Google Docs is a trademark of Google LLC.)

Google also has a wide variety of templates to choose from. You can create a new file using a template in a similar manner to how you use templates in Office. Templates can be a great place to start if you are designing a specialized document or file such as an invoice or a budget worksheet. They can also be useful when doing more creative work such as designing flyers. The templates can provide a starting point for you and you can customize to meet your needs. To access the templates in Google for each of the programs, use the expanded menu to the side of the program name when you choose New (see Figure 2.48).

Figure 2.48 When creating a new file in Google, you can either create a file from scratch or start with a template. (Google Drive is a trademark of Google LLC.)

Printing a File

The Print command in Google is found in the File menu. There are also two shortcuts to printing a file: Ctrl+P or the printer icon on the toolbar. When you select print, a window will open with similar settings that you might see in Office (Figure 2.49). You can manage the various settings related to printing such as the number of copies, orientation, and paper size. Like with Office, you will also be able to see a preview of the file you are printing.

Figure 2.49 When you have changed the appropriate settings, click Next to print the file. (Google Docs is a trademark of Google LLC.)

Edit Menu

The Edit menu contains the expected choices: Undo, Redo, Cut, Copy, Paste, Delete, Duplicate, Select All, and Find and Replace. Clicking on Find and Replace brings up the window shown in Figure 2.50. You type in a word from your file. For each occurrence, you confirm whether you want to replace it with another word. Although most misspelled words will be caught by the spell-check function, if, for example, you have misspelled a title or name throughout the file, using Find and Replace is an efficient way to make sure you catch all the errors.

Figure 2.50 You can use Find and Replace to find specific text in a file and replace it with other text. (Google Sheets is a trademark of Google LLC.)

The Edit menu for each of the apps looks similar. Figure 2.51 shows the Edit menu.

Figure 2.51 The Edit menu will look the same in Docs, Sheets, and Slides. (Google Docs is a trademark of Google LLC.)

View Menu

The View menu controls the way your document or file appears on your screen, allows you to show certain components to others, and lets you set three different modes in Docs: Editing, Suggesting, and Viewing. The default mode is Editing, which allows the user to edit the document directly. The Suggesting mode is similar to Track Changes in Word, as shown in Figure 2.52. In this mode, the changes you type into the document become suggestions rather than actual edits. You can then either accept each change by clicking on the check mark or reject it by choosing the X. You can also add comments to the edits, which is especially useful when you are collaborating with others on a document.

Figure 2.52 Notice that when you are in Suggesting mode, changes are not saved until you first either accept or reject the edits, as represented by the check mark or X in the comment box. (Google Docs is a trademark of Google LLC.)

In Sheets, you can use the View menu to display the gridlines or not, or to display a ruler at the top. In Slides, you use the View menu to view the slideshow, zoom in if needed, or show the speaker notes for the presentation. Figure 2.53 shows the different View menus for each application.

Figure 2.53 The View menus for (a) Docs, (b) Sheets, and (c) Slides will become more familiar to you as you navigate the programs. (Google Docs, Google Sheets, and Google Slides are trademarks of Google LLC.)

Insert Menu

The Insert menu is used to insert a variety of items into a file. The different apps may offer different items that are best suited to the purposes and uses of that app (see Figure 2.54). In Docs, the Insert menu includes items such as inserting images, footnotes, headers, and page numbers. Sheets insert options include inserting columns/rows, charts, and formulas. Finally, Slides includes options for inserting tables, drawings, text boxes, and WordArt. Other chapters will cover the Insert menu in more detail.

Figure 2.54 The Insert menu in (a) Docs, (b) Sheets, and (c) Slides differ slightly from one another depending on the function of each program. (Google Docs, Google Sheets, and Google Slides are trademarks of Google LLC.)

Format Menu

The Format menu enables you to alter the visual appearance of most elements within your document, spreadsheet, or slide. Most frequently, you will be formatting text, paragraph setting, spacing, and layout in Docs. In Sheets, you will be formatting the information in the cells and adding conditional formatting based on specific rules. For Slides, the Format menu is much like that of Docs. To see the differences between the Format menus, see Figure 2.55.

Figure 2.55 The Format menu in (a) Docs, (b) Sheets, and (c) Slides. While the options in Docs and Slides focus on formatting text, Sheets’s options allow you to format numerical information in the cells. (Google Docs, Google Sheets, and Google Slides are trademarks of Google LLC.)

Tools Menu

The Tools menu is where you’ll find the tools you need to help ensure the quality of your document, sheet, or slide. Let’s examine some of the Docs offerings, shown in Figure 2.56. “Spelling and grammar” allows you to check for misspelled words, to ensure phrasing and sentences are grammatically correct, and to create a personal dictionary to which you can add frequently used names or words that are not in a standard dictionary. There are also tools for quickly checking editorial matters, such as counting the number of words in your document or seeing a list of linked objects. Notice how the menu also includes keyboard shortcuts. The Tools menu also offers the option of typing by voice recognition, and it includes accessibility settings such as the ability to use a screen reader to read the text on a page aloud and a magnifier to see content at a very large scale. The Tools menu among the three Google apps is very similar.

Figure 2.56 The Tools menu contains some of the most useful features of the Google Workspace. (Google Workspace is a trademark of Google LLC.)

The Tools menu is also where you can set standard preferences for your Google app. The General options allow for automatically capitalizing initial words, automatically applying certain quotation mark styles, and having spell-check running in the background, among other functions. In the Substitutions section, you can set certain manually entered items to be automatically formatted, such as fractions. See Figure 2.57.

Figure 2.57 The list in (a) shows the general preferences; (b) shows the substitutions. (Google Workspace is a trademark of Google LLC.)

Add-ons or Extensions Menu

The Add-ons menu is where you will find accessory programs that can be used for additional features compatible with Google. For example, in Docs, if you need to work on a document with lots of mathematical formulas and equations, you can install an add-on like MathType, which has offerings that go beyond Docs’s equation feature. Or you might install Box, a cloud-based, file sharing, and storage app, to share files with colleagues or clients.

Help Menu

The Help menu is self-explanatory: It contains the body of available knowledge concerning each Google application, as well as all the fine print of the terms of use for the consumer or business. You can search for content related to your question and you can access training materials in the Help menu (see Figure 2.58). Conveniently, Docs also offers the user a dialog box with a list of all the keyboard shortcuts. The Help menu in each of the Google apps is similar to the one shown for Docs.

Figure 2.58 Using keyboard shortcuts can be a time-saver. (Google Docs is a trademark of Google LLC.)

Other Menus

Some Google products have menus specific to the application. For example, Sheets contains a Data menu to help format and organize data. Slides has both a Slides tab, with a variety of options specific to the presentation page, and an Arrange menu for organizing the various slides within a presentation. You will learn how to use these specific menu features as you practice using the software later in the course.