Office 2007 Library: Excel 2007 Bible, Access 2007 Bible, PowerPoint 2007 Bible, Word 2007 Bible - Softcover

Walkenbach, John; Wempen, Faithe; Tyson, Herb; Prague, Cary N.; Irwin, Michael R.; Reardon, Jennifer; Groh, Michael R.; Stockman, Joseph C.; Powell, Gavin

Softcover

ISBN 10: 0470169931 ISBN 13: 9780470169933

Verlag: John Wiley & Sons Ltd, 2007

Inhaltsangabe

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.

Über diesen Titel

Über die Autorinnen und Autoren

John Walkenbach, a.k.a. Mr. Spreadsheet, is arguably the foremost authority on Excel. His forty-plus books include Excel "2007 Power Programming with VBA," "Excel 2007 Formulas," and the bestselling "Excel 2007 Bible," all published by Wiley. He has also written hundreds of articles and created the award-winning Power Utility Pak. Visit John's popular Spreadsheet Page at www.j-walk.com/ss.

Faithe Wempen, M.A., CompTIA A+ (Noblesville, IN), has been teaching PC hardware and software architecture at Purdue University for over a decade. She has written over 140 retail, trade, and academic books, including A+ Certification Workbook for Dummies, PC Maintenance: Preparing for A+ Certification, and CompTIA Strata Study Guide Authorized Courseware. She is also a Microsoft Office Master Instructor and the author of many popular Microsoft Office books including Word 2016 In Depth, PowerPoint 2013 Official Academic Course, and Office 2016 for Dummies At Work. Her online courses for corporate clients such as CNET, Sony, and HP have educated over a quarter of a million students.

Dr. Herb Tyson has been a Microsoft MVP for more than ten years and has authored more than a dozen computer "help" books. He is an economist, a consultant, and a musician. Herb also provides custom training for users of Windows and Office, emphasizing Word and Outlook.

Joe Stockman is an independent consultant, software designer, and author who has been using Microsoft Access since its initial release. He's also developed courseware and taught classes in Access and VBA. Joe developed his first application in Access, and then migrated into Visual Basic and VB.NET, where he specializes in creating applications for the Windows Mobile platform. He's worked for several software companies before forming his consulting business in 2002, where he deals with all types of clients including healthcare, financial, government, manufacturing, and small business. His ability to turn his customers' wishes into working applications keeps them satisfied. Joe is the co-author of the "Access 2007 Bible" and "Access 2007 VBA Programming For Dummies" and also writes for the "Advisor Guide to Microsoft Access" magazine.

Von der hinteren Coverseite

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

Details zur Ausgabe

• Verlag: John Wiley & Sons Ltd
• Erscheinungsdatum: 2007
• Sprache: Englisch
• ISBN 10: 0470169931
• ISBN 13: 9780470169933
• Einband: Tapa blanda
• Anzahl der Seiten: 4200
• Kontakt zum Hersteller: Nicht verfügbar
• Verantwortliche Person: Nicht verfügbar