DDC Learning Microsoft Office XP

by Weixel, Suzanne; Fulton, Jennifer; Wempen, Faithe; Plumley, Sue

• ISBN13: 9781585771356
• ISBN10: 158577135X
• Edition: 1st
• Format: Spiral Bound
• Copyright: 2002-01-01
• Publisher: Prentice Hall

Summary

Learning Microsoft Office XPprovides readers with a total-immersion, hands-on tutorial that walks them step by step, mouse-click by mouse-click, keystroke by keystroke through essential features of Word, Excel, PowerPoint, and Access. Designed for readers at a variety of skill levels, the well-illustrated, spiral-bound manual contains easy-to-read, appealingly formatted procedural explanations and step-by-step exercises in a multi-part Lesson format. Real-life, on-the-job exercise scenarios make content immediately relevant. An accompanying CD-ROM includes data files and a host of other resources.Word 2002 (Basic Editing Skills; Formatting Basics; Using the Internet and E-mail; Creating Web Pages; Creating Tables; Creating Documents with Merge; Creating and Editing Longer Documents; Enhancing Documents and Automating Tasks). Excel 2002 (Working with Formulas and Formatting; Working with Functions, Formulas, and Charts; Advanced Printing, Formatting, and Editing; Advanced Chart Techniques; Working with Lookup Functions, PivotCharts, and PivotTables; Internet and Integration with Excel). Access 2002 (Working with Tables and Datasheets; Simplifying Data Entry with Lookups and Forms; Find Information in a Database; Display Information with Reports). PowerPoint 2002 (Editing and Formatting a Presentation; Starting Up a Slide Show).For anyone who wants to develop skills in using the features of the various components of Microsoft Office XP.

Table of Contents

Getting Started With Office XP-Included On CD (Exercise 1-4)

Word 2002

Getting Started with Word 2002 (Exercises 1-8)

Basic Editing Skills (Exercises 9-14)

Formatting Basics (Exercises 15-21)

Using the Internet and E-mail

Creating Web Pages (Exercise 22-26)

Creating Tables (Exercises 27-31)

Creating Documents with Merge (Exercises 32-35)

Creating and Editing Longer Documents (included on CD) (Exercises 36-41)

Enhancing Documents and Automating Tasks (included on CD) (Exercises 42-49)

Excel 2002

Getting Started with Excel (Exercises 1-6)

Working with Formulas and Formatting (Exercises 7-12)

Working with Functions, Formulas, and Charts (Exercises 13-19)

Advanced Printing, formatting, and Editing (Exercises 20-27)

Advanced Chart Techniques (included on CD) (Exercises 28-31)

Working with Lookup Functions, PivotCharts, and PivotTables (included on CD) (Exercises 32-35)

Internet and Integration with Excel (included on CD) (Exercises 36-39)

Access 2002

Getting Started with Access 2002 (Exercises 1-6)

Working with Tables and Datasheets (Exercises 7-10)

Simplifying Data Entry with Lookups and Forms (Exercises 11-16)

Find Information in a Database (Exercises 17-23)

Display Information with Reports (included on CD) (Exercises 24-28)

Powerpoint 2002

Getting Started with PowerPoint 2002 (Exercises 1-7)

Editing and Formatting a Presentation (Exercises 8-16)

Starting Up a Slide Show (Exercise 17-24)

Challenge Lesson-Included On CD (Exercises 1-9)

Table of Contents provided by Publisher. All Rights Reserved.

Excerpts

Microsoft Office XP is Microsoft's suite of application software. The Standard version includes Word, Excel, Outlook, and PowerPoint. The Professional version includes the above applications plus Access. This book covers Word (the word processing tool), Excel (the spreadsheet tool), PowerPoint (the presentation tool), and Access (the database tool). Because Microsoft Office is an integrated suite, the components can all be used separately or together to create professional-looking documents and to manage data. How We've Organized the BookLearning Microsoft Office XP is made up of seven sections: Basics--Included on CD This short chapter introduces essential Office skills--including starting Microsoft Office, using the mouse and keyboard, screen elements, and an overview of the applications. If you are completely new to the Office suite, you should start with this lesson. All of the lessons on CD can be printed out or viewed on-screen. See page ix for details on how to access the files. Word 2002 With Word you can create letters, memos, Web pages, newsletters, and more. Excel 2002 Excel, Microsoft's spreadsheet component, is used to organize and calculate data, track financial data, and create charts and graphs. Access 2002 Access is Microsoft's powerful database tool. Using Access you will learn to store, retrieve, and report on information. PowerPoint 2002 Create dynamic on-screen presentations with PowerPoint, the presentation graphics tool. Challenge Lesson--Included on CD This chapter combines critical thinking, application integration, and Internet skills. In the Challenge Lesson, you will retrieve data from the Internet, send Web documents via e-mail, download clip art and add it to a PowerPoint presentation, create a Web page, and more. In each exercise, only basic step directions are given--you need to rely on your own skills to complete the exercise. Advanced Lessons--Included on CD These lessons cover advanced Word, Excel, and Access skills.Each chapter inLearning Microsoft Office XPis made up of several lessons. Lessons are comprised of short exercises designed for using Office XP in real-life business settings. Every application exercise (except for the Critical Thinking Exercises and the Challenge Exercises) is made up of seven key elements: On the Job.Each exercise starts with a brief description of how you would use the features of that exercise in the workplace. Exercise Scenario.The Office tools are then put into context by setting a scenario. For example, you may be a designer putting together a promotional sales flyer using Word or you may be responsible for tracking inventory for a gourmet-food store. Terms.Key terms are included and defined at the start of each exercise, so you can quickly refer back to them. The terms are then highlighted in the text. Notes.Concise notes for learning the computer concepts. Procedures.Hands-on mouse and keyboard procedures teach all necessary skills. Application Exercise.Step-by-step instructions put your skills to work. On Your Own.Each exercise concludes with a critical thinking activity that you can work through on your own. You may have to create a personal budget spreadsheet in Excel or a personal Web page in Word. You are challenged to come up with data and then additionally challenged to use the data in a document. TheOn Your Ownsections can be used as additional reinforcement, for practice, or to test skill proficiency. In addition, each lesson ends with aCritical Thinking Exercise.As with theOn Your Owns,you need to rely on your own skills to complete the task.