INTRODUCTION TO MS-EXCEL (KEYPOINT)

INTRODUCTION: 

Excel is an application package that is design to handle numeric data (so many data) .e.g. Taxes, Sales, Payrolls and result etc. in the computer system, so that they could be calculated quickly and with ease.

FEATURES OF EXCEL:

1.      Data can be arrange in rows and columns

2.      Data can be representation in a chart form.

3.      Calculations and analysis of data using the required formulae

IMPORTANCE OF EXCEL:

1.      Engineering: Excel is required for engineering work for the purpose of calculation and structural records:

2.      Business: it is also  required for business settings and for the arrangement of payrolls and saves

3.      Scientific and statistical data analysis: excel is required for scientific calculations and statistics

HOW CAN I OPEN EXCEL?:  opening excel is not different from opening other Microsoft packages such as, ms-word, ms-power point etc. so the same way you open them is the same way you can open excel. I.E ( Click on the START MENU in your system, click on ALL PROGRAMS, from the list of folders that will display, slect MICROSOFT OFFICE, and finally click on MICROSOFT OFFICE EXCEL)

CELL ADDRESS: this is an address which identifies the location of a particular cell in excel

THE title bar, menu bar, quick access tool bar, as well as the office button have been explained above, so no need of talking about them again, but there are features here that we have not come across those are the one we will treat now: these are as follows:

·         Formula bar: the formula  bar is blank and horizontally placed under the quick access tool bar. It displays the contents of an active cell. It is also used to enter formula.

·         Name box: the name box displays the cell address of an active cell ( A1) etc. 

·         Active cell: an active cell is a cell that is currently selected or activated. The active cells are usually bolder than other cells.

·         Cell: a cell is a small division of a worksheet in a rectangular form. The cell is formed when the vertical and the horizontal lines join or intercepts.

·         Horizontal & Vertical Scroll bar you have been notified above.

WORK BOOK: This has to do with the entire work done under a book name. The work book contains the whole files you have in your document now called book here in excel.

WORK SHEET: the worksheet the unit of a work book. E.g. (sheet 1, sheet 2) if you look down in the lower part of your screen you will see then labeled sheet 1 (page 1) sheet2 (page 2) sheet 3 (page 3) so more sheet can be inserted by you if needed.

FORMULA:  these are mathematical expression that are use calculating a new value in excel using an existing value or number.

FUNCTIONS IN EXCEL: functions are expression that performs calculation on data that are installed in a cell or range of cells. Some functions that can be used in excel includes:

-          TOTAL                                  -           (=SUM(b2:i2)

-          MINIMUM                            -           (=MIN(b2:c2)

-          MAXIMUM                          -           (=MAX(b2:c2)

-          STANDARD DEVIATION -           (=STDEV(b2:c2)

-          COUNT                                 -           (=COUNT(b2:c2)

-          LOGARITHM                      -           (=LOG(any figre)

-          AVERAGE                           -           (AVERAGE(b2:b2)

-          SQUARE ROOT                  -           (SQRT(given figure)

-          MULTIPLICATION           -           (*)

-          DIVISION                             -           (/)

-          SUBTRACTION                  -           (-)

-          PERCENTAGE                   -           (%)

-          EXPONENTIAL (CARAT)     -           (^)

-          EQUAL TO                           -           (=) ETC.