USE OF VLOOKUP FORMULA & SUBTOTAL FORMULA IN EXCEL | EXCEL FOR ACCOUNTANT IN HINDI
Вставка
- Опубліковано 22 сер 2024
- 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- tallyhomeagra@gmail.com
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.
Thank you sir,aap jaise talented teacher kistmat se milte hai -aap niswarth bhav se padhate hai .I respect you sir
सर 🙏
आप लाजवाब हो।🤘
आप की वीडियो देख देख कर मेरा भी बहुत हौसला बड़ा है।🤘
शुक्रिया सर🙏🙏
4 saal se jo samajh nahi aya wo chis apne samajha di sir thank u
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...
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.
Can u please share that link..I am unable to find that video..?🙏
आपकी बात बिल्कुल सही है बहुत बहुत लंबी कर देते हो यार
Pahale bar sardar ji ki account per video dekha hai Dil Khush ho gaya 👍👍
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. 🙏🙏🙏🙏
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.
thanks sir mene aajtk itni aasani se valuble information ki se nhi suni nadekhi thanks sir
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
Important concept for all accountants.
Thanks sir 🙏
Thank you sir for Subtotal Copy paste problem solved kr diye.
Sir aap bahut achha samjhae ho
Bahut hi powerful video hh sir thanks
Sir...aapne bht help kiya...bht achchi tarah samajh me aa gaya
बहुत ही शानदर प्रेजेंटेशन सर जी😍
Kya simpal tarike se btaya mazaaa aa gaya aisha laga jese mera practical work pressar Aadha ho gaya
आपका बहुत-बहुत धन्यवाद 🙏
आपने एकाउंटिंग की हर बारीकियों और कमियों को पूरा किया
Superb fantastic sir 👍
JABARDAST VIDIO BANAYA AAPNE.THANKU SIR
Nice sir ji bhagwan aapko lambi umar de
सर vLookup से Trial Balance मैच और GSTR - 2 A with परचेज रजिस्टर Reconciliation पर वीडियो बनाए 🙏🙏🙏
noted
@@TallyHomeInstitute thanks Sir 🙏🙏
ß
Ic/
@@jssingh3505 तो
Bhut bdia sir ji..mza aagyaaa dekh kr once again..😁😁😁
Nice explained both formula with practical examples.
Thanks for your explanation sir ji.🙏🙏👍👍
Thanks for liking
Thank you sir muje vlookup ka formula nahi ata tha par apaki video dekha ke a gaya sir thank you so much sir
Gurudev ap ne meri sari problem solv kar diya thanks guruji
Important Video
Thank you sir,
Aapka Dil Se Dhanywad.
Sir aapka har video important hai
Just love your originality in your videos sir.....
Sir Course ka teesra batch jaldi shuru kar den please .
Great video sirr
Thankyou sir for sharing valuable information.
Very Nice aaj Se pahle kabhi samjh nahi aaya tha
Awesome video sir ji
Thanks and welcome
very nice video about excel formula used
Glad you liked it!
Thanku Sir ji
Sir aap bahut helpful hai.
Great thanks to you
Every videos is very important
Salute sir
बहुत बहुत शुक्रिया सर जी धन्यवाद् 🙏🙏🙏
Thank u so much for your easy and understandable ways of describing.
You are most welcome
Sir , your video is always helpful us because you explain everything in detail.
Glad to hear that
Sir aap bahut achha se samjhate ho
Genuinely knowledge 💯 👌 👏
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 🙏🙏
Very nice and knowledgeable video sir...thanks a lot
Most welcome
Sir u r great
great video sir
Thanks
Badiya video sir ji
Very nice vedio
Thank you so much 😀
Sir aapki sabhi video bhot useful hoti h...Aapke jaisa youtuber nhi h koi❤️😎
Bohut Bdiya Explain Krte ho 😊
bahut bahut dhanyawaad sir ji.❤️
Sir it is very helpful. Thanks for the video.
Most welcome
Thanks sir I love you.
Good
Very very thanks sir
Most welcome
Sir vahe guru ji... Ab hme bank reculation ke video banavo
Sir Accountant k liye excel me jo bhi jarurat pdti h wo aap share kijiye pura full vedio banaiye .
Thank you
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
nice...
Very useful for everyone.
Thx sir
Always welcome
Very good explanation sir👌
Thanks sir🙏
Thank you brother. Further, its not 'Short' but 'sort'.
🌹राधे राधे 🌹ARK 🔥🏹हमेसा हंसते मुस्कुराते रहिये l
Boht kuch sikheya itho,ajj avg logistic ch job milgi
very nice sir
Thanks and welcome
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.
Very helpful video👏🏻👏🏻 thank you sir🙏🏻🙏🏻
Most welcome
Awesome, video sir...accountancy ke liye excel formula or video share krna. Sir..
MANY MANY CONGRATULATIONS
FOR COMPLETE 1 LAKH SUBSCRIBERS.
YOUR VIDEOS ARE VERY USEFUL AND INFORMATIVE.
Keep it up SIR.
Thanks Sir sharing this video
Most welcome
Thanks sir
Thankyou sir
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.
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....
Thanks
Thanks sir 🎉
Welcome
Amazing Guruji
Thanks a lot
Thanks and welcome
Thank you
Tq jii❤
Very useful sir
Thank you sir ❣️❣️❣️
Welcome 👍
Thanks for uploading this information sir..
Welcome
Nice Sir
Thanks and welcome
Great sir
thanku sir
Clear explanation Thank u Sir
You are welcome
Sir MIS par bhi video bano
Thank u so much sir love u so much sir dil se 😘😘😘
Very nice explanation
Thanks for liking
Thanks 🙏
Welcome
Sir ek bar reverse charge ki entri pas wala video banao g
Please explain in video sir regularly
Very very helpful
Glad to hear that
Waah sir thank you
Most welcome
Sir Ji Ek Video Lc entry and Stock in Transit per bhi banao
Very nice
Great sir very useful video..