SELECT: Advanced Excel 2000

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.

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.