{"id":1072,"date":"2024-05-25T10:54:07","date_gmt":"2024-05-25T05:24:07","guid":{"rendered":"https:\/\/isdtp.selvamtech.edu.in\/?p=1072"},"modified":"2025-04-16T17:59:35","modified_gmt":"2025-04-16T12:29:35","slug":"sort-filter-data-with-excel","status":"publish","type":"post","link":"https:\/\/isdtp.selvamtech.edu.in\/?p=1072","title":{"rendered":"Sort &#038; Filter data with Excel"},"content":{"rendered":"<h5 style=\"text-align: justify;\"><strong>Sort &amp; Filter data with Excel<\/strong><\/h5>\n<p style=\"text-align: justify;\"><strong>Sorting<\/strong> of data refers to the arrangements of data that add meaning to the data collected. It may involve rearranging data in a specific order. For example, numerical data collected can be sorted in increasing or decreasing order. Excel offers additional sorting options, including sorting by custom lists. Custom lists are useful when you want a user-defined order that doesn\u2019t follow existing sort rules.<\/p>\n<p style=\"text-align: justify;\"><strong>Filters<\/strong> is used to temporarily hide some of the data in a table, so you can focus on the data you want to see. When filtering, you can specify exact matches or comparisons (\u2018more than\u2019, \u2018less than\u2019) or data that doesn\u2019t match specific criteria.<\/p>\n<p style=\"text-align: justify;\"><div class=\"wp-block-pdfemb-pdf-embedder-viewer\"><a href=\"https:\/\/isdtp.selvamtech.edu.in\/wp-content\/uploads\/2024\/05\/4.-Excel-QB.docx.pdf\" class=\"pdfemb-viewer\" style=\"\" data-width=\"max\" data-height=\"max\" data-toolbar=\"top\" data-toolbar-fixed=\"on\">4. Excel QB.docx<\/a><\/div><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Sort &amp; Filter data with Excel Sorting of data refers to the arrangements of data that add meaning to the data collected. It may involve<span class=\"more-button\"><a href=\"https:\/\/isdtp.selvamtech.edu.in\/?p=1072\" class=\"more-link\">Continue reading<span class=\"screen-reader-text\">Sort &#038; Filter data with Excel<\/span><\/a><\/a><\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2}},"categories":[25,5],"tags":[],"class_list":["post-1072","post","type-post","status-publish","format-standard","hentry","category-ms-excel","category-technical-programming"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/isdtp.selvamtech.edu.in\/index.php?rest_route=\/wp\/v2\/posts\/1072","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/isdtp.selvamtech.edu.in\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/isdtp.selvamtech.edu.in\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/isdtp.selvamtech.edu.in\/index.php?rest_route=\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/isdtp.selvamtech.edu.in\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1072"}],"version-history":[{"count":5,"href":"https:\/\/isdtp.selvamtech.edu.in\/index.php?rest_route=\/wp\/v2\/posts\/1072\/revisions"}],"predecessor-version":[{"id":2637,"href":"https:\/\/isdtp.selvamtech.edu.in\/index.php?rest_route=\/wp\/v2\/posts\/1072\/revisions\/2637"}],"wp:attachment":[{"href":"https:\/\/isdtp.selvamtech.edu.in\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1072"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/isdtp.selvamtech.edu.in\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1072"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/isdtp.selvamtech.edu.in\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1072"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}