Overview
Main description
Master the latest version of Excel
Get more out of Excel than ever before with help from this hands-on guide. Learn how to create powerful and easy-to-use spreadsheets and bring yourself up to speed on all the new and improved features available in Excel 2007. Discover how to enter and format data, use graphics effectively, create formulas, build tables to store and analyze data, and share workbooks securely with other users. You'll also learn how to save files to intranet sites and Internet servers, and publish workbooks to Web pages. Plus, you'll find valuable shortcuts that will make it even easier to use the world's most popular spreadsheet application.
- Control Excel using the new Ribbon interface instead of menus and toolbars
- Configure and customize Excel to suit your working needs
- Add visual impact to your worksheets with pictures and diagrams
- Develop formulas to perform custom calculations
- Analyze data using PivotTables and organize your information to show exactly what you need
- Use what-if analysis to solve complex and time-grabbing business problems
- Share workbooks and collaborate with colleagues
- Transfer data easily among other Office applications
Table of contents
Part I: Get Started with ExcelChapter 1: Navigate the Excel ScreenChapter 2: Configure Excel to Suit Your Working NeedsChapter 3: Create Spreadsheets and Enter DataChapter 4: Format Worksheets for Best EffectChapter 5: Add Graphics and Drawings to WorksheetsChapter 6: Check, Lay Out, and Print WorksheetsPart II: Calculate, Manipulate, and Analyze DataChapter 7: Perform Calculations with FunctionsChapter 8: Create Formulas to Perform Custom CalculationsChapter 9: Organize Data with Excel DatabasesChapter 10: Outline and Consolidate WorksheetsChapter 11: Analyze Data Using PivotTables and PivotChartsChapter 12: Solve Problems by Performing What-If AnalysisPart III: Share, Publish, and Present DataChapter 13: Create Effective Charts to Present Data VisuallyChapter 14: Share Workbooks and Collaborate with ColleaguesChapter 15: Using Excel's Web CapabilitiesChapter 16: Use Excel with the Other Office ApplicationsPart IV: Customize and Program ExcelChapter 17: Customize Excel's InterfaceChapter 18: Use Macros to Automate TasksAppendix: Keyboard ShortcutsIndex
Author comments
Guy Hart-Davis is the author of more than 40 computer books including How to Do Everything with Microsoft Office Word 2007, CNET Do-It-Yourself iPod Projects, and How to Do Everything with Your iPod & iTunes.
