IT Help Desk > Use of PC
Microsoft Excel: Learning Tutorial
ashiqbest012:
Functions:
Balance: Type in Cell no: E10, =Deposit-Withdraw =(C10-D10)
Balance: Type in cell no: E11, =sum(Last Balance E10+ Deposit C11)-Withdraw D11 =SUM(E10+C11)-D11
When you deposit money in your a/c, this deposit amount always plus with your previous balance.
Ex: you deposited yesterday 10000 tk. today you deposited 20000 tk. So, the total amount is 30,000/=tk.
So, I have used the function =SUM(E10+C11)-D11 .
As you can see in your right hand side, Deposit, Withdraw and balance. These reflect the total number of transaction ( Deposit and withdraw). Balance reflects the difference between Deposit and Withdraw.
Function of Deposit : =SUM(C10:C101)
function of Withdraw: =SUM(D10:D101)
Function of Balance: =(H12-I12)
ashiqbest012:
ashiqbest012:
ashiqbest012:
First of all, you can see January, February, March.....December indicates your rent collection amount. and Accrued/green color column reflects your unearned rent/accrued rent.
Lets see cell no C19 & D20, It reflects the total sum of collected money and uncollected money accordingly.
Suppose, Ashiq Cell no C9 monthly pay the rent to me about 3500 tk. As you can see in cell no D9 is 0 because there is no accrued is available. On the other hand, in the month of February, as you can see Ashiq pays 3200 tk. So, accrued amount is 300. It also plus with next month accrued payment. (cell no J9). If any person don't give then it will automatically show you the total accrued in every month.
Suppose, Rifat pays 1550 tk. in every month. Cell no C11, Mr. Rifat didn't pay any money in the month of January. So, the accrued amount is 1550. But he paid in the month of February, He paid 3000 tk. so the accrued amount is 100tk.
ashiqbest012:
Cell no AE9 reflects the Total amount of rent which you have collected and AE19 shows your total income in a year.
Navigation
[0] Message Index
[#] Next page
[*] Previous page
Go to full version