Skills for Success Using Microsoft Office 2007

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