Title Details

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.

Part I 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

Check Your File for Hidden or Personal Data 26

Email a File 28

Select Data 30

Cut, Copy, and Paste Data 32

Arrange Windows 34

Chapter 3 Office Graphics Tools

Insert a Picture 36

Insert an Online Picture 38

Resize and Move Objects 40

Understanding Graphics Modification Techniques 42

Chapter 4 Working with Office Files Online

Office and the Cloud 44

Sign In to Office 365 46

Share a Document from Office 48

Download Apps from the Office Store 50

Sign In to OneDrive 52

Using an Online App in OneDrive 54

Using an Office Program from OneDrive 56

Upload a Document to OneDrive 58

Share a Document Using OneDrive 60

Part II Word

Chapter 5 Adding Text

Change Word’s Views 64

Type and Edit Text 66

Insert Quick Parts 68

Insert Symbols 70

Create a Blog Post 72

Chapter 6 Formatting Text

Change the Font, Size, and Color 74

Align Text 78

Set Line Spacing 79

Indent Text 80

Set Tabs 82

Set Margins 84

Create Lists 86

Copy Formatting 88

Clear Formatting 89

Format with Styles 90

Using a Template 92

Chapter 7 Adding Extra Touches

Insert an Online Video 94

Assign a Theme 96

Add Borders 98

Create Columns 100

Insert a Table 102

Apply Table Styles 104

Insert Table Rows or Columns 105

Add Headers and Footers 106

Insert Footnotes and Endnotes 108

Insert Page Numbers and Page Breaks 110

Mark Index Entries 112

Generate an Index 114

Generate a Table of Contents 116

Create a Bibliography 118

Chapter 8 Reviewing Documents

Work in Read Mode View 120

Find and Replace Text 124

Scan Document Content 126

Check Spelling and Grammar 128

Work with AutoCorrect 130

Using Word’s Thesaurus and Dictionary 132

Translate Text 134

Track and Review Document Changes 136

Lock and Unlock Tracking 138

Combine Reviewers’ Comments 140

Work with Comments 142

Part III Excel

Chapter 9 Building Spreadsheets

Enter Cell Data 146

Select Cells 148

Faster Data Entry with AutoFill 150

Turn On Text Wrapping 152

Center Data Across Columns 153

Adjust Cell Alignment 154

Change the Font and Size 156

Change Number Formats 158

Increase or Decrease Decimals 159

Add Cell Borders and Shading 160

Format Data with Styles 162

Apply Conditional Formatting 164

Add Columns and Rows 166

Resize Columns and Rows 168

Freeze Column and Row Titles On‐Screen 169

Name a Range 170

Clear or Delete Cells 172

Split and Format a Column of Data 174

Chapter 10 Worksheet Basics

Add a Worksheet 176

Name a Worksheet 177

Change Page Setup Options 178

Move and Copy Worksheets 180

Delete a Worksheet 181

Find and Replace Data 182

Create a Table 184

Filter or Sort Table Information 186

Analyze Data Quickly 188

Understanding Data Analysis Choices 189

Track and Review Worksheet Changes 190

Insert a Comment 192

Chapter 11 Working with Formulas and Functions

Understanding Formulas 194

Create a Formula 196

Apply Absolute and Relative Cell References 198

Understanding Functions 200

Apply a Function 202

Total Cells with AutoSum 204

Audit a Worksheet for Errors 206

Chapter 12 Working with Charts

Create a Chart 208

Move and Resize Charts 210

Change the Chart Type 212

Change the Chart Style 213

Change the Chart Layout 214

Add Chart Elements 215

Format Chart Objects 216

Change the Chart Data 217

Using Sparklines to View Data Trends 218

Understanding PivotTables 220

Create a PivotTable 222

Create a PivotChart 224

Insert a PivotTable Slicer 226

Part IV PowerPoint

Chapter 13 Creating a Presentation

Create a New Presentation 230

Create a Photo Album Presentation 232

Change PowerPoint Views 234

Insert Slides 236

Change the Slide Layout 238

Change the Slide Size 240

Chapter 14 Populating Presentation Slides

Add and Edit Slide Text 242

Change the Font, Size, and Color 244

Apply a Theme 248

Set Line Spacing 249

Align Text 250

Add a Text Box to a Slide 251

Add a Table to a Slide 252

Add a Chart to a Slide 254

Add a Video Clip to a Slide 256

Move a Slide Object 258

Resize a Slide Object 259 Chapter 15 Assembling and Presenting a Slide Show

Reorganize Slides 260

Reuse a Slide 262

Organize Slides into Sections 264

Define Slide Transitions 266

Add Animation Effects 268

Create a Custom Animation 270

Record Narration 272

Insert a Background Song 273

Create Speaker Notes 274

Rehearse a Slide Show 276

Run a Slide Show 278

Review a Presentation 282

Package Your Presentation on a CD 284

Present Online 286

Part V Access

Chapter 16 Database Basics

Understanding Database Basics 290

Create a Database Based on a Template 292

Create a Blank Database 294

Create a New Table 296

Change Table Views 298

Add a Field to a Table 300

Delete a Field from a Table 301

Hide a Field in a Table 302

Move a Field in a Table 303

Create a Form 304

Change Form Views 306

Move a Field in a Form 307

Delete a Field in a Form 308

Apply a Database Theme 309

Format Form Fields 310

Add a Background Image 311

Chapter 17 Adding, Finding, and Querying Data

Add a Record to a Table 312

Add a Record to a Form 314

Navigate Records in a Form 316

Search for a Record Using a Form 317

Delete a Record from a Table 318

Delete a Record Using a Form 319

Sort Records 320

Filter Records 322

Apply Conditional Formatting 324

Perform a Simple Query 326

Create a Report 330

Part VI Outlook

Chapter 18 Organizing with Outlook

Navigate in Outlook 336

Schedule an Appointment 338

Create a New Contact 340

Create a New Task 342

Add a Note 344

Customize the Navigation Bar 346

Peek at Appointments and Tasks 348

Search for Outlook Items 350

Work with the To‐Do Bar 352

Link Contacts 353

Chapter 19 Emailing with Outlook

Compose and Send a Message 354

Send a File Attachment 356

Read an Incoming Message 357

Reply To or Forward a Message 358

Add a Sender to Your Outlook Contacts 360

Delete a Message 361

Work with Conversations 362

Screen Junk Email 364

Create a Message Rule 366

Part VII Publisher

Chapter 20 Publisher Basics

Create a Publication 370

Zoom In and Out 372

Add Text 374

Add a New Text Box 375

Swap Pictures 376

Save a Publication for Photo Center Printing 378

Chapter 21 Fine‐Tuning a Publication

Change the Font, Size, and Color 380

Apply a Text Effect 384

Change Text Alignment 385

Add a Border 386

Control Text Wrap 387

Link Text Boxes 388

Edit the Background 390

Add a Building Block Object 392

Create a Building Block Object 394

Part VIII OneNote

Chapter 22 Taking Notes with OneNote

Navigate OneNote 398

Type and Draw Notes 400

Insert and Format a Table 402

Attach Files to Notes 404

Create a Quick Note 405

Insert a Screen Clipping 406

Record an Audio Note 408

Chapter 23 Organizing and Sharing Notes

Create a New Notebook 410

Create a New Section 411

Create a New Page 412

Rename a Section or Page 413

Group Sections 414

Search Notes 416

Search for Recent Edits 418

Set Synchronization Options 419

Share Notes with People Who Do Not Have OneNote 420

Index 422