Exploring Microsoft Office Excel 2019 Comprehensive

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

• ISBN13: 9780135452752
• ISBN10: 0135452759
• Additional ISBN(s): 9780135574331
• Edition: 1st
• Format: Spiral Bound
• Copyright: 2019-03-15
• Publisher: Pearson
• More Book Details

Summary

Now live! SUMMER 2020 DIGITAL UPDATE for digital content
Microsoft Office 365 updates are reflected in the eText and associated MyLab for this title. Instructors, to learn more, contact your Pearson representative.

For courses covering introductory Microsoft^® Excel^™.

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.

Also available 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.

Note: You are purchasing a standalone product; MyLab IT does not come packaged with this content. Students, if interested in purchasing this title with MyLab IT, ask your instructor to confirm the correct package ISBN and Course ID. Instructors, contact your Pearson representative for more information.

If you would like to purchase both the physical text and MyLab IT, search for:

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