IT Help Desk > Use of PC

Microsoft Excel: Learning Tutorial

(1/12) > >>

ashiqbest012:
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.

ashiqbest012:

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

ashiqbest012:

If you want, you can download soft copy.

ashiqbest012:

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.

For your convenience, you can download the soft copy of this post.

Thank you

ashiqbest012:

Solution:

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

You can download the soft copy from the following link