Questions About This Book?
- The New copy of this book will include any supplemental materials advertised. Please check the title of the book to determine if it should include any CDs, lab manuals, study guides, etc.
- The Used copy of this book is not guaranteed to include any supplemental materials. Typically, only the book itself is included.
- The Rental copy of this book is not guaranteed to include any supplemental materials. You may receive a brand new copy, but typically, only the book itself.
Dr. Robert T. Grauer, Creator of the Exploring Series
Bob Grauer is an Associate Professor in the Department of Computer Information Systems at the University of Miami, where he is a multiple winner of the Outstanding Teaching Award in the School of Business, most recently in 2009. He has written numerous COBOL texts and is the vision behind the Exploring Office series, with more than three million books in print. His work has been translated into three foreign languages and is used in all aspects of higher education at both national and international levels. Bob Grauer has consulted for several major corporations including IBM and American Express. He received his Ph.D. in operations research in 1972 from the Polytechnic Institute of Brooklyn.
Dr. Keith Mulbery, Consulting Series Editor and Excel Author
Dr. Keith Mulbery is the Department Chair and an Associate Professor in the Information Systems and
Technology Department at Utah Valley University (UVU), where he teaches computer applications, C#
programming, systems analysis and design, and MIS classes. Keith also served as Interim Associate Dean,
School of Computing, in the College of Technology and Computing at UVU.
Keith received the Utah Valley State College Board of Trustees Award of Excellence in 2001, School of
Technology and Computing Scholar Award in 2007, and School of Technology and Computing Teaching
Award in 2008. He has authored more than 15 textbooks, served as Series Editor for the Exploring Office
2007 series, and served as developmental editor on two textbooks.
Keith received his B.S. and M.Ed. in Business Education from Southwestern Oklahoma State University
and earned his Ph.D. in Education with an emphasis in Business Information Systems at Utah State
University. His dissertation topic was computer-assisted instruction using Prentice Hall’s Train and Assess IT program to supplement traditional instruction in basic computer proficiency courses.
Mary Anne Poatsy, Series Editor
Mary Anne is a senior faculty member at Montgomery County Community College, teaching various
computer application and concepts courses in face-to-face and online environments. She holds a B.A.
in psychology and education from Mount Holyoke College and an M.B.A. in finance from Northwestern
University’s Kellogg Graduate School of Management.
Mary Anne has more than 12 years of educational experience. She is currently adjunct faculty at
Gwynedd-Mercy College and Montgomery County Community College. She has also taught at Bucks
County Community College and Muhlenberg College, as well as conducted professional training. Before
teaching, she was vice president at Shearson Lehman in the Municipal Bond Investment Banking
Dr. Lynn Hogan, Office Fundamentals and File Management and
Windows 7 Author
Lynn Hogan has taught in the Computer Information Systems area at Calhoun Community College for
29 years. She is the author of Practical Computing and has contributed chapters for several computer
applications textbooks. Primarily teaching in the areas of computer literacy and computer applications,
she was named Calhoun’s outstanding instructor in 2006. She received an M.B.A. from the University of
North Alabama and a Ph.D. from the University of Alabama. Lynn resides in Alabama with her husband
and two daughters.
Table of Contents
Chapter 1 Office Fundamentals and File Management
Chapter 1 Introduction to Excel
Chapter 2 Formulas and Functions
Chapter 3 Charts
Chapter 4 Datasets and Tables