I'm a student
I'm an educator
Request full copy

Exploring Microsoft Office Excel 2019 Comprehensive, 1st edition

Published by Pearson (March 15, 2019) © 2020

  • Mary Anne Poatsy
  • Keith Mulbery Utah Valley State College
  • Jason Davidson Butler University

eTextbook

per month

  • Anytime, anywhere learning with the Pearson+ app
  • Easy-to-use search, navigation and notebook
  • Simpler studying with flashcards
$149.32

  • Hardcover, paperback or looseleaf edition
  • Affordable rental option for select titles
  • Free shipping on looseleafs and traditional textbooks

MyLab

from$119.99

  • Reach every student with personalized support
  • Customize courses with ease
  • Optimize learning with dynamic study tools

For courses covering introductory Microsoft® Excel™.

Beyond point-and-click.

Exploring Microsoft Office Excel 2019 Comprehensive moves students beyond rote tasks to a deeper comprehension of how, when, and why to apply Office skills. A market leader for over 20 years, the text helps students achieve high-level learning outcomes by engaging them in the way they learn best: through hands-on practice. A dozen exercises in each chapter range from multiple-choice questions to open-ended projects.

Revised to reflect Microsoft Office 365, the 2019 Edition is Mac compatible and adds new critical thinking assignments to help students build fundamental 21st-century skills.

Hallmark features of this title

Focus on outcomes

  • The text supports deeper understanding by design, with white pages highlighting theory-based content and yellow pages for hands-on exercises.
  • Objective mapping outlines clear objectives at the start of each chapter, identifies them by icons throughout, and assesses for mastery with chapter-ending reviews.

Active, flexible learning

  • Mid-Level Exercises include a Creative Case (for PowerPointâ„¢ and Wordâ„¢), an Analysis Case (for Excelâ„¢ and Accessâ„¢) and Discover Steps encouraging students to use Help or to problem-solve to accomplish a task.
  • Application Capstone Exercises test students on the entire contents of a single application.
  • Content for MOS exams is woven in seamlessly and easily identified via icons and a MOS Certification Guide.

New and updated features of this title

Case-based, hands-on learning

  • EXPANDED: The Running Case has been expanded to all applications. One exercise per chapter focuses on the New Castle County Technical Services case, offering a real-world project for reference throughout the semester.

Updated to Microsoft® Office 365® and Mac specifications

  • REVISED: This edition is written to Microsoft Office 365. Regular content updates keep the text current with Office 365, and an Office 365 content updates document is available as an instructor resource.
  • NEW: Now compatible with Mac, this edition includes Mac Tips, On a Mac boxes, and a Mac Student Reference Card to ensure Mac users can use the text as easily as a PC user.
  • NEW:A Mac Troubleshooting feature helps Mac users overcome obstacles while working in Office applications.

Varied assessment options and resources

  • EXPANDED: New assignments and resources have been added to enhance this edition.

Highlights of the DIGITAL UPDATE for MyLab IT (available for Summer 2020 classes)

Instructors, contact your sales rep to ensure you have the most recent version of the course.

  • Microsoft Office 365 updates are reflected in MyLab activities and in the associated eText. These updates reduce student confusion and ensure course materials remain current throughout the Office lifecycle.

Features of MyLab IT for the 1st Edition; published 2019

  • Book-specific 1:1 simulations let students practice in a realistic Office 365 environment using hi-fidelity HTML5 simulations that match the content in the Hands-On Exercises.
  • Book-specific 1:1 Grader projects let students complete end-of-chapter Capstone Exercises live in Office 365 and receive immediate feedback on their performance through various reports. A Grader in each chapter mirrors the Hands-On Exercise in each chapter.

OFFICE

Office 365 Common Features

EXCEL

  1. Introduction to Excel
  2. Formulas and Functions
  3. Charts
  4. Datasets and Tables
  5. Subtotals, PivotTables, and PivotCharts
  6. What-If Analysis
  7. Specialized Functions
  8. Statistical Functions
  9. Multiple-Sheet Workbook Management
  10. Power Add-Ins
  11. Additional Specialized Functions
  12. Templates, Workbook Inspection, and Macros

APPLICATION CAPSTONE EXERCISE

Excel Application Capstone Exercise

About our authors

Mary Anne Poatsy, Series Editor, Windows 10 Author, is a senior faculty member at Montgomery County Community College, teaching various computer applications and concepts courses in face-to-face and online environments. She holds a BA in psychology and education from Mount Holyoke College and an MBA in finance from Northwestern University's Kellogg Graduate School of Management.

Mary Anne has over 20 years of educational experience. She has taught at Montgomery County Community College and Muhlenberg College. She also engages in corporate training. Before teaching, she was Vice President at Shearson Lehman in the Municipal Bond Investment Banking Department.

Dr. Keith Mulbery, Excel Author, is 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.

Keith received his BS and MEd in business education from Southwestern Oklahoma State University and his PhD in education with an emphasis in business information systems from Utah State University. His dissertation topic was computer-assisted instruction using Prentice Hall's Train and Assess IT program (the predecessor to MyLab IT) to supplement traditional instruction in basic computer proficiency courses.

Jason Davidson, Excel Author, 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. Along with teaching, he serves as an IT consultant for regional businesses in the Indianapolis area.

Need help? Get in touch

Pearson+

All in one place. Pearson+ offers instant access to eTextbooks, videos and study tools in one intuitive interface. Students choose how they learn best with enhanced search, audio and flashcards. The Pearson+ app lets them read where life takes them, no wi-fi needed. Students can access Pearson+ through a subscription or their MyLab or Mastering course.

MyLab

Customize your course to teach your way. MyLab® is a flexible platform merging world-class content with dynamic study tools. It takes a personalized approach designed to ignite each student's unique potential. And, with the freedom it affords to adapt your pedagogy, you can reinforce select concepts and guide students to real results.

Video
Play
Privacy and cookies
By watching, you agree Pearson can share your viewership data for marketing and analytics for one year, revocable by deleting your cookies.

Video transcript (PDF | 25KB) 

Empower your students, in class and beyond

Meet students where they are with MyLab®, and capture their attention in every lecture, activity, and assignment using immersive content, customized tools, and interactive learning experiences in your discipline.

Digital Learning NOW

Extend your professional development and meet your students where they are with free weekly Digital Learning NOW webinars. Attend live, watch on-demand, or listen at your leisure to expand your teaching strategies. Earn digital professional development badges for attending a live session.

Explore webinars