List of Figures

A Tour of the Office 2007 User Interface

Figure I-1: When you click a command tab, the command sets that relate to that tab are displayed in the Ribbon.

Figure I-2: The set of commands displayed in the Ribbon varies depending on the command tab you select.

Figure I-3: Contextual tools provide you with additional options related to the selected object.

Figure I-4: Dialog launchers display some command sets in traditional dialog boxes.

Figure I-5: Click the More Columns option at the bottom of a gallery to display a dialog box of additional options.

Figure I-6: Galleries enable you to easily find and select the choice that’s right for your project.

Figure I-7: The new File menu includes a new design, new organization, and additional commands to expand the way you work with files.

Figure I-8: Switch between windows and change the view by using the commands in the View tab.

Chapter 1: Exploring Word 2007

Work in the Word environment, page 4. Display different views of a document, page 17. Preview and print a document, page 29.

Chapter 2: Editing and Proofreading Documents

Insert saved text, page 42. Find the most appropriate word, page 45. Reorganize a document outline, page 48. Find and replace text, page 51. Finalize a document, page 61.

Chapter 3: Changing the Look of Text

Quickly format text and paragraphs, page 68. Manually change the look of characters, page 70. Manually change the look of paragraphs, page 77. Create and modify lists, page 88.

Chapter 4: Presenting Information in Columns and Tables

Present information in columns, page 98. Present information in a table, page 104. Perform calculations in a table, page 116. Use a table to control page layout, page 124.

Chapter 5: Setting Up a Workbook

Create a workbook, page 134. Modify a workbook, page 138. Modify a worksheet, page 141. Customize the Excel 2007 program window, page 146.

Chapter 6: Working with Data and Data Tables

Enter data quickly, page 156. Move data within a workbook, page 160. Find and replace, workbook data, page 164. Verify and extend workbook data using proofing and reference tools, page 168. Organize data using tables, page 172.

Chapter 7: Performing Calculations on Data

Create formulas to calculate values, page 184. Name groups of data, page 180. Summarize data that meets specific conditions, page 191. Find and correct errors in calculations, page 195.

Chapter 8: Changing Document Appearance

Format a cell, page 206. Apply a workbook theme, page 216. Define styles, page 212. Make numbers easier to read, page 222. Change data’s appearance based on its value, page 226. Add an image to a document, page 233.

Chapter 9: Creating a Database

Create a database from a template, page 242. Create a table manually or by using a template, page 245. Manipulate table columns and rows, page 252.

Chapter 10: Simplifying Data Entry by Using Forms

Create a form, pages 258 and 283. Refine form properties, page 262. Add controls to a form, page 273. Change the arrangement of a form, page 268. Add a subform to a form, page 285.

Chapter 11: Locating Specific Information

Filter information by using a form, page 307. Perform calculations by using a query, page 328. Create a query manually, page 314. Create a query by using a wizard, page 324.

Chapter 12: Keeping Your Information Accurate

Create a lookup list, page 348. Prevent database problems, page 364. Restrict data by using validation rules, page 345. Restrict the type of data in a field, page 334.

Chapter 13: Starting a New Presentation

Quickly create a presentation, page 376. Convert an outline to a presentation, page 383. Reuse existing slides, page 385.

Chapter 14: Working with Slide Text

Add and manipulate text boxes, page 399. Correct and size text while typing, page 405. Check spelling and choose the best words, page 409. Change the size, alignment, spacing, and look of text, page 416.

Chapter 15: Adjusting the Slide Layout, Order, and Look

Change the layout of a slide, page 424. Apply a theme, page 429. Switch to a different color scheme, page 431. Add shading and texture to the background of a slide, page 436.

Chapter 16: Delivering a Presentation Electronically

Adapt a presentation for different audiences, page 442. Prepare speaker notes and handouts, page 450. Prepare a presentation for travel, page 455.

Chapter 17: Getting Started with Outlook 2007

Troubleshoot the Startup wizard, page 473. Connect to additional e-mail accounts, page 475. Personalize your Outlook workspace, page 483.

Chapter 18: Sending E-Mail Messages

Add signatures to messages automatically, page 528. Personalize the appearance of messages, page 522. Create and format business graphics, page 514.

Chapter 19: Managing Your Inbox

Organize messages by using color categories, page 553. Quickly locate messages, page 536. Arrange messages in different ways, page 540.

Chapter 20: Managing Appointments, Events, and Meetings

Work in the calendar item windows, page 568. Schedule, update, and cancel meetings, page 580. Schedule appointments and events, pages 574 and 578.

Chapter 21: Managing Your Calendar

Print a calendar, page 600. Link to an Internet calendar, page 608. Work with multiple calendars, page 611. Send calendar information in an e-mail message, page 604.