0%

Take your Microsoft Office skills to the next level by mastering the exciting new features and enhancements in Microsoft Office 2021, including communicating, collaborating, and presenting using Teams

Key Features

  • Get a progressive walkthrough of the new desktop and web apps with real-world examples
  • Enrich your skillset by learning new productivity feature enhancements for Office web and desktop
  • Discover how to use Microsoft Teams to communicate, collaborate, and present during meetings

Book Description

This second edition book covers the new and exciting features of Microsoft Office 2021 for desktop and web apps, helping you broaden the skills from the previous edition. Using real-world experiences, this book will guide you through practical examples that set off your thought process to boost productivity.

To build new skills in each application, the book ensures that you gain a thorough understanding of new functions, such as PivotTables, Dashboards, and data manipulation methods in Excel.

You'll explore PowerPoint tools such as Presenter Coach, Presenter View, the record tool, and setting reading order to mention a few. You'll also manipulate slide elements using Auto Fix, draw features, insert video captions, explore playback options, and rehearse presentations using the body language Presenter Coach feature. The book demystifies the Transform feature and shows you how to dictate directly in Word. You'll even be able to work with Styles by refining the layout and multiple tables of contents. Finally, you'll focus on making the best use of Outlook enhancements and working remotely using Teams.

By the end of this book, you'll have understood the features of each app inside out and enhanced your existing skills using new techniques to make your professional life more efficient.

What you will learn

  • Uncover OneDrive features and Word enhancements such as dictation, co-authoring, embedding, styles, referencing, and media tools
  • Manage Word document layouts, online forms, recording document automation, and track, compare, and combine
  • Create engaging PowerPoint presentations using Presenter Coach, Auto Fix, Record, and drawing tools
  • Explore Excel functions such as XLOOKUP, LET, XMATCH IFS, arrays and IFERROR, and VLOOKUP
  • Work with database and COUNTIF functions, Advanced Filter, clean data, and PivotTables and Dashboards
  • Explore Outlook enhancements

Who this book is for

If you work with Microsoft Office applications but are yet to discover the complete range of features, this second edition is tailored to broaden your skillset with new features and functionalities. It would be of value for those working in any industry and for students moving into the workplace or preparing for Microsoft Office certification. The book uses real-world practical workplace examples to help you get ready to apply your skills and make the most of the recent features of Microsoft Office.

Although not a prerequisite, a solid understanding of the Microsoft Office applications will be beneficial.

Table of Contents

  1. Learn Microsoft Office 2021
  2. Second Edition
  3. Contributors
  4. About the author
  5. About the reviewer
  6. Preface
  7. Part 1: Learning Word 2021
  8. Chapter 1: Exploring the New Interface and Managing OneDrive
  9. Chapter 2: Dictation, Co-authoring, and Embedding
  10. Chapter 3: Styles, Referencing, and Media
  11. Chapter 4: Managing Professional Documents
  12. Part 2: Learning PowerPoint 2021
  13. Chapter 5: The PowerPoint Interface and Presentation Options
  14. Chapter 6: Formatting Slides, Charts, and Graphic Elements
  15. Chapter 7: Photo Albums, Sections, and Show Tools
  16. Chapter 8: Mastering Best Practices with Presentations
  17. Part 3: Learning Excel 2021
  18. Chapter 9: New Features, Filters, and Cleaning Data
  19. Chapter 10: Exploring New and Useful Workflow Functions
  20. Chapter 11: Date-Time Functions and Enhancing PivotTable Dashboards
  21. Chapter 12: Useful Statistical and Mathematical Functions
  22. Part 4: Outlook 2021 and Useful Communication Tools
  23. Chapter 13: Creating and Attaching Item Content
  24. Chapter 14: Managing Mail and Contacts
  25. Chapter 15: Calendar Objects, Tasks, Notes, and Journal Entries
  26. Chapter 16: Creating and Managing Online Meetings
  27. Chapter 17: Presenting and Collaborating Online
  28. Other Books You May Enjoy