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

Ann Shaffer, Jennifer T. Campbell, Patrick Carey

ISBN-13: 9780357672129
Copyright 2023 | Published
840 pages | List Price: USD $245.95

Using a unique in-depth, case-based approach, Cengage's NEW PERSPECTIVES COLLECTION, MICROSOFT® 365® & OFFICE® 2021 INTERMEDIATE 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. Updated coverage of Microsoft® 365® features and enhanced support for Mac users are also included. 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.

Purchase Enquiry INSTRUCTOR’S eREVIEW COPY

WORD MODULES.
Module 5: Working with Templates, Themes, and Styles: Creating a Summary Report.
Module 6: Using Mail Merge: Creating a Form Letter, Mailing Labels, and a Phone Directory.
Module 7: Collaborating with Others and Integrating Data: Preparing an Information Sheet.
EXCEL MODULES.
Module 5: Generating Reports from Multiple Worksheets and Workbooks: Summarizing Profit and Loss Statements.
Module 6: Managing Data with Data Tools: Analyzing Employment Data.
Module 7: Summarizing Data with PivotTables: Preparing a Social Media Marketing Report.
Module 8: Performing What-If Analyses: Maximizing Profits with the Right Product Mix.
ACCESS MODULES.
Module 5: Creating Advanced Queries and Enhancing Table Design: Making the Clinic Database Easier to Use.
Module 6: Using Form Tools and Creating Custom Forms: Creating Forms for Lakewood Community Health Services.
Module 7: Creating Custom Reports: Creating Custom Reports for Lakewood Community Health Services.
Module 8: Sharing, Integrating, and Analyzing Data: Importing, Exporting, Linking, and Analyzing Data in the Clinic Database.
POWERPOINT MODULES.
Module 3: Applying Advanced Formatting to Objects: Formatting Objects in a Presentation for a Sales and Marketing Company.
Module 4: Advanced Animations and Distributing Presentations: Creating an Advanced Presentation for Agricultural Development.

  • 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.

  • 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.

  • 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.

  • 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 cengage.com/unlimited.

  • 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 Testing, powered by Cognero® for Cengage's New Perspectives Collection, Microsoft® 365® & Office® 2021
9780357672372

Cengage Testing, powered by Cognero® for Cengage's New Perspectives Collection, Microsoft® 365® & Office® 2021, Instant Access
9780357672389

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