USE OF VLOOKUP FORMULA & SUBTOTAL FORMULA IN EXCEL | EXCEL FOR ACCOUNTANT IN HINDI

Dear All,
kindly watch the video for below mentioned topics:
00:01 - intro of the video
02:14 - use of subtotal formula in excel for accountant
11:16 - use of vlookup formula in excel for accountant
17:55 - video summary
‪@TallyHomeInstitute‬
#excel_for_accountants
#subtotal_formula_in_excel
#vlookup_formula_in_excel
_____________________________________________________________
for tally purchase, tss renewal, course related information
Email Id- [e-mail]
Only Whatsapp - 7252033025
____________________________________________________________
___________________________________________________
👉 ALL ABOUT ACCOUNTANT & ACCOUNTING JOB | ACCOUNTANT की जॉब कैसे लगती है | ACCOUNTANT क्या काम करता है
• ALL ABOUT ACCOUNTANT &...
👉 HOW TO GET ACCOUNTING JOB | PART TIME & FULL TIME ACCOUNTING JOB | SALARY OF THE ACCOUNTANT
• HOW TO GET ACCOUNTING ...
________________________________________________
_____________________________________________________________
FOR WATCHING ALL VIDEOS OF OUR CHANNEL, PLEASE PRESS ON BELOW MENTIONED LINK
/ @tallyhomeinstitute
_______________________________________________________________________
telegram link - t.me/tallyhome...
हमारी सभी VIDEOS के FREE PDF NOTES प्राप्त करने के लिए, हमें TELEGRAM APP पर JOIN करे
| APP DOWNLOAD करें और फिर SEARCH करें @tallyhomeinstit
_________________________________________________________________
FREE RUNNING COURSE ON OUR YOU TUBE CHANNEL
👉TALLY PRIME / LEARN TALLY PRIME
• TALLY PRIME / LEARN TA...
👉TALLY PRIME 2.0
• TALLY PRIME 2.0
👉 FREE TALLY ERP9 COMPLETE ACCOUNTING COURSE IN HINDI | HOW TO BECOME ACCOUNTANT | HOW TO LEARN ACCOUNTING WITH TALLY ERP9
• LEARN TALLY ERP9 +GST+...
👉 FINANCIAL YEAR CLOSURE GUIDE/ HOW TO CLOSE FINANCIAL YEAR
• FINANCIAL YEAR CLOSURE...
👉 FREE TDS COURSE ONLINE | HOW TO FILE TDS RETURN ONLINE IN HINDI
• FREE TDS FULL COURSE I...
👉 TCS ON SALE OF GOODS / TCS ON SALE OF GOODS ENTRY IN TALLY
• TCS ON SALE OF GOODS
👉 IMPORTANT TOPICS & TALLY TRICKS FOR ACCOUNTANT | HOW TO BECOME EXPERT IN ACCOUNTING
• IMPORTANT TOPICS FOR A...
👉 NEW GST RETURN COMPLETE DETAIL/HOW TO FILE NEW GST RETURN
• Playlist
👉 FREE GST FULL COURSE IN HINDI/ HOW TO BECOME EXPERT IN GST & ACCOUNTING
• FREE ONLINE GST COURSE
👉 WHAT IS EWAY BILL & HOW TO GENERATE E WAY BILL COMPLETE DETAIL IN HINDI
• E WAY BILL RELATED VIDEOS
👉 MANUAL ACCOUNTANCY (TRANSACTION,JOURNAL ENTRY, LEDGER, TRIAL BALANCE, FINAL ACCOUNT)
• Manual Accountancy / B...
____________________________________________________________
DISCLAIMER ********
TALLY HOME & INSTITUTE does not agree or disagree with the views expressed in the video.
This video is merely a general guide meant for learning purposes only. All the instructions, references, content or documents are for educational purposes only and do not constitute a legal advice. We do not accept any liabilities whatsoever for any losses caused directly or indirectly by the use/reliance of any information contained in this video or for any conclusion of the information. Prior to acting upon this video, you're suggested to seek the advice of your financial, legal, tax or professional advisors as to the risks involved may be obtained and necessary due diligence, etc may be done at your end.

[@nafeesapathan6756]

Thank you sir,aap jaise talented teacher kistmat se milte hai -aap niswarth bhav se padhate hai .I respect you sir

[@ykaynegi8323]

सर 🙏
आप लाजवाब हो।🤘
आप की वीडियो देख देख कर मेरा भी बहुत हौसला बड़ा है।🤘
शुक्रिया सर🙏🙏

[@priyojitsinha6595]

4 saal se jo samajh nahi aya wo chis apne samajha di sir thank u

[@krunalchaudhary325]

In vlookup, the data of invoice no., date, amount etc. is repeating for each name and is therefore not as per original sheet.
And Sub Total Information is Too Good...

[@aRyan123ji]

My favorite formula ..
I learned this formulas already by watching your Old videos. And i made my Own exel sheet for making reco of 2A month wise.. Tnxx.

[@shaharukhnadaf7084]

Can u please share that link..I am unable to find that video..?🙏

[@ajyalam1]

आपकी बात बिल्कुल सही है बहुत बहुत लंबी कर देते हो यार

[@arunbansal8016]

Pahale bar sardar ji ki account per video dekha hai Dil Khush ho gaya 👍👍

[@ashishdangle5387]

Sir aap bohat ti smart and intelligent ho,,, Aapki sikhane ki method bohat pyari hai Sir,,, itani pyar se to koi classes bhi nahi sikhata... Aap such mai guru ho,, kyu ki aapki sikhane se such mai bohat logo ko faida hoga... Thank you very much sirji. 🙏🙏🙏🙏

[@MrKammu]

Very nice one sir, abhi tak vlook me dikkat aati thi..but ab sch me last 3 din se alag alag tarike use kr rha hu aapke concept k basis me..ek dum shi hua..thank you so much sir.

[@rajeshkoli.]

thanks sir mene aajtk itni aasani se valuble information ki se nhi suni nadekhi thanks sir

[@RajKumar-vx3gf]

Dhanbad veer ji ,me tuade dwara skhaya gya. Har topic follow krda ji,tusi boht vdiya knowledge dinde ho,or tuadi eh knowledge kise di jindgi bna reyi hai

[@vishalgaur9979]

Important concept for all accountants.
Thanks sir 🙏

[@rautgulshan]

Thank you sir for Subtotal Copy paste problem solved kr diye.

[@shubhamtomer2202]

Sir aap bahut achha samjhae ho

[@Santosh_Parmar.214]

Bahut hi powerful video hh sir thanks

[@aapkaashish6439]

Sir...aapne bht help kiya...bht achchi tarah samajh me aa gaya

[@chandrakantdewangan3762]

बहुत ही शानदर प्रेजेंटेशन सर जी😍

[@rishabhjain2862]

Kya simpal tarike se btaya mazaaa aa gaya aisha laga jese mera practical work pressar Aadha ho gaya

[@trivedikumarsonesh4194]

आपका बहुत-बहुत धन्यवाद 🙏
आपने एकाउंटिंग की हर बारीकियों और कमियों को पूरा किया

[@anand07121984]

Superb fantastic sir 👍

[@nikhilsaxena2394]

JABARDAST VIDIO BANAYA AAPNE.THANKU SIR

[@deepakprajapatprajapat8]

Nice sir ji bhagwan aapko lambi umar de

[@jssingh3505]

सर vLookup से Trial Balance मैच और GSTR - 2 A with परचेज रजिस्टर Reconciliation पर वीडियो बनाए 🙏🙏🙏

[@TallyHomeInstitute]

noted

[@jssingh3505]

@@TallyHomeInstitute thanks Sir 🙏🙏

[@vickychawla01]

ß
Ic/

[@chandukumar9782]

@@jssingh3505 तो

[@vipinchauhan6156]

Bhut bdia sir ji..mza aagyaaa dekh kr once again..😁😁😁

[@dharmendramaurya8367]

Nice explained both formula with practical examples.
Thanks for your explanation sir ji.🙏🙏👍👍

[@TallyHomeInstitute]

Thanks for liking

[@ajaythakor1498]

Thank you sir muje vlookup ka formula nahi ata tha par apaki video dekha ke a gaya sir thank you so much sir

[@lankeshwarinternationaltra8771]

Gurudev ap ne meri sari problem solv kar diya thanks guruji

[@jyotighule6498]

Important Video

[@Devashish_Thakran]

Thank you sir,
Aapka Dil Se Dhanywad.

[@VivekKumar-sr1hj]

Sir aapka har video important hai

[@arshadahmad1663]

Just love your originality in your videos sir.....
Sir Course ka teesra batch jaldi shuru kar den please .

[@JAATBLOG7500]

Great video sirr

[@deeptipandey5379]

Thankyou sir for sharing valuable information.

[@verma2lali3]

Very Nice aaj Se pahle kabhi samjh nahi aaya tha

[@himanshugera9788]

Awesome video sir ji

[@TallyHomeInstitute]

Thanks and welcome

[@shyam10201]

very nice video about excel formula used

[@TallyHomeInstitute]

Glad you liked it!

[@arjunsingh1811]

Thanku Sir ji

[@MyGorakh]

Sir aap bahut helpful hai.

[@narbatporwal9764]

Great thanks to you

[@GauravKumar-jg3my]

Every videos is very important
Salute sir

[@arunkumarsinghark3024]

बहुत बहुत शुक्रिया सर जी धन्यवाद् 🙏🙏🙏

[@saradaswain3136]

Thank u so much for your easy and understandable ways of describing.

[@TallyHomeInstitute]

You are most welcome

[@shrinathkrgupta5909]

Sir , your video is always helpful us because you explain everything in detail.

[@TallyHomeInstitute]

Glad to hear that

[@heeralaldheewar2300]

Sir aap bahut achha se samjhate ho

[@sonugoswami9326]

Genuinely knowledge 💯 👌 👏

[@ManojKumar-11826]

R Sir apka samjahne ka formula jabardast hai pls keep it up and make video on cheque issue but clear and check in hand in 31 March pls sir 🙏🙏

[@SUNNYKUMAR-kx3qu]

Very nice and knowledgeable video sir...thanks a lot

[@TallyHomeInstitute]

Most welcome

[@shubhamtomer2202]

Sir u r great

[@gagansharmaDevelopYourself]

great video sir

[@TallyHomeInstitute]

Thanks

[@user-vinodkumar143]

Badiya video sir ji

[@jitendraprajapati3445]

Very nice vedio

[@TallyHomeInstitute]

Thank you so much 😀

[@bhayankarboy569]

Sir aapki sabhi video bhot useful hoti h...Aapke jaisa youtuber nhi h koi❤️😎

[@Tarunkumar-go8ub]

Bohut Bdiya Explain Krte ho 😊

[@KaranSharma-ec5sz]

bahut bahut dhanyawaad sir ji.❤️

[@syedsalam3923]

Sir it is very helpful. Thanks for the video.

[@TallyHomeInstitute]

Most welcome

[@urfiahmad7203]

Thanks sir I love you.

[@vikassinger5308]

Good

[@satenderkumar7231]

Very very thanks sir

[@TallyHomeInstitute]

Most welcome

[@kirtibhaivyas7153]

Sir vahe guru ji... Ab hme bank reculation ke video banavo

[@fezanali1346]

Sir Accountant k liye excel me jo bhi jarurat pdti h wo aap share kijiye pura full vedio banaiye .
Thank you

[@amareesh1515]

TB se excel me Profit and loss and Balance sheet par ek video banaye it is very important yours video very clear and up to marks thanks for giving your valuable time

[@sachinrathi2007]

nice...

[@rakeshkumar-ew5lr]

Very useful for everyone.
Thx sir

[@TallyHomeInstitute]

Always welcome

[@rahuldhiman8776]

Very good explanation sir👌

[@anandkumarjha6599]

Thanks sir🙏

[@jethi8305]

Thank you brother. Further, its not 'Short' but 'sort'.

[@arunkumarsinghark3024]

🌹राधे राधे 🌹ARK 🔥🏹हमेसा हंसते मुस्कुराते रहिये l

[@RajKumar-vx3gf]

Boht kuch sikheya itho,ajj avg logistic ch job milgi

[@babitgarg7811]

very nice sir

[@TallyHomeInstitute]

Thanks and welcome

[@shaileshupreti3234]

Sir agar aap comment padhte ho to yeh lo aap ne excel me subtotal data copy ke karne ke liye jo process kiya hai oh ok hai but bahut long procee hai, aap data ko select kijiye aur
Keyword se - ALT+;
Button ko press kare aur copy paste kare.

[@bhanuverma4738]

Very helpful video👏🏻👏🏻 thank you sir🙏🏻🙏🏻

[@TallyHomeInstitute]

Most welcome

[@sohit7445]

Awesome, video sir...accountancy ke liye excel formula or video share krna. Sir..

[@ABDULHAI-xx6ky]

MANY MANY CONGRATULATIONS
FOR COMPLETE 1 LAKH SUBSCRIBERS.
YOUR VIDEOS ARE VERY USEFUL AND INFORMATIVE.
Keep it up SIR.

[@deenakshisaini7905]

Thanks Sir sharing this video

[@TallyHomeInstitute]

Most welcome

[@praveenpatel1258]

Thanks sir

[@targetatoz6088]

Thankyou sir

[@sathyanarayanansatagopan9069]

Thank you sir. Please explain how to use standard formula for totalling date-wise debit and credit columns and balance in next line, like cash book in tally.

[@aniketmendjogepoetry2409]

Log faltu ke youtube channel ko itna badava dete, jo reels ke nam pe nanga nach karte hai, faltu ke videos dalte hai unke subscriber milion me hote hai, or jaha aap jaise log logonko free me education dene ki koshish karte ho, free me knowldge batne ki koshis karte ho jisse ghar me 2 paise kama sakenge aise chanal ke subcriber unke comparison me kam hote, or bolte hamara desh tarraki nahi kar raha..... Sir aane wale dino me aapke subcriber 5M honge, yahi bhagwan se prathna hai... We love you sir....

[@kuldeeptiwari2360]

Thanks

[@amolpatil7024]

Thanks sir 🎉

[@TallyHomeInstitute]

Welcome

[@accountingskill5537]

Amazing Guruji
Thanks a lot

[@TallyHomeInstitute]

Thanks and welcome

[@suvarnasawadkar2794]

Thank you

[@Anil_verma_official]

Tq jii❤

[@mohitbusa350]

Very useful sir
Thank you sir ❣️❣️❣️

[@TallyHomeInstitute]

Welcome 👍

[@thetrinetraa]

Thanks for uploading this information sir..

[@TallyHomeInstitute]

Welcome

[@vickylal6840]

Nice Sir

[@TallyHomeInstitute]

Thanks and welcome

[@bhagwansahaysharma8036]

Great sir

[@poonamthakur3786]

thanku sir

[@mohdsharukh5280]

Clear explanation Thank u Sir

[@TallyHomeInstitute]

You are welcome

[@ghanshyamchouhan1289]

Sir MIS par bhi video bano

[@SAMKHAN-xq7nt]

Thank u so much sir love u so much sir dil se 😘😘😘

[@proteekdas3990]

Very nice explanation

[@TallyHomeInstitute]

Thanks for liking

[@JaswinderSingh-rb5em]

Thanks 🙏

[@TallyHomeInstitute]

Welcome

[@chulbuliBlog]

Sir ek bar reverse charge ki entri pas wala video banao g

[@suvarnasawadkar2794]

Please explain in video sir regularly

[@SushilKumar-te7pq]

Very very helpful

[@TallyHomeInstitute]

Glad to hear that

[@bijaykumarmishra7689]

Waah sir thank you

[@TallyHomeInstitute]

Most welcome

[@ManojKumar-11826]

Sir Ji Ek Video Lc entry and Stock in Transit per bhi banao

[@adilkhan-vb6nj]

Very nice

[@kravlogs365]

Great sir very useful video..