Office 2007: The Missing Manual

The Missing Credits; About the Author; About the Creative Team; Acknowledgements; The Missing Manual Series; Introduction; What's New in Office 2007; The Very Basics; About This Book; Part I: Word 2007; Chapter 1: Creating, Opening, and Saving Documents; 1 What Word Does; 2 Launching Word; 3 Creating a New Document; 4 Opening an Existing Document; 5 Your Different Document Views; 6 Saving and Closing Documents; Chapter 2: Entering and Editing Text; 1 Typing in Word; 2 Selecting Text; 3 Cutting, Copying, and Pasting; 4 Finding and Replacing Text; 5 Saving Keystrokes with Quick Parts; Chapter 3: Formatting Text, Paragraphs, and Headings; 1 Formatting Basics; 2 Formatting Characters; 3 Formatting Paragraphs; 4 Creating Bulleted and Numbered Lists; 5 Setting Tabs; 6 Using Word's Rulers; 7 Fast Formatting with Format Painter; 8 Formatting with Styles; 9 Modifying Styles; 10 Managing Style Sets; Chapter 4: Setting Up the Document; 1 Choosing Paper Size and Layout; 2 Setting Document Margins; 3 Applying Page Borders; 4 Adding Headers and Footers; 5 Working with Multiple Columns; 6 Hyphenation; 7 Dividing Your Document into Sections; Chapter 5: Themes and Templates; 1 Choosing a Theme; 2 Choosing a Template; Chapter 6: Spelling, Grammar, and Reference Tools; 1 Turning on Spelling and Grammar Checking; 2 Checking Spelling; 3 Checking Grammar and Style; 4 Controlling AutoCorrect; 5 Exploring Word's Research Tools; 6 Accessing Word's Thesaurus; 7 Translating Text; 8 Checking Your Word Count; Chapter 7: Printing Word Documents; 1 Quick and Easy Printing; 2 Print Preview; 3 Choosing a Printer; 4 Printing to an Adobe PDF File; 5 Faxing with Word; 6 Changing Print Settings; 7 Printing Envelopes; 8 Printing Labels; 9 >Setting Print Options; Chapter 8: Planning with Outlines; 1 Switching to Outline View; 2 Promoting and Demoting Headings; 3 Moving Outline Items; 4 Showing Parts of Your Outline; Part II: Excel 2007; Chapter 9: Creating and Navigating Worksheets; 1 What You Can Do with Excel; 2 Excel's New Features; 3 Creating a Basic Worksheet; 4 Editing Data; 5 Navigating in Excel; 6 Saving Files; 7 Opening Files; Chapter 10: Adding Information to Worksheets; 1 Adding Different Types of Data; 2 Quick Ways to Add Data; Chapter 11: Moving Data Around a Worksheet; 1 Selecting Cells; 2 Moving Cells Around; 3 Adding and Moving Columns or Rows; Chapter 12: Managing Worksheets and Workbooks; 1 Worksheets and Workbooks; 2 Find and Replace; 3 Spell Check; Chapter 13: Formatting Cells; 1 Formatting Cell Values; 2 Formatting Cell Appearance; Chapter 14: Viewing and Printing Worksheets; 1 Controlling Your View; 2 Printing; 3 Controlling Pagination; Chapter 15: Building Basic Formulas; 1 Creating a Basic Formula; 2 Formula Shortcuts; 3 Copying Formulas; Chapter 16: Tables and Charts; 1 The Basics of Tables; 2 Sorting and Filtering a Table; 3 Charting 101; Part III: PowerPoint 2007; Chapter 17: Creating a Basic Presentation; 1 What You Can Do with PowerPoint 2007; 2 What's New in PowerPoint 2007; 3 Beginning a New Presentation; 4 Choosing a Theme for Your Presentation; 5 Adding Text; 6 Adding More Slides; 7 Moving Around Inside a Presentation; Chapter 18: Editing Slides; 1 Editing Text; 2 Reversing an Action (Undo); 3 Finding and Replacing Text Automatically; 4 Checking Spelling; 5 Adding Special Characters; Chapter 19: Formatting and Aligning Your Text; 1 Automating Text Formatting; 2 Manually Formatting Text Appearance; 3 Manually Aligning and Indenting Text; 4 Formatting Text Boxes; Chapter 20: Formatting and Laying Out Your Slides; 1 Changing Slide Layout; 2 Changing Background Color; 3 Reapplying Themes, Colors, and Fonts; Chapter 21: Editing Your Slideshow; 1 Viewing Multiple Slides; 2 Adding, Deleting, and Moving Slides; 3 Inserting Slides from Other Slideshows; 4 Editing Slide and Layout Masters; 5 Adding Headers and Footers; Chapter 22: Adding Charts, Diagrams, and Tables; 1 Creating Charts; 2 Creating Diagrams; 3 Creating Tables; Chapter 23: Delivering Presentations; 1 Setting Up a Slideshow; 2 Slideshows for Multiple Audiences; 3 Presenting Your Slideshow; 4 Creating PowerPoint Shows; 5 Emailing Your Presentation; 6 Packaging Presentations for CD; Chapter 24: Printing Presentations; 1 Printing Slides (One Slide per Page); 2 Handouts (Multiple Slides per Page); 3 Overhead Transparencies; 4 Speaker Notes; 5 Presentation Outline; Chapter 25: Images and Transitions; 1 Drawing on Slides; 2 Adding Pictures ffrommmmm Other Programs; 3 Slide Transitions; Part IV: Access 2007; Chapter 26: Creating Your First Database; 1 What You Can Do with Access; 2 Understanding Access Databases; 3 Getting Started; 4 Saving and Opening Access Databases; 5 The Navigation Pane; Chapter 27: Building Smarter Tables; 1 Understanding Data Types; 2 Design View; 3 Access Data Types; 4 The Primary Key; 5 Six Principles of Database Design; Chapter 28: Mastering the Datasheet; 1 Datasheet Customization; 2 Datasheet Navigation; 3 Printing the Datasheet; Chapter 29: Blocking Bad Data; 1 Data Integrity Basics; 2 Input Masks; 3 Validation Rules; 4 Lookups; Chapter 30: Linking Tables with Relationships; 1 Relationship Basics; 2 Using a Relationship; Chapter 31: Queries: Reusable Searches; 1 Query Basics; 2 Creating Queries; 3 Understanding Action Queries; Chapter 32: Creating Reports; 1 Report Basics; 2 Printing, Previewing, and Exporting a Report; 3 Formatting a Report; 4 Filtering and Sorting a Report; Chapter 33: Creating Simple Forms; 1 Form Basics; 2 Sorting and Filtering in a Form; 3 The Form Wizard; Chapter 34: Importing and Exporting Data; 1 The Case for Importing and Exporting; 2 Using the Clipboard; 3 Import and Export Operations; Part V: Appendixes; Appendix A: Customizing the Quick Access Toolbar; 1 The Quick Access Toolbar; Appendix B: Getting Help; 1 Using Office 2007's Built-in Help; 2 Using Microsoft's Office Web Site; 3 Third-Party Web Sites; Colophon;