Microsoft Excel: Learning Tutorial

[ashiqbest012]

Functions of Part-19 and part-20

Cell no D9 (Accrued) the function is =3500-C9

N.B. Suppose, I have got in every month about 3500 tk. so, the function start with =3500-c9 . If your get the rent 8000 then type =8000-C9 instead of =3500-c9.

Cellno F9, the function is =3500-E9+D9

Cell no H9 the function is =3500-G9+F9

Cell no J9, the function is =3500-I9+H9

I hope, you understand the consistency of the function.

Cell no C19 (Total) the function is =SUM(C9:C17)
Cell no D20 the function is =SUM(D9:D17)

AE9 no cell the function is =C9+E9+G9+I9+K9+M9+R9+T9+V9+X9+Z9+AB9

AE19 no cell the function is =C19+E19+G19+I19+K19+M19+R19+T19+V19+X19+Z19+AB19

Thank you everybody

[ashiqbest012]

[ashiqbest012]

Red Color indicates the Collection amount and Green color indicates the uncollected amount.

First of all, cell no B7, no shop monthly pays 1200 tk. So, there is no unpaid amount available in January-May. However, in month of June, I collected 1000 tk. instead of 1200. So, there was remaining 200 tk. Every work is automatically done by Ms.Excel.

[ashiqbest012]

Type on the Cell no C7 is =1200-B7

NB. Suppose your rent is 5000 taka. then type on the cell no C7 is =5000-B7

Type on the Cell no C8 is =1200+C7-B8


NB. Suppose your rent is 5000 taka. then type on the cell no C8 is =5000+C7-B8

Accordingly, C9, C10, C11 no cell =1200+C8-B9, =1200+C9-B10, =1200+C10-B11

Let's go for download soft copy

[ashiqbest012]

[ashiqbest012]

Own Capital   .=Total Expense*20% ==C6*20%         
            
Loan Amount   .=Total Expense*80%==C6*80%         
            
Payment   .=pmt(Interst/12,Term*12,-Loan Amount) =PMT(A6/12,B6*12,-E6)   

for soft copy      

[faham]

i will be very grateful to u if u  pls provide the details about power point.

We told you that we will start PowerPoint tutorial very soon.
It will take few more days to start this topic because we are very busy for assignment and reporting writing.
bdw, we will try to start this topic as soon as possible.
Sorry for this delay @Aarif

[ashiqbest012]

Mr. Faham Bhai when will you start the power point tutorial?

[faham]

Mr. Faham Bhai when will you start the power point tutorial?

sorry for my delay...
Finally I can able to start :)
http://forum.daffodilvarsity.edu.bd/index.php/topic,3694.0.html

[ashiqbest012]

ooohh...Finallly, I have recovered all of my pic which I uploaded by Imageshack....Thank you my Creator.

[ashiqbest012]

[ashiqbest012]

[ashiqbest012]

Click here for soft Copy

[Samsul Alam]

Good. Go ahead.

[zahid.eng]

Thank you.