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 g.