Pub. Date:
Exploring Microsoft Office Excel 2016 Comprehensive / Edition 1

Exploring Microsoft Office Excel 2016 Comprehensive / Edition 1

by Mary Anne Poatsy


View All Available Formats & Editions
Current price is , Original price is $151.6. You
Select a Purchase Option (New Edition)
  • purchase options
    $35.67 $151.60 Save 76% Current price is $35.67, Original price is $151.6. You Save 76.47097625329815%.
    • Free return shipping at the end of the rental period details
    • Textbook Rentals in 3 Easy Steps  details
    Note: Access code and/or supplemental material are not guaranteed to be included with textbook rental or used textbook.
  • purchase options
    $120.96 $151.60 Save 20% Current price is $120.96, Original price is $151.6. You Save 20%.
  • purchase options
    $78.14 $151.60 Save 48% Current price is $78.14, Original price is $151.6. You Save 48%.
    Note: Access code and/or supplemental material are not guaranteed to be included with textbook rental or used textbook.

Product Details

ISBN-13: 2900134479445
Publisher: Pearson
Publication date: 04/06/2016
Series: Exploring for Office 2016 Series
Edition description: New Edition
Pages: 848
Product dimensions: 11.00(w) x 9.30(h) x 1.20(d)

About the Author

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 personal training. Before teaching, she was Vice President at Shearson Lehman in the Municipal Bond Investment Banking Department.

Dr. Keith Mulbery

Dr. Keith Mulbery is the Department Chair and a Professor in the Information Systems and Technology Department at Utah Valley University (UVU), where he currently teaches systems analysis and design, and global and ethical issues in information systems and technology. He has also taught computer applications, C# programming, and management information systems. Keith 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 17 textbooks, served as Series Editor for the Exploring Office 2007 series, and served as developmental editor on two textbooks for the Essentials Office 2000 series. He is frequently asked to give presentations and workshops on Microsoft Office Excel at various education conferences. 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 (the predecessor to MyITLab) to supplement traditional instruction in basic computer proficiency courses.

Jason Davidson

Jason Davidson is a faculty member in the College of Business at Butler University, where he teaches Advanced Web Design, Data Networks, Data Analysis and Business Modeling, and introductory information systems courses. He is the co-author of Exploring Microsoft Excel 2013 Comprehensive, Exploring Microsoft Office 2013 Volume 2, Exploring Microsoft Office 2013 Plus, and Exploring VBA for Microsoft Office 2013. With a background in media development, prior to joining the faculty at Butler, he worked in the technical publishing industry. Along with teaching, he currently serves as an IT consultant for regional businesses in the Indianapolis area. He holds a B.A. in Telecommunication Arts from Butler University and an M.B.A. from Morehead State University. He lives in Indianapolis, Indiana, and in his free time enjoys road biking, photography, and spending time with his family.

Amy Rutledge

Amy Rutledge is a Special Instructor of Management Information Systems at Oakland University in Rochester, Michigan. She coordinates academic programs in Microsoft Office applications and introductory management information systems courses for the School of Business Administration. Before joining Oakland University as an instructor, Amy spent several years working for a music distribution company and automotive manufacturer in various corporate roles including IT project management. She holds a B.S. in Business Administration specializing in Management Information Systems, and a B.A. in French Modern Language and Literature. She holds an M.B.A from Oakland University. She resides in Michigan with her husband, Dan and daughters Emma and Jane.

Dr. Robert T. Grauer, Creator of the Exploring Series

Bob Grauer is Professor Emeritus 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.

Table of Contents

Office 2016 Common Features
Excel CHAPTER 1 Introduction to Excel
CHAPTER 2 Formulas and Functions
CHAPTER 3 Charts
CHAPTER 4 Datasets and Tables
CHAPTER 5 Subtotals, PivotTables, and PivotCharts
CHAPTER 6 What-If Analysis
CHAPTER 7 Specialized Functions
CHAPTER 8 Statistical Functions
CHAPTER 9 Multiple-Sheet Workbook Management
CHAPTER 10 Imports, XML, and Power Add-Ins
CHAPTER 11 Collaboration and Workbook Distribution
CHAPTER 12 Templates, Styles, and Macros
Excel Introductory Capstone Exercise (Chs. 1—4)
Excel Comprehensive Capstone Exercise (Chs. 5—12)

Customer Reviews

Most Helpful Customer Reviews

See All Customer Reviews