Teach Yourself VISUALLY Excel 2016

Chapter 1 Working with Ranges Select a Range 4 Fill a Range with the Same Data 6 Fill a Range with a Series of Values 8 Flash Fill a Range 10 Move or Copy a Range 12 Insert a Row or Column 14 Insert a Cell or Range 16 Delete Data from a Range 18 Delete a Range 20 Hide a Row or Column 22 Freeze Rows or Columns 24 Merge Two or More Cells 26 Transpose Rows and Columns 28 Select and Enter Data Using Touch Gestures 30 Chapter 2 Working with Range Names Understanding the Benefits of Using Range Names 34 Define a Range Name 36 Using Worksheet Text to Define a Range Name 38 Navigate a Workbook Using Range Names 40 Change a Range Name 42 Delete a Range Name 44 Paste a List of Range Names 46 Chapter 3 Formatting Excel Ranges Change the Font and Font Size 50 Apply Font Effects 52 Change the Font Color 54 Align Text Within a Cell 56 Center Text Across Multiple Columns 58 Rotate Text Within a Cell 60 Add a Background Color to a Range 62 Apply a Number Format 64 Change the Number of Decimal Places Displayed 66 Apply an AutoFormat to a Range 68 Apply a Conditional Format to a Range 70 Apply a Style to a Range 72 Change the Column Width 74 Change the Row Height 76 Wrap Text Within a Cell 78 Add Borders to a Range 80 Copy Formatting from One Cell to Another 82 Chapter 4 Building Formulas Understanding Excel Formulas 86 Build a Formula 88 Understanding Excel Functions 90 Add a Function to a Formula 92 Add a Row or Column of Numbers 94 Build an AutoSum Formula 96 Add a Range Name to a Formula 98 Reference Another Worksheet Range in a Formula 100 Move or Copy a Formula 102 Switch to Absolute Cell References 104 Hide the Formula Bar or Ribbon 106 Troubleshoot Formula Errors 108 Chapter 5 Manipulating Worksheets Navigate a Worksheet 112 Rename a Worksheet 113 Create a New Worksheet 114 Move a Worksheet 116 Copy a Worksheet 118 Delete a Worksheet 120 Change the Gridline Color 122 Toggle Worksheet Gridlines On and Off 124 Toggle Worksheet Headings On and Off 125 Set the Worksheet Tab Color 126 Set the Worksheet Background 128 Zoom In on or Out of a Worksheet 130 Split a Worksheet into Two Panes 132 Hide and Unhide a Worksheet 134 Chapter 6 Dealing with Workbooks Create a New Blank Workbook 138 Create a New Workbook from a Template 140 Save a Workbook 142 Open a Workbook 143 Arrange Workbook Windows 144 Find Text in a Workbook 146 Replace Text in a Workbook 148 Check Spelling and Grammar 150 Chapter 7 Formatting Workbooks Modify the Workbook Colors 154 Set the Workbook Fonts 156 Choose Workbook Effects 158 Apply a Workbook Theme 160 Add a Workbook Header 162 Add a Workbook Footer 164 Chapter 8 Importing Data into Excel Understanding External Data 168 Import Data from a Data Source 170 Import Data from an Access Table 172 Import Data from a Word Table 174 Import Data from a Text File 176 Import Data from a Web Page 180 Import Data from an XML File 182 Refresh Imported Data 184 Separate Cell Text into Columns 186 Chapter 9 Printing Workbooks Adjust the Workbook Margins 190 Change the Page Orientation 192 Insert a Page Break 193 Choose a Paper Size 194 Set the Print Area 196 Configure Titles to Print on Each Page 198 Preview the Printout 200 Print a Workbook 202 Chapter 10 Working with Tables Understanding Tables 206 Get to Know Table Features 207 Convert a Range to a Table 208 Select Table Data 210 Insert a Table Row 212 Insert a Table Column 213 Delete a Table Row 214 Delete a Table Column 215 Add a Column Subtotal 216 Convert a Table to a Range 218 Apply a Table Style 219 Build a Custom Table Style 220 Create a PivotTable 222 Chapter 11 Analyzing Data Sort a Range or Table 226 Filter a Range or Table 228 Set Data Validation Rules 230 Create a Data Table 232 Summarize Data with Subtotals 234 Group Related Data 236 Analyze Data with Goal Seek 238 Analyze Data with Scenarios 240 Remove Duplicate Values from a Range or Table 244 Highlight Cells That Meet Some Criteria 246 Highlight the Top or Bottom Values in a Range 248 Analyze Cell Values with Data Bars 250 Analyze Cell Values with Color Scales 252 Analyze Cell Values with Icon Sets 254 Create a Custom Conditional Formatting Rule 256 Consolidate Data from Multiple Worksheets 258 Load the Excel Analysis ToolPak 262 Chapter 12 Visualizing Data with Charts Examine Chart Elements 266 Understanding Chart Types 267 Create a Chart 268 Create a Recommended Chart 270 Add Chart Titles 272 Add Data Labels 273 Position the Chart Legend 274 Display Chart Gridlines 275 Display a Data Table 276 Change the Chart Layout and Style 277 Select a Different Chart Type 278 Change the Chart Source Data 280 Move or Resize a Chart 282 Add a Sparkline to a Cell 284 Chapter 13 Adding Worksheet Graphics Draw a Shape 288 Insert a Clip Art Image 290 Insert a Photo 292 Insert a WordArt Image 294 Insert a SmartArt Graphic 296 Move or Resize a Graphic 298 Crop a Picture 300 Format a Picture 302 Chapter 14 Collaborating with Others Add a Comment to a Cell 306 Protect a Worksheet's Data 308 Protect a Workbook's Structure 310 Share a Workbook with Other Users 312 Track Workbook Changes 314 Accept or Reject Workbook Changes 316 Save a Workbook to Your OneDrive 318 Send a Workbook as an E-Mail Attachment 320 Save Excel Data as a Web Page 322 Make a Workbook Compatible with Earlier Versions of Excel 324 Mark Up a Worksheet with a Digital Pen 326 Collaborate on a Workbook Online 328 Index