Uh-oh, it looks like your Internet Explorer is out of date.
For a better shopping experience, please upgrade now.
SELECT Series: Microsoft Office XP Volume II / Edition 1 available in Paperback
Temporarily Out of Stock Online
The Select family of books boasts a lively look and feel that takes a step-by-step approach to teaching Office XP tasks. Not only does the user step through the tasks, but the emphasis on projects in this series gives them practical knowledge of Office XP. The series consists of intro and advanced books for the primary Microsoft Office applications. The Select Series is customizable by project and Microsoft Certified to the EXPERT level. The authors have developed the material to reflect the most recent Microsoft Office User Specialist (MOUS) guidelines and objectivesPrepares users with the skills necessary to be productive in today's job market. Each book consist of 6-8 projects that are intended to be learned as a comprehensive unit, but can also be covered separately. Each book contains an Overview of Windows and File Management32 pages of material covering Windows 2000, Windows 98, Windows 95, and Windows NT along with lessons on file management. Introduces the Office 2002 teamwork concept through integrated projectsstep-by-step instructions in three projects designed to integrate files and data among Word, Excel, Access, and PowerPoint. This book in the Select Lab Series is certified to basic and expert levels of Microsoft Office XP (includes Word, Excel, Access, PowerPoint, Office XP, and Windows 98 and higher).
Table of ContentsOutlook Advanced Project.
Word 2002 Volume II. Introducing Word 2000.
I. ADVANCED WORD FORMATTING AND TOOLS.Project 1. Formatting Complex Documents.
Project 2. Creating a Reference Document.
Project 3. Working with Tables, Charts, and Graphics.
Project 4. Collaborating on Document Revisions and Creating a Template.
II. WORKING WITH COMPLEX DOCUMENTS.Project 5. Merging Form Letters and Labels.
Project 6. Creating Forms and Documents for the Web.
Project 7. Navigating Complex Documents.
III. DATA INTEGRATION, COLLABORATION, CUSTOMIZATION AND DISTRIBUTING DOCUMENTS ON THE WORLD WIDE WEB.Project 8. Using Word's Collaboration Features.
Project 9. Working with Forms, Macros and Visual Basic for Applications (VBA).
Project 10. Presenting Integrated Office Data on the World Wide Web.
Appendix: Working with Word.
Excel 2002 Volume II.
I. DESIGNING COMPLEX WORKBOOKS.
Project 2. Completing a Three Dimensional Workspace Using Logical and Lookup Functions.
Project 3. Sorting, Grouping and Filtering Sales Data.
Project 4. Formatting, Displaying, Printing and Publishing Workbooks.
II. ANALYZING DATA WITH EXCEL.
Project 6. Using the Analysis Toolpak to Analyze Sales Transactions.
Project 7. ForecastingValues with What-If Analysis: Using Data Tables, Scenarios, Goal Seek and Solver.
III. INTEGRATING DATA, COLLABORATING WITH OTHERS AND CUSTOMIZING EXCEL 2000.
Project 9. Using Visual Basic for Applications (VBA) to Customize and Automate Excel.
Project 10. Sharing Excel 2000 Data with Other Microsoft Office Applications.
Appendix A: Working with Excel.
Appendix B: Using Excel's Financial Functions to Amortize a Loan.
Integrated Project 1—Integrating Word and Excel.
Access 2002 Volume II. Introducing Access 2002.
I. DATABASE DESIGN.Project 1. Setting Up a Relational Database.
Project 2. Filtering Data and Creating Queries.
Project 3. Creating and Modifying Forms and Reports.
II. MAINTAINING AND CUSTOMIZING A DATABASE.Project 4. Customizing the Database Interface.
Project 5. Integrating Access with the Web.
Project 6. Creating Database Applications.
III. MAINTAINING AND CUSTOMIZING A DATABASE.Project 7. Maintaining Databases Using Access Database Tools.
Project 8. Displaying Access Data on the World Wide Web.
Project 9. Customizing Access Using Macros and Visual Basic for Applications (VBA).
Project 10. Using Access with Excel and Visual Basic.
Appendix: Working with Access.
Integrated Project 2—Integrating Word, Excel, and Access.
POWERPOINT PROJECT 5: BROADCASTING PRESENTATIONS.
Viewing Presentations in Web Browsers.
Scheduling Presentation Broadcasts.
Tracking Broadcast Responses.
Starting Presentation Broadcasts.
Joining Presentation Broadcasts.
Conducting Presentation Broadcasts.
Integrated Project 3—Integrating Word, Excel, Access, and PowerPoint.
About this Series
The Select Series uses a class-tested, highly visual, project-based approach that teaches students through tasks using step-by-step instructions. You will find extensive full-color figures and screen captures that guide learners through the basic skills and procedures necessary to demonstrate proficiency in their use of each software application.
The Select Series introduces an all-new design for Microsoft Office XP The easy-to-follow design now has larger screen shots with steps listed on the left side of the accompanying screen. This unique design program, along with the use of bold color, helps reduce distraction and keeps students focused and interested as they work. In addition, selectively placed Tip boxes and Other Ways boxes enhance student learning by explaining various ways to complete a task.
Our approach to learning is designed to provide the necessary visual guidance in a project-oriented setting. Each project concludes with a review section that includes a Summary, Key Terms & Skills, Study Questions, Guided Exercises, and On Your Own Exercises. This extensive end-of-project section provides students with the opportunity to practice and gain further experience with the tasks covered in each project.
What's New in the Select Series for Office XP
The entire Select Series has been revised to include the new features found in the Office XP suite, which contains Word 2002, Excel 2002, Access 2002, PowerPoint 2002, Publisher 2002, FrontPage 2002, and Outlook 2002.
The Select Series provides students with clear, concise instruction supported by its new design, which includes bigger screen captures.Steps are now located in the margin for ease of use and readability. This instruction is further enhanced by graded exercises in the end-of-project material.
Another exciting update is that every project begins with a Running Case from Selections, Inc., a department store that has opened shop online as e-Selections.com. Students are put in an e-commerce-based business environment so that they can relate what they are learning in Office XP to a real world situation. Everything is within a scenario that puts them in the department store where they perform tasks that relate to a particular division of the store or Web site.
Organization of the Select Series for Office XP
The new Select Series for Office XP includes four combined Office XP texts from which to choose:
- Microsoft Office XP Volume I is MOUS certified at the Core level in each of the major applications in the office suite (Word, Excel, Access, and PowerPoint). Four additional supplementary modules (Introduction to Internet Explorer, Introduction to Windows, Introduction to Outlook, and Common Elements) are also included. In addition, three integrated projects are included which integrate files and data among Word, Excel, Access, and PowerPoint.
- Microsoft Office XP Volume II, MOUS certified at the Expert level, picks up where Volume I leaves off, covering advanced topics for the individual applications.
- Microsoft Office XP Brief provides less coverage of the individual applications than Volume I (a total of four projects as opposed to six). The supplementary modules are also included.
- A new volume, Getting Started with Microsoft Office XP, contains the Introduction and first chapter from each application (Word, Excel, Access, and PowerPoint) plus the four supplementary modules.
Individual texts for Word 2002, Excel 2002, Access 2002, and PowerPoint 2002 provide complete coverage of each application and are MOUS certified. They are available in Volume I and Volume II texts and also as Comprehensive texts.
This series of books has been approved by Microsoft to be used in preparation for Microsoft Office User Specialist exams.
The Microsoft Office User Specialist (MOUS) program is globally recognized as the standard for demonstrating desktop skills with the Microsoft Office suite of business productivity applications (Microsoft Word, Microsoft Excel, Microsoft PowerPoint, Microsoft Access, and Microsoft Outlook). With MOUS certification, thousands of people have demonstrated increased productivity and have proved their ability to utilize the advanced functionality of these Microsoft applications.
Customize the Select Series with Prentice Hall's Custom Binding program. The Select Series is part of the Custom Binding Program, enabling instructors to create their own texts by selecting projects from Office XP to suit the needs of a specific course. An instructor could, for example, create a custom text consisting of the specific projects that he or she would like to cover from the entire suite of products. The Select Series is part of PHit's Value Pack program in which multiple books can be shrink-wrapped together at substantial savings to the student. A value pack is ideal in courses that require complete coverage of multiple applications.
Instructor and Student Resources
Instructor's Resource CD-ROM
The Instructor's Resource CD-ROM that is available with the Select Office XP Series contains:
- Student data files
- Solutions to all exercises and problems
- PowerPoint lectures
- Instructor's manuals in Word format that enable the instructor to annotate portions of the instructor manual for distribution to the class
- A Windows-based test manager and the associated test bank in Word format