FILTER HACKS Surprising TRICKS in Excel | Auto Filter & Advanced Filter Hacks Tips and Tricks

[@excellenciamadhapur9174]

Guruji, I am thinking while developing MS Office especially Excel, you are one of the employee of Microsoft( BillGates). Wonderful trick and explanation. No one is explaining like you. Actually my mother tongue is Telugu. But your language is very easy to understand. Thank you Guruji.

[@Innozant]

Omg..No Words ..M truly speechless...These word are Best gift from a student like you for me..God bless you dear..Will always make awesome content for you dear.❤️🙏

[@superiogoswami7141]

6

[@amitfore]

A BIG BIG BIG shout out to Innozant Team. One of rarest educational platform.

[@Innozant]

Oh thank you Raj thanks for your support I am very honoured to serve you all with various methods of learning and education 🙂😁

[@z-4-zoon650]

Waah....maja hi aagaya.

[@z-4-zoon650]

But there is a problem....I can't go for more than one criteria in a single column. eg: I want to filter east and west but not other.. So in this condition, your trick is failed...plz suggest any different option if possible.

[@syedfamuneeb8654]

Superb hacks even for excel veterans! Besides excel, you also have a wonderful voice. You will pass any voice and speaking skills test for radio/ TV/ cinema

[@biswajyotimondal6885]

Sir, Thanks too apko nahi, Hama kahana chhaya is leya many many thanks for ur video tricks once more thanks, apka tricks mujha bohut bariya lagta hai, is leya mea apka video dekhta hoo, apna bariya karka explain korto ho samajna mea subudha hote hai, Biswajyoti from Kolkata, see u next video...

[@heeralalkumawat2132]

Great

[@narottammanihal8463]

बेहतरीन, वास्तव में शानदार।
धन्यवाद आपका अच्छी जानकारी share करने के लिए।

[@asifkamal5012]

Excellent . Loving it from Pakistan.

[@Unknown.Userrr]

Bahut excel ki videos dekhi but aap ka tarika or tricks achhe or knowledgefu rahte hai 🙏🙏

[@Innozant]

Thanks Raja

[@rsingh1988]

​@@Innozanthello sir

[@Rudrakshyaa]

Ecruited as sales operation analyst and i really need a lot of help in excel and i cannot thank you more🙏

[@harishsingh2958]

Sir you are so amz...maan gaye aapko sir...maire liye unique tha....jitna bhi thanks kahu utna kam hai sir..hats off you sir

[@Innozant]

Thanks Harish ji ❤️

[@Usmanghani063]

Excellent bro... very unique tips... thanks a lot...

[@snehanayak7487]

THIS WAS REALLY REALLY AWSOME OPTION. THANK YOU SO MUCH SIR FOR SHARING THIS.

[@naeemkhokhar8270]

Zabardast Brother... Cha gaye .. Thanks and Bless you

[@Innozant]

Thanks dear

[@RajuKumarYadav-i3t]

These tricks are self research which comes after many practice Thanks Sir ji

[@Innozant]

Thanks..keep learning

[@MrBh2000]

I am new viewer and enjoying alot excel techniques. Wonderful delivery. God bless u.

[@muzamiludaas]

Waaaah kiya baaaat hiii❤️❤️❤️ love from pakistan

[@devmittal8134]

Great Sir, कुछ नया सीखने को मिला

[@Innozant]

Thanks Dev

[@qaisermuhammad4708]

Fantastic Sir, you truly ease my office jobs, thanks

[@im4uajnds]

Wonderful Tricks and Tips, really helpful in our day to day activities.... Thanks Sir....

[@Innozant]

Thanks dear

[@mohanjoshi5639]

Unique trick.Gazab

[@star5guy]

Great Job, brother. Love your energy, style and smile

[@Innozant]

Thanks

[@kavita8390]

This is really great. Your excel videos are very addictive and everyday I am learning new things. Thank you

[@Innozant]

Thanks Kavita, Really means a lot ❤️

[@phcderdi5221]

Mam I am government employee. I have many issues and question in excel. So I want small small solution. If anyone have solution discussion with my mail id and help me.

[@shahnawazkhan1776]

Bhaut hi shandaar tha sir, salute sir 🤗🤗

[@Innozant]

👍❤️

[@73vinodkumar]

super ji , very much practical oriented and time saving concepts

[@Innozant]

Thanks dear

[@PratapSinghSoam]

Wonderful Tricks and Tips, really helpful in our day to day activities.... Thanks 🙏

[@Innozant]

Thanks Pratap ji

[@doremonumar2302]

I am subscribing this channel because i found this channel very much useful compare to other channels ... thanku sir for these mind blowing hacks . Love you from Kashmir ❤️😌

[@Innozant]

Thanks Dear .Happy learning ❤️

[@paulpal6599]

Sir yours teaching skills awesome ...

[@jaisan5582]

Superb Guruji. Thank you so much.

[@koushik4484]

WONDERFUL. Really surprising. 👌👍🙏🏻

[@prakashchordia3899]

REALLY VERY USEFUL TRICKS. tanks a lot sir.

[@user-jc6te1vm8v]

u r simply unbelievable sir..... tis is mind blowing trick.... u rock sir in excel

[@Innozant]

❤️🙏😊

[@ankurghosh7734]

Sir your just awesome knowledge about excel thanks very much

[@rahulgoenka4570]

It was really helpful and new!! The last hack...

[@SandeepKumar-wm6gd]

Amazing hacks.... Woow wonderful sir..

[@sonukumarskp6933]

Wah sir kya Kamal ka chiz aapne sikha diya...
Mera job me bahout use hota h ye ...
Thank you

[@Innozant]

Thanks dear

[@KundanSingh-qq6kp]

Thanks from depth of my heart

[@Innozant]

Thanks Kundan

[@rashminandnitips3218]

Superb se bhi Uper sir......

[@muhammadramzan6371]

Sir u great and u tricks also Excellent and very helpful God gave u long life and keep healthy

[@Innozant]

Thanks dear

[@sarojkumarsahu2858]

Your tricks r really mind-blowing,thanks

[@Innozant]

Thanks Saroj

[@shamaleemendis8091]

Thank you sir for the great mission you are doing for us.. I am from Sri Lanka. I want to get sort desending in copy to onther location. what should i do

[@siddharthladdha4272]

i was in search for great video to learn new tips and tricks ..... and now im so satisfied that i found this video...... you are just op mannnn 🔥🔥

[@anoopchaudhary8893]

Sir, I must say that you are an amazing teacher. In the last couple of days I have been watching your videos and believe me I have learnt so many things. Which helps me in daily work.
Thank you.

[@Innozant]

Thanks Anoop Jim.happy learning ❤️

[@nikeshsk1]

Great. I have a query header should be in 1st row or it works even if data starts from any row

[@ashutoshawasthi954]

Awesome video for filters thanks for uploading this video 🙏🙏

[@Innozant]

Thanks dear ❤️

[@prashanttyagi1156]

Mujhe to aap ke video ka besabri se intzaar rehta hai sir kyonki naya hi seekhne ko milta hai. Thank u very much. Mahadev ki kripa aap per bani rahe aur aap ki hum per.

[@hemantkarmalkar3828]

Very useful....Great learning with you....Many thanks

[@Innozant]

Thanks Hemant ji

[@ankursingh35]

Wow you are really super hero of Excel.
I will always be very keen for you all new videos. Thank you for giving so unique techniques of excel…🙏🙏🙏🙏

[@Innozant]

Thanks Ankur Ji .God bless ayou dear❤️

[@followups1010]

So great sir, you are genus of MS- Excel, i am very happy and lucky when I got you from sea of you tube and subscribe your chennal. keep it up sir..

[@Innozant]

Thanks Vijaypal ji .We welcome you then experience the taste of success with Innozant-Seed of success

[@Altaf_Alam]

Thank u sir.....it was fantastic 🙃

[@riteshtiwari9382]

Sir it's so lovely and your all videos so usefull and motivated thank you so much teach for every one people 🙏😊

[@Innozant]

Thanks dear

[@sagar962]

Bahot sahi bataya sir Thank you !!!

[@Innozant]

Thanks Dear❤️❤️

[@asfandyar8240]

Being a corporate professional its Really Helpful.

[@Innozant]

Thanks dear

[@shrikantbadge3978]

Amazing sir. Beautiful content, no words.

[@bishtlokesh1297]

Bht acha lga bht acha bht khoob more helpful ab toh bs yahi filter shi h

[@Innozant]

Thanks Lokesh
🙏🙏😊❤️

[@nitinshukla914]

Guru G, Namaste. Aapke dono hack bahot hi Shandar lage. Pahele wala Filter Hack waqai naya hai, mujhe office me work load bahot hota hai to bahot kam aayega. Par, Sir, Dusara Autofilter wala hack, to mai pahele se janta hu, aur rojana office work me use bhi karta hu.
Sir, aapke har videos me aapka presentation bahot hi Saral aur Asardar hota hai. Dhanyawad......

[@Innozant]

Thanks Nitin..Achi baat hai...Tricks se benifit hota hai ki aap apne kaam ki productivity badha skte hain..Hope aapko videos pasand aante honge aur life me value add krte honge aap.. Thanks..❤️😊🙏

[@devangthakkar6847]

excellent dear sir. Superb & unique method.

[@Innozant]

Thanks dear

[@real5731]

I was doing right click n filter by cell value.... This one is good

[@Innozant]

Thanks dear

[@hypernovawizard]

Superb, Thanks for sharing ❤️❤️❤️

[@Innozant]

Thanks dear

[@SirKasim666]

Excellent pehle kyun Nehi dekha aapka video. Koi Nehi jab aankh khuli tabhi savera.

[@Innozant]

Thanks...Keep learning ❤️❤️ 👍

[@SINGERMANOJSINGH]

Too effective and awesome must see everyone this vedio tutorial

[@Innozant]

Thanks Narender Ji

[@abhijitdey1819]

Woww mind blowing ticks. Thank you so much sir🙏

[@BeingInside]

Seriously wow sir ❤️ Maza aa gya

[@prosanjitbhura1161]

Mind-blowing sir...

[@excel-nh4cq]

you are great trainner. your method of teaching is excellent. Sir i requrested that you should upload your best vidoes

[@Innozant]

Thanks

[@jaymasaraswati1439]

Sir aapko bahut bahut dhanyawaad ❤❤❤❤ bahut achha padate ho sir

[@Innozant]

Thanks dear...Padhiye aur life me aage badhiye yhi wish meri 👍❤️

[@dsraghav4975]

Mind blowing solution sir

[@Harsh77627]

Sir ji you are great 👍👍😊

[@arijeetkumarsharma226]

Super Se Uper. Nd Uper se bhi Uper.

[@Innozant]

Thanks Are jeet ji❤️

[@dssaini689]

Sir, really a awesome trick, I never seen like this trick till date, your are genius

[@Innozant]

Thanks dear.Gid bless You

[@siva4569]

I am working as MIS reporting analyst since three years.. won't listen any time...super sir..super sir

[@Innozant]

Thanks Prasanna ..Happy learning dear ❤️👍

[@VishalSharma-zm3on]

Sir You are great 👏😊👍👍👍

[@shrikantbhaibhosale]

what a great tip , Thanks Sir

[@imran-yb9kw]

100/100 again beauty ❤❤❤❤

[@marthikutumb1307]

Your Helping Lots Of Students and Me Also Your Teaching Style Mind-blowing .I hope You Achieve the Lots Of Success in Your Life.

[@Innozant]

Thanks dear..Keep learning ❤️

[@PankajSharma-em2vn]

You have great knowledge of excle

[@krashnkant8858]

Sir, this video of yours has reduced a lot of my work, your every video is better than all youtubers, thanks sir

[@Innozant]

Thanks dear ❤️❤️

[@Alli21]

Simply amazing 👏

[@nkraghav1944]

very useful tricks,
thank you sir

[@golmaal935]

Superb Video,Thank U,Sir issi technique se Macro pe video banayiye ..
Excel 2011 me Alt +... wala feature nahi hai?

[@technicalknowledge409]

It's a unique way to making understand... Thanks a lot for these videos... Have learnt a lot of excel tricks from ur videos

[@Innozant]

Thanks dear❤️

[@pramodbhavsar4488]

Sir aapka hacking formula to gajab ka hai sir simple but unique idea hai thank you sir

[@Innozant]

Thanks Pramod.
🙏😊❤️

[@BimanChGhosh]

Salute to your skills

[@naveenpandeya9168]

Shaandar jabardast zindabaad

[@minhajshareef1180]

Sir, You are amazing all your videos are well explained and thank you so much posting your videos.

[@Innozant]

Thanks Minhaj sahab..Keep learning

[@AsgharAli-ck8qh]

you have a great job with excel and I hope that we will get a lot unique to learn there
I am too facing a problem in my excel sheet in filtering the data when I put the filter as my desire then the sum and grand total's row also go hide, so could you help me to solve this?

[@Nadeemahmed.1234]

You are experts in excel

[@Babliana]

Informative ❤

[@ravitrivedi2755]

Superb 👌👌👌🙏🙏🙏💐💐💐👍👍👍

[@bimawalebhaiyaji7665]

Great Sir. Thanks Sir.

[@dancecity5879]

From today I will say Guruji,
You teach very unique tricks but with very simple ways.
Thanks a lot 🙏

[@Innozant]

Thanks dear...God bless You .Keep learning 👍❤️

[@mdsajjadhussain2653]

Best trick... Kafi useful hai

[@Innozant]

Thanks Sajjad.❤️😊🙏

[@adilhameed2233]

Bohat zabrdast

[@mst6345]

Sir very informative video thanks a lot great job ❤️❤️❤️🇵🇰🇵🇰

[@Innozant]

Thanks dear

[@Bhusanization]

Thanks Sir . That’s so helpful
Just got a tip from your tips , there is no need use of alt shift l for removing filter rather in the same way you can add filter to the command and u can press alt 4-5-6-7 wherever u have put filter . You can add filter and auto filter both to the command button

[@Innozant]

👍❤️

[@rashidhassan417]

Very best video sir

[@vinodarora9326]

Really too good teacher you are... Always teaches with full dedication. 🙏🙏🙏🙏

[@Innozant]

Thanks Vinod Ji.keep learning

[@KrishnaThakur-nf5jo]

Very good sir ❤❤❤❤❤

[@Mkashyap1205]

Very Nice Sir 👍👍

[@husenwalode8889]

Very Nice Sir 👍👍 It will really help to reduce time to apply filters

[@Innozant]

Thanks dear🙏❤️👍