Office 2019 For Seniors For Dummies

Faithe Wempen, M.A., is a Microsoft Office Master Instructor and the author of over 150 books on computer technology, including Outlook 2019 for Dummies and PowerPoint Bible. She is also a CompTIA A+ certified PC technician and an adjunct Computer Technology instructor at Purdue University. Her online courses in Office applications and digital literacy have educated over a quarter of a million students for corporate clients.

• Introduction 1About This Book 1Foolish Assumptions 3Icons Used in This Book 3Beyond the Book 4Where to Go from Here 4Part 1: Getting Started with Office 2019 5Chapter 1: The Two-Dollar Tour 7Start an Office Application 8Start a New Document 9Explore the Office Ribbon and Tabs 10Understand the File Menu (Backstage View) 14Create a Document 15Type Text 16Insert a Picture 18Move Around in a Document 19Select Content 21Zoom In and Out 23Change the View 24Chapter 2: Exploring the Common Features of Office Applications 27Edit Text 28Move and Copy Content 29Choose Fonts and Font Sizes 33Apply Text Formatting 35Use the Mini Toolbar 37Work with Themes 38Check Your Spelling and Grammar 42Chapter 3: Opening, Saving, and Printing Files 47Save Your Work 48The Basic Save 48Changing the Save Location 50Choosing a File Type 54Open a Previously Saved File 55Change the File Listing View 56Email Your Work to Others 57Emailing a Link to a Document 58Emailing a Copy of a Document 59Share Your Work in Other Formats 61Print Your Work 64Recover Lost Work 66Part 2: Word 69Chapter 4: Composing Your Thoughts in Word 71Examine the Word Interface 72Move Around and Select Text 73Choose Paper Size and Orientation 74Set Margins 76Select the Right Screen View 78Align and Indent Paragraphs 80Change Line Spacing 86Create Bulleted and Numbered Lists 88Chapter 5: Dressing Up Your Documents 91Apply Styles and Style Sets 92Insert Photos 97Size and Format a Picture 100Position a Picture 101Add a Page Border 102Apply a Background Color to a Page 104Create Tables 106Format a Table 109Chapter 6: Taking Word to the Next Level 111Number the Pages 112Use Headers and Footers 114Insert Cover Pages and Other Building Blocks 117Print an Envelope 119Perform a Mail Merge 121Insert the Date and Time 127Part 3: Excel 129Chapter 7: Creating Basic Spreadsheets in Excel 131Understand Excel’s Unique Features 132Get Familiar with Spreadsheet Structure 134Move the Cell Cursor 134Select a Range 135Type and Edit Cell Contents 139Insert and Delete Rows, Columns, and Cells 141Work with Worksheets 145Chapter 8: Doing the Math: Formulas and Functions 149Learn How Formulas Are Structured 150Write Formulas That Reference Cells 150Move and Copy Cell Content 152Reference a Cell on Another Sheet 154Understand Functions 154Take a Tour of Some Basic Functions 157Explore Financial Functions 159Chapter 9: Creating Visual Interest with Formatting and Charts 163Adjust Row Height and Column Width 164Wrap Text in a Cell 165Apply Gridlines or Borders 166Apply Fill Color 169Format Text in Cells 171Format the Spreadsheet as a Whole 173Create a Basic Chart 174Identify the Parts of a Chart 177Format a Chart 178Chapter 10: Using Excel as a Database 183Understand Databases 184Prepare a List for a Mail Merge 184Store Data in a Table 185Sort a Table 187Filter Data in a Table 189Split a Column’s Content 192Merge the Contents of Columns 195Part 4: Outlook 197Chapter 11: Managing Email with Outlook 199Set Up Outlook for the First Time 200Set Up Additional Mail Accounts 201Troubleshoot Mail Setup Problems 202Take a Quick Tour of Outlook’s Mail Feature 206Receive and Read Your Mail 207View Photos and Other Attachments 209Reply to a Message 210Forward a Message 211Compose a Message 212Attach a File to a Message 214Avoid Frauds, Scams, and Viruses 215Chapter 12: Managing the Details: Contacts, Notes, and Tasks 219Store Contact Information 220Edit and Delete Contacts 223Choose How the Contact List Appears 224Use the Contacts List 225Create Notes 227Categorize Notes 230Use Tasks and the To-Do List 232Update the Status of a Task 235Set a Task Reminder 236Chapter 13: Your Busy Life: Using the Calendar 239View Your Calendar 239Create and Delete a Calendar Event 242Set an Event to Recur 243Configure Event Reminders 245Add Holidays 246Print a Hard Copy of Your Calendar 247Part 5: Powerpoint 251Chapter 14: Getting Started with PowerPoint 253Explore the PowerPoint Interface 254Work with PowerPoint Files 255Understand PowerPoint Views 256Create New Slides 258Use Slide Placeholders 259Turn Text AutoFit Off or On 261Change Slide Layouts 263Move or Resize Slide Content 263Manually Place Text on a Slide 264Navigate and Select Text 265Select Content 267Chapter 15: Dressing Up Your Presentations 269Understand and Apply Themes and Variants 270Change the Presentation Colors 271Edit Slide Masters 272Format Text Boxes and Placeholders 274Insert Pictures 275Create a Photo Album Presentation 279Chapter 16: Adding Movement and Sound 283Animate Objects on a Slide 284Add Slide Transition Effects 289Set Slides to Automatically Advance 291Add a Soundtrack 292Chapter 17: Presenting the Show 293Display a Slide Show Onscreen 294Use the Slide Show Tools 296Print Copies of a Presentation 299Package a Presentation for Distribution 301Make a Video of the Presentation 304Appendix: Customizing Office Applications 307Index 315