Buying Options
Excel 2007 Pocket Guide, Second Edition
Print $9.99
Add to Cart
Print+Ebook $10.99
Add to Cart
Ebook $7.99
Add to Cart
Safari Books Online
Add to Cart
What is this?
Print £7.50
Add to Cart
What is this?

Product Editions

  1. Excel 2007 Pocket Guide, Second Edition - October 2007
  2. Excel Pocket Guide - September 2003
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 is 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.
Full Description
Table of Contents
  1. Chapter 1 Understanding Excel

    1. What's New in Excel 2007

    2. The Excel 2007 Interface

    3. The Anatomy of an Excel File

    4. Formatting

    5. Shortcut Menus and the Mini Toolbar

    6. How Excel Tries to Help

  2. Chapter 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

    7. Formatting

    8. Working with Hyperlinks

    9. Working with Headers and Footers

    10. Summarizing Data

    11. Using Named Ranges

    12. Defining Alternative Data Sets

    13. Controlling How Data Is Displayed

    14. Protecting All or Part of a Workbook

    15. Spelling and Other Tools

    16. Customizing Excel

    17. Collaborating

    18. Working with the Web

    19. Summarizing Data with Charts

    20. Analyzing Data with PivotTables and PivotCharts

  3. Chapter 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

  4. Chapter 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

  5. Chapter 5 Excel Resources

    1. Internet Sites

    2. Books

    3. Excel Utilities

    View Full Table of Contents
    Product Details
    Title:
    Excel 2007 Pocket Guide, Second Edition
    By:
    Curt Frye
    Publisher:
    O'Reilly Media
    Formats:
    • Print
    • Ebook
    • Safari Books Online
    Print Release:
    October 2007
    Ebook Release:
    February 2009
    Pages:
    172
    Print ISBN:
    978-0-596-51452-5
    | ISBN 10:
    0-596-51452-2
    Ebook ISBN:
    978-0-596-10294-4
    | ISBN 10:
    0-596-10294-1
    Customer Reviews
    About the Author
    1. Curt Frye

      Curt is the author of numerous books on Excel and other Office products, most recently the "Excel 2007 Pocket Guide". He graduated from Syracuse in 1990 with a degree in political science, and then moved to Washington, DC, where he worked as a defense trade analyst for four years and as the director of sales and marketing for an ISP for one year. He moved to Portland, Oregon, in 1995 to launch his freelance writing career. When Curt's not writing, and often while he is writing, he is a keynote speaker, mentalist, and professional improvisational comedian.

      View Curt Frye's full profile page.

    • Book cover of Excel 2007 Pocket Guide