You are previewing Excel 2007 Pocket Guide, 2nd Edition.
O'Reilly logo
Excel 2007 Pocket Guide, 2nd Edition

Book Description

Moving to Excel 2007 is not a routine upgrade. Microsoft's radical redesign of the application's user interface has led to confusion among many who people who have relied on Excel for years. Our new edition of the Excel 2007 Pocket Guide has been written from the ground up to help newcomers and longtime users alike find their way around without getting lost. With this book in hand, you'll be able to find your favorite Excel tools quickly. It's packed with information to guide beginners through the basics of creating spreadsheets and entering data, while providing advanced users with information on formulas, pivot tables, and more. Inside, you'll find:

  • A visual guide to the new "Ribbon" interface that helps users find familiar tools

  • A section designed to give beginners enough information to dive right in and start creating rich Excel workbooks immediately

  • Quick answers about how to perform specific tasks in Excel, such as working with files, editing data, formatting, summarizing and displaying data

  • Convenient techniques for connecting data across worksheets and projects

  • Help for moving from the basics of spreadsheet construction to more advanced features

This edition also includes an extensive reference on commonly used formulas, which reveal at a glance the many possibilities Excel 2007 provides for easy calculation. Tasks in the book are presented as answers to "How do I..." questions -- such as "How do I change the formatting of part of a cell's contents?" -- followed by concise instructions for performing the task. You'll learn ways to customize Excel to fit your needs, and how to share workbooks and collaborate with others. And much more.

Don't let Excel 2007 baffle you. Pick up this convenient pocket guide and learn to navigate this redesigned application with ease.

Table of Contents

  1. Excel 2007 Pocket Guide, 2nd Edition
  2. 1. Understanding Excel
    1. What's New in Excel 2007
    2. The Excel 2007 Interface
      1. The Ribbon
      2. Contextual Tabs
      3. Dialog Expanders
      4. The Office Button
      5. Quick Access Toolbar
      6. The Excel Program Window
      7. New Excel 2007 File Format
      8. Workbook, Template, and Workspace Files
      9. Tips on Using Templates
    3. The Anatomy of an Excel File
      1. A Workbook
      2. A Worksheet
      3. Sheet Tabs
    4. Formatting
      1. Worksheets
      2. Columns and Rows
      3. Cells
      4. Characters
      5. Styles
    5. Shortcut Menus and the Mini Toolbar
    6. How Excel Tries to Help
      1. AutoCorrect
      2. AutoComplete
      3. Smart Tags
  3. 2. Excel Tasks
    1. Working with Files
    2. Printing
    3. Moving Around in a Workbook or Worksheet
    4. Manipulating Workbooks and Worksheets
    5. Manipulating Rows, Columns, and Cells
    6. Entering and Editing Data
      1. Entering Data Efficiently
      2. Creating, Managing, and Formatting Excel Tables
      3. Entering Data with a Data Entry Form
      4. Using AutoCorrect and AutoComplete
      5. Inserting Text and Other Elements
      6. Selecting Text and Data
      7. Cutting, Copying, and Pasting Data
      8. Clearing Cell Contents and Formulas
    7. Formatting
      1. Formatting Cell Contents
      2. Formatting Numbers and Dates
      3. Formatting Cell Borders and Areas
      4. Formatting a Workbook
    8. Working with Hyperlinks
    9. Working with Headers and Footers
    10. Summarizing Data
      1. Getting a Running Total
      2. Adding Formulas to Cells
      3. Auditing Formulas
    11. Using Named Ranges
    12. Defining Alternative Data Sets
    13. Controlling How Data Is Displayed
      1. Sorting Worksheet Data
      2. Filtering Worksheet Data
      3. Using Subtotals to Summarize Data
      4. Creating Custom Views
    14. Protecting All or Part of a Workbook
    15. Spelling and Other Tools
    16. Customizing Excel
      1. Setting General Customization Options
      2. Customizing the Quick Access Toolbar
    17. Collaborating
      1. Comments
      2. Tracking Changes
      3. Sharing Workbooks
    18. Working with the Web
    19. Summarizing Data with Charts
    20. Analyzing Data with PivotTables and PivotCharts
  4. 3. Formula Reference
    1. New Formulas in Excel 2007
    2. Math Formulas
    3. Date and Time Formulas
    4. Financial Formulas
    5. Lookup and Reference Formulas
    6. Logical Formulas
    7. Text Formulas
    8. Statistical Formulas
  5. 4. Excel Reference
    1. Command Reference
    2. Native Formats
    3. Startup Switches
    4. Wildcards in Filters and Searches
    5. Default File Locations
    6. Keyboard Shortcuts
  6. 5. Excel Resources
    1. Internet Sites
    2. Books
    3. Excel Utilities
  7. Index
  8. About the Author
  9. Copyright