👉 Year 2024 Calendar
0:37
11 ай бұрын
HOW THE LEN FUNCTION WORKS IN EXCEL
3:26
Пікірлер
@Mummy4nice
@Mummy4nice 6 күн бұрын
Right away...
@AccountingOnExcel
@AccountingOnExcel 6 күн бұрын
You can access the template here 👇 selar.co/budget-performance-manager
@AMITACCOUNTANT
@AMITACCOUNTANT 17 күн бұрын
Sir mujhe ek Google sheet par cash book banana hai 1 sal ke liye jisme auto matetic ledger posting hoti rahe
@fortunenwokosi-vp8md
@fortunenwokosi-vp8md 20 күн бұрын
Great job, please ma, how do i get the complete template
@AccountingOnExcel
@AccountingOnExcel 19 күн бұрын
@@fortunenwokosi-vp8md check the description for link
@KyosuonteySeiAbraham
@KyosuonteySeiAbraham 21 күн бұрын
Please how do non profit making organizations use this template to reconcile their cashbook with bank statement?
@AccountingOnExcel
@AccountingOnExcel 21 күн бұрын
@@KyosuonteySeiAbraham you can definitely use it as a non-profit. Record your cash transactions on the transaction sheet… follow the steps explained in the video and you will be good to go. If you have a specific concern do not hesitate to reach out. Just to state, I plan to launch an automated template for NGOs in a week or less. You can keep tab on my channel to get notified when it is out.
@KyosuonteySeiAbraham
@KyosuonteySeiAbraham 21 күн бұрын
Please is there a away to upload the statements or you must record transaction by transaction
@AccountingOnExcel
@AccountingOnExcel 21 күн бұрын
@ I do not get what you mean here… You enter transaction on a daily basis into your books. At the end of the month or at any month you want to reconcile you either demand for statement from the bank or you download it if your organization has access to internet banking platform. I will advice you download in excel for easy navigation.
@KyosuonteySeiAbraham
@KyosuonteySeiAbraham 21 күн бұрын
Thank you god bless you please it would be helpful if you could make video to throw more lights on the template especially on the Dashboards
@AccountingOnExcel
@AccountingOnExcel 21 күн бұрын
@@KyosuonteySeiAbraham this is noted. I will look to it… Amen to the prayers
@MrDee1107
@MrDee1107 23 күн бұрын
This is really educating. Thank you
@AccountingOnExcel
@AccountingOnExcel 23 күн бұрын
You are welcome Glad you got value 🤗
@BerkatIkhlasMart
@BerkatIkhlasMart Ай бұрын
very easy to understand, could you please describe for account payable and receivable, for example for individual account payable and receivable, how to create the group for individual account
@Home_of_Discoveries
@Home_of_Discoveries Ай бұрын
Out of all the videos I have watched, yours is much easier to understand and learn for beginners
@AccountingOnExcel
@AccountingOnExcel Ай бұрын
Thank you for the feedback. Glad you got value.
@FatimaAmtul-n2o
@FatimaAmtul-n2o Ай бұрын
Thank you ,After watching tons of tutorials finally you save me.
@AccountingOnExcel
@AccountingOnExcel Ай бұрын
@@FatimaAmtul-n2o you are welcome. Glad you got value.
@fortunenwokosi-vp8md
@fortunenwokosi-vp8md Ай бұрын
Very impactful,thank u. Old how can dis be applicable in a hotel as a hotel accountant
@AccountingOnExcel
@AccountingOnExcel Ай бұрын
Glad you got value. You can use this as a foundation for setting up your hotel's accounts.
@shabushabu1727
@shabushabu1727 Ай бұрын
Hai maam I had mailed you please can you kindly go through the mail please.
@AccountingOnExcel
@AccountingOnExcel Ай бұрын
I am yet to see you mail… Hope I did not miss out on it. Please can you send again via [email protected]
@taoreedolalekan2520
@taoreedolalekan2520 Ай бұрын
This is well explained. good job. well done ma
@AccountingOnExcel
@AccountingOnExcel Ай бұрын
Glad you got value. Thank you for the feedback.
@belovedharvin1460
@belovedharvin1460 Ай бұрын
worst accent i have ever heard
@aicx40
@aicx40 Ай бұрын
Thanks to sharing.
@ikennachuksezebube380
@ikennachuksezebube380 2 ай бұрын
Kudos for the good work
@AccountingOnExcel
@AccountingOnExcel 2 ай бұрын
Thank you !
@AccountingOnExcel
@AccountingOnExcel 2 ай бұрын
Use the link provides to watch the full video… Feel free to share Like and comment also 🤗😊
@kimptonndimande1760
@kimptonndimande1760 2 ай бұрын
Kindly show how we do jounal entries when we have sub-accounts and how to generate all the statements.
@kimptonndimande1760
@kimptonndimande1760 2 ай бұрын
This is very helpful, but suppose I have sub-accounts. How do I then do my journal entries
@AccountingOnExcel
@AccountingOnExcel 2 ай бұрын
If you have main accounts and sub accounts, you have to include that in your charts of accounts and create a column for that. Thank you for the feedback
@alabaawolaja
@alabaawolaja 2 ай бұрын
Thank you so much. I cannot appreciate this insightful session. I am your fan.
@AccountingOnExcel
@AccountingOnExcel 2 ай бұрын
You are welcome. Glad you got value. Thank you for the feedback
@softsntechs
@softsntechs 2 ай бұрын
Just lovely ❤
@AccountingOnExcel
@AccountingOnExcel 2 ай бұрын
Glad you got value. Thank you for the feedback
@oresotufunmilayo
@oresotufunmilayo 2 ай бұрын
This is only usable for a well knowledgeable excel user you mention locking cells, making absolute without explaining how to do that. I believe you could have simplify more better.
@AccountingOnExcel
@AccountingOnExcel 2 ай бұрын
I have specific videos on that… you can check out my channel. Thank you for engaging.
@nikthepupperkiller410
@nikthepupperkiller410 2 ай бұрын
i think this is the best way to learn accounting by building templates and explaining the rolls of the sheet and account. Thanks i learned so much by watching this..
@danielkariuki-q3w
@danielkariuki-q3w 2 ай бұрын
I am Dr. Karani from Nairobi, Kenya. This is wow. You have solved a big problem just simply. I now have additional clarity on simplifying accounting work. Thank you and continue.
@chukudiNwachuku
@chukudiNwachuku 3 ай бұрын
Thank you for the lecture, ma. However, why did you use the Charts of Account to prepare your trial balance instead of the Journal Entries sheet? Can't we have our trial balance on the Journal Entry sheet instead?
@AccountingOnExcel
@AccountingOnExcel 3 ай бұрын
Glad you got value… Looking at the journal entry sheet, you will notice there is a control that ensures every transaction entry balances off. In regards to your question, the trial balance can also be generated from the journal entries. This we did using the chart of account which makes up our general ledger. You can also generate on a different sheet if you so wish. It is not cast on stone. Thank you for engaging.
@chukudiNwachuku
@chukudiNwachuku 3 ай бұрын
@@AccountingOnExcel Thank you so much
@tramainelouis
@tramainelouis 3 ай бұрын
I wanted to take a moment to thank you for the amazing beginner Excel videos you’ve created. Your tutorials have been a true lifesaver as I’m re-learning Excel for my accounting studies. I watched the entire playlist in just a few days, and each video was clear, easy to follow, and helped me build a strong foundation while learning many new things. I truly appreciate the time and effort you put into making them.😊
@AccountingOnExcel
@AccountingOnExcel 3 ай бұрын
You are welcome. I am so glad you are getting value going through the beginner's course. Keep at it and see how you will gain enough confidence working with Excel. Congratulations in advance. Your feedback is highly appreciated.
@tramainelouis
@tramainelouis 3 ай бұрын
@@AccountingOnExcel What Excel topics would you suggest that I learn next, now that i have graduated from a beginner.
@tramainelouis
@tramainelouis 3 ай бұрын
perfect!
@tramainelouis
@tramainelouis 3 ай бұрын
Amazing! Thank you! I had no idea this feature existed in excel.
@freddykashimba1521
@freddykashimba1521 3 ай бұрын
Very educative indeed.....keep it up !
@tramainelouis
@tramainelouis 3 ай бұрын
Excellent explanation! Thank you!
@tramainelouis
@tramainelouis 3 ай бұрын
Excellent explanation! Thank you!
@tramainelouis
@tramainelouis 3 ай бұрын
Excellent explanation! Thank you!
@tramainelouis
@tramainelouis 3 ай бұрын
Excellent explanation! Thank you!
@tramainelouis
@tramainelouis 3 ай бұрын
This lesson was very insightful. Thank you!
@tramainelouis
@tramainelouis 3 ай бұрын
I thought i new a lot about copy and paste but i learnt a lot of new tips from this lesson. Thank you!
@tramainelouis
@tramainelouis 3 ай бұрын
Very well explained. Thank you!
@tramainelouis
@tramainelouis 3 ай бұрын
Very well explained. Thank you!
@tramainelouis
@tramainelouis 3 ай бұрын
Very well explained. Thank you!
@tramainelouis
@tramainelouis 3 ай бұрын
Very well explained. Thank you!
@AccountingOnExcel
@AccountingOnExcel 3 ай бұрын
@@tramainelouis you are welcome Glad you got value.
@tramainelouis
@tramainelouis 3 ай бұрын
Very well explained. Thank you!
@tramainelouis
@tramainelouis 3 ай бұрын
Excellent explanation! Thank you!
@tramainelouis
@tramainelouis 3 ай бұрын
Excellent explanation! Thank you!
@tramainelouis
@tramainelouis 3 ай бұрын
Excellent explanation! Thank you!
@tramainelouis
@tramainelouis 3 ай бұрын
Excellent explanation! Thank you!
@tramainelouis
@tramainelouis 3 ай бұрын
Excellent explanation! Thank you!
@AccountingOnExcel
@AccountingOnExcel 3 ай бұрын
You are welcome. Glad you got value. Thank you for engaging
@tramainelouis
@tramainelouis 3 ай бұрын
Excellent explanation! Thank you!
@tramainelouis
@tramainelouis 3 ай бұрын
Excellent explanation! Thank you!
@tramainelouis
@tramainelouis 3 ай бұрын
Thank you! This was very helpful.
@AccountingOnExcel
@AccountingOnExcel Ай бұрын
Glad you got value! Thank you for the feedback
@JenniferTenney-x3r
@JenniferTenney-x3r 3 ай бұрын
THANK YOU! This was a life saver!
@AccountingOnExcel
@AccountingOnExcel 3 ай бұрын
You are welcome. Glad you got value.
@debbyjoseph6222
@debbyjoseph6222 3 ай бұрын
Thank you so much. You the best Ma'am
@AccountingOnExcel
@AccountingOnExcel 3 ай бұрын
Glad you got value. Thank you for the feedback.