Microsoft Excel: Learning Tutorial

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

#### ashiqbest012

• Hero Member
• Posts: 1186
• I love my University
##### 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
Daffodil International University
Cell:01674-566806

#### ashiqbest012

• Hero Member
• Posts: 1186
• I love my University
##### 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.

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-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
Daffodil International University
Cell:01674-566806

#### ashiqbest012

• Hero Member
• Posts: 1186
• I love my University
##### 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")))))))

=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)

=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
Daffodil International University
Cell:01674-566806

#### Aarif

• Full Member
• Posts: 107
##### 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.

#### ashiqbest012

• Hero Member
• Posts: 1186
• I love my University
##### 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
Daffodil International University
Cell:01674-566806

#### faham

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

#### ashiqbest012

• Hero Member
• Posts: 1186
• I love my University
##### 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
Daffodil International University
Cell:01674-566806

#### ashiqbest012

• Hero Member
• Posts: 1186
• I love my University
##### 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
Daffodil International University
Cell:01674-566806

#### ashiqbest012

• Hero Member
• Posts: 1186
• I love my University
##### 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
Daffodil International University
Cell:01674-566806

#### ashiqbest012

• Hero Member
• Posts: 1186
• I love my University
##### Re: Microsoft Excel: Learning Tutorial Part-14
« Reply #25 on: November 22, 2010, 10:43:06 PM »

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

WEEKLY PAY

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

GROSS PAY

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

Thank you
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-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
Daffodil International University
Cell:01674-566806

#### ashiqbest012

• Hero Member
• Posts: 1186
• I love my University
##### Re: Microsoft Excel: Learning Tutorial
« Reply #28 on: November 23, 2010, 03:00:08 PM »

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
Daffodil International University
Cell:01674-566806

#### ashiqbest012

• Hero Member
• Posts: 1186
• I love my University
##### Re: Microsoft Excel: Learning Tutorial
« Reply #29 on: November 23, 2010, 03:17:41 PM »

Quiz
=SUM(D17:G17)/4

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

=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