'Skills for Success' is the Microsoft Office textbook that recognises how students learn today!

Table of Contents:
Introduction   Start! Common Features of Office 2007   Skill 1    Explore Your Computer Using Folder Windows Skill 2    Start Word and Navigate the Word Window Skill 3    Start Excel and PowerPoint and Work with Multiple Windows Skill 4    Create a Folder and Save Files Skill 5    Print and Save Office Files Skill 6    Open a Student Data File and Save a Copy Using Save As Skill 7    Edit and Format Text Skill 8    Use Contextual tabs, Dialog Boxes, and Shortcut Menus Skill 9    Use Office Help Skill 10   Create a New Access Database   More Skills Skill 11    Capture a Screen with the Snipping Tool Skill 12    Organize Files Skill 13    Search and Preview Files Skill 14    Delete and Restore Files   Word Chapter 1 Creating Documents with Word 2007   Skill 1     Create a New Document and Enter Text Skill 2     Edit Text Using the Delete and Backspace Keys Skill 3     Select, Delete, and Insert Text Skill 4     Insert Text from another Document Skill 5     Navigate a Document Skill 6     Format the Font, Font Size, and Font Style Skill 7     Insert a Picture Skill 8     Check Spelling and Grammar Skill 9     Create a Document Footer Skill 10    Preview, Print, and Save a Document   More Skills Skill 11     Split Windows and Arrange Windows Skill 12     Insert Symbols Skill 13     Use Quick Styles Skill 14     Use Research Tools     Word Chapter 2  Format and Organize Text   Skill 1    Set Document Margins Skill 2    Align Text and Set Indents Skill 3    Modify Line and Paragraph Spacing Skill 4    Format Text Using the Format Painter Skill 5    Find and Replace Text Skill 6    Cut, Copy, Paste, and Move Text Skill 7    Create a Bulleted List Skill 8    Create a Numbered List Using AutoFormat Skill 9    Insert and Format Headers and Footers Skill 10   Insert and Modify Footnotes   More Skills Skill 11     Record AutoCorrect Entries Skill 12     Add Citations and a Bibliography Skill 13     Format and Customize Lists Skill 14     Manage Document Properties   Word Chapter 3  Work with Graphics, Tabs, and Tables   Skill 1    Insert a Picture from a File Skill 2    Resize and Move a Picture Skill 3    Format Pictures Using Styles and Borders Skill 4    Set Tab Stops Skill 5    Enter Text with Tab Stops Skill 6    Apply a Predefined Format to a Table Skill 7    Create a Table Skill 8    Add Rows and Columns to a Table Skill 9    Format Text in Table Cells Skill 10   Format a Table   More Skills Skill 11     Insert a Text Box Skill 12     Create a WordArt Title Skill 13     Create a Table from an Existing List Skill 14     Insert a Drop Cap   Word Chapter 4  Applying Special Text, Paragraph, and Document Formats   Skill 1    Collect Information using the Office Clipboard Skill 2    Use the Office Clipboard to Build a Document Skill 3    Create Multiple Column Text Skill 4    Insert a Column Break Skill 5    Add a Border and Shading to a Paragraph Skill 6    Insert Hyperlinks to Text and Graphics Skill 7    Insert a SmartArt Graphic Skill 8    Format a SmartArt Graphic Skill 9    Create Labels Using the Mail Merge Wizard Skill 10   Preview and Print a Mail Merge Document   More Skills Skill 11     Create a Resume from a Template Skill 12     Create an Outline Skill 13     Prepare a Document for Distribution Skill 14     Preview and Save a Document as a Web Page   Excel Chapter 1 Create Workbooks with Excel 2007   Skill 1    Create and Save a New Workbook Skill 2    Enter Worksheet Data and Merge and Center Titles Skill 3    Adjust Column Widths and Format Cells Skill 4    Use the SUM Function Skill 5    Copy Formulas and Insert Columns Skill 6    Format, Edit, and Check the Spelling of Data Skill 7    Create a Column Chart Skill 8    Format a Column Chart Skill 9    Create a Footer Containing a Graphic Skill 10   Display and Print Formulas and Scale a Worksheet for Printing   More Skills Skill 11     Create a New Workbook by Using a Template Skill 12     Change a Chart Type Skill 13     Change the Office Theme in an Excel Workbook Skill 14     Manage Document Properties in an Excel Workbook   Excel Chapter 2  Construct Formulas and Charts   Skill 1    Create a New Workbook from an Existing Workbook and Align Text Skill 2    Construct Formulas for Mathematical Operations Skill 3    Format Numbers Skill 4    Construct and Copy Formulas Containing Absolute Cell References Skill 5    Format Percentages and Insert Rows in a Worksheet Containing Formulas Skill 6    Create a Pie Chart and a Chart Sheet Skill 7    Format a Pie Chart with 3-D and Rotate Slices Skill 8    Explode and Color a Pie Slice, Format the Chart Area, and Insert a Text Box Skill 9    Edit a Workbook, Update a Chart, and Insert WordArt Skill 10   Prepare a Chart Sheet for Printing   More Skills Skill 11       Add and Edit Comments Skill 12       Use Range Names in a Formula Skill 13       Use the Payment (PMT) Function Skill 14       Use Goal Seek   Excel Chapter 3  Manage Multiple Worksheets in a Workbook   Skill 1    Navigate, Rename, and Change the Tab Color of Worksheets Skill 2    Enter and Format Dates Skill 3    Clear Cells of Contents and Formats Skill 4    Move, Copy, and Paste Cell Contents Skill 5    Group Worksheets for Editing Skill 6    Use More Than One Math Operator in a Formula Skill 7    Edit and Format Multiple Worksheets Skill 8    Insert and Move a Worksheet Skill 9    Construct Formulas that Refer to Cells in Another Worksheet Skill 10   Create a Clustered Bar Chart   More Skills Skill 11    Add SmartArt Graphics to a Worksheet Skill 12    Create a Line Chart Skill 13    Set and Clear a Print Area Skill 14    Create a Hyperlink in a Workbook   Excel Chapter 4  Use Excel Functions and Tables   Skill 1    Use the SUM and AVERAGE Functions Skill 2    Use the MEDIAN, MIN, and MAX Functions Skill 3    Move Data, Add Borders, and Rotate Text Skill 4    Use the IF and COUNTIF Functions Skill 5    Apply Conditional Formats With Custom Formats and Data Bars Skill 6    Use Find and Replace and Insert the Date Function Skill 7    Freeze and Unfreeze Panes Skill 8    Create and Sort an Excel Table Skill 9    Filter an Excel Table Skill 10   Convert a Table to a Range of Data and Format a Large Worksheet   More Skills Skill 11    Apply Conditional Formats by Using Color Scales, Icon Sets, and Top/Bottom Rules Skill 12    Hide or Unhide Rows and Columns Skill 13    Create PivotTable Reports Skill 14    Use Auto Fill to Fill Data Automatically in Worksheet Cells     Access Chapter 1 Working with Database Management Systems   Skill 1    Open and Organize an Existing Database Skill 2    Modify Table Data Using a Form Skill 3    Modify a Query and Print the Results in a Report Skill 4    Format a Datasheet and Modify Table Design Skill 5    Modify Table Data and Use Find and Replace Skill 6    Sort Table Data and Hide Datasheet Columns Skill 7    Filter, Summarize, and Print a Datasheet Skill 8    Create a Relational Database from a Template Skill 9    Add Records to Related Tables Skill 10   Format a Report in Layout View   More Skills Skill 11    Compact and Repair a Database Skill 12    Convert Databases to and from the 2002 - 2003 File Format Skill 13     Work with the Attachment Data Type Skill 14     Work with the Hyperlink and Yes/No Data Types   Access Chapter 2  Building a Relational Database and Creating Forms   Skill 1    Design a Relational Database and Build a Table in Datasheet View Skill 2    Build a Table in Design View Skill 3    Create Tables by Importing Data from Excel Skill 4    Import Access Tables and Create an Input Mask Skill 5    Create a Lookup Column Skill 6    Relate Tables Skill 7    Create a Many-to-Many Relationship Skill 8    Create a Form Using the Form Tool Skill 9    Create a Form and a Subform Using the Form Wizard Skill 10   Modify a Form in Design View and Enter Records in a One-to-Many Form   More Skills Skill 11    Set Field Properties to Validate Data Skill 12    Create Indexes and Establish a One-to-One Relationship Skill 13    Create a Multiple Items Form Skill 14    Create and Format a Split Form   Access Chapter 3  Creating Queries and Reports   Skill 1    Use the Simple Query Wizard to Create a Query Skill 2    Create a Labels Report Based on a Query Skill 3    Create a Query with Numeric and Date Criteria Skill 4    Create a Report Using the Report Wizard Skill 5    Modify a Report in Design View and Add Summary Data Skill 6    Format a Report in Layout View Skill 7    Create a Parameter Query Skill 8    Create a Report Based on a Parameter Query Skill 9    Group, Sort, and Filter Records in a Report Skill 10   Export Reports to Other File Formats   More Skills Skill 11    Create a Crosstab Query Skill 12    Export Data to Other Applications Skill 13    Use a Query to Find Duplicate Data Skill 14    Use a Query to Find Unmatched Data   Access Chapter 4 Designing Advanced Queries and Reports   SKILL 1    Use Logical Operators in a Query SKILL 2    Create a Form Based on a Query SKILL 3    Group, Sort , and Add Wildcards to a Query Criteria SKILL 4    Add Calculated Fields to a Query SKILL 5    Add Summary Statistics to a Query SKILL 6    Create a Report with a Calculated Control in Design View SKILL 7    Format a Report in Design View SKILL 8    Create a Report Using the Blank Report Tool SKILL 9    Add a Chart to a Report SKILL 10   Customize the Navigation Pane   More Skills Skill 11    Encrypt a Database File Skill 12    Specify Relationship Join Types Skill 13    Create Macros Skill 14    Create a Switchboard   PowerPoint Chapter 1 Getting Started with PowerPoint 2007   Skill 1    Open, View, and Save a Presentation Skill 2    Edit and Replace Text in Normal View Skill 3    Format Slide Text Skill 4    Check Spelling and Use the Thesaurus Skill 5    Insert Slides and Modify Slide Layouts Skill 6    Insert and Format Pictures Skill 7    Organize Slides Using Slide Sorter View Skill 8    Apply Slide Transitions and View a Slide Show Skill 9    Insert Headers and Footers and Print Presentation Handouts Skill 10   Add Speakers Notes and Print Notes Pages   More Skills Skill 11    Type Text in the Outline Pane Skill 12      Use Keyboard Shortcuts Skill 13      Move and Delete Slides in Normal View Skill 14      Design a Presentation for Audience and Location   PowerPoint Chapter 2  Format a Presentation   Skill 1    Create a New Presentation Skill 2    Change the Presentation Theme Skill 3    Apply Font and Color Themes Skill 4    Format the Slide Background Skill 5    Apply a Picture or Texture to the Slide Background Skill 6    Format Text with WordArt Skill 7    Change Character Spacing and Font Color Skill 8    Modify Bulleted and Numbered Lists Skill 9    Move and Copy Text and Objects Skill 10   Use Format Painter and Clear All Formatting   More Skills Skill 11    Edit the Slide Master Skill 12    Save and Apply a Presentation Template Skill 13    Create Slides from a Microsoft Word Outline Skill 14    Design a Presentation with Contrast   PowerPoint Chapter 3  Enhance a Presentation with Graphics Skill 1    Insert Slides from an Existing Presentation Skill 2    Insert, Size, and Move Clip Art Skill 3    Change Picture Shape and Apply Picture Effects and Borders Skill 4    Insert, Size, and Move Shapes Skill 5    Add Text to Shapes and Insert Text Boxes Skill 6    Format, Group, and Align Shapes and Pictures Skill 7    Insert a SmartArt Graphic Skill 8    Modify SmartArt Layout, Color, and Style Skill 9    Convert Text to a SmartArt Graphic Skill 10   Add Shapes to a SmartArt Graphic   More Skills Skill 11    Compress Pictures Skill 12    Save a Group as a Picture Skill 13    Change Object Order Skill 14    Design a Presentation Using Appropriate Graphics   PowerPoint Chapter 4  Present Data using Tables, Charts, and Animation   Skill 1     Insert a Table Skill 2     Modify Table Layout Skill 3     Select and Align Table Text Skill 4     Change the Table Style Skill 5     Insert a Chart Skill 6     Delete Chart data and Change the Chart Type Skill 7     Format a Chart Skill 8     Apply Animation to Text and Graphics Skill 9     Set Animation Effect and Timing Options Skill 10   Animate Objects using the Animate List   More Skills Skill 11    Prepare a Presentation for Remote Delivery Skill 12    Create a Photo Album Skill 13    Insert Hyperlinks in a Presentation Skill 14    Design a Presentation that includes a Custom Show