Excel 2007: The Missing Manual

Excel 2007: The Missing Manual

by Matthew MacDonald


$35.99 $39.99 Save 10% Current price is $35.99, Original price is $39.99. You Save 10%.
View All Available Formats & Editions
Choose Expedited Shipping at checkout for guaranteed delivery by Thursday, March 28

Product Details

ISBN-13: 9780596527594
Publisher: O'Reilly Media, Incorporated
Publication date: 01/28/2007
Series: Missing Manual Series
Pages: 860
Product dimensions: 9.20(w) x 6.92(h) x 1.41(d)

About the Author

Matthew MacDonald is a science and technology writer with well over a dozen books to his name. Web novices can tiptoe out onto the Internet with him in Creating a Website: The Missing Manual. HTML fans can learn about the cutting edge of web design in HTML5: The Missing Manual. And human beings of all description can discover just how strange they really are in the quirky handbooks Your Brain: The Missing Manual and Your Body: The Missing Manual.

Table of Contents

  • The Missing Credits
  • Introduction
  • Part I: Worksheet Basics
    • Chapter 1: Creating and Navigating Worksheets
    • Chapter 2: Adding Information to Worksheets
    • Chapter 3: Moving Data Around a Worksheet
    • Chapter 4: Managing Worksheets and Workbooks
    • Chapter 5: Formatting Cells
    • Chapter 6: Smart Formatting Tricks
    • Chapter 7: Viewing and Printing Worksheets

  • Part II: Formulas and Functions
    • Chapter 8: Building Basic Formulas
    • Chapter 9: Math and Statistical Functions
    • Chapter 10: Financial Functions
    • Chapter 11: Manipulating Dates, Times, and Text
    • Chapter 12: Lookup, Reference, and Information Functions
    • Chapter 13: Advanced Formula Writing and Troubleshooting

  • Part III: Organizing Worksheets
    • Chapter 14: Tables: List Management Made Easy
    • Chapter 15: Grouping and Outlining Data
    • Chapter 16: Templates

  • Part IV: Charts and Graphics
    • Chapter 17: Creating Basic Charts
    • Chapter 18: Formatting and Perfecting Charts
    • Chapter 19: Inserting Graphics

  • Part V: Advanced Data Analysis
    • Chapter 20: Scenarios and Goal Seeking
    • Chapter 21: Pivot Tables

  • Part VI: Sharing Data with the Rest of the World
    • Chapter 22: Protecting Your Workbooks
    • Chapter 23: Worksheet Collaboration
    • Chapter 24: Querying Databases and XML Files
    • Chapter 25: Exchanging Data with Other Programs
    • Chapter 26: Connecting Worksheets to the Web

  • Part VII: Programming Excel
    • Chapter 27: Automating Tasks with Macros
    • Chapter 28: Programming Spreadsheets with VBA

  • Part VIII: Appendix
    • Appendix A: Customizing the Quick Access Toolbar

  • Colophon

Customer Reviews

Most Helpful Customer Reviews

See All Customer Reviews