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

[@wayneedmondson1065]

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

[@unique-wolf495]

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

[@kimdavis5272]

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

[@margad-erdeneboldbaatar4704]

Thanks for the this course.

[@tusharbansal786]

amazing

[@vivekkatole153]

Great video . Learnt

[@YT2007XYZ]

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?

[@zeeshanshaikh2124]

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

[@atulpahurkar9153]

Where i will get excel file for study and practice

[@kimYeonyuu]

What Buttons did you Press on 11:30?

[@jyotisharma9313]

Thankyou.....its really very helpful....

[@venice741]

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?

[@Happiness_Key]

Use paste special...and select skip blanks

[@mrudulalakshmi1590]

will u plzz zoom the data

[@FRANKWHITE1996]

thanks!

[@naijatalkertive]

U are the best

[@hafizurrahman9081]

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

[@wayneedmondson1065]

The trick is: apply a filter to the range you want to sum; while the range is filtered, use ALT+= to autosum the column at the last cell in the range; since you have a filtered range, autosum will enter the SUBTOTAL() function instead of the SUM() function. You can then unfilter your range and the SUBTOTAL function remains. For Filter/Unfilter, have the active cell within your range of data and press CTRL+SHIFT+L. It is a toggle.. so.. goes on if it is off.. goes off it is on. If you need more description, check out this link: www.excelcampus.com/keyboard-shortcuts/autosum-subtotal-formula/ Hope this helps. Good luck!

[@jitendrakumar-fy4hh]

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

[@samuellechenkhiamchoi8439]

Welcome to online class 101

[@1gopalakrishnarao]

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

[@mrudulalakshmi1590]

data is not clear