Office 2000 Essentials

For courses in Microsoft Office Professional for Windows, Access for Windows, Excel for Windows, PowerPoint for Windows, and Word for Windows. Essentials courseware is anchored in the practical and professional needs of all types of students. The series has been completely revamped as the result of extensive usability testing conducted by students with multiple levels of computer knowledge. The Essentials series is conceived as a 'learning system' that combines graphics, instructions, experience, reinforcement, and problem solving. It consists of modular lessons that are built around a series of numbered, step-by-step procedures that are clear, concise, and easy to review. Explanatory material is interwoven before each lesson and between the steps. Additional features, tips, pitfalls, and other related information are provided at exactly the right place. They are easily recognizable elements that stand out from the main flow of the tutorial. Icons are designed to match the Microsoft Office theme. The end-of-chapter exercises have been carefully graded from the routine Checking Concepts and Terms to tasks in the Discovery Zone that gently prod students into extending what they have learned into areas beyond the explicit scope of the lessons proper. Substantial Focus On Learning and How To Learn. * Guided use of onscreen Help within lessons and end-of-project exercises. * Helps students 'learn to learn' on their own to keep up with the ever-expanding feature set of Microsoft Office. Shows them how to discover the right procedures or answers by exploiting the many resources that are already within the application. Hands-On Exercises: Expanded into Three Levels. * Skill Drill exercises--Reinforce project skills. Each skill that is reinforced is the same, or nearly the same, as a skill presented in the project. Detailed instructions are provided in a step-by-step format. * Enables students to check their comprehension, evaluate their progress, and practice what theyve learned. * Challenge exercises--Expand upon or are related to skills presented in the lessons. Each exercise provides a brief narrative introduction, followed by instructions in a numbered step format that are not as detailed as those in the Skill Drill section. Some contain references for students to apply tips discussed in Nice to Know, Need to Know, or Help. * Helps students learn to think on their own and fosters the 'near transfer' of learning. * Discovery Zone exercises--Require advanced knowledge of topics presented in Essentials lessons, the application of skills from multiple lessons, or self-directed learning of new skills. Some contain references for students to apply tips discussed in Nice to Know, Need to Know, or Help. * Emulates real-world experience by encouraging self-directed learning of new skills. Beginning of the Project. * Objectives--Specific topics covered in the lessons. * Gives students short-term, attainable goals for each project. * Key Terms--New terminology defined and discussed in the project. * Helps students to become familiar with the terminology used. * Why Would I Do This?--Introductory section telling students why a project is useful to them. * Shows students why a project is useful to them and what they can do with the knowledge they obtain. * Visual Summary--Screen shots and sample documents to illustrate what students will learn in the project. * Illustrates the concepts and features students will learn in the project and helps to keep them motivated. Lessons. * Lessons--Projects broken down into lessons that correspond with objectives. * Gives students the project broken down into lessons that correspond with objectives. * Step-by-Step Instructions--Instructions, along with explanation, to guide students as they learn new features. * Guides students as they learn new features, and lets them 'learn-by-doing.' * If You Have Problems-- Trouble-shooting tips that anticipate common pitfalls. * Helps students anticipate or solve common problems quickly and effectively. * Need to Know--Essential notes and information necessary to apply features. * Provides students with essential tips for performing the task and using the application more effectively. * Nice to Know--Additional tips to become more proficient in using the software. * Provide students with extra tips, shortcuts, alternative ways to complete a process, and special hints about using the software. Checking Concepts and Terms. * True/False Questions --With reference to lesson where topic is covered. * Multiple Choice Questions--With reference to lesson where topic is covered. * Screen ID--Where students identify elements of the screen and within documents. * Discussion Questions--That make students apply critical-thinking skills to further understand concepts and features. * Helps students check their comprehension and assess their retention.

Table of Contents:
I. BASICS. Project 1. Working with Windows. Starting Windows and Using the Mouse. Using the Start Button. Resizing and Moving a Window. Scrolling a Window. Maximizing, Restoring, Minimizing, and Closing a Window. Using the Taskbar to Work in Multiple Windows. Using the Windows Help System. Shutting Down Your Computer. Project 2. Windows Disk and File Management. Formatting a Disk. Creating a Folder. Copying a File. Renaming a File or Folder. Moving a File. Deleting a File or Folder. Copying a Floppy Disk. Project 3. Working with Office 2000. Launching and Exiting an Office Application. Opening, Editing, and Saving an Existing Document. Using Menus and Toolbars. Saving a Document with a New Name. Printing a Document Using the Toolbar Button and the Menu. Getting Help Using the Office Assistant. Getting Help Online. II. WORD. Project 1. Getting Started with Word. Opening a New Document and Entering Text. Moving Around in a Document. Correcting Errors using the Backspace and Delete Keys. Correcting Spelling and Grammar Errors. Saving, Printing, and Closing a Document, and Exiting from Word. Project 2. Editing a Document. Opening an Existing Document and Saving It with a Different Name. Inserting Text. Using the Click and Type Feature. Selecting Text to Delete or Replace. Moving Text using Cut-and-Paste. Using Undo and Redo. Moving Text Using Drag-and-Drop. Printing a Document using the Menu. Project 3. Formatting Text. Changing the Font Type, Size, and Emphasis. Aligning Text in a Paragraph. Changing Line Spacing. Creating a Bulleted List. Indenting the First Line of a Paragraph. Using the Format Painter. Creating a Hanging Indent. Adding Spaces after Paragraphs. Working with Tabs. Project 4. Formatting a Document. Setting Margins. Inserting Page Numbers. Creating a Header or Footer. Inserting Page Breaks. Working with Clip Art. Using Print Preview. Project 5. Working with Tables. Inserting a Table. Entering Information into a Table. Adding Rows and Columns to a Table. Using AutoFormat. Aligning Text and Aligning a Table. III. EXCEL. Project 1. Introduction to Excel. Navigating a Workbook. Selecting Individual Cells. Entering Text and Numbers into Cells. Editing the Contents of a Cell. Inserting and Deleting Rows or Columns. Saving a Workbook, Printing the Worksheet, and Exiting Excel. Project 2. Enhancing the Appearance of the Worksheet. Opening a File and Selecting Groups of Cells. Formatting Large Numbers, Currency, Decimal Places, and Dates. Adjusting Columns and Cells for Long Text or Numbers. Aligning Text in the Cell. Changing the Font, Size and Emphasis of Text. Adding Lines, Borders, Colors, and Shading. Renaming a Worksheet. Project 3. Techniques for Working Efficiently in Excel. Creating Sequential Text Headings. Creating a Series of Numbers. Changing Zoom and Freezing Panes. Copying Cell Contents. Improving the Printed Worksheet. Previewing Print Settings and Printing a Range. Project 4. Making the Computer Do the Math. Adding, Subtracting, Multiplying and Dividing Using Cell References and Numbers. Creating Formulas with More Than One Cell Reference. Combining Operations and Filling Cells with Formulas. Filling Cells with Relative and Absolute Formulas. Applying Basic Formulas to a Loan Repayment. Using Built-in Financial Formulas. Using Counting and Conditional Formulas. Using Excel to Explore Different Possibilities. Project 5. Understanding the Numbers using a Chart. Creating a Chart to Show a Trend. Creating a Chart to make Comparisons. Creating a Chart to Show Contributions to a Whole. Editing Chart Elements. Printing a Chart. Project 6. Using Excel's Interactive Features. Inserting and Moving a New Sheet. Designing a Summary Sheet for Convenient Charting. Linking the Results of Several Sheets to a Summary Sheet. Inserting a Hyperlink to Another Workbook. Using a Worksheet on the Web. IV. ACCESS. Project 1. Creating a Database. Creating a New Database. Creating a New Table. Saving a Table Design and Creating a Primary Key. Adding Fields. Editing Fields. Changing Views and Moving Fields. Deleting Fields. Project 2. Entering and Editing Data. Adding Records. Moving Among Records. Editing Records. Inserting and Deleting Records. Adjusting Column Widths and Hiding Columns. Finding Records. Sorting Records. Project 3. Querying Your Database. Creating a New Query. Choosing Fields for a Query. Saving the Query. Editing the Query. Changing Field Order and Sorting the Query. Matching Criteria. Saving a Query with a New Name and Opening Multiple Queries. Project 4. Creating and Using Forms. Creating an AutoForm. Entering and Editing Data Using a Form. Saving, Closing and Opening a Form. Creating a New Form from Scratch. Adding Fields to Forms. Moving and Resizing Fields in Forms. Adding a Form Header and Label. Project 5. Creating and Printing Records. Printing the Table Data. Creating a Report Using the Report Wizards. Printing and Renaming a Report. Modifying a Report Design. Saving the Report with a New Name. Adding Labels to Reports. Project 6. Interacting and Connecting. Converting a Database from a Previous Version of Access. Linking an Access Table to a Form Letter in Word. Merging an Access Table with a Form Letter. Importing a Table from Excel. Saving a Form as a Data Access Page. Using a Browser to Interact with the Database. V. POWERPOINT. Project 1. Getting Started with PowerPoint. Opening a Blank Presentation and Identifying Parts of the PowerPoint Window. Entering Text in Normal View. Using Slide View and Outline View to Edit Text. Saving a Presentation and Adding Speaker Notes. Previewing a Slide Show. Printing an Outline. Project 2. Improving the Design of the Presentation. Opening an Existing Presentation and Applying a Design. Inserting Clip Art. Adding A WordArt Image. Adding Text Objects. Adding Connector Lines between Objects. Printing Audience Handouts. Project 3. Charting Numerical Data. Replacing Sample Data. Choosing a Chart Type. Switching Columns and Rows. Modifying a Chart. Project 4. Adding Animations for the Slide Show. Using the Slide Sorter View to Change Sequence. Animating the Transition from One Slide to the Next. Animating Text. Dimming Previously Displayed Text. Project 5. Working with Master Pages. Modifying Font Characteristics in the Slide Master. Changing the Bullet Type in the Slide Master. Adding Footer Information to the Slide Master. Adding Header and Footer Information to the Handout Master. VI. OUTLOOK AND PUBLISHER. Using Outlook to Manage Time and Contacts. Navigating in Outlook. Creating Personal Folders. Entering Appointments in the Calendar. Entering Tasks. Entering Contacts. Printing Information in Outlook. Creating a Web Page with Publisher. Launching Publisher and Creating a Web Page using a Wizard. Editing and Inserting Text from Microsoft Word. Adding a New Linked Page and Inserting Web Page Objects. Adding, Moving, and Resizing Pictures. Inserting a Table from Excel. Working with Clip Art. Wrapping Text around Graphics. Inserting a Logo. Putting the Finishing Touches on Your Web Page and Viewing It with a Browser.