Office For Seniors For Dummies

SEND EMAILS, STAY ON TOP OF YOUR FINANCES, AND MANAGE YOUR EVERYDAY LIFE WITH THIS NO-EXPERIENCE-NECESSARY OFFICE 2021 HANDBOOK

Microsoft Office offers huge benefits to people of all ages. The popular software suite has always made creating to-do lists, sending emails, drafting documents, and processing spreadsheets a breeze, and the updates and upgrades found in Office 2021 make those tasks even easier. Office For Seniors For Dummies offers step-by-step instructions to learn every part of Office 2021, including Word, Excel, and PowerPoint. This trusted guide starts at the very beginning, showing you how to start each application and understand the interface. It walks you through the most commonly used functions of each program and explains how to apply it in your everyday life. Written in large, crystal-clear type and full of helpful images and screenshots, the book also demonstrates how to:

* Stay in touch with friends and family using Office 2021's built-in communications tools, including Outlook
* Keep your finances up to date with functional spreadsheets in Excel
* Take advantage of existing Office templates for things like budgets, letters, faxes, and more

You don't have to be a computer scientist to get the most out of Office 2021. Let this handy guide clarify and demystify some of the most practical and user-friendly applications available today. FAITHE WEMPEN, M.A., is a Microsoft Office Master Instructor who has been writing and teaching about Microsoft Office for more than 25 years. She is an adjunct professor of Computer Information Technology with more than 150 books to her credit, including Computers For Seniors For Dummies and Outlook For Dummies, as well as a CompTIA A+ certified computer technician.

INTRODUCTION 1

About This Book 1

Foolish Assumptions 3

Icons Used in This Book 3

Beyond the Book 4

Where to Go from Here 4

PART 1: GETTING STARTED WITH OFFICE 5

CHAPTER 1: THE TWO-DOLLAR TOUR 7

Start an Office Application 8

Start a New Document 9

Explore the Office Ribbon and Tabs 10

Understand the File Menu (Backstage View) 15

Create a Document 16

Type Text 17

Insert a Picture 19

Move Around in a Document 20

Select Content 22

Zoom In and Out 24

Change the View 25

CHAPTER 2: EXPLORING THE COMMON FEATURES OF OFFICE APPLICATIONS 27

Edit Text 28

Move and Copy Content 29

Choose Fonts and Font Sizes 33

Apply Text Formatting 36

Use the Mini Toolbar 38

Work with Themes 39

Check Your Spelling and Grammar 43

CHAPTER 3: OPENING, SAVING, AND PRINTING FILES 49

Save Your Work 50

The Basic Save 50

Changing the Save Location 52

Choosing a File Type 57

Open a Previously Saved File 57

Change the File Listing View 59

Email Your Work to Others 60

Emailing a Link to a Document 61

Emailing a Copy of a Document 63

Share Your Work in Other Formats 65

Print Your Work 68

Recover Lost Work 70

PART 2: WORD 73

CHAPTER 4: COMPOSING YOUR THOUGHTS IN WORD 75

Examine the Word Interface 76

Move Around and Select Text 77

Choose Paper Size and Orientation 79

Set Margins 80

Select the Right Screen View 82

Align and Indent Paragraphs 84

Change Line Spacing 90

Create Bulleted and Numbered Lists 92

CHAPTER 5: DRESSING UP YOUR DOCUMENTS 95

Apply Styles and Style Sets 96

Insert Pictures 101

Size and Format a Picture 105

Position a Picture 106

Add a Page Border 108

Apply a Background Color to a Page 110

Create Tables 112

Format a Table 115

CHAPTER 6: TAKING WORD TO THE NEXT LEVEL 117

Number the Pages 118

Use Headers and Footers 120

Insert Cover Pages and Other Building Blocks 123

Print an Envelope 125

Perform a Mail Merge 127

Insert the Date and Time 133

PART 3: EXCEL 135

CHAPTER 7: CREATING BASIC SPREADSHEETS IN EXCEL 137

Understand Excel’s Unique Features 138

Get Familiar with Spreadsheet Structure 140

Move the Cell Cursor 140

Select a Range 142

Type and Edit Cell Contents 145

Insert and Delete Rows, Columns, and Cells 147

Work with Worksheets 151

CHAPTER 8: DOING THE MATH: FORMULAS AND FUNCTIONS 155

Learn How Formulas Are Structured 156

Write Formulas That Reference Cells 156

Move and Copy Cell Content 157

Reference a Cell on Another Sheet 159

Understand Functions 160

Take a Tour of Some Basic Functions 163

Explore Financial Functions 165

CHAPTER 9: CREATING VISUAL INTEREST WITH FORMATTING AND CHARTS 169

Adjust Row Height and Column Width 170

Wrap Text in a Cell 172

Apply Gridlines or Borders 172

Apply Fill Color 176

Format Text in Cells 177

Format the Spreadsheet as a Whole 179

Create a Basic Chart 181

Identify the Parts of a Chart 183

Format a Chart 185

CHAPTER 10: USING EXCEL AS A DATABASE 189

Understand Databases 190

Prepare a List for a Mail Merge 190

Store Data in a Table 191

Sort a Table 193

Filter Data in a Table 196

Split a Column’s Content 199

Merge the Contents of Columns 201

PART 4: OUTLOOK 205

CHAPTER 11: MANAGING EMAIL WITH OUTLOOK 207

Set Up Outlook for the First Time 208

Set Up Additional Mail Accounts 209

Troubleshoot Mail Setup Problems 210

Take a Quick Tour of Outlook’s Mail Feature 214

Choose a Ribbon Layout 216

Receive and Read Your Mail 216

View and Download Photos and Other Attachments 218

Reply to a Message 219

Forward a Message 221

Compose a Message 221

Attach a File to a Message 224

Avoid Frauds, Scams, and Viruses 226

CHAPTER 12: MANAGING THE DETAILS: CONTACTS, NOTES, AND TASKS 229

Store Contact Information 230

Edit and Delete Contacts 233

Choose How the Contacts List Appears 235

Use the Contacts List 235

Create Notes 238

Categorize Notes 240

Use Tasks and the To-Do List 243

Update the Status of a Task 246

Set a Task Reminder 247

CHAPTER 13: YOUR BUSY LIFE: USING THE CALENDAR 249

View Your Calendar 250

Create and Delete a Calendar Event 252

Set an Event to Recur 254

Configure Event Reminders 255

Add Holidays 257

Print a Hard Copy of Your Calendar 258

PART 5: POWERPOINT 261

CHAPTER 14: GETTING STARTED WITH POWERPOINT 263

Explore the PowerPoint Interface 264

Work with PowerPoint Files 266

Understand PowerPoint Views 266

Create New Slides 268

Use Slide Placeholders 270

Turn Text AutoFit Off or On 271

Change Slide Layouts 273

Move or Resize Slide Content 274

Manually Place Text on a Slide 275

Navigate and Select Text 276

Select Content 277

CHAPTER 15: DRESSING UP YOUR PRESENTATIONS 279

Understand and Apply Themes and Variants 280

Change the Presentation Colors 281

Edit Slide Masters 283

Format Text Boxes and Placeholders 284

Insert Pictures 286

Create a Photo Album Presentation 290

CHAPTER 16: ADDING MOVEMENT AND SOUND 293

Animate Objects on a Slide 294

Add Slide Transition Effects 301

Set Slides to Automatically Advance 302

Add a Musical Soundtrack 303

CHAPTER 17: PRESENTING THE SHOW 305

Display a Slide Show On-Screen 306

Use the Slide Show Tools 308

Print Copies of a Presentation 311

Package a Presentation for Distribution 313

Make a Video of the Presentation 316

PART 6: GOING DEEPER WITH OFFICE 319

CHAPTER 18: INTEGRATING OFFICE WITH OTHER APPS 321

Use Microsoft Money in Excel to Track Bank Accounts 322

Subscribe to a Google Calendar in Outlook 324

Import a Google Calendar Into Outlook 327

Access Gmail Contacts in Outlook 329

Integrating Office with iCloud 332

Share Content Between Google Apps and Office Apps 337

Include Online Videos in PowerPoint Presentations 339

CHAPTER 19: CUSTOMIZING OFFICE APPLICATIONS 341

Customize the Quick Access Toolbar 342

Customize the Ribbon 346

Customize the Status Bar 349

Set Options in Word, Excel, and PowerPoint 351

Set Outlook Options 352

CHAPTER 20: TROUBLESHOOTING COMMON PROBLEMS 355

Recover Lost Work 356

Repair a Malfunctioning App 357

Fix Inconsistent Formatting in Word 360

Improve an Ugly Presentation in PowerPoint 363

Fix Formula Errors in Excel 364

Pick the Right Function in Excel 365

Minimize Document File Size 367

Move Outlook Data Files to Another PC 368

Index 373