Excel 2007: The Missing Manual

Description

Microsoft Excel continues to grow in power, sophistication, and capability, but one thing that has changed very little since the early '90s is its user interface. The once-simple toolbar has been packed with so many features over the years that few users know where to find them all. Microsoft has addressed this problem in Excel 2007 by radically redesigning the user interface with a tabbed toolbar that makes every feature easy to locate and use. Unfortunately, Microsoft's documentation is as scant as ever, so even if users can find advanced features, they probably won't know what to do with them.

 Excel 2007: The Missing Manual covers the entire gamut of how to build spreadsheets, add and format information, print reports, create charts and graphics, and use basic formulas and functions. Like its siblings in the Missing Manual series, this book crackles with a fine sense of humor and refreshing objectivity about its subject, guiding readers through the new Excel with clear explanations, step-by-step instructions, lots of illustrations, and friendly, time-saving advice. It's a perfect primer for small businesses with no techie to turn to, as well as those who want to organize household and office information.

CONTENTS:

The Missing CreditsIntroductionPart 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 WorksheetsPart 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 TroubleshootingPart III: Organizing Worksheets
* Chapter 14: Tables: List Management Made Easy
* Chapter 15: Grouping and Outlining Data
* Chapter 16: TemplatesPart IV: Charts and Graphics
* Chapter 17: Creating Basic Charts
* Chapter 18: Formatting and Perfecting Charts
* Chapter 19: Inserting GraphicsPart V: Advanced Data Analysis
* Chapter 20: Scenarios and Goal Seeking
* Chapter 21: Pivot TablesPart 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 WebPart VII: Programming Excel
* Chapter 27: Automating Tasks with Macros
* Chapter 28: Programming Spreadsheets with VBAPart VIII: Appendix
* Appendix A: Customizing the Quick Access ToolbarColophon