SELECT Series: Microsoft Office XP Volume II / Edition 1by Pam Toliver, Yvonne Johnson
Pub. Date: 10/31/2002
Publisher: Prentice Hall
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… See more details below
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.
and post it to your social network
Most Helpful Customer Reviews
See all customer reviews >