Paul McFedries has worked, programmed, and even talked to computers large and small since 1975. Primarily a writer, he has worked as a programmer, consultant, and database and website developer. His more than 95 books have sold 4+ million copies worldwide.

Introduction 1

About This Book 1

What You Can Safely Ignore 2

Foolish Assumptions 2

Icons Used in This Book 3

Beyond the Book 4

Where to Go from Here 4

Part 1: Keeping Your Affairs in Order 5

Chapter 1: G Suite: The 50¢ Tour 7

What is G Suite? 8

What You Get with G Suite 9

Using Apps Online - Really? Here are the FAQs 10

Introducing Online Collaboration 14

Going Mobile 15

Chapter 2: Taming the Email Beast 17

Rhymes with Email: Getting to Know Gmail 17

Touring the Gmail app 18

Touring the Gmail Inbox 19

Showing your good side: Adding a profile photo 20

The Outbox: Sending an Email Message 22

The basics: Composing and sending a message 22

Easier addressing: Using the Contacts app 24

Inserting attachments and other hangers-on 25

Creating a signature 25

Scheduling a send 27

Undoing a send 28

The Inbox: Handling Incoming Messages 29

Refreshing your messages 29

Reading your messages 29

Easier reading with the Reading pane 30

Attending to attachments 32

Responding to a message 33

Creating a task from a message 34

Setting up a vacation responder 34

Selecting messages 36

Dealing with the Onslaught 37

Cleaning out your inbox 37

Labeling your messages 38

Muting a conversation 42

Snoozing a conversation 42

Searching for messages 44

Filtering your messages 45

Chapter 3: Places to Go, People to See: Managing Your Calendar 47

Navigating the Calendar Window 48

Changing the Calendar View 50

Time Traveling: Changing the Date 51

Setting Your Social Schedule: Entering Events 52

Adding an event 53

Editing an event 55

Lather, rise, repeat: Creating a repeating event 56

Scheduling an all-day event 59

Psst: Setting up event notifications 60

Nudge, nudge: Creating a reminder 62

Things to do: Creating a task 63

Going Calendar Crazy: Adding Even More Calendars 66

Chapter 4: Friends, Romans, Countrymen: Managing Your Contacts 69

Eyeballing the Contacts App 70

What's with those "other" contacts? 71

Configuring the Contacts columns 72

Changing the sort order 73

Populating Your Contacts List 74

Adding a contact from scratch 74

Adding a contact from Gmail 75

Going legit: Turning an "other" contact into a real contact 76

Adding multiple contacts all at once 77

Importing contacts 78

Managing Your Contacts 79

Editing a contact 80

Grouping contacts with labels 81

Merging duplicate contacts 82

Exporting contacts 83

Deleting contacts 84

Doing Stuff with Your Contacts 85

Emailing a contact 85

Emailing a contact who has multiple addresses 86

Emailing multiple contacts 86

Calling a contact 87

Surfing to a contact's website 87

Part 2: Making Stuff: Documents, Spreadsheets, and More 89

Chapter 5: Getting Started with Docs 91

Opening Docs 92

Touring the Google Docs Home Page 92

Creating a Shiny, New Document 94

Checking Out the Document Screen 94

Dealing with Documents 96

Saving your work - just kidding! 96

Naming a new document 97

Opening an existing document 97

Saving a copy of a document 99

Learning Some Editing Basics 100

Navigating with the keyboard 100

Selecting text 102

Deleting stuff 102

Deleting characters 103

Fooling around with special characters 104

Stating your case: Uppercase versus lowercase 106

Adding links 106

Setting tab stops 107

Search and Ye Shall Replace 108

Finding stuff 108

Some notes on searching 109

Finding-and-replacing stuff 110

Checking Spelling and Grammar 111

Handling spelling slip-ups 111

Handling grammar gaffes 112

Chapter 6: Looking Good: Formatting Documents 115

Making Your Characters Look Good 115

Getting familiar with fonts 116

Formatting with fonts 118

Avoiding the ransom note look 120

Copy text formatting by "painting" it 121

Making Your Lines and Paragraphs Look Good 121

Getting your text ducks in a row: Aligning paragraphs 121

Breathing room: Changing the line spacing 123

Giving paragraphs some elbow room 125

Keeping stuff together 125

Indenting paragraphs 126

Using Styles to Make Looking Good Look Easy 128

Style advantages 129

Applying default Docs styles to avoid reinventing the style wheel 130

Updating a default style to taste 132

Saving your updated styles 132

Telling Docs to use your updated styles 133

Resetting the default styles 133

Making Lists, Checking Them Twice 133

Putting your affairs in order with numbered lists 133

Scoring points with bulleted lists 135

Image is Everything: Adding Graphics 137

Inserting an image from your PC 138

Inserting an image from the web 139

Inserting an image from Drive 139

Inserting an image from Photos 140

Inserting an image from a URL 140

Inserting a photo from your PC's camera 140

Setting a few image options 141

Chapter 7: Fiddling with Document Layout 143

Building a Table with Your Bare Hands 143

What is a table? 144

Inserting a table 145

Populating a table 145

Adjusting column widths 146

Selecting table cells 147

Setting table properties 147

Inserting a new row or column 149

Deleting a row or column 150

Merging table cells 150

Headers and Footers from Head to Toe 151

Adding a header 151

Adding a footer 153

Opening the header or footer for editing 154

Creating a unique first-page header and footer 154

Creating unique odd and even page headers and footers 154

Changing the Page Setup 156

Setting the page margins 156

Changing the page orientation 158

Changing the paper size 158

Adding a page break 159

Adding a section break 159

Working with Columns, Just Like the Pros 161

Getting text into columns, Part 1: The easy way 161

Getting text into columns, Part 2: The ever-so-slightly-harder way 162

Entering text in columns 163

Show Your Work: Adding Footnotes 164

Chapter 8: Getting Started with Sheets 167

Opening Sheets 168

Touring the Google Sheets Home Page 168

Creating a New Spreadsheet 170

Checking Out the Spreadsheet Screen 170

Dealing with Spreadsheets 172

Sheets saves your work for you 172

Naming a new spreadsheet 173

Opening an existing spreadsheet 173

Saving a copy of a spreadsheet 174

Understanding Sheet Cells 174

Entering Data 175

Entering text 175

Entering numbers 176

Entering dates and times 177

Navigating a sheet 179

Editing cell contents 180

Working with Ranges 180

Understanding ranges 180

Selecting a range 181

Specifying a range input in a dialog box 184

Working with named ranges 185

Filling a range with data 187

Filling a range with a series of values 187

Copying a range 188

Moving a range 188

Formatting a Cell 189

Formatting the cell font 189

Aligning cell data 190

Applying a numeric, date, or time format 191

Using the Paint Format tool 192

Working with Columns and Rows 193

Adjusting the column width 193

Adjusting the row height 194

Hiding columns and rows 196

Inserting columns and rows 196

Deleting columns and rows 197

Chapter 9: Crunching Numbers 199

Building Formulas 199

Creating a simple formula 200

Understanding formula operators 201

Avoiding problems with cell references 202

Using Functions for More Powerful Formulas 206

Entering functions directly 207

Entering functions via the Function menu 208

Using a Range as a Database 209

Sorting a range 209

Filtering a range 211

Visualizing Data with Charts 213

Getting to know the chart elements 213

How Sheets converts sheet data into a chart 214

Creating a chart 216

Moving a chart to its own sheet 217

Editing the chart 217

Building Pivot Tables 218

Understanding pivot tables 219

Exploring pivot table features 220

Building a pivot table 221

Adding multiple fields to a pivot table area 224

Pivoting a field to a different area 225

Grouping pivot table values 225

Filtering pivot table values 227

Chapter 10: Creating Eye-Popping Presentations 229

Opening Slides 230

Touring the Google Slides Home Page 230

Creating a New Presentation 232

Checking Out the Presentation Screen 232

Dealing with Presentations 234

Slides saves your work for you 234

Naming a new presentation 234

Opening an existing presentation 234

Saving a copy of a presentation 235

Applying a presentation theme 235

Working with Slides 237

Adding a slide to the presentation 237

Adding data to a slide 239

Selecting slides 242

Rearranging slides 242

Changing the layout of a slide 242

Changing the slide background 243

Working with the Master Slide 243

Formatting Slide Text 245

Formatting with...