You are previewing Microsoft® Office Excel® 2007 Step by Step.
O'Reilly logo
Microsoft® Office Excel® 2007 Step by Step

Book Description

Experience learning made easy—and quickly teach yourself how to organize, analyze, and present data with Excel 2007. With Step By Step, you set the pace—building and practicing the skills you need, just when you need them!

  • Create formulas, calculate values, and analyze data

  • Present information visually with graphics, charts, and diagrams

  • Build PivotTable dynamic views—even easier with new data tables

  • Reuse information from databases and other documents

  • Share spreadsheets for review and manage changes

  • Create macros to automate repetitive tasks and simplify your work



  • Your all-in-one learning experience includes:

  • Files for building skills and practicing the book’s lessons

  • Fully searchable eBook

  • Bonus quick reference to the Ribbon, the new Microsoft Office interface

  • Windows Vista Product Guide eReference—plus other resources on CD

  • For customers who purchase an ebook version of this title, instructions for downloading the CD files can be found in the ebook.

    Table of Contents

    1. Microsoft® Office Excel® 2007 Step by Step
    2. SPECIAL OFFER: Upgrade this ebook with O’Reilly
    3. A Note Regarding Supplemental Files
    4. About the Author
      1. Curtis Frye
    5. Acknowledgments
    6. Features and Conventions
    7. Using the Book’s CD
      1. What’s on the CD?
      2. Minimum System Requirements
      3. Installing the Practice Files
      4. Using the Practice Files
      5. Uninstalling the Practice Files
    8. Getting Help
      1. Getting Help with This Book and Its Companion CD
      2. Getting Help with Office Excel 2007
    9. The Microsoft Business Certification Program
      1. Selecting a Certification Path
      2. Becoming a Microsoft Certified Application Specialist—Microsoft 2007 Office System
      3. Becoming a Microsoft Certified Application Professional
      4. Taking a Microsoft Business Certification Exam
        1. Test Taking Tips
        2. Certification
        3. For More Information
    10. Quick Reference
      1. 2. Setting Up a Workbook
      2. 3. Working with Data and Data Tables
      3. 4. Performing Calculations on Data
      4. 5. Changing Document Appearance
      5. 6. Focusing on Specific Data Using Filters
      6. 7. Reordering and Summarizing Data
      7. 8. Combining Data from Multiple Sources
      8. 9. Analyzing Alternative Data Sets
      9. 10. Creating Dynamic Lists with PivotTables
      10. 11. Creating Charts and Graphics
      11. 12. Printing
      12. 13. Automating Repetitive Tasks with Macros
      13. 14. Working with Other Microsoft Office System Programs
      14. 15. Collaborating with Colleagues
    11. 1. What’s New in Excel 2007?
      1. Becoming Familiar with the New User Interface
      2. Managing Larger Data Collections
      3. Using the New Microsoft Office File Format
      4. Formatting Cells and Worksheets
      5. Managing Data Tables More Effectively
      6. Creating Formulas More Easily by Using Formula AutoComplete
      7. Summarizing Data Using New Functions
      8. Creating Powerful Conditional Formats
      9. Creating More Attractive Charts
      10. Controlling Printouts More Carefully
      11. Key Points
    12. 2. Setting Up a Workbook
      1. Creating Workbooks
      2. Modifying Workbooks
      3. Modifying Worksheets
      4. Customizing the Excel 2007 Program Window
        1. Zooming In on a Worksheet
        2. Arranging Multiple Workbook Windows
        3. Adding Buttons to the Quick Access Toolbar
      5. Key Points
    13. 3. Working with Data and Data Tables
      1. Entering and Revising Data
      2. Moving Data Within a Workbook
      3. Finding and Replacing Data
      4. Correcting and Expanding Upon Worksheet Data
      5. Defining a Table
      6. Key Points
    14. 4. Performing Calculations on Data
      1. Naming Groups of Data
      2. Creating Formulas to Calculate Values
      3. Summarizing Data That Meets Specific Conditions
      4. Finding and Correcting Errors in Calculations
      5. Key Points
    15. 5. Changing Document Appearance
      1. Formatting Cells
      2. Defining Styles
      3. Applying Workbook Themes and Table Styles
      4. Making Numbers Easier to Read
      5. Changing the Appearance of Data Based on Its Value
      6. Adding Images to a Document
      7. Key Points
    16. 6. Focusing on Specific Data Using Filters
      1. Limiting Data That Appears on Your Screen
      2. Manipulating List Data
      3. Defining Valid Sets of Values for Ranges of Cells
      4. Key Points
    17. 7. Reordering and Summarizing Data
      1. Sorting Data Lists
      2. Organizing Data into Levels
      3. Looking Up Information in a Data List
      4. Key Points
    18. 8. Combining Data from Multiple Sources
      1. Using Data Lists as Templates for Other Lists
      2. Linking to Data in Other Worksheets and Workbooks
      3. Consolidating Multiple Sets of Data into a Single Workbook
      4. Grouping Multiple Sets of Data
      5. Key Points
    19. 9. Analyzing Alternative Data Sets
      1. Defining and Editing Alternative Data Sets
      2. Defining Multiple Alternative Data Sets
      3. Varying Your Data to Get a Desired Result Using Goal Seek
      4. Finding Optimal Solutions with Solver
      5. Analyzing Data with Descriptive Statistics
      6. Key Points
    20. 10. Creating Dynamic Lists with PivotTables
      1. Analyzing Data Dynamically with PivotTables
      2. Filtering, Showing, and Hiding PivotTable Data
      3. Editing PivotTables
      4. Formatting PivotTables
      5. Creating PivotTables from External Data
      6. Key Points
    21. 11. Creating Charts and Graphics
      1. Creating Charts
      2. Customizing the Appearance of Charts
      3. Finding Trends in Your Data
      4. Creating Dynamic Charts Using PivotCharts
      5. Creating Diagrams by Using SmartArt
      6. Key Points
    22. 12. Printing
      1. Adding Headers and Footers to Printed Pages
      2. Preparing Worksheets for Printing
        1. Previewing Worksheets Before Printing
        2. Changing Page Breaks in a Worksheet
        3. Changing the Page Printing Order for Worksheets
      3. Printing Data Lists
      4. Printing Parts of Data Lists
      5. Printing Charts
      6. Key Points
    23. 13. Automating Repetitive Tasks with Macros
      1. Introducing Macros
        1. Macro Security in Excel 2007
        2. Examining Macros
      2. Creating and Modifying Macros
      3. Running Macros When a Button Is Clicked
      4. Running Macros When a Workbook Is Opened
      5. Key Points
    24. 14. Working with Other Microsoft Office System Programs
      1. Including Microsoft Office System Documents in Excel 2007 Worksheets
      2. Storing Excel 2007 Documents as Parts of Other Microsoft Office System Documents
      3. Creating Hyperlinks
      4. Pasting Charts into Other Documents
      5. Key Points
    25. 15. Collaborating with Colleagues
      1. Sharing Data Lists
      2. Managing Comments
      3. Tracking and Managing Colleagues’ Changes
      4. Protecting Workbooks and Worksheets
      5. Authenticating Workbooks
      6. Saving Workbooks for the Web
      7. Key Points
    26. Glossary
    27. Choose the Right Book for You
      1. Published and Upcoming Titles
        1. Plain & Simple
        2. Step by Step
        3. Inside Out
        4. Other Titles
    28. Index
    29. About the Author
    30. SPECIAL OFFER: Upgrade this ebook with O’Reilly