Guy Hart-Davis

How to Do Everything with Microsoft Office Excel 2007

• Broschiertes Buch

Produktbeschreibung

How to Do Everything with Excel 2007 teaches the reader how to master the latest version of Microsoft's market-dominating spreadsheet application Excel 2007 builds on previous versions of Excel by introducing a new interface featuring the Ribbon, a visual feature that replaces the current menus and toolbars and gives instant, context-sensitive access to whichever features the user currently needs. Excel 2007 also features an XML-based file format for greater compatibility with other applications, deeper integration with the other Office applications, and enhanced stability. Features 1. Uses the proven hands-on approach of the How to Do Everything series to take the reader from being an Excel beginner to producing full-quality, professional work with Excel 2. Coverage includes spreadsheet layout; basic and advanced formatting; adding impact with graphics and diagrams; using functions and formulae (built-in and custom); building databases; creating PivotTables and PivotCharts; and using Solver, Goal Seek, and what-if analysis to solve complex business problems 3. How To sidebars introduce practical, timesaving techniques for everyday operations-from the mundane to the sophisticated. Did You Know sidebars point up key information on why Excel works in unexpected ways and tell the reader how to get the most out of Excel

---

Hinweis: Dieser Artikel kann nur an eine deutsche Lieferadresse ausgeliefert werden.

Produktdetails

• Verlag: McGraw Hill LLC
• Seitenzahl: 512
• Erscheinungstermin: 9. Januar 2007
• Englisch
• Abmessung: 230mm x 187mm x 29mm
• Gewicht: 838g
• ISBN-13: 9780072263695
• ISBN-10: 0072263695
• Artikelnr.: 21672303

Autorenporträt

Guy Hart-Davis (Barnard Castle, UK) is the author of more than 60 computer books, including all editions of How to Do Everything: iPod, iPhone, & iTunes, iPad and iPhone Administrator's Guide, Integrating Macs in Windows Networks, and Mac OS X System Administration.

Inhaltsangabe

Part I: Get Started with Excel
Chapter 1: Navigate the Excel Screen
Chapter 2: Configure Excel to Suit Your Working Needs
Chapter 3: Create Spreadsheets and Enter Data
Chapter 4: Format Worksheets for Best Effect
Chapter 5: Add Graphics and Drawings to Worksheets
Chapter 6: Check, Lay Out, and Print Worksheets
Part II: Calculate, Manipulate, and Analyze Data
Chapter 7: Perform Calculations with Functions
Chapter 8: Create Formulas to Perform Custom Calculations
Chapter 9: Organize Data with Excel Databases
Chapter 10: Outline and Consolidate Worksheets
Chapter 11: Analyze Data Using PivotTables and PivotCharts
Chapter 12: Solve Problems by Performing What-If Analysis
Part III: Share, Publish, and Present Data
Chapter 13: Create Effective Charts to Present Data Visually
Chapter 14: Share Workbooks and Collaborate with Colleagues
Chapter 15: Using Excel's Web Capabilities
Chapter 16: Use Excel with the Other Office Applications
Part IV: Customize and Program Excel
Chapter 17: Customize Excel's Interface
Chapter 18: Use Macros to Automate Tasks
Appendix: Keyboard Shortcuts
Index