Microsoft Excel: Learning Tutorial

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

#### ashiqbest012

• Hero Member
• Posts: 1186
• I love my University
##### Microsoft Excel: Learning Tutorial
« on: November 01, 2010, 06:25:25 PM »
Part-1

Introduction:
Microsoft Excel is a spreadsheet application written and distributed by Microsoft for Microsoft Windows and Mac OS X. It features calculation, graphing tools, pivot tables and a macro programming language called Visual Basic for Applications. It has been a very widely applied spreadsheet for these platforms, especially since version 5 in 1993. Excel forms part of Microsoft Office. The current versions are 2010 for Windows and 2011 for Mac.

The number of row of Microsoft Excel is 65,536 and the number of column is 256.

MS Excel : Microsoft Excel Is a Great Software for our Life. Personal Accounting, Financial Accounting, Official works, Variety of Calculation can be easily done by MS Excel.
Source:http://forum.daffodilvarsity.edu.bd/index.php/topic,2691.0.html

I have copied the source file from Mr. Rubel sir. Mr. Rubel sir has described about Ms Excel very nicely and his attached file is really very informative. So, you can know from the attached file the basic operation of Excel.

However, I will share with you the different functions of excel.

« Last Edit: November 03, 2010, 11:27: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 Part-2
« Reply #1 on: November 01, 2010, 06:56:44 PM »

All of these are the input value.

(the above function as you can see some "." (dot), when you type the formula,  Please ignore the dot. Otherwise it will not work.

A6, B6, C6, D6, E6, F6, G6, H6 are the output value.

I try to find out the sum in the A, B, C, D and E no column.

Ex: First of all, type the input value like image shown after that put the mouse cursor on the A6 no cell and type the formula like =SUM(A3:A5). You will get the desire value.

N.B: The formula of Sum1 and Sum2 are the same. Both are working. However, always try to use first one. Because it saves your time and more flexible.

As you can see, I try to find our Column no F is average like (4+3+2)/3=3. type the following formula on the cell no F6.
=AVERAGE(F3:F5)

MIN means minimum. Using this formula will find out the minimum value.Such as 3, 6, 4, Here the minimum input value is 3.

MAX means Maximum value. Using this formula will find out the Maximum value. Such as 9, 5, 6, Here the maximum input value is 9
« Last Edit: July 13, 2011, 07:50:07 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-3
« Reply #2 on: November 02, 2010, 05:18:15 PM »

« Last Edit: July 13, 2011, 07:51:40 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-4
« Reply #3 on: November 03, 2010, 11:27:01 AM »

N.B: Avoid dot(.) and use the formula. In any cell you can use these formula.

Total-1   =sum(c4:e4)

Total-2   =sum(c4:c15)

Total           =sum(f4:f15)

Average   =sum(c4:c15)/12

.% of Total    =c16/f16*100

At first input data like the image file. After that write these formula any of the cell in the spreadsheet.

Thank you
« Last Edit: July 13, 2011, 07:53:31 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-5
« Reply #4 on: November 04, 2010, 06:23:11 PM »

Solution:

Find out the 10% of Sales of each employees after that add to Basic salary with it.
Formula is = b7+c7*10%

« Last Edit: July 13, 2011, 07:55:51 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-6
« Reply #5 on: November 14, 2010, 12:58:03 AM »
How to calculate discount and interest rate?

« Last Edit: July 13, 2011, 07:56:55 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-7
« Reply #6 on: November 14, 2010, 11:43:09 AM »

Do you face any problem, just inform me.

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

#### arif_theviper

• Newbie
• Posts: 13
##### Re: Microsoft Excel: Learning Tutorial
« Reply #7 on: November 14, 2010, 02:08:22 PM »
I am regular viewer of this post. Thank you Mr. Ashiq. Keep it up.
Arif Hossain
ID-103-11-1635
Daffodil International University

#### ashiqbest012

• Hero Member
• Posts: 1186
• I love my University
##### Re: Microsoft Excel: Learning Tutorial
« Reply #8 on: November 14, 2010, 02:40:04 PM »
Nice to know about it. Anyway, My next comment on Grade sheet, Result sheet, Best quiz count. I am working for preparing it.

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
« Reply #9 on: November 14, 2010, 02:43:34 PM »
Dear viewer of my this post. In each part, first of all I mention the cell no with the headline after I mention formula. Every formula starts from "=" sign.

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-8
« Reply #10 on: November 15, 2010, 12:39:27 AM »
« Last Edit: July 13, 2011, 08:04:04 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-9
« Reply #11 on: November 15, 2010, 01:00:01 AM »
« Last Edit: July 13, 2011, 08:02:55 AM by ashiqbest012 »
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 #12 on: November 15, 2010, 09:54:26 AM »
Good job Mr.Ashiq, keep it up.
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-10
« Reply #13 on: November 20, 2010, 12:15:51 AM »
« Last Edit: July 13, 2011, 08:01:55 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 #14 on: November 20, 2010, 12:18:01 AM »
Thank you Faham bhai.

Dear Viewers,
If you have any query, you can ask me.

Thank you.
Name: Ashiq Hossain
ID: 121-14-696 & 083-11-558