Microsoft Excel: Learning Tutorial

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

Offline faham

  • Full Member
  • ***
  • Posts: 111
  • I'm different.... ;)
    • View Profile
    • FahamBD
Re: Microsoft Excel: Learning Tutorial
« Reply #30 on: November 23, 2010, 08:14:38 PM »
(N.B: "IF" function can't be used more than 8 times.)
So, I have created the number of 2 Grade column and the number of 2 GPA column.

"IF" function can't support more than 8 times. It's a problem.
Showing in 2 column and linked 2 column is a great idea :)
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 #31 on: November 23, 2010, 08:22:40 PM »
 ;D ;D ;D ;D ;D ;D ;D ;D

"IF" function can't support more than 8 times. It's a problem.
Showing in 2 column and linked 2 column is a great idea :)

haha...vhai, khaiya daiya amar kam nai. tai notun notun idea bar kori....

Thank you Mr.FAHAM bhai
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 #32 on: November 23, 2010, 08:25:46 PM »
Faham bhai, I have generated a new idea after reading your comment. Than you will see the final grade and gpa in one column. Wait for a moment, , I will share with you after preparing.
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-16
« Reply #33 on: November 23, 2010, 08:32:19 PM »
« Last Edit: July 13, 2011, 08:13:39 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 #34 on: November 23, 2010, 08:33:45 PM »
Formulas
F.Grade
=IF(P17="F","F",IF(P17="D","D",O17))

F.Gpa
=IF(S17="0","0",IF(S17="2","2",R17))
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 #35 on: November 23, 2010, 08:36:26 PM »
Thank you Faham bhai, I have learnt a new formula only for you. If you didn't comment on my post, I would not generate this formula.

« Last Edit: November 24, 2010, 05:24:54 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
Re: Microsoft Excel: Learning Tutorial Part-17
« Reply #36 on: November 24, 2010, 05:37:55 PM »
« Last Edit: July 13, 2011, 08:14:36 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-17
« Reply #37 on: November 24, 2010, 05:42:30 PM »
::Functions of Calculating Depreciation::

Depreciation ( Yearly) =SLN(Cost,Salvage Value, Life Time)

Formula
=SLN(E10,E11,E12)

Depreciation (Monthly) =SLN(Cost,Salvage Value, Life Time)/12

Forumla
=SLN(E10,E11,E12)/12

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-18
« Reply #38 on: November 26, 2010, 11:33:28 AM »
« Last Edit: July 13, 2011, 08:18:59 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-18
« Reply #39 on: November 26, 2010, 11:40:24 AM »
You can maintain in your account at home by using MS excel.

Sometimes, We forget our A/C balance. That time, we cannot say exactly the balance amount. So, if you prepare like this, you can maintain your account status easily.

I have been maintaining my bank a/c information from the beginning of opening my savings account.
« Last Edit: November 26, 2010, 11:52:13 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
Re: Microsoft Excel: Learning Tutorial part-18
« Reply #40 on: November 26, 2010, 11:52:02 AM »
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)
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-19
« Reply #41 on: November 29, 2010, 08:43:16 AM »
« Last Edit: July 13, 2011, 08:20:19 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-20
« Reply #42 on: November 29, 2010, 08:44:02 AM »
« Last Edit: July 13, 2011, 08:20:37 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 19
« Reply #43 on: November 29, 2010, 09:02:56 AM »
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.
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-20
« Reply #44 on: November 29, 2010, 09:06:42 AM »
Cell no AE9 reflects the Total amount of rent which you have collected and AE19 shows your total income in a year.
Name: Ashiq Hossain
ID: 121-14-696 & 083-11-558
Faculty of Business & Economics
Daffodil International University
Cell:01674-566806