Microsoft Excel: Learning Tutorial

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

Offline ashiqbest012

  • Hero Member
  • *****
  • Posts: 1186
  • I love my University
    • View Profile
Re: Microsoft Excel: Learning Tutorial Part-11
« Reply #15 on: November 20, 2010, 10:11:26 AM »
« Last Edit: July 13, 2011, 08:06: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
« Reply #16 on: November 20, 2010, 10:15:33 AM »
First of all type the quiz 1, quiz 2 and quiz 3 field. This sheet will automatically updated. After that type the attendance , Assignment , Presentation etc number. You will get your desire number.

Finally, Total grade point indicates the total grade point (TGP) and Total grade indicates the Total Grade. 
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-12
« Reply #17 on: November 20, 2010, 06:58:17 PM »


« Last Edit: July 13, 2011, 08:08:27 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 #18 on: November 20, 2010, 07:04:52 PM »
G.P.A   =IF(D10>=80,"4",IF(AND(D10<80,D10>=75),"3.75",IF(AND(D10<75,D10>=70),"3.50",IF(AND(D10<70,D10>=65),"3.25",IF(AND(D10<65,D10>=60),"3.00",IF(AND(D10<60,D10>=55),"2.75",IF(AND(D10<55,D10>=50),"2.50","0.00")))))))

Grade
=IF(D10>=80,"A+",IF(AND(D10<80,D10>=75),"A",IF(AND(D10<75,D10>=70),"A-",IF(AND(D10<70,D10>=65),"B+",IF(AND(D10<65,D10>=60),"B",IF(AND(D10<60,D10>=55),"B-",IF(AND(D10<55,D10>=50),"C+","F")))))))

Total Point
=SUM(E10+E11+E12+E13+E14+E15+E16+E17+E18+E19+E20+E21+E22+E23+E24+E25+E26+E27+E28+E29+E30+E31+E32+E33+E34+E35+E40+E41+E42+E43+E44+E45+E46+E47+E48+E54+E55+E56+E57+E58)/COUNT(D10:D58)

Grade
=IF(D10>=80,"A+",IF(AND(D10<80,D10>=75),"A",IF(AND(D10<75,D10>=70),"A-",IF(AND(D10<70,D10>=65),"B+",IF(AND(D10<65,D10>=60),"B",IF(AND(D10<60,D10>=55),"B-",IF(AND(D10<55,D10>=50),"C+","F")))))))
Name: Ashiq Hossain
ID: 121-14-696 & 083-11-558
Faculty of Business & Economics
Daffodil International University
Cell:01674-566806

Offline Aarif

  • Full Member
  • ***
  • Posts: 107
    • View Profile
Re: Microsoft Excel: Learning Tutorial
« Reply #19 on: November 21, 2010, 03:28:41 PM »
thanks for ur valuable posting. i am looking forward more and more.
i will be very grateful to u if u  pls provide the details about power point.

Offline ashiqbest012

  • Hero Member
  • *****
  • Posts: 1186
  • I love my University
    • View Profile
Re: Microsoft Excel: Learning Tutorial
« Reply #20 on: November 21, 2010, 04:52:38 PM »
Thank you Mr. Aarif for your wonderful comment. Yes, I will start the tutorial about MS. Power Point after completing the Ms. Excel. Inshallah. I have to make first all of the post before posting. So, it will be  very difficult to maintain 2 section (Excel and Power point) for me.

Thank you Mr. Aarif.
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 #21 on: November 21, 2010, 05:14:38 PM »
Thank you Mr. Aarif for showing interest on MS Power Point.

I have to make first all of the post before posting. So, it will be  very difficult to maintain 2 section (Excel and Power point) for me.
I can help you. I will start Power point tutorial and continue it. When you will finish your Excel part you can join with us. @Ashiq
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 Part-13
« Reply #22 on: November 21, 2010, 06:15:01 PM »
« Last Edit: July 13, 2011, 08:09:58 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 #23 on: November 21, 2010, 06:23:19 PM »
Formulas:

Level:
=IF(C18>9001,$B$7,IF(AND(C18>7501,C18<=9000),$B$8,IF(AND(C18>6001,C18<=7500),$B$9,IF(AND(C18>4501,C18<=6000),$B$10,IF(AND(C18>3001,C18<=4500),$B$11,IF(AND(C18>2001,C18<=3000),$B$12,IF(C18<=2000,$B$13)))))))

Bonus:
=IF(C18>9001,C18*75%,IF(AND(C18>7501,C18<=9000),C18*70%,IF(AND(C18>6001,C18<=7500),C18*65%,IF(AND(C18>4501,C18<=6000),C18*60%,IF(AND(C18>3001,C18<=4500),C18*55%,IF(AND(C18>2001,C18<=3000),C18*50%,IF(AND(C18>1,C18<=2000),C18*45%)))))))

Total Salary:
=SUM(C18+E18)

N.B: Put all of the function D18, E18, F18 no cells according to the Headline.
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 #24 on: November 21, 2010, 06:28:18 PM »
I can help you. I will start Power point tutorial and continue it. When you will finish your Excel part you can join with us. @Ashiq

It is really good news for us. We will make this forum more effective and fulfill this forum from every side. Inshallah.

We are waiting for viewing your post. It will be helpful for everyone.

Thank You Mr. Faham bhai.
« Last Edit: November 21, 2010, 06:31:22 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-14
« Reply #25 on: November 22, 2010, 10:43:06 PM »


For soft copy Click here
« Last Edit: July 13, 2011, 08:10:49 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 #26 on: November 22, 2010, 11:10:27 PM »
Formula of Weekly Wage

WEEKLY PAY
=sum (Hour Cell Address*Rate Cell Address)        =SUM(B16*C16)

OVERTIME PAY
 =IF(B16>40,(B16-40)*C16*2,0)

GROSS PAY
=Sum(weekly pay cell address + Overtime Pay Cell Address)           =SUM(D16+E16)

TAX
=IF(F16<=2000,F16*$B$6,IF(AND(F16>2001,F16<=3000),F16*$B$7,IF(AND(F16>3001,F16<=4500),F16*$B$8,IF(AND(F16>4501,F16<=6000),F16*$B$9,IF(AND(F16>6001,F16<=7500),F16*$B$10,IF(AND(F16>7501,F16<=9000),F16*$B$11,IF(F16>9001,F16*$B$12)))))))

TOTAL
=sum(Gross Pay Cell Address-Tax Pay Cell Address)         =SUM(F16-G16)

Thank you
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-15
« Reply #27 on: November 23, 2010, 02:52:45 PM »
« Last Edit: November 23, 2010, 03:10:16 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
« Reply #28 on: November 23, 2010, 03:00:08 PM »
Topic name: ::Student Grade Sheet::

Number distribution
Class attendance =7
Quiz                   =10
Assignment         =5
Mid term             =20
Presentation        =5
Lab                     =13
Final                    =40

Total                 =100

(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.

Suppose, the course instructor has taken 4 quiz. So, I have averaged 4 quiz and continue it. 
« Last Edit: November 23, 2010, 03:06:42 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
« Reply #29 on: November 23, 2010, 03:17:41 PM »
Functions of Student Grade Sheet

Quiz
=SUM(D17:G17)/4

Total
=SUM(C17+H17+I17+J17+K17+L17+M17)

Grade-1
=IF(N17>=80,"A+",IF(N17>=75,"A",IF(N17>=70,"A-",IF(N17>=65,"B+",IF(N17>=60,"B",IF(N17>=55,"B-",IF(N17>=50,"C+",IF(N17>=45,"C","Grade-2"))))))))

Grade-2
=IF(N17<=39,"F",IF(N17<=44,"D","N/A"))

G.P.A-1
=IF(N17>=80,"4.00",IF(N17>=75,"3.75",IF(N17>=70,"3.50",IF(N17>=65,"3.25",IF(N17>=60,"3.00",IF(N17>=55,"2.75",IF(N17>=50,"2.5",IF(N17>=45,"2.25","GPA-2"))))))))

G.P.A-2
=IF(N17<=39,"0",IF(N17<=44,"2","N/A"))

Prepared by Ashiq Hossain

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