Microsoft Office 2000 Step by Step Learning Kit

by Microsoft Press

• ISBN13: 9780735605084
• ISBN10: 0735605084
• Format: Paperback
• Copyright: 1999-05-01
• Publisher: Microsoft Pr

Summary

The "Microsoft Office 2000 Step By Step Learning Kit" uniquely combines the learning advantages of the proven step-by-step tutorials and those of interactive computer-based training. Users can easily choose what they learn and how they learn it by using both print and interactive lessons. The companion CD-ROM contains sample files for step-by-step lessons and Starts Here multimedia lessons.

Table of Contents

Using the Microsoft Office 2000 Step by Step Interactive CD	vii
Installing Office 2000 SBSI and the Practice Files	vii
Using Office 2000 SBSI	viii
Using the Practice Files	viii
Uninstalling Office 2000 SBSI	xi
Uninstalling the Practice Files	xii
Need Help with the Office 2000 Step by Step Learning Kit?	xii
Part 1 Creating Business Information	1	(110)
Using Templates and Forms in Word	3	(26)
Using Templates and Wizards	4	(4)
Saving a Document as a Template	8	(2)
Using Electronic Forms	10	(5)
Inserting Fields and Controls	15	(5)
Inserting Calculation Fields	20	(3)
Protecting Electronic Forms	23	(1)
Filling Out an Electronic Form	24	(3)
Lesson 1 Quick Reference	27	(2)
Filtering to Find Information in Excel	29	(12)
Locating a Set of Records by Filtering	30	(4)
Calculating Filtered Sets of Records	34	(5)
Lesson 2 Quick Reference	39	(2)
Using Forms and Tables in Access	41	(30)
Opening a Database	42	(2)
Understanding Forms	44	(1)
Entering and Updating Data	44	(5)
Entering Data Efficiently and Correctly	49	(3)
Finding Records	52	(2)
Adding and Removing Record Text	54	(6)
Understanding Tables	60	(1)
Viewing a Datasheet	61	(4)
Viewing Multiple Tables with a Subform	65	(3)
Lesson 3 Quick Reference	68	(3)
Applying and Modifying Templates in PowerPoint	71	(20)
Understanding and Applying Templates	72	(2)
Understanding PowerPoint Masters	74	(3)
Changing the Display Using the Master	77	(1)
Modifying Master Placeholders	78	(1)
Formatting Master Text	79	(4)
Adjusting Master Text Indents	83	(3)
Reapplying a Slide Layout	86	(1)
Saving a Presentation as a Template	87	(2)
Lesson 4 Quick Reference	89	(2)
Creating and Editing One-Page Publications in Publisher	91	(20)
Entering Personal Information	92	(1)
Creating a Business Card	93	(1)
Viewing Frames and Frame Content	94	(1)
Viewing Different Mouse Pointers	95	(2)
Using the Logo Creation Wizard	97	(2)
Moving and Resizing Frames	99	(1)
Changing Font Attributes	100	(3)
Saving a Publication	103	(1)
Creating Letterhead	104	(1)
Changing the Viewing Size of Your Publications	105	(2)
Lesson 5 Quick Reference	107	(4)
Part 2 Making Changes	111	(126)
Mastering Indents, Tabs, and Tables in Word	113	(24)
Displaying the Ruler	115	(1)
Understanding Indents and Tabs	115	(1)
Working with Indents	116	(3)
Creating Bulleted and Numbered Lists	119	(1)
Using the New Line Character	120	(1)
Using Picture Bullets	121	(1)
Using Tabs	122	(1)
Using the Ruler to Set Tabs	123	(4)
Working with Tables	127	(4)
Formatting Tables	131	(3)
Lesson 6 Quick Reference	134	(3)
Enhancing Documents with Columns and Art in Word	137	(24)
Creating Columns	139	(5)
Creating and Placing Text Boxes	144	(4)
Applying Drop Caps	148	(1)
Working with the Word Clip Gallery	149	(1)
Creating Graphics with the Drawing Toolbar	150	(5)
Adding 3-D Effects and Color to Graphics	155	(2)
Lesson 7 Quick Reference	157	(4)
Using a Color Scheme in PowerPoint	161	(12)
Viewing and Choosing a Color Scheme	162	(2)
Changing Colors in a Color Scheme	164	(2)
Creating a New Color Scheme	166	(1)
Adding New Colors to Color Menus	167	(2)
Adding a Background	169	(2)
Copying a Color Scheme	171	(1)
Lesson 8 Quick Reference	172	(1)
Drawing and Modifying Objects in PowerPoint	173	(30)
Drawing an Object	174	(2)
Editing an Object	176	(7)
Modifying Object Attributes	183	(4)
Aligning Objects	187	(2)
Connecting Objects	189	(3)
Adding 3-D Effects to Objects	192	(1)
Changing Object Stacking Order	193	(1)
Rotating and Flipping Objects	194	(1)
Drawing and Editing an Arc Object	195	(3)
Grouping and Ungrouping Objects	198	(2)
Lesson 9 Quick Reference	200	(3)
Working with Text in Publisher	203	(20)
Typing Text in a Text Frame	203	(5)
Creating a Text Frame	208	(1)
Picking Up and Applying Existing Formats	209	(1)
Working with Columns and Autoflow Text	210	(4)
Disconnecting and Reconnecting Frames	214	(2)
Rotating Text	216	(2)
Editing Text in Microsoft Word	218	(1)
Adding a Drop Cap	219	(2)
Lesson 10 Quick Reference	221	(2)
Working with Multiple Frames and Objects in Publisher	223	(14)
Placing a Picture Frame Within a Text Frame	224	(1)
Cropping a Picture	225	(3)
Combining Text, Shapes, and Pictures	228	(4)
Grouping and Ungrouping Frames	232	(3)
Lesson 11 Quick Reference	235	(2)
Part 3 Sharing Business Information	237	(56)
Managing Your Calendar in Outlook	239	(32)
Getting Ready for the Lesson	240	(1)
Navigating in Calendar	241	(1)
Scheduling Appointments	242	(9)
Managing Appointments	251	(8)
Personalizing Your Calendar	259	(7)
Lesson 12 Quick Reference	266	(5)
Managing Meetings and Events in Outlook	271	(22)
Getting Ready for the Lesson	272	(2)
Using E-mail to Plan a Meeting	274	(7)
Responding to Meeting Requests	281	(2)
Changing Meeting Information After Sending the Invitation	283	(2)
Managing Meeting Requests Automatically	285	(2)
Setting Up an Event	287	(1)
Lesson 13 Quick Reference	288	(5)
Part 4 Synthesizing and Managing Information	293	(58)
Consolidating Multiple Lists in Excel	295	(12)
Opening Groups of Workbooks	296	(2)
Viewing and Arranging Groups of Workbooks	298	(2)
Combining Groups of Workbooks	300	(2)
Creating a Year-to-Date Summary and Chart	302	(3)
Lesson 14 Quick Reference	305	(2)
Creating PivotTable Reports in Excel	307	(22)
Creating a Dynamic Summary with a PivotTable	308	(6)
Using Data from Other Programs	314	(4)
Changing the Data Displayed	318	(4)
Showing Cost by Category	322	(2)
Refreshing PivotTable Report Data	324	(1)
Showing Details of a Calculation	324	(2)
Lesson 15 Quick Reference	326	(3)
Organizing and Managing the Inbox in Outlook	329	(22)
Getting Ready for the Lesson	330	(1)
Organizing Your Inbox for Fast Review	331	(2)
Organizing Your E-mail Messages into Folders	333	(4)
Flagging E-mail Messages for Follow-up	337	(3)
Creating Rules to Automatically Organize and Manage Your Inbox	340	(4)
Using the Out of Office Assistant	344	(1)
Lesson 16 Quick Reference	345	(6)
Part 5 Analyzing Information	351	(44)
Managing Database Change in Access	351	(22)
Modifying Database Tables	352	(6)
Changing a Table in Design View	358	(3)
Improving Data Entry and Display	361	(3)
Connecting a New Table to a Database	364	(7)
Lesson 17 Quick Reference	371	(2)
Keeping Database Information Reliable in Access	373	(22)
Validating Data in a Form	374	(11)
Validating Records Across Related Tables	385	(5)
Resolving Many-to-Many Relationships	390	(3)
Lesson 18 Quick Reference	393	(2)
Index	395