Data Sorting & Filtering in Excel (Basic + Advanced) | FREE Excel Course

preview_player
Показать описание
This video covers all the basic and advanced concepts about data sorting and data filtering in Excel.

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.

This video is a part of my Free Online Excel Training where I show you how to use Excel from the basics and also cover a lot of advanced topics.

This YouTube channel is managed by Sumit Bansal (who also runs the TrumpExcel website).

This channel is meant for people who want to learn Excel. It covers a lot of Excel basics and advanced Excel topics such as Excel Formulas, Functions, Pivot Table, Shortcuts, Excel VBA, Macros, Excel Dashboards, Excel Charts, Conditional Formatting, Power Query, etc. Please subscribe to this channel to be the first to know when new Excel tutorials come out.

⚙️ Gear I Recommend:

Note: Some of these links here are affiliate links!

#Excel #ExcelTips #ExcelTutorial
Рекомендации по теме
Комментарии
Автор

Hi Sumit.. thanks for this summary of Data Sorting and Filtering. Thumbs up!

wayneedmondson
Автор

hello from 2023 and still your videos are amazing we appreciate it.
hanks for ur time and for sharing ur works free.
<3

unique-wolf
Автор

I had not seen the "Advanced Filter" option before. GREAT feature. Will really simplify one of my projects. Thanks for the video1

kimdavis
Автор

Sumit... Love your videos. Is there a way to use a ListBox control on the spreadsheet and then use the selected item in the listbox as your filter criteria?

YTXYZ
Автор

plz provide practice sheet also i am not able to access it on ur website

zeeshanshaikh
Автор

Where i will get excel file for study and practice

atulpahurkar
Автор

Thank you . Excellent. Your explanation is very simple, easy to understand, and it is of great use to the Excel learners. Doing a great job indeed. Your contact no. please, for learning vba

gopalakrishnarao
Автор

Hi Sumit, I have a large table setup with lots of blank cells in other columns. Somehow, once I applied Advanced filter, the blank cells will have value paste in by Excel, do you know how can I avoid that?

venice
Автор

Dear sir.
I want to know keyboard shortcut for subtotal function. Thank you in advance.

hafizurrahman
Автор

Sir 🙏
I want to extract data by using of advance filter of any month from the date (format table.
How do it do?

jitendrakumar-fyhh