Teach Yourself VISUALLY Excel 2016

Table of contents

1. 1. Cover
   2. Chapter 1: Working with Ranges
      1. Select a Range
      2. Fill a Range with the Same Data
      3. Fill a Range with a Series of Values
      4. Flash Fill a Range
      5. Move or Copy a Range
      6. Insert a Row or Column
      7. Insert a Cell or Range
      8. Delete Data from a Range
      9. Delete a Range
      10. Hide a Row or Column
      11. Freeze Rows or Columns
      12. Merge Two or More Cells
      13. Transpose Rows and Columns
      14. Select and Enter Data Using Touch Gestures
   3. Chapter 2: Working with Range Names
      1. Understanding the Benefits of Using Range Names
      2. Define a Range Name
      3. Using Worksheet Text to Define a Range Name
      4. Navigate a Workbook Using Range Names
      5. Change a Range Name
      6. Delete a Range Name
      7. Paste a List of Range Names
   4. Chapter 3: Formatting Excel Ranges
      1. Change the Font and Font Size
      2. Apply Font Effects
      3. Change the Font Color
      4. Align Text Within a Cell
      5. Center Text Across Multiple Columns
      6. Rotate Text Within a Cell
      7. Add a Background Color to a Range
      8. Apply a Number Format
      9. Change the Number of Decimal Places Displayed
      10. Apply an AutoFormat to a Range
      11. Apply a Conditional Format to a Range
      12. Apply a Style to a Range
      13. Change the Column Width
      14. Change the Row Height
      15. Wrap Text Within a Cell
      16. Add Borders to a Range
      17. Copy Formatting from One Cell to Another
   5. Chapter 4: Building Formulas
      1. Understanding Excel Formulas
      2. Build a Formula
      3. Understanding Excel Functions
      4. Add a Function to a Formula
      5. Add a Row or Column of Numbers
      6. Build an AutoSum Formula
      7. Add a Range Name to a Formula
      8. Reference Another Worksheet Range in a Formula
      9. Move or Copy a Formula
      10. Switch to Absolute Cell References
      11. Hide the Formula Bar or Ribbon
      12. Troubleshoot Formula Errors
   6. Chapter 5: Manipulating Worksheets
      1. Navigate a Worksheet
      2. Rename a Worksheet
      3. Create a New Worksheet
      4. Move a Worksheet
      5. Copy a Worksheet
      6. Delete a Worksheet
      7. Change the Gridline Color
      8. Toggle Worksheet Gridlines On and Off
      9. Toggle Worksheet Headings On and Off
      10. Set the Worksheet Tab Color
      11. Set the Worksheet Background
      12. Zoom In on or Out of a Worksheet
      13. Split a Worksheet into Two Panes
      14. Hide and Unhide a Worksheet
   7. Chapter 6: Dealing with Workbooks
      1. Create a New Blank Workbook
      2. Create a New Workbook from a Template
      3. Save a Workbook
      4. Open a Workbook
      5. Arrange Workbook Windows
      6. Find Text in a Workbook
      7. Replace Text in a Workbook
      8. Check Spelling and Grammar
   8. Chapter 7: Formatting Workbooks
      1. Modify the Workbook Colors
      2. Set the Workbook Fonts
      3. Choose Workbook Effects
      4. Apply a Workbook Theme
      5. Add a Workbook Header
      6. Add a Workbook Footer
   9. Chapter 8: Importing Data into Excel
      1. Understanding External Data
      2. Import Data from a Data Source
      3. Import Data from an Access Table
      4. Import Data from a Word Table
      5. Import Data from a Text File
      6. Import Data from a Web Page
      7. Import Data from an XML File
      8. Refresh Imported Data
      9. Separate Cell Text into Columns
   10. Chapter 9: Printing Workbooks
       1. Adjust the Workbook Margins
       2. Change the Page Orientation
       3. Insert a Page Break
       4. Choose a Paper Size
       5. Set the Print Area
       6. Configure Titles to Print on Each Page
       7. Preview the Printout
       8. Print a Workbook
   11. Chapter 10: Working with Tables
       1. Understanding Tables
       2. Get to Know Table Features
       3. Convert a Range to a Table
       4. Select Table Data
       5. Insert a Table Row
       6. Insert a Table Column
       7. Delete a Table Row
       8. Delete a Table Column
       9. Add a Column Subtotal
       10. Convert a Table to a Range
       11. Apply a Table Style
       12. Build a Custom Table Style
       13. Create a PivotTable
   12. Chapter 11: Analyzing Data
       1. Sort a Range or Table
       2. Filter a Range or Table
       3. Set Data Validation Rules
       4. Create a Data Table
       5. Summarize Data with Subtotals
       6. Group Related Data
       7. Analyze Data with Goal Seek
       8. Analyze Data with Scenarios
       9. Remove Duplicate Values from a Range or Table
       10. Highlight Cells That Meet Some Criteria
       11. Highlight the Top or Bottom Values in a Range
       12. Analyze Cell Values with Data Bars
       13. Analyze Cell Values with Color Scales
       14. Analyze Cell Values with Icon Sets
       15. Create a Custom Conditional Formatting Rule
       16. Consolidate Data from Multiple Worksheets
       17. Load the Excel Analysis ToolPak
   13. Chapter 12: Visualizing Data with Charts
       1. Examine Chart Elements
       2. Understanding Chart Types
       3. Create a Chart
       4. Create a Recommended Chart
       5. Add Chart Titles
       6. Add Data Labels
       7. Position the Chart Legend
       8. Display Chart Gridlines
       9. Display a Data Table
       10. Change the Chart Layout and Style
       11. Select a Different Chart Type
       12. Change the Chart Source Data
       13. Move or Resize a Chart
       14. Add a Sparkline to a Cell
   14. Chapter 13: Adding Worksheet Graphics
       1. Draw a Shape
       2. Insert a Clip Art Image
       3. Insert a Photo
       4. Insert a WordArt Image
       5. Insert a SmartArt Graphic
       6. Move or Resize a Graphic
       7. Crop a Picture
       8. Format a Picture
   15. Chapter 14: Collaborating with Others
       1. Add a Comment to a Cell
       2. Protect a Worksheet’s Data
       3. Protect a Workbook’s Structure
       4. Share a Workbook with Other Users
       5. Track Workbook Changes
       6. Accept or Reject Workbook Changes
       7. Save a Workbook to Your OneDrive
       8. Send a Workbook as an E-Mail Attachment
       9. Save Excel Data as a Web Page
       10. Make a Workbook Compatible with Earlier Versions of Excel
       11. Mark Up a Worksheet with a Digital Pen
       12. Collaborate on a Workbook Online
   16. End User License Agreement