Office 2019 For Dummies

Wallace Wang is the bestselling author of more than 50 computer books, with over three million of his For Dummies books in print. They include numerous versions of Office For Dummies as well as Beginning Programming For Dummies. When not playing with computers, Wallace splits his time between teaching, writing, game designing, screenwriting, and stand-up comedy.

• Introduction 1Who Should Buy This Book 1Icons Used in This Book 3Beyond the Book 4Getting Started 4Part 1: Getting Started with Office 2019 5Chapter 1: Introducing Microsoft Office 2019 7Starting an Office 2019 Program 8Introducing the Microsoft Office Ribbon 9Using the File Tab 11Creating a file 12Opening an existing file 13Saving a file 14Using the Ribbon 17Deciphering Ribbon icons 18Identifying Ribbon icons 20Displaying dialog boxes 21Minimizing the Ribbon 22Using the Quick Access Toolbar 24Using the Quick Access icons 24Adding icons 25Removing icons 26Moving the Quick Access toolbar 27Customizing the Ribbon for Touch 27Customizing an Office 2019 Program 28Changing the file format and default location 28Customizing the Ribbon icons 29Exiting Office 2019 30Chapter 2: Selecting and Editing Data 31Adding Data by Pointing 31Selecting Data 33Selecting data with the mouse 34Selecting data with the keyboard 35Selecting multiple chunks of data with the mouse and keyboard 35Editing Text with the Pop-Up Toolbar 36Deleting Data 36Cutting and Pasting (Moving) Data 37Copying and Pasting Data 38Using Paste Options 38Dragging with the Mouse to Cut, Copy, and Paste 40Undo and Redo 40Sharing Data with Other Office 2019 Programs 41Using the Office Clipboard 41Viewing and pasting items from the Office Clipboard 42Deleting items from the Office Clipboard 43Chapter 3: Modifying Pictures and Drawing on Documents 45Adding and Deleting Pictures 46Getting pictures from the Internet 46Capturing screenshots 48Manipulating Pictures 49Moving a picture 49Resizing a picture 50Rotating a picture 50Enhancing Pictures 51Choosing visual effects 51Choosing a picture style 54Adding a border around a picture 55Drawing with the Draw Tab 57Drawing lines 57Moving lines 58Erasing lines 59Drawing Shapes 59Creating Math Equations 60Chapter 4: Getting Help from Office 2019 63Searching in the Help Window 64Making the Help Window Easier to Read 66Moving the Help window 66Resizing the Help window 67Displaying Help text in a browser window 67Closing the Help window 68Finding the Right Commands to Use 68Part 2: Working with Word 71Chapter 5: Typing Text in Word 73Moving the Cursor with the Mouse 73Moving the Cursor with the Keyboard 75Navigating through a Document 76Navigating with the mouse 76Using the Go To command 77Finding and Replacing Text 78Using the Find command 78Customizing text searching 80Searching by headings 82Browsing through pages 83Using the Find and Replace command 84Checking Your Spelling 85Checking Your Grammar 87Viewing a Document 87Switching between views 88Using Read Mode view 89Using Outline view 89Chapter 6: Formatting Text 95Finding Formatting Tools on the Home Tab 95Changing the Font 96Changing the Font Size 97Changing the Text Style 98Changing Colors 99Changing the color of text 99Highlighting text with color 100Using Text Effects 101Justifying Text Alignment 102Adjusting Line Spacing 103Making Lists 104Indenting list items 105Converting list items back to text 105Customizing a list 105Renumbering numbered lists 106Using the Ruler 107Adjusting left and right paragraph margins 108Defining indentation with the Ruler 109Using Format Painter 110Using Styles 111Using Templates 112Removing Formatting from Text 113Chapter 7: Designing Your Pages 115Inserting New Pages 116Adding (and Deleting) a Cover Page 116Inserting Page Breaks 117Inserting Headers and Footers 118Creating a header or footer 118Defining which pages display a header or footer 119Deleting a header or footer 121Organizing Text in Tables 121Creating a table by highlighting rows and columns 121Creating a table with the Insert Table dialog box 122Creating a table with the mouse 123Creating a table from existing text 124Formatting and Coloring a Table 126Selecting all or part of a table 126Aligning text in a table cell 127Choosing a table style 128Resizing columns and rows 128Sorting a Table 130Deleting Tables 131Deleting an entire table 131Deleting rows and columns 132Deleting cells 132Deleting cell borders 133Making Text Look Artistic 133Creating drop caps 134Creating WordArt 134Dividing Text into Columns 135Editing columns 136Removing columns 137Previewing a Document before Printing 138Defining page size and orientation 138Using Print Preview 139Part 3: Playing the Numbers with Excel 141Chapter 8: The Basics of Spreadsheets: Numbers, Labels, and Formulas 143Understanding Spreadsheets 144Storing Stuff in a Spreadsheet 145Typing data into a single cell 145Typing data in multiple cells 145Typing in sequences with AutoFill 146Formatting Numbers and Labels 147Formatting numbers 147Formatting cells 150Navigating a Spreadsheet 154Using the mouse to move around in a spreadsheet 154Using the keyboard to move around a spreadsheet 155Naming cells 156Searching a Spreadsheet 158Searching for text 158Searching for formulas 160Editing a Spreadsheet 161Editing data in a cell 161Changing the size of rows and columns with the mouse 161Typing the size of rows and columns 162Adding and deleting rows and columns 162Adding sheets 163Renaming sheets 164Rearranging sheets 164Deleting a sheet 164Clearing Data 165Printing Workbooks 166Using Page Layout view 166Adding a header or footer 167Printing gridlines 168Defining a print area 169Inserting and removing page breaks 170Printing row and column headings 171Defining printing margins 172Defining paper orientation and size 173Printing in Excel 174Chapter 9: Playing with Formulas 175Creating a Formula 175Organizing formulas with parentheses 178Copying formulas 179Using Functions 180Using the AutoSum command 182Using recently used functions 183Editing a Formula 184Conditional Formatting 185Comparing data values 185Creating conditional formatting rules 186Data Validation 187Goal Seeking 190Creating Multiple Scenarios 192Creating a scenario 192Viewing a scenario 194Editing a scenario 195Viewing a scenario summary 195Auditing Your Formulas 197Finding where a formula gets its data 197Finding which formula(s) a cell can change 198Checking for Errors 199Chapter 10: Charting and Analyzing Data 201Understanding the Parts of a Chart 201Creating a Chart 203Editing a Chart 205Moving a chart on a worksheet 205Moving a chart to a new sheet 206Resizing a chart 207Using the Chart Tools 207Changing the chart type 207Changing the data source 208Switching rows and columns 209Changing the parts of a chart 210Designing the layout of a chart 211Deleting a chart 212Using Sparklines 212Creating a Sparkline 213Customizing a Sparkline 213Deleting a Sparkline 214Organizing Lists in Pivot Tables 215Creating a pivot table 215Rearranging labels in a pivot table 217Modifying a pivot table 219Filtering a pivot table 220Summing a pivot table 221Slicing up a pivot table 222Creating a pivot chart 224Part 4: Making Presentations with Powerpoint 227Chapter 11: Creating a PowerPoint Presentation 229Defining the Purpose of Your Presentation 229Creating a PowerPoint Presentation 230Designing a presentation in Normal view 231Designing a presentation with Outline view 234Working with Text 237Creating a text box 238Formatting text 239Aligning text 239Adjusting line spacing 240Making numbered and bulleted lists 241Making columns 242Moving and resizing a text box 243Rotating a text box 244Chapter 12: Adding Color and Pictures to a Presentation 245Applying a Theme 246Changing the Background 247Choosing a solid color background 248Choosing a gradient background 249Choosing a picture background 251Choosing a pattern background 252Adding Graphics to a Slide 252Placing picture files on a slide 253Placing clip art on a slide 253Creating WordArt 254Capturing screenshots 255Resizing, moving, and deleting graphic images 256Rotating graphics 257Layering objects 257Adding Movies to a Slide 258Searching for a video on the Internet 258Searching for video on your computer 259Trimming a video 260Coloring a video 261Formatting the shape of a video 262Adding Sound to a Slide 264Adding audio from a file 264Recording audio 265Chapter 13: Showing Off a Presentation 267Spell-Checking Your Presentation 267Organizing Slides in Sections 269Adding a section 269Expanding and collapsing a section 270Deleting a section 271Adding Visual Transitions 272Adding slide transitions 273Text and graphic transitions 275Using Animation Painter 276Adding Hyperlinks 276Creating web page hyperlinks 277Creating hyperlinks to external files 278Running a program through a hyperlink 279Removing a hyperlink or action 279Viewing a Presentation 280Creating a custom slide show 281Hiding a slide 283Organizing with Slide Sorter view 283Creating Handouts 284Part 5: Getting Organized with Outlook 287Chapter 14: Managing Email with Outlook 289Configuring Email Settings 289Adding an email account 290Creating Email 291Creating an email message 291Replying to an email message 292Using a stored email address to create a new email message 293Attaching Files to Messages 295Reading and Organizing Email 297Grouping messages into categories 298Changing the appearance of the Reading Pane 298Retrieving a file attachment from a message 299Deleting Email Messages 301Creating Quick Steps 301Chapter 15: Calendars, Contacts, and Tasks 305Setting Appointments 305Making an appointment 305Viewing appointments 308Deleting an appointment 309Storing Names and Addresses 310Adding a name 310Viewing names 311Searching names 312Managing Tasks 313Storing a task 315Searching tasks 316Viewing tasks 317Part 6: Storing Stuff in Access 319Chapter 16: Using a Database 321Understanding the Basics of a Database 322Designing a Database 323Editing and Modifying a Database 326Naming a field 326Adding and deleting a field 327Defining the type and size of a field 328Typing Data into a Database 329Using Datasheet view 330Using Form view 330Creating a form 331Viewing and editing data in a form 332Editing a form 332Closing and Saving a Database 335Closing a database 335Exiting Access 336Chapter 17: Searching, Sorting, and Querying a Database 337Searching a Database 338Searching for a specific record 338Filtering a database 339Sorting a Database 346Querying a Database 347Creating a simple query 347Creating a crosstab query 349Creating a query that finds duplicate field data 352Creating an unmatched query 354Viewing, renaming, closing, and deleting queries 355Chapter 18: Creating a Database Report 357Using the Report Wizard 357Manipulating the Data in a Report 361Switching a report to Layout view 361Counting records or values 361Sorting a field 363Filtering a field 363Editing a Report 364Resizing fields 365Deleting fields 366Making Reports Look Pretty 366Applying themes 367Creating conditional formatting 367Deleting a Report 369Part 7: The Part of Tens 371Chapter 19: Ten Tips for Using Office 2019 373Saving Office 2019 Files 373Password-Protecting Your Files 375Guarding Against Macro Viruses 377Customizing the Ribbon 378Changing the Size of the Office Window 380Right-Clicking the Mouse 381Freezing Row and Column Headings in Excel 381Displaying Slides Out of Order in PowerPoint 382Reducing Spam in Outlook 382Setting up Outlook’s junk email filter 382Creating a Safe Senders list 384Creating a Blocked Senders list 385Using Office 365 and Office on Android and iOS 385Chapter 20: Ten Ways to Make Office 2019 Easier to Use 387Build (and Use) Your Own Office Add-Ins 387Collaborating with the Review Tab 388Using Word’s References Tab 389Using Excel’s Data Tab 389Saving and Sending Files 390Encrypting a File 390Saving to the Cloud 391Ignoring the Silly Office Ribbon 392Find More Office Templates 392Use Microsoft Office Everywhere 393Index 395