Learning Ofice 2007 Softcover Deluxe Edition

    Lesson 1

Getting Started with Microsoft Office 2007

    Exercise 1

        About Business Technology

        About Microsoft Office 2007

        Use the Mouse

        Use the Keyboard

        Start and Exit Microsoft Office Programs

        Identify Common Screen Elements

        Conventions Used in This Book

    Exercise 2

        About Commands

        About the Ribbon

        Use the Ribbon

        Use Access Keys

        Use the Office Button

        Use the Quick Access Toolbar

        Use a Mini Toolbar

        Use Shortcut menus

        Use Dialog Box Options

        Use Task Panes

    Exercise 3

        Use Window Controls

        Zoom

        Scroll

        Use Multiple Windows

    Exercise 4

        Use the Help Program

        Search for Help

        Use the Help Table of Contents

        Recover a File

 

Word 2007

Lesson 1

Getting Started with Word 2007

    Exercise 1

        Start Word

        The Word Window

        Change the Word Window

        Type in a Document

        Correct Errors

        Use Undo, Redo, and Repeat

        Save a New Document

        Close a Document

        Types of Business Documents

        Exit Word

    Exercise 2

        Create a New Document

        Work with Show/Hide Marks

        Move the Insertion Point in a Document

        Use Click and Type

        Save Changes

        Print

        Preview an Open Document

        About Press Releases

    Exercise 3

        Correct Spelling as You Type

        Correct Grammar as You Type

        Check Spelling and Grammar

        Use the Thesaurus

    Exercise 4

        Use AutoCorrect

        Select Text in a Document

        Replace Selected Text

        Align Text Horizontally

        Align a Document Vertically

        Line Spacing

        Paragraph Spacing

        About Memos

    Exercise 5

        Format a Business Letter

        Insert the Date and Time

        Use Uppercase Mode

        Change Case

        Create an Envelope

    Exercise 6

        Set Tabs

        Format a Modified-Block Business Letter

        Shrink One Page

    Exercise 7

        Format a Personal Business Letter

        About Fonts

        Change the Font

        Change Font Size

        Apply Font Styles

        Apply Underlines

        Create Labels

    Exercise 8 Critical Thinking

    Exercise 9 Curriculum Integration

 

Lesson 2

Basic Editing Skills

    Exercise 10

        Use Proofreaders’ Marks

        Open a Saved Document

        Insert and Edit Text

        Use Overtype Mode

        Save a Document with a New Name

    Exercise 11

        Use Split Screen View

        Open Multiple Documents at the Same Time

        Arrange Documents On-Screen

        Compare Documents Side by Side

    Exercise 12

        Move Text

        Use Cut and Paste

        Use the Clipboard Task Pane

        Use Drag-and-Drop Editing

        Select Paste Formatting Options

        Move a Paragraph

    Exercise 13

        Use Copy and Paste

        Use Drag-and-Drop Editing to Copy

    Exercise 14

        Open a Document as Read-Only

        Open a Document from Windows

        Document Properties

        About File Types

    Exercise 15

        Preview a Closed Document

        Print a Closed Document

    Exercise 16 Critical Thinking

    Exercise 17 Curriculum Integration

 

Lesson 3

Formatting Basics

    Exercise 18

        Apply Font Effects

        Font Color

        Highlight Text

        Format Painter

    Exercise 19

        Use Symbols

    Exercise 20

        Indent Text

    Exercise 21

        Bulleted Lists

        Numbered Lists

        Sort

    Exercise 22

        About Styles

        Apply Styles

        Create a Style

        Edit a Style

        Reapply Direct Formatting

        Clear Formatting

    Exercise 23

        About Document Production

        Set Margins

        Set Page Orientation

        Format a One-Page Report

    Exercise 24

        Use Themes

        Use AutoFormat As You Type

    Exercise 25 Critical Thinking

    Exercise 26 Curriculum Integration

 

Lesson 4

Word and the World Wide Web

    Exercise 27

        About the World Wide Web

        Create a Web Page Document in Word

        Use Web Layout View

        View a Web Page Document in a Browser

    Exercise 28

        Open a Web Page Document in Word

        Use Web Page Titles

        Apply a Background

    Exercise 29

        Create Hyperlinks

    Exercise 30

        Send a Document as an E-mail Attachment

    Exercise 31 Critical Thinking

    Exercise 32 Curriculum Integration

 

Lesson 5

Working with Tables

    Exercise 33

        Create a Table

        Enter Data in a Table

        Select in a Table

        Change Table Structure

        Format a Table

    Exercise 34

        Set Alignments within Table Cells

        Set Cell Margins

        Align Table on the Page

        Column Width and Row Height

    Exercise 35

        Draw a Table

        Move and Resize Tables

        Merge and Split Cells

        Rotate Text

        Wrap Text

    Exercise 36

        Calculations in a Table

        Number Formats

        Sort Rows

        Cell Borders and Shading

    Exercise 37 Critical Thinking

    Exercise 38 Curriculum Integration

 

Lesson 6

Creating Documents with Merge

    Exercise 39

        Mail Merge Basics

        Use Mail Merge

        Create a New Address List

        Use Merge Fields

    Exercise 40

        Merge with an Existing Address List

        Edit an Address List

        Customize Merge Fields

        Merge Envelopes and Labels

        Create Envelopes

        Create Labels

    Exercise 41

       Sort Recipients in an Address List

        Select Specific Recipients

        Create a Directory with Mail Merge

    Exercise 42

        Filter Recipients

        Merge to an E-mail Message

    Exercise 43 Critical Thinking

    Exercise 44 Curriculum Integration

 

Lesson 7

Creating and Editing Long Documents

    Exercise 45

        Create an Outline

        Edit an Outline

        Collapse and Expand Outlines

        Number an Outline

    Exercise 46

        Set Margins for Multiple Page Documents

        Insert Page Breaks

        Insert Section Breaks

        Insert Headers and Footers

        Insert Page Numbers

        View the Word Count

    Exercise 47

        Footnotes and Endnotes

        Find and Replace

        Insert Bookmarks

        Select Browse Object

    Exercise 48

        Use Full Screen Reading View

        Use Document Map

        Use Thumbnails

        Preview Multiple Pages

        Copy or Move Text from One Page to Another

        Print Specific Pages

    Exercise 49

        Insert Comments

        Track Changes

        Customize Revision Marks

        Compare and Combine Documents

        Accept/Reject Changes

     Exercise 50 Critical Thinking

     Exercise 51 Curriculum Integration

 

Lesson 8

Enhancing Documents and Automating Tasks

    Exercise 52

        About Desktop Publishing

        Create Newsletter Columns

        Set Column Width

        Insert Column Breaks

        Balance Columns

        About Layout and Design

    Exercise 53

        Use Dropped Capitals

        Enhance a Document with Borders and Shading

    Exercise 54

        Insert Shapes

        Insert a Text Box

        Format Objects

        Resize Objects

        Position Objects

    Exercise 55

        Insert Clip Art

        Format Pictures

        Use the Clip Organizer

        Insert SmartArt

    Exercise 56

        Templates

    Exercise 57

        Insert a File in a Document

        Building Blocks

    Exercise 58

        Record a Macro

        Run a Macro

    Exercise 59 Critical Thinking

    Exercise 60 Curriculum Integration

 

Excel 2007

Lesson 1

Getting Started with Excel 2007

    Exercise 1

        Start Excel

        The Excel Window

        Excel Interface

        Navigate the Worksheet

        Change Between Worksheets

        Worksheet Views

        Exit Excel

    Exercise 2

        Create a New (Blank) Workbook

        Create a Workbook from a Template or Another Workbook

        Enter Labels

        Make Simple Corrections

        Undo and Redo

        Delete (Clear) Cell Contents

        Save a Workbook

        Close a Workbook

    Exercise 3

        Open Workbooks

        Change from Workbook to Workbook

        Compare Workbooks

        AutoComplete

        Pick From List

        AutoCorrect

        Spell Check

    Exercise 4

        Enter Numeric Labels and Values

        Enter Dates

        Create a Series

        Change Data Alignment

        Change Column Width

    Exercise 5

        Enter a Formula

        Edit a Formula

    Exercise 6 Critical Thinking

    Exercise 7 Curriculum Integration

 

Lesson 2

Working with Formulas and Formatting

    Exercise 8

        Select Ranges

        Range Entry Using Collapse Button

    Exercise 9

        Choose a Theme

        Apply Cell Styles (Quick Styles)

        Apply Font Formats

        Apply Number Formats

    Exercise 10

        Copy and Paste Data

        Copy Formats

        Relative Reference

        Absolute Reference

        Preview and Print a Worksheet

    Exercise 11

        Insert and Delete Columns and Rows

        Move Data (Cut/Paste)

        Drag-and-Drop Editing

    Exercise 12

        Insert, Delete, Copy, Move, and Rename Worksheets

        Change the Color of a Worksheet Tab

        Hide Sheets

        Group Sheets

    Exercise 13 Critical Thinking

    Exercise 14 Curriculum Integration

 

Lesson 3

Working with Functions, Formulas, and Charts

    Exercise 15

        Use Functions

        Common Functions

        Insert a Function

        AutoCalculate

    Exercise 16

        Excel Tables

        Comments

    Exercise 17

        Named Ranges

    Exercise 18

        Understand IF Functions

        Nested IF Functions

        =SUMIF() and SUMIFS() Functions

        =COUNTIF() and COUNTIFS() Functions

    Exercise 19

        Chart Basics

        Select Chart Data

        Chart Elements

        Create Charts

        Change Chart Types

        Select a Chart

        Resize, Copy, Move, or Delete a Chart

    Exercise 20

        Change Data Series Orientation

        Format a Chart

        Resize, Move, or Delete a Chart Object

        Change Chart Text

        Enhance Chart Background

        Format Category and Value Axes

    Exercise 21 Critical Thinking

    Exercise 22 Curriculum Integration

 

Lesson 4

Advanced Printing, Formatting, and Editing

    Exercise 23

        Print a Workbook

        Print Multiple Copies

        Modify Page Setup

        Insert Headers and Footers

        Page Layout View

    Exercise 24

        Insert Page Breaks

        Page Break Preview

        Set Print Area

        Repeat Row and Column Labels

        Other Sheet Tab Options

    Exercise 25

        Copy and Paste Special

        Transpose Data

    Exercise 26

        Combine Data with Copy and Paste Special

    Exercise 27

        Freeze Labels While Scrolling

        Split a Worksheet into Panes

    Exercise 28

        Drag-and-Drop Data Between Workbooks

        Link Workbooks

    Exercise 29

        3-D Formulas

        Duplicate Workbook Window

    Exercise 30 Critical Thinking

    Exercise 31 Curriculum Integration

 

Lesson 5

Advanced Chart Techniques

    Exercise 32

        Print a Chart

        Publish Chart to the Internet/Intranet

    Exercise 33

        Paste a Picture of a Chart

        Link a Chart

        Embed a Chart into a Word Document

        Edit a Linked or Embedded Chart

    Exercise 34

        Create Organization Charts

        Create SmartArt

    Exercise 35 Critical Thinking

    Exercise 36 Curriculum Integration

 

Lesson 6

Advanced Functions, PivotCharts, and PivotTables

    Exercise 37

        Create Predictions and Estimations

        Use FORECAST

        Use TREND

        Use GROWTH

    Exercise 38

        Use the PMT Function

        Create What-If Data Tables

        Solve a Problem with Goal Seek

        Use Solver to Resolve Problems

    Exercise 39

        Create Lookup Functions

    Exercise 40

        Create PivotTables and PivotCharts

        Use the PivotTable Field List

    Exercise 41 Critical Thinking

    Exercise 42 Curriculum Integration

 

Lesson 7

Internet and Integration with Excel

    Exercise 43

        Save a Worksheet as a Web Page

    Exercise 44

        Copy Data from a Web Page

        Create a Web Query

    Exercise 45

        Link and Embed Excel Data

        Paste a Picture

        Link Data

        Edit Linked Data

        Embed Data

        Edit Embedded Data

    Exercise 46 Critical Thinking

    Exercise 47 Curriculum Integration

 

Access 2007

Lesson 1

Getting Started with Access 2007

    Database Basics

        What is Access?

        What is a Database?

        What is a Database Management System?

        How is an Access Database Organized?

        How are Access Tables Related?

    Exercise 1

        Start Access and Open a Database

        Work with the Navigation Pane

        Save a Copy of a Database

        Open and Close Objects in a Database

        Move through a Datasheet or Form

        Sort Records

    Exercise 2

        Enter Records

        Edit Records

        Select Records

        Delete Records

        Print Datasheets and Forms

        Print Preview

    Exercise 3

        Plan a Database

        Create a Database

        Create a Table from a Datasheet

        Save Changes to a Table Design

        Rename a Field in a Datasheet

        Delete a Field from a Datasheet

    Exercise 4

        Open a Database File

        Create a Table with a Template

        Create a Table in Design View

        Select a Field for the Primary Key

        Open a Database Exclusively

        Set a Database Password

    Exercise 5 Critical Thinking

    Exercise 6 Curriculum Integration

 

Lesson 2

Working with Tables and Datasheets

    Exercise 7

        Open a Table for Editing in Design View

        Rename a Field in Design View

        Add a Field in Design View

        Delete a Field in Design View

        Reorder Fields

        Change Field Properties

    Exercise 8

        How Data is Stored in a Plain Text File

        Import Data

        Export Data

        Save Import or Export Steps

    Exercise 9

        Insert a Field on a Datasheet

        Change Field Properties from Datasheet View

        Move a Column

        Hide and Unhide Columns

        Change Datasheet Column Widths

        Freeze Columns

    Exercise 10

        Relate Tables

        Enforce Referential Integrity

        Show Related Records

    Exercise 11 Critical Thinking

    Exercise 12 Curriculum Integration

 

Lesson 3

Simplifying Data Entry with Lookups and Forms

    Exercise 13

        Create a Lookup

        Create a Value List

        Lookup Field Values from Another Table

        Create a Multivalued Field

    Exercise 14

        Create a Quick Form

        Create a Form with a Wizard

        Create a Form from Scratch

        AutoFormat a Form

    Exercise 15

        Understanding Layout View

        Adjust the Control Margins and Control Padding

        Move Fields in the Layout

        Size a Control

        Delete a Control

        Reset Tab Order

        Align Controls with One Another

        Change Control Formatting

    Exercise 16

        Work in Form Design View

        Select and Move Controls

        Resize Controls

        Work with Headers and Footers

        Add Page Number Codes

        Add Date/Time Codes

        Move Controls Between Sections

        Insert an Unbound Label

        Insert a Form Title

    Exercise 17 Critical Thinking

    Exercise 18 Curriculum Integration

 

Lesson 4

Find Information in a Database

    Exercise 19

        Find Text

        Replace Data

        Search Using Wildcards

        Use Multiple Sorts

        Change Column Order

        Remove a Sort

    Exercise 20

        Filter a Record Subset

        Filter By Selection

        Filter for Multiple Selections

        Filter For Entry

        Filter By Form

        Save a Filter as a Query

    Exercise 21

        Compare Queries to Sorts/Filters

        Create a Query with a Wizard

        Create a Query in Query Design View

        Display the Query Datasheet

        Save a Query

    Exercise 22

        Open a Query for Editing

        Select, Move, and Delete Fields

        Add Fields to a Query

        Use All Fields of a Table for a Query

        Rename a Query

        Save a Copy of a Query

    Exercise 23 Critical Thinking

    Exercise 24 Curriculum Integration

    xiv

 

Lesson 5

Display Information with Reports

    Exercise 25

        Report Layout Types

        Views for Working with Reports

        Ways to Create a Report

        Create a Quick Report

        Create a Report with the Report Wizard

        Create a Blank Report in Layout View

        Work with Print Preview and Report Views

        Print a Report

        Save a Report

    Exercise 26

        Use Report Design View.

        Work with Headers and Footers

        Move a Control Between Sections

        Add Sorting and Grouping

        Add a Calculated Field to a Report

    Exercise 27

        About Labels

        Use the Label Wizard

    Exercise 28 Critical Thinking

    Exercise 29 Curriculum Integration

 

PowerPoint 2007

Lesson 1

PowerPoint Basics

    Exercise 1

        About PowerPoint

        The PowerPoint Window

        Create a Presentation from a Blank Presentation

        Work with Placeholders

        Add Slides to a Presentation

        Select a Slide Layout

        Save a Presentation

    Exercise 2

        Open an Existing Presentation

        Move from Slide to Slide

        Apply a Theme

        Change Slide Layout

        Work with the Normal View Panes

        Spell Check a Presentation

    Exercise 3

        Insert Clip Art

        Resize and Position Clip Art

        Use Undo and Redo

        Change Theme Colors

        Change Theme Fonts

        Change Background Style

    Exercise 4

        Create a Presentation from a Template or Existing

        Presentation

        PowerPoint Views

        Copy, Duplicate, and Delete Slides

        Rearrange Slides

    Exercise 5

        Create Slides from an Outline

        Reuse Slides from Other Presentations

        Insert Header/Footer, Date, and Slide Numbers

        Hide Background Graphics

    Exercise 6

        Create Notes Pages and Handouts

        Change Slide Size and Orientation

        Use Print Preview

        Print Presentation Materials

    Exercise 7 Critical Thinking

    Exercise 8 Curriculum Integration

 

Lesson 2

Work with Text and Graphic Elements

    Exercise 9

        Select Text and Placeholders

        Change the Appearance of Text

        Use AutoFit Options

        Copy Text Formatting

        Create New Theme Fonts

    Exercise 10

        Work with Bulleted and Numbered Lists

        Align Text

        Adjust Paragraph Spacing

        Move and Copy Text

        Adjust and Format Placeholders

    Exercise 11

        Insert Symbols

        Insert and Format a Text Box

        Create Column Text in a Text Box

        Insert and Format WordArt

    Exercise 12

        Insert a Table

        Format or Modify a Table

        Insert or Link Excel Worksheet Data

    Exercise 13

        Insert a Chart

        Format or Modify a Chart

        Insert a SmartArt Graphic

        Format or Modify a SmartArt Graphic

    Exercise 14

        Use Rulers, Guides, and Gridlines

        Draw and Format Shapes

        Arrange Objects

    Exercise 15

        Insert a Picture from a File

        Format Pictures

        Insert a Movie

        Insert Sounds and Music

    Exercise 16

        About the Slide Master

        Customize Slide Master Elements

        Create a Custom Layout

        Work with Notes and Handouts Masters

    Exercise 17

        Create a Theme or Template

        Apply Custom Themes and Templates

    Exercise 18 Critical Thinking

    Exercise 19 Curriculum Integration

 

Lesson 3

Prepare and Present a Slide Show

    Exercise 20

        Add Slide Transitions

        Control Slide Advance

        Animate Text and Objects

        Rehearse Timings

    Exercise 2

        Create a Custom Show

        Insert Links on Slides

        Insert an Action Button

    Exercise 22

        Hide Slides

        Set Slide Show Options

        Control Slides During a Presentation

        Annotate Slides During a Presentation

    Exercise 23

        Send a Presentation for Review

        Finalize a Presentation

        Package for CD

        Other Output Options

    Exercise 24 Critical Thinking

    Exercise 25 Curriculum Integration

 

Outlook 2007

Lesson 1

Getting Started with Outlook

    Exercise 1

        About Microsoft Office Outlook 2007

        Start and Exit Outlook

        Change the Outlook View

        Navigate among Outlook Components

    Exercise 2

        Navigate in Mail

        Create Messages

        Send and Receive Messages

        Read Messages

        Reply To and Forward Messages

        Print Messages

    Exercise 3

        Use Categories

        Flag Messages for Follow-Up

        Delete, Copy, and Move Messages

        Find Items with Instant Search

        Attach Files to Messages

        Receive Message Attachments

        Select a Theme or Stationery

        Create a Signature

        Use the Address Book

    Exercise 4

        Navigate in the Calendar

        Change the Calendar View

        Schedule Calendar Items

        Schedule Recurring Calendar Items





        Set Reminders

        Print a Calendar

    Exercise 5

        Use Notes

        Create Contacts

        Change the Contacts View

        Create Tasks

        Change the Tasks View

        Print Notes, Contacts, or Tasks

    Exercise 6 Critical Thinking

    Exercise 7 Curriculum Integration

 

Challenge Lesson

    Exercise 1

        Copy Word Table Data to an Excel Worksheet

        Manipulate Data in Excel

        Link Excel Data to a Word Document

        Update Linked Data and E-Mail the Document

    Exercise 2

        Export a PowerPoint Presentation to Word for Handouts

        Modify the PowerPoint Handouts in Word

        Export a PowerPoint Outline to Word

        Format the PowerPoint Outline in Word

    Exercise 3

        Create Pictures from PowerPoint Slides

        Add a Field and Create a Form in Access

        Insert Pictures in an Access Form

    Exercise 4

        Save a Word File as a Web Page

        Save a Presentation as a Web Site

        Create Hyperlinks in a Word Document

        Preview and Test the Web Site

    Exercise 5

        Export an Access Table to Excel

        Analyze Access Data in Excel

        Send a Worksheet as E-Mail

        Receive, Save, and Edit an E-Mailed Worksheet

    Exercise 6

        Create Queries in an Access Database

        Use an Access Query as a Data Source for a Form Letter

        Mail Merge

        Embed Excel Data in a Word Document

        Complete the Merge

        Use an Access Table as a Data Source for an Envelope

        Mail Merge

    Exercise 7

        Save an Excel Worksheet as a Web Page

        Link a Word Document to an Excel Web Page

        Send a Word Document via E-Mail

    Exercise 8

        Link an E-Mail Message to an Excel Worksheet

        Prepare a Word Document for Use as a Form Letter

        Link an Excel Worksheet to an Access Database

    Exercise 9

        Insert Downloaded Clip Art in an Excel Worksheet

        Paste Excel Charts in a PowerPoint Presentation

        Save Office Files in HTML Format

        Insert and Test Hyperlinks

    Glossary

    Index