Whether you're already a power user or just starting, find out how to get the most out of this major new release of Excel from expert instructor and Microsoft MVP, "Mr. Spreadsheet," John Walkenbach. Each of the book's seven parts thoroughly focuses on key elements, so no matter what your level of expertise, you'll find what you need in the hundreds of examples, techniques, and tips in this comprehensive resource. *Master Excel's new "menu-less" Ribbon user interface *Understand formulas, functions, tables, worksheets, and workbooks *Explore the new unlimited conditional formatting *Develop custom functions, program with VBA, and create UserForms *Analyze data using external database files and pivot tables *Enhance your worksheets with new SmartArt tools *Customize the Quick Access Toolbar and save time *CD-ROM includes valuable Excel templates and worksheets from John Walkenbach *ISBN: 0470044039

Access 2007 Bible - Harness the power of Access 2007

Beginners will appreciate the thorough attention to database fundamentals and terminology. Experienced users can jump right into Access 2007 enhancements like the all-new user interface and wider use of XML and Web services. Each of the book's six parts thoroughly focuses on key elements in a logical sequence, so you have what you need, when you need it. Designed as both a reference and a tutorial, Access 2007 Bible is a powerful tool for developers needing to make the most of the new features in Access 2007. *Build Access tables using good relational database techniques *Construct efficient databases using a five-step design method *Design efficient data-entry and data display forms *Utilize the improved Access report designer *Use Visual Basic® for Applications and the VBA Editor to automate applications *Build and customize Access 2007 ribbons *Seamlessly exchange Access data with SharePoint® *Employ advanced techniques such as the Windows® API and object-oriented programming *Add security and use data replication in your Access applications *CD-ROM includes databases examples, including database files, images, and data files *ISBN: 0470046732

PowerPoint 2007 Bible - Make an impact on your audience with PowerPoint 2007

To deliver a compelling presentation to your audience, you need to get the most out of PowerPoint’s powerful features. In this comprehensive guide to PowerPoint 2007, experienced author and trainer Faithe Wempen shows you how to do both. You’ll get up to speed on PowerPoint’s new interface and the Ribbon—while you also find out what contributes to a good presentation, such as choosing the right amount and style of information for your audience. *Format with Layouts, Themes, and Master slides *Integrate drawings, charts, or data from a variety of sources *Get beyond bullet points and reading slides full of text and learn to engage your audience during your presentation *Add sound effects, music, animation, and video *Present from multiple monitors and separate computers *Design interactive or self-running kiosk shows *CD-ROM includes more than 500 professionally designed PowerPoint templates and backgrounds that you can use in your own PowerPoint presentations. *ISBN: 0470043687

Word 2007 Bible - Make Microsoft’s brave new Word work for you

Microsoft’s Word 2007 rewrites the book on word processing. New to Word? The Word 2007 Bible helps you soar over the hurdles and quickly brings you up to speed. A Word veteran? You’ll discover new ways to command legacy features, completely new features to accomplish old tasks, and brand new native capabilities. No matter what level user you are, Microsoft Word MVP Herb Tyson’s expert guidance puts you in charge, helping you choose the best way to get your work done, and to get the most out of Word 2007. *Navigate the new Ribbon and Quick Access Toolbar user interface *Put Word’s automatic features to work for you—AutoCorrect, AutoFormat, Smart Tags, Quick Parts, and more *Find the fastest way to accomplish your mission once or the best way to speed through recurring tasks *Create envelopes, labels, and mailings for one recipient or 1,000 *Communicate visually with tables, charts, drawings, and Smart Art *Master formatting, styles, and find-and-replace with a heady dose of tips, pitfalls, and shortcuts *Share and collaborate with Word’s PDF export, Groove, and SharePoint® *CD-ROM includes 90 minutes of Word 2007 tutorial video by MVP author Herb Tyson *ISBN: 0470046899