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

Просмотров 119 тыс.

% 5 155

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.com/drive/folders/1y5h4SMwPLk12xZ2-2U1SDBIQqyH5bz4P?
(Playlist Folder-Excel Tips and Tricks-FilterHacks.xlsx)
Website - "www.innozant.com"
Let's Connect:
Instagram ► innozantoffi...
Facebook ► innozant
Twitter ► innozant
Linkedin ► www.linkedin.com/company/inno...
#filterhacks #advancedfilterhacks#Innozant #advancedfilterexcel #misinterviewquestions

Опубликовано:

12 сен 2020

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 625

@excellenciamadhapur9174 3 года назад

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 3 года назад

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 Год назад

@amitfore 3 года назад

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

@Innozant 3 года назад

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

@SirKasim666 Год назад

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

@Innozant Год назад

Thanks...Keep learning ❤️❤️ 👍

@anoopchaudhary8893 2 года назад

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 2 года назад

Thanks Anoop Jim.happy learning ❤️

@narottammanihal8463 Год назад

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

@amitythub 2 года назад

Thanks for sharing this helpful information ❤️❤️❤️

@technicalknowledge409 2 года назад

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 2 года назад

Thanks dear❤️

@MrBh2000 2 года назад

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

@harishsingh2958 2 года назад

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 2 года назад

Thanks Harish ji ❤️

@kavita8390 2 года назад

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

@Innozant 2 года назад

Thanks Kavita, Really means a lot ❤️

@phcderdi5221 2 года назад

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.

@snehanayak7487 Год назад

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

@sonukumarskp6933 2 года назад

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

@Innozant 2 года назад

Thanks dear

@devmittal8134 2 года назад

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

@Innozant 2 года назад

Thanks Dev

@ankursingh35 2 года назад

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 2 года назад

Thanks Ankur Ji .God bless ayou dear❤️

@PratapSinghSoam Год назад

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

@Innozant Год назад

Thanks Pratap ji

@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 🔥🔥

@omeshkohli6057 2 года назад

That's a turning point of reporting in excel. Thank you sir.

@Innozant 2 года назад

❤️❤️👍

@sandeepaswal8944 3 года назад

This awesome thanks a lot sir i really appreciate it lots of love sending to you ❤❤.... i strongly recommend this channel for Excel users .. very, focussed powerful and organized instructor.

@Innozant 3 года назад

Thanks Sandeep.🙏🙏❤️❤️😊😊

@SylvesterMarshallPune Год назад

Wow, you just earned my Respects. What a way to teach. Simply awesome and very easy to understand. Really appreciate the efforts that you put in creating this lovely video. Pls. keep up the excellent work Sir.

@Innozant Год назад

Really means a lot to me dear

@sarojdas08 2 года назад

your way of teaching really a excellent. your every video is completely different from others. very very depth

@Innozant 2 года назад

Thanks Saroj . Really means a lot to me

@qaisermuhammad4708 Год назад

Fantastic Sir, you truly ease my office jobs, thanks

@Unknown.Userrr Год назад

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

@Innozant Год назад

Thanks Raja

@rsingh1988 3 месяца назад

@@Innozanthello sir

@abhijitdey1819 2 года назад

Woww mind blowing ticks. Thank you so much sir🙏

@narendratanna6629 3 года назад

Thank you, Good technique show by you.

@Innozant 3 года назад

Thanks Narendra Ji

@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?

@yuganyogi Год назад

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

@asifkamal5012 Год назад

Excellent . Loving it from Pakistan.

@star5guy 7 месяцев назад

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

@Innozant 7 месяцев назад

Thanks

@hemantgusain1260 3 года назад

Thanks you for such a amazing trick.

@Innozant 3 года назад

❤️😊🙏 Thanks hemant

@im4uajnds Год назад

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

@Innozant Год назад

Thanks dear

@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 👍❤️

@asfandyar8240 Год назад

Being a corporate professional its Really Helpful.

@Innozant Год назад

Thanks dear

@tejpalsain1507 3 года назад

Wow. Such a very good trik sir. Thank you very much.

@Innozant 3 года назад

Thanks Tejpal..Hope you like the trick.😊😊❤️❤️

@73vinodkumar 10 месяцев назад

super ji , very much practical oriented and time saving concepts

@Innozant 10 месяцев назад

Thanks dear

@ashutoshawasthi954 2 года назад

Awesome video for filters thanks for uploading this video 🙏🙏

@Innozant 2 года назад

Thanks dear ❤️

@shrikantbadge3978 Год назад

Amazing sir. Beautiful content, no words.

@vinodarora9326 Год назад

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

@Innozant Год назад

Thanks Vinod Ji.keep learning

@PawanKumar-lc3du 3 года назад

Thank sir ji Good technique show, so helpful for fast work

@Innozant 3 года назад

Thanks Pawan Ji .❤️❤️👍

@doremonumar2302 2 года назад

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 2 года назад

Thanks Dear .Happy learning ❤️

@paulpal6599 Год назад

Sir yours teaching skills awesome ...

@ArmanKhan-iq3ji 3 года назад

Wow Sir ji ur great thanks for sharing this wonderful video 👍..

@Innozant 3 года назад

Thanks Aman Khan Sahab ..Hope it may help you .🙏👍❤️

@prithvirajsingh1274 2 года назад

Awesome hacks ❤️😍❤️, thank you for such a wonderful video.

@Innozant 2 года назад

Thanks Raj..Happy learning ❤️

@husenwalode8889 3 года назад

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

@Innozant 3 года назад

Thanks dear🙏❤️👍

@premchandsagar157 2 года назад

Awesome video sir Thank you ❤️

@followups1010 2 года назад

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 2 года назад

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

@110Makram Год назад

Nice time saving tricks and very useful for all.Thanks for uploading such important video

@Innozant Год назад

Thanks dear

@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 ❤️

@user-jc6te1vm8v 3 года назад

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

@Innozant 3 года назад

❤️🙏😊

@suncore1611 2 года назад

Excellent Tip Hope to see more of such expertise

@Innozant 2 года назад

👍❤️

@muhammadramzan6371 2 года назад

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

@Innozant 2 года назад

Thanks dear

@ankurghosh7734 Год назад

Sir your just awesome knowledge about excel thanks very much

@nitinshukla914 3 года назад

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 3 года назад

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..❤️😊🙏

@vinodkumar5784 2 года назад

Thanks sir, Please give solution for style comma error, sometimes i work with shares and amount doesn't calculate during doing sum. I need to enter and press back space in each cell. then it does sum. then i use format painter for same and takes too time. Thanks

@prashanttyagi1156 2 года назад

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.

@sarojkumarsahu2858 Год назад

Your tricks r really mind-blowing,thanks

@Innozant Год назад

Thanks Saroj

@pramodbhavsar4488 3 года назад

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

@Innozant 3 года назад

Thanks Pramod. 🙏😊❤️

@kazisazzad9257 2 года назад

So, amazing! ❤️

@aviationandbeyond 3 года назад

Fantastic, Thanks.

@Innozant 3 года назад

Thanks Ghanshayam ji .gn

@rashminandnitips3218 3 месяца назад

Superb se bhi Uper sir......

@yashharishadyar525 3 года назад

Excellent sir, very good information, and good learning video

@Innozant 3 года назад

Thanks Yash❤️❤️❤️

@prakashchordia3899 Год назад

REALLY VERY USEFUL TRICKS. tanks a lot sir.

@bishtlokesh1297 3 года назад

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

@Innozant 3 года назад

Thanks Lokesh 🙏🙏😊❤️

@dssaini689 2 года назад

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

@Innozant 2 года назад

Thanks dear.Gid bless You

@naeemkhokhar8270 2 года назад

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

@Innozant 2 года назад

Thanks dear

@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

@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

@KundanSingh-qq6kp Год назад

Thanks from depth of my heart

@Innozant Год назад

Thanks Kundan

@shahnawazkhan1776 2 года назад

Bhaut hi shandaar tha sir, salute sir 🤗🤗

@Innozant 2 года назад

👍❤️

@jaymasaraswati1439 Год назад

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

@Innozant Год назад

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

@sailvinainstudio6967 2 года назад

Very Very Nice Sir.... It's too Good for Hance our Skills

@Innozant 2 года назад

Thanks Sunny..God bless You

@krashnkant8858 2 года назад

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

@Innozant 2 года назад

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 Год назад

👍❤️

@narenderyadav1727 3 года назад

Very interesting and useful trick.

@Innozant 3 года назад

Thanks Narender Ji

@shrikantbadge3978 3 года назад

Your every video is good and unskippable Sir.

@Innozant 3 года назад

Thanks Shrikant...Love You all for the support.😊❤️🙏 Will always try to upload wonderful videos that enhance knowledge and Life skills.

@shamaleemendis8091 8 месяцев назад

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

@excel-nh4cq Год назад

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

@Innozant Год назад

Thanks

@puransingh-sx2tk 3 года назад

Very informative 👌

@Innozant 3 года назад

Thanks Puran 😊🙏

@ManishVerma-gg8xl 3 года назад

mind blowing tricks thanks sir 👍👍🙏👌👌

@Innozant 3 года назад

Thanks Manish ji..gn❤️🙏

@real5731 2 года назад

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

@Innozant 2 года назад

Thanks dear

@ta20111996 Год назад

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

@ShivKumar-qz8ct 3 года назад

Amazing unique tricks well done Sir !!

@Innozant 3 года назад

Thanks Shiv.❤️😊🙏

@durgeshtripathi8635 2 года назад

Really amazing sir🙏

@z-4-zoon650 2 года назад

Waah....maja hi aagaya.

@z-4-zoon650 2 года назад

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.