Product Description

Special Edition Using Microsoft® Office 2007

THE ONLY OFFICE BOOK YOU NEED

We crafted this book to grow with you, providing the reference material you need as you move toward Office proficiency and use of more advanced features. If you buy only one book on Office 2007, Special Edition Using Microsoft® Office 2007 is the only book you need.

If you own a copy of Office 2007, you deserve a copy of this book! Although this book is aimed at the Office veteran, Ed and Woody’s engaging style will appeal to beginners, too. Written in clear, plain English, readers will feel as though they are learning from real humans and not Microsoft clones. Sprinkled with a wry sense of humor and an amazing depth of field, this book most certainly isn’t your run-of-the-mill computer book. You should expect plenty of hands-on guidance and deep but accessible reference material.

This isn’t your Dad’s Office! For the first time in a decade, Microsoft has rolled out an all-new user interface. Menus? Gone. Toolbars? Gone. For the core programs in the Office family, you now interact with the program using the Ribbon–an oversize strip of icons and commands, organized into multiple tabs, that takes over the top of each program’s interface. If your muscles have memorized Office menus, you’ll have to unlearn a lot of old habits for this version.

Ed Bott is an award-winning computer journalist and one of the most widely recognized voices in the computing world, with nearly two decades of experience as a writer and editor at leading magazines, such as PC World, PC Computing, and Smart Business. Ed has written many of Que’s all-time bestsellers, including Special Edition Using Office 2000, Special Edition Using Windows 98, and Special Edition Using Windows Me.

Curmudgeon, critic, and perennial “Office Victim,” Woody Leonhard runs the fiercely independent AskWoody.com website with up-to-the-nanosecond news, observations, tips and help for both Office and Windows. 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.

Introduction

I Common Tasks and Features

1 Getting Started with Office 2007 . . . . . . . . . . . . . . . . . . . . 9

2 Using and Customizing the Office 2007 Interface . . 27

3 Managing Office Files and Formats . . . . . . . . . . . . . . . . 53

4 Creating, Editing, and Formatting Documents . . . . . 75

5 Creating, Editing, and Using Pictures and Graphics . . . 103

6 Sharing and Reviewing Office Files . . . . . . . . . . . . . . . 135

7 Office Security and Privacy . . . . . . . . . . . . . . . . . . . . . . . . 159

II Using Outlook

8 Outlook Essentials . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 177

9 Reading, Writing, and Organizing Email . . . . . . . . . . 219

10 Keeping Your Contacts List Under Control . . . . . . . 259

11 Working with Calendars and Tasks . . . . . . . . . . . . . . . 277

12 Outlook Security and Privacy . . . . . . . . . . . . . . . . . . . . . . 307

III Using Word

13 Building a Better Word Document . . . . . . . . . . . . . . . . 329

14 Using Themes, Styles, and Templates . . . . . . . . . . . . 387

15 Advanced Document Formatting . . . . . . . . . . . . . . . . . . 415

16 Professional Document Tools and Advanced Document Sharing . . . . . . . 455

17 Letters, Envelopes, and Data-Driven Documents . . . . . . . . .477

IV Using Excel

18 Building a Better Workbook . . . . . . . . . . . . . . . . . . . . . . . 507

19 Advanced Worksheet Formatting . . . . . . . . . . . . . . . . . 553

20 Using Formulas and Functions . . . . . . . . . . . . . . . . . . . . 593

21 Organizing Data with Tables and PivotTables . . . . 627

22 Creating and Editing Charts . . . . . . . . . . . . . . . . . . . . . . . 665

V Using PowerPoint

23 Building a Perfect Presentation . . . . . . . . . . . . . . . . . . . 703

24 Advanced Presentation Formatting . . . . . . . . . . . . . . . 737

25 Adding Graphics, Multimedia, and Special Effects . . . . . .759

26 Planning and Delivering a Presentation . . . . . . . . . . 779

VI Other Office Applications

27 Publisher Essentials . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 797

28 Access Essentials . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 835

29 Using OneNote . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 879

30 Using Office 2007 on a Corporate Network . . . . . 907

VII Appendixes

A Advanced Setup Options . . . . . . . . . . . . . . . . . . . . . . . . . . 929

B Macros and Add-Ins . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 943

C Using Office on a Tablet PC . . . . . . . . . . . . . . . . . . . . . . . 961

Index . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 969

Product Details

• Amazon Sales Rank: #70952 in Books
• Published on: 2007-01-02
• Original language: English
• Number of items: 1
• Binding: Paperback
• 1056 pages

From the Back Cover

Special Edition Using Microsoft® Office 2007

THE ONLY OFFICE BOOK YOU NEED

We crafted this book to grow with you, providing the reference material you need as you move toward Office proficiency and use of more advanced features. If you buy only one book on Office 2007, Special Edition Using Microsoft® Office 2007 is the only book you need.

If you own a copy of Office 2007, you deserve a copy of this book! Although this book is aimed at the Office veteran, Ed and Woody’s engaging style will appeal to beginners, too. Written in clear, plain English, readers will feel as though they are learning from real humans and not Microsoft clones. Sprinkled with a wry sense of humor and an amazing depth of field, this book most certainly isn’t your run-of-the-mill computer book. You should expect plenty of hands-on guidance and deep but accessible reference material.

This isn’t your Dad’s Office! For the first time in a decade, Microsoft has rolled out an all-new user interface. Menus? Gone. Toolbars? Gone. For the core programs in the Office family, you now interact with the program using the Ribbon–an oversize strip of icons and commands, organized into multiple tabs, that takes over the top of each program’s interface. If your muscles have memorized Office menus, you’ll have to unlearn a lot of old habits for this version.

Ed Bott is an award-winning computer journalist and one of the most widely recognized voices in the computing world, with nearly two decades of experience as a writer and editor at leading magazines, such as PC World, PC Computing, and Smart Business. Ed has written many of Que’s all-time bestsellers, including Special Edition Using Office 2000, Special Edition Using Windows 98, and Special Edition Using Windows Me.

Curmudgeon, critic, and perennial “Office Victim,” Woody Leonhard runs the fiercely independent AskWoody.com website with up-to-the-nanosecond news, observations, tips and help for both Office and Windows. 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.

Introduction

I Common Tasks and Features

1 Getting Started with Office 2007 . . . . . . . . . . . . . . . . . . . . 9

2 Using and Customizing the Office 2007 Interface . . 27

3 Managing Office Files and Formats . . . . . . . . . . . . . . . . 53

4 Creating, Editing, and Formatting Documents . . . . . 75

5 Creating, Editing, and Using Pictures and Graphics . . . 103

6 Sharing and Reviewing Office Files . . . . . . . . . . . . . . . 135

7 Office Security and Privacy . . . . . . . . . . . . . . . . . . . . . . . . 159

II Using Outlook

8 Outlook Essentials . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 177

9 Reading, Writing, and Organizing Email . . . . . . . . . . 219

10 Keeping Your Contacts List Under Control . . . . . . . 259

11 Working with Calendars and Tasks . . . . . . . . . . . . . . . 277

12 Outlook Security and Privacy . . . . . . . . . . . . . . . . . . . . . . 307

III Using Word

13 Building a Better Word Document . . . . . . . . . . . . . . . . 329

14 Using Themes, Styles, and Templates . . . . . . . . . . . . 387

15 Advanced Document Formatting . . . . . . . . . . . . . . . . . . 415

16 Professional Document Tools and Advanced Document Sharing . . . . . . . 455

17 Letters, Envelopes, and Data-Driven Documents . . . . . . . . .477

IV Using Excel

18 Building a Better Workbook . . . . . . . . . . . . . . . . . . . . . . . 507

19 Advanced Worksheet Formatting . . . . . . . . . . . . . . . . . 553

20 Using Formulas and Functions . . . . . . . . . . . . . . . . . . . . 593

21 Organizing Data with Tables and PivotTables . . . . 627

22 Creating and Editing Charts . . . . . . . . . . . . . . . . . . . . . . . 665

V Using PowerPoint

23 Building a Perfect Presentation . . . . . . . . . . . . . . . . . . . 703

24 Advanced Presentation Formatting . . . . . . . . . . . . . . . 737

25 Adding Graphics, Multimedia, and Special Effects . . . . . .759

26 Planning and Delivering a Presentation . . . . . . . . . . 779

VI Other Office Applications

27 Publisher Essentials . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 797

28 Access Essentials . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 835

29 Using OneNote . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 879

30 Using Office 2007 on a Corporate Network . . . . . 907

VII Appendixes

A Advanced Setup Options . . . . . . . . . . . . . . . . . . . . . . . . . . 929

B Macros and Add-Ins . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 943

C Using Office on a Tablet PC . . . . . . . . . . . . . . . . . . . . . . . 961

Index . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 969

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.

Customer Reviews

You need this book!
I have for many years used the predecessor book on Office 2000 and found it invaluable. I am using the new edition to aid the move to Office 2007, and am finding it essential. Everything in Office has moved, the menus have essentially gone, and what used to be simple is hell to manage unless you know which way to go. And in case you haven't guessed it, the help screens that come with Office 2007 are seriously inadequate.

This book has shown me the answers I want first time 75% of the time and with a bit of digging 90% of the time.

Does what it says on the tin.
A really good book covering all the Microsoft Office products - some in more detail than others. The explanations are good and there's a lot covered. Screenshots are shown throughout the book though they're in black and white, but that's the only drawback. If anything, there's too much detail at times but it's a great reference and I'm pleased I bought it. The book itself is just over a thousand pages so it's hardly something you'd pop in your laptop bag. I used a scalpel to `slice' it into its various components then used a binding machine and comb binders to create six different books of manageable size (roughly 150 to 200 pages each) which lay flat when you open them. That means you only need to carry details of the product that's relevant and each `book' was as cheap as chips. Why buy something on individual products when you can get it all in one for less than £20?

Help for Office 2007
Useful book. Recently upgraded to 2007 and lost as to where to find some of the features I was used to in 2003. This book is a good help in getting used to the new format and where to find the features I need most.