How to automate Accounting Bookkeeping , Ledger and Trial Balance in Microsoft Excel | Hindi Urdu
Вставка
- Опубліковано 18 вер 2024
- In this video you will learn how to create and automate accounting ledger and general journal in Microsoft Excel and maintain accounts in more advance way.
You will also learn the advance feature of Table and Pivot Table, slicer and much more.
After watching this video you will be able to do following:
How to create accounting General Journal in Excel?
How to do bookkeeping in Microsoft Excel?
How to create Trail Balance in MS Excel
How to create Table in Excel?
How to create accounting party, customer, client or any kind of ledger in excel?
How to create trail balance in excel?
How to use Pivot Slicer in excel?
How to use advance formatting in excel?
This Video is essential to watch for every person including students, officers and business person.
To get this file. Please subscribe to this channel
For More Videos: www.youtube.co...
To get this file with Ledger, Trial Balance, Income Statement, Balance Sheet and Cash Flow:
Download File: www.downloadex...
visit: www.exceldoers...
Facebook page / exceldoers
For Queries & Business: exceldoers@gmail.com
#Ledger #Bookkeeping #TrailBalance #GeneralJournal #MSExcel #Excel #TrailBalance #Student #Job #Officer #Business #Hisab #Hindi #Urdu #MicrosoftExcel #PivotTable #Slicer #PivotSlicer #Table #Automate #Create #Ledgeraccounts
Wait is over those, who was looking for Trial Balance, Income Statement and Balance sheet in Excel. Finally video has been uploaded. Checkout below link:
ua-cam.com/video/pgBsyTKAwLw/v-deo.html
I had deadline to do it so tried chat gpt and worked as suggested but after spending 3 hours i gave up as didnt feel confidence and started searching on you tube and bingo i saw your video in recommendation.
Its awesome you made it very simple.
Thank you😊
Thats great. Now its ur duty to share on your profile so other can benefit too :)
Wonderful! I am 51 years old and having experience in computer 32 years. Surely, you have made it in very easy and simple way.
ua-cam.com/video/2L95R2Ngw0I/v-deo.html
#GL #GeneralLedger #exceltutoring #excelonline #excelvba #excelword #excelrankformula #excel formula hacks #excel interview questions #excel attendance sheet #educ
Brother,I am very much grateful to you for your splendid presentation on such a crucial topic regarding ledger accounts.
Thank u brother
Great! Explained in a very simple and understandable way !!
Thank you so much brother. You made my life super simple. The most effective, practical, simple, and to the point video ever seen on this topic. May Allah Bless you with success and uncountable blessings
Ameen.
kia baat hai bro ! so simple , point to point behtreen . mushkil topic lekin gool gappy ki trah mazeedar bana kar samjhany pr dil ki gehrai se shukar guzar. love from pakistan.
Thanks Brother
اردو میں آسان ویڈیو پر زبردست تعریف
It is very helpful for me, please make a trial balance and balance sheet.
Jazakallahu kheyr.
Aapka ye video mere liye intehai mufid raha.
Allah aako khush rakhe.
Thanks owasi menon sir, ये इतना फायदेमंद विडियो है । कमाल का आइडिया दिया है। मेरा काम बहुत आसान हो गया। ये तो tally software जैसा हो गया आपका बहुत शुक्रिया
Very informative Sir thank you so much ❤
super madam I'm ur student joined class very useful this course
Thank u
Sir -Great education
Helpful & Very Comprehensive. Have been looking for many month for this. But, Please make clear that grow to make a subsidiary ledger in this sheet and kindly make a Trial Balance and Profit and Loss Statement.
A Complete Account Format
Thank u for feedback
+1 please. Thank you
Very useful video. I think before formating to the table, format each cell then convert to table. For inserting additional row, you can press tab at the last column of the to table, just above the sum row. Though the video is excellent
Great Video Really Apreciate your efford. God Bless you
Ameen
Hats off to your teaching skills, lots and lots of love from india.
Useful video Excel accounting Bro 😊
This video is a great help! I learned a lot!
Very knowledgeable. Thumbs up
Thank you so much! This was massive help!!
Hello sir,
I respect you so much ❤💯
This is awesome for transactions management and also request you to make more best videos like this and also provide all information ...
*_Sure. Stay in touch.. Thank u so much_*
@@EXCELDOERS why not!! I am always with you ❤💕♥
@@EXCELDOERS hello there, my dr and cr column is showing blank..
Bohat bohat pasand aahe excellent skills
Jazakallah
Keep Uploading Videos Like This About Accounting
Thanks for this...its very helpful and more informational for everyone.....I would be very glad if you make Trial Balance & Balance Sheet along with Journal & Ledger.
Thanks again
Yes, please make TB and Balance Sheet video as well. Thank you
Check this out. ua-cam.com/video/tQG5vWMF_Wc/v-deo.html
Thanks for splendid information, keep posting video like this.
Thank you sir, for sharing good stuff and Lectures.
Really outstanding job brother Keep it up ALLAH BLESS YOU COUNTLESS
AMEEN. THANKS
@@EXCELDOERS do you have a video on how to calculate profit & loss using this system?
behtareen! no need of purchasing accounting software it made my work so easy better than any accounting package. Thanks alot.
Love u
Nice and easy. Please upload a video of complete video of financial statements .... Thanks
Teach krny ka انداز لاجواب ❤
Thanks
Sir debit and credit ka sum nai aa raha Mery pass. Bata den
Sir kon sa version used ho raha hy vedio MN
Thanks 👍 dear 😊 i liked it very much and you helped me
Good One....If there is an category column it will be much helpful to find expense on specific category
Excellent explanation and easiest way to follow. Jazakallah Khair for making life easy of many. 🎉
Jazakallah and Sukriya.
@@EXCELDOERS Are u porki or Indian
Thanks 💐🌸 alot bhai 🙏 😊 you're so kind May Allah bless you all the happiness and rewards you 🙏
Jazakallah. Ameen. Remember in your prayers. May Allah help us all.
@@EXCELDOERS ameen sum ameen 🙏
A lot of thanks to give some amazing information sir.....
great i learn lot from this
Glad to hear that
Very well explained, with a lot of clarity on mechanics of ledger & pivot report, Thanks
_Many Thanks_
@EXCELDOERS AoA bro i am having some problem with your automation video when i made Ledger out of general journal it shows credit line items first then shows debit line items (there is no problem within Date Column) it is just (Entry structure) presentation problem that i am having can you help me out? i want to show debit line item first and then credit line second of every general entry in Ledger.
Zabardast please make more videos on accounting in excel
Sure I will
Behtreeen maza aya dekhny m thankyou
Simply i love your teaching style...👍👍👍
Hello Sir,
I respect you so much and also request you to make Trial Balance,Final Account etc... please
thank you sir, good presentation .
You are most welcome
Kudos to you to share this info to all.
Thank you so much for your video. Could you create income statement and balance sheet by linking this.
Behtareen kafi help mili, ik help apkey ley table pr jahan total aya tha wahan us sey uppar ja kar tab dabyen gey to continue table bhar jaye ga
Nice videos and I really appreciated ..Satisfactory
hank you so much brother. excellent vvvv simple way
what an excellent video. Very well done
Thanks Owais Memon Bhai. You have made my life lot more easier. Learnt a lot today. God Bless. 😊
Thank you sir. It helps me alot 👌
Great, this is quite helpful. Thank you so much
Good to see someone from my city, Karachi helping us learn excel and as a simple and useful illustration :)
GREAT JOB BRO.
Thank you for amazing video and very helpful
Thank you brother the nice stuff pivot table be very effective.
Well-done
Well-done, i apprecite your sheets, plz make clear that gow to make a subsidiary ledger in this sheet and kindly make a trial balance and profit and loss statement as well. Thanks
V.nice video brother Salamat rahen
Amazing course.
You've made my life so much easy.
You are a genius. Thanks friend
Great informative video Dear, it solves my problems, Thanks Again
soft too your lecture
Best video for making Ledgers a/c
Thank you so much sir....Very helpful ..🙏🙏
Amazingly simple and effective video. Thanks
Very informative 👍
Its really helpful
I want learn more Sir
visit my channel for more useful videos in urdu/hindi
Excellent thanks 🙏🏽
Thanks sir for so much useful knowledge.
Thank youu, this is very helping me A LOT
Helpful information 👍
Good
I am from Gujarat, India
Much appreciated for the tutorial video, keep going.
Very beautiful tutorial, ❤️
amazing smart work
Absolutely great explanation! Even though do not speak/understand your language, was able to do this just by watching. Clear and well. The only problem I seem to have is with the date! Somehow it does not organize in my ledger as I want, by oldest first etc etc. Can you help with this? Looking forward to more of this kind of video's.
email me ur file at exceldoers@gmail.com
You are great man sir❣
Can you make a video please, how to maintain the accounting of ( Excel) a taxi vehicle business. Vehicle purchase, daily collection, diesel, bata, repair and maintenance, tax and insurance,loan etc. Thank you
Thanks a lot. Please explain date wise debit and credit total in two columns and balance in next line, just like in tally cash book.
Dear It is an interesting and informative video and really helped me to make General Journal, Ledger etc. But I also want to create profit and loss statement by using these entries. So can you help and make video on this.
Too good sir 🙂
very very nice wheat a great video... superb work great you are amazing brother.... keep it up... love you bro
Thanks for your help
It is very good!
Amazing 👍🤞🤟
Very Helpful Video. Please Share any Complete Format of GL
Will soon
Super bro
Thank you so much brother
This is amazing brother
Dear video dekha achha laga pls practice file in distribution thank you sir
good zaberdast Mashallah
Wonderful way to explain
Very informative thank you
Nice explain..
Amazing
🥰🥰🥰🥰🥰🥰🥰🥰
Main to apka fan ho gaya
Love u.
Great 👍
Love you sir great explained
excellent bro❤
Thankyou brother very easy to understand. ❤️
Amazing, you are ... if you can create english and your language for us to understand much better
English version is available on our channel.. please visit