Upskill with Microsoft Office 2021: A Comprehensive Guide to Word, PowerPoint, Excel, Outlook, and Teams, 2nd Edition

Price: $16.54
(as of May 21,2023 02:33:13 UTC – Details)

Looking for a way to upgrade your Microsoft Office skills? Look no further than this second edition book, which covers the latest and greatest features of Microsoft Office 2021 in both desktop and web applications. Loaded with real-world examples and practical tips and tricks, this book will help you increase your productivity and become a Microsoft Office pro.

Key Features

• Walkthrough of new desktop and web apps with real-world examples
• Learning new productivity feature enhancements for Office web and desktop
• Using Microsoft Teams for communication, collaboration, and presentations during meetings

Book Description

This book is designed to help you master the exciting new features of Microsoft Office 2021 for desktop and web apps. It provides a practical approach to learning that is supported by real-world experiences, guiding you through practical examples that help you boost productivity.

The book covers specific functions of each application, such as PivotTables, Dashboards, and data manipulation methods in Excel. You will also learn about PowerPoint tools, such as Presenter Coach, Presenter View, the record tool, and setting reading order, among other things. Additionally, the book demonstrates how to manipulate slide elements by using Auto Fix, draw features, insert video captions, explore playback options, and rehearse presentations using the body language Presenter Coach feature.

The book also demystifies the Transform feature and shows how to dictate directly in Word. You’ll also learn how to work with Styles by refining the layout and multiple tables of contents. Lastly, you’ll focus on making the best use of Outlook enhancements and working remotely using Teams. By the end of this book, you will have a comprehensive understanding of the features of each app and how to integrate new techniques to improve your proficiency in Microsoft Office.

What You Will Learn

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

About the Author

The author of this book has many years of experience working with Microsoft Office applications, making her uniquely qualified to explain the latest features and enhancements in Office 2021. She is passionate about teaching readers how to leverage the full potential of Microsoft Office, and many readers have found her earlier works highly beneficial.

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. This book is helpful 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.

The book assumes a solid understanding of the Microsoft Office applications, although this is not a prerequisite to learning from the book. It is a comprehensive guide with 654 pages that will help you become a master of Microsoft Office 2021.

Table of Contents

• Exploring the New Interface and Managing OneDrive
• Dictation, Co-authoring, and Embedding
• Styles, Referencing, and Media
• Managing Professional Documents
• The PowerPoint Interface and Presentation Options
• Formatting Slides, Charts, and Graphic Elements
• Photo Albums, Sections, and Show Tools
• Mastering Best Practices with Presentations
• New Features, Filters, and Cleaning Data
• Exploring New and Useful Workflow Functions
• Date-Time Functions and Enhancing PivotTable Dashboards

(N.B. Please use the Look Inside option to see further chapters)

Published by Packt Publishing, the 2nd edition (July 29, 2022) is available in English and comes in paperback with an ISBN-10 of 1803239735 and an ISBN-13 of 978-1803239736. The book weighs about 2.44 pounds and has a dimension of 7.5 x 1.48 x 9.25 inches.