Exploring Microsoft Excel 2019 Comprehensive, 1/e + MyLab IT w/ Pearson eText

by Poatsy, Mary Anne; Mulbery, Keith; Davidson, Jason

• ISBN13: 9780135825280
• ISBN10: 0135825288
• Edition: 1st
• Format: Spiralbound w/ Access Card
• Copyright: 2019-05-07
• Publisher: Pearson

Summary

NOTE: Before purchasing, check with your instructor to ensure you select the correct ISBN. Several versions of the MyLab^™ and Mastering^™ platforms exist for each title, and registrations are not transferable. To register for and use MyLab or Mastering, you may also need a Course ID, which your instructor will provide.

Used books, rentals, and purchases made outside of Pearson
If purchasing or renting from companies other than Pearson, the access codes for the MyLab platform may not be included, may be incorrect, or may be previously redeemed. Check with the seller before completing your purchase.

DIGITAL UPDATE available now
Microsoft Office 365 updates will be reflected in the eText and associated MyLab activities, reducing student confusion and keeping course materials current throughout the Office lifecycle. For details, see the Product Announcements page in MyLab IT.

For courses covering introductory Microsoft ^® Excel ^™ .
This package includes MyLab IT.

Beyond point-and-click
The Exploring Microsoft^® Office 365^® series 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 collection 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.

Personalize learning with MyLab IT
By combining trusted author content with digital tools and a flexible platform, MyLab personalizes the learning experience and improves results for each student. MyLab IT 2019 delivers trusted content and resources through an expansive course materials library, including new easy-to-use Prebuilt Learning Modules that promote student success. Through an authentic learning experience, students become sharp critical thinkers and proficient in Microsoft Office, developing essential skills employers seek.

0135825288 / 9780135825280 Exploring: Microsoft Excel 2019 Comprehensive, 1/e + MyLab IT w/ Pearson eText, 1/e
Package consists of:

• 0135402468 / 9780135402467 MyLab IT with Pearson eText -- Access Card -- for Exploring Microsoft Office 2019, 1/e
• 0135452759 / 9780135452752 Exploring Microsoft Office Excel 2019 Comprehensive, 1/e

Author Biography

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.

Table of Contents

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