Teach Yourself VISUALLY Excel 2016

Paul McFedries (Toronto, Ontario) is the president of Logophilia Limited, a technical writing company. He has been programming since he was a teenager in the mid-1970s, has programmed everything from mainframes to desktops to bar code scanners, and has worked with many different languages, including Fortran, assembly language, C++, and, of course, JavaScript. Paul has written more than four dozen books that have sold more than two million copies worldwide. These books include Windows 8.1 Simplified, Teach Yourself VISUALLY Windows 8.1, Excel Data Analysis Visual Blueprint, and previous editions of Teach Yourself VISUALLY Excel. Paul encourages all readers to drop by his Web site, mcfedries.com.

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