SELECT Series
Microsoft Excel Comprehensive, Volume I and II 2002
Published on 10. January 2003
Book
Paperback/Softback
716 pages
978-0-13-066450-1 (ISBN)
Description
The Select Series MicrosoftA (R) Office XP Select's easy to follow, step-by-step approach lays the groundwork for students to have early success with Office XP and to gain the confidence they need to apply their skills to text projects and cases, as well as to everyday work challenges! The Practical Running Case and the clear instructions guide students to mastering Office XP in the classroom and beyond! Select is certified to the Core and Expert levels, giving students the full range of competencies in Office XP!
More details
Language
English
Place of publication
United States
Publishing group
Pearson Education (US)
Target group
Professional and scholarly
Dimensions
Width: 282 mm
Thickness: 22 mm
Weight
1229 gr
ISBN-13
978-0-13-066450-1 (9780130664501)
Copyright in bibliographic data and cover images is held by Nielsen Book Services Limited or by the publishers or by their respective licensors: all rights reserved.
Schweitzer Classification
Content
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.
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.