Product Description

Packed with examples, techniques, and tips from Microsoft MVP John Walkenbach, this perennial bestseller has been updated for Excel 2007 and is equally valuable for beginners and power users. You’ll learn how to master Excel’s new “menuless” Ribbon interface, develop custom functions, create UserForms, analyze data with external database files and PivotTables, and much more. Here’s valuable comprehensive coverage of the fundamentals as well as advanced 2007 features like the new user interface and wider use of XML and Web services.

Product Details

• Amazon Sales Rank: #87678 in Books
• Published on: 2007-04-16
• Original language: English
• Number of items: 1
• Binding: Paperback
• 4200 pages

From the Back Cover

The perennial bestseller, updated for Excel 2007

Equally valuable for beginners and power users, this book is packed with examples, techniques, and tips from Microsoft MVP John Walkenbach.

• Master Excel's new "menuless" Ribbon interface

• Understand formulas, functions, tables, worksheets, and workbooks

• Develop custom functions and create UserForms

• Analyze data with external database files and PivotTables

• Enhance worksheets with SmartArt tools

• Customize the Quick Access toolbar to save time

Updated with all the exciting Access 2007 features

Here's comprehensive coverage of the fundamentals as well as advanced 2007 features like the new user interface and wider use of XML and Web services.

• Build efficient databases using a five-step design method

• Utilize the improved Access report designer

• Design efficient data-entry and data-display forms

• Automate applications using VBA and the VBA editor

• Seamlessly exchange Access data with SharePoint®

• Use the Windows API and object-oriented programming

Put this brave new Word to work for you

A Microsoft MVP shows you how to accomplish familiar tasks, command Word's legacy features, use the new native capabilities in Word 2007, and more!

• Navigate Word's new Ribbon and Quick Access Toolbar

• Use the new automatic features—AutoCorrect, AutoFormat, Smart Tags, and Quick Parts

• Speed through recurring tasks

• Create envelopes, labels, and mailings for 10 or 1,000

• Include tables, charts, drawings, and SmartArt for visual communication

Use PowerPoint 2007 for presentations with punch

Here's the complete PowerPoint picture—how to use all the new features plus what goes into a power-packed presentation.

• Format with Layouts, Themes, and Master slides

• Integrate drawings, charts, or data from various sources

• Discover how to engage your audience during your presentation

• Add sound effects, music, video, and animation

• Make your presentation from multiple monitors and different computers

• Design interactive or self-running shows

"John Walkenbach provides excellent examples in this book . . . that Excel users will find very useful."
—David McRitchie, Microsoft MVP

"I recommend this book for anyone who wants a strong foundation in Access."
— Jeff Lenamon, CIBC World Markets