SELECT: Advanced Excel 2000 - Softcover

Koneman, Philip A.

Softcover

ISBN 10: 0130885444 ISBN 13: 9780130885449

Publisher: Prentice Hall, 2000

Synopsis

The goal of this book is to introduce learners to intermediate and advanced spreadsheet management concepts, and using spreadsheet technology to manage business data. Through the projects in this book, users 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 book emphasizes the features in Microsoft Excel for integrating Microsoft Access data, and building web-based solutions for analyzing pivot table data. This book is MOUS certified at the Expert level.

About this title

About the Author

DR. PHILIP A. KONEMAN has over ten years of experience in computers and education. He is an Associate Professor of Computer Information Systems and Advanced Computer Applications at Colorado Christian University. His teaching responsibilities include Introduction to Computer Applications, where students learn the primary applications in Microsoft Office 2000 Premium Edition.

Dr. Koneman has a broad professional portfolio that includes a variety of activities outside the university. He assisted Nivo International in defining the MOUS Certification objectives for Office 2000. In addition to being an author on numerous Select modules; he is also the Series Consulting Editor for the entire Select series. Dr. Koneman is President of Instructional Design Consultants, Inc., a company that develops educational multimedia and provides consulting for curriculum design and educational measurement.

Dr. Koneman received his Ph.D. from the University of Colorado at Denver, School of Education, Division of Instructional Technology. His research interests include computer-based learning, educational testing and measurement, and ethical issues in computers and technology. He is a certified Microsoft Office User Specialist for Office 2000.

From the Back Cover

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 a Running Case from SELECTIONS, Inc., a department store with locations nationwide. You'll also find a list of Objectives that identify what you will learn, the Challenge you will face as you complete the tasks in the project, a suggested Solution to take to accomplish the task, and the Setup that 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.

Edition details

• Publisher: Prentice Hall
• Publication date: 2000
• Language: English
• ISBN 10: 0130885444
• ISBN 13: 9780130885449
• Binding: Paperback
• Number of pages: 369