FILTER HACKS Surprising TRICKS in Excel | Auto Filter & Advanced Filter Hacks Tips and Tricks
Вставка
- Опубліковано 5 вер 2024
- FILTER HACKS Surprising TRICKS in Excel | Auto Filter & Advanced Filter Hacks Tips and Tricks
1. Auto Filter Hack Trick (You've never heard of)
2. Surprising Advanced Filter TRICK in Excel (You've never heard of)
Download the Assignment Master Practice Folder here (All Playlist Example at one place)
drive.google.c...
(Playlist Folder-Excel Tips and Tricks-FilterHacks.xlsx)
Website - "www.innozant.com"
Let's Connect:
Instagram ► / innozantoffi. .
Facebook ► / innozant
Twitter ► / innozant
Linkedin ► / inno. .
#filterhacks #advancedfilterhacks#Innozant #advancedfilterexcel #misinterviewquestions
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.
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.❤️🙏
6
A BIG BIG BIG shout out to Innozant Team. One of rarest educational platform.
Oh thank you Raj thanks for your support I am very honoured to serve you all with various methods of learning and education 🙂😁
Bahut excel ki videos dekhi but aap ka tarika or tricks achhe or knowledgefu rahte hai 🙏🙏
Thanks Raja
@@Innozanthello sir
Being a corporate professional its Really Helpful.
Thanks dear
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
Thanks Harish ji ❤️
Wah sir kya Kamal ka chiz aapne sikha diya...
Mera job me bahout use hota h ye ...
Thank you
Thanks dear
These tricks are self research which comes after many practice Thanks Sir ji
Thanks..keep learning
Waah....maja hi aagaya.
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.
I am working as MIS reporting analyst since three years.. won't listen any time...super sir..super sir
Thanks Prasanna ..Happy learning dear ❤️👍
Sir aapko bahut bahut dhanyawaad ❤❤❤❤ bahut achha padate ho sir
Thanks dear...Padhiye aur life me aage badhiye yhi wish meri 👍❤️
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......
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..❤️😊🙏
Bohat zabrdast
Overall wow...
but sir, 1st approach is not working on "table format"
Great Job, brother. Love your energy, style and smile
Thanks
Bhaut hi shandaar tha sir, salute sir 🤗🤗
👍❤️
This is really great. Your excel videos are very addictive and everyday I am learning new things. Thank you
Thanks Kavita, Really means a lot ❤️
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.
Sir aapka hacking formula to gajab ka hai sir simple but unique idea hai thank you sir
Thanks Pramod.
🙏😊❤️
super ji , very much practical oriented and time saving concepts
Thanks dear
बेहतरीन, वास्तव में शानदार।
धन्यवाद आपका अच्छी जानकारी share करने के लिए।
Zabardast Brother... Cha gaye .. Thanks and Bless you
Thanks dear
Bahot sahi bataya sir Thank you !!!
Thanks Dear❤️❤️
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 ❤️😌
Thanks Dear .Happy learning ❤️
Ecruited as sales operation analyst and i really need a lot of help in excel and i cannot thank you more🙏
Super Se Uper. Nd Uper se bhi Uper.
Thanks Are jeet ji❤️
Unique trick.Gazab
Excellent bro... very unique tips... thanks a lot...
Shaandar jabardast zindabaad
Sir your just awesome knowledge about excel thanks very much
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.
Thanks Anoop Jim.happy learning ❤️
REALLY VERY USEFUL TRICKS. tanks a lot sir.
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.
Thanks from depth of my heart
Thanks Kundan
Wonderful Tricks and Tips, really helpful in our day to day activities.... Thanks Sir....
Thanks dear
It was really helpful and new!! The last hack...
Excellent pehle kyun Nehi dekha aapka video. Koi Nehi jab aankh khuli tabhi savera.
Thanks...Keep learning ❤️❤️ 👍
Sir u great and u tricks also Excellent and very helpful God gave u long life and keep healthy
Thanks dear
THIS WAS REALLY REALLY AWSOME OPTION. THANK YOU SO MUCH SIR FOR SHARING THIS.
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..
Thanks Vijaypal ji .We welcome you then experience the taste of success with Innozant-Seed of success
Sir ji data validation me kuch new btaiye plzz। Thanku sir bhut ache se smjhaya h aapne aap logo jaisa itna acha centar me nhi pdhate
Thanks Dolly .Ok Data Validation ke upar aur video bnate hain
Thanku sir jee
Wonderful Tricks and Tips, really helpful in our day to day activities.... Thanks 🙏
Thanks Pratap ji
Excellent . Loving it from Pakistan.
Best trick... Kafi useful hai
Thanks Sajjad.❤️😊🙏
Very useful....Great learning with you....Many thanks
Thanks Hemant ji
Your tricks r really mind-blowing,thanks
Thanks Saroj
apko bahut bahut dhanywad sir
Great Sir, कुछ नया सीखने को मिला
Thanks Dev
Mind blowing solution sir
Very best video sir
you are great trainner. your method of teaching is excellent. Sir i requrested that you should upload your best vidoes
Thanks
I was doing right click n filter by cell value.... This one is good
Thanks dear
Too effective and awesome must see everyone this vedio tutorial
Thanks Narender Ji
Amazing hacks.... Woow wonderful sir..
Sir it's so lovely and your all videos so usefull and motivated thank you so much teach for every one people 🙏😊
Thanks dear
I am new viewer and enjoying alot excel techniques. Wonderful delivery. God bless u.
Salute to your skills
You are experts in excel
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…🙏🙏🙏🙏
Thanks Ankur Ji .God bless ayou dear❤️
Sir, this video of yours has reduced a lot of my work, your every video is better than all youtubers, thanks sir
Thanks dear ❤️❤️
excellent dear sir. Superb & unique method.
Thanks dear
Fantastic Sir, you truly ease my office jobs, thanks
You have great knowledge of excle
Wonderful real job
That's a turning point of reporting in excel.
Thank you sir.
❤️❤️👍
Simply amazing 👏
Mind-blowing sir...
Gudmorning sir. Truely u develop our interest.
Thanks..keep learning
From today I will say Guruji,
You teach very unique tricks but with very simple ways.
Thanks a lot 🙏
Thanks dear...God bless You .Keep learning 👍❤️
what a great tip , Thanks Sir
Bht acha lga bht acha bht khoob more helpful ab toh bs yahi filter shi h
Thanks Lokesh
🙏🙏😊❤️
Great Sir. Thanks Sir.
Too good. Thanks a lot
Absolutely beautiful
Thanks Dhiraj Ji
u r simply unbelievable sir..... tis is mind blowing trick.... u rock sir in excel
❤️🙏😊
mera 80% kaam bas ek isi video se ho jata hai. bahut bahut Dhanyabad.
Awesome video for filters thanks for uploading this video 🙏🙏
Thanks dear ❤️
I dont know trick this before. Thankyou sir
👍❤️
Thank you so much sir. Love from Pakistan
Thanks Kashif
Superb, Thanks for sharing ❤️❤️❤️
Thanks dear
Very Informative thank you so much
Thanks dear
very useful tricks,
thank you sir
Your Helping Lots Of Students and Me Also Your Teaching Style Mind-blowing .I hope You Achieve the Lots Of Success in Your Life.
Thanks dear..Keep learning ❤️
Very nice simple and easy
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
👍❤️
Zehar hai katai 🙏🙏
❤️❤️😊👍😀
Superb... if i change the criteria range it wil not change..ex: >50000 will show and if i change
Didnt get your query dear.kindly explain
Seriously wow sir ❤️ Maza aa gya
Great
Sir ji you are great 👍👍😊
Excellent bro.
Great.......sir.......thanks
Zabardast 👌
Superb se bhi Uper sir......
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 🔥🔥
Amazing
Very very nice sir
Great ho aap sir
Thankyou sir ji
Thanks Kuldeep Ji
Excellent
Bahut Gazab
Sir, I have 2021 Excel, in that autofilter hack is not working like yours, when I press alt+2 it only apply filter to the header not actually filtering, I have also checked that I have added Autofilter only to my QA toolbar
You are excel magician
Thanks for such a lovely feedback..❤️❤️😊🙏🙏
भी मज़ा आया, ओर ये नो मजा है सबको लेना चाहिए 😉
Too Good
Thanks sir