Pearson eText Exploring Microsoft Office Excel 2019 -- Access Card

by Mary Anne Poatsy / Keith Mulbery

• ISBN13: 9780136851653
• ISBN10: 0136851657
• Format: Nonspecific Binding
• Copyright: 2020-09-18
• Publisher: PEARSO
• More Book Details
• Purchase Benefits

Summary

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.

For courses covering introductory Microsoft^® Excel^™.

Pearson eText is an easy-to-use digital textbook that you can purchase on your own or instructors can assign for their course. The mobile app lets you keep on learning, no matter where your day takes you, even offline. You can also add highlights, bookmarks, and notes in your Pearson eText to study how you like.

NOTE: This ISBN is for the Pearson eText access card. Pearson eText is a fully digital delivery of Pearson content. Before purchasing, check that you have the correct ISBN. To register for and use Pearson eText, you may also need a course invite link, which your instructor will provide. Follow the instructions provided on the access card to learn more.

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