Exploring Microsoft Office 2019 Introductory

by Poatsy, Mary Anne; Mulbery, Keith; Hogan, Lynn; Davidson, Jason; Lau, Linda; Lawson, Rebecca; Williams, Jerri; Rutledge, Amy M.; Kosharek, Diane

• ISBN13: 9780135402542
• ISBN10: 0135402549
• Edition: 1st
• Format: Spiral Bound
• Copyright: 2019-02-15
• Publisher: Pearson

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^® Office^™.

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:

013576890X / 9780135768907 Exploring Microsoft Office 2019 Introductory, 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
• 0135402549 / 9780135402542 Exploring Microsoft Office 2019 Introductory, 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.

Lynn Hogan, Word Author, teaches at the University of North Alabama, providing instruction in the area of computer applications. Prior to her current assignment, she taught for over 25 years at the community college level, serving in academic administration and teaching applications, programming, and concepts courses in both online and classroom environments. She has served as an author for several Pearson publications over the past 14 years, including Exploring 2010, 2013, and 2016. She also contributed Word chapters for the first edition of Your Office, and developed and wrote Practical Computing. She received an MBA from the University of North Alabama and a PhD from the University of Alabama.

Amy Rutledge, Access Author, is a special Instructor of MIS (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 BS in business administration, specializing in MIS, and a BA in French modern language and literature. She holds an MBA from Oakland University. She resides in Michigan with her husband, Dan, and daughters, Emma and Jane.

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.

Rebecca Lawson, PowerPoint Author, is a professor in the Computer Information Technologies Program at Lansing Community College. She coordinates the curriculum, develops the instructional materials, and teaches for the E-Business curriculum. She also serves as the online faculty coordinator at the Center for Teaching Excellence at LCC. In that role, she develops and facilitates online workshops for faculty who are learning to teach online. Her major areas of interest include online curriculum quality assurance, the review and development of printed and online instructional materials, the assessment of computer and Internet literacy skill levels to facilitate student retention, and the use of social networking tools to support learning in blended and online learning environments.

Jerri Williams, Access Author, is a senior instructor at Montgomery County Community College in Pennsylvania, and currently works as a technical editor and content developer in addition to her teaching responsibilities. Jerri worked as a live and virtual corporate trainer and developer in major pharmaceutical and other companies for many years prior to joining the Exploring Access 2013, 2016, and 2019 teams. She is interested in travel, history, cooking, theater, movies, and tending to her colonial farmhouse (a work in progress). Jerri is married to Gareth and is the mother of two daughters, Holly (an accountant/office manager, and mother of an adorable son, Meir) and Gwyneth (a corporate defense/employment attorney). Jerri and Gareth live outside of Philadelphia, and enjoy their home and garden, spending time with family and friends, watching the Philadelphia Eagles, and visiting the Jersey Shore any time of the year.

Dr. Linda K. Lau, Word Author, has, since 1994, been on the MIS (management information systems) faculty at the College of Business and Economics, Longwood University, located in Farmville, Virginia. She received the Outstanding Academic Advisor Award in 2006. Besides teaching and advising, Linda has authored and co-authored numerous journal and conference articles and textbooks, has edited two books, and has sat on several editorial boards. Her current research interest is in cyber security and forensics, and she is a member of the Journal of Digital Forensics, Security and Law (JDFSL).

Linda earned her PhD from Rensselaer Polytechnic Institute in 1993, and her MBA and a bachelor of science from Illinois State University in 1987 and 1986, respectively. In her younger days, Linda worked as a flight attendant for Singapore International Airlines for six years before coming to America to pursue her academic dream. She also worked as a financial consultant with Salomon Smith Barney from 1999 to 2000 before returning to the academic world. Linda resides in Richmond with her family.

Diane Kosharek, PowerPoint Author, is a full-time Business Technology faculty member at Madison College in Madison, WI. In addition to her faculty role, she works closely with business and industry specialists, developing and delivering tailored training solutions to employees in areas such as customer service, software applications, and business writing skills.

Table of Contents

OFFICE
Office 365 Common Features

WORD
1. Introduction to Word
2. Document Presentation
3. Document Productivity
4. Research and Collaboration

EXCEL
1. Introduction to Excel
2. Formulas and Functions
3. Charts
4. Datasets and Tables

ACCESS
1. Introduction to Access
2. Tables and Queries in Relational Databases
3. Query Calculations and Expressions
4. Basic Forms and Reports

POWERPOINT
1. Introduction to PowerPoint
2. Effective Presentation Development
3. Presentation Enhancement
4. Presentation Refinement

APPLICATION CAPSTONE EXERCISES
Word Application Capstone Exercise
Excel Application Capstone Exercise
Access Application Capstone Exercise
PowerPoint Application Capstone Exercise

Microsoft Office 2019 Specialist Word
Microsoft Office 2019 Specialist Excel
Microsoft Office 2019 Specialist Access
Microsoft Office 2019 Specialist PowerPoint