Special Edition Using Microsoft Office Home and Student 2007 and over one million other books are available for Amazon Kindle. Learn more
  • List Price: $39.99
  • Save: $8.79 (22%)
FREE Shipping on orders over $35.
Only 3 left in stock (more on the way).
Ships from and sold by Amazon.com.
Gift-wrap available.
FREE Shipping on orders over $35.
Used: Acceptable | Details
Sold by ToyBurg
Condition: Used: Acceptable
Comment: Eligible for FREE Super Saving Shipping! Fast Amazon shipping plus a hassle free return policy mean your satisfaction is guaranteed. Readable copy. All pages complete and readable but expect worn edges, covers, and creases. There is no Amazon condition below acceptable.
Access codes and supplements are not guaranteed with used items.
Have one to sell? Sell on Amazon
Flip to back Flip to front
Listen Playing... Paused   You're listening to a sample of the Audible audio edition.
Learn more
See this image

Special Edition Using Microsoft Office 2007 Paperback – January 1, 2007

ISBN-13: 978-0789735171 ISBN-10: 0789735172 Edition: 1st

Buy New
Price: $31.20
24 New from $14.57 64 Used from $0.01 1 Collectible from $9.98
Amazon Price New from Used from
"Please retry"
Paperback, January 1, 2007
$14.57 $0.01

Frequently Bought Together

Special Edition Using Microsoft Office 2007 + Special Edition Using Microsoft(R) Office Excel 2007 + Special Edition Using Microsoft Office Word 2007
Price for all three: $90.83

Buy the selected items together


Shop the New Digital Design Bookstore
Check out the Digital Design Bookstore, a new hub for photographers, art directors, illustrators, web developers, and other creative individuals to find highly rated and highly relevant career resources. Shop books on web development and graphic design, or check out blog posts by authors and thought-leaders in the design industry. Shop now

Product Details

  • Paperback: 1056 pages
  • Publisher: Que Publishing; 1 edition (January 1, 2007)
  • Language: English
  • ISBN-10: 0789735172
  • ISBN-13: 978-0789735171
  • Product Dimensions: 9.1 x 7.1 x 2 inches
  • Shipping Weight: 4 pounds (View shipping rates and policies)
  • Average Customer Review: 4.1 out of 5 stars  See all reviews (34 customer reviews)
  • Amazon Best Sellers Rank: #844,549 in Books (See Top 100 in Books)

Editorial Reviews

About the Author

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.


Excerpt. © Reprinted by permission. All rights reserved.



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 as personal productivity software.

Some of what you see in Special Edition Using Microsoft Office 2007 will 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-selling Special Edition Using series, 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 programs really work. Trust us—Office still has bugs and poorly designed features, and Microsoft doesn't always make it easy to see how you can combine features or customize applications to increase productivity.

What you'll find documented here is the raw Office, in all its glory, seen through the eyes of experts who have been pushing Office to the limit for years and years. We don't gloss over the rough spots. We show you what works and what doesn't—giving real-world examples and advice for the former and, whenever possible, workarounds for the latter.

We figure you're smart enough to experiment with basic features and to read the online help when you want to know how an Office program is supposed to work. That's why you won't find beginner-level instructions in this book. Instead, you'll find what isn't in the official documentation—key details, insight, and real-world advice you can't find anywhere else. And it's all arranged so that you can get in, find the answer you need, apply it to your work at hand, and get out. This book may weigh a ton, but if you need the straight scoop on anything related to Office, this is where you should look first.

We're proud to present Special Edition Using Microsoft Office 2007.

How This Book Is Organized

Special Edition Using Microsoft Office 2007 is organized into seven parts. Naturally, each of the major applications in the Office suite gets its own section. Before diving into specific features of Outlook, Word, Excel, and the rest, however, we recommend that you read through the sections that cover the techniques common to all applications.

Part I, "Common Tasks and Features," covers the essentials of Office, most notably the new, radically revamped Office interface. We show you how to customize the one and only user-configurable element of the new interface, the Quick Access Toolbar. This section also covers Office 2007's exceptional new graphics tools, especially the slick SmartArt engine.

Office 2007 has a variety of new tools intended to enhance your privacy and your online security. Turn to Chapter 7, "Office Security and Privacy," for an overview of these new features and detailed instructions on how you can make sure your personal information stays private.

In Part II, "Using Outlook," we'll help you tame the flood of email, banish spam forever with Outlook's surprisingly effective junk-mail filter, keep your address book up-to-date, and set up reminders so that you never miss another appointment. We'll also explain how you can use its hybrid interface (old-style menus and toolbars in the main window, ribbons and tabs in message editing windows, and a new To-Do pane) to tie together contacts, calendars, tasks, and email for maximum productivity.

Part III, "Using Word," covers the oldest and most polished productivity application in Office. We'll walk you through every customization option (including a few you probably never even knew you needed). We'll show you how to supercharge your text-editing and formatting skills, how to manage long documents, and how to automate everyday documents so that they practically write themselves.

Part IV, "Using Excel," shows you tricks you never realized you could perform with this incredibly versatile tool. Check out the examples in our formatting chapters to see how you can turn drab rows and columns into eye-catching data graphics. We'll explain how to master any of Excel's 300+ functions, as well as which ones are worth memorizing. We'll unravel the secrets of making drop-dead gorgeous charts, and we'll show you how to use the effective new list-editing tools that turn Excel 2007 into one of the best flat-file database programs around.

Of all the Office applications, PowerPoint is probably the least appreciated. In Part V, "Using PowerPoint," we explain how this program really works, and we'll help you create compelling presentations that you can deliver in front of a large audience or a small one—or completely unattended over the Web.

In Part VI, "Other Office Applications," we focus on three programs found in selected Office versions. Access is Microsoft's industrial-strength database-management program. We explain how to build tables, forms, and reports, as well as simple (and not-so-simple) queries to find and filter data. We'll also clue you in on techniques you can use to automate everyday business tasks without having to become a programmer.

This section also covers Publisher, which takes up where Word leaves off to perform advanced page-layout tasks. And we look at OneNote, an offbeat but incredibly useful freeform note-taking application. And finally, we offer a broad overview of what youget with Office 2007 when you combine it with a growing family of server-based components.

If you need to install Office on one PC or several hundred, we'll run through all your options in Appendix A, "Advanced Setup Options," one of three appendixes at the back of the book. In Appendix B, "Macros and Add-Ins," we provide a whirlwind tour of how the tools to create, edit, and run macros have changed in Office 2007. And in Appendix C, "Using Office on a Tablet PC," we explain what's new when you install Office 2007 on a Tablet PC.

Conventions Used in This Book

Special conventions are used to help you get the most from this book and from Office 2007.

Text Conventions

Various typefaces in this book identify terms and other special objects. These special typefaces include the following:




New terms or phrases when initially defined. An italic term followed by a page number indicates the page where that term is first defined.


Information that you type or onscreen messages.


Typically used to indicate Excel objects, such as functions and cell references.

More About the Authors

Discover books, learn about writers, read author blogs, and more.

Customer Reviews

Book is well done and the instructions are easily understood.
Robert P. Newman
If you are upgrading to Office 2007 from an earlier version of Office this book is a great help.
Overall, I highly recommend this book to everyone, beginner to pro.
Gregory Fridman

Most Helpful Customer Reviews

66 of 68 people found the following review helpful By Joyce M. Lillemon Boschert on March 30, 2007
Format: Paperback
I have to learn Office 2007 enough to teach it, and there aren't many books out yet for it. The Special Edition series is one that I use for a desktop reference for several programs, and this one goes with them. It's clear, not cute or condescending, has good content, and is easy to refer to with questions. It's a good book to keep on hand as you learn Office 2007.
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
52 of 57 people found the following review helpful By G. Kinzer on March 22, 2007
Format: Paperback
Ed & Woody have turned out another extememly valuable reference text for Microsoft's Office series. I bought the upgrade to Office but would not install it until I could read some of the text to see what I should be aware of after installation. I'm glad I did. The change in file systems is definitely something that anyone upgrading should know about.

I highly recommend the book.
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
97 of 115 people found the following review helpful By John Matlock on January 8, 2007
Format: Paperback
I don't have Office 2007 yet, but I bought this book because as soon as it's available I'll start getting questions about it. At first glance, just from reading this book not actually trying things out, it appears that there are three big changes in Office 2007.

First is the Ribbon. Microsoft has specialized in graphical user interfaces (GUI). 'THE RIBBON' is Microsoft's new standard for GUI's and have been applied across all of the office products. I think it's better from what the book says, but boy is it going to cause a lot of questions.

Second is Security. Internally this is probably the biggest changes. There's a new Office Trust Center. It's not as pretty as the other packages (but it does have a ribbon). It's a new feature within office, it will get prettier and easier to use in future versions.

The third big set of changes is in sharing documents as you work on them. This is part of Microsoft's approach to the enterprise market rather than personal productivity. Let's just say that this will be a challenge.

Why this particular book? The authors and their writing style. They make reading about computers almost entertaining. And they are not Microsoft, so they can make comments about how things really work rather than just praising everything.

One complaint -- About ten more pages on Access would be a big help. A list of reserved words for instance, which are rather hard to find. And some brief discussion on using Access with SQL Server.

All in all, there are (or will be) a lot of books on Office 2007. I like these guy's style.
4 Comments Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
15 of 16 people found the following review helpful By Gregory Fridman on November 20, 2007
Format: Paperback
I've been using office for as long as Microsoft had it. This is a good book that let me quickly familiarize myself with whatever was added in this version.

Took me about 3 days to thumb-through and take notes. I come back to this book now as a reference every once in a while.

Overall, I highly recommend this book to everyone, beginner to pro. Though, possibly, this book might be a little tough on the beginner.
2 Comments Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
17 of 19 people found the following review helpful By Linc on February 15, 2008
Format: Paperback Verified Purchase
If you are upgrading to Office 2007 from an earlier version of Office this book is a great help. Microsoft has made a number of changes in where basic tools are located and how to access them. This book makes the learning process a lot simpler and a lot quicker. However, I don't recommend you try to read the book cover-to-cover in one sitting. It is the thickness of a New York phone book. The Index at the back of the book is well done and is a good way to problem-solve individual issues.
1 Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
5 of 5 people found the following review helpful By M. Schechter on August 5, 2008
Format: Paperback Verified Purchase
The book seems well written, but not quite as detailed as I need. I see that I will need to buy the Using Word 2007 to get as much detail as I want. Still, this book gives a great overview of the whole suite and probably has a much info as most users will want.
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
4 of 4 people found the following review helpful By E. N. Abbott on March 19, 2008
Format: Paperback Verified Purchase
Every "Using" book I own (more than a dozen) has been valuable, well written and packed with good information. This is no exception. The authors know Office. I started with Word and quickly absorbed the "flavor" of the new interface. This book will cut my frustration time dramatically.
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
10 of 13 people found the following review helpful By George T. High on November 9, 2007
Format: Paperback
Microsoft Office 2007 Simplified

This is a book that is very easy to read. I have learned a lot about Office from reading it. I find that it is most useful as a reference book when I get in trouble.I have always solved the problem when I use it as a reference book.

George High
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again

Customer Images

Most Recent Customer Reviews

What Other Items Do Customers Buy After Viewing This Item?