Office 2016 Simplified

Elaine Marmel (Phoenix, AZ) is President of Marmel Enterprises, LLC, an organization that specializes in technical writing and software training. Elaine has an MBA from Cornell University and worked on projects to build financial management systems for New York City and Washington, D.C. and trained more than 600 employees to use these systems. This prior experience provided the foundation for Marmel Enterprises, LLC to help small businesses manage the project of implementing a computerized accounting system. Elaine spends most of her time writing; she has authored and co-authored over seventy books. She left her native Chicago for the warmer climes of Arizona (by way of Cincinnati, OH; Jerusalem, Israel; Ithaca, NY; Washington, D.C. and Tampa, FL) where she basks in the sun with her PC, her cross stitch projects, and her dog Jack.

OFFICE FEATURES

Chapter 1 Office Basics

Start and Exit Office Applications 4

Navigate the Program Windows 6

Work with Backstage View 7

Change the Color Scheme 8

Find a Ribbon Command 10

Work with the Ribbon 12

Customize the Quick Access Toolbar 14

Using an Office Program on a Tablet PC 16

Chapter 2 Working with Files

Create a New File 18

Save a File 20

Open a File 22

Print a File 24

Email a File 26

Select Data 28

Cut, Copy, and Paste Data 30

Arrange Windows 32

Chapter 3 Office Graphics Tools

Insert a Picture 34

Insert an Online Picture 36

Resize and Move Objects 38

Understanding Graphics Modification Techniques 40

Chapter 4 Working with Office Files Online

Office and the Cloud 42

Sign In to Office 365 44

Share a Document from Office 46

Download Apps from the Office Store 48

Sign In to OneDrive 50

Using an Online App in OneDrive 52

Using an Office Program from OneDrive 54

Upload a Document to OneDrive 56

Share a Document Using OneDrive 58

WORD

Chapter 5 Adding Text

Change Word’s Views 62

Type and Edit Text 64

Insert Quick Parts 66

Insert Symbols 68

Create a Blog Post 70

Chapter 6 Formatting Text

Change the Font, Size, and Color 72

Align Text 76

Set Line Spacing 77

Indent Text 78

Set Tabs 80

Set Margins 82

Create Lists 84

Copy Formatting 86

Clear Formatting 87

Format with Styles 88

Using a Template 90

EXCEL

Chapter 7 Adding Extra Touches

Insert an Online Video 92

Assign a Theme 94

Add Borders 96

Create Columns 98

Insert a Table 100

Apply Table Styles 102

Insert Table Rows or Columns 103

Add Headers and Footers 104

Insert Footnotes and Endnotes 106

Insert Page Numbers and Page Breaks 108

Generate a Table of Contents 110

Create a Bibliography 112

Chapter 8 Reviewing Documents

Work in Read Mode View 114

Find and Replace Text 116

Scan Document Content 118

Check Spelling and Grammar 120

Work with AutoCorrect 122

Using Word’s Thesaurus and Dictionary 124

Translate Text 126

Track and Review Document Changes 128

Lock and Unlock Tracking 130

Work with Comments 132

EXCEL

Chapter 9 Building Spreadsheets

Enter Cell Data 136

Select Cells 137

Faster Data Entry with AutoFill 138

Turn On Text Wrapping 140

Center Data Across Columns 141

Adjust Cell Alignment 142

Change the Font and Size 144

Change Number Formats 146

Increase or Decrease Decimals 147

Add Cell Borders and Shading 148

Format Data with Styles 150

Apply Conditional Formatting 152

Add Columns and Rows 154

Resize Columns and Rows 156

Freeze Column and Row Titles On‐Screen 157

Name a Range 158

Clear or Delete Cells 160

Split and Format a Column of Data 162

Chapter 10 Worksheet Basics

Add a Worksheet 164

Name a Worksheet 165

Change Page Setup Options 166

Move and Copy Worksheets 168

Delete a Worksheet 169

Find and Replace Data 170

Create a Table 172

Filter or Sort Table Information 174

Analyze Data Quickly 176

Understanding Data Analysis Choices 177

Track and Review Worksheet Changes 178

Insert a Comment 180

Chapter 11 Working with Formulas and Functions

Understanding Formulas 182

Create a Formula 184

Apply Absolute and Relative Cell References 186

Understanding Functions 188

Apply a Function 190

Total Cells with AutoSum 192

Audit a Worksheet for Errors 194

Chapter 12 Working with Charts

Create a Chart 196

Move and Resize Charts 198

Change the Chart Type 200

Change the Chart Style 201

Change the Chart Layout 202

Add Chart Elements 203

Format Chart Objects 204

Change the Chart Data 205

Using Sparklines to View Data Trends . . . . . . . . . . . . . .206

POWERPOINT

Chapter 13 Creating a Presentation

Create a New Presentation 210

Create a Photo Album Presentation 212

Change PowerPoint Views 214

Insert Slides 216

Change the Slide Layout 217

Change the Slide Size 218

Chapter 14 Populating Presentation Slides

Add and Edit Slide Text 220

Change the Font, Size, and Color 222

Apply a Theme 226

Set Line Spacing 227

Align Text 228

Add a Text Box to a Slide 229

Add a Table to a Slide 230

Add a Chart to a Slide 232

Add a Video Clip to a Slide 234

Move a Slide Object 236

Resize a Slide Object 237

Chapter 15 Assembling and Presenting a Slide Show

Reorganize Slides 238

Reuse a Slide 240

Define Slide Transitions 242

Add Animation Effects 244

Record Narration 246

Insert a Background Song 247

Create Speaker Notes 248

Rehearse a Slide Show 250

Run a Slide Show 252

Review a Presentation 256

Package Your Presentation on a CD 258

Present Online 260

ACCESS

Chapter 16 Database Basics

Understanding Database Basics 264

Create a Database Based on a Template 266

Create a Blank Database 268

Create a New Table 270

Change Table Views 272

Add a Field to a Table 274

Delete a Field from a Table 275

Hide a Field in a Table 276

Move a Field in a Table 277

Create a Form 278

Change Form Views 280

Move a Field in a Form 281

Delete a Field in a Form 282

Apply a Database Theme 283

Chapter 17 Adding, Finding, and Querying Data

Add a Record to a Table 284

Add a Record to a Form 286

Navigate Records in a Form 288

Search for a Record Using a Form 289

Delete a Record from a Table 290

Delete a Record Using a Form 291

Sort Records 292

Filter Records 294

Apply Conditional Formatting 296

Perform a Simple Query 298

Create a Report 302

OUTLOOK

Chapter 18 Organizing with Outlook

Navigate in Outlook 306

Schedule an Appointment 308

Create a New Contact 310

Create a New Task . . . . . . . . . . . . . . . . . . . . .312

Add a Note 314

Customize the Navigation Bar 316

Peek at Appointments and Tasks 318

Search for Outlook Items 320

Work with the To‐Do Bar 322

Link Contacts 323

Chapter 19 Emailing with Outlook

Compose and Send a Message 324

Send a File Attachment 326

Read an Incoming Message 327

Reply To or Forward a Message 328

Add a Sender to Your Outlook Contacts 330

Delete a Message 331

Work with Conversations 332

Screen Junk Email 334

PUBLISHER

Chapter 20 Publisher Basics

Create a Publication 338

Zoom In and Out 340

Add Text 342

Add a New Text Box 343

Swap Pictures 344

Save a Publication for Photo Center Printing 346

Chapter 21 Fine‐Tuning a Publication

Change the Font, Size, and Color 348

Apply a Text Effect 352

Change Text Alignment 353

Add a Border 354

Control Text Wrap 355

Link Text Boxes 356

Edit the Background 358

Taking Notes with OneNote

Navigate OneNote 362

Type and Draw Notes 364

Insert and Format a Table 366

Attach Files to Notes 368

Create a Quick Note 369

Insert a Screen Clipping 370

Record an Audio Note 372

ONENOTE

Chapter 22 Organizing and Sharing Notes

Create a New Notebook 374

Create a New Section 375

Create a New Page 376

Rename a Section or Page 377

Group Sections 378

Search Notes 380

Search for Recent Edits 382

Set Synchronization Options 383

Share Notes with People Who Do Not Have OneNote 384