Microsoft Excel: Learning Tutorial

### Author Topic: Microsoft Excel: Learning Tutorial  (Read 15674 times)

#### ashiqbest012

• Hero Member
• Posts: 1186
• I love my University
##### Re: Microsoft Excel: Learning Tutorial
« Reply #45 on: November 29, 2010, 09:19:16 AM »
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
Name: Ashiq Hossain
ID: 121-14-696 & 083-11-558
Daffodil International University
Cell:01674-566806

#### ashiqbest012

• Hero Member
• Posts: 1186
• I love my University
##### Re: Microsoft Excel: Learning Tutorial Part-21
« Reply #46 on: November 30, 2010, 12:14:07 PM »

« Last Edit: July 13, 2011, 08:23:50 AM by ashiqbest012 »
Name: Ashiq Hossain
ID: 121-14-696 & 083-11-558
Daffodil International University
Cell:01674-566806

#### ashiqbest012

• Hero Member
• Posts: 1186
• I love my University
##### Re: Microsoft Excel: Learning Tutorial Part-21
« Reply #47 on: November 30, 2010, 12:19:57 PM »
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.
Name: Ashiq Hossain
ID: 121-14-696 & 083-11-558
Daffodil International University
Cell:01674-566806

#### ashiqbest012

• Hero Member
• Posts: 1186
• I love my University
##### Re: Microsoft Excel: Learning Tutorial Part-21 Function
« Reply #48 on: November 30, 2010, 12:27:30 PM »
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

Name: Ashiq Hossain
ID: 121-14-696 & 083-11-558
Daffodil International University
Cell:01674-566806

#### ashiqbest012

• Hero Member
• Posts: 1186
• I love my University
##### Re: Microsoft Excel: Learning Tutorial Part-22
« Reply #49 on: December 03, 2010, 08:17:28 PM »
« Last Edit: July 13, 2011, 08:24:45 AM by ashiqbest012 »
Name: Ashiq Hossain
ID: 121-14-696 & 083-11-558
Daffodil International University
Cell:01674-566806

#### ashiqbest012

• Hero Member
• Posts: 1186
• I love my University
##### Re: Microsoft Excel: Learning Tutorial
« Reply #50 on: December 03, 2010, 08:26:09 PM »
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
Name: Ashiq Hossain
ID: 121-14-696 & 083-11-558
Daffodil International University
Cell:01674-566806

#### faham

• Full Member
• Posts: 111
• I'm different.... ;)
##### Re: Microsoft Excel: Learning Tutorial
« Reply #51 on: December 06, 2010, 12:36:31 AM »
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
Faham Kabir
MBA (112), HRM & MIS
BBA (073), HRM
Daffodil International University,
.....................
Asst. Manager (HRD & MIS)
New Horizons CLC of Dhaka
http://fb.com/fahamkabir

#### ashiqbest012

• Hero Member
• Posts: 1186
• I love my University
##### Re: Microsoft Excel: Learning Tutorial
« Reply #52 on: January 07, 2011, 05:41:27 PM »
Mr. Faham Bhai when will you start the power point tutorial?
Name: Ashiq Hossain
ID: 121-14-696 & 083-11-558
Daffodil International University
Cell:01674-566806

#### faham

• Full Member
• Posts: 111
• I'm different.... ;)
##### Re: Microsoft Excel: Learning Tutorial
« Reply #53 on: January 18, 2011, 12:17:38 AM »
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
Faham Kabir
MBA (112), HRM & MIS
BBA (073), HRM
Daffodil International University,
.....................
Asst. Manager (HRD & MIS)
New Horizons CLC of Dhaka
http://fb.com/fahamkabir

#### ashiqbest012

• Hero Member
• Posts: 1186
• I love my University
##### Re: Microsoft Excel: Learning Tutorial
« Reply #54 on: March 19, 2011, 09:03:40 AM »
ooohh...Finallly, I have recovered all of my pic which I uploaded by Imageshack....Thank you my Creator.
Name: Ashiq Hossain
ID: 121-14-696 & 083-11-558
Daffodil International University
Cell:01674-566806

#### ashiqbest012

• Hero Member
• Posts: 1186
• I love my University
##### Calculation for market return, Beta, Cost of equity and WACC Part-23
« Reply #55 on: July 14, 2011, 07:55:47 PM »

« Last Edit: July 14, 2011, 08:04:47 PM by ashiqbest012 »
Name: Ashiq Hossain
ID: 121-14-696 & 083-11-558
Daffodil International University
Cell:01674-566806

#### ashiqbest012

• Hero Member
• Posts: 1186
• I love my University
##### Calculation for market return, Beta, Cost of equity and WACC
« Reply #56 on: July 14, 2011, 07:58:59 PM »
Name: Ashiq Hossain
ID: 121-14-696 & 083-11-558
Daffodil International University
Cell:01674-566806

#### ashiqbest012

• Hero Member
• Posts: 1186
• I love my University
##### Calculation for market return, Beta, Cost of equity and WACC
« Reply #57 on: July 14, 2011, 08:19:29 PM »
Name: Ashiq Hossain
ID: 121-14-696 & 083-11-558
Daffodil International University
Cell:01674-566806

#### Samsul Alam

• Full Member
• Posts: 160
• The works that I left will remember me...
##### Re: Microsoft Excel: Learning Tutorial
« Reply #58 on: April 08, 2018, 03:04:35 AM »
Samsul Alam (710001796)
Sr. Lecturer (MIS)