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