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 featuresAutoCorrect, 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 picturehow 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