The Shelly Cashman Series® Microsoft® 365® & Office® 2021 Advanced

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. Ellen F. Monk is an Assistant Professor of Management Information Systems in the Lerner College of Business and Economics at the University of Delaware. Her areas of interest encompass enterprise resource planning systems and undergraduate MIS education, including databases, advanced spreadsheets and data analytics. Dr. Monk holds a B.S. in chemical engineering, an M.B.A., and a Ph.D. in MIS. 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. Joy Starks has taught at Indiana University Purdue University Indianapolis for 20 years. She has written chapters in several of the best-selling Shelly Cashman Series Office books and has authored the Photoshop, Java Programming, and Microsoft® Publisher series of books. She speaks and presents at various conferences, seminars and forums across the U.S. 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. Sandra Cable is the author and co-author of numerous books with Course Technology, including both introductory and advanced levels of Microsoft Excel and Access. In addition to working full time for an international corporation in Dallas, she volunteers to teach at seminars and in classrooms, sharing her simple, proven approaches for mastering today's computer applications. She holds a Ph.D. in education from Texas A&M University-Commerce. NA

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.