Office 2007 Library Excel 2007 Bible, Access 2007 Bible, Powerpoint 2007 Bible, Word 2007 Bible

The perennial bestseller, updated for Excel 2007Equally 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 interfaceUnderstand formulas, functions, tables, worksheets, and workbooksDevelop custom functions and create UserFormsAnalyze data with external database files and PivotTablesEnhance worksheets with SmartArt toolsCustomize the Quick Access toolbar to save timeUpdated with all the exciting Access 2007 featuresHere'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 methodUtilize the improved Access report designerDesign efficient data-entry and data-display formsAutomate applications using VBA and the VBA editorSeamlessly exchange Access data with SharePointrUse the Windows API and object-oriented programmingPut this brave new Word to work for youA 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 ToolbarUse the new automatic features-AutoCorrect, AutoFormat, Smart Tags, and Quick PartsSpeed through recurring tasksCreate envelopes, labels, and mailings for 10 or 1,000Include tables, charts, drawings, and SmartArt for visual communicationUse PowerPoint 2007 for presentations with punchHere'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 slidesIntegrate drawings, charts, or data from various sourcesDiscover how to engage your audience during your presentationAdd sound effects, music, video, and animationMake your presentation from multiple monitors and different computersDesign 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 MarketsWalkenbach, John is the author of 'Office 2007 Library Excel 2007 Bible, Access 2007 Bible, Powerpoint 2007 Bible, Word 2007 Bible', published 2007 under ISBN 9780470169933 and ISBN 0470169931.