Data Structure
Networking
RDBMS
Operating System
Java
MS Excel
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
Physics
Chemistry
Biology
Mathematics
English
Economics
Psychology
Social Studies
Fashion Studies
Legal Studies
- Selected Reading
- UPSC IAS Exams Notes
- Developer's Best Practices
- Questions and Answers
- Effective Resume Writing
- HR Interview Questions
- Computer Glossary
- Who is Who
What are the new functions introduced in Excel 2021?
Introduction
In today's data-driven world, the ability to swiftly search and retrieve specific information is vital. This is particularly true when dealing with large datasets spread across multiple sheets or worksheets within a file. Manually manipulating the matrix through each sheet can be time-consuming and prone to errors. In this article, we will gain deep insights into the new functions that are introduced in Excel 2021.
The main advantages of Excel 2021 are better teamwork, improved expert performance, better productivity, more interactive ribbon with a new tab, more flexibility, and new Dynamic Array Formulas to get accurate results.
Description of newly inbuilt functions in Excel 2021 are listed below −
Sequence Number |
Function and Description |
|---|---|
1 |
Let It appends the specified name to a variable along with the value. |
2 |
Filter It allows you to filter the table and extract certain value based on the predefined condition. |
3 |
XMATCH It returns the position of the searched value which is presented in an array. |
4 |
XLOOKUP It looks up the value in a single column and retrieves the value from another column based on the specified criteria. |
5 |
SEQUENCE Return an array comprising the consecutive integer numbers. |
6 |
RANDARRAY Return the array containing the numbers between 0 and 1. |
7 |
SORT It populates the selected column value either in ascending or descending order. |
8 |
SORTBY The data in the array is sorted based on the value of a corresponding column. |
9 |
UNIQUE It would extract the list of non-duplicate values from a specified range. |
Conclusion
Users may efficiently search for values across multiple sheets or worksheets can save valuable time and effort when dealing with complex datasets. By mastering Excel's built-in features such as Unique, Filter, XMATCH functions, users can streamline their workflow while ensuring accurate search results. Embrace these techniques to boost productivity without getting overwhelmed by endless rows of data spread throughout a workbook.
165 Views
