This is the code repository for Learn Microsoft Office 2021 - Second Edition, published by Packt.
Your one-stop guide to upskilling with new features of Word, PowerPoint, Excel, Outlook, and Teams
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.
This book covers the following exciting features:
- 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
If you feel this book is for you, get your copy today!
Following is what you need for this book: 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.
With the following software and hardware list you can run all code files present in the book (Chapter 1-17).
| Chapter | Software required | OS required |
|---|---|---|
| 1-17 | Microsoft Office 2021 (Word, Excel, Powerpoint, and Outlook) | Windows 10 or 11 |
| 1-17 | Microsoft Office 365 and Office web apps, Sharepoint and OneDrive | Windows 10 or 11 |
| 1-17 | Teams app and meeting add-on | Windows 10 or 11 |
| 1-17 | Zoom meeting add-on | Windows 10 or 11 |
We also provide a PDF file that has color images of the screenshots/diagrams used in this book. Click here to download it.
Linda Foulkes is a senior learning and development trainer at Knights. She is also a Microsoft Office Master Trainer, Certified Educator, and Microsoft Innovative Expert Educator with an educational and corporate background spanning 25 years. Linda is the author of the first edition of the book Learn Microsoft Office 2019. As well as being certified as an IT trainer, Linda represented South Africa at the Microsoft Global Forum in Redmond in 2015. She has certified students to compete at the Microsoft Office Specialist Championships in Texas, presented at conferences, and hosted webinars, TeachMeets, and MicrosoftMeets. She has a keen interest in e-learning and has developed e-learning paths and content for the Microsoft Office suite of programs.
If you have already purchased a print or Kindle version of this book, you can get a DRM-free PDF version at no cost.
Simply click on the link to claim your free PDF.