3 Ultimate Excel Tricks You Need to Know | Dropdown | HyperLink | Insert Rows

3 Ultimate Excel Tricks You Need to Know | Dropdown | HyperLinks | Insert Rows
1.Dropdoen list that hides used item
2. Create the list of files in a folder and link it to Excel
3. Insert Rows (Multiple Method)
Excel Tips & Tricks Playlist Link - • Excel Tips & Tricks
Download the Assignment Master Practice Folder here (All Playlist Example at one place)
drive.google.c...
Music: www.bensound.com
===========VIDEO COURSE============================
✅ Mastering Excel Video Course
www.innozant.c...
✅ Mastering Power BI Video Course
www.innozant.c...
✅ Mastering VBA Video Course
www.innozant.c...
✅ Mastering SQL Video Course
www.innozant.c...
Visit - innozant.com
=====================================================
===========HYBRID CLASSES============================
✅ आरंभ EXCEL | सक्षम Analytics | निपुण Analytics
✅ Database Training(SQL , PL\SQL , Oracle Developer)
✅ Mastering Data Science
Visit - innozant.com
====================================================
Videos in a Sequence -Basic to Advanced EXCEL
Basic Excel- • Basic Excel-The Learni...
Advanced Excel Sorting and Filter- • Advanced Excel Sorting...
Subtotal TTC and Data Validation- • Excel Subtotal TTC and...
Excel What if Analysis- • Excel What if Analysis
Excel Array and Sumproduct- • Excel Array & Sumprodu...
Excel Lookup Functions- • Excel Lookup Functions...
Excel Pivot Tables- • Excel Pivot Tables
Excel Power Pivot- • Excel Power Pivot
Excel Power Query- • Excel Power Query
Excel Chart and Infographics- • Excel Chart and Infogr...
Excel Dashboard & Reports- • Excel Dashboard & Reports
Value add-ons Playlist
ProQuest-Check Point- • Excel ProQuest-Check P...
Career Guide:सिफर से सिखर तक - • Career Guide-सिफर से श...
StudsTalk -The Journey begins- • StudsTalk-The Journey ...
QUIZ Sunday- • EXCEL MIS QUIZ SUNDAY
Excel Tips and Tricks- • Excel Tips & Tricks
MIS Interview Cracker- • MIS Interview Cracker
MIS Job Live Interview :Based on Real Incident- • MIS JOB Live Interview...
Excel Maharaj- • EXCEL MAHARAJ - For Ex...
Microsoft Powerpoint- • Microsoft Powerpoint
Microsoft Word- • Microsoft Word
Office 365- • Office 365
Google Sheets- • Google Sheets
Microsoft Outlook- • Microsoft Outlook
Power BI- • Power BI
Excel VBA- • Excel VBA Macro
TezXL Jata Shorts- • #shorts | जो TRIM के ब...
Announcements- • Announcements
Website - "www.innozant.com"
Let's Connect:
Instagram ► / innozantinfotech
Facebook ► / innozantinfotech
Telegram►t.me/innozanti...
#exceltricks #exceltips #innozant #exceltipsandtricks #excelproductivitytricks

[@gulshanmehta6997]

सर, हर बार की तरह एक्सेल ट्रिक का जबरदस्त तरका लगाए हैं।।
Thanks🙏🙏🙏

[@Innozant]

Thanks Mehta Ji❤️❤️🙏

[@tusharpawar3557]

nice and very useful in day to day office life 🙏

[@Innozant]

Thanks dear ❤️

[@Narendar.pathak]

Very useful trick .thanks always leaning something new from your videos

[@Innozant]

Thanks dear❤️❤️🙏

[@createyour6681]

Very great sir

[@Innozant]

Thanks ❤️❤️

[@asmrindia]

Very Beautiful Sir

[@Innozant]

Good Morning...Have. A great day Ahead ❤️❤️🙏

[@VikashKumar-mz9cm]

Very very nice sir👌👌👌
❤️❤️

[@Innozant]

Thanks dear ❤️❤️

[@sekhar6106]

Insert rows and hyperlink tricks were amazing. Will save time while working.

[@Innozant]

Thanks Kothuri sahah❤️❤️🙏🙏

[@MrAvtar1979]

Good tutor
These type of person must be supported

[@Innozant]

Thanks Japleen for tour valuable appreciation..Happy learning ❤️❤️

[@MrAvtar1979]

@@Innozant Actually Japleen is my cute daughter. my name is Avtar singh.I m a civil engineer .I love to spend time in excel

[@Innozant]

Oh...Say Hello to Japleen from my side.
Singh sahab hope you starts your learning journey and able to understand the said concept ❤️

[@satishojha6240]

Very effective tricks sir thanku. good night sir 🙏🙏🙏🙏🙏

[@Innozant]

Thanks Satish Ji 🙏🙏🙏

[@kishorpanara4191]

Sir aap ki har tips mast hoti hai thank you sir

[@Innozant]

Thanks Kishor ji .happy learning

[@vishwaschavan7182]

As usual, very useful👍

[@Innozant]

Thanks dear ❤️🙏

[@rajsahu1029]

Very useful

[@dilipshedge8503]

Thank you sir

[@excelskillforall]

The way u say mane ke chalathe hai while explaining even v do the same way.. Understandin n learning tips from you..

[@Innozant]

Thanks Dear..umeed karte hain aap seekh rahe hain aur life me aage badhne me ye help krega.. Thanks for being part of Innozant family ❤️❤️❤️

[@pradeepjangid490]

Excellent

[@Innozant]

Thanks dear ❤️

[@sumanpaik3933]

Thanks sir

[@thisisnature2030]

I fully enjoy your video sirji

[@Innozant]

Thanks dear❤️❤️🙏

[@Maddyy85]

Good sir ji thanx for video

[@Innozant]

Thanks dear❤️❤️🙏

[@hsgusain2054]

Amazing Sir

[@Innozant]

❤️❤️🙏

[@pa2happiness13]

Super ♥️👌 Sir

[@Innozant]

Thanks dear❤️❤️🙏

[@SpartanForever]

Loved the first trick.

[@Innozant]

Thanks dear❤️❤️🙏

[@Amank3107]

awesome sir ☺️

[@Innozant]

❤️❤️❤️

[@sathyanarayana4914]

beautiful video ...

[@Innozant]

Thanks Sathya ❤️🙏

[@sathyanarayana4914]

@@Innozant when uploading series of power bi courses vedio

[@anilnahar6292]

You are great

[@Innozant]

Thanks dear

[@vijaysahal4556]

Nice sir 👍🏻👍🏻👍🏻

[@Innozant]

Thanks Vijay

[@someonefrom2002]

Super tricks 👌❤️

[@Innozant]

Thanks ❤️

[@jayantabhattacharyya628]

Dear Sir
Very useful excel tricks. These are also helpful for day-to-day excel work. Kindly upload a video on macro in advance filter. It would be very helpful for me.
Thanks & Regards
Jayanta Bhattacharyya

[@Innozant]

Thanks Jayanta..Happy Learning dear👍

[@sandeepaswal8944]

Sir I love it. This trick & You are my favourite teacher ❤

[@Innozant]

Thanks Sandeep JI🙏🙏❤️

[@ramandeep14590]

Love that methods🥰😍😍😍

[@Innozant]

Thanks dear❤️🙏

[@ashusharma9439]

2 nd and 3 are very useful

[@Innozant]

Thanks Ashu

[@Innozant]

❤️❤️

[@excelskillforall]

Super sir...

[@Innozant]

Thanks dear🙏🙏❤️❤️❤️

[@parmeshwarmaddheshiya2858]

Shandar

[@Innozant]

Thanks

[@mohammadhafeez1554]

So nice

[@Innozant]

Thanks ❤️❤️❤️

[@bishtlokesh1297]

Amezing

[@Innozant]

Thanks Lokesh Ji❤️❤️🙏

[@PraveenKumar-el8ty]

Sir vba start kariye . I have been waiting for it for a long time.

[@Innozant]

Haan Praveen ji . planning the start the same soon

[@rajsahu1029]

Mast

[@gauravbhatia7987]

Thnq sir

[@Innozant]

❤️❤️

[@kashisharora4563]

Sir ab hum excel nhi excel hi seekh rhe hai ❤️💥💥💥💥

[@Innozant]

❤️❤️❤️❤️🙏🙏🙏

[@aqeelahmadengr3]

Liked

[@Innozant]

❤️❤️❤️

[@tarun_k_shorts]

Sr macros pr bhi series banaye 🙏

[@Innozant]

Jarur bnayenge Tarun Ji..

[@tarun_k_shorts]

@@Innozant 🙏thnxx sr

[@pa2happiness13]

I am hear sir 1st💞

[@Innozant]

👍👍❤️❤️🙏

[@pa2happiness13]

@@Innozant Sorry Sir Laikin aap bura nahi maanye gaa next time ager aap mujhai ye symbol (🙏) reply kijye gaa tho Mai aap kaa koi v videos Mai comment nahi karunga + chennal per visit v Kam Karunga🙏

[@Tarunkumar-yt7lc]

sr please make a vedios on macros

[@Innozant]

Sure..soon will start the series.

[@tapankumardas8252]

Sir Xlookup upar mein ek video kijia Plz..

[@Innozant]

Office 365 series already chal ra hai bht jao aayega vidoe dear xlookup and xmatch

[@himanshu6231]

how to absent employees name highlight according to date in attendance sheet

[@PANKAJSHARMA-eg5mx]

Drop down list ka font ka size kase Increase karte h Sir
Please reply

[@munendrarathore01]

Gazab.... Aap kisi ka bhi mis interview mat lena bhaisahab

[@Innozant]

Hahahaha.
thanks ❤️❤️🙏

[@thewayoflearning2121]

Sir, starting se videos chahiye.

[@Innozant]

Harion ji video description me jaake dekhiye starting se saare playlist milenge.
Basic excel onwards playlist se seekhiye ❤️🙏

[@sravi991]

Pls upload a video for ms office version as to which version will suit d best for a retired person, with max functions, at one time cost, offline working.

[@Innozant]

Ok..will upload it

[@anweshagayan221]

Awesome as always, but the filter is not working in my excel, redirects to FILTERXML.

[@Innozant]

Thanks Anwesha,Which office version you are using now ?try it again dear...

[@anweshagayan221]

@@Innozant m using Excel 2016

[@Innozant]

Then why showing error.its working fine in office 16 version onwards

[@anweshagayan221]

@@Innozant let me check again

[@anweshagayan221]

Sir, can I have your email so that I can share the screenshot

[@durgeshrai8938]

🙏🙏🙏

[@Innozant]

❤️❤️🙏

[@RahulChauhan-ll9pu]

🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏

[@vicktor_damian6612]

Sir,
Q: At 7:37 in Insert Two Rows ( Manual ) ; Why didn't you Choose the First Two rows but the third and forth and rest ??
Thanks For The Video Btw Sir..

[@Innozant]

After 2nd row we need the insert the new rows na thats why

[@vicktor_damian6612]

@@Innozant ohh Okay.. Thanks Again Sir.. ☺

[@ashusharma9439]

🙏👍

[@Innozant]

❤️❤️

[@pa2happiness13]

💞👌🏼

[@BimanChGhosh]

The hyperlink is not working. Due to security reasons

[@vinaydadhich]

बॉस, एक पुरानी फ़ाइल है, जिस में ड्रॉप डाउन लगा है, अब प्रॉब्लम ये है कि मूझे ओरिजिनल लिस्ट
वाला कॉलम नही मिल रहा, जहा लिस्ट है (लिस्ट range वाला कॉलम हाईड कर दिया था)
Please बताइये ना उस रेंज वाला कॉलम को कैसे फाइंड करू।

[@Innozant]

Usimg go to special drop down list se dirrct us reference par ja skte h jahan se uska origin h

[@sayeedshaik573]

🥺Sir, Mis Interview 🥺💔

[@Innozant]

Soon❤️