Special Edition Using Microsoft Office 2007

by Bott, Ed; Leonhard, Woody

• ISBN13: 9780789735171
• ISBN10: 0789735172
• Edition: 1st
• Format: Paperback
• Copyright: 2006-12-22
• Publisher: Que Publishing

Summary

The ONLY Office 2003 book that matters.

Author Biography

Ed Bott is a best-selling author of more than 25 computer books and an award-winning computer journalist with two decades of experience in the personal computer industry. For nearly 10 years, he was responsible for PC Computing magazine’s extensive coverage of every conceivable flavor of Microsoft Windows and Microsoft Office. He is a three-time winner of the Computer Press Award, and he and Woody Leonhard won the prestigious Jesse H. Neal Award, sometimes referred to as “the Pulitzer Prize of the business press,” in back-to-back years for their work on PC Computing’s “Windows SuperGuide.” He lives in an extremely civilized corner of the American Southwest with his wife, Judy, and a growing menagerie of affectionate pets who are sometimes smarter than he is. You can read more of Ed’s writing at http://www.edbott.com/weblog and at http://blogs.zdnet.com/bott.

 

Curmudgeon, critic, and perennial “Office Victim,” Woody Leonhard runs a fiercely independent Web site with up-to-the-nanosecond news, observations, tips, and help for both Office and Windows. AskWoody.com has become the premier source of unbiased information for people who need to really use Windows and Office, and for people concerned about juggling the never-ending stream of Microsoft patches. In the past 15 years, Woody has written more than three dozen books, drawing an unprecedented six Computer Press Association awards and two American Business Press awards. Woody was one of the first Microsoft Consulting Partners and is a charter member of the Microsoft Solutions Provider organization.

 

Woody moved to Phuket, Thailand, in 2000. He lives in Patong with his wife, Duangkhae Tongthueng (better known as “Add”), his father George, his son Justin, and his all-American beagle, Chronos.

 

Table of Contents

Introduction
Common Tasks and Features
Getting Started with Office 2007	p. 9
Using and Customizing the Office 2007 Interface	p. 27
Managing Office Files and Formats	p. 53
Creating, Editing, and Formatting Documents	p. 75
Creating, Editing, and Using Pictures and Graphics	p. 103
Sharing and Reviewing Office Files	p. 135
Office Security and Privacy	p. 159
Using Outlook
Outlook Essentials	p. 177
Reading, Writing, and Organizing Email	p. 219
Keeping Your Contacts List Under Control	p. 259
Working with Calendars and Tasks	p. 277
Outlook Security and Privacy	p. 307
Using Word
Building a Better Word Document	p. 329
Using Themes, Styles, and Templates	p. 387
Advanced Document Formatting	p. 415
Professional Document Tools and Advanced Document Sharing	p. 455
Letters, Envelopes, and Data-Driven Documents	p. 477
Using Excel
Building a Better Workbook	p. 507
Advanced Worksheet Formatting	p. 553
Using Formulas and Functions	p. 593
Organizing Data with Tables and PivotTables	p. 627
Creating and Editing Charts	p. 665
Using PowerPoint
Building a Perfect Presentation	p. 703
Advanced Presentation Formatting	p. 737
Adding Graphics, Multimedia, and Special Effects	p. 759
Planning and Delivering a Presentation	p. 779
Other Office Applications
Publisher Essentials	p. 797
Access Essentials	p. 835
Using OneNote	p. 879
Using Office 2007 on a Corporate Network	p. 907
Appendixes
Advanced Setup Options	p. 929
Macros and Add-Ins	p. 943
Using Office on a Tablet PC	p. 961
	p. 969
Table of Contents provided by Publisher. All Rights Reserved.

Excerpts

Introduction INTRODUCTION In this Introduction Who Should Buy This Book 2 How This Book Is Organized 3 Conventions Used in This Book 4 Over the past dozen years, Microsoft Office has gone through a half-dozen upgrades. And every time, pundits and reviewers trot out the same complaint: there's nothing new. No one's saying that about Office 2007. It's taken Microsoft nearly four years to deliver this upgrade, which is roughly twice as long as the average gap between each of the five previous versions. What were they doing in all that time? Oh, just replacing the core interface that has defined desktop software since the earliest days of Windows. Adding a new graphics engine. Tightening security. You know, little stuff. In its early years, Office was little more than a bundle of programs built by teams that sometimes worked at cross purposes with one another, and the whole package was held together with the digital equivalent of baling wire and chewing gum. In this massive update, however, Microsoft has delivered something genuinely new and surprisingly well integrated. The new Office interface, with its Ribbon, tabs, and groups of commands, is a shock at first. The more you know about the old interface, the more you'll have to unlearn to become productive again. And the old interface with its menus and toolbars isn't gone completely. It still has odd inconsistencies, as well as bugs, features that don't work as advertised, and some limitations guaranteed to drive expert users crazy. But for the fourth edition of this book, we were pleasantly surprised to see how many of the new features actually work as advertised. As befits the name, Office 2007 has a decidedly corporate bias. In fact, some of the collaborative features that are at its core are available only if you enlist an army of IT professionals to run a room full of servers. To help show you how to make Office programs work with SharePoint and other network-based services, we had to build our own corporate network. (In the process, we developed a deep empathy for the challenges that network administrators have to deal with every day.) But we didn't lose sight of the fact that most of our readers still think of Office aspersonalproductivity software. Some of what you see inSpecial Edition Using Microsoft Office 2007will be familiar to you if you've worked with an earlier edition of this book. We didn't take the easy way out and simply reprint some of those old chapters on the theory that the programs didn't change much. Instead, we went through every chapter, sentence by sentence, testing, verifying, updating, and adding a wealth of new information to ensure that this book is accurate and absolutely up-to-date. Who Should Buy This Book If you need an Office reference book you can rely on--one that won't bore you with the obvious, pull punches when Office comes up short, or turn mealy-mouthed when you hit the really hard parts--you have the right book in your hands. As with other titles in Que's best-sellingSpecial Edition Usingseries, this book focuses on the unique needs of business professionals and business users. We assume you're experienced with Windows, the Web, and, for the most part, previous versions of Microsoft Office. We know that Office is an absolutely essential part of your everyday working life. We're also certain you've experienced your fair share of Office bugs and annoyances firsthand. Because we're confident you've already figured out the basics, we've spent our time figuring out how these programsreallywork. Trust us--Office still has bugs and poorly designed features, and Microsoft doesn'