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
   114   115   116   117   118   119   120   121   122