2007 Microsoft Office System Inside Out

Table of Contents

Acknowledgments; About the CD; What’s on the CD; Using the CD; System Requirements; Support Information; Conventions and Features Used in This Book; Text Conventions; Design Conventions; Chapter 1: Introduction; 1.1 Who This Book Is For; 1.2 How This Book Is Organized; Part 1: Getting Started; Chapter 1: Overview of the 2007 Microsoft Office System; 2.1 The New World of Work; 2.2 The New Microsoft Office User Interface; 2.3 The New Microsoft Office XML File Formats; 2.4 What Else Is New?; Chapter 2: The 2007 Office System User Interface: What’s Changed, What’s the Same; 3.1 A Quick Tour and Comparison; 3.2 The Ribbon and Command Tabs; 3.3 Customizing the Quick Access Toolbar; 3.4 The Microsoft Office Button and Menu; 3.5 Working in Context: More Tabs, Plus Some Menus and Toolbars; 3.6 Galleries and Live Preview; 3.7 Getting Help; Chapter 3: Managing Security and Privacy in the 2007 Office System; 4.1 Working in the Trust Center; 4.2 Setting Your Privacy Options; 4.3 Removing Hidden Data and Personal Information from Microsoft Office Documents; 4.4 Applying Information Rights Management; 4.5 Assigning a Password to a Document; 4.6 Avoiding Phishing Schemes; Part 2: Collaboration Essentials; Chapter 4: Collaborating and Sharing with Others; 5.1 Understanding and Using the 2007 Office System Collaboration Environments; 5.2 Creating and Using Shared Workspaces with Windows SharePoint Services; 5.3 Creating and Using Groove Workspaces; 5.4 Using Office OneNote 2007 as a Collaboration Tool; Chapter 5: Organizing and Finding Information in Microsoft Office OneNote; 6.1 Organizing a OneNote Notebook; 6.2 Adding Notes and Information to a Notebook; 6.3 Finding Your Information; 6.4 Using a Notebook on More Than One Computer; 6.5 Working as a Team with Office OneNote 2007; Chapter 6: Working as a Team in a Microsoft Office Groove Workspace; 7.1 Getting Started with Groove; 7.2 Setting Up a Groove Account; 7.3 The View from the Launchbar; 7.4 Groove Workspace Basics; 7.5 Outfitting a Groove Workspace with Tools; Chapter 7: Sharing and Communicating Using Microsoft Office Groove; 8.1 Setting Up and Using a File-Sharing Workspace; 8.2 Managing Groove Communications; 8.3 Working with Groove Contacts; 8.4 Introducing the Groove Forms Tool; 8.5 Managing Workspace Archives and Templates; Part 3: Word; Chapter 8: Mastering Page Setup and Pagination; 9.1 Basic Page Setup Options; 9.2 Changing Margins and Orientation; 9.3 Selecting a Paper Size and Source; 9.4 Controlling Page and Section Breaks; 9.5 Working with Varying Page Settings; 9.6 Including Headers and Footers; 9.7 Working with the Document Grid; 9.8 Adding and Controlling Line Numbers; Chapter 9: Outlining Documents for Clarity and Structure; 10.1 Outlining Enhancements in Word 2007; 10.2 Creative Outlining with Word 2007; 10.3 Eleven Reasons to Outline Your Next Complex Document; 10.4 Viewing a Document in Outline View; 10.5 Creating a New Outline; 10.6 Choosing Outline Display; 10.7 Working with Headings in Outline View; 10.8 Displaying Outline and Print Layout View at the Same Time; 10.9 Changing Your Outline; 10.10 Printing Your Outline; 10.11 Using the Document Map vs. Using Outline View; Chapter 10: Advanced Layout and Formatting; 11.1 Layout and Design Fundamentals; 11.2 Using Backgrounds and Watermarks; 11.3 Controlling Text Placement and Formatting with Text Boxes, Shapes, and Frames; 11.4 Configuring Word 2007 Layout Options; 11.5 Commanding Attention with Borders and Shading; 11.6 Adding a Simple Border; 11.7 Creating Enhanced Borders; 11.8 Creating Partial Borders; 11.9 Using a Page Border; 11.10 Adding Borders to Document Sections and Paragraphs; 11.11 Adjusting Border Spacing; 11.12 Inserting Graphical Horizontal Lines; 11.13 Adding Borders to Pictures; 11.14 Adding Table Borders; 11.15 Applying Shading Behind Content; Chapter 11: Revising Documents Using Markup Tools; 12.1 Benefits of an Organized Revision Process; 12.2 Familiarizing Yourself with Markup Tools; 12.3 Using the Highlight Tool; 12.4 Adding and Managing Comments Effectively; 12.5 Tracking Changes; 12.6 Comparing and Combining Documents; Part 4: Excel; Chapter 12: How to Work a Worksheet and a Workbook; 13.1 Moving Around Regions; 13.2 Understanding Selection; 13.3 Techniques for Entering Data; 13.4 Managing Worksheets; 13.5 Viewing Worksheets; 13.6 Protecting Worksheets; 13.7 Managing Multiple Workbooks; 13.8 Opening Multiple Windows for the Same Workbook; 13.9 Hiding and Protecting Workbooks; Chapter 13: Building Formulas; 14.1 Formula Fundamentals; 14.2 Using Functions: A Preview; 14.3 Working with Foooooormulas; 14.4 Worksheet Calculation; 14.5 Using Arrays; 14.6 Linking Workbooks; 14.7 Creating Conditional Tests; Chapter 14: Using Functions; 15.1 Using the Built-In Function Reference in Excel; 15.2 Exploring the Syntax of Functions; 15.3 Inserting Functions; 15.4 Understanding Mathematical Functions; 15.5 Understanding Text Functions; 15.6 Understanding Logical Functions; 15.7 Understanding Information Functions; 15.8 Understanding Lookup and Reference Functions; Chapter 15: Analyzing Data with PivotTable Reports; 16.1 Introducing PivotTables; 16.2 Creating a PivotTable; 16.3 Rearranging PivotTable Fields; 16.4 Refreshing a PivotTable; 16.5 Changing the Numeric Format of PivotTable Data; 16.6 Choosing Report Layout Options; 16.7 Formatting a PivotTable; 16.8 Displaying Totals and Subtotals; 16.9 Sorting PivotTable Fields; 16.10 Filtering PivotTable Fields; 16.11 Changing PivotTable Calculations; 16.12 Grouping and Ungrouping Data; 16.13 Displaying the Details Behind a Data Value; 16.14 Creating PivotCharts; Part 5: PowerPoint; Chapter 16: Introduction to PowerPoint 2007; 17.1 Command Locations; 17.2 Customizing Office PowerPoint 2007; 17.3 File Formats; 17.4 Formatting; 17.5 PowerPoint 2007 Views; 17.6 Themes; 17.7 Tables; 17.8 Custom Slide Layouts; 17.9 PowerPoint 2007 Slide Libraries; 17.10 Program Recovery; Chapter 17: Working with Text; 18.1 Adding a Text Box to a Slide; 18.2 Finding and Replacing Words or Phrases; 18.3 Creating and Saving Customized Theme Fonts; 18.4 Formatting with WordArt; 18.5 Adding Punch to Your Bulleted Lists; 18.6 Writing on Slides During a Presentation; 18.7 Using Headers and Footers; 18.8 Working with Proofing Tools; Chapter 18: Working with Objects, Diagrams, and Charts in PowerPoint 2007; 19.1 Working with Pictures; 19.2 Adding Clip Art; 19.3 Using SmartArt; 19.4 Adding Sounds; 19.5 Including Movies; 19.6 Playing with Animations; 19.7 Animating SmartArt Graphics; 19.8 Creating Charts and Diagrams; Chapter 19: Collaborating and Sharing; 20.1 Using Templates; 20.2 Working with Windows SharePoint Services; 20.3 Reviewing, Approving, and Tracking Changes; 20.4 Protecting Your Document; 20.5 Securing Your Presentation; 20.6 Using the Document Inspector; Chapter 20: Working with External Data in PowerPoint 2007; 21.1 Working with Earlier Versions of PowerPoint; 21.2 Working with Excel 2007; 21.3 Working with Access 2007; 21.4 Blocking and Unblocking External Content; 21.5 Using Trusted Locations; 21.6 Setting Up Security Alerts and Trusted Publishers; Chapter 21: Setting Up and Presenting a Slide Show; 22.1 Learning the Basics; 22.2 Creating Custom Slide Shows; 22.3 Adding Transitions; 22.4 Using Presenter View; 22.5 Working with Photo Albums; 22.6 Exploring Printing Options; Part 6: Outlook; Chapter 22: Introducing Outlook 2007; 23.1 A New Interface; 23.2 Instant Search; 23.3 Calendar Changes; 23.4 E-Mail Changes; 23.5 Color Categories; 23.6 Collaboration and Sharing Improvements; 23.7 Overview of Outlook 2007 Capabilities; 23.8 How Outlook Stores Data; 23.9 Understanding Messaging Protocols; 23.10 Security Provisions in Outlook; 23.11 Options for Starting Outlook; Chapter 23: Finding and Organizing Messages; 24.1 Finding and Organizing Messages with Search Folders; 24.2 Flagging and Monitoring Messages and Contacts; 24.3 Grouping Messages by Customizing the Folder View; 24.4 Filtering a View Using Categories; 24.5 Managing E-Mail Effectively; Chapter 24: Securing Your System, Messages, and Identity; 25.1 Configuring HTML Message Handling; 25.2 Protecting Messages with Digital Signatures; 25.3 Signing Messages; 25.4 Encrypting Messages; 25.5 Protecting Data with Information Rights Management; Chapter 25: Collaboration with Outlook and Windows SharePoint Services; 26.1 Understanding Windows SharePoint Services Collaboration; 26.2 Setting Up Alerts; 26.3 Working with Shared Documents; 26.4 Working with Shared Contacts; 26.5 Linking a Team Calendar to Outlook; 26.6 Configuring Alerts in Outlook; 26.7 Using Outlook to Work with SharePoint Libraries and Files; Part 7: Access; Chapter 26: Exploring the New Look of Access 2007; 27.1 Opening Access for the First Time; 27.2 Getting Started—A New Look for Access; 27.3 Understanding Content Security; 27.4 Understanding the New Ribbon Feature; 27.5 Understanding the New Navigation Pane; 27.6 Using the Single-Document vs. Multiple-Document Interface; 27.7 Modifying Global Settings via the Access Options Dialog Box; Chapter 27: Creating Your Database and Tables; 28.1 Creating a New Database; 28.2 Creating Your First Simple Table by Entering Data; 28.3 Creating a Table Using a Table Template; 28.4 Creating a Table in Design View; 28.5 Defining Fields; 28.6 Defining a Primary Key; 28.7 Defining a Table Validation Rule; 28.8 Understanding Other Table Properties; 28.9 Defining Relationships; 28.10 Adding Indexes; 28.11 Setting Table Design Options; 28.12 Creating a Default Template for New Databases; 28.13 Printing a Table Definition; 28.14 Database Limitations; Chapter 28: Creating and Working with Simple Queries; 29.1 Selecting Data from a Single Table; 29.2 Testing Validation Rule Changes; 29.3 Working in Query Datasheet View; Chapter 29: Building a Form; 30.1 Forms and Object-Oriented Programming; 30.2 Starting from Scratch—A Simple Input Form; 30.3 Working with Quick Create Commands and the Form Wizard; 30.4 Simplifying Data Input with a Form; Chapter 30: Constructing a Report; 31.1 Starting from Scratch—A Simple Report; 31.2 Using the Report Command; 31.3 Using the Report Wizard; 31.4 Building a Report in Layout View; Part 8: Microsoft Office Programming Primer; Chapter 31: VBA Primer; 32.1 When and Why to Use VBA; 32.2 Introduction to the VBA Language and Code Structure; 32.3 Understanding and Using the Visual Basic Editor; 32.4 Writing, Editing, and Sharing Simple Macros; 32.5 Using VBA to Save Time on Document Production and Troubleshooting; 32.6 Introduction to Using Events; 32.7 Creating UserForms (Dialog Boxes); 32.8 Next Steps for Working with Automation in Microsoft Office; Chapter 32: Office Open XML Essentials; 33.1 Chapter Assumptions; 33.2 XML Basics for Reading Your Documents; 33.3 Getting to Know the Office Open XML Formats; 33.4 Editing and Managing Documents Through XML; 33.5 Customizing the Ribbon; 33.6 Binding Data to Content Controls; 33.7 Next Steps for Working with the Office Open XML Formats; Appendix: Installing and Configuring the 2007 Office System; Installing the Microsoft Office System from the CD; Changing Your 2007 Office System Setup; Index to Troubleshooting Topics; About the Authors; Choose the Right Book for You;