Тёмный
No video :(

how to make debit and credit sheet in excel 

Shahab Islam
Подписаться 214 тыс.
Просмотров 616 тыс.
50% 1

if formula for debit and credit in excel. how to separate debit and credit in excel.
_/LINKS\
► Facebook:➜ / shahabislam123
► Twitter:➜ / shahabislam123
► Instagram:➜ / shahabislam6
► Website:➜ advanceexcelonline.blogspot.com/
================================================
#deibtcredit #ledger #Excel
How To Make Salary Sheet in MS Excel # 43
• How To Make Salary She...
Microsoft Word - Create Form (Office 2019)
• Microsoft Word - Creat...
How to Calculate gross Profit From Income Statement
• how to calculate gross...
Inventory Management excel formulas
• inventory management e...
How To Make Sale Report in Excel # 26
• HOW TO MAKE SALES REPO...
how to maintain store inventory in excel
• how to maintain store ...
#159 How To Make Food Cost Profit Sheet in Excel Hindi
• #159 How To Make Food ...
advance Excel Training For Job | Data Entry | functions for data analysis
• advance Excel Training...
hide excel sheet with password
• hide excel sheet with ...
#107 How To Make a Stock Management in MS Excel
• #107 How To Make a Sto...
How To Make Experience Certificate and Latter on MS word Hindi
• How To Make Experience...
How To Make Automatic student fee Collection and status system in Excel
• How To Make Automatic ...
How To Make General Ledger Trial Balance Sheet in Excel
• How To Make General Le...
#219 How To Make Daily Production Report in Excel Hindi
• #219 How To Make Daily...
How To Make Salary Pay Slip In MS Excel # 37
• How To Make Salary Pay...
how to Maintain petrol pump accounts in excel Hindi
• how to maintain petrol...
How To Make ID Card Design In Ms Word Urdu Tutorial
• How To Make ID Card De...
#283 How To Make Stock Sale/purchase or Profit and Loss Sheet in Excel Hindi
• #283 How To Make Stock...
How To Make Resume / CV with Microsoft Word
• How To Make Resume / C...
How To Make Daily Production Report For Garment industry on Excel Hindi
• How To Make Daily Prod...
how to Create Notifications or Reminders Automatically in Excel
• how to Create Notifica...
#132 How To Make Monthly Interest amount Calculate Sheet in Excel Hindi
• #132 How To Make Month...
Click to see all our videos||
/ @shahabislam4912
subcribe to our Channel ||
/ @shahabislam4912
How To Make Bill / cash Book On MS word Hindi
• How To Make Bill / cas...
How To Make Sale Price Sheet IN MS Excel Tutorial In Hindi # 51
• How To Make Sale Price...
#88 How To Make Debit Credit sheet in Excel Hindi
• #88 How To Make Debit ...
#91 How To Make Balance Sheet in Excel Hindi
• #91 How To Make Balanc...
how to calculate retirement date in Excel
• how to calculate retir...
Top 50 Excel Shortcut in Hindi
• Top 50 Excel Shortcut ...
#269 How TO Maintain Cash Book ans Petty Cash Record in Excel 2019 Hindi
• #269 How TO Maintain C...
MS Excel Complete Course Hindi ||
• #231 How To Make Reven...
File Download Link Click Link goto Website
advanceexcelonline.blogspot.c...

Опубликовано:

 

11 авг 2020

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 186   
@CyberLinkComputers
@CyberLinkComputers Год назад
Superb Sir . . . . Thank you so much Allah Apko Hamesha Abaad Rakhay Ameen ♥
@Sahibzaada
@Sahibzaada 3 года назад
I love ur voice so much....u r real gem....
@raj28san
@raj28san 3 года назад
Hi Sir, you are simply fantastic. super explanation of debit credit. I watch your video most of the time and it is very very interesting and knowledgable. Thank you Sir God Bless you. As I practice my daughter really like it.
@shahabislam4912
@shahabislam4912 3 года назад
All the best
@unknownPerson-yr9gh
@unknownPerson-yr9gh Год назад
Jazakallah brother this was perfect and just what I was looking. The formulas are simple and clearly explained, and in Urdu loved it. May Allah swt bless you and your family and fill your life with barakat and His mercy. You my brother have a subscriber... great job
@sanjaikv2851
@sanjaikv2851 Год назад
IT WAS REALLY GREAT. THANK YOU FOR THE EFFORTS YOU PUT INTO CREATING THIS VIDEO
@shahabislam4912
@shahabislam4912 Год назад
Glad you liked it!
@shaguftasalamofficial9435
@shaguftasalamofficial9435 4 года назад
Well done Sir.
@vedangoza8756
@vedangoza8756 2 года назад
Thanks for information I have e totally kharch in office I have saved in my devise Thanks a lot🙏
@md.atiarrahman9748
@md.atiarrahman9748 Год назад
very Good. Thaks
@atulshukal4072
@atulshukal4072 4 года назад
Very very good Sir Thenks
@poornamainkar1642
@poornamainkar1642 2 года назад
Arre wah! kitna simple. Thank you bro. 🙏
@shahabislam4912
@shahabislam4912 2 года назад
Most welcome 😊
@tauhidmohammadansari2738
@tauhidmohammadansari2738 4 года назад
W.salam sir.; Super info
@TDGaming147
@TDGaming147 3 года назад
thank you so much bahut help hui
@MohiHash
@MohiHash 2 года назад
Thanks. Very helpful tutorial. I used it for my google sheet for kids pocket money and monthly expenses and it worked great. Only issue I can't leave a cell blank and have to put zero if nothing else otherwise the formula breaks and starts again. But that's no big deal as there are just a few entries every month and I can easily add zeros manually to empty debit or credit fields.
@jawwadali4767
@jawwadali4767 Год назад
it's very helpful video sir
@shahabislam4912
@shahabislam4912 Год назад
Keep watching
@tinuolaogunlade5649
@tinuolaogunlade5649 3 года назад
Good Afternoon wonderful tutor, I appreciate all Indian tutors on youtube, they have helped me so far but please try to teach more in English. I can't understand your language but I need this lesson.
@awaisg1228
@awaisg1228 3 года назад
Good one
@shreesuryawanshi9386
@shreesuryawanshi9386 Год назад
Bhai thank you 🤗
@sharifmuhammad4787
@sharifmuhammad4787 2 года назад
Very helpful tutorial. I want to get this software.
@mrCetus
@mrCetus 2 года назад
Made-in-Pakistan is one of the leading platforms for wholesale trade globally. We want to serve every buyer and supplier around every corner of the world.
@NOOR-islaam4all
@NOOR-islaam4all Год назад
Excellent!
@muhammadshakeel4482
@muhammadshakeel4482 4 года назад
Excellent
@rheajobin06
@rheajobin06 2 года назад
Thank you sir!!
@rockxxin1
@rockxxin1 2 года назад
Great sir
@HASNAINALI-ql3yl
@HASNAINALI-ql3yl 2 года назад
so nice of you
@ahmedabdulaleem5304
@ahmedabdulaleem5304 6 месяцев назад
Jazakumullahu khairan
@kushalmukhoti
@kushalmukhoti Год назад
Excellent tutorial.
@shahabislam4912
@shahabislam4912 Год назад
Many thanks!
@mohaammadripon
@mohaammadripon Год назад
LOVE FROM bANGLADESH🤩🤩🤩🤩🤩🤩🤩
@MetroIndustries
@MetroIndustries 2 года назад
Very helpful , Thanks
@shahabislam4912
@shahabislam4912 2 года назад
You're welcome!
@aqibshah802
@aqibshah802 2 года назад
THANKS DEAR IT WAS VERY USE FULL
@shahabislam4912
@shahabislam4912 2 года назад
Welcome 😊
@srishunil3414
@srishunil3414 2 года назад
Brilliant bro.. Thank you so much...
@shahabislam4912
@shahabislam4912 2 года назад
Most welcome 😊
@ar-ramzafamily2517
@ar-ramzafamily2517 2 года назад
THANKS ALOT SIR. GOOD TUTORIAL
@shahabislam4912
@shahabislam4912 2 года назад
You are most welcome
@brighttipstricks
@brighttipstricks 2 года назад
Wonderful
@MuhammadUsama-cd6rq
@MuhammadUsama-cd6rq 3 года назад
Thnk you sir 💖;:
@sabirjan2973
@sabirjan2973 3 года назад
Your r doing very professionally but its lil bit complicated
@prabegtwati9766
@prabegtwati9766 Год назад
Thank you man great job ❤
@shahabislam4912
@shahabislam4912 Год назад
Thank you too
@muhammadshakeel4482
@muhammadshakeel4482 4 года назад
Marvelllous
@nirdeshyadavheera8182
@nirdeshyadavheera8182 2 года назад
Thanks very helpful So divide by month with interest
@Yt-Shorts255
@Yt-Shorts255 Год назад
Thank u so much sir
@esrar7799
@esrar7799 2 года назад
Thanks for this video😎
@shahabislam4912
@shahabislam4912 2 года назад
Welcome 😊
@razwang.7844
@razwang.7844 Год назад
TQ SIRR. REALLY HELPS ME A LOT.
@shahabislam4912
@shahabislam4912 Год назад
You are most welcome
@kushalmukhoti
@kushalmukhoti Год назад
Many many thanks for your prompt reply. Please tell me what the formula will be if I connect the 'credit' (E5) instead of the 'description' (C4) and get serial numbers as and when only a credit entry is entered? I want to know how many EMIs I have paid by seeing only the last serial number against the last credit entry.
@kingnrtechnical555
@kingnrtechnical555 2 года назад
Thankyou bhai
@i2xbf
@i2xbf 3 года назад
I would like to add debit automatically to debit column even if it's entered in credit column if the description is " amount debited" , how can I do that ? Pls help
@evelynneri7294
@evelynneri7294 Год назад
Thank you for giving me an idea.
@shahabislam4912
@shahabislam4912 Год назад
Most welcome 😊
@faqjammwal5851
@faqjammwal5851 2 года назад
Very supper way of explanation. Masha Allah. May I request you to please explain the excel functions and formulas using in Finance Organization.
@shahabislam4912
@shahabislam4912 2 года назад
ru-vid.com/show-UCcOsbNCxgUZMPoHEI1w-1RAsearch?query=finance
@arnavwell
@arnavwell 2 года назад
Thnaks
@sathiharipur9343
@sathiharipur9343 3 года назад
Super
@user-pd1pi5yp4h
@user-pd1pi5yp4h 11 месяцев назад
Thanks
@globalfinancelimited741
@globalfinancelimited741 Год назад
Hello Sir good tutorial but I am confused!!! In accounting EXPENSE ACCOUNT IS DEBIT BALANCE RIGHT?? Your example is CREDIT. Why???
@SurjeetSingh-vs9so
@SurjeetSingh-vs9so Год назад
good video sir
@shahabislam4912
@shahabislam4912 Год назад
Thanks
@musthakmohamed7942
@musthakmohamed7942 Год назад
Thank you!
@shahabislam4912
@shahabislam4912 Год назад
You're welcome!
@globalfinancelimited741
@globalfinancelimited741 2 месяца назад
Fantastic tutorial. Where can i download this excel sheet. Cant find it
@musabbehsmkt8253
@musabbehsmkt8253 2 года назад
THANKS
@AkhterKhan-d5t
@AkhterKhan-d5t 19 дней назад
Your Greet
@triggeredmishti5498
@triggeredmishti5498 2 года назад
Very nice explanation of this formulas but only one mistake debit side minus Hoga & credit side plus hoga
@shivanishivani6221
@shivanishivani6221 2 года назад
Sir. Account se related bi video upload kr do jese tally erp 9 and Busy accountancy etc
@pankajgoikar1706
@pankajgoikar1706 3 года назад
THANKS BRO
@shahabislam4912
@shahabislam4912 3 года назад
Welcome
@ahshankhan439
@ahshankhan439 4 года назад
Good morning # value aata hai time in or time out ko jab select mana jise ki =(D5-E5)+(G5-F5) formula
@fasttraders5625
@fasttraders5625 10 месяцев назад
Nice
@blanctanerlau3800
@blanctanerlau3800 3 года назад
Goodnight can someone help please when I write count I can't choose countA cause the crochet not turns red and it tell me to counts the number of cells that are not empty. What should I do please please please.
@sainitishpasupuleti
@sainitishpasupuleti 3 года назад
thanks but please tell me what if there in no debit and credit entry in specific date then this formula not working.pls help.
@subratasinha7420
@subratasinha7420 2 года назад
Wrong formula debit aur credit ka matlab ulta kar diye he apne
@SOLO_Rythm.Studio
@SOLO_Rythm.Studio 3 года назад
This video is fully helpful for me thank you 🙏
@shahabislam4912
@shahabislam4912 3 года назад
You're welcome 😊
@sanjayrocky7685
@sanjayrocky7685 4 месяца назад
Tq
@erdene-ochirmijid4040
@erdene-ochirmijid4040 2 года назад
Explain why if and function are used here when only sum formulas can be used?
@khaksarali1990
@khaksarali1990 Год назад
Good job Sir, but SoooO Confusion and difficult proccedur ledger
@justinedeleon620
@justinedeleon620 2 года назад
Capital Increase in the balance is 2500 ? How come sr?
@bijaytanty8434
@bijaytanty8434 8 месяцев назад
👍👍
@pa2happiness13
@pa2happiness13 Год назад
Sir ye tho simple hai, surf +, - ho Raha hai interest iss Mai add hoga 😇
@maryamali7107
@maryamali7107 Год назад
Assalam o Alaikum sir..ye Jo ap short cut keys use krte Hain inko bhi mention Kiya kren
@Sha-Sha.
@Sha-Sha. Год назад
Sir debit ko minus and credit ko add nahi krna tha?
@aparadisebird
@aparadisebird 9 месяцев назад
thats what im talking about, but
@muhammadkaleem3957
@muhammadkaleem3957 3 года назад
Please add thees formulas in description so that we can copy and past
@gulfammithani3658
@gulfammithani3658 3 года назад
Masha Allah. Sir agar opening balance minus (-) me ho ky Kya karen sir plz reply
@prabeenpro7908
@prabeenpro7908 3 года назад
Same doubt mera v
@ranaasif1422
@ranaasif1422 3 года назад
AoA. Sir ap ny F3 me cash balance likh k zhort key use ki jis sy cell bara ho gya and jb C4 me last year's balance likha os k bad phir apny wohi short key use ki. Kindly wo short key bta dy
@Usamavlogs12
@Usamavlogs12 2 года назад
Very nice video
@shahabislam4912
@shahabislam4912 2 года назад
Thanks
@Usamavlogs12
@Usamavlogs12 2 года назад
@@shahabislam4912 no thanks you really deserve like and subscribe I also want to get some more lacture so I subscribe and click on bell icon for more videos
@Usamavlogs12
@Usamavlogs12 2 года назад
@@shahabislam4912 and i also see more videos in your channel about Excell and Word
@pakistanpunjab4295
@pakistanpunjab4295 9 месяцев назад
@dineshkumar-xe1sw
@dineshkumar-xe1sw 3 года назад
Sir, it's too much good but I've a question, when I put my credit balance it is shows in subtract sign in cash balance
@rajahamed7021
@rajahamed7021 3 года назад
❤❤❤
@muhammadshakeel4482
@muhammadshakeel4482 4 года назад
Superb
@ranafaisalrajput3498
@ranafaisalrajput3498 3 года назад
mjhe confusion ha k ap ny cash balance ma formula lgaty hue debit or credit ko uper nechy select kiu kia koi uper ka or koi nechy ka select kr k formula lgaya? kiu?
@savagedemon4268
@savagedemon4268 Год назад
Sir how to write 100,000.00 in excel.....by formula its putting one extra comma after 1 for eg its showing it as 1,00,000.00
@moshirkhan9417
@moshirkhan9417 3 года назад
Mofiz bhai ke awaaz hai
@azahamed1832
@azahamed1832 4 года назад
Sir PDF file Dana sa bohut help hoga
@brijeshkumarsharma3062
@brijeshkumarsharma3062 Год назад
Good
@monisadnan661
@monisadnan661 3 года назад
Destination and tonnage wise automatically freight rate list me pick ho jaye aisa formulation bata dijiye , shukriya
@iNasrullahKhan
@iNasrullahKhan 3 года назад
Me debit credit k item ko barana chahta hoo lekin neeche wali row khud neeche jaati rahe.. matlab final total wali row fixed rehni chahye.
@saleemshafi7275
@saleemshafi7275 2 года назад
i put this formula in sheet but showing false in balance column....please tell what is my mistake
@asfarshorts5023
@asfarshorts5023 Год назад
Debit and credit
@unainabbasi
@unainabbasi 3 года назад
or mre axcell me formula copy to ho rha h lkn value ek hi arhi js cell me formula put kia ho uski chnge nh arhi copy past per
@madniraza6568
@madniraza6568 2 года назад
Agr credit ky ya debit ky 2 cells rkhny hoon
@saimoooo
@saimoooo 2 года назад
You are posting entries just how we post entries in ledger? Not in journal?
@lifeisvlog28
@lifeisvlog28 2 года назад
Sir date k uper formula lag sakta h kya
@ragofficial0133
@ragofficial0133 2 года назад
Op
@wasifsaleemch
@wasifsaleemch 2 года назад
Hello, wonderful tutorial, I would like to download the file but need access. I have sent a access request would you please approve it thank you.
@yuvrajkumbhkar9400
@yuvrajkumbhkar9400 3 года назад
sir same processes krne pr bhi false aa rha h
@mohdintakhab4306
@mohdintakhab4306 2 года назад
Hi sir ye formula ek hi lejar me 2 bar kam kio nhi krrha h =IF(AND bala batana sir
@CreativeCorner3
@CreativeCorner3 Год назад
Need Complete Cargo Inventory Management Sheet.
@smastore-pk
@smastore-pk 3 года назад
As salam o aalaikum bhai ma ne ye formula apply kia start ki entries ma work kar raha hai us k bad #VALUE! show ho raha hai, kindly help aisa ku ho raha hai.
@amnasarwar1949
@amnasarwar1949 Год назад
Agr hmary pas last year ka balance na ho to kia kren
@sheraznawaz6029
@sheraznawaz6029 Год назад
Please tell formula of balance sheet
@raheelasad9025
@raheelasad9025 3 года назад
APPLY YOUR FORMULAS BY PUTTING VALUES IN AL THE INTITIES , WHEN I APPLY YOUR FORMULAS ON MY EXCEL SHEET IT SHOW WRONG FORMULA
Далее
БАТЯ И СОСЕД😂#shorts
00:59
Просмотров 2,2 млн
Top 10 Most Important Excel Formulas - Made Easy!
27:19
Ledger in excel | Bank pass book ledger entry in excel
18:57