Advanced Projects for Microsoft Excel 2000 Microsoft Certified Edition

MICROSOFT CERTIFIED SELECT Lab Series: Advanced Projects for Microsoft Excel 2000 is MOUS Certified at the Expert Level. It was written to introduce students to intermediate and advanced spreadsheet management concepts, and to use spreadsheet technology to manage business data. Through the projects in this text, students build upon a basic understanding of Excel by creating more complex three-dimensional workbook solutions, using a full range of Excel's functions and tools. Utilizing a comprehensive approach to creating spreadsheet solutions, this text emphasizes the features in Microsoft Excel for integrating Microsoft Access data, and building web-based solutions for analyzing Pivot Table data. PROVEN STEP-BY-STEP APPROACH A class-tested, task-based, highly visual approach makes it easy to clearly see and understand what you are doing as you work through each project--one step at a time. Each project is designed to be completed in a single class or lab session. Every project begins with aRunning Casefrom SELECTIONS, Inc., a department store with locations nationwide. You'll also find a list of Objectives that identify what you will learn, theChallengeyou will face as you complete the tasks in the project, a suggestedSolutionto take to accomplish the task, and theSetupthat will help you get started on the right foot. Every project ends with a summary, key terms and operations, study questions, and hands-on exercises to help you reinforce and review what you have learned. NEW FEATURES IN EXCEL 2000 Comprehensive coverage of Advanced Excel 2000 Topics Based upon feedback from instructors like you, the Select Advanced Excel 2000 module covers a variety of topics beyond those required for MOUS certification. As you review the Table of Contents, you will be pleased with the comprehensive coverage of Excel 2000 in this book. Useful Appendices The Select Advanced Excel 2000 module includes two useful appendices: Appendix A covers basic concepts in Excel 2000, providing a brief review of navigating Excel worksheets and workbooks, entering text, numbers, and formulas in Excel, using functions in formulas, and getting help with the Office Assistant. Appendix B covers Excel's financial functions, and is perfect for students who want to learn how to use the power of Excel for calculating the loan payment for any loan scenario.Koneman, Philip A. is the author of 'Advanced Projects for Microsoft Excel 2000 Microsoft Certified Edition' with ISBN 9780130885449 and ISBN 0130885444.