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

Investigating new functions

Excel 2021 has a few new functions, namely, XLOOKUP, LET, XMATCH, and a couple of dynamic Array functions. We will discover these in the following topics.

New dynamic array functions

In the previous chapter, we introduced the FILTER and UNIQUE functions. The FILTER function is part of the new dynamic array formulas in Excel 2021. When we apply this function, the results spill from a single cell into the adjacent cells. Normally, when using the traditional filter in Excel, it will not update as new data is entered into the workbook – you would have to recalculate or update the results.

Dynamic arrays are perfect since, when the underlying data (source data) is updated, all lists based on that dataset are updated automatically.

Along with the new FILTER function, we also have a couple of other functions added to the list of dynamic array formulas, namely, SORT, SORTBY, UNIQUE, SEQUENCE, and RANDARRAY.

Let's recap the FILTER function...