New Perspectives Collection, Microsoft® 365® & Office® 2021 Advanced,
1st Edition

Jennifer T. Campbell, Ann Shaffer, Patrick Carey, Cengage Cengage

ISBN-13: 9780357672167
Copyright 2023 | Published
824 pages | List Price: USD $276.95
ISBN: 9780357672167

Using a unique in-depth, case-based approach, Cengage's NEW PERSPECTIVES COLLECTION, MICROSOFT® 365® & OFFICE® 2021 ADVANCED thoroughly prepares you for the Microsoft® Office® Specialist (MOS) certification exam and success in your future career. As you apply Microsoft® Office® skills to real-world business scenarios based on Burning Glass market insights, you will sharpen your critical-thinking and problem-solving skills. Professional tips and insights incorporated throughout provide context and relevancy to real-world practice, while ProSkills Boxes help strengthen your employability skills, including written and verbal communication. The text also offers updated coverage of Microsoft® 365® features and enhanced support for Mac users. In addition, MindTap and up-to-date SAM (Skills Assessment Manager) online resources provide interactive study tools to help maximize your study time -- and results.

Request Evaluation Copy

Module 8: Customizing Word and Automating Your Work: Automating a Document for a Rock Climbing Gym.
Module 9: Creating Online Forms Using Advanced Table Techniques: Developing an Order Form.
Module 10: Managing Long Documents: Creating a Survey Report for a Personal Chef Association.

Module 9: Exploring Financial Tools and Functions: Analyzing a Business Plan.
Module 10: Analyzing Data with Business Intelligence Tools: Presenting Sales and Revenue Data.
Module 11: Exploring PivotTable Design: Summarizing Sales and Revenue Data.
Module 12: Developing an Excel Application: Creating a Data Entry App Case Problems.

Module 9: Using Action Queries and Advanced Table Relationships: Enhancing User Interaction with the Health Database.
Module 10: Automating Tasks with Macros: Creating a User Interface for the Health Database.
Module 11: Using and Writing Visual Basic for Applications Code: Creating VBA Code for the Health Database.
Module 12: Managing and Securing a Database: Administering the Health Database.

Module 5: Integrating PowerPoint with Other Programs: Creating a Presentation for a Rowing Convention.
Module 6: Customizing Presentations and the PowerPoint Environment: Creating a Presentation for a City-Wide Green Challenge.

  • Jennifer T. Campbell

    Jennifer T. Campbell has written and co-authored several other leading technology texts, including TECHNOLOGY FOR SUCCESS, DISCOVERING THE INTERNET, WEB DESIGN: INTRODUCTORY, MICROSOFT EXPRESSION WEB INTRODUCTORY CONCEPTS AND TECHNIQUES, COMPUTER LITERACY BASICS: MICROSOFT OFFICE 2007 COMPANION and MICROSOFT OFFICE QUICK REFERENCE POCKET GUIDE. For over 25 years, she has served integral roles in computer educational publishing as an editor, author and marketing manager. She holds a B.A. in English from The College of William and Mary.

  • Ann Shaffer

    Ms. Ann Shaffer is the co-author of NEW PERSPECTIVES ON MICROSOFT® WORD and has contributed to many other Cengage publications. She has more than 25 years of experience as a developmental editor and co-author of books, journal articles and multimedia in a variety of fields, including computer science, mathematics, history, engineering and social sciences. She holds a master’s degree in English from the University of Wisconsin-Madison.

  • Patrick Carey

    A leading textbook author, lecturer and instructor, Patrick Carey has authored or co-authored more than 40 popular academic and trade texts for the academic market. He has taught and written about a wide range of topics, including website design, JavaScript programming, Microsoft Office and Excel, statistics, data analysis and mathematics. Mr. Carey received his M.S. in biostatistics from the University of Wisconsin, where he worked as a researcher designing and analyzing clinical studies. Today, he splits his time between Wisconsin and Colorado, and when he is not writing, he can be found hiking and cycling.

  • Cengage Cengage


  • Microsoft® Teams® coverage is now expanded to include five digital modules available in MindTap, authored by Corinne Hoisington.

  • Thoroughly updated coverage reflects Microsoft® 365® and Office® 2021 features including the new modern commenting experience that enables the user to display comments in contextual view or in the Comments pane. Other feature updates include the immersive reader in Word, XLOOKUP, PowerBI and the analyze data button in Excel, along with Microsoft's updated search feature and backstage view.

  • Introductory Textbook Projects have been redesigned to ensure successful completion by Mac users.

  • New Embracing Change modules in MindTap help students successfully navigate through Microsoft® 365's continual software changes. Each module includes accessibility features, application-specific tips, a Microsoft® ribbon and toolbar visual overview, plus review and discussion questions.

  • Using a case-based pedagogy built around realistic business scenarios, the NEW PERSPECTIVES COLLECTION's signature critical-thinking, problem-solving approach is the ideal way to prepare students to transcend point-and-click skills and take advantage of all that Microsoft® 365® has to offer.

  • Part of the NEW PERSPECTIVES MICROSOFT® 365® COLLECTION, this title provides access to a complete digital library of content spanning computer concepts, operating systems (for Windows and Mac) and the Microsoft® Office® Suite -- all for one price including low-cost rental options. Learn more about Cengage Unlimited at

  • Helping learners maximize their study time, Module Learning Objectives are mapped to the Microsoft® Office® Specialist (MOS) exam. Users of MindTap Collections and SAM also have access to exam preparation materials and the option to purchase a discounted MOS exam voucher.

  • By carefully examining the context for their projects, students understand the "why" behind each step in the process, which increases their motivation to learn.

  • ProSkills Boxes help students strengthen their employability skills, including written and verbal communication, problem-solving, decision-making and teamwork.

  • Trouble call-outs offer practical tips and insight to help readers avoid common errors.

Cengage provides a range of supplements that are updated in coordination with the main title selection. For more information about these supplements, contact your Learning Consultant.

Cengage eBook: New Perspectives Collection, Microsoft® 365® & Office® 2021 Advanced 12 Months