Office 2019 For Seniors For Dummies

ISBN-13: 9781119517979 / Angielski / Miękka / 2018 / 352 str.

Faithe Wempen

Opis

Make sense of Office 2019 Just like using a computer for the first time, learning Microsoft Office applications can be confusing and intimidating at any age.

Spis treści

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

O autorze

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.