You are previewing Picture Yourself Learning Microsoft® Excel® 2010.
O'Reilly logo
Picture Yourself Learning Microsoft® Excel® 2010

Book Description

This book is a guide to the features of Microsoft Excel, one of the key products of the Microsoft Office suite. Step-by-step instructions and visual aides help the reader easily learn the software. PICTURE YOURSELF LEARNING MICROSOFT EXCEL 2010 teaches the latest version of Microsoft Excel by following along in a four-color, highly visual format. Readers will develop the skills needed to complete a multitude of tasks, such as working with formulas, filtering and sorting data, working with charts, and much more.

Table of Contents

  1. Copyright
  2. About the Authors
  3. About the Authors
  4. Introduction
  5. Just the Basics
    1. Creating a Basic Excel Worksheet
      1. Exploring Excel
      2. Moving Around the Excel Screen
      3. Entering Excel Data
      4. Selecting Cells on a Spreadsheet
      5. Editing a Worksheet
      6. Moving and Copying Data
      7. Working with Range Names
    2. Working with Formulas
      1. Creating Formulas
      2. Editing Formulas
      3. Controlling Recalculation
      4. Copying Formulas
      5. Creating an Absolute or Mixed Formula Reference
    3. Using Excel Functions
      1. Considering Form versus Function
      2. Understanding Function Syntax
      3. Creating a Total with the SUM Function
      4. Calculating Results Without Entering a Formula
      5. Nesting Functions
      6. Using Other Functions
    4. Troubleshooting Formula Errors
      1. Displaying Formulas in a Worksheet
      2. Understanding How Excel Handles Formula Errors
      3. Telling Excel Which Errors to Flag
      4. Telling Excel to Flag Result Cells with an Error
      5. Checking for Errors Automatically One at a Time
      6. Controlling Whether Errors Print
    5. Making the Worksheet Look Good
      1. Adjusting Columns and Rows
      2. Formatting Cell Content
      3. Applying Numeric Formatting
      4. Applying Conditional Formatting
      5. Applying Office Themes and Layouts
  6. Handling Larger Workbooks
    1. Managing Large Amounts of Excel Data
      1. Working with Multiple Worksheets
      2. Using Find and Replace
      3. Managing Worksheet Views
    2. Sorting Data
      1. Sorting from the Ribbon
      2. Working with the Sort Command
      3. Creating a Subtotal Report
      4. Creating Manual Groups from Sorted Rows
    3. Filtering Data
      1. Creating an AutoFilter
      2. Performing a Secondary Filter Selection
      3. Exploring Special Filters
      4. Creating Custom Filters
      5. Using Formulas with Filtered Data
    4. Preparing to Print
      1. Setting the Print Area
      2. Previewing Your Worksheet
      3. Switching Worksheet Views
      4. Adjusting Page Layout
      5. Adding Headers and Footers
      6. Inserting a Watermark
    5. Printing and Other Output Formats
      1. Printing Your Workbooks
      2. Handling Special Printing Needs
      3. Printing Charts
      4. Printing a Draft
      5. Changing Printers
      6. Printing Without Opening Excel
      7. Choosing an Alternative to Printing
      8. Printing from the Quick Access Toolbar
  7. Working with Graphics
    1. Generating Excel Charts
      1. Creating a Basic Chart
      2. Changing the Chart Options
    2. Inserting Illustrations
      1. Designing with Illustrations
      2. Formatting Illustrations
      3. Working with Shapes
      4. Creating SmartArt
      5. Using Screenshots
      6. Adding WordArt
  8. Using Excel Tools
    1. Setting Security Options
      1. Inspecting for Private Information
      2. Hiding Data
      3. Protecting Data
      4. Marking a Workbook as Final
    2. Collaborating with Others
      1. Considering Your Collaboration Options
      2. Using Comments in Collaboration
      3. Validating Excel Worksheet Content
      4. Importing and Exporting Your Excel Content
    3. Using PivotTables
      1. Creating a PivotTable
      2. Using the PivotTable Tools
      3. Sorting and Filtering PivotTable Data
      4. Formatting Your PivotTable
      5. Creating a PivotChart
  9. Index