Special Edition Using Microsoft Office 2007

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