Оглавление
Paul McFedries. G Suite For Dummies
G Suite® For Dummies® To view this book's Cheat Sheet, simply go to www.dummies.com and search for “G Suite For Dummies Cheat Sheet” in the Search box. Table of Contents
List of Tables
List of Illustrations
Guide
Pages
Introduction
About This Book
What You Can Safely Ignore
Foolish Assumptions
Icons Used in This Book
Beyond the Book
Where to Go from Here
Keeping Your Affairs in Order
G Suite: The 50¢ Tour
What Is G Suite?
What You Get with G Suite
Using Apps Online — Really? Here Are the FAQs
ANOTHER FAQ: WHAT’S ALL THIS ABOUT A “CLOUD”?
Introducing Online Collaboration
Going Mobile
Taming the Email Beast
Rhymes with Email: Getting to Know Gmail
Touring the Gmail app
Touring the Gmail Inbox
Showing your good side: Adding a profile photo
The Outbox: Sending an Email Message
The basics: Composing and sending a message
Easier addressing: Using the Contacts app
Inserting attachments and other hangers-on
Creating a signature
Scheduling a send
Undoing a send
The Inbox: Handling Incoming Messages
Refreshing your messages
Reading your messages
Easier reading with the Reading pane
Attending to attachments
Responding to a message
Creating a task from a message
Setting up a vacation responder
Selecting messages
Dealing with the Onslaught
Cleaning out your inbox
Labeling your messages
Putting a label on a message
Creating a new label
Creating a nested label
Customizing the label list
Muting a conversation
Snoozing a conversation
Searching for messages
Filtering your messages
Places to Go, People to See: Managing Your Calendar
Navigating the Calendar Window
Changing the Calendar View
Time Traveling: Changing the Date
Setting Your Social Schedule: Entering Events
Adding an event
Editing an event
Lather, rise, repeat: Creating a repeating event
Scheduling an all-day event
Psst: Setting up event notifications
Nudge, nudge: Creating a reminder
Things to do: Creating a task
Creating a task in Calendar
Creating a task in the Tasks app
Going Calendar Crazy: Adding Even More Calendars
Friends, Romans, Countrymen: Managing Your Contacts
Eyeballing the Contacts App
What's with those “other” contacts?
Configuring the Contacts columns
Changing the sort order
Populating Your Contacts List
Adding a contact from scratch
Adding a contact from Gmail
Going legit: Turning an “other” contact into a real contact
Adding multiple contacts all at once
Importing contacts
Managing Your Contacts
Editing a contact
Grouping contacts with labels
Merging duplicate contacts
Exporting contacts
Deleting contacts
Doing Stuff with Your Contacts
Emailing a contact
Emailing a contact who has multiple addresses
Emailing multiple contacts
Calling a contact
Surfing to a contact's website
Making Stuff: Documents, Spreadsheets, and More
Getting Started with Docs
Opening Docs
Touring the Google Docs Home Page
Creating a Shiny, New Document
Checking Out the Document Screen
Dealing with Documents
Saving your work — just kidding!
Naming a new document
Opening an existing document
Saving a copy of a document
Learning Some Editing Basics
Navigating with the keyboard
Navigating characters and words
Navigating lines and paragraphs
Navigating headings, screens, and documents
Selecting text
Deleting stuff
Deleting characters
Deleting words
To err is human, to undo divine
Fooling around with special characters
Stating your case: Uppercase versus lowercase
Adding links
Setting tab stops
Search and Ye Shall Replace
Finding stuff
Some notes on searching
Finding-and-replacing stuff
Checking Spelling and Grammar
Handling spelling slip-ups
Handling grammar gaffes
Looking Good: Formatting Documents
Making Your Characters Look Good
Getting familiar with fonts
Just what the heck is a font, anyway?
Typeface
Type style and size
Type position
Formatting with fonts
Avoiding the ransom note look
Copy text formatting by “painting” it
Making Your Lines and Paragraphs Look Good
Getting your text ducks in a row: Aligning paragraphs
Breathing room: Changing the line spacing
Giving paragraphs some elbow room
Keeping stuff together
Indenting paragraphs
Using Styles to Make Looking Good Look Easy
Style advantages
Applying default Docs styles to avoid reinventing the style wheel
Updating a default style to taste
Saving your updated styles
Telling Docs to use your updated styles
Resetting the default styles
Making Lists, Checking Them Twice
Putting your affairs in order with numbered lists
Scoring points with bulleted lists
Image Is Everything: Adding Graphics
Inserting an image from your PC
Inserting an image from the web
Inserting an image from Drive
Inserting an image from Photos
Inserting an image from a URL
Inserting a photo from your PC's camera
Setting a few image options
Fiddling with Document Layout
Building a Table with Your Bare Hands
What is a table?
Inserting a table
Populating a table
Adjusting column widths
Selecting table cells
Setting table properties
Inserting a new row or column
Deleting a row or column
Merging table cells
Headers and Footers from Head to Toe
Adding a header
Adding a footer
Opening the header or footer for editing
Creating a unique first-page header and footer
Creating unique odd and even page headers and footers
Changing the Page Setup
Setting the page margins
Changing the page orientation
Changing the paper size
Adding a page break
Adding a section break
Working with Columns, Just Like the Pros
Getting text into columns, Part 1: The easy way
Getting text into columns, Part 2: The ever-so-slightly-harder way
Entering text in columns
Show Your Work: Adding Footnotes
Getting Started with Sheets
Opening Sheets
Touring the Google Sheets Home Page
Creating a New Spreadsheet
Checking Out the Spreadsheet Screen
Dealing with Spreadsheets
Sheets saves your work for you
Naming a new spreadsheet
Opening an existing spreadsheet
Saving a copy of a spreadsheet
Understanding Sheet Cells
Entering Data
Entering text
Entering numbers
Entering dates and times
Navigating a sheet
Editing cell contents
Working with Ranges
Understanding ranges
Selecting a range
Mouse techniques for selecting a range
Mouse tricks for selecting a range
Keyboard techniques for selecting a range
Keyboard tricks for selecting a range
Specifying a range input in a dialog box
Working with named ranges
Understanding named range restrictions
Naming a range
Using a named range
Filling a range with data
Filling a range with a series of values
Copying a range
Moving a range
Formatting a Cell
Formatting the cell font
Aligning cell data
Applying a numeric, date, or time format
Using the Paint Format tool
Working with Columns and Rows
Adjusting the column width
Specifying a column width
Using a mouse to set the column width
Fitting the column width to the data
Adjusting the row height
Specifying a row height
Using the mouse to set the row height
Fitting the row height to the data
Hiding columns and rows
Inserting columns and rows
Deleting columns and rows
Crunching Numbers
Building Formulas
Creating a simple formula
Understanding formula operators
Avoiding problems with cell references
Using Functions for More Powerful Formulas
Entering functions directly
Entering functions via the Function menu
Using a Range as a Database
Sorting a range
Filtering a range
Activating the filter
Filtering by the values in a column
Filtering by condition
Visualizing Data with Charts
Getting to know the chart elements
How Sheets converts sheet data into a chart
Creating a chart
Moving a chart to its own sheet
Editing the chart
Building Pivot Tables
Understanding pivot tables
Exploring pivot table features
Building a pivot table
Adding multiple fields to a pivot table area
Pivoting a field to a different area
Grouping pivot table values
Grouping numeric values
Grouping date and time values
Filtering pivot table values
Creating Eye-Popping Presentations
Opening Slides
Touring the Google Slides Home Page
Creating a New Presentation
Checking Out the Presentation Screen
Dealing with Presentations
Slides saves your work for you
Naming a new presentation
Opening an existing presentation
Saving a copy of a presentation
Applying a presentation theme
Working with Slides
Adding a slide to the presentation
Inserting a new slide
Duplicating a slide
Importing slides from another presentation
Adding data to a slide
Adding slide text
Adding slide objects
Adding speaker notes
Selecting slides
Rearranging slides
Changing the layout of a slide
Changing the slide background
Working with the Master Slide
Formatting Slide Text
Formatting with fonts
Aligning paragraphs
Slide formatting considerations
Animating Your Slides
Learning a few animation guidelines
Setting up a slide transition
Animating slide objects
Running a Slide Show
Starting the slide show
Navigating slides
Navigating the slide show from the keyboard
Collaborating with Your Team
Collaborating on Files
Sharing a File
Sharing a file for editing
Sharing a file for commenting and suggesting
Sharing a file for viewing
Sharing a link to a file
Sharing a link with your organization
Sharing a link with selected users
Sharing a link with the public
Emailing your collaborators
Setting an access expiration date
Changing a user's sharing access
Removing a user's sharing access
Dealing with Shared Files
Responding to a sharing invitation
Viewing which files have been shared with you
Working on a Shared File
Making suggested edits to a shared Docs document
Adding comments to a file
Requesting edit access
Chatting with your fellow collaborators
Viewing a file's sharing activity
Reviewing a Shared File
Accepting or rejecting suggested changes in Docs
Working with comments
Collaborating with Calendar
Inviting Guests to a Meeting
Inviting guests to a new meeting
Inviting guests to an existing meeting
Controlling your guest list
Coordinating attendee schedules
Getting suggested meeting times
Responding to a Meeting Invitation
Sharing Your Calendar
Controlling access to your calendar in your organization
Making your calendar available to the public
Making your calendar unavailable to other G Suite apps
Sharing your calendar on an ad hoc basis
Sharing your calendar with only specific people
Subscribing to a Shared Calendar
Importing Events
Exporting Events
Setting Up Video Meetings
What Do You Need to Use Meet?
Allowing Meet to use your camera and microphone
Making sure Meet is using the equipment you want
Starting a Video Meeting
Starting a video meeting from the Meet home page
Starting a video meeting from Gmail
Adding people to your video meeting
Inviting people to join your video meeting via email
Sending the video meeting joining info to people
Scheduling a video meeting with Calendar
Joining a Video Meeting
Joining a video meeting from the Meet home page
Joining a video meeting from Gmail
Dialing in to a video meeting and using the phone for audio
Customizing Video Meeting Settings
Changing the meeting layout
Messing around with meeting participants
Displaying captions
Sharing Resources During a Video Meeting
Chatting with meeting participants
Presenting your screen
JOIN A MEETING JUST TO PRESENT
Chatting with Your Team
Chatting, G Suite Style
Chatting with Gmail
Chatting with Docs, Sheets, and Slides
Chatting with Meet
Chatting with Google Chat
Exchanging Messages
Formatting chat text
Messing around with messages
Collaborating with Chat
Chatting with a group
Uploading a file to a chat
Adding a video meeting to a chat
More Collaboration: Congregating in a Chat Room
Creating a room
Managing a room
Robotexting: Chatting with Bots
Adding a bot
GIPHY: Animated GIF fun and frivolity
Meet: Managing your meetings
Google Drive: Getting file alerts
Collaborating with Groups
Why Create a Group?
Investigating the Groups Home Page
Understanding Group Roles
Finding a Group
Joining a Group
Joining a group directly
Asking to join a group
Leaving a group
Posting Messages
Responding to Posts
Creating a Group
Preparing to add a group
Creating the group
Adding more people directly to the group
Inviting people to your group
Managing group requests and invitations
Collaborating with Forms and Notes
Gathering Info with Forms
Loading the Forms website
Touring the Forms home page
Creating a new form
Touring the form screen
Fabricating a form
Constructing a quiz
Adding form collaborators
Sending your form
Emailing a form
Sharing a link to a form
Embedding the form in a web page
Checking out the form responses
Sharing Notes
Checking out the Keep home page
Creating a new note
Adding note collaborators
The Part of Tens
Ten Tips for Working from Home
Set Your Working Hours
Show Your Availability
Tell Chat to Chill for a While
Keep Up the Face-to-Face Communication
Know Which Communications Tools to Use
Add Time Zones in Your Calendar
Configure Calendar for Speedy Meetings
Read Email from Another Account
Handle Microsoft Office Documents
Set Up Your Video Conference Space
Ten Really Useful Gmail Settings
Five Splendiferous Send Settings
Sending a message as plain text
Setting the default reply behavior
Replying and archiving in one fell swoop
Setting the default text style
Preventing Gmail from creating contacts automatically
Five Stupendous Read Settings
Turning off Conversation view
Adding importance markers
Setting the maximum page size
Managing notifications
Indicating messages sent only to you
Ten Ways to Enhance Privacy and Security
Make Sure Your Wi-Fi Network Is Locked Up Tight
Secure Your Google Account with a Strong Password
Enable Google’s 2-Step Verification
Set Up Your Contact Verification Methods
Hide Images in Gmail Messages
HOW WEB BUGS WORK
Blocking Senders in Gmail
Choose Who Can See Your Personal Info
Manage Your Activity Controls
Manage Your Devices
Manage Third-Party Apps
Glossary of G Suite Terms
Index. Special Characters
Numbers
A
B
C
D
E
F
G
H
I
J
K
L
M
N
O
P
Q
R
S
T
U
V
W
X
Y
About the Author
Dedication
Author’s Acknowledgments
WILEY END USER LICENSE AGREEMENT
