You're reading from Learn Microsoft Office 2021 Your one-stop guide to upskilling with new features of Word, PowerPoint, Excel, Outlook, and Teams

Product type Paperback

Published in Jul 2022

Publisher Packt

ISBN-13 9781803239736

Length 654 pages

Edition 2nd Edition

Tools

Excel

Concepts

Document Preparation

Author (1):

Linda Foulkes

View More author details

Table of Contents (23) Chapters

Preface

1. Part 1: Learning Word 2021

2. Chapter 1: Exploring the New Interface and Managing OneDrive FREE CHAPTER

3. Chapter 2: Dictation, Co-authoring, and Embedding

4. Chapter 3: Styles, Referencing, and Media

5. Chapter 4: Managing Professional Documents

6. Part 2: Learning PowerPoint 2021

7. Chapter 5: The PowerPoint Interface and Presentation Options

8. Chapter 6: Formatting Slides, Charts, and Graphic Elements

9. Chapter 7: Photo Albums, Sections, and Show Tools

10. Chapter 8: Mastering Best Practices with Presentations

11. Part 3: Learning Excel 2021

12. Chapter 9: New Features, Filters, and Cleaning Data

13. Chapter 10: Exploring New and Useful Workflow Functions

14. Chapter 11: Date-Time Functions and Enhancing PivotTable Dashboards

15. Chapter 12: Useful Statistical and Mathematical Functions

16. Part 4: Outlook 2021 and Useful Communication Tools

17. Chapter 13: Creating and Attaching Item Content

18. Chapter 14: Managing Mail and Contacts

19. Chapter 15: Calendar Objects, Tasks, Notes, and Journal Entries

20. Chapter 16: Creating and Managing Online Meetings

21. Chapter 17: Presenting and Collaborating Online

22. Other Books You May Enjoy

Summary

You now have the skills to work with Math & Trig and Statistical functions using Excel 2021. You have built on prior knowledge by learning valuable functions, such as being able to generate random numbers using RANDBETWEEN and RAND functions. In addition, you went through examples of working with PRODUCT functions and explored the SUMPRODUCT, MROUND, FLOOR, TRUNC, AGGREGATE, and CONVERT functions.

We also investigated the MEDIAN, COUNTBLANK, and AVERAGEIFS statistical functions in this chapter, from which you can experiment and apply to existing or new scenarios when working with workbook data.

This next chapter will take you through Outlook 2021 enhancements, where we will explore and configure objects such as mail, contacts, tasks, notes, and journals. You will set some advanced and language options in the interface and learn how to manipulate item tags and arrange the content pane.

In addition, we will apply some search and filter tools, and print Outlook...