You can also sort using a custom list you create (such as A, C, and B) or by the format of cells which can be done on the basis of cell color, font color, or cell icon. You can sort data by text (A to Z or Z to A), numbers (smallest to largest or largest to smallest), and dates and times (oldest to newest and newest to oldest) in one or more columns. Sorting data in Excel helps the user to understand and visualize data more effectively, facilitates investigation of data, aids the process of searching, organizing and formatting data and ultimately, helps in making efficient decisions. You might want to arrange a list of values alphabetically, compile a list of product values from highest to lowest, or order rows by their corresponding icons or colors. Sorting data is considered to be one of the most essential components of data analysis as it helps in organizing or arranging the data in a specified desirable order and aids the procedure of formatting and visualizing data. By Harshita Srivastava on Januin Advanced Excel Functions and Formulas, Basic Excel Functions and Formulas
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |