Catalog / Google Workspace Cheatsheet
Google Workspace Cheatsheet
A comprehensive cheat sheet covering essential Google Workspace (formerly G Suite) tools, shortcuts, and features to boost productivity.
Gmail Essentials
Keyboard Shortcuts
|
Compose a new email. |
|
Reply to the current email. |
|
Reply all to the current email. |
|
Forward the current email. |
|
Move to the newer/older conversation. |
|
Next/Previous message. |
|
Open the selected conversation. |
|
Report spam. |
Search Operators
Example: |
Example: |
Example: |
|
|
|
Tips & Tricks
Use filters to automatically label, archive, delete, or forward incoming emails based on specific criteria. |
Create multiple signatures for different types of emails (e.g., formal, informal, etc.). |
Use canned responses (templates) for frequently sent emails to save time. |
Enable offline mode to access and compose emails without an internet connection. |
Google Drive Mastery
File Management
|
Add a file to multiple folders. |
|
Create a new folder. |
|
Access file details and activity. |
Right-click on a file |
Share, rename, download, or remove the file. |
Shared drives |
For team-based file storage and collaboration. |
Collaboration Features
Share files or folders with specific people or groups with varying permission levels (view, comment, edit). |
Use comments and suggestions to provide feedback on documents, spreadsheets, and presentations. |
Track changes made to files and revert to previous versions if needed. |
Use Google Drive for Desktop to sync files between your computer and the cloud. |
Work simultaneously on the same document with others in real-time. |
Advanced Techniques
Use advanced search operators to quickly find specific files based on criteria like file type, owner, or date modified. |
Integrate Google Drive with other apps and services using add-ons and extensions. |
Use optical character recognition (OCR) to extract text from images and PDFs. |
Set expiration dates on shared links for added security. |
Google Docs Editing
Formatting Shortcuts
|
Bold text. |
|
Italicize text. |
|
Underline text. |
|
Numbered list. |
|
Bulleted list. |
|
Apply heading styles (Heading 1 to Heading 6). |
Collaboration & Review
Suggesting edits allows collaborators to propose changes without directly modifying the original text. |
Use comments to provide feedback, ask questions, or discuss specific sections of the document. |
Track changes to see who made which edits and when. |
Use the Explore tool to research topics and find relevant information without leaving the document. |
Link to other Google Workspace files directly within the document. |
Productivity Features
Use voice typing to dictate text instead of typing it manually. |
Insert special characters, equations, and drawings using the Insert menu. |
Create and use templates for frequently used documents. |
Translate the document into another language using the Translate feature. |
Add a table of contents for easy navigation in long documents. |
Google Sheets Functions
Basic Functions
|
Adds up all the numbers in a range of cells. |
|
Calculates the average of numbers in a range. |
|
Returns the largest number in a range. |
|
Returns the smallest number in a range. |
|
Counts the number of cells that contain numbers. |
Conditional Functions
Example: |
Example: |
Example: |
Data Manipulation
Example: |
Example: |
Example: |