Author Topic: Microsoft Excel: Learning Tutorial  (Read 9674 times)

Offline ashiqbest012

  • Hero Member
  • *****
  • Posts: 1186
  • I love my University
    • View Profile
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
Faculty of Business & Economics
Daffodil International University
Cell:01674-566806

Offline ashiqbest012

  • Hero Member
  • *****
  • Posts: 1186
  • I love my University
    • View Profile
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
Faculty of Business & Economics
Daffodil International University
Cell:01674-566806

Offline ashiqbest012

  • Hero Member
  • *****
  • Posts: 1186
  • I love my University
    • View Profile
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
Faculty of Business & Economics
Daffodil International University
Cell:01674-566806

Offline ashiqbest012

  • Hero Member
  • *****
  • Posts: 1186
  • I love my University
    • View Profile
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

Let's go for download soft copy
Name: Ashiq Hossain
ID: 121-14-696 & 083-11-558
Faculty of Business & Economics
Daffodil International University
Cell:01674-566806

Offline ashiqbest012

  • Hero Member
  • *****
  • Posts: 1186
  • I love my University
    • View Profile
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
Faculty of Business & Economics
Daffodil International University
Cell:01674-566806

Offline ashiqbest012

  • Hero Member
  • *****
  • Posts: 1186
  • I love my University
    • View Profile
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
Faculty of Business & Economics
Daffodil International University
Cell:01674-566806

Offline faham

  • Full Member
  • ***
  • Posts: 111
  • I'm different.... ;)
    • View Profile
    • FahamBD
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

Offline ashiqbest012

  • Hero Member
  • *****
  • Posts: 1186
  • I love my University
    • View Profile
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
Faculty of Business & Economics
Daffodil International University
Cell:01674-566806

Offline faham

  • Full Member
  • ***
  • Posts: 111
  • I'm different.... ;)
    • View Profile
    • FahamBD
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

Offline ashiqbest012

  • Hero Member
  • *****
  • Posts: 1186
  • I love my University
    • View Profile
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
Faculty of Business & Economics
Daffodil International University
Cell:01674-566806

Offline ashiqbest012

  • Hero Member
  • *****
  • Posts: 1186
  • I love my University
    • View Profile
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
Faculty of Business & Economics
Daffodil International University
Cell:01674-566806

Offline ashiqbest012

  • Hero Member
  • *****
  • Posts: 1186
  • I love my University
    • View Profile
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
Faculty of Business & Economics
Daffodil International University
Cell:01674-566806

Offline ashiqbest012

  • Hero Member
  • *****
  • Posts: 1186
  • I love my University
    • View Profile
Name: Ashiq Hossain
ID: 121-14-696 & 083-11-558
Faculty of Business & Economics
Daffodil International University
Cell:01674-566806