Learn Microsoft Office 2021 - Second Edition: Your one-stop guide to upskilling with new features of Word, PowerPoint, Excel, Outlook, and Teams

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.

將您的 Microsoft Office 技能提升到新的水平，掌握 Microsoft Office 2021 中令人興奮的新功能和增強功能，包括使用 Teams 進行溝通、協作和演示。

主要功能：
- 通過實際案例進行逐步引導，深入了解新的桌面和網絡應用程序
- 通過學習 Office 網絡和桌面的新的生產力功能增強，豐富您的技能組合
- 發現如何在會議期間使用 Microsoft Teams 進行溝通、協作和演示

書籍描述：
本書第二版涵蓋了 Microsoft Office 2021 桌面和網絡應用程序的新功能，幫助您擴展上一版的技能。通過實際經驗，本書將通過實際例子引導您，激發您的思考，提高生產力。

為了在每個應用程序中建立新的技能，本書確保您全面了解新功能，例如 Excel 中的樞紐表、儀表板和數據操作方法。

您將探索 PowerPoint 工具，如演講者教練、演講者視圖、錄製工具和設置閱讀順序等。您還將使用自動修復、繪圖功能、插入視頻字幕、探索播放選項以及使用身體語言演講者教練功能排練演示文稿。本書將揭示 Transform 功能的奧秘，並向您展示如何在 Word 中直接口述。您甚至可以通過優化版式和多個目錄來處理樣式。最後，您將專注於充分利用 Outlook 的增強功能以及使用 Teams 遠程工作。

通過閱讀本書，您將全面了解每個應用程序的功能，並使用新技術增強現有技能，使您的專業生活更高效。

學到什麼：
- 探索 OneDrive 功能和 Word 的增強功能，如口述、共同編輯、嵌入、樣式、引用和媒體工具
- 管理 Word 文檔佈局、在線表單、記錄文檔自動化以及跟踪、比較和合併
- 使用演講者教練、自動修復、錄製和繪圖工具創建引人入勝的 PowerPoint 演示文稿
- 探索 Excel 函數，如 XLOOKUP、LET、XMATCH IFS、數組和 IFERROR，以及 VLOOKUP
- 使用數據庫和 COUNTIF 函數、高級篩選、數據清理、樞紐表和儀表板
- 探索 Outlook 的增強功能

本書適合對 Microsoft Office 應用程序有一定了解但尚未掌握完整功能範圍的人士，第二版旨在擴展您的技能組合，並為任何行業的從業人員和準備進入職場或準備進行 Microsoft Office 認證的學生提供價值。本書使用實際的職場實例，幫助您準備應用您的技能，充分利用 Microsoft Office 的最新功能。

雖然不是必需的，但對 Microsoft Office 應用程序有扎實的理解將是有益的。