Rent 9780760064337 | New Perspectives on Microsoft Office 2000: Second Course

Summary Table of Contents

Part of the New Perspectives Series, this text offers a case-based, problem solving approach to learning the more advanced features of the Microsoft Office 2000 Premium package.

Preface

iii

Tutorial Tips

viii

Microsoft Office 2000 2nd Course---Level II Tutorials

(1)

Microsoft Word 2000 Level II Tutorials

(1)

Read this Before y... MORE

(1)

Creating Styles, Outlines, Tables, and Tables of Contents

(1)

Writing a Business Plan for EstimaTech

Session 5.1

(17)

Planning the Document

(1)

Creating a New Folder

(1)

Using the Thesaurus

(1)

Choosing Fonts

(3)

Using Styles

(1)

Using a Word Template

(1)

Applying Styles

(1)

Modifying a Predefined Style

(2)

Defining New Styles with the Style Command

(4)

Creating a New Template

(3)

Session 5.1 Quick Check

(1)

Session 5.2

(9)

Creating and Editing an Outline

(2)

Moving Headings Up and Down in an Outline

(1)

Promoting and Demoting Headings in an Outline

(1)

Printing the Outline

(1)

Hyphenating a Document

(2)

Adding Footnotes and Endnotes

(3)

Session 5.2 Quick Check

(1)

Session 5.3

(1)

Positioning the Insertion Point with Click and Type

(2)

Inserting the Current Date

(1)

Highlighting Text with Color

(1)

Changing Character and Paragraph Spacing

(1)

Adjusting Spacing between Characters

(2)

Adjusting Spacing between Paragraphs

(2)

Creating a Table of Contents

(2)

Browsing by Heading

(3)

Session 5.3 Quick Check

(1)

Review Assignments

(2)

Case Problems

(5)

Quick Check Answers

Creating Form Letters and Mailing Labels

(1)

Writing a Sales Letter for The Pet Shoppe

Session 6.1

(15)

Planning the Form Letter

(1)

The Merge Process

(2)

Mail Merge Fields

(1)

Data Fields and Records

(1)

Creating a Main Document

(2)

Creating a Data Source

(1)

Attaching the Data Source and Creating the Header Row

(3)

Entering Data into a Data Source

(5)

Session 6.1 Quick Check

(1)

Session 6.2

(14)

Editing a Main Document

(2)

Inserting Merge Fields

(4)

Merging the Main Document and Data Source

(3)

Sorting Records

(2)

Selecting Records to Merge

(3)

Session 6.2 Quick Check

(1)

Session 6.3

(1)

Creating Mailing Labels

(5)

Creating a Telephone List

(2)

Session 6.3 Quick Check

(1)

Review Assignments

(2)

Case Problems

(4)

Quick Check Answers

Integrating Word with Other Programs and with the World Wide Web

(1)

Writing a Proposal to Open a New Branch of Family Style, Inc.

Session 7.1

(18)

Planning the Document

(1)

Integrating Objects from Other Programs

(1)

Embedding

(1)

Linking

(1)

Choosing between Embedding and Linking

(1)

Embedding an Excel Worksheet

(2)

Centering the Embedded Worksheet

(1)

Modifying the Embedded Worksheet

(3)

Linking an Excel Chart

(2)

Modifying the Linked Chart

(3)

Updating the Link

(3)

Session 7.1 Quick Check

(1)

Session 7.2

(12)

Creating and Navigating Hyperlinks

(1)

Inserting a Hyperlink to a Bookmark in the Same Document

(3)

Navigating Hyperlinks and the Web Toolbar

(1)

Creating Hyperlinks to Other Documents

(2)

Viewing a Document in Web Layout View

(2)

Improving the Appearance of an Online Document

(1)

Animating Text

(1)

Applying a Textured Background

(1)

Session 7.2 Quick Check

(1)

Session 7.3

(1)

Publishing Documents on the World Wide Web

(1)

Saving a Word Document as a Web Page

(3)

Formatting a Web Page

(1)

Moving and Editing Text and Graphics

(1)

Inserting Horizontal Lines

(2)

Modifying Text Size and Color

(1)

Creating and Editing Hyperlinks in a Web Page

(1)

Inserting a Hyperlink to a Web Page

(1)

Editing a Hyperlink

(1)

Viewing the Web Page in a Web Browser

(3)

Session 7.3 Quick Check

(1)

Review Assignments

(3)

Case Problems

(4)

Lab Assignments

(1)

Quick Check Answers

Microsoft Excel 2000 Level II Tutorials

(1)

Read this Before you Begin

(1)

Working with Excel Lists

(1)

Managing Faculty Data at North State University

Session 5.1

(15)

Introduction to Lists

(1)

Planning and Creating a List

(1)

Freezing Rows and Columns

(2)

Changing the Zoom Setting of a Worksheet

(1)

Using Find and Replace

(1)

Sorting Data

(1)

Sorting a List Using One Sort Field

(1)

Sorting a List Using More than One Sort Field

(2)

Maintaining a List Using a Data Form

(2)

Using the Data Form to Search for Records

(1)

Using the Data Form to Delete a Record

(2)

Quick Check

(1)

Session 5.2

(15)

Filtering a List Using AutoFilters

(3)

Using Custom AutoFilters to Specify More Complex Criteria

(2)

Using Conditional Formatting

(2)

Using Worksheet Labels in Formulas

(2)

Inserting Subtotals into a List

(2)

Using the Subtotals Outline View

(1)

Printing the List Using Page Breaks

(1)

Printing Row and Column Titles on Every Page

(1)

Removing Page Breaks

(1)

Quick Check

(1)

Session 5.3

(1)

Creating and Using Pivot Tables to Summarize a List

(1)

Creating a Pivot Table

(3)

Laying Out the Pivot Table Directly on the Worksheet

(3)

Changing the Layout of a Pivot Table

(1)

Formatting Numbers in the Pivot Table

(1)

Repositioning a Field in the Pivot Table

(1)

Sorting Items Within the Pivot Table

(1)

Adding a Field to a Pivot Table

(1)

Removing a Field from the Pivot Table

(1)

Hiding Field Items on a Pivot Table

(1)

Refreshing a Pivot Table

(1)

Making a Chart from a Pivot Table

(2)

Quick Check

(1)

Review Assignments

(1)

Case Problems

(4)

Quick Check Answers

Integrating Excel with Other Windows Programs and the World Wide Web

(1)

Creating Integrated Documents for Basket Weavers

Session 6.1

(20)

Methods of Integration

(1)

Pasting Data

(1)

Object Linking and Embedding

(1)

Planning the Integration

(1)

Creating the New Products Flyer

(2)

Inserting WordArt into an Excel Worksheet

(4)

Mail a Workbook as an Attachment

(1)

Linking an Excel Worksheet to a Word Document

(4)

Updating Linked Objects

(1)

Embedding an Excel Chart in a Word Document

(3)

Modifying an Embedded Object

(2)

Quick Check

(1)

Session 6.2

(11)

Customizing a Form Letter Using an Excel List

(1)

Planning the Form Letter

(1)

Specifying a Main Document and a Data Source

(2)

Inserting the Merge Fields

(3)

Performing the Mail Merge

(2)

Viewing Merged Documents

(1)

Previewing and Printing a Merged Document

(2)

Quick Check

(1)

Session 6.3

(1)

Creating Hyperlinks to Connect Files

(1)

Inserting a Hyperlink

(2)

Testing Hyperlinks

(1)

Navigating Between the Hyperlink Documents

(1)

Publishing Excel Data on a Web Page

(1)

Saving Excel Data as a Web Page

(4)

Quick Check

(1)

Review Assignments

(2)

Case Problems

(3)

Quick Check Answers

Developing an Excel Application

(1)

Employee 401(k) Planning at CableScan

Session 7.1

(15)

Planning the 401(k) Workbook Application

(2)

Arranging a Worksheet in Sections

(1)

Entering Initial Values

(1)

Validating Data Entry

(1)

Specifying Data Type and Acceptable Values

(1)

Specifying an Input Message

(1)

Specifying an Error Alert Style and Message

(3)

Using Range Names

(1)

Defining a Range Name

(1)

Using the Name Box to Define a Range Name

(1)

Using a Range Name in a Formula

(1)

Building a Conditional Formula Using the IF Function

(4)

Quick Check

(1)

Session 7.2

(12)

Computing the Retirement Fund

(1)

Creating a Series Using AutoFill

(2)

Inserting the FV Function

(5)

Protecting Cells in a Worksheet

(1)

Unlocking Individual Cells

(2)

Protecting the Worksheet

(1)

Testing Cell Protection

(1)

Deleting Unnecessary Worksheets

(1)

Quick Check

(1)

Session 7.3

(1)

Automating Tasks Using Macros

(1)

Creating Macros

(1)

Planning Macros

(1)

Recording the ClearInputs Macro

(3)

Running the ClearInputs Macro from the Tools Menu

(2)

Creating a Macro Shortcut Key

(1)

Viewing the ClearInputs Macro Code

(1)

Visual Basic for Applications Code

(1)

Recording the Print401k Macro

(3)

Assigning the Print401k Macro to a Button on the Worksheet

(3)

Quick Check

(1)

Review Assignments

(2)

Case Problems

(8)

Quick Check Answers

Working with Multiple Worksheets and Workbooks

(1)

Creating Grading Sheets at MidWest University

Session 8.1

(22)

Why Use Multiple Worksheets?

(1)

Planning a Multiple-Sheet Workbook

(1)

Inserting a Worksheet

(3)

Moving Worksheets

(1)

Working with Worksheet Groups

(1)

Copying Information Across Worksheets

(2)

Entering Text and Formulas into a Worksheet Group

(4)

Formatting a Worksheet Group

(1)

Creating a Summary Worksheet

(1)

Consolidating Data with 3-D References

(6)

Printing Worksheet Groups

(2)

Quick Check

(1)

Session 8.2

(8)

Using Templates

(1)

Opening a Workbook Based on a Template

(2)

Creating and Storing a Workbook Template

(1)

Using the Templates Folder

(3)

Quick Check

(1)

Session 8.3

(1)

Summarizing Data from Several Workbooks

(1)

Creating 3-D Cell References to Other Workbooks

(5)

Working with Linked Workbooks

(3)

Using Lookup Tables

(3)

Using Lookup Functions

(3)

Creating an Excel Workspace

(2)

Quick Check

(1)

Review Assignments

(1)

Case Problems

(4)

Quick Check Answers

APPENDIX 1 Excel Functions

(1)

Session A1.1

(6)

Financial Functions

(1)

Introduction to Financial Functions

(1)

Calculating a Loan Payment Using the PMT Function

(1)

Developing the Loan Amortization Schedule

(1)

Calculating the Principal Paid in Each Period Using the PPMT Function

(1)

Calculating the Interest Paid in Each Period Using the IPMT Function

(1)

Completing the Amortization Schedule

(1)

Session A1.2

(6)

AND, OR, NOT, and Nesting IF Functions

(1)

Introduction to Logical Functions

(1)

Using the AND Function to Compute the 401(k) Costs

(2)

Nesting IF Functions to Compute Health Insurance Costs

(2)

Session A1.3

(1)

Date and Time Functions

(1)

Introduction to Date and Time Values

(1)

Using the YEAR Function to Calculate Years Employed

(1)

Text and Statistical Functions

(1)

Review Assignments

(2)

Case Problems

Microsoft Access 2000 Level II Tutorials

(1)

Read this Before you Begin

(1)

Creating More Advanced Queries and Custom Forms

(1)

Making the Dining Database Easier to Use

Session 5.1

(19)

Creating a Lookup Wizard Field

(5)

Displaying Related Records in a Subdatasheet

(2)

Using the Input Mask Wizard

(3)

Using a Pattern Match in a Query

(2)

Using a List-of-Values Match in a Query

(1)

Using a Nonmatching Value in a Query

(2)

Using Both the And and Or Operators in the Same Query

(2)

Creating a Parameter Query

(2)

Session 5.1 Quick Check

(1)

Session 5.2

(17)

Creating a Custom Form

(1)

Designing a Custom Form

(1)

The Form Window in Design View

(3)

Adding Fields to a Form

(1)

Selecting and Moving Controls

(2)

Changing a Label's Caption

(2)

Resizing Controls

(1)

Using Form Headers and Form Footers

(2)

Adding a Label to a Form

(1)

Adding a Picture to a Form

(2)

Changing the Background Color of a Form Object

(2)

Session 5.2 Quick Check

(1)

Session 5.3

(1)

Creating a Multi-page Form Using Tab Controls

(4)

Adding a Subform Using Control Wizards

(5)

Using a Filter with a Form

(1)

Using Filter By Form

(3)

Saving a Filter as a Query

(1)

Applying a Filter that Was Saved as a Query

(1)

Session 5.3 Quick Check

(1)

Review Assignments

(2)

Case Problems

(6)

Internet Assignments

(1)

Quick Check Answers

Customizing Reports and Integrating Access with Other Programs

(1)

Creating a Custom Invoices Report and a Report with an Embedded Chart and a Linked Document

Session 6.1

(17)

Creating a Custom Report

(2)

Designing a Custom Report

(1)

Assigning a Conditional Value to a Calculated Field

(2)

Report Window in Design View

(1)

Adding Fields to a Report

(2)

Working with Controls

(1)

Moving and Resizing Controls

(2)

Changing the Caption Property

(2)

Aligning Controls

(3)

Session 6.1 Quick Check

(1)

Session 6.2

(20)

Adding the Date to a Report

(2)

Adding Page Numbers to a Report

(2)

Adding a Title to a Report

(2)

Adding Lines to a Report

(1)

Defining Conditional Formatting Rules

(3)

Sorting and Grouping Data in a Report

(1)

Calculating Group Totals and Overall Totals

(7)

Hiding Duplicate Values in a Report

(1)

Session 6.2 Quick Check

(1)

Session 6.3

(1)

Integrating Access with Other Programs

(1)

Embedding a Chart in a Report

(6)

Linking a Word Document in a Report

(6)

Exporting an Access Query as an Excel Worksheet

(2)

Saving the Worksheet and Exiting Excel

(1)

Session 6.3 Quick Check

(1)

Review Assignments

(1)

Case Problems

(7)

Internet Assignments

(1)

Quick Check Answers

Working with HTML Documents, Data Access Pages, and Hyperlink Fields

(1)

Creating Web-Enabled Information for Valle Coffee

Session 7.1

(24)

Using the Web

(1)

Exporting an Access Table to an HTML Document

(2)

Viewing an HTML Document Using Internet Explorer

(3)

Creating a Data Access Page for an Access Table

(2)

Updating a Data Access Page Using Internet Explorer

(1)

Sorting and Filtering Data Access Page Records

(1)

Creating a Custom Data Access Page

(1)

Creating a Blank Data Access Page in Design View

(2)

Adding Fields to a Data Access Page

(1)

Printing Database Relationships

(1)

Adding Fields and a Title to a Data Access Page

(2)

Moving and Resizing Controls on a Data Access Page

(1)

Resizing a Section and Applying a Special Effect

(1)

Adding and Modifying a Caption Section

(2)

Selecting a Theme

(1)

Saving and Viewing a Data Access Page

(2)

Session 7.1 Quick Check

(1)

Session 7.2

(1)

Importing an HTML Document as an Access Table

(5)

Creating Hyperlinks to Documents in Other Office 2000 Programs

(1)

Creating a Hyperlink Field

(1)

Entering a Hyperlink Field Value

(3)

Using a Hyperlink

(1)

Creating Hyperlinks to World Wide Web Pages

(3)

Session 7.2 Quick Check

(1)

Review Assignments

(2)

Case Problems

(6)

Internet Assignments

(1)

Quick Check Answers

Appendix Relational Databases and Database Design

(1)

Relations

(1)

Keys

(2)

Relationships

(4)

One-to-One

(1)

One-to-Many

(1)

Many-to-Many

(1)

Entity Subtype

(1)

Entity-Relationship Diagrams

(2)

Integrity Constraints

(1)

Dependencies and Determinants

(2)

Anomalies

(1)

Normalization

(6)

First Normal Form

(2)

Second Normal Form

(2)

Third Normal Form

(2)

Review Questions

Microsoft PowerPoint 2000 Level II Tutorials

(1)

Read this Before you Begin

(1)

Preparing and Presenting a Slide Show

(1)

Annual Report of Inca Imports International

Session 3.1

(12)

Planning the Presentation

(1)

Inserting Slides from Another Presentation

(2)

Creating a Design Template

(1)

Creating a Custom Color Scheme

(1)

Creating a Custom Background

(2)

Modifying Fonts

(1)

Saving the Design Template

(1)

Applying Graphics and Sounds

(1)

Adding and Customizing a Scanned Image in the Title Slide

(1)

Adding an Animated GIF

(2)

Adding a Sound Clip

(2)

Session 3.1 Quick Check

(1)

Session 3.2

(1)

Creating a Chart (Graph)

(3)

Building and Modifying an Organization Chart

(4)

Applying Special Effects

(1)

Adding Slide Transitions

(1)

Adding Animation with Sound

(3)

Hiding Slides

(2)

Preparing Presentation Materials

(1)

Preparing 35mm Slides

(1)

Preparing the Presentation to Run on Another Computer

(1)

Session 3.2 Quick Check

(1)

Review Assignments

(1)

Case Problems

(5)

Lab Assignments

(1)

Internet Assignments

(1)

Quick Check Answers

Integrating PowerPoint with Other Programs and with the World Wide Web

(1)

Presenting a Proposal to the Executive Officers

Session 4.1

(14)

Planning the Presentation

(1)

Applying a Design Template from Another Presentation

(2)

Using Integration Techniques: Importing, Embedding, and Linking

(2)

Embedding and Modifying a Word Table

(2)

Linking and Modifying an Excel Chart

(4)

Adding Tab Stops

(2)

Creating a Summary Slide

(2)

Session 4.1 Quick Check

(1)

Session 4.2

(1)

Creating and Editing Hyperlinks

(4)

Adding Action Buttons

(2)

Viewing a Slide Show with Embedded or Linked Objects

(1)

Rehearsing the Presentation

(1)

Generating Meeting Notes and Action Items

(1)

Creating and Customizing a Toolbar

(3)

Publishing Presentations on the World Wide Web

(1)

Saving Presentations as HTML Documents

(2)

Viewing a Presentation in a Web Browser

(2)

Sharing and Collaborating with Others

(2)

Session 4.2 Quick Check

(1)

Review Assignments

(1)

Case Problems

(5)

Lab Assignments

(1)

Internet Assignments

(1)

Quick Check Answers

Microsoft Outlook 2000 Level II Tutorials

(1)

Read this Before you Begin

(1)

Communicating with Outlook 2000

(1)

Sending and Receiving E-mail Messages for The Express Lane

Session 1.1

(13)

Exploring Outlook

(1)

Starting Outlook

(3)

Navigating Between Outlook Components

(1)

Creating and Sending E-mail Messages

(1)

Choosing a Message Format

(1)

Adding a Signature

(1)

Using Stationery

(1)

Creating an E-mail Message

(1)

Sending E-mail

(2)

Organizing Contact Information

(1)

Creating Contacts

(3)

Editing Contacts

(1)

Session 1.1 Quick Check

(1)

Session 1.2

(1)

Receiving E-mail

(1)

Reading Messages

(1)

Replying to and Forwarding Mail

(1)

Printing Messages

(1)

Working with Attachments

(2)

Managing Messages

(1)

Creating a Folder

(1)

Filing Messages

(1)

Archiving Mail Messages

(1)

Finding Messages

(1)

Sorting Messages

(1)

Filtering a View

(1)

Getting Help

(2)

Exiting Outlook

(1)

Session 2.1 Quick Check

(1)

Review Assignments

(1)

Case Problems

(2)

Lab Assignments

(1)

Quick Check Answers

Integrating Outlook Components and Office

(1)

Planning a Meeting about The Express Lane's Web Page

Session 2.1

(1)

Jotting Down Notes

(1)

Creating a Task List

(2)

Assigning Tasks to Others

(1)

Organizing Tasks by Category

(2)

Responding to a Task Request

(1)

Scheduling in Calendar

(2)

Scheduling Appointments and Events

(3)

Scheduling Events

(1)

Printing a Calendar

(1)

Planning a Meeting

(4)

Adding and Removing Meeting Attendees

(1)

Checking Off Completed Tasks

(1)

Saving a Calendar as a Web Page

(2)

Creating a Word Mail Merge from Outlook

(1)

Filtering and Sorting Contacts

(1)

Creating the Form Letter

(2)

Recording the Letter in the Journal

(1)

Removing a Filter and Sort

(1)

Session 2.1 Quick Check

(1)

Review Assignments

(1)

Case Problems

(2)

Quick Check Answers

(2)

Task Reference

(4)

Index

Microsoft PhotoDraw 2000 Level II Tutorials

(1)

Read this Before you Begin

(1)

Working with Pictures, Graphic Objects, and Digital Images in PhotoDraw

(1)

Creating and Modifying Artwork for the Pottery Playground Web Site

Session 1.1

(13)

PhotoDraw Basics

(1)

Starting PhotoDraw

(2)

The PhotoDraw Interface

(1)

Saving a PhotoDraw Picture

(1)

Creating Pictures Using Shapes

(2)

Specifying Colors and Styles for Fill Areas and Outlines

(2)

Moving, Aligning, and Grouping Objects

(1)

Creating, Formatting, and Rotating Text

(1)

Using the PhotoDraw Paintbrushes

(2)

Exiting PhotoDraw

(1)

Session 1.1 Quick Check

(1)

Session 1.2

(12)

Inserting and Editing Graphic Files in a Picture

(2)

Saving PhotoDraw Pictures for Use in Other Programs

(3)

Inserting and Manipulating Digital Images

(1)

Colorizing and Sharpening a Digital Image

(2)

Flipping and Cropping a Digital Image

(1)

Adjusting the Hue and Saturation of a Digital Image

(1)

Fading out a Digital Image

(1)

Changing the Order of PhotoDraw Objects

(1)

Fitting the Picture Area to the Selection

(1)

Session 1.2 Quick Check

(1)

Session 1.3

(1)

Working with Templates

(1)

Opening a PhotoDraw Template

(1)

Customizing a Template

(1)

Using the Save for Use in Wizard

(2)

Previewing and Printing PhotoDraw Pictures

(1)

Session 1.3 Quick Check

(1)

Review Assignments

(1)

Case Problems

(3)

Quick Check Answers

(1)

Task Reference

(1)

Index

Microsoft Publisher 2000 Level II Tutorials

(37)

Read this Before you Begin

(1)

Creating Customized Publications Using a Wizard

(1)

Creating an Invitation for Quality Clocks' 100th Birthday Celebration

Session 1.1

(13)

Publisher Basics

(1)

Starting Publisher and Choosing a Publication Design

(3)

Customizing a Publication Design Using the Wizard

(1)

The Publisher Interface

(1)

Saving a Publication

(1)

Working with Text

(1)

Entering Text

(2)

Formatting Text

(2)

Creating and Formatting Custom Shapes

(2)

Session 1.1 Quick Check

(1)

Session 1.2

(1)

Inserting Pictures into a Publication

(1)

Formatting a Picture Frame

(1)

Using Layout Guides

(2)

Adding Captions to Pictures

(1)

Aligning and Grouping Objects

(1)

Getting Files Ready for Print

(1)

Previewing and Printing a Publisher File

(1)

Using Publisher's Pack and Go Feature

(2)

Saving Your Publication as a Template

(1)

Session 1.2 Quick Check

(1)

Review Assignments

(2)

Case Problems

(4)

Quick Check Answers

Creating Publications from Scratch

(37)

Designing a Class Schedule for The Software Learning Center

Session 2.1

(17)

Starting with a Blank Publication

(1)

Creating Tables

(2)

Creating Ruler Guides

(1)

Snapping Objects to Guides

(2)

Entering Text into Table Cells

(1)

Opening Publisher Files Created on Other Computers

(1)

Creating Text Styles

(2)

Adjusting Rows and Colomns

(3)

Using Find and Replace

(1)

Formatting Tables

(2)

Session 2.1 Quick Check

(1)

Session 2.2

(19)

Inserting Page into Publisher

(1)

Placing Objects on the Publisher Background

(1)

Wrapping Text Around a Picture

(3)

Inserting Clip Art

(3)

Adding an Object to the Design Gallery

(1)

Saving a Publication as a Word 97/2000 Document

(1)

Session 2.2 Quick Check

(1)

Review Assignments

(1)

Case Problems

(6)

Quick Check Answers

(1)

Task Reference

(1)

Index

RENT TEXTBOOKS

New Perspectives on Microsoft Office 2000: Second Course

Why Rent from Knetbooks?

Top 5 reasons to order all your textbooks from Knetbooks:

Related Products