You are previewing Teach Yourself VISUALLY Excel 2016.
O'Reilly logo
Teach Yourself VISUALLY Excel 2016

Book Description

See your way to Excel spreadsheet stardom with this visual guide

If you're always hearing about the cool things Excel can do, here's your chance to see how to do them!Teach Yourself Visually Excel offers you a straightforward visual approach to working with the newest version of the world's leading spreadsheet program. Packed with visually rich tutorials and step-by-step instructions that will help you take your Excel skills to new heights, this friendly and approachable guide will have you creating, editing, and manipulating Excel spreadsheets in no time!

Excel can seem daunting, but with Teach Yourself Visually Excel, you'll quickly and painlessly learn how to perform dozens of tasks, including creating spreadsheets and charts, filtering and sorting data, working with PivotTables, and so much more. Covering the latest additions and changes to the newest version of Excel, a series of easy-to-follow, full-color tutorials helps you to excel at working with Excel!

  • Tutorials and step-by-step screenshots make lessons easy to follow and understand

  • Helps you grasp the basic functions of Excel—and beyond

  • Walks you through Excel s new features

  • Clearly demonstrates how to organize, present, analyze, and chart data with Excel

  • Whether you've never used Excel or just need to brush up on its new features, Teach Yourself Visually Excel will be the dog-eared resource you'll turn to again and again.

    Table of Contents

      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