Read more
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.
List of contents
WORD MODULES.
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.
EXCEL MODULES.
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.
ACCESS MODULES.
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.
POWERPOINT MODULES.
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.
About the author
N/A
Summary
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.