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.
Inhaltsverzeichnis
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