Excel 2007 for Starters: The Missing Manual

Book description

Fast-paced and easy to use, this new book teaches you the basics of Excel 2007 so you can start using the program right away. This concise guide shows readers how to work with Excel's most useful features and its completely redesigned interface. With clear explanations, step-by-step instructions, lots of illustrations, and plenty of timesaving advice, Excel 2007 for Starters: The Missing Manual will quickly teach you to:



  • Build spreadsheets
  • Add and format information
  • Print reports
  • Create charts and graphics
  • Use basic formulas and functions
  • and more




The new Excel is radically different from previous versions. Over the years, Excel has grown in power, sophistication and capability, but its once-simple toolbar has been packed with so many features that not even the pros could find them all. For Excel 2007, Microsoft redesigned the user interface completely, adding a tabbed toolbar that makes every feature easy to locate.

Unfortunately, Microsoft's documentation is as scant as ever, so even if you find the features you need, you still may not know what to do with them. But with this book, you can breeze through the new user interface and its timesaving features in no time. Excel 2007 for Starters: The Missing Manual is the perfect primer for small businesses with no techie to turn to, as well as those who want to organize household and office information.

Publisher resources

View/Submit Errata

Table of contents

  1. Excel 2007 for Starters: The Missing Manual
  2. The Missing Credits
    1. About the Author
    2. About the Creative Team
    3. Acknowledgements
    4. The Missing Manual Series
  3. Introduction
    1. What You Can Do with Excel
    2. Excel’s New Face
      1. The Ribbon
      2. Using the Ribbon with the Keyboard
      3. The Office Menu
      4. The Quick Access Toolbar
    3. Excel’s New Features
    4. About This Book
      1. About the Outline
      2. About → These → Arrows
        1. Contextual tabs
        2. Drop-down buttons
        3. Dialog box launchers
      3. About Shortcut Keys
      4. About Clicking
      5. Examples
      6. About MissingManuals.com
      7. Safari® Enabled
  4. I. WORKSHEET BASICS
    1. 1. Creating and Navigating Worksheets
      1. 1.1. Creating a Basic Worksheet
        1. 1.1.1. Starting a New Workbook
        2. 1.1.2. Adding the Column Titles
        3. 1.1.3. Adding Data
      2. 1.2. Editing Data
      3. 1.3. Navigating in Excel
        1. 1.3.1. The Tabs of the Ribbon
        2. 1.3.2. The Formula Bar
        3. 1.3.3. The Status Bar
        4. 1.3.4. Excel Options
      4. 1.4. Saving Files
        1. 1.4.1. The Excel 2007 File Format
        2. 1.4.2. Saving Your Spreadsheet in Older Formats
        3. 1.4.3. Saving Your Spreadsheet As a PDF
        4. 1.4.4. Disaster Recovery
      5. 1.5. Opening Files
        1. 1.5.1. Opening Multiple Spreadsheets at Once
    2. 2. Adding Information to Worksheets
      1. 2.1. Adding Different Types of Data
        1. 2.1.1. Controlling Your Data Types
          1. 2.1.1.1. How Excel decides your data is text
          2. 2.1.1.2. How Excel decides your data is numeric
          3. 2.1.1.3. How Excel decides your data is a date or time
      2. 2.2. Quick Ways to Add Data
        1. 2.2.1. AutoComplete
        2. 2.2.2. AutoCorrect
        3. 2.2.3. AutoFill
          1. 2.2.3.1. Custom AutoFill lists
        4. 2.2.4. AutoFit
        5. 2.2.5. Undo and Redo
    3. 3. Moving Data Around a Worksheet
      1. 3.1. Selecting Cells
        1. 3.1.1. Making Continuous Range Selections
        2. 3.1.2. Making Non-Contiguous Selections
        3. 3.1.3. Automatically Selecting Your Data
        4. 3.1.4. Making Selections with the Keyboard
      2. 3.2. Moving Cells Around
        1. 3.2.1. A Simple Cut-and-Paste or Copy-and-Paste
        2. 3.2.2. A Fancy Cut-and-Paste or Copy-and-Paste
        3. 3.2.3. The Clipboard
        4. 3.2.4. Special Pasting
      3. 3.3. Adding and Moving Columns or Rows
        1. 3.3.1. Inserting Columns
        2. 3.3.2. Inserting Rows
        3. 3.3.3. Inserting Copied or Cut Cells
        4. 3.3.4. Deleting Columns and Rows
    4. 4. Managing Worksheets and Workbooks
      1. 4.1. Worksheets and Workbooks
        1. 4.1.1. Adding, Removing, and Hiding Worksheets
        2. 4.1.2. Naming and Rearranging Worksheets
      2. 4.2. Find and Replace
        1. 4.2.1. The Basic Find
        2. 4.2.2. Find All
        3. 4.2.3. More Advanced Searches
        4. 4.2.4. Finding Formatted Cells
        5. 4.2.5. Finding and Replacing Values
      3. 4.3. Spell Check
        1. 4.3.1. Spell Checking Options
    5. 5. Formatting Cells
      1. 5.1. Formatting Cell Values
        1. 5.1.1. Formatting Numbers
          1. 5.1.1.1. General
          2. 5.1.1.2. Number
          3. 5.1.1.3. Currency
          4. 5.1.1.4. Accounting
          5. 5.1.1.5. Percentage
          6. 5.1.1.6. Fraction
          7. 5.1.1.7. Scientific
          8. 5.1.1.8. Text
        2. 5.1.2. Formatting Dates and Times
        3. 5.1.3. Special Formats for Special Numbers
      2. 5.2. Formatting Cell Appearance
        1. 5.2.1. Alignment and Orientation
        2. 5.2.2. Fonts and Color
          1. 5.2.2.1. Special characters
        3. 5.2.3. Borders and Fills
        4. 5.2.4. Drawing Borders by Hand
      3. 5.3. Smart Ways to Apply Formatting
        1. 5.3.1. The Format Painter
        2. 5.3.2. Styles and Themes
          1. 5.3.2.1. Themes: A package of styles
    6. 6. Viewing and Printing Worksheets
      1. 6.1. Controlling Your View
        1. 6.1.1. Zooming
        2. 6.1.2. Viewing Distant Parts of a Spreadsheet at Once
        3. 6.1.3. Freezing Columns or Rows
        4. 6.1.4. Hiding Data
        5. 6.1.5. Saving View Settings
      2. 6.2. Printing
        1. 6.2.1. How to Print an Excel File
        2. 6.2.2. Quick Printing
        3. 6.2.3. Previewing Your Printout
        4. 6.2.4. Creating Headers and Footers
        5. 6.2.5. Customizing Print Settings
          1. 6.2.5.1. Margins
          2. 6.2.5.2. Paper size and orientation
          3. 6.2.5.3. Sheet settings
      3. 6.3. Controlling Pagination
        1. 6.3.1. Page Breaks
        2. 6.3.2. Scaling
        3. 6.3.3. Page Break Preview: A Bird’s-Eye View of Your Worksheet
  5. II. WORKSHEET POWER
    1. 7. Building Basic Formulas
      1. 7.1. Creating a Basic Formula
        1. 7.1.1. Excel’s Order of Operations
        2. 7.1.2. Cell References
        3. 7.1.3. How Excel Formats Cells That Contain Cell References
        4. 7.1.4. Functions
          1. 7.1.4.1. Using a function in a formula
          2. 7.1.4.2. Using cell references with a function
          3. 7.1.4.3. Using cell ranges with a function
        5. 7.1.5. Formula Errors
        6. 7.1.6. Logical Operators
      2. 7.2. Formula Shortcuts
        1. 7.2.1. Point-and-Click Formula Creation
        2. 7.2.2. Point-and-Click Formula Editing
        3. 7.2.3. The Formulas Tab
        4. 7.2.4. Using the Insert Function Button to Quickly Find and Insert Functions
      3. 7.3. Copying Formulas
        1. 7.3.1. Absolute Cell References
        2. 7.3.2. Partially Fixed References
    2. 8. Tables: List Management Made Easy
      1. 8.1. The Basics of Tables
        1. 8.1.1. Creating a Table
        2. 8.1.2. Formatting a Table
        3. 8.1.3. Editing a Table
        4. 8.1.4. Selecting Parts of a Table
      2. 8.2. Sorting and Filtering a Table
        1. 8.2.1. Applying a Simple Sort Order
        2. 8.2.2. Sorting with Multiple Criteria
        3. 8.2.3. Filtering with the List of Values
        4. 8.2.4. Creating Smarter Filters
          1. 8.2.4.1. Filtering dates
          2. 8.2.4.2. Filtering numbers
          3. 8.2.4.3. Filtering text
    3. 9. Creating Basic Charts
      1. 9.1. Charting 101
        1. 9.1.1. Embedded and Standalone Charts
        2. 9.1.2. Creating a Chart with the Ribbon
        3. 9.1.3. The Chart Tools Ribbon Tabs
      2. 9.2. Basic Tasks with Charts
        1. 9.2.1. Moving and Resizing a Chart
        2. 9.2.2. Creating a Standalone Chart
        3. 9.2.3. Editing and Adding to Chart Data
        4. 9.2.4. Changing the Chart Type
        5. 9.2.5. Printing Charts
          1. 9.2.5.1. Embedded charts
          2. 9.2.5.2. Standalone charts
      3. 9.3. Practical Charting
        1. 9.3.1. Charts with Multiple Series of Numbers
        2. 9.3.2. Controlling the Data Excel Plots on the X-Axis
        3. 9.3.3. Non-Contiguous Chart Ranges
        4. 9.3.4. Changing the Order of Your Data Series
        5. 9.3.5. Changing the Way Excel Plots Blank Values
      4. 9.4. Chart Types
        1. 9.4.1. Column
        2. 9.4.2. Bar
        3. 9.4.3. Line
        4. 9.4.4. Pie
        5. 9.4.5. Area
  6. A. Customizing The Quick Access Toolbar
    1. A.1. The Quick Access Toolbar
      1. A.1.1. Adding Buttons
      2. A.1.2. Customizing Specific Workbooks
  7. Index
  8. About the Author
  9. Colophon
  10. Copyright

Product information

  • Title: Excel 2007 for Starters: The Missing Manual
  • Author(s): Matthew MacDonald
  • Release date: January 2007
  • Publisher(s): O'Reilly Media, Inc.
  • ISBN: 9781491909423