The Unofficial Guide To Microsoft Office 2007

The Unofficial Guide to Microsoft Office 2007 answers the questions users need most and gives reader s insider guidance and valuable tips on how to exploit the capabilities of Office. They ll find savvy advice on everything from simple tasks like working with the new UI to understanding and maximizing the new Open XML and collaboration tools available in Office 2007 and how they can expedite repetitive or common tasks. This comprehensive, easy-to-follow guide reveals what other sources won t and presents unbiased recommendations to help users get the most out of Office. This book begins with the basics and takes users through all the robust features and applications in Office 2007. Aimed primarily at those users looking for more than the conventional wisdom on to how to get the best out of Office in the most efficient way, The Unofficial Guides are the answers they are seeking.Part I Learning Common Office TasksPart II Creating Documents with WordPart III Crunching Numbers with ExcelPart IV Communicating with OutlookPart V Building Presentations with PowerPointPart VI Managing Data with AccessPart VII Finishing Your Site and BeyondPart VIII Appendixes

The inside scoop...for when you want more than the official line! Microsoft Office Excel 2007 may be just what you need to crunch numbers, but to use it with confidence, you'll need to know its quirks and shortcuts. Find out what the manual doesn't always tell you in this insider's guide to using Excel in the real world. What are the secrets of pro users? Are there shortcuts for repetitive tasks? From writing formulas to using charts, first get the official way, then the best way from two experts. Unbiased coverage of how to get the most out of Excel 2007, from creating workbooks and writing formulas to comparing data Savvy, real-world advice to help you set up, enter, format, and organize your data Time-saving techniques and practical guidance on creating custom macros with VBA and using PivotTables and PivotCharts Tips and hacks with practical ways to save time, avoid pitfalls, and increase your output Sidebars, tables, and illustrations featuring toolbar buttons and more ways to be productive in Excel Watch for these graphic icons in every chapter to guide you to specific practicalinformation. Bright Ideas are smart innovations that will save you time or hassle. Hacks are insider tips and shortcuts that increase productivity. When you see Watch Out! heed the cautions or warnings to help you avoid commonpitfalls. And finally, check out Inside Scoops for practical insights from the author. It's like having your own expert at your side!

The inside scoop... for when you want more than the official line! Microsoft Office Word 2007 may be the top word processor, but to use it with confidence, you'll need to know its quirks and shortcuts. Find out what the manual doesn't always tell you in this insider's guide to using Word in the real world. How do you use the new Ribbon? What's the best way to add pictures? From deciphering fonts to doing mass mailings, first get the official way, then the best way from an expert. Unbiased coverage on how to get the most out of Word 2007, from applying templates and styles to using new collaboration tools Savvy, real-world advice on creating document for the Web, saving time with macros, and punching up docs with SmartArt. Time-saving techniques and practical guidance on working around Word quirks, avoiding pitfalls, and increasing your productivity. Tips and hacks on how to customize keyboard shortcuts, how to embed fonts, and quick ways to get to Help. Sidebars and tables on TrueType versus Printer fonts, World 2007 View modes, and tabs in Word 2007. Watch for these graphic icons in every chapter to guide you to specific practical information. Bright Ideas are smart innovations that will save you time or hassle. Hacks are insider tips and shortcuts that increase productivity. When you see Watch Out! heed the cautions or warnings to help you avoid common pitfalls. And finally, check out the Inside Scoops for practical insights from the author. It's like having your own expert at your side!

The inside scoop...for when you want more than the official line! Microsoft Access 2007 may be a major new update, but to use it with confidence, you'll need to know its quirks and shortcuts. Find out what the manual doesn't always tell you in this insider's guide to using Access 2007 in the real world. What's the best way to use the new features? What are "intelligent" forms? From setting up tables to encrypting databases, first get the official way, then the best way from an expert. Unbiased coverage of how to get the most out of Access, from using the Quick Launch Toolbar and Office Button to building a database from scratch Savvy, real-world advice on everything from using form views, PivotTables, and PivotCharts to writing questions in the form of a query Time-saving techniques and practical guidance on creating smart macros, collaborating with others using SharePoint(r), and adding pizzazz to reports Tips and hacks that help you work around Access quirks, avoid pitfalls, and increase your productivity Sidebars and tables on sorting rules for special characters, predefined sizes for number data types, and more

This book provides the inside scoop ... for when you want more than the official line! Microsoft Access 2007 may be a major new update, but to use it with confidence, you'll need to know its quirks and shortcuts. Find out what the manual doesn't always tell you in this insider's guide to using Access 2007 in the real world. What's the best way to use the new features? What are "intelligent" forms? From setting up tables to encrypting databases, first get the official way, then the best way from an expert. This book provides unbiased coverage of how to get the most out of Access, from using the Quick Launch Toolbar and Office Button to building a database from scratch. It contains savvy, real world advice on everything from using form views, PivotTables, and PivotCharts to writing questions in the form of a query. It includes time saving techniques and practical guidance on creating smart macros, collaborating with others using SharePoint[registered], and adding pizzazz to reports. It provides tips and hacks that help you work around Access quirks, avoid pitfalls, and increase your productivity. It features sidebars and tables on sorting rules for special characters, predefined sizes for number data types, and more. Watch for these graphic icons in every chapter to guide you to specific practical information. Bright Ideas are smart innovations that will save you time or hassle. Hacks are insider tips and shortcuts that increase productivity. When you see Watch Out! heed the cautions or warnings to help you avoid commonpitfalls. And finally, check out Inside Scoops for practical insights from the author. It's like having your own expert at your side!

The inside scoop...for when you want more than the official line! To use Microsoft Excel with confidence you'll need to know its quirks and shortcuts.Find out what the manual doesn't always tell you in this insider's guide to using Excel in the real world. What are the best practices used by pros? Are there shortcuts for repetitive tasks? From writing formulas to using charts, first get the official way, then the best way from an expert. * Unbiased coverage of how to get the most out of Excel, create workbooks and templates, and get comfortable with the Excel environment * Savvy, real-world advice, to help you set up, enter, format, and organize your data * Time-saving techniques and practical guidance on creating custom macros with VBA, using PivotTables and PivotCharts, and sharing data * Tips and hacks on how to use pre-set macros, AutoFill double-click, and other useful shortcuts to save you time * Sidebars and tables featuring toolbar buttons and more ways to beproductive in Excel Watch for these graphic icons in every chapter to guide you to specific practical information. * Bright Ideas are smart innovations that will save you time or hassle. * Hacks are insider tips and shortcuts that increase productivity. When you see * Watch Out! heed the cautions or warnings to help you avoid common pitfalls. And finally, check out * Inside Scoops for practical insights from the author. It's like having your own expert at your side!

Microsoft Outlook 2007 is a major update and to use it with confidence you need to know its quirks and shortcuts. Readers will find unbiased information on everything from simple tasks like working with schedules and the calendar to expertly managing contacts and expediting repetitive or common tasks.

Completely redesigned to help users finish tasks more quickly and manage information more effectively, Microsoft Office 2007 will offer users a new look and smarter ways of getting things done. From the expanded depth and power of Excel 2007 to the new graphics capabilities and formatting tools of PowerPoint, Microsoft has rethought and reworked the entire suite. And in this new edition of our Office Visual QuickStart Guide, author Steve Schwartz has rewritten from the ground up the entire book to better aid readers as they get up to speed with the new Office tools. The book is essential reference tool for the home and small business user, covering everything in the Office Basic, Home & Student, Standard, and Small Business suites. Software covered includes: Word, Excel, OneNote, Outlook, PowerPoint, and Publisher. Easy visual approach uses pictures to guide you through Microsoft Office and show you what to do. Concise steps and explanations let you get up and running in no time. Page for page, the best content and value around. Table of Contents: Part I: Introducing Microsoft Office 2007 Chapter 1: What's New in Office 2007? Chapter 2: Office Basics Part II: Microsoft Word Chapter 3: Getting Started with Word 2007 Chapter 4: Formatting Documents Chapter 5: Creating Outlines Chapter 6: Tables, Charts, and Art Chapter 7: Sharing Word Documents Part III: Microsoft Excel Chapter 8: Getting Started with Excel 2007 Chapter 9: Formatting Worksheets and Data Chapter 10: Formulas and Functions Chapter 11: Working with Tables Chapter 12: Creating Charts Part IV: Microsoft PowerPoint Chapter 13: Getting Started with PowerPoint 2007 Chapter 14: Creating a Presentation Chapter 15: Completing a Presentation Part V: Microsoft Outlook Chapter 16: Getting Started with Outlook 2007 Chapter 17: Using the Address Book Chapter 18: Composing and Sending Mail Chapter 19: Receiving Mail Chapter 20: Managing the Mail Chapter 21: Tasks and Appointments Part VI: Microsoft OneNote Chapter 22: Getting Started with OneNote 2007 Chapter 23: Creating Notes Chapter 24: Embellishing and Editing Notes Chapter 25: Managing Notes Part VII: Microsoft Publisher Chapter 26: Getting Started with Publisher 2007 Chapter 27: Distributing and Printing Index