Excel 2007: The Missing Manual
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...
Search in google:
This text 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 using the new Excel.
The Missing CreditsIntroductionPart I: Worksheet BasicsChapter 1: Creating and Navigating WorksheetsChapter 2: Adding Information to WorksheetsChapter 3: Moving Data Around a WorksheetChapter 4: Managing Worksheets and WorkbooksChapter 5: Formatting CellsChapter 6: Smart Formatting TricksChapter 7: Viewing and Printing WorksheetsPart II: Formulas and FunctionsChapter 8: Building Basic FormulasChapter 9: Math and Statistical FunctionsChapter 10: Financial FunctionsChapter 11: Manipulating Dates, Times, and TextChapter 12: Lookup, Reference, and Information FunctionsChapter 13: Advanced Formula Writing and TroubleshootingPart III: Organizing WorksheetsChapter 14: Tables: List Management Made EasyChapter 15: Grouping and Outlining DataChapter 16: TemplatesPart IV: Charts and GraphicsChapter 17: Creating Basic ChartsChapter 18: Formatting and Perfecting ChartsChapter 19: Inserting GraphicsPart V: Advanced Data AnalysisChapter 20: Scenarios and Goal SeekingChapter 21: Pivot TablesPart VI: Sharing Data with the Rest of the WorldChapter 22: Protecting Your WorkbooksChapter 23: Worksheet CollaborationChapter 24: Querying Databases and XML FilesChapter 25: Exchanging Data with Other ProgramsChapter 26: Connecting Worksheets to the WebPart VII: Programming ExcelChapter 27: Automating Tasks with MacrosChapter 28: Programming Spreadsheets with VBAPart VIII: AppendixAppendix A: Customizing the Quick Access ToolbarColophonMatthew MacDonald is an author and programmer extraordinaire. He's the author of Excel: The Missing Manual, Creating Web Sites: The Missing Manual, the forthcoming Access 2007: The Missing Manual, and over a dozen books about programming with the Microsoft .NET Framework.
