Page 119 - modular4.0
P. 119
Chapter Profile
New functions: Excel 2021 added a number of new functions that make data analysis more
powerful and efficient. Some of the highlights include:
• FILTER: It is a powerful tool for dynamically filtering data based on specific criteria you define.
• SORTBY: It is designed for flexible and dynamic sorting of data based on values in another
range or array.
• UNIQUE: It is a handy tool for removing duplicate values from your data set and returning a
list of only distinct entries.
Improved accessibility: There are some improved accessibility features, making Excel easier to
use for people with disabilities.
Explore More (Excel 2021) 117

