apps.google.com/learning-center
Gmail Cheat Sheet
mail.google.com
Work faster and collaborate better with powerful email features. Create and send emails, reply to threaded email conversations, and organize your inbox.
1
Click
2
to create new emails.
Click a message in your inbox to read it and send a reply.
Expand all emails in the conversation
Change font styles
Choose text alignment
Add links
Add attachments Insert files from Drive
3
Open conversation in a new window
Insert images
Organize your inbox.
Archive email
Delete email
Advanced search and filters
Add labels
Add selected emails to task list Change settings
Select email
Star or mark as important
Š2016 Google Inc., 1600 Amphitheatre Parkway, Mountain View, CA 94043, USA
Unread emails
galc-gmail-cs_1.02
apps.google.com/learning-center
Calendar Cheat Sheet
calendar.google.com
Manage your time with integrated online calendars designed for teams. Keep track of important events, share your schedule, and create multiple calendars.
1 Click
to schedule a new event and enter event details
Invite guests
Enter event details Add a Hangouts video call
Add or delete event notifications
2
Click any event on your calendar to join a video call or edit events and invites.
Join a video call Respond to invites
3
Add and customize calendars.
Edit event details
3
1 Create a new calendar Make more calendars, such as a team calendar or a calendar to track project deadlines. 2 Add a coworker’s calendar Then select any added calendar to view it.
1
3 Change Calendar settings Change default notifications, share calendars, set working hours, and more.
2
Š2016 Google Inc., 1600 Amphitheatre Parkway, Mountain View, CA 94043, USA
galc-calendar-cs_1.02
1
apps.google.com/learning-center
Drive Cheat Sheet
drive.google.com
Keep all your work in one secure place with online file storage. After you store your files in Google Drive, you can share them with others and access them on any computer, smartphone, or tablet. When you change or delete a file stored in one of these locations, Drive makes the same change everywhere else so you don’t have to.
1
2
Click
to…
a
Upload any files (such as PDFs, videos, and pictures) and folders from your computer.
b
Create new documents right in your browser. Description
Example uses
Text documents
Proposals, reports, shared meeting notes
Spreadsheets
Project plans, budget sheets
Presentations
Pitch decks, training modules, team presentations
Surveys
Customer satisfaction surveys, group polls
Drawings
Flowcharts, diagrams, wireframes
Work with files you’ve stored in Drive. Get link to file
Share files with others
Preview files without buying extra software
Remove file Search for files Change settings Right-click a file or folder to:
See what other people shared with you
Move it to another folder Upload a new version or r evert to previous versions
View, restore, or permanently delete removed files
Make a copy Save a copy on your computer
3
Click
to share your files and folders, then choose what collaborators can do. They’ll also receive an email notification. Delete files and folders
Add and remove files and folders
Share or unshare files and folders
Edit Docs files
x
x
x
x
Can edit Can comment
Comment or suggest edits in files
View files and folders
x x
x x x
Can view
4
Access your files from any device. Browser or device
Requirements
How to access
Web browser (any device)
Install any web browser.
Go to drive.google.com.
Desktop computer
Install Google Drive for Mac/PC at https://www.google.com/drive/download/.
Open the Google Drive folder on your desktop
Mobile and tablet devices
Install the Drive app from the Play Store (Android) or App Store (iOS).
©2016 Google Inc., 1600 Amphitheatre Parkway, Mountain View, CA 94043, USA
galc-drive-cs_1.03
Open the Drive app on your smartphone or tablet.
apps.google.com/learning-center
Docs Cheat Sheet
docs.google.com
Create and simultaneously edit text documents with your team, right in your browser. Write reports, create joint project proposals, keep track of meeting notes, and much more. All changes are saved automatically!
1 Edit and add styles to your text.
Undo/Redo your last changes
Change title
Assign styles for headings and titles
Format your text
Copy formatting from one s ection of text and apply it t o another section
2 Work with different versions and copies of your document.
3 Enhance your document by adding features.
Make a copy Create a duplicate of your document. This is a great way to create templates!
Image Insert an image from your computer, the web, or Google Drive. Link Add a link to another page or to a header or bookmark in the same document.
See revision history See all the changes you and others have made to the document, or revert to earlier versions.
Drawing Create pictures, flowcharts, diagrams, and more in your document.
Download as Download your document in other formats such as Microsoft® Word® or PDF.
Table Select the number of columns and rows to create a table.
Publish to web Publish a copy of your document as a webpage, or embed your document in a website.
4
Click
Can edit
Bookmark Add shortcuts to specific places within your document. Table of contents Create an autogenerated table of contents that links to each heading (where you’ve applied heading styles).
to share your document, then choose what collaborators can do. They’ll also receive an email notification. Share or unshare
Edit content directly
Suggest edits
Add comments
x
x
x x
x x
Can comment Can view
5 Collaborate with your team in real-time.
View comment history
Chat with other people viewing the document
Share with your team Make changes directly in the document
Insert comments
Propose edits to the document. Your suggestions won’t change the original text until the document owner approves them. ©2016 Google Inc., 1600 Amphitheatre Parkway, Mountain View, CA 94043, USA
galc-docs-cs_1.02
apps.google.com/learning-center
Sheets Cheat Sheet
sheets.google.com
Create and simultaneously edit spreadsheets with your team, right in your browser. Analyze data with charts and filters, handle task lists, create project plans, and much more. All changes are saved automatically!
1
Customize your spreadsheet and data.
Copy formating from one section of text and apply it to another
Change title
Add or edit cell borders
Merge cells
Undo/Redo your last changes Format your data as currency, percentages, decimal places, or other options.
To enter data, click any cell and start typing
2
Format your text
Add links, comments, charts, filters, or functions
Work with rows and columns. 1 Add rows and columns Select a cell, click Insert, and choose where to add the row or column next to that cell. 2 Delete or hide rows and columns Right-click the row number or column letter and select Delete or Hide. 3 Move rows and columns Click the row number or column letter to select it. Then, drag it to a new location. 4 Freeze header rows and columns Keep some of your data in the same place. On the menu bar, click View. Then, choose an option under Freeze.
3
Click
to share your spreadsheet, then choose what collaborators can do. They’ll also receive an email notification.
Can edit
Share or unshare
Edit content directly
Add comments
x
x
x x
Can comment Can view
4
Collaborate with your team in real-time. Chat with other people viewing the spreadsheet
View comment history
5
Create different versions and copies of your spreadsheet. Make a copy Create a duplicate of your spreadsheet. This is a great way to create templates. See revision history See all the changes you and others have made to the spreadsheet, or revert to earlier versions. Download as Download your spreadsheet in other formats, such as Microsoft® Excel® or PDF.
Insert comments
Share with your team
Publish to the web Publish a copy of your spreadsheet as a webpage, or embed your spreadsheet in a website. Email as attachment Email a copy of your spreadsheet.
©2016 Google Inc., 1600 Amphitheatre Parkway, Mountain View, CA 94043, USA
galc-sheets-cs_1.04
1
apps.google.com/learning-center
Sheets Cheat Sheet
sheets.google.com
Work with functions Your most important Excel functions exist in Sheets, too!
Function
Type
Description
AVERAGE
Statistical
Returns the numerical average value in a dataset, ignoring text.
CHOOSE
Lookup
Returns an element from a list of choices based on index.
COUNT
Statistical
Returns the count of the number of numeric values in a dataset.
COUNTIF
Statistical
Returns a conditional count across a range.
DATE
Date
Converts a provided year, month, and day into a date.
DAYS360
Date
Returns the difference between two days based on the 360 day year.
FIND
Text
Returns the position at which a string is first found within text.
FINDB
Text
Returns the position at which a string is first found within text counting each double-character as 2.
IF
Logical
Returns one value if a logical expression is true and another if it is false.
INDEX
Lookup
Returns the content of a cell, specified by row and column offset.
INT
Math
Rounds a number down to the nearest integer that’s less than or equal to it.
LOOKUP
Lookup
Looks through a row or column for a key and returns the value of the cell in a result range located in the same position as the search row or column.
MATCH
Lookup
Returns the relative position of an item in a range that matches a specified value.
MAX
Statistical
Returns the maximum value in a numeric dataset.
MIN
Statistical
Returns the minimum value in a numeric dataset.
NOW
Date
Returns the current date and time as a date value.
ROUND
Math
Rounds a number to a certain number of decimal places according to standard rules.
SUM
Math
Returns the sum of a series of numbers and/or cells.
SUMIF
Math
Returns a conditional sum across a range.
TODAY
Date
Returns the current date as a date value.
VLOOKUP
Lookup
Searches down the first column of a range for a key and returns the value of a specified cell in the row found.
Š2016 Google Inc., 1600 Amphitheatre Parkway, Mountain View, CA 94043, USA
galc-sheets-cs_1.04
2
apps.google.com/learning-center
Slides Cheat Sheet
slides.google.com
Create and simultaneously edit presentations with your team, right in your browser. Collaborate on professional pitch decks, project presentations, training modules, and much more. All changes are saved automatically!
1
Add and edit content in your slides.
Change title
2
Add a text box, image, shape, or line
Add or change slide backgrounds, layouts, themes, or transitions
Add a link
Begin your presentation
Add and organize slides. 1
New slide Click
in the toolbar. Click
to choose a layout for the new slide.
2 Move slide Drag the slide to a different position in the presentation. To move several slides at once, Ctrl+click multiple slides before dragging them.
3
3
Duplicate slide Right-click the slide in the sidebar and select Duplicate slide.
4
Delete slide Right-click the slide and select Delete slide.
Work with different copies and versions of your presentation. Make a copy Create a duplicate of your presentation. This is a great way to create templates! Import slides Add slides from another presentation to your current slide deck. See revision history See all the changes you and others have made to the presentation, or revert to earlier versions. Download as Download your presentation in other formats such as Microsoft® PowerPoint® or PDF. Publish to the web Publish a copy of your presentation as a webpage, or embed your presentation in a website. Email as attachment Email a copy of your presentation.
4
Click
Can edit
to share your presentation, then choose what collaborators can do. They’ll also receive an email notification. Share or unshare
Edit content directly
Add comments
x
x
x x
Can comment Can view
©2016 Google Inc., 1600 Amphitheatre Parkway, Mountain View, CA 94043, USA
galc-slides-cs_1.03
apps.google.com/learning-center
Forms Cheat Sheet
forms.google.com
Create, simultaneously edit, and analyze surveys with your team, right in your browser. Manage event registrations, whip up a quick opinion poll, create a pop quiz, and much more.
1
Build your form.
Change your form’s look and feel
Rename your form
Customize your question and answer options
Add questions Add titles and descriptions, images, videos, or sections Edit, copy, or delete questions
2
Share and collaborate on your form.
3
Choose where to collect your responses.
4
Preview and send your form.
5
View and analyze responses.
Š2016 Google Inc., 1600 Amphitheatre Parkway, Mountain View, CA 94043, USA
galc-forms-cs_1.05
apps.google.com/learning-center
Hangouts Cheat Sheet
hangouts.google.com
Send messages and make video calls worldwide to several people at once. Hold impromptu meetings on the go, virtual training classes around the world, remote interviews, and much more.
1
Start a chat or video call in Gmail.
Find people to chat with
Start a video call or add other people to the chat Insert images, videos, and more Chat with someone
2
Join a call from… Gmail
3
Work with video calls.
Calendar
Add people to the video call
Your browser
Turn your microphone or camera on/off
Change settings
Leave call
Group chat with guests Share your screen
Remote desktop control
©2016 Google Inc., 1600 Amphitheatre Parkway, Mountain View, CA 94043, USA
View someone’s video or screen
galc-hangouts-cs_1.03