Microsoft Office XP Introductory Tutorial

by Pasewark and Pasewark

• ISBN13: 9780619058432
• ISBN10: 0619058439
• Edition: 1st
• Format: Spiral Bound
• Copyright: 2001-09-18
• Publisher: Course Technology

Summary

Part of the South-Western Computer Education Series, this text includes features that make learning easy and enjoyable - yet - challenging for learners. The text includes a wide range of learning experiences from activities with one or two commands to simulations and case studies that challenge and sharpen learners' problem-solving skills. This book is ideal for computer courses with learners who have varying abilities and previous computer experiences. The book covers Office 2000 Basics and the Internet, Word, Excel, Access. PowerPoint, Outlook, Publisher and FrontPage.

Table of Contents

How to Use This Book	iv
Preface	vi
What's New	ix
Start-Up Checklist	x
Guide for Using this Book	x
The Microsoft Office User Specialist Program	xiii
UNIT Introduction
Microsoft Office XP Basics and the Internet	1	(1)
UNIT Introductory Microsoft Word
Word Basics	2	(18)
Introduction to Word Processing	2	(1)
Creating a New Word Document	3	(1)
Viewing the Document Screen	4	(1)
Understanding the Normal View Screen	4	(1)
Text Entry and Word Wrap	5	(1)
Navigating Through a Document	6	(2)
Saving a File	8	(1)
Locating and Opening an Existing Document	9	(1)
Previewing Your Document	10	(2)
Printing Your Document	12	(1)
Selecting a Page Orientation	13	(2)
Summary	15	(5)
Basic Editing	20	(13)
Selecting Text	20	(2)
Using the Backspace and Delete Keys	22	(1)
Using Overtype	22	(1)
Using Undo and Redo	23	(1)
Moving and Copying Text	24	(3)
Summary	27	(6)
Helpful Word Features	33	(21)
Automatic Features	33	(8)
Using the Spelling and Grammar Checker	41	(2)
Inserting the Date and Time	43	(1)
Using the Theasurus	44	(2)
Using Find and Replace	46	(4)
Summary	50	(4)
Formatting Text	54	(13)
Formatting Text	54	(1)
Using Fonts	55	(7)
Copying Format and Style	62	(1)
Summary	63	(4)
Formatting Paragraphs and Documents	67	(23)
Formatting Documents	67	(1)
Setting Margins	67	(2)
Aligning Text	69	(1)
Changing Indents and Spacing	70	(3)
Changing Vertical Alignment	73	(1)
Using Click and Type	74	(1)
Setting Tab Stops	75	(2)
Bulleted and Numbered Lists	77	(2)
Outline Numbered List	79	(4)
Sorting Text in a Document	83	(2)
Summary	85	(5)
Desktop Publishing with Word	90	(22)
What Is Desktop Publishing?	90	(1)
Creating Columns	90	(2)
Using Borders and Shading	92	(3)
Working with Graphics	95	(9)
Creating Diagrams and Charts	104	(3)
Summary	107	(5)
Working with Documents	112	(27)
Switching Between Documents	112	(1)
Copying and Pasting Text Between Documents	113	(1)
Inserting Page Breaks	114	(1)
Working with Multipage Documents	115	(4)
Inserting Headers and Footers	119	(2)
Creating Footnotes and Endnotes	121	(2)
Creating a Section with Formatting That Differs from Other Sections	123	(1)
Applying Styles	124	(1)
Inserting and Formatting Tables	125	(5)
Organizing a Document in Outline View	130	(3)
Assigning Outline Levels to Paragraphs	133	(1)
Summary	134	(5)
Increasing Efficiency Using Word	139
Using Templates and Wizards	139	(6)
Workgroup Collaboration	145	(5)
Creating and Printing Envelopes	150	(2)
Creating and Printing Labels	152	(1)
Using Mail Merge	153	(2)
Creating a Web Page	155	(5)
Sending a Word Document via E-mail	160	(1)
Linking Data	160	(3)
Summary	163	(4)
Unit Review	167
Unit Introductory Microsoft Excel
Excel Basics	2	(19)
What Is Excel?	2	(1)
Starting Excel	3	(2)
Opening an Existing Worksheet	5	(1)
Moving the Highlight in a Worksheet	6	(2)
Selecting a Group of Cells	8	(1)
Entering Data in a Cell	9	(2)
Changing Data in a Cell	11	(1)
Searching for Data	12	(2)
Zoom View	14	(1)
Saving a Worksheet	14	(1)
Printing a Worksheet	15	(1)
Summary	16	(5)
Changing the Appearance of a Worksheet	21	(20)
Changing the Size of a Cell	21	(2)
Positioning Text Within a Cell	23	(4)
Changing Cell Appearance	27	(3)
Cell Formats	30	(5)
Summary	35	(6)
Organizing the Worksheet	41	(22)
Copying Data	41	(5)
Moving Data	46	(1)
Inserting and Deleting Rows and Columns	47	(1)
Freezing Titles	48	(2)
Printing Options	50	(4)
Checking Spelling on a Worksheet	54	(2)
Summary	56	(7)
Worksheet Formulas	63	(19)
What Are Formulas?	63	(1)
Structure of a Formula	64	(2)
Editing Formulas	66	(1)
Relative, Absolute, and Mixed Cell References	67	(2)
Creating Formulas Quickly	69	(2)
Previewing a Calculation	71	(1)
Formula Helpers	72	(3)
Summary	75	(7)
Function Formulas	82	(20)
Function Formulas	82	(1)
Parts of Function Formulas	82	(2)
Types of Functions	84	(10)
Summary	94	(8)
Making the Worksheet Useful	102	(27)
Sorting Data	102	(1)
AutoFilter	103	(2)
Hiding Columns and Rows	105	(1)
Using Draw in the Worksheet	106	(3)
Adding a Picture to a Worksheet	109	(5)
Using Templates	114	(3)
Inserting Hyperlinks in Files	117	(1)
Saving Workbooks in Different Formats	118	(2)
Viewing and Editing Comments	120	(3)
Summary	123	(6)
Working with Multiple Worksheets	129	(13)
Worksheets in a Workbook	129	(1)
Identifying Worksheets	129	(2)
Positioning Worksheets in a Workbook	131	(1)
Consolidating Workbook Data	132	(2)
Printing a Workbook	134	(3)
Summary	137	(5)
Worksheet Charts	142
What Is a Worksheet Chart?	142	(2)
Types of Worksheet Charts	144	(2)
Creating a Chart from a Worksheet	146	(1)
Creating a Chart Sheet	146	(5)
Creating an Embedded Chart	151	(2)
Creating Other Types of Charts	153	(8)
Summary	161	(7)
Unit Review	168	(9)
Excel Function Reference	177
UNIT Introductory Microsoft Access
Access Basics	2	(23)
Database Basics	2	(1)
Starting Access	3	(1)
Opening a Database	4	(3)
Creating a Database	7	(12)
Summary	19	(6)
Manipulating Data	25	(16)
Editing Records	25	(5)
Changing Datasheet Layout	30	(6)
Summary	36	(5)
Creating and Modifying Forms	41	(19)
Creating Forms	41	(8)
Modifying Forms	49	(6)
Compacting and Repairing a Database	55	(1)
Summary	56	(4)
Finding and Ordering Data	60	(24)
Using Find	60	(2)
Using Queries	62	(8)
Sorting	70	(3)
Indexing	73	(1)
Setting a Primary Key	73	(1)
Relationships	74	(3)
Creating a Multitable Query	77	(3)
Summary	80	(4)
Reports and Macros	84	(20)
Reports	84	(12)
Macros	96	(4)
Summary	100	(4)
Integrating Access	104
Importing and Exporting Data	104	(3)
Form Letters	107	(6)
Data Access Pages	113	(4)
Summary	117	(4)
Unit Review	121
UNIT Introductory Microsoft PowerPoint
PowerPoint Basics	2	(14)
Introduction to PowerPoint	2	(1)
Starting PowerPoint	2	(1)
Opening and Viewing an Existing Presentation	3	(2)
Saving a Presentation	5	(1)
Changing Views	6	(3)
Using Menus and Toolbars	9	(1)
Deleting Slides	10	(1)
Printing a Presentation	11	(1)
Closing a Presentation and Exiting PowerPoint	12	(1)
Summary	13	(3)
Enhancing a PowerPoint Presentation	16	(30)
Creating a Presentation	16	(2)
Applying a Design Template	18	(2)
Format a Single Slide	20	(1)
Use the Slide Master	21	(2)
Working with Text	23	(6)
Check Spelling and Style	29	(1)
Adding a Slide	30	(1)
Formatting Slides	31	(1)
Using Multimedia	32	(6)
Adding a Header or Footer	38	(2)
Use Slide Transitions	40	(1)
Saving a Presentation as Rich Text Format	41	(1)
Summary	42	(4)
Working with Visual Elements	46	(23)
Working with Organization Charts	46	(3)
Working with Charts	49	(3)
Working with Tables	52	(3)
Creating Shapes and Objects	55	(2)
Manipulating Objects	57	(6)
Create a Text Box	63	(3)
Summary	66	(3)
Expanding on PowerPoint Basics	69
Integrating PowerPoint with Other Office Programs	69	(8)
Working with Multiple Presentations	77	(2)
Formatting Text and Objects	79	(1)
Aligning Text and Pictures	80	(1)
Delivering a Presentation	81	(6)
Publishing Presentations to the Web	87	(3)
Sending a Presentation via E-mail	90	(4)
Summary	94	(3)
Unit Review	97
UNIT Introductory Microsoft Outlook
Outlook Basics and E-mail	2	(23)
Introducing Outlook	2	(2)
Creating a Contacts List	4	(5)
Using E-mail	9	(3)
Creating an Address Book	12	(9)
Summary	21	(4)
Calendar	25	(17)
Introducing Calendar	25	(13)
Summary	38	(4)
Working with Other Outlook Tools	42
Using Outlook Today	42	(2)
Creating a Tasks List	44	(8)
Using the Journal	52	(2)
Using Notes	54	(2)
Exiting Outlook	56	(1)
Summary	57	(3)
Unit Review	60
UNIT Introductory Microsoft Publisher & Microsoft FrontPage
Publisher Basics	2	(14)
Introduction to Publisher	2	(1)
Starting Publisher	2	(1)
Starting a Project	3	(1)
Personal Information Sets	4	(2)
Adding a Logo	6	(2)
By Design Sets	8	(3)
Other Types of Publications	11	(2)
Summary	13	(3)
FrontPage Basics	16
Introduction to FrontPage	16	(3)
Creating a New Web Site	19	(20)
Publishing Webs	39	(1)
Summary	40	(4)
Unit Review	44
Capstone Simulation	1	(1)
Appendix A: The Microsoft Office User Specialist Program	1	(1)
Appendix B: Windows Basics	1	(1)
Appendix C: Computer Concepts	1	(1)
Appendix D: Using Microsoft Office XP Speech Recognition	1	(1)
Glossary	1	(1)
Index	1