SELECT Series: Microsoft Excel Comprehensive, Volume I and II 2002 / Edition 1

SELECT Series: Microsoft Excel Comprehensive, Volume I and II 2002 / Edition 1

by Pamela R. Toliver, Donna N. Losciuto Lane, Donna N. Lane, Yvonne Johnson
     
 

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

Overview

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 objectives—Prepares 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 Management—32 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 projects—step-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).

Read More

Product Details

ISBN-13:
9780130664501
Publisher:
Pearson Education
Publication date:
10/07/2002
Series:
Select Series
Edition description:
SPIRAL
Pages:
716
Product dimensions:
9.00(w) x 11.00(h) x 1.00(d)

Table of Contents

Introducing Excel.
Project 1. Designing and Creating a Worksheet.
Project 2. Formatting Worksheets.
Project 3. Analyzing and Distributing Worksheet Data.
Project 4. Working with Workbooks.
Project 5. Creating More Complex Workbooks.
Project 6. Using Financial Functions.

I. DESIGNING COMPLEX WORKBOOKS.

Project 7. Creating a Three-Dimensional Workspace.
Project 8. Completing a Three-Dimensional Workspace Using Logical and Lookup Functions.
Project 9. Sorting, Grouping and Filtering Sales Data.
Project 10. Formatting, Displaying, Printing and Publishing Workbooks.

II. ANALYZING DATA WITH EXCEL.

Project 11. Creating Interactive PivotTable Reports.
Project 12. Using the Analysis Toolpak to Analyze Sales Transactions.
Project 13. Forecasting Values with What-If Analysis: Using Data Tables, Scenarios, Goal Seek and Solver.

III. INTEGRATING DATA, COLLABORATING WITH OTHERS AND CUSTOMIZING EXCEL 2000.

Project 14. Using Excel's Auditing and Collaboration Features.
Project 15. Using Visual Basic for Applications (VBA) to Customize and Automate Excel.
Project 16. Sharing Excel 2000 Data with Other Microsoft Office XP Applications.
Appendix A: Working with Excel.
Appendix B: Using Excel's Financial Functions to Amortize a Loan.

Read More

Customer Reviews

Average Review:

Write a Review

and post it to your social network

     

Most Helpful Customer Reviews

See all customer reviews >