The Shelly Cashman Series® Microsoft® 365® & Office® Advanced, First Edition

Misty E. Vermaat has more than 30 years of experience in the field of computer and information technology. In addition to consulting in the field, she was Associate Professor at Purdue University Calumet, teaching or developing Microsoft® Office, computer concepts, database management, systems analysis and design and programming courses. Since 1990, Ms. Vermaat has led the development of THE SHELLY CASHMAN SERIES and has authored and co-authored numerous Series textbooks, including many editions of DISCOVERING COMPUTERS, DISCOVERING COMPUTERS FUNDAMENTALS, MICROSOFT® PUBLISHER and MICROSOFT® WORD books. Jill West authors Cengage courses for CompTIA Cloud+, CompTIA Network+, Data Communications, Technology for Success and the popular Shelly Cashman Series. She has taught kindergarten through college and currently teaches computer technology courses at Georgia Northwestern Technical College. Jill specializes in designing innovative, critical-thinking activities and building courses that teach to popular IT certifications. She regularly presents at conferences and webinars on preparing for CompTIA certifications, teaching cloud computing and computer networking and mentoring lifelong student learners in IT. She’s a member of the 2019 inaugural cohort of Faculty Ambassadors for AWS Educate and is currently an AWS Academy Accredited Educator. Jill and her husband, Mike, live in northwest Georgia with two children at home and two off to college. Steven M. Freund serves as a lead instructor of various Microsoft® Office, computer concepts, programming and internet technology courses throughout Central Florida. An integral author for the successful Shelly Cashman Series® since 2001, he has presented at the annual customer conference, the Shelly Cashman Series Institute and other customer events. Freund has co-authored multiple editions of DISCOVERING COMPUTERS, MOZILLA FIREFOX, WINDOWS® INTERNET EXPLORER, WINDOWS® OFFICE and DREAMWEAVER books. In addition, he has written numerous successful instructor supplements. He attended the University of Central Florida. Susan L. Sebok is a retired professor at South Suburban College in South Holland, Illinois. She also is a licensed attorney. Working with the leading SHELLY CASHMAN SERIES® since 1993, she has co-authored several successful textbooks, including multiple versions of DISCOVERING COMPUTERS and MICROSOFT® POWERPOINT® books. She holds both Master of Arts and Juris Doctor degrees.

Getting to Know Microsoft Office Versions.
Using SAM Projects and Textbook Projects.
MICROSOFT WORD 2021.
Module 8: Using Collaboration, Integration, and Charts.
Module 9: Creating a Reference Document.
Module 10: Creating an Online Form.
Module 11: Enhancing an Online Form and Using Macros.
MICROSOFT POWERPOINT 2021.
Module 8: Creating Photo Albums and Delivering Presentations.
MICROSOFT EXCEL 2021.
Module 8: Working with Trendlines, PivotTables, Pivot Charts, and Slicers.
Module 9: Formula Auditing, Data Validation, and Complex Problem Solving.
Module 10: Data Analysis with Power Tools and Creating Macros.
Module 11: User Interfaces, Visual Basic for Applications (VBA), and Collaboration Features.
MICROSOFT ACCESS 2021.
Module 8: Macros, Navigation Forms, and Control Layouts.
Module 9: Administering a Database System.
Module 10: Using SQL.
Module 11: Database Design.
Index.