2007 Microsoft Office System Step By Step 2nd Edition,

Description

The smart way to learn Microsoft Office-one step at a time! The second edition of this popular book features new and expanded content. In addition to covering familiar Microsoft Office applications such as Microsoft Office Access™ 2007, Excel(R) 2007, Outlook(R) 2007, PowerPoint(R) 2007, and Word 2007-you now also get coverage of Microsoft Office Publisher 2007, SharePoint(R) Server 2007, Groove(R) 2007, OneNote(R) 2007, and InfoPath(R) 2007. Work at your own pace through the easy numbered steps, practice files on CD, helpful hints, and troubleshooting help to learn the fundamentals of working with the 2007 Microsoft Office system, including how to navigate the new user interface. Learn how to create professional-quality documents, powerful spreadsheets, and compelling slide presentations. And discover how to get your Web site up and running, take notes electronically, and manage your e-mail communications and workday. The companion CD includes skill-building practice files, eBooks, and more. With STEP BY STEP, you can take just the lessons you need or work from cover to cover. Either way, you drive the instruction-building and practicing the skills you need, just when you need them!

A Note Regarding the CD or DVD

The print version of this book ships with a CD or DVD. For those customers purchasing one of the digital formats in which this book is available, we are pleased to offer the CD/DVD content as a free download via OReilly Medias Digital Distribution services. To download this content, please visit OReillys web site, search for the title of this book to find its catalog page, and click on the link below the cover image (Examples, Companion Content, or Practice Files). Note that while we provide as much of the media content as we are able via free download, we are sometimes limited by licensing restrictions. Please direct any questions or concerns to booktech@oreilly.com.

CONTENTS:

Your All-in-One Resource; Introducing the 2007 Microsoft Office System; The Microsoft Office Fluent User Interface; Certification; Information for Readers Running Windows XP; Managing the Practice Files; Using the Start Menu; Navigating Dialog Boxes; Features and Conventions of This Book; Using the Companion CD; What’s on the CD?; Minimum System Requirements; Installing the Practice Files; Using the Practice Files; Removing and Uninstalling the Practice Files; Getting Help; Getting Help with This Book and Its Companion CD; Getting Help with an Office Program; More Information; About the Authors; Joyce Cox; Curtis Frye; M. Dow Lambert III; Steve Lambert; John Pierce; Joan Preppernau; Online Training Solutions, Inc. (OTSI); Quick Reference; Part I Microsoft Office Word 2007; Part II Microsoft Office Excel 2007; Part III Microsoft Office Access 2007; Part IV Microsoft Office PowerPoint 2007; Part V Microsoft Office Outlook 2007; Part VI Microsoft Office Publisher 2007; Part VII Microsoft Office OneNote 2007; Part VIII Microsoft Office Groove 2007; Part IX Collaboration; Microsoft Office Word 2007; Chapter 1: Exploring Word 2007; 1.1 Working in the Word Environment; 1.2 Opening, Moving Around in, and Closing a Document; 1.3 Displaying Different Views of a Document; 1.4 Creating and Saving a Document; 1.5 Previewing and Printing a Document; 1.6 Key Points; Chapter 2: Editing and Proofreading Documents; 2.1 Making Changes to a Document; 2.2 Inserting Saved Text; 2.3 Finding the Most Appropriate Word; 2.4 Reorganizing a Document Outline; 2.5 Finding and Replacing Text; 2.6 Correcting Spelling and Grammatical Errors; 2.7 Finalizing a Document; 2.8 Key Points; Chapter 3: Changing the Look of Text; 3.1 Quickly Formatting Text and Paragraphs; 3.2 Manually Changing the Look of Characters; 3.3 Manually Changing the Look of Paragraphs; 3.4 Creating and Modifying Lists; 3.5 Key Points; Chapter 4: Presenting Information in Columns and Tables; 4.1 Presenting Information in Columns; 4.2 Creating a Tabular List; 4.3 Presenting Information in a Table; 4.4 Formatting Table Information; 4.5 Performing Calculations in a Table; 4.6 Using a Table to Control Page Layout; 4.7 Key Points; Microsoft Office Excel 2007; Chapter 5: Setting Up a Workbook; 5.1 Creating Workbooks; 5.2 Modifying Workbooks; 5.3 Modifying Worksheets; 5.4 Customizing the Excel 2007 Program Window; 5.5 Key Points; Chapter 6: Working with Data and Data Tables; 6.1 Entering and Revising Data; 6.2 Moving Data Within a Workbook; 6.3 Finding and Replacing Data; 6.4 Correcting and Expanding Upon Worksheet Data; 6.5 Defining a Table; 6.6 Key Points; Chapter 7: Performing Calculations on Data; 7.1 Naming Groups of Data; 7.2 Creating Formulas to Calculate Values; 7.3 Summarizing Data That Meets Specific Conditions; 7.4 Finding and Correcting Errors in Calculations; 7.5 Key Points; Chapter 8: Changing Workbook Appearance; 8.1 Formatting Cells; 8.2 Defining Styles; 8.3 Applying Workbook Themes and Table Styles; 8.4 Making Numbers Easier to Read; 8.5 Changing the Appearance of Data Based on Its Value; 8.6 Adding Images to Documents; 8.7 Key Points; Microsoft Office Access 2007; Chapter 9: Creating a Database; 9.1 Creating a Database from a Template; 9.2 Creating a Table Manually; 9.3 Creating a Table from a Template; 9.4 Manipulating Table Columns and Rows; 9.5 Key Points; Chapter 10: Simplifying Data Entry by Using Forms; 10.1 Creating a Form by Using the Form Tool; 10.2 Refining Form Properties; 10.3 Changing the Arrangement of a Form; 10.4 Adding Controls to a Form; 10.5 Entering Data in a Form by Using VBA; 10.6 Creating a Form by Using an AutoForm; 10.7 Adding a Subform to a Form; 10.8 Key Points; Chapter 11: Locating Specific Information; 11.1 Sorting Information in a Table; 11.2 Filtering Information in a Table; 11.3 Filtering Information by Using a Form; 11.4 Locating Information That Matches Multiple Criteria; 11.5 Creating a Query Manually; 11.6 Creating a Query by Using a Wizard; 11.7 Performing Calculations by Using a Query; 11.8 Key Points; Chapter 12: Keeping Your Information Accurate; 12.1 Restricting the Type of Data in a Field; 12.2 Restricting the Amount of Data in a Field; 12.3 Specifying the Format of Data in a Field; 12.4 Restricting Data by Using Validation Rules; 12.5 Creating a Simple Lookup List; 12.6 Creating a Multi-Column Lookup List; 12.7 Updating Information in a Table; 12.8 Deleting Information from a Table; 12.9 Preventing Database Problems; 12.10 Key Points; Microsoft Office PowerPoint 2007; Chapter 13: Starting a New Presentation; 13.1 Quickkkkkkly Creating a Presentation; 13.2 Creating a Presentation Based on a Ready-Made Design; 13.3 Converting an Outline to a Presentation; 13.4 Reusing Existing Slides; 13.5 Key Points; Chapter 14: Working with Slide Text; 14.1 Entering Text; 14.2 Editing Text; 14.3 Adding and Manipulating Text Boxes; 14.4 Correcting and Sizing Text While Typing; 14.5 Checking Spelling and Choosing the Best Words; 14.6 Finding and Replacing Text and Fonts; 14.7 Changing the Size, Alignment, Spacing, and Look of Text; 14.8 Key Points; Chapter 15: Adjusting the Layout, Order, and Look of Slides; 15.1 Changing the Layout of a Slide; 15.2 Rearranging Slides in a Presentation; 15.3 Applying a Theme; 15.4 Switching to a Different Color Scheme; 15.5 Using Colors That Are Not Part of the Scheme; 15.6 Adding Shading and Texture to the Background of a Slide; 15.7 Key Points; Chapter 16: Delivering a Presentation Electronically; 16.1 Adapting a Presentation for Different Audiences; 16.2 Rehearsing a Presentation; 16.3 Preparing Speaker Notes and Handouts; 16.4 Preparing a Presentation for Travel; 16.5 Showing a Presentation; 16.6 Key Points; Microsoft Office Outlook 2007; Chapter 17: Sending E-Mail Messages; 17.1 Working in the Message Window; 17.2 Creating and Sending Messages; 17.3 Attaching Files to Messages; 17.4 Creating and Formatting Business Graphics; 17.5 Personalizing the Appearance of Messages; 17.6 Adding Signatures to Messages Automatically; 17.7 Key Points; Chapter 18: Managing Your Inbox; 18.1 Quickly Locating Messages; 18.2 Arranging Messages in Different Ways; 18.3 Organizing Messages by Using Color Categories; 18.4 Organizing Messages in Folders; 18.5 Archiving Messages; 18.6 Key Points; Chapter 19: Managing Appointments, Events, and Meetings; 19.1 Working in the Calendar Item Windows; 19.2 Scheduling and Changing Appointments; 19.3 Scheduling and Changing Events; 19.4 Scheduling, Updating, and Canceling Meetings; 19.5 Responding to Meeting Requests; 19.6 Key Points; Chapter 20: Managing Your Calendar; 20.1 Displaying Different Views of a Calendar; 20.2 Defining Your Available Time; 20.3 Configuring Outlook for Multiple Time Zones; 20.4 Printing a Calendar; 20.5 Sending Calendar Information in an E-Mail Message; 20.6 Linking to an Internet Calendar; 20.7 Working with Multiple Calendars; 20.8 Key Points; Microsoft Office Publisher 2007; Chapter 21: Creating Colorful Cards and Calendars; 21.1 Storing Personal and Company Information; 21.2 Creating Folded Cards; 21.3 Creating Postcards; 21.4 Creating Calendars; 21.5 Packaging Publications for Printing; 21.6 Key Points; Chapter 22: Creating Text-Based Publications; 22.1 Planning Longer Publications; 22.2 Creating Newsletters; 22.3 Organizing Content; 22.4 Editing and Proofing Content; 22.5 Key Points; Microsoft Office OneNote 2007; Chapter 23: Collecting Information in a Notebook; 23.1 Understanding Notebooks; 23.2 Understanding Note Containers; 23.3 Entering Content Directly onto a Page; 23.4 Sending Content to OneNote; 23.5 Capturing Audio and Video Notes; 23.6 Quickly Capturing Notes; 23.7 Key Points; Chapter 24: Organizing and Locating Information; 24.1 Moving and Removing Information; 24.2 Tagging Notes; 24.3 Searching for Information; 24.4 Key Points; Microsoft Office Groove 2007; Chapter 25: Setting Up a Standard Workspace; 25.1 Creating a Standard Workspace; 25.2 Sending and Accepting Workspace Invitations; 25.3 Working in the Workspace Members Pane; 25.4 Changing the Role of a Workspace Member; 25.5 Changing Permissions Assigned to a Workspace Role; 25.6 Exploring a Groove Workspace; 25.7 Adding Files to the Files Tool; 25.8 Adding a Tool to a Standard Workspace; 25.9 Key Points; Chapter 26: Managing and Sharing Files; 26.1 Adding Folders and Files to the Files Tool; 26.2 Working with Files in the Files Tool; 26.3 Opening, Editing, and Saving a File in the Files Tool; 26.4 Specifying Download Settings for a Folder; 26.5 Setting Permissions in the Files Tool; 26.6 Specifying Alert Settings for Folders and Files; 26.7 Creating a File Sharing Workspace; 26.8 Downloading Files in a File Sharing Workspace; 26.9 Changing Roles and Permissions for a File Sharing Workspace; 26.10 Setting Properties for a File Sharing Workspace; 26.11 Key Points; Collaboration; Chapter 27: Enabling Collaboration by Using SharePoint; 27.1 Creating a SharePoint Team Site; 27.2 Creating a Document Library; 27.3 Managing Files in a Document Library; 27.4 Checking Files Into and Out of a Document Library; 27.5 Creating a Custom List from an Excel Workbook; 27.6 Working with SharePoint List Data in Access; 27.7 Creating a Document Workspace from an Office Document; 27.8 Creating a Document Workspace from Outlook; 27.9 Working Offline with Document Library Contents; 27.10 Linking a SharePoint Calendar to Outlook; 27.11 Key Points; Glossary;