Excel 5 Productivity Tricks

[@rajnarayan1739]

Sir please make video about Dynamic Drop Down List with auto refresh.. like Country state block Na city...

[@mohitjaiswal4023]

Great 👍 sir it's very helpful for improving my skills in Excel.

[@sekharispassion]

Sir, Thank you for the tricks especially those mentioned in 2 & 3. In case of trick 5, can I use pivot table to display subtotals as an alternative.

[@bhesaniyarajesh1750]

Thank you sir very useful for us.

[@AbhishekKumar-gf4db]

Sir, we are very excited for your video. I got a offers latter from OLIS INFOSYSTEM private limited as a role of MIS Executive. Without your video, I can't get this JOB. I will never forget,Your contribution. Thanks sir Thanks #innozant

[@Innozant]

Congratulations Abhishek Ji..Have a wonderful career ahead ❤️👍

[@sawaimalhi8439]

Bhot bhot mubarak ho

[@shri_420]

Very useful Thank you so much

[@satishojha6240]

Awesome sir 🙏🙏🙏. Good night

[@satscoolstyle4210]

Very helpful 👍🏼

[@saipianocovered1731]

Bahut Sundar sir jee 🙏

[@pawankhedwal1]

Thanks Sir, fruitful video as usually 🙏

[@Innozant]

Thanks dear

[@Soft-tips-tricks]

Amazing tricks

[@shubhamgupta392]

Amazing.... tricks... ❤️

[@somnathadhikary1421]

Thank you sir for showing keyboard shortcuts

[@Innozant]

Thanks dear

[@createyour6681]

Very Great Sir

[@ManishVerma-gg8xl]

Trick no. 5 awesome

[@BashirAhmed-uh9pp]

Wonderful video

[@shreyapaul358]

Aa gaye hum bhi sikhne

[@sawaimalhi8439]

Welcome

[@Innozant]

Welcome Shreya...Keep learning ❤️👍

[@balance1772]

Thank you Guru ji

[@komalsoni7212]

Thanks sir...this video is very helpful 👍

[@Innozant]

Thanks Komal..Happy Learning ❤️

[@MIS_PRODUCTION_AAA]

Ever and forever

[@shubhamsoni8115]

Thank you sir

[@dilipshedge8503]

❤❤ thank you so soo much sir

[@aqeelahmadengr3]

Thank-you

[@asifkhurshid9208]

great, thanks and regard

[@Innozant]

Thanks Asif

[@Maverick.Man.]

Sir vba pe video banao

[@hsgusain2054]

Thanks sir

[@vinayakpotadar4093]

Super sir

[@mohitsharma-ym3km]

Hello sir, I need your guidance. I have learnt excel and currently working as well. Now I want to grow but I am confused that what should I learn next. Either SQL or VBA ?? My coding aptitude is not good. So I wanted to ask that can I learn SQL and get a High salary job or it is mandatory to learn VBA ?

[@Innozant]

You may proceed with SQL and Power BI .For more info you may connect with us.

[@AshishKumar-hc3km]

Mja aa gya boss

[@vijaykumarjain3222]

Nice sir

[@bishtlokesh1297]

I like it🤓

[@AftabAhmed-uw4ki]

Sir really ASI type others options ki video we are more need plz create more videos about this settings sir plz WhatsApp pa reply ki nhi Dy ti hi plz others options explain text days next month's plz we are more needing this option

[@manojkumarsingh3385]

Sir Aap Ke Sath Judne se Success To milega to Sure Mujhe Believe hai Aap pe 🙏🙏🙏

[@Innozant]

Thanks Manoj Ji..God bless You dear❤️

[@shubhamsoni8115]

Sir please kuchh aur bhi excel deshboard ki video banaiye

[@Innozant]

Ok..noted

[@ManojKumar-ne9is]

Sir please POWER BI per bhi video bnaye. Yeh bhi sikhna h

[@Innozant]

❤️👍

[@ManojKumar-ne9is]

@@Innozant thanks please create

[@ManishVerma-gg8xl]

गुरुजी Trick no.2 वली problem से कई बार गुजर चुका हु जब कोई एक्सल फाइल आँन लाइन डाउनलोड करो और उसमे फार्मूले लगाकर risult निकालने की कोशिश करो तो 90% यही समस्या आती है । धन्यवाद आपका आपने इसे कैसे ठिक करना है इसका रास्ता बताया 🙏🙏🙏

[@durgeshrai8938]

Nyc sir

[@68team]

Trick no 2 , mere khyal se sir " ctrl + ~ ". se bhi kam ho jayega. Pls confirm

[@technicalbabaji381]

Sir ap online bhi classes lete ho advance excel ki sir apke apki videos dhek kar basic to advance excel pura complete ho jayega Or agar apse online complete excel padha ho to

[@Innozant]

Haan sahil humare batches chalte hain offline and online,For more information about new upcoming batches kindly visit Innozant website

[@AftabAhmed-uw4ki]

Sir ap be setting ki hn option mein SA is ja kr is ki ban kre GA

[@9826076733]

Super trick sir kaam bhi or load bhi nahi

[@Anujsharma-db3zo]

Sir MIS me to salary hi nahi hai kya kare?

[@Innozant]

Ye kisne kaha ...Vary krta hai organization that organisation

[@chandrashekharprajapati9451]

सर! मेरा प्रश्न गूगल शीट से संबंधित है। मेरे पास 4 उपयोगकर्ता हैं और सभी के पास काम करने के लिए अलग शीट है। और सभी 4 शीट का डेटा एक ही मास्टर शीट में सेव होना चाहिए। लेकिन कोई भी उपयोगकर्ता मास्टर शीट में डेटा संपादित न कर पाये.

[@DeepakVerma-vb3uu]

8:02 sir but is trick se amounta me last wala cell to select nhi hua na. voto apne manually chalaki se video edit krke manually select kr liya. 😂 interviews me hum thodi video editor leke bethwnge jo is step ko edit krle 😂 apko ye bat bhi clear krni chahiye na ki last wala cell select nhi hoga isse.

[@Innozant]

Deepak Verma ji ek baar data select kren niche tak ..goto special me jayen aur blanke select krke alt = khud bhi press krke dekh lete ti itna lamba msg type hi nahi kara parta aapko..Verma ji jab range select krte hain to last selected scell highlighted dikhta nhi hai but wo already selected rehta hai..aur auto suk krne par subtotal polulate ho jata hai ye baat main ek nahi hajaar baar padha chuka hoon..tried and tested hai..Editor saath le jaane ki jarurat nahi hai..Yadi khudse practice kiye hote ti editor ki jarurat apko nahi parti...aur mujhe to waise bhi nhi krti hai jarurat😁 Ek baar phirse dekhne 8:02 alt equal to press krte hi output flash hua hai na ki editor ne kiya hai na hi maine manual..Bachon wale sawal nhi badon wale counter question krenge aur seekhenge usse to acha lgega mujhe

[@DeepakVerma-vb3uu]

@@Innozant sir mene bhi ye kyi bar try kiya hai. but the main problem is whenever we try to select blank cells, ho humesha last wala blank cell nhi krta select. even if agr hum apke btaye hue trike se last wala cell ectra select krke chle. vo sirf tabhi select hota hai jb humne us last wali row ya us last cell wale amount ke niche ke kisi bhi cell me pehle kuch na kuch work kiya ho. for example border lgaya ho ya kuch type krke delete kr diya ho. orherwise vo goto special se nhi hota last wala cell select bhle hi hum extra cell select krke chle. i know bhut logo ko meri trh ye problem ayegi. but mene ye sirf ek version me nhi blki excel ke kyi versions me use kiya hai. atleast kuch na kuch work pehle se krna jrori hai last cell ke niche ke cells me. tabhi goto special wala option last blank cell selwct krne pr use select krega otherwise vo sirf beech ke hi blank cells ko select krega. bhle hi ap niche ke 10 15 blank cells extra select krke rkho. ❤️❤️❤️❤️❤️