Data Sorting & Filtering in Excel || Basic & Advanced

This video covers all the basic and advanced concepts about data sorting and data filtering in Excel (Basics to Advanced Level). It starts with the absolute basics and covers advanced examples. It covers the following topics: -- Data Sorting (by name, text, color, icon and custom list) -- Multi-Levels of Sorting -- Data Filter (by text, number, date, and color) -- Advanced Filter in Excel -- Filtering and Sorting in Excel Data Tables Excel has a lot of sorting options such as sorting from left to right, sorting based on color and icon and doing multi-level sorting. All these sorting options can be accessed from the single sorting dialog box. Similarly, you have a lot of filtering options - such as filter based on numbers, text, dates and even colors. Excel has many data analysis functionalities and a good knowledge of filtering and sorting data in Excel will help you analyze a huge amount of data easily.

Let’s connect on social media:

[ahcreation]

sir, I Have an excel file with students roll number and section and the subjects they studying as shuffle and i want to filter roll number of students with matching criteria (section and Subjects), how to do?

[AlexCheriankalapurayil]

In Pivot tables, how to show in 1000s ( 2500 =2.5..no need of k)