Sams teach yourself Microsoft Office 2007 all in one / Greg Perry.

Enhanced descriptions from Syndetics:

One Book...All the Answers

nbsp;

In just a short time you will be up and running with Microsoft Office 2007, including Word, Excel, PowerPoint, Outlook, and OneNote.

nbsp;

Using a straightforward, step-by-step approach, each lesson builds upon a real-world foundation, allowing you to learn the essentials of Office 2007 from the ground up.

nbsp;

Thorough instructions walk you through the most common tasks and show you extra features that make your Office 2007 documents stand apart from the crowd.

nbsp;

Notes present interesting pieces of information, extra features you can use, and warnings to protect your data.

nbsp;

Tips offer extra advice or teach an easier way to do something.

nbsp;

Learn how to...

Leverage New Features to Do More Work in Less Time Master Office 2007''s New Ribbon Use Live Preview to See How Changes Will Affect Your Documents Create Online Web Pages from Your Office Documents, Worksheets, and Presentations Apply a Consistent Theme to All Your Documents, Worksheets, and Presentations Format Word Documents to Grab Attention Without Taking Away from the Message You Want to Convey Perform Mail Merging with Ease Set Up Powerful Worksheet Page Formats Drop Audio and Video into Your PowerPoint Presentations Organize Your Email to Work Smarter Locate Outlook Contacts on a Global Map Maximize Note Taking with OneNote Part I: Introducing Microsoft Office 2007 1

Chapter 1: Start Herenbsp;nbsp;nbsp;nbsp;nbsp; 3

nbsp;

PART II: Writing with Wordnbsp;nbsp; 29

Chapter 2: Learning Word''s Basicsnbsp;nbsp;nbsp;nbsp;nbsp; 31

Chapter 3: Making Your Words Look Goodnbsp;nbsp;nbsp; 69

Chapter 4: Adding Lists, Tables, and Graphicsnbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp; 107

Chapter 5: Using Word''s Advanced Features 147

nbsp;

PART III: Working with Excel Worksheetsnbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp; 201

Chapter 6: Getting to Know Excelnbsp;nbsp;nbsp;nbsp;nbsp;nbsp; 203

Chapter 7: Working with Excel Datanbsp;nbsp;nbsp; 243

Chapter 8: Formatting Worksheets with Excelnbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp; 273

Chapter 9: Creating Advanced Worksheetsnbsp;nbsp; 303

Chapter 10: Using Excel as a Simple Databasenbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp; 329

nbsp;

PART IV: Impressing Audiences with PowerPointnbsp;nbsp;nbsp;nbsp;nbsp; 347

Chapter 11: Learning About PowerPointnbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp; 349

Chapter 12: Adding Flair to Your Presentationsnbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp; 371

Chapter 13: Making More Impressive Presentationsnbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp; 393

nbsp;

PART V: Organizing with Outlooknbsp;nbsp;nbsp; 429

Chapter 14: Introducing Outlooknbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp; 431

Chapter 15: Making Contactnbsp;nbsp;nbsp;nbsp;nbsp; 475

Chapter 16: Living with Outlook 497

nbsp;

PART VI: Enhancing Your Work with Other Office Features 517

Chapter 17: Making Notes with OneNotenbsp;nbsp;nbsp;nbsp;nbsp; 519

Chapter 18: Automatic Officenbsp;nbsp;nbsp; 541

Chapter 19: Sharing Data Among Office Applicationsnbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp; 563

Chapter 20: Combining Office and the Internetnbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp; 581

nbsp;

Table of contents provided by Syndetics

• Part I Introducing Microsoft Office 2007 (p. 1)
• Chapter 1 Start Here (p. 3)
• Part II Writing with Word (p. 29)
• Chapter 2 Learning Words Basics (p. 31)
• Chapter 3 Making Your Words Look Good (p. 69)
• Chapter 4 Adding Lists, Tables, and Graphics (p. 107)
• Chapter 5 Using Words Advanced Features (p. 147)
• Part III Working with Excel Worksheets (p. 201)
• Chapter 6 Getting to Know Excel (p. 203)
• Chapter 7 Working with Excel Data (p. 243)
• Chapter 8 Formatting Worksheets with Excel (p. 273)
• Chapter 9 Creating Advanced Worksheets (p. 303)
• Chapter 10 Using Excel as a Simple Database (p. 329)
• Part IV Impressing Audiences with PowerPoint (p. 347)
• Chapter 11 Learning About PowerPoint (p. 349)
• Chapter 12 Adding Flair to Your Presentations (p. 371)
• Chapter 13 Making More Impressive Presentations (p. 393)
• Part V Organizing with Outlook (p. 429)
• Chapter 14 Introducing Outlook (p. 431)
• Chapter 15 Making Contact (p. 475)
• Chapter 16 Living with Outlook (p. 497)
• Part VI Enhancing Your Work with Other Office Features (p. 517)
• Chapter 17 Making Notes with OneNote (p. 519)
• Chapter 18 Automatic Office (p. 541)
• Chapter 19 Sharing Data Among Office Applications (p. 563)
• Chapter 20 Combining Office and the Internet (p. 81)

Excerpt provided by Syndetics

Introduction Microsoft Corporation's Office products have an installed base of more than 25 million licensed users. More than 90% of the Fortune 500 companies use Microsoft Office. Microsoft completely redesigned the Office interface when it produced Office 2007. Microsoft's goal was to make the Office 2007 interface easier than ever to use, as well as more integrated among other applications and the Internet. By redesigning the interface, Microsoft in effect did away with menus and toolbars and replaced the interface with an ever-changing ribbon across the top of the Office product screens. To many Office old-timers, the ribbon was a bold move--Microsoft did away with the interface we've been using for what seems like forever. At first, the ribbon might frustrate you. You'll find yourself wondering, "Where's that option I need?" If you look up at the ribbon, you'll probably find it! The ribbon changes depending on what you're doing at the time. If you need a feature that you used to have to hunt through menus to locate, you'll probably find it on the ribbon. Office pros are happily finding that after a session or two with Office 2007, they wonder how they ever worked efficiently with the clunky menus and toolbars that used to be there. Brand-new Office users may not ever know how well they have it with the new interface. The ribbon makes it far simpler to master Office than the menu system did. In addition, the graphical features of Office 2007, especially when used with a Windows Vista--compatible computer with Aero graphics capabilities, make learning Office 2007 a pleasure--and a quick pleasure at that. You probably are anxious to get started with Office 2007. Take just a few preliminary moments to acquaint yourself with the design of this book, as described in the next few sections. Who Should Read This Book? This book is for both beginning and advanced Office 2007 users. Readers rarely believe that lofty claim, for good reason, but the design of this book and the nature of Office 2007 make it possible for this book to address that wide of an audience. The reason is simple: The book you hold in your hands approaches Office 2007 the way that most users approach Office 2007 in that a task needs to be done and this book shows you how to do it. All major and most minor Office 2007 features are not taught from a theoretical viewpoint; you don't read paragraph after paragraph of background before learning how something works. Instead, you see how something works in a step-by-step lesson. For example, if you want to create an Excel graph, you'll jump to the task in this book that walks you through the creation of an Excel graph. Why bother with a background of color palettes when you need a simple pie chart? Readers unfamiliar with Windows--based environments will find plenty of introductory help here that brings them quickly up to speed. This book shows you how to do work in Office 2007, as well as how to manage many of the Internet-based Office 2007 elements that you need in order to use Office 2007 in today's online, connected world. If you are new to the Internet, this book helps you get started and shows you how to combine the Internet with Office 2007 to gain synergy from both. Quite simply, this book talks to newcomers without talking down to them. This book also brings those who presently use a Microsoft Office product up to speed with Office 2007. You face a mighty dramatic interface change, as the preceding section explained. With the fundamental Office understanding you already have, you will appreciate the new features and added power of Office 2007, and you'll learn how to maximize your use of the Office 2007 ribbon to get your work done quickly and easily. What This Book Does for You Although this book is not a complicated reference book, you'll learn almost every aspect of Office 2007 from a task-based, typical user's point of view. Office 2007 includes many advanced technical details that most users never need, and this book does not waste your time with those. You want to get up to speed with Office 2007 now , and this book helps you fulfill that goal. Those of you who are tired of the mass of quick-fix computer titles cluttering today's shelves will find a welcome reprieve here. This book presents both the background and descriptions that a new Office 2007 user needs without burdening you with a lot of theory. This book is practical and provides a plethora of step-by-step task walk-throughs that you can follow when you need a feature that a task demonstrates while ignoring the tasks you don't need at the time. This is truly a hands-on book for any Office 2007 user, from novice to pro. These tasks guide you through all the common Office 2007 actions you need to perform to make Office 2007 work for you. Conventions Used in This Book Given that this book is task-based, almost everything shown to you is performed in a step-by-step task. When you read a task, you'll learn about other tasks that you should understand first. For example, before learning how to add text to a PowerPoint slide, you need to know how to insert a slide into a new PowerPoint presentation. The cross-reference for that preliminary task is right there for you to review. Other tasks form a basis or a foundation for subsequent tasks in the book. For example, when you follow the task that shows you how to format Excel cells, the task also lists other tasks that might be beneficial to you after you complete the cell-formatting task. These cross-references among the tasks form web page--like links to the other tasks so that you're sure to get a rounded walk-through of whatever you want to do. Most hands-on tasks include a "Before You Begin" and "See Also" cross-reference section like this one: Before you Begin See Also Enter Data into a Worksheet Set Up Page Formatting Conditionally Format Data About Excel Styles, Themes, and Templates In addition to the step-by-step tasks, you'll find several "About" tasks. These tasks give you necessary background when that background is required to do something else. For example, before learning how to apply a theme to an Excel worksheet, you need to understand how styles, themes, and templates go together to help reduce your work time and increase your productivity. Therefore, the "About Excel Styles, Themes, and Templates" task (task number 78) provides the background necessary--and no more--for you to then tackle the tasks that show you how to apply a style, theme, or template to your work. As you follow the tasks, you'll run across several Tips such as this one: Tip -If you want to freeze only the top row, you don't need to select it first. You only need to select Freeze Top Row from the Freeze Panes drop down list. The same is also true if you want to free the leftmost column; you would select Freeze First Column. These Tips give you added insight into the task you're currently learning about and show you ways to improve on something you're doing. Several Notes are included as well to explain a task in more detail, such as this one: Note -Whatever format you can apply to a cell you can also apply to a range or to your entire worksheet. Select what you want to format and then select the formatting command. It seems to be the nature of computer software to litter our language with terms that are generally unfamiliar to newcomers, and sometimes to advanced users too. When a new term is introduced, the New Term margin note will explain the term to you like this: New Term - AutoFit --The capability of Excel to adjust a column's width to accommodate the widest data value in that column. Your Job Now With that introduction, it's time that you began learning what Office 2007 has in store for you. Turn the page and begin learning Microsoft's exciting redesigned product. © Copyright Pearson Education. All rights reserved. Excerpted from Microsoft Office 2007 by Greg Perry All rights reserved by the original copyright owners. Excerpts are provided for display purposes only and may not be reproduced, reprinted or distributed without the written permission of the publisher.

Author notes provided by Syndetics

Greg Perry has been a leader in computer education for twenty years, having taught at the college level and written enough books and articles to be called "the most proficient computer author on earth." In addition to writing about computers, he speaks, consults, and writes about other topics, including real estate and the government. He and his wife Jayne now offer unique training and insights for new and advanced eBay users and run an eBay consignment business out of their rural, countryside home.